-
公开(公告)号：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
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.
-
公开(公告)号：CA2384174A1
公开(公告)日：2003-10-29
申请号：CA2384174
申请日：2002-04-29
Applicant: IBM CANADA
Inventor： ZHU BIAO , PIRAHESH HAMID , SIDLE RICHARD S , LAPIS GEORGE , COCHRANE ROBERTA J , RIELAU SERGE P
Abstract: Records of information are classified for delivery to different targets or destinations even though it is not predictable as to which target a given unit of data (such a s a record) should be routed. Classification allows database updating through an insert command. Generally, it cannot be predicted into which table a given record should be inserted when there a re multiple tables or destinations from which to choose.
-
Search Results
2
records
(took 0.018 seconds)
