System and method for gradually bringing rolled in data online with ...

IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII

US007302441B2

(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.

G06F17/00 (2006.01)

(52) U.S. CI 707/101; 707/102; 707/103 R;

707/104.1

(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

OTHER PUBLICATIONS

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