International Business Machines Corporation

Petrus Kai Chung Chan

Richard Sefton Sidle

Roberta Jo Cochrane

William T O'Connell

Dieu Quang La

Mir Hamid Pirahesh

Calisto Paul Zuzarte

Sam Sampson Lightstone

Bruce Gilbert Lindsay

Michael Jeffrey Winer

Tuong Chanh Truong

Miroslaw Adam Flasza

M Hamid Pirahesh

Data flow in a database statement for a database management system having memory storing a database is simplified. The statement has at least two sequenced subexpressions, evaluation of which is driven by a sequencing operation. A reference to a first sequenced subexpression in a second sequenced subexpression subsequent to the first sequenced subexpression is determined. The reference affirming evaluation of the first sequenced subexpression is determined. A first evaluation order for conflicting table accesses between the first sequenced subexpression and other table accesses in the statement is determined. A second evaluation order between the other table accesses and the determined reference is also determined. The sequencing operation for the first sequenced subexpression is modified based on a sequential arrangement of the determined reference and the first sequenced subexpression according to the first evaluation order and the second evaluation order.

Method, system and program for simplifying data flow in a statement with sequenced subexpressions

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.

System and method for gradually bringing rolled in data online with incremental deferred integrity processing

A system and method for directing a data processing system to incrementally process a base table and a materialized view, wherein the materialized view is associated with the base table, and both are stored in the system, is disclosed. The method includes setting integrity of the base table having an identifier identifying data newly load appended to the base table, and placing the identifier into a location if the location does not contain any other identifier identifying any other data newly load appended to the base table. In a preferred embodiment, the materialized view is incrementally refreshed using the identifier.

Independent deferred incremental refresh of materialized views

The invention provides method and apparatus for use in a database management system for managing a database containing data, where the database has storage for storing data in the database, and has an instruction processor for processing instructions for managing data stored in the database. The database has a constraint manager for managing constraints on said data stored in the database. The invention provides efficient method and means for deferred checking of data after bulk loading into said database for violation of constraints by determining an appropriate procedure for constraint checking by determining whether constraint checking is required; and if it is required, determining whether to implement full, or incremental checking for compliance with said constraints; and then checking the data in the database in accordance with the determined constraint checking procedure.

System and method for selective incremental deferred constraint processing after bulk loading data

Growing community of inventors

Richmond Hill, Canada

Petrus Kai Chung Chan