Invention Grant
- Patent Title: Optimizing relational database queries with multi-table predicate expressions
- Patent Title (中): 使用多表谓词表达式优化关系数据库查询
-
Application No.: US14270419Application Date: 2014-05-06
-
Publication No.: US09411806B2Publication Date: 2016-08-09
- Inventor: Abhinav Goyal , Wenbin Ma , Nattavut Sutyanyong , Calisto P. Zuzarte
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agent David B. Woycechowsky
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
Responding to relational database queries (for example, SQL queries) in a new way. More specifically, qualifying queries are written (for example, written by a human individual) in a way so that a join operation precedes a row limiting operation. Notwithstanding the fact that the join operation precedes the row limiting operation, when responding to the query, machine logic (for example, software) performs the row limiting operation before the join operation. This can improve time and processing efficiency.
Public/Granted literature
- US20150324426A1 OPTIMIZING RELATIONAL DATABASE QUERIES WITH MULTI-TABLE PREDICATE EXPRESSIONS Public/Granted day:2015-11-12
Information query