Independent deferred incremental refresh of materialized views

Data processing: presentation processing of document – operator i – Operator interface – User interactive multicomputer data transfer

Reexamination Certificate

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

C707S793000

Reexamination Certificate

active

10427382

ABSTRACT:
A system and method for directing a data processing system to incrementally process a base table and a materialized view, wherein the materialized view is associated with the base table, and both are stored in the system, is disclosed. The method includes setting integrity of the base table having an identifier identifying data newly load appended to the base table, and placing the identifier into a location if the location does not contain any other identifier identifying any other data newly load appended to the base table. In a preferred embodiment, the materialized view is incrementally refreshed using the identifier.

REFERENCES:
patent: 4631673 (1986-12-01), Haas et al.
patent: 6125360 (2000-09-01), Witkowski et al.
patent: 6134543 (2000-10-01), Witkowski
patent: 6205451 (2001-03-01), Norcott et al.
patent: 6587857 (2003-07-01), Carothers et al.
patent: 7028022 (2006-04-01), Lightstone et al.
patent: 7167853 (2007-01-01), Zaharioudakis et al.
Colby, Latha S. et al., “Algorithms for Deferred View Maintenance,” Sigmod, Jun. 1996, Montreal, Canada, pp. 469-480.
Kulkarni, Uday R. et al., “Independently Updated News,” IEEE Transactions on Knowledge and Data Engineering, vol. 9, No. 5, Sep./Oct. 1997, pp. 796-812.
Mumick, Inderpal, S. et al., “Maintenance of Data Cubes and Summary Tables in a Warehouse,” ACM 1997, pp. 100-111.

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

Independent deferred incremental refresh of materialized views does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Independent deferred incremental refresh of materialized views, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Independent deferred incremental refresh of materialized views will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-3899084

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.