Patent ID: 7359923
Filing Date: 2008-04-15
Classification: G06F,Y10S

Abstract:
1. A method for managing a data warehouse having a table dividable into partitions for containing rows of at least one of rolled-in data and rolled-out data, a metadata element where a data warehouse management system, having operation mechanisms, is operatively coupled to a data processing system having memory for storing the data warehouse, the method allowing for execution of integrity checking of rolled-in data and maintenance of rolled-out data to be deferred and incrementally processed while allowing a general user access to other content of the data warehouse, the method comprising: arranging rolled-in and rolled-out data into partitions; assigning a distinguishable identifier corresponding to each partition; creating a metadata entry, in the metadata element, associated with each identifier, having attributes asserted to signify if rolled-in data and rolled-out data are contained in a corresponding partition respectively; providing for data warehouse management system operations responsive to the attributes, de-asserting the attribute signifying rolled-in data is contained in the corresponding partition after integrity processing is completed for the partition.