Materialized view maintenance and change tracking

Details Materialized view maintenance and change tracking Materialized view maintenance and change tracking

2011-04-19

2011-04-19

Pham, Khanh B (Department: 2166)

Data processing: database and file management or data structures

Database and file access

Query optimization

Reexamination Certificate

active

07930297

ABSTRACT:
A technique for refreshing materialized views in a database is disclosed. The detail table is partitioned, and changes made to the detail table are tracked with information stored, for example. Only sections in the materialized view which correspond to the partitions which include modifications made to the detail table are refreshed, thus avoiding the need of a complete refresh to overcome staleness.

REFERENCES:
patent: 6026390 (2000-02-01), Ross et al.
patent: 6272502 (2001-08-01), Lieuwen et al.
patent: 6366903 (2002-04-01), Agrawal et al.
patent: 6484159 (2002-11-01), Mumick et al.
patent: 6546381 (2003-04-01), Subramanian et al.
patent: 6601073 (2003-07-01), Robare
patent: 6931390 (2005-08-01), Zait et al.
patent: 7111020 (2006-09-01), Gupta et al.
patent: 7139783 (2006-11-01), Hinshaw et al.
patent: 7440963 (2008-10-01), Bello et al.
patent: 2003/0074348 (2003-04-01), Sinclair et al.
patent: 2003/0187864 (2003-10-01), McGoveran
patent: 2004/0122828 (2004-06-01), Sidle et al.
patent: 2004/0133567 (2004-07-01), Witkowski et al.
patent: 2004/0260684 (2004-12-01), Agrawal et al.
patent: 2005/0091180 (2005-04-01), Peleg et al.
patent: 2005/0203933 (2005-09-01), Chaudhuri et al.
patent: 2005/0235001 (2005-10-01), Peleg et al.
Dougherty et al., “sed & awk: Unix Power Tools”, Mar. 1997, O'Reilly Press, 2nd Ed., P. xiii, xiv, xvii,9-10, 15-16, 19, 45 63, 86-87, 204-205, 245, 251, 267.
Gupta et al., “Materialized Views: Techniques , Implementations, and Applications”, Jun. 1999, MIT Press, p. 145-207.
Roussopoulos, et al., “The ADMS Project Views R Us”, Jun. 1995, Bulletin of the Technical Committee on Data Engineering, IEEE Computer Society, p. 19-28.
Hammer, et al., “The Stanford Data Warehousing Project”, Jun. 1995, Bulletin of the Technical Committee on Data Engineering, IEEE Computer Society, p. 40-47.
Zhou, et al., “Supporting Data Integration and Warehousing Using H2O”, Jun. 1995, Bulletin of the Technical Committee on Data Engineering, IEEE Computer Society, p. 29-39.
BMCsoftware, “Loadplus(r) for DB2 Reference Manual: Component of Database Administration for DB2”, Oct. 24, 2003, Version 7.1, 588 pages. <Retrieved from the internet Nov. 23, 2008>.
Oracle, “Oracle9i Data Warehousing Guide Release 1 (9.0.1)”, Dec. 2001, Part No. A90237-01, 21 pages, <Retrieved from www.cs.uvm.edu/oracle9doc/server901/a90237/refresh.htm>.
Blakely et al, “Efficiently Updating Materialized Views”, May 1986, ACM SIGMOD, p. 61-71, <Retrieved from internet Nov. 23, 2008>.
Amiri et al, “A Self-managing Data Cache for Edge-Of-Network Web Applications”, Nov. 2002, ACM CIKM'02, ACM Press, p. 177-185. <Retrieved from web Nov. 28, 2008>.
Segev et al, “Updating Distributed Materialized Views”, Jun. 1989, IEEE Transactions on Knowledge and Data Engineering, p. 173-184. <Retrieved from IEEE Xplore Nov. 27, 2008>.
Chirkova et al, “Materializing Views with Minimal Size to Answer Queries”, Jun. 2003, PODS 2003, ACM Press, p. 38-48. <Retrieved from ACM Nov. 28, 2008>.

Affiliated with

Also associated with

Rating

Materialized view maintenance and change tracking does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Materialized view maintenance and change tracking, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Materialized view maintenance and change tracking will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2722347