Object views for relational data

• US 6,108,664 A
• Filed: 10/31/1997
• Issued: 08/22/2000
• Est. Priority Date: 10/31/1997
• Status: Expired due to Term

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle Corporation
• Inventors: Hong, Chin, Cheng, Tze-Pin, Kooi, deceased, Robert P., Wijaya, Joyo, Nori, Anil
• Primary Examiner(s): Alam, Hosain T.
• Assistant Examiner(s): Colbert, Ella
• Application Number:
  US08/962,415
• Time in Patent Office: 1,026 Days
• Field of Search: 707/103, 707/2, 707/10, 707/101, 707/102, 707/104, 711/203, 345/348
• US Class Current: 1/1
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06F 16/289 Object oriented databases
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• 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
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

A method and apparatus for presenting and modifying data from a set of tables in a database is provided. A view that is defined is based on a set of one or more tables that may include relational tables or object tables. The view defines a presentation of data from the one or more tables as a set of objects that reside in the database. Data is read from the one or more rows of the tables based on the view, and is presented as a set of objects that reside in the database. An object id that is based on data from the one or more rows is generated and associated with each object presented. The view may specify which columns from the one or more tables contain values used to generate the object ids. A trigger may associated with the view. The set of objects presented may be presented as objects having an attribute that is a column object. Column objects include user specified object types, collection objects (e.g. nested tables and variable arrays), or references to objects.

Claims

1. A method for changing content of a set of one or more tables in a database system, the method comprising the steps of:

receiving a request to change the content of the set of one or more tables through a view, wherein said view is defined by database metadata that specifies an association between said view and a trigger, wherein said view is based on the one or more tables; and

executing the trigger in response to said request.

2. The method of claim 1, wherein said trigger, when executed, changes the content of the set of one or more tables.

3. The method of claim 2, wherein:

the method further includes the step of determining whether said request to change the content of the set of one or more tables is a trigger event, the trigger event being an event upon whose occurrence the trigger is invoked; and

the step of executing the trigger is performed if said request to change the content of the set of one or more tables is a trigger event.

4. The method of claim 3, wherein the method further includes the step of changing the content of the set of one or more tables based on a translation of the view if:

said request to change the content of the set of one or more tables is not a trigger event; and

said view is inherently modifiable.

5. The method of claim 1, wherein said view is a presentation of data as a set of objects contained in the database system.

6. The method of claim 5, wherein said view is based on a set of relational tables from the database system.

7. The method of claim 1, wherein the step of receiving data from a user that specifies a trigger includes receiving data that specifies an instead-of trigger.

8. A method for changing content of a set of one or more tables in a database system, the method comprising the steps of:

said database system receiving a request to change the content of the set of one or more tables through a view defined by database metadata;

determining whether a trigger event has occurred;

if a trigger event has occurred, then executing a trigger associated with said view; and

if a trigger event has not occurred, then changing the content based on a translation of the view.

9. The method of claim 8, wherein the step of executing a trigger includes executing an instead-of trigger.

10. The method of claim 8, wherein the step of changing the content based on a translation of the view is performed if said view is inherently modifiable.

11. The method of claim 8, wherein said view is a presentation of data as a set of objects contained in the database system.

12. The method of claim 11, wherein said view is based on a set of relational tables from the database system.

13. A method for presenting data from a set of one or more tables in a database, the method comprising the steps of:

reading data from one or more rows of the set of one or more tables based on an object view that is defined by database metadata and that is based on the set of one or more tables, the object view defining a presentation of data as a set of objects that reside in said database, the set of one or more tables including at least one relational table; and

presenting said data from one or more rows as a set of objects that reside in said database.

14. The method of claim 13, wherein said object view is based on a set of one or more tables that includes at least one object table.

15. The method of claim 13, wherein:

the method further includes the step of creating a new object id based on values from said one or more rows; and

wherein the step of presenting data includes presenting an object from said set of objects as having said object id.

16. The method of claim 15, wherein the step of creating a new object id based on values includes generating an object id based on values from one or more rows of said at least one relational table.

17. The method of claim 15, wherein:

the method further includes the steps of;

receiving a request to define said object view, said request specifying one or more columns of the set of one or more tables containing values used to generate said object id;

in response to receiving the request to define said object view, storing specification data that specifies the one or more columns; and

the step of creating a new object id based on values from said one or more rows includes determining how to generate the object id by inspecting said specification data.

18. The method of claim 17, wherein the step of receiving a request to define an object view includes receiving a request that specifies the one or more columns as including at least one column from said at least one relational table.

19. A database system, comprising:

a set of one or more tables;

said database system configured to define a view based on the set of one or more tables, the view defining a presentation of data from the set of one or more tables;

said database system configured to store database metadata defining said view;

said database system configured to receive data from a user that specifies a trigger to associate with said view;

said database system configured to associate the trigger with the view;

said database system configured to receive a request to change content of the set of one or more tables through the view; and

said database system configured to execute the trigger in response to said request.

20. A database system, comprising:

a set of one or more tables;

said database system configured to store database metadata defining a view;

said database system configured to receive a request to change content of the set of one or more tables through the view;

said database system configured to determine whether a trigger event has occurred;

said database system configured to execute a trigger associated with said view if a trigger event has occurred; and

said database system configured to change the content of the set of one or more tables based on a translation of the view if a trigger event has not occurred.

21. A database system, comprising:

a set of one or more tables that includes at least one relational table;

said database system configured to receive data that defines an object view based on the set of one or more tables, the object view defining a presentation of data as a set of objects that reside in a database;

said database system configured to store database metadata that defines said object view;

said database system receiving a request to change the content of the set of one or more tables through a view defined by database metadata;

determining whether a trigger event has occurred;

if a trigger event has occurred, then executing a trigger associated with said view; and

if a trigger event has not occurred, then changing the content based on a translation of the view.

22. A computer-readable medium carrying one or more sequences of one or more instructions for changing content of a set of one or more tables in a database system, wherein the execution of the one or more sequences of the one or more instructions causes the one or more processors to perform the steps of:

receiving a request to change the content of the set of one or more tables through a view, wherein said view is defined by database metadata that specifies an association between said view and a trigger, wherein said view is based on the one or more tables; and

executing the trigger in response to said request.

23. The computer readable medium of claim 22, wherein said trigger, when executed, changes the content of the set of one or more tables.

24. The computer-readable medium of claim 23, wherein:

the computer-readable medium further includes sequences of instructions for performing the step of determining whether said request to change the content of the set of one or more tables is a trigger event, the trigger event being an event upon whose occurrence the trigger is invoked; and

the step of executing the trigger is performed if said request to change the content of the set of one or more tables is a trigger event.

25. The computer-readable medium of claim 24, wherein the computer-readable medium further includes sequences of instructions for performing the step of changing the content of the set of one or more tables based on a translation of the view if:

said request to change the content of the set of one or more tables is not a trigger event; and

said view is inherently modifiable.

26. The computer readable medium of claim 22, wherein said view is a presentation of data as a set of objects contained in the database system.

27. The computer readable medium of claim 26, wherein said view is based on a set of relational tables from the database system.

28. The computer-readable medium of claim 22, wherein the step of receiving data from a user that specifies a trigger includes receiving data that specifies an instead-of trigger.

29. A computer-readable medium carrying one or more sequences of one or more instructions for changing content of a set of one or more tables in a database system, wherein the execution of the one or more sequences of the one or more instructions causes the one or more processors to perform the steps of:

said database system receiving a request to change the content of the set of one or more tables through a view defined by database metadata;

determining whether a trigger event has occurred;

if a trigger event has occurred, then executing a trigger associated with said view; and

if a trigger event has not occurred, then changing the content based on a translation of the view.

30. The computer readable medium of claim 29, wherein the step of executing a trigger includes executing an instead-of trigger.

31. The computer-readable medium of claim 29, wherein the step of changing the content based on a translation of the view is performed if said view is inherently modifiable.

32. The computer-readable medium of claim 29, wherein said view is a presentation of data as a set of objects contained in the database system.

33. The computer-readable medium of claim 32, wherein said view is based on a set of relational tables from the database system.

34. A computer-readable medium carrying one or more sequences of one or more instructions for presenting data from a set of one or more tables in a database, wherein the execution of the one or more sequences of the one or more instructions causes the one or more processors to perform the steps of:

reading data from one or more rows of the set of one or more tables based on an object view that is defined by database metadata and that is based on the set of one or more tables, the object view defining a presentation of data as a set of objects that reside in said database, the set of one or more tables including at least one relational table; and

presenting said data from one or more rows as a set of objects that reside in said database.

35. The computer readable medium of claim 34, wherein said object view is based on a set of one or more tables that includes at least one object table.

36. The computer-readable medium of claim 34, wherein:

the computer-readable medium further includes sequences of instructions for performing the step of creating a new object id based on values from said one or more rows; and

wherein the step of presenting data includes presenting an object from said set of objects as having said object id.

37. The computer-readable medium of claim 36, wherein the step of creating a new object id based on values includes generating an object id based on values from one or more rows of said at least one relational table.

38. The computer-readable medium of claim 36, wherein:

the computer-readable medium further includes sequences of instructions for performing the steps of;

receiving a request to define said object view, said request specifying one or more columns of the set of one or more tables containing values used to generate said object id;

in response to receiving the request to define said object view, storing specification data that specifies the one or more columns; and

the step of creating a new object id based on values from said one or more rows includes determining how to generate the object id by inspecting said specification data.

39. The computer-readable medium of claim 38, wherein the step of receiving a request to define an object view includes receiving a request that specifies the one or more columns as including at least one column from said at least one relational table.