Data processing: database and file management or data structures – Database and file access – Preparing data for information retrieval
Reexamination Certificate
2006-12-22
2010-11-30
Rones, Charles (Department: 2164)
Data processing: database and file management or data structures
Database and file access
Preparing data for information retrieval
C707S800000
Reexamination Certificate
active
07844608
ABSTRACT:
A device, system, and method are directed towards combining a plurality of queries to a database into a combined execution plan. The plurality of queries is received. The queries may be Structured Query Language (SQL) statements. The database may be a relational database. The plurality of queries is transformed into a plurality of parse trees. A determination is made whether the plurality of queries operates on at least the same portion of the same table. If so, then the plurality of query trees is query-optimized. The plurality of query trees are combined into a master query tree based on similar nodes in the plurality of query trees. A split node in the master query tree represents non-similarities between the plurality of query trees. The master query tree is transformed into an execution plan. The execution plan is applied to a database to return at least one result.
REFERENCES:
patent: 6848078 (2005-01-01), Birsan et al.
patent: 2005/0071349 (2005-03-01), Jordan et al.
patent: 2008/0114803 (2008-05-01), Chinchwadkar et al.
Cao Jonathan
Gates Alan
Natkovich Olga
Frommer & Lawrence & Haug LLP
Ortiz Belix M
Rones Charles
Wiegand Jamie L.
Yahoo ! Inc.
LandOfFree
Clustered query support for a database query engine does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Clustered query support for a database query engine, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Clustered query support for a database query engine will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4245927