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 material
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.
대표청구항▼
What is claimed is: 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 m
What is claimed is: 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.
연구과제 타임라인
LOADING...
LOADING...
LOADING...
LOADING...
LOADING...
이 특허에 인용된 특허 (60)
Blakeley Jose Alfredo ; Thompson Craig W., Apparatus and method for adding an associative query capability to a programming language.
Levy Alon Y. (New Providence NJ) Srivastava Divesh (New Providence NJ), Apparatus and methods for retrieving information by modifying query plan based on description of information sources.
Burnett Colin J. (Sydney AUX) Haas Garry L. (San Jose CA), Computer program product for object specification, generation, and management in a distributed database.
Griffin Timothy G. ; Hull Richard Baxter ; Kumar Bharat ; Lieuwen Daniel Francis ; Zhou Gang, Data architecture for fetch-intensive database applications.
Farber David A. ; Lachman Ronald D., Data processing system using substantially unique identifiers to identify data items, whereby identical data items hav.
Boyer Philip L. ; Carey Michael James ; Kiernan Gerald G., Database method and apparatus for interactively retrieving data members and related members from a collection of data.
Pirahesh Mir Hamid ; Simmen David E. ; Truong Tuong Chanh, Database system and method for supporting current of cursor updates and deletes from a select query from one or more upd.
Cochrane Roberta Jo ; Pirahesh Mir Hamid ; Rielau Serge Philippe,DEX ; Sidle Richard Sefton,CAX ; Urhan Tolga, Intelligent compilation of procedural functions for query processing systems.
Katin Neil (Los Gatos CA) Leventer Ruthellen (Potomac MD) Priyadarshan Eswar (Reading MA) Ruberg Alan (Arlington MA) Shaio Sami (Palo Alto CA), Method and apparatus for deriving object type and obtaining object type attribute values.
Bentson Sheridan (c/o DataView Partners ; 5699 Kanan Rd. ; Suite 253 Agoura CA 91301) Rassman William R. (c/o DataView Partners ; 5699 Kanan Rd. ; Suite 253 Agoura CA 91301), Method and apparatus for displaying and updating structured information.
Norcott William D. ; Ziauddin Mohamed, Method and apparatus for efficiently refreshing sets of summary tables and materialized views in a database management system.
Bhargava Gautam (Cupertino CA) Goel Piyush (Monte Sereno CA) Iyer Balakrishna Ragmavendra (San Jose CA), Method and apparatus for reordering complex SQL queries using a modified generalized outer join operator.
Dar Shaul,ILX ; Jagadish Hosagrahar Visvesvaraya ; Levy Alon Yitzchak ; Srivastava Divesh, Method and system for using materialized views to evaluate queries involving aggregation.
Anand Thulusalamatom Krishnamurthi ; Tucker Peter A. ; Bennett John G. ; Bath Kamaljit S. ; Krishnaswamy Raja, Method of creating a tabular data stream for sending rows of data between client and server.
Hoover Michael K. (Roswell GA) Miller Barrick H. (Marietta GA) Schurenberg Kurt (Roswell GA) Daigle Richard A. (Atlanta GA), Methods and systems for object-based relational distributed databases.
Knudsen Helge (Oakville CAX) Chong Daniel T. (Woodbridge CAX) Yaffe John (Mississauga CAX) Taugher James E. (Mississauga CAX) Robertson Michael (Mississauga CAX) Plazak Zbigniew (Etobicoke CAX), Operating system and data base having an access structure formed by a plurality of tables.
Roberta Jo Cochrane ; George Lapis ; Ting Yu Leung ; Mir Hamid Pirahesh ; Monica Sachiye Urata ; Richard Sefton Sidle ; David E. Simmen ; Calisto Paul Zuzarte CA, Query optimization by transparently altering properties of relational tables using materialized views.
Lieuwen Daniel Francis ; Kawaguchi Akira ; Colby Latha Sankar ; Ross Kenneth A., Refreshing materialized views of a database to maintain consistency with underlying data.
Raitto John ; Ziauddin Mohamed ; Finnerty James, Rewriting a query in terms of a summary based on aggregate computability and canonical format, and when a dimension tabl.
Roberta Jo Cochrane ; James C. Kleewein ; Ting Yu Leung ; Mir Hamid Pirahesh ; Narayana Subramanian ; Shivakumar Venkataraman, Support for summary tables in a heterogeneous database environment.
Latha S. Colby ; Richard L. Cole ; Edward P. Haslam ; Nasi Jazayeri ; Galt Johnson ; William J. McKenna ; David G. Wilhite, Jr., System and method for determining and generating candidate views for a database.
Castelli Vittorio ; Jhingran Anant Deep ; Li Chung-Sheng ; Robinson John Timothy, System and method for generating multi-representations of a data cube.
Bhargava Gautam (Cupertino CA) Goel Piyush (Monte Sereno CA) Iyer Balakrishna R. (San Jose CA), System and method for generating uniqueness information for optimizing an SQL query.
Colby Latha S. ; Cole Richard L. ; Haslam Edward P. ; Jazayeri Nasi ; Johnson Galt ; McKenna William J. ; Schumacher Lee E. ; Wilhite ; Jr. David G., System and method for rewriting relational database queries.
Leung Ting Y. (San Jose CA) Pirahesh Mir H. (San Jose CA) Seshadri Praveen (Madison WI), System for optimizing correlated SQL queries in a relational database using magic decorrelation.
Yang, Liuxi; Surlaker, Kapil; Krishnamurthy, Ravi; Corwin, Michael; Branscome, Jeremy; Meiyyappan, Krishnan; Chamdani, Joseph I., Accessing data in column store database based on hardware compatible data structures.
Folkert, Nathaniel Keith; Gupta, Abhinav; Witkowski, Andrew, Choosing whether to use a delayed index maintenance depending on the portion of the materialized view (MV) changed.
Friedrich, Thomas; Robinson, Alexander Daniel; Setzer, Kathy J., Creating, updating, saving, and propagating customized views of table and grid information.
Friedrich, Thomas; Robinson, Alexander Daniel; Setzer, Kathy J., Creating, updating, saving, and propagating customized views of table and grid information.
Pizzo, Michael J.; Suver, Chris A.; Castro, Pablo; Henry, Alyssa Heather; Conrad, Andrew J.; Muralidhar, Subramanian; Albahari, Benjamin; Blakeley, Jose A., Incremental approach to an object-relational solution.
Deem, Michael E.; Albahari, Benjamin; Nagarajan, Ramesh; Pizzo, Michael J.; Whitten, Arthur T.; Sheppard, Edward G., Storage API for a common data platform.
Stefani, Stefano; Xiao, Wei, Systems and methods for avoiding database anomalies when maintaining constraints and indexes in presence of snapshot isolation.
Folkert, Nathaniel Keith; Gupta, Abhinav; Witkowski, Andrew, Using estimated cost to schedule an order for refreshing a set of materialized views (MVS).
Adya, Atul; Melnik, Sergey; Michailov, Zlatko; Meek, Colin Joseph, View maintenance rules for an update pipeline of an object-relational mapping (ORM) platform.
※ AI-Helper는 부적절한 답변을 할 수 있습니다.