Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2007-01-23
2007-01-23
Wong, Don (Department: 2163)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000
Reexamination Certificate
active
10423407
ABSTRACT:
A block map is associated with a multi-dimensionally clustered (MDC) base table in a database to maintain a “free” or “in use” status for each of the contiguous blocks in the table. Additionally, information may be stored in the block map to indicate whether, after loading data, a given block in the base table requires constraint checking operation or whether, based on changes to the block, a materialized query table dependent upon the table requires a refresh operation. Each time data is loaded into the table, the associated block map is updated. When delayed constraint check or refresh operations are to be performed, the block map is consulted to learn which blocks require the operations. After one of the constraint check or refresh operations is performed, the associated block map is again updated. The block map enables a method to efficiently identify data blocks in a base table, changes to which trigger incremental constraint checking operations and incremental maintenance operations of dependent materialized query tables.
REFERENCES:
patent: 4243984 (1981-01-01), Ackley et al.
patent: 4961134 (1990-10-01), Crus et al.
patent: 5043871 (1991-08-01), Nishigaki et al.
patent: 5982572 (1999-11-01), Dahlerud
patent: 5991754 (1999-11-01), Raitto et al.
patent: 6009201 (1999-12-01), Acharya
patent: 6345272 (2002-02-01), Witkowski et al.
patent: 6438562 (2002-08-01), Gupta et al.
patent: 6591272 (2003-07-01), Williams
patent: 6618719 (2003-09-01), Andrei
patent: 6622168 (2003-09-01), Datta
patent: 2002/0010706 (2002-01-01), Brickell et al.
patent: 2002/0116457 (2002-08-01), Eshleman et al.
Lehner et al., “Fast refresh using mass query optimization”, IEEE, 2001, pp. 391398.
Holst et al., “Incremental table-based method dispatch for reflective object-oriented languages”, Aug. 1997, pp. 1-12.
Chan Petrus K. C.
Malkemus Timothy R.
Padmanabhan Sriram K.
Black Linh
International Business Machines - Corporation
Kassatly Samuel A.
Wong Don
LandOfFree
System and method for identifying and maintaining base table... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with System and method for identifying and maintaining base table..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for identifying and maintaining base table... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3773565