Object-oriented materialized views

• US 7,158,994 B1
• Filed: 12/05/2001
• Issued: 01/02/2007
• Est. Priority Date: 09/28/2001
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Subramaniam, Mahesh, Muralidhar, Subramanian, Smith, Wayne
• Primary Examiner(s): Wong; Don
• Assistant Examiner(s): NGUYEN, MERILYN P
• Application Number:
  US10/006,605
• Time in Patent Office: 1,854 Days
• Field of Search: 707 1- 5, 707100-103, 707200-203, 707/8, 707/10, 717/140
• US Class Current: 707/717
• CPC Class Codes: G06F 16/2393 Updating materialised views
• CPC Class Codes: G06F 16/2445 Data retrieval commands; View definitions
• CPC Class Codes: G06F 16/24539 using cached or materialised query results
• CPC Class Codes: Y10S 707/954 Relational
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure

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.

Claims

1. A computer-implemented method, the method comprising the steps of:

a database management system receiving a request to generate a materialized view that contains objects of an object class;

in response to receiving said request, said database management system creating said materialized view;

said database management system performing operations on said objects as instances of said object class;

wherein said object class defines attributes and one or more routines to invoke to operate on the state of the objects of said object class;

wherein attribute values of an object contained in said materialized view are derived from one or more base tables;

wherein the step of creating said materialized view includes creating a container table, separate from said one or more base tables, that includes corresponding columns that correspond to said attributes and that hold the attribute values of said attributes; and

storing said attribute values of said attributes in said container table.

2. The method of claim 1, wherein the step of creating said materialized view includes the step of creating an object materialized view, wherein said object materialized view is associated with an object class and contains instances of said object class that correspond to rows of said object materialized view.

3. The method of claim 1, wherein the step of creating said materialized view includes creating an object-relational view that includes at least one object column.

4. The method of claim 1, wherein the method further includes the step of receiving another request from a user requesting performance of said operations on said objects as instances of said object class.

5. The method of claim 1, wherein the step of said database management system performing operations includes performing an operation on said objects by invoking a routine defined by said object class.

6. The method of claim 1, further including the step of said database management system generating refresh code that refreshes said materialized view.

7. The method of claim 1, further including the step of generating refresh code that may be executed to fully refresh said materialized view.

8. The method of claim 1, further including the step of generating refresh code that refreshes said materialized view based on modifications to the one or more base tables.

9. The method of claim 8, wherein the step of generating refresh code includes the step of generating refresh code that references said corresponding columns but not as said attributes of said object class.

10. The method of claim 1, wherein said materialized view includes an object column that has a plurality of nested tables that contain nested table objects.

11. The method of claim 10, wherein the step of creating said materialized view includes the step of creating another table that holds attributes of nested table objects of said plurality of nested tables.

12. The method of claim 1, wherein:

a base table of said one or more base tables includes a base column typed as an object reference; and

wherein the step of creating said materialized view includes creating a particular column of said container table that;

corresponds to said base column, and is typed as an object reference.

13. The method of claim 12, wherein:

a first scope of said base column is a first set of tables; and

the particular column has a second scope that is different than said first scope.

14. The method of claim 13, wherein the second scope is another materialized view based on said first set of tables.

15. A computer-readable storage medium storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 1.

16. A computer-readable storage medium storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 2.

17. A computer-readable storage medium storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 3.

18. A computer-readable storage medium storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 4.

19. A computer-readable storage medium storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 5.

20. A computer-readable storage medium storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 6.

21. A computer-readable storage medium storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 7.

22. A computer-readable storage medium storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 8.

23. A computer-readable storage medium storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 9.

24. A computer-readable storage medium storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 10.

25. A computer-readable storage medium storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 11.

26. A computer-readable storage medium storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 12.

27. A computer-readable storage medium storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 13.

28. A computer-readable storage medium storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 14.