Object views for relational data
First Claim
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.
3 Assignments
0 Petitions
Accused Products
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.
-
Citations
39 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. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
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. - View Dependent Claims (9, 10, 11, 12)
-
-
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. - View Dependent Claims (14, 15, 16, 17, 18)
-
-
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. - View Dependent Claims (23, 24, 25, 26, 27, 28)
-
-
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. - View Dependent Claims (30, 31, 32, 33)
-
-
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. - View Dependent Claims (35, 36, 37, 38, 39)
-
Specification