A system and a method maintain a precomputed view (20) corresponding to deta il data in a database server (12) by: determining a maintenance plan to refresh the precomputed view when detail data is changed; integrating the maintenanc e plan with a query execution plan (18) in the database server (12); and executing the query execution plan.
申请公布号
CA2379827(A1)
申请公布日期
2001.01.25
申请号
CA20002379827
申请日期
2000.07.19
申请人
INTERNATIONAL BUSINESS MACHINES CORPORATION
发明人
MULAGUND, GOPAL B.;WILHITE, DAVID G. JR.;MCKENNA, WILLIAM J.;COLBY, LATHA S.;BUNGER, CRAIG;COLE, RICHARD L.;JOHNSON, GALT