Invention Grant
US08548980B2 Accelerating queries based on exact knowledge of specific rows satisfying local conditions
有权
基于满足当地条件的特定行的确切知识来加速查询
- Patent Title: Accelerating queries based on exact knowledge of specific rows satisfying local conditions
- Patent Title (中): 基于满足当地条件的特定行的确切知识来加速查询
-
Application No.: US11966611Application Date: 2007-12-28
-
Publication No.: US08548980B2Publication Date: 2013-10-01
- Inventor: Steven A. Kirk , David E. Walrath
- Applicant: Steven A. Kirk , David E. Walrath
- Applicant Address: US CA Dublin
- Assignee: Sybase Inc.
- Current Assignee: Sybase Inc.
- Current Assignee Address: US CA Dublin
- Agency: Sterne, Kessler, Goldstein & Fox P.L.L.C.
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30
Abstract:
A method, computer program product, and system are provided for accelerating a query in a database system. For example, an embodiment of the method may include generating a data structure identifying a set of rows that satisfy conditions local to a table prior to an evaluation of a query and modifying the query based on the data structure. In addition, the method may include repeating the steps with respect to generating the data structure and modifying the query, if one or more additional local conditions are inferred from modifying the query based on the data structure.
Public/Granted literature
- US20090171921A1 Accelerating Queries Based on Exact Knowledge of Specific Rows Satisfying Local Conditions Public/Granted day:2009-07-02
Information query
