Incremental maintenance of aggregated and join summary tables

Details Incremental maintenance of aggregated and join summary tables Incremental maintenance of aggregated and join summary tables

2006-01-03

2006-01-03

Robinson, Greta (Department: 2167)

Data processing: database and file management or data structures

Database design

Data structure types

Reexamination Certificate

active

06983291

ABSTRACT:
A method, apparatus, and article of manufacture for incrementally maintaining a summary table derived from a plurality of base tables in a database stored on the computer. A plurality of modifications are applied to the base tables, and the applied modifications are then propagated to the summary table. The propagated modifications include an associated tag column containing a tag value, and the tag value indicates per row of the propagated modifications how many rows are to be added to or deleted from the summary table.

REFERENCES:
patent: 5377306 (1994-12-01), Broomhead et al.
patent: 5379422 (1995-01-01), Antoshenkov
patent: 5414839 (1995-05-01), Joshi
patent: 5511116 (1996-04-01), Shastry et al.
patent: 5584024 (1996-12-01), Shwartz
patent: 5590324 (1996-12-01), Leung et al.
patent: 5666526 (1997-09-01), Reiter et al.
patent: 5706495 (1998-01-01), Chadha et al.
patent: 5761657 (1998-06-01), Hoang
patent: 5793968 (1998-08-01), Gregerson et al.
patent: 5812840 (1998-09-01), Shwartz
patent: 5822751 (1998-10-01), Gray et al.
patent: 5835904 (1998-11-01), Vicik et al.
patent: 5870746 (1999-02-01), Knutson et al.
patent: 5890150 (1999-03-01), Ushijima et al.
patent: 5893125 (1999-04-01), Shostak
patent: 5918232 (1999-06-01), Pouschine et al.
patent: 5926819 (1999-07-01), Doo et al.
patent: 6191797 (2001-02-01), Politis
patent: 6192460 (2001-02-01), Goleman et al.
patent: 6289335 (2001-09-01), Downing et al.
patent: 6298342 (2001-10-01), Graefe et al.
patent: 6353828 (2002-03-01), Ganesh et al.
patent: 6353835 (2002-03-01), Lieuwen
patent: 6408163 (2002-06-01), Fik
patent: 6449609 (2002-09-01), Witkowski
“Informix Guide to SQL: Tutorial”, version 9.1, Copyright 1998, Informix Software, Inc., Chapt. 3.
IBM Technical Data Bulletin, “Deriving Production Rules for Incremental View Maintenance”, vol. 35, No. 1A, Jun. 1992, pp 178.
J Bailey et al., “Incremental View Maintenance by Base Relation Tagging in Distributed Databases”, Distributed and Parallel Databases, vol. 6, No. 3, pp. 287-309, (ABSTRACT only).
HA Kuno et al., “Augmented Inherited Multi-index Structure for Maintenance of Materialized Path Query Views”, Proceedings: Sixth International Workshop on Research Issues in Data Engineering. Interoperability of Nontraditional Database Systems, IEEE Computer Soc. Press, 1996, pp. 128-137, (ABSTRACT only).
T. Griffin et al., Incremental Maintenance of Views with Duplicates, SIGMOD Record, vol. 24, No. 2, Jun. 1995, pp. 328-339, (ABSTRACT only).
A. Gupta et al., “Maintaining Views Incrementally”, SIGMOD Record, vol. 22, No. 2, Jun. 1993, 157-166, (ABSTRACT only).

Affiliated with

Also associated with

Rating

Incremental maintenance of aggregated and join summary tables does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Incremental maintenance of aggregated and join summary tables, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Incremental maintenance of aggregated and join summary tables will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3525841