公开(公告)号：CA2414983A1

公开(公告)日：2004-06-23

申请号：CA2414983

申请日：2002-12-23

Applicant: IBM CANADA

Inventor： O'CONNELL WILLIAM T ,  SIDLE RICHARD S ,  COCHRANE ROBERTA JO ,  CHAN PETRUS KAI CHUNG ,  PIRAHESH HAMID MIR ,  LA DIEU QUAN STEVE

IPC: G06F16/11 ,  G06F16/21 ,  G09G5/00 ,  G06F17/30 ,  G06F11/10

Abstract: A system and method for flexible execution in the order of operations for loading data into base tables, for checking the base tables for constraint violations, an d for refreshing the materialized views. The system and method maintains the ability to perform a ny of these operations incrementally. Materialized views may be incrementally refreshed at different points in time independently of one another and independently of the load append operations performed on the base tables. The system and method includes load appending data to on e base table, incrementally refreshing of just one associated materialized view (and makin g the materialized view available immediately thereafter) and deferring refresh of the other materialized views, load appending more data into other base tables, and incrementally refreshing all materialized views with respect to all load append operations. Advantageously, the system and method handles combinations of multiple materialized views associated with a single base table as well as multiple base tables referenced or associated with one materialized view.

公开(公告)号：CA2279119C

公开(公告)日：2004-10-19

申请号：CA2279119

申请日：1999-07-29

Applicant: IBM CANADA

Inventor： MCARTHUR CATHERINE S ,  FLASZA MIROSLAW A ,  LIGHTSTONE SAM S ,  O'CONNELL WILLIAM T

IPC: G06F17/30

Abstract: A computer system for the indexing of data in which a heuristic determinatio n function is applied to predict an efficient index updating approach. The system is able to updat e an index relating to a first data set by incrementally updating the index or by a rebuild of the index at the completion of the addition of a second set of data to the first set of data. The system applies a heuristic determination function to the characteristics of the first set of data, its index, and the second set of data, to predict whether an incremental update or a rebuild update of the index will result in a more efficient rebuild of the data. The system applies this approach to a restore and rollforward recovery or a data load operation to improve the efficiency of these operations.

公开(公告)号：CA2382714A1

公开(公告)日：2003-10-19

申请号：CA2382714

申请日：2002-04-19

Applicant: IBM CANADA

Inventor： VINCENT TIMOTHY J ,  SCHIEFER KLAUS BERNHARD ,  O'CONNELL WILLIAM T ,  LIMOGES JOSEPH SERGE ,  BEGG ROBERT A ,  EVANS DOMINIQUE J

IPC: G06F17/30

Abstract: A method, computer program product and computing device for promoting reuse ofpreviously generated access plans in a relational DBMS are disclosed. SQL statements containing literals are amended so as to substitute a parameter marker for each literal. Amended statements are provided to the DBMS along with parameters comprising the substituted literals and a substitution indicator indicating that the substitution has been performed. The DBMS assesses the soundness of the substitutions that are performed. Soundness may be measured in terms of the semantic correctness of the amended statement and the likelihood that the literal substitution wi ll improve DBMS efficiency. If a substitution is unsound, the DBMS may obtain and optimize (i.e. select an access plan for) the original version of the amended SQL statement. Otherwise, the amended statement is optimized. Advantageously, SQL statements originally differing only in the value of one or more literals may become functionally equivalent, and the reuse of cached, previously generated access plans is thus promoted. Improvements in DBMS efficiency may thus be achieved .

公开(公告)号：CA2359277A1

公开(公告)日：2003-04-18

申请号：CA2359277

申请日：2001-10-18

Applicant: IBM CANADA

Inventor： IGORALWALLA IQBAL A ,  SHARPE DAVID C ,  O'CONNELL WILLIAM T

IPC: G06F17/30

Abstract: The present invention provides a system and a method for materializing recor ds in a result set in response to a query. The computer system comprises a server and a client. The server has a database and a database management system for providing access to the database. The client is operatively coupled to the database management system. The client is adapted to provide a query to the database management system and the database management system is adapted to materialize a number of records in a result set in response to the query. The number of materialized records is selected to reduce inefficient materialization of records from the database in response to the query.

公开(公告)号：CA2279119A1

公开(公告)日：2001-01-29

申请号：CA2279119

申请日：1999-07-29

Applicant: IBM CANADA

Inventor： FLASZA MIROSLAW A ,  MCARTHUR CATHERINE S ,  O'CONNELL WILLIAM T ,  LIGHTSTONE SAM S

IPC: G06F17/30

Abstract: A computer system for the indexing of data in which a heuristic determinatio n function is applied to predict an efficient index updating approach. The system is able to updat e an index relating to a first data set by incrementally updating the index or by a rebuild of the index at the completion of the addition of a second set of data to the first set of data. The system applies a heuristic determination function to the characteristics of the first set of data, its index, and the second set of data, to predict whether an incremental update or a rebuild update of the index will result in a more efficient rebuild of the data. The system applies this approach to a restore and rollforward recovery or a data load operation to improve the efficiency of these operations.