Patent ID: 6460027
Filing Date: 2002-10-01
Classification: G06F,Y10S

Abstract:
A method of optimizing a query in a computer system, the query being performed by the computer system to retrieve data from a database stored on the computer system, the method comprising the steps of:(a) accepting the query into the computer system; (b) incorporating a query definition of one or more summary tables into the query to create a resulting query, wherein the resulting query comprises a first portion and a second portion; (c) determining whether an input to the first portion can be re-routed to an output of the second portion, wherein the second portion comprises a relational operator between a derived table of a group by operation and one or more other tables, and the rows produced by the derived table are filtered by the relational operator; (d) rewriting the query so that the first portion receives its input from an output of the second portion; and (e) executing the rewritten query.