(12) United States Patent
Chan et al.
(io) Patent No.: (45) Date of Patent:
US 7,302,441 B2 Nov. 27, 2007
(73) Assignee: International Business Machines Corporation, Armonk, NY (US)
( * ) Notice: Subject to any disclaimer, the term of this patent is extended or adjusted under 35 U.S.C. 154(b) by 554 days.
(21) Appl. No.: 10/896,154
(22) Filed: Jul. 20, 2004
(65) Prior Publication Data
US 2006/0020605 Al Jan. 26, 2006
(51) Int. CI.
(52) U.S. CI 707/101; 707/102; 707/103 R;
(58) Field of Classification Search 707/1 10,
707/100-104.1, 200-205 See application file for complete search history.
(56) References Cited
U.S. PATENT DOCUMENTS
6,453,314 Bl 9/2002 Chan et al 707/3
6,457,013 Bl 9/2002 Saxton et al 707/101
6,597,809 Bl 7/2003 Ross et al 382/229
6,647,510 Bl 11/2003 Ganesh et al 714/16
6,778,977 Bl * 8/2004 Avadhanam et al 707/2
2001/0047360 Al 11/2001 Huras et al 707/102
2002/0095408 Al 7/2002 Cheng 707/3
2002/0143764 Al 10/2002 Martin et al 707/8
2002/0173911 Al 11/2002 Branet et al 702/1
2003/0208506 Al 11/2003 Greenfield et al 707/102
2003/0212789 Al 11/2003 Hamel et al 709/225
Chen et al., Materialized View Signature and Efficient Identification of Materialized View Candidates for Queries, U.S. Appl. No. 10/324,800, filed Dec. 19, 2003, IBM Docket SVL920030007US1. Nelson, System. Method and Computer Program for Providing a Time Map ofRolled-upData, U.S. Appl. No. 10/392,654, filed Mar. 20, 2003, IBM Docket SVL920030007US1.
* cited by examiner
Primary Examiner—Isaac Woo
(74) Attorney, Agent, or Firm—Sughrue Mion, PLLC
Disclosed is a data processing system, a data processing system-implemented method and an article of manufacture for providing general user availability while integrity processing of rolled-in data is deferred and performed incrementally. The data processing system includes a data warehouse administration module for administering a data warehouse to include a table dividable into portions for containing rows of rolled-in data, a first and a second delimiter delimiting the start and the end respectively of each portion, a metadata element having an entry corresponding to the start and end delimiters delimiting each portion, a third delimiter for delimiting, between the first delimiter and the third delimiter, a sub-portion of the portion, and an operations management module having operation mechanisms for performing operations on the data warehouse responsive to the delimiters.
18 Claims, 5 Drawing Sheets