Invention Grant
- Patent Title: Multi-query optimization
- Patent Title (中): 多查询优化
-
Application No.: US11280827Application Date: 2005-11-15
-
Publication No.: US07966315B2Publication Date: 2011-06-21
- Inventor: Russell Okamoto , Greg Passmore
- Applicant: Russell Okamoto , Greg Passmore
- Applicant Address: US CA Palo Alto
- Assignee: VMware, Inc.
- Current Assignee: VMware, Inc.
- Current Assignee Address: US CA Palo Alto
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30

Abstract:
A database query optimization method is provided for database queries that include predicates, the queries being directed to at least one database table having data in rows and columns. The method includes associating a lineage bit set with each row of the database table, the lineage bit set providing a binary predicate state indication whether each predicate is met or are not met by data in the row. A dependency bit set is established to provide a binary indication of the predicates that are included in each query. Queries are applied against the database table by a logical operation between the lineage bit set and the dependency bit set. A database query optimization data structure includes a lineage bit set associated with each row in the database table. The lineage bit set provides a binary predicate state indication whether each predicate is met or are not met by data in the row. The data structure further includes a dependency bit set that provides a binary indication of the predicates included in each query.
Public/Granted literature
- US20070112736A1 Multi-query optimization Public/Granted day:2007-05-17
Information query