Object-oriented materialized views

Details Object-oriented materialized views Object-oriented materialized views

2007-01-02

2007-01-02

Wong, Don (Department: 2163)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000

Reexamination Certificate

active

10006605

ABSTRACT:
Techniques are provided for creating object-oriented materialized views. The object-oriented materialized views may be object materialized views or object-relational materialized views. The base tables may be object tables, object relational tables, or relational tables. The object-oriented materialized views may be refreshed, fully or incrementally. When an object-oriented materialized view is created, refresh code is generated for it. Through the use of object-oriented materialized views, users gain both the efficiency of materialized views and the power of the object-oriented paradigm.

REFERENCES:
patent: 5261098 (1993-11-01), Katin et al.
patent: 5276870 (1994-01-01), Shan et al.
patent: 5404506 (1995-04-01), Fujisawa et al.
patent: 5418946 (1995-05-01), Mori
patent: 5444842 (1995-08-01), Bentson et al.
patent: 5548755 (1996-08-01), Leung et al.
patent: 5551027 (1996-08-01), Choy et al.
patent: 5560005 (1996-09-01), Hoover et al.
patent: 5581758 (1996-12-01), Burnett et al.
patent: 5584024 (1996-12-01), Shwartz
patent: 5594899 (1997-01-01), Knudsen et al.
patent: 5598559 (1997-01-01), Chaudhuri
patent: 5600831 (1997-02-01), Levy et al.
patent: 5659728 (1997-08-01), Bhargava et al.
patent: 5701455 (1997-12-01), Bhargava et al.
patent: 5724575 (1998-03-01), Hoover et al.
patent: 5729730 (1998-03-01), Wlaschin et al.
patent: 5734884 (1998-03-01), Eberhard et al.
patent: 5765147 (1998-06-01), Mattos et al.
patent: 5774692 (1998-06-01), Boyer et al.
patent: 5778355 (1998-07-01), Boyer et al.
patent: 5812840 (1998-09-01), Shwartz
patent: 5822751 (1998-10-01), Gray et al.
patent: 5826077 (1998-10-01), Blakeley et al.
patent: 5832485 (1998-11-01), Chaudhry
patent: 5848405 (1998-12-01), Norcott
patent: 5873093 (1999-02-01), Williamson et al.
patent: 5875447 (1999-02-01), Goel et al.
patent: 5897632 (1999-04-01), Dar et al.
patent: 5950210 (1999-09-01), Nelson
patent: 5956706 (1999-09-01), Carey et al.
patent: 5960426 (1999-09-01), Pirahesh et al.
patent: 5960427 (1999-09-01), Goel et al.
patent: 5963933 (1999-10-01), Cheng et al.
patent: 5970482 (1999-10-01), Pham et al.
patent: 5974407 (1999-10-01), Sacks
patent: 5974416 (1999-10-01), Anand et al.
patent: 5978788 (1999-11-01), Castelli et al.
patent: 5978791 (1999-11-01), Farber et al.
patent: 5987455 (1999-11-01), Cochrane et al.
patent: 5991754 (1999-11-01), Raitto et al.
patent: 6003022 (1999-12-01), Eberhard et al.
patent: 6006216 (1999-12-01), Griffin et al.
patent: 6023695 (2000-02-01), Osborn et al.
patent: 6026390 (2000-02-01), Ross et al.
patent: 6032144 (2000-02-01), Srivastava et al.
patent: 6088705 (2000-07-01), Lightstone et al.
patent: 6108651 (2000-08-01), Guha
patent: 6125360 (2000-09-01), Witkowski et al.
patent: 6134543 (2000-10-01), Witkowski et al.
patent: 6199063 (2001-03-01), Colby et al.
patent: 6272502 (2001-08-01), Lieuwen et al.
patent: 6334128 (2001-12-01), Norcott et al.
patent: 6339769 (2002-01-01), Cochrane et al.
patent: 6480836 (2002-11-01), Colby et al.
patent: 6484159 (2002-11-01), Mumick et al.
patent: 6496828 (2002-12-01), Cochrane et al.
patent: 6546402 (2003-04-01), Beyer et al.
patent: 6741997 (2004-05-01), Liu et al.
patent: 7007006 (2006-02-01), Zilio et al.
Harumi A. Kuno and Elke A. Rundensteiner (1996), Using Object-Oriented Principles to Optimize Update Propagation to Materizalized Views, pp. 310-317.
Harumi A. Kuno and Elke A Rundersteiner (1998), Incremental Maintenance of Materialized Object-Oriented Views in Multiview: Strategies and Performance Evaluation, pp. 768-792.
Chenho Kung (1990), Object subclass hierarchy in SQL: A Simple Approach, pp. 117-125.
Jixue Liu, Millist Vincent and Mukesh Mohania (1999), Incremental Maintenance of Nested Relational Views, pp. 197-205.
Fawaz s. Al-Anzi and David L. Spooner (1994), Modeling Behavior, a Step Towards Defining Functionally Correct Views of Complex Objects in concurrent Engineering, pp. 1-9.
Vivekanand Gpalkrishnan, Qing Li and Kamalakar Karlapalem (1998), Issues of Object-Relational view Design in Data Warehousing Environment, pp. 1732-2737.
http://www.research.att.com/conf/vldb98/program.html, Mar. 2001.
http://www.research.att.com.conf/vldb98, Mar. 2001.
Bello et al., “Materialized Views in Oracle”, VLDB '98, Proceedings of 24th International Conference on Very Large Data Bases, Aug. 24-27, 1998, New York City, New York, USA, pp. 659-664.
Tanjar et al., “Aggregate-join query processing in parallel database systems”; May 14-17, 2000; High Performance Computing in the Asia-Pacific Region, 2000, Proceedings, The Fourth International Conference/Exhibition on, vol. 2, pp. 824-829.
Proietti et al., “Analysis of range queries and self-spatial join queries on real region datasets stored using an R-tree”; Sep.-Oct., 2000; Knowledge and Data Engineering, IEEE Transaction, vol. 12, Issue 5, pp. 751-762.
Najjar et al., “Cardinality estimation of distributed join queries”; Sep. 1-3, 1999; Database and Expert Systems Applications, 1999, Proceedings, Tenth International Workshop on, pp. 66-70.
Chaudhuri, Surajit et al., “Optimizing Queries with Materialized Views”, Proceedings of the Eleventh International Conference on Data Engineering, Mar. 6-10, 1995, pp. 190-200.
Gopalkrishnan, Vivekanand et al., “Issues of Object-Relational View in Data Warehousing Environment”, 1998 IEEE International Conference on Systems, Man, and Cybernetics, Oct. 11-14, 1998, vol. 3, pp. 2732-2737.
Kuno, Harumi et al., “Augmented Inherited Multi-Index Structure for Maintenance of Materialized Path Query Views”, Proceedings of the Sixth International Conference on Research Issues in Data Engineering, Feb. 26-27, 1996, pp. 128-137.
Segev, Arie et al., “Maintaining Materialized Views in Distributed Databases”, Proceedings of the Fifth International Conference on Data Engineering, Feb. 6-10, 1989, pp. 262-270.
Bhargava, Gautam et al., “Hypergraph based reorderings of outer join queries with complex predicates”, Proceedings of the 1995 ACM SIGMOND International Conference on Management of Data and Symposium on Principles of Database Systems , May 22-25, 1995, AC.
Bhagrava, Gautam et al., “Efficient processing of outer joins and aggregate junctions”, Proceedings of the Twelfth International Conference Data Engineering, 1996., Feb. 26-Mar. 1, 1996, pp. 441-449.
Biggs, Maggie, “Oracle8 still in pole position”, InfoWorld, Framingham; Dec. 15, 1997, vol. 19, Issue 50, p. 1, 97, ISSN: 01996649.
Chen, Arbee, “Outerjoin Optimization in Multidatabase Systems”, Proceedings of the Second International Symposium on Databases in Parallel and Distributed Systems, 1990, Jul. 2-4, 1990, pp. 211-218.
Pang, HweeHwa et al., “Partially Preemptble Hash Joins”, Proceedings of the 1993 ACM SIGMOND international conference on Mangement of data, 1993, pp. 59-68.
Ross, Kenneth et al., “Materialized view maintenance and integrity constraint checking: trading space for time”, Proceedings of the 1996 ACM SIGMOND international conference on Mangement of data, Jun. 3-6, 1996, pp. 447-458.
O'Neil et al., “Multi-Table Joins Through Bitmapped Join Indices”, SIGMOND Record, vol. 24, No. 3, Sep. 1995, pp. 8-11.
Yan, Weipeng et al., “Performing Group-By before Join”, Proceedings of the 10thInternational Conference on Data Engineering, 1994, Feb. 14-18, 1994, pp. 89-100.
Lee, Byung Suk et al., “Outer joins and filters for instantiating objects from relational databases through views”, IEEE Transactions on Knowledge and Data Engineering, Feb. 1994, vol. 6, Issue 1, pp. 108-119.
Lo, Ming-Ling et al., “Spatial Hash-Joins”, Proceedings of the 1996 ACM SIGMOND International Conference on Management of Data, 1996, pp. 247-258.
Marek, Robert et al., “TID Hash Joins”, Proceedings of the third international conference in Information and knowledge management, 1994, No. 2-, Dec. 2, 1994, pp. 42-49.
Mishra, Priti et al., “Join Processing in Relational Data

Affiliated with

Also associated with

Rating

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

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3740400