The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Mar. 28, 2006
Filed:
Dec. 30, 2002
Roberta JO Cochrane, Los Gatos, CA (US);
Themistoklis Palpanas, Toronto, CA;
Mir Hamid Pirahesh, San Jose, CA (US);
Richard Sefton Sidle, Mountain View, CA (US);
Roberta Jo Cochrane, Los Gatos, CA (US);
Themistoklis Palpanas, Toronto, CA;
Mir Hamid Pirahesh, San Jose, CA (US);
Richard Sefton Sidle, Mountain View, CA (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
A system for incrementally maintaining non-distributive aggregate functions in a relational database includes a data storage device in which a relational database is stored. A processor communicates with the data storage device and includes a database maintenance module. The database maintenance module includes a program for incrementally maintaining non-distributive aggregate functions in a relational database. The method embodied in the program includes determining whether all functions in a relational database query are distributive. Based on this determination, a basic propagate phase graph is selectively altered to yield a new propagate phase graph. Changes to an automatic summary table are then applied thereto based on the new propagate phase graph.