View composition in a data base management system

Details View composition in a data base management system View composition in a data base management system

1990-10-09

1994-01-04

Lee, Thomas C.

Boots, shoes, and leggings

364974, 3649746, 364978, 364DIG2, G06F 15403

Patent

active

052768708

ABSTRACT:
In a database management system that operates according to the Structured Query Language standard, a query containing a reference to a view is processed by dynamically materializing the view through execution of the view definition. Once the view is materialized, it is treated as any other base table. To enable a query optimization plan to refer to the materialized view, a view node is introduced into the execution plan. The view node includes a subquery that results in the creation of the virtual table defined by the view. This created table is temporarily stored in a memory. The query optimizer can treat view nodes in the same manner as stored base tables, and thereby overcomes restrictions that were placed upon views by previous view decomposition approaches.

REFERENCES:
patent: 4497039 (1985-01-01), Kitakami et al.
patent: 4506326 (1985-03-01), Shaw et al.
patent: 4631673 (1986-12-01), Haas et al.
patent: 4644471 (1987-02-01), Kojima et al.
patent: 4688195 (1987-08-01), Thompson et al.
patent: 4769772 (1988-09-01), Dwyer
patent: 4791561 (1988-12-01), Huber
patent: 4805099 (1989-02-01), Huber
patent: 4888690 (1989-12-01), Huber
patent: 4918593 (1990-04-01), Huber
patent: 4930071 (1990-05-01), Tou et al.
patent: 5097408 (1992-03-01), Huber
Roussopoulos, Nicholas: "View Indexing in Relational Databases", ACM Transactions on Database Systems, vol. 7, No. 2, Jun. 1982, pp. 258-290.
Rowe et al: "Data Abstraction, Views and Updates in RIGEL", The Ingres Papers: Anatomy of a Relational Database System, Addison-Wesley Publ., 1986, pp. 278-294.
Dayal et al. "On the Updatability of Relational Views", Proceedings of 4th Internatinoal Conf. on Very Large Databases, Sep. 1978, pp. 368-377.
K. C. Kinsley et al.: "A Generalized Method for Maintaining Views", AFIPS Conference Las Vegas, Nevada, Jul. 9-12, 1984, pp. 587-593.
S. Talbot: "An Investigation into Logical Optimization of Relational Query Languages" The Computer Journal, vol. 27, No. 4, No. 1984, pp. 301-309.
S. Hanara et al: "Conversational Database Query Language", Review of the Electrical Communication Laboratories, vol. 29, Nos. 1-2, Jan./Feb. 1981, pp. 32-50.
C. J. Date: "An Introduction to Data Base Systems", 3rd Edition, Section 9, The External Level of System R, Nov. 1974, pp. 159-168.

Affiliated with

Also associated with

Rating

View composition in a data base management system does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with View composition in a data base management system, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and View composition in a data base management system will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-315697