Database system with methodology for generating bushy nested loop join trees
US7882100B2 · kind B2 · utility
36Cited by
21References
52Claims
0Family size
Assignee
Inventor
Key dates
| Filing date | Jan 24, 2005 |
| Grant date | Feb 1, 2011 |
| Priority date | — |
| Expiry date | Dec 3, 2029 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24544
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A database system with methodology for generating bushy nested loop join trees is described. In one embodiment, for example, an improved method is described for optimization of a query requesting data from a database, the method comprises steps of: generating a left deep operator tree for returning data requested by the query based on traversing a left deep operator tree search space; transforming the left deep operator tree into a semantically correct structure for returning data requested by the query; and building a query execution plan for returning data requested by the query based on the semantically correct structure.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.