Deferred incremental integrity maintenance of base tables...

Details Deferred incremental integrity maintenance of base tables... Deferred incremental integrity maintenance of base tables...

G - Physics

06

F

G06F 17/30 (2006.01)

Patent

CA 2414980

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.

Affiliated with

Also associated with

Rating

Deferred incremental integrity maintenance of base tables... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Deferred incremental integrity maintenance of base tables..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Deferred incremental integrity maintenance of base tables... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFCA-PAI-O-1906568