Materialized view system and method

Details Materialized view system and method Materialized view system and method

2006-11-21

2006-11-21

Cottingham, John R. (Department: 2167)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

07139783

ABSTRACT:
Described herein is a system for creating and maintaining materialized views. The maintenance of the materialized views is performed in a distributed manner that improves efficiency and performance in response to the queries for materialized views or views on top of the materialized views.

REFERENCES:
patent: 5842207 (1998-11-01), Fujiwara et al.
patent: 6308284 (2001-10-01), LeCrone et al.
patent: 6745207 (2004-06-01), Reuter et al.
patent: 2002/0040413 (2002-04-01), Okada et al.
patent: 2003/0126143 (2003-07-01), Roussopoulos et al.
patent: 2004/0128289 (2004-07-01), Cochrane et al.
Oracle9iAS Clickstream Intelligence Administrator's Guide, Release 2 (9.0.2), May 2002, Oracle®.
Storage Networking Virtualization, What's it all about? Dec. 2000, IBM.
Oracle8i™ for Data Warehousing, Features Overview, Feb. 1999, Oracle®.
Hutchinson, D.A., “Parallel Algorithms in External Memory,” Ph.D. thesis, Carleton University, Ottawa, Canada, ©1999, 2000, David Alexander Hutchinson, abstract (http://www.cs.duke.edu/˜hutchins/abstract—thesis.html) and notes (6 pp.).
Gupta, A. and I.S. Mumich, “Maintenance of Materialized Views: Problems, Techniques, and Applications,”Bulletin of the Technical. Committee on Data Engineering, 18(2)m IEEE Computer Society, 3-18 (1995).
Roussopoulos, N. et al., “The ADMS Project: Views “img id="CUSTOM-CHARACTER-00001" he="3.13mm" wi="2.46mm" file="US07139783-20061121-P00001.TIF" alt="custom character" img-content="character" img-format="tif" ?” Us,”Bulletin of the Technical. Committee on Data Engineering, 18(2), IEEE Computer Society, 19-28 (1995).
Zhou, G. et al., “Data Integration and Warehousing Using H20,”Bulletin of the Technical. Committee on Data Engineering, 18(2), IEEE Computer Society, 29-39 (1995).
Hammer, J. et al., “The Stanford Data Warehousing Project,”Bulletin of the Technical. Committee on Data Engineering, 18(2), IEEE Computer Society, 40-47 (1995).
Yang, J., et al., “Algorithms for Materialized View Design in Data Warehousing Environment,”VLDB '97, Proceedings of 23rd International Conference on Very Large Databases, Aug. 25-29, 1997, Athens, Greece (pp. 136-145 [1-26]).
Blakeley, J.A., et al., “Efficiently Updating Materialized Views,”ACM SIGMOD Record 15(2):61-71 (Jun. 1986).
Abiteboul, S, et al., Incremental Maintenance for Materialized Views over Semistructured Data,VLDB '98, Proceedings of 24th International Conference on Very Large Databases,Aug. 24-27, 1998, New York, NY (pp. 38-49) [1-24]).
“Data Warehousing and Very Large Databases (VLDB),” Getting to Know ORACLE8/, 2-22—2-26.
Stanchev, OL., “Semantic Data Control in Distributed Database Environment,” Survey Paper for CS748T Distributed Database Management, University of Waterloo, 1-25 (2001).
“Survey for Update Propagation in Piazza,” http://www.cs.washington.edu/homes/lunadong/courses/544Project—survey.pdf , downloaded Jan. 12, 2005 (4 pp.).
Robert Ramey Software Development, “The Postman's Sort,” originally appeared in C User's Journal, 1992 [retrieved Feb. 28, 2003], Retrieved from the Internet <URL: http://www.rrsd.com/psort/cuj/cuj.htm>.
“The ACID Model,” [online] [retrieved Feb. 28, 2003], Retrieved from the Internet <URL: http://databases.about.com/library/weekly/aa120102a.htm>.

Affiliated with

Also associated with

Rating

Materialized view system and method 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 system and method, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Materialized view system and method will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3692666