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:
Oct. 30, 2007
Filed:
Apr. 29, 2003
Richard S. Sidle, Mountain View, CA (US);
Dieu Q. LA, Markham, CA;
Petrus Kai Chung Chan, Richmond Hill, CA;
Roberta J. Cochrane, Los Gatos, CA (US);
William T. O'connell, Etobicoke, CA;
M. Hamid. Pirahesh, San Jose, CA (US);
Richard S. Sidle, Mountain View, CA (US);
Dieu Q. La, Markham, CA;
Petrus Kai Chung Chan, Richmond Hill, CA;
Roberta J. Cochrane, Los Gatos, CA (US);
William T. O'Connell, Etobicoke, CA;
M. Hamid. Pirahesh, San Jose, CA (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
A system and method for directing a data processing system to incrementally process a base table and a materialized view, wherein the materialized view is associated with the base table, and both are stored in the system, is disclosed. The method includes setting integrity of the base table having an identifier identifying data newly load appended to the base table, and placing the identifier into a location if the location does not contain any other identifier identifying any other data newly load appended to the base table. In a preferred embodiment, the materialized view is incrementally refreshed using the identifier.