发明名称 |
System and method for incrementally maintaining non-distributive aggregate functions in a relational database |
摘要 |
A system for incrementally maintaining non-distributive aggregate functions in a relational database includes a data storage device in which a relational database is stored. A processor communicates with the data storage device and includes a database maintenance module. The database maintenance module includes a program for incrementally maintaining non-distributive aggregate functions in a relational database. The method embodied in the program includes determining whether all functions in a relational database query are distributive. Based on this determination, a basic propagate phase graph is selectively altered to yield a new propagate phase graph. Changes to an automatic summary table are then applied thereto based on the new propagate phase graph.
|
申请公布号 |
US2004128289(A1) |
申请公布日期 |
2004.07.01 |
申请号 |
US20020335376 |
申请日期 |
2002.12.30 |
申请人 |
COCHRANE ROBERTA JO;PALPANAS THEMISTOKLIS;PIRAHESH MIR HAMID;SIDLE RICHARD SEFTON |
发明人 |
COCHRANE ROBERTA JO;PALPANAS THEMISTOKLIS;PIRAHESH MIR HAMID;SIDLE RICHARD SEFTON |
分类号 |
G06F17/30;(IPC1-7):G06F17/30 |
主分类号 |
G06F17/30 |
代理机构 |
|
代理人 |
|
主权项 |
|
地址 |
|