US6134558A
Expired / Lapsed
US
⏱️ 0.0 years remaining
References that indicate where global database objects reside
Assignee: Oracle International Corp
•
Filing: 1997-10-31
•
Granted: 2000-10-17
•
Expires: 2017-10-31
Abstract
Abstract A method and apparatus for generating references to a set of objects which reside in a plurality databases is described. Each object is associated with a table from a plurality of tables that are contained in the plurality of databases. An object id is associated with each object; the object id uniquely identifies the object relative to the objects in the set of objects. A table id is associated with each table; the table id uniquely identifies the table relative to tables in the plurality of tables. A table containing an object is located based on the table id associated with the table, and the object is located in the table based on the object id associated with the object. A table mapping is generated. The table mapping maps a set of tables to databases associated with the set of tables. The set of tables are from the plurality of tables. References to objects from the set of object are generated. Each reference comprises data that identifies an object. The reference contains data representing the object id of the referenced object, the object referred to by the reference. The reference also contains data representing the table id of the table containing the referenced object. An object is located based on the table mapping and the reference referring to the object. The table containing the object is located based on the data in the reference, the data representing the table id associated with the table containing the object.
Inventors
- 👤 Chin-Heng Hong
- 👤 Sudheer Thakur
- 👤 Anil Nori
- 👤 Joyo Wijaya
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-05 23:50
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/28; G06F16/284; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933; Y10S707/99941; Y10S707/99942; Y10S707/99943; Y10S707/99944
Claims Analysis
Total Claims: 52
Claim 1
Independent Claim
149 words
In a computer system, a method of locating an object that belongs to a set of objects that reside in a plurality of databases, the method comprising the steps of: associating an object id with each object from said set of objects, wherein each object from said set of objects is contained in a table from a plurality of tables, wherein said plurality of tables are from said plurality of databases; associating a table id with each table of said plurality of tables; wherein the table id associated with each of said plurality of tables is not assigned to any other table in any of said plurality of databases; locating a table that contains said object based on the table id that is associated with the table that contains the object; and locating said object within said table based on the object id that is associated with said object.
Claim 2
Dependent Claim
149 words
In a computer system, a method of locating an object that belongs to a set of objects that reside in a plurality of databases, the method comprising the steps of: associating an object id with each object from said set of objects, wherein each object from said set of objects is contained in a table from a plurality of tables, wherein said plurality of tables are from said plurality of databases; associating a table id with each table of said plurality of tables; wherein the table id associated with each of said plurality of tables is not assigned to any other table in any of said plurality of databases; locating a table that contains said object based on the table id that is associated with the table that contains the object; and locating said object within said table based on the object id that is associated with said object.
Claim 3
Dependent Claim
44 words
The method of claim 1, further comprising the step of generating a table mapping, wherein the table mapping maps a mapped set of tables to databases associated with said mapped set of tables, wherein said mapped set of tables includes said plurality of tables.
Claim 4
Dependent Claim
41 words
The method of claim 2, further comprising the step of generating references referring to objects that belong to said set of objects, each reference comprising data identifying a referenced object, the referenced object being an object from said set of objects.
Claim 5
Dependent Claim
38 words
The method of claim 3, wherein the step of generating references includes generating references that contain: data representing the object id of the referenced object; and data representing the table id of the table containing the referenced object.
Claim 6
Dependent Claim
32 words
The method of claim 4, wherein the step of generating references includes generating references that contain data representing a row-id, the row-id being associated with the table that contains the referenced object.
Claim 7
Dependent Claim
61 words
The method of claim 5, wherein: the step of locating the object includes the steps of: locating the object based on the table mapping and a particular reference referring to the object, wherein the particular reference contains data representing a particular row-id associated with the table; and accessing the object in the table based on the data representing the particular row-id.
Claim 8
Dependent Claim
40 words
The method of claim 6, wherein: the particular row-id specifies a specified entry in the table; and the step of accessing the object includes the step of determining whether an object id associated with the specified entry identifies the object.
Claim 9
Dependent Claim
25 words
The method of claim 5, wherein the step of generating references includes generating references that contain data representing whether the particular reference contains any row-id.
Claim 10
Dependent Claim
41 words
The method of claim 4, wherein: the data representing the object id of the referenced object has a size; and the step of generating references includes generating data representing the size of data representing the object id of the referenced object.
Claim 11
Dependent Claim
32 words
The method of claim 3, wherein the step of locating said object includes the step of locating said object based on the table mapping and a particular reference referring to said object.
Claim 12
Dependent Claim
47 words
The method of claim 10, wherein: the particular reference contains data representing the table id associated with the table; and the step of locating the table includes determining the particular database associated with the table based on the data representing the table id associated with the table.
Claim 13
Dependent Claim
37 words
The method of claim 3, wherein: each reference has a reference size; the references sizes of references is variable; and the step of generating references includes generating references that contain data representing the size of the reference.
Claim 14
Dependent Claim
38 words
The method of claim 3, wherein the step of associating an object id with each object includes the step of associating at least one of said objects from the set of objects with a user specified object id.
Claim 15
Dependent Claim
49 words
The method of claim 3, further including the steps of: receiving from a foreign database a reference to an object contained in a foreign table, the foreign table belonging to the foreign database; and adding to the table mapping a mapping of the foreign table to the foreign database.
Claim 16
Dependent Claim
39 words
The method of claim 1, wherein the step of associating an object id with each object includes associating an object id that is unique relative to all other object ids that are assigned using the same id assignment mechanism.
Claim 17
Dependent Claim
36 words
The method of claim 1, wherein the step of associating a table id includes associating a table id that is unique relative to all other table ids that are assigned using the same id assignment mechanism.
Claim 18
Dependent Claim
84 words
In a computer system, a method of accessing an object that belongs to a set of objects that reside in a set of one or more databases, the method comprising the steps of: receiving a reference to the object, wherein each object from the set of objects is contained in a table from a plurality of tables; reading a table identifier from the reference; locating a table associated with the table identifier; and accessing the object from the table associated with the table identifier.
Claim 19
Dependent Claim
84 words
In a computer system, a method of accessing an object that belongs to a set of objects that reside in a set of one or more databases, the method comprising the steps of: receiving a reference to the object, wherein each object from the set of objects is contained in a table from a plurality of tables; reading a table identifier from the reference; locating a table associated with the table identifier; and accessing the object from the table associated with the table identifier.
Claim 20
Dependent Claim
44 words
The method of claim 17, wherein the step of locating a table associated with a table identifier includes locating a table associated with a table identifier that is unique relative to all other table identifiers that are assigned using the same id assignment mechanism.
Claim 21
Dependent Claim
110 words
In a computer system, a method of accessing an object that belongs to a set of objects that reside in a set of one or more databases, the method comprising the steps of: receiving a reference to the object that has a first object identifier; reading a row-id from the reference; reading a second object identifier from a row that resides at a location identified by the row-id; if the second object identifier matches said first object identifier, then accessing the object from said row; and if the second object identifier does not match said first object identifier, then locating the object in another row using the first object identifier.
Claim 22
Dependent Claim
110 words
In a computer system, a method of accessing an object that belongs to a set of objects that reside in a set of one or more databases, the method comprising the steps of: receiving a reference to the object that has a first object identifier; reading a row-id from the reference; reading a second object identifier from a row that resides at a location identified by the row-id; if the second object identifier matches said first object identifier, then accessing the object from said row; and if the second object identifier does not match said first object identifier, then locating the object in another row using the first object identifier.
Claim 23
Dependent Claim
54 words
The method of claim 19, wherein: the method further includes the step of extracting a table identifier from the object identifier; and the step of locating said object in another row using the object identifier includes finding a row in said table that specifies a third object identifier that matches said first object identifier.
Claim 24
Dependent Claim
176 words
A computer-readable medium carrying one or more sequences of one or more instructions for locating an object that belongs to a set of objects that reside in a plurality of databases, 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: associating an object id with each object from the set of objects, wherein each object from said set of objects is contained in a table from a plurality of tables, wherein said plurality of tables are from the plurality of databases; associating a table id with each table of said plurality of tables; wherein the table id associated with each of said plurality of tables is not assigned to any other table in any of said plurality of databases; locating a table that contains said object based on the table id that is associated with the table that contains the object; and locating said object within said table based on the object id that is associated with said object.
Claim 25
Dependent Claim
176 words
A computer-readable medium carrying one or more sequences of one or more instructions for locating an object that belongs to a set of objects that reside in a plurality of databases, 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: associating an object id with each object from the set of objects, wherein each object from said set of objects is contained in a table from a plurality of tables, wherein said plurality of tables are from the plurality of databases; associating a table id with each table of said plurality of tables; wherein the table id associated with each of said plurality of tables is not assigned to any other table in any of said plurality of databases; locating a table that contains said object based on the table id that is associated with the table that contains the object; and locating said object within said table based on the object id that is associated with said object.
Claim 26
Dependent Claim
51 words
The computer readable medium of claim 21, further carrying sequences of instructions for performing the step of generating a table mapping, wherein the table mapping maps a mapped set of tables to databases associated with said mapped set of tables, wherein said mapped set of tables includes said plurality of tables.
Claim 27
Dependent Claim
48 words
The computer readable medium of claim 22, further carrying sequences of instructions for performing the step of generating references referring to objects that belong to said set of objects, each reference comprising data identifying a referenced object, the referenced object being an object from said set of objects.
Claim 28
Dependent Claim
40 words
The computer readable medium of claim 23, wherein the step of generating references includes generating references that contain: data representing the object id of the referenced object; and data representing the table id of the table containing the referenced object.
Claim 29
Dependent Claim
34 words
The computer readable medium of claim 24, wherein the step of generating references includes generating references that contain data representing a row-id, the row-id being associated with the table that contains the referenced object.
Claim 30
Dependent Claim
63 words
The computer readable medium of claim 25, wherein: the step of locating the object includes the steps of: locating the object based on the table mapping and a particular reference referring to the object, wherein the particular reference contains data representing a particular row-id associated with the table; and accessing the object in the table based on the data representing the particular row-id.
Claim 31
Dependent Claim
42 words
The computer readable medium of claim 26, wherein: the particular row-id specifies a specified entry in the table; and the step of accessing the object includes the step of determining whether an object id associated with the specified entry identifies the object.
Claim 32
Dependent Claim
27 words
The computer readable medium of claim 25, wherein the step of generating references includes generating references that contain data representing whether the particular reference contains any row-id.
Claim 33
Dependent Claim
43 words
The computer readable medium of claim 24, wherein: the data representing the object id of the referenced object has a size; and the step of generating references includes generating data representing the size of data representing the object id of the referenced object.
Claim 34
Dependent Claim
34 words
The computer readable medium of claim 23, wherein the step of locating said object includes the step of locating said object based on the table mapping and a particular reference referring to said object.
Claim 35
Dependent Claim
49 words
The computer readable medium of claim 30, wherein: the particular reference contains data representing the table id associated with the table; and the step of locating the table includes determining the particular database associated with the table based on the data representing the table id associated with the table.
Claim 36
Dependent Claim
39 words
The computer readable medium of claim 23, wherein: each reference has a reference size; the references sizes of references is variable; and the step of generating references includes generating references that contain data representing the size of the reference.
Claim 37
Dependent Claim
40 words
The computer readable medium of claim 23, wherein the step of associating an object id with each object includes the step of associating at least one of said objects from the set of objects with a user specified object id.
Claim 38
Dependent Claim
56 words
The computer readable medium of claim 23, further carrying sequences of instructions for performing the steps of: receiving from a foreign database a reference to an object contained in a foreign table, the foreign table belonging to the foreign database; and adding to the table mapping a mapping of the foreign table to the foreign database.
Claim 39
Dependent Claim
41 words
The computer readable medium of claim 21, wherein the step of associating an object id with each object includes associating an object id that is unique relative to all other object ids that are assigned using the same id assignment mechanism.
Claim 40
Dependent Claim
38 words
The computer readable medium of claim 21, wherein the step of associating a table id includes associating a table id that is unique relative to all other table ids that are assigned using the same id assignment mechanism.
Claim 41
Dependent Claim
111 words
A computer-readable medium carrying one or more sequences of one or more instructions for accessing an object that belongs to a set of objects that reside in a set of one or more databases, 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 reference to the object, wherein each object from said set of objects is contained in a table from a plurality of tables; reading a table identifier from the reference; locating a table associated with the table identifier; and accessing the object from the table associated with the table identifier.
Claim 42
Dependent Claim
111 words
A computer-readable medium carrying one or more sequences of one or more instructions for accessing an object that belongs to a set of objects that reside in a set of one or more databases, 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 reference to the object, wherein each object from said set of objects is contained in a table from a plurality of tables; reading a table identifier from the reference; locating a table associated with the table identifier; and accessing the object from the table associated with the table identifier.
Claim 43
Dependent Claim
45 words
The computer-readable medium of claim 37, wherein the step of locating a table associated with a table identifier includes locating a table associated with a table identifier that is unique relative to all other table identifiers that are assigned using the same id assignment mechanism.
Claim 44
Dependent Claim
137 words
A computer-readable medium carrying one or more sequences of one or more instructions for accessing an object that belongs to a set of objects that reside in a set of one or more databases, 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 reference to the object that has a first object identifier; reading a row-id from the reference; reading a second object identifier from a row that resides at a location identified by the row-id; if the second object identifier matches said first object identifier, then accessing the object from said row; and if the second object identifier does not match said first object identifier, then locating the object in another row using the first object identifier.
Claim 45
Dependent Claim
137 words
A computer-readable medium carrying one or more sequences of one or more instructions for accessing an object that belongs to a set of objects that reside in a set of one or more databases, 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 reference to the object that has a first object identifier; reading a row-id from the reference; reading a second object identifier from a row that resides at a location identified by the row-id; if the second object identifier matches said first object identifier, then accessing the object from said row; and if the second object identifier does not match said first object identifier, then locating the object in another row using the first object identifier.
Claim 46
Dependent Claim
61 words
The computer-readable media of claim 39, wherein: the computer-readable media further including sequences of instructions for performing the step of extracting a table identifier from the object identifier; and the step of locating said object in another row using the object identifier includes finding a row in said table that specifies a third object identifier that matches said first object identifier.
Claim 47
Dependent Claim
162 words
A computer system comprising: a processor; a memory coupled to said processor; a plurality of databases; a set of objects that reside in said plurality of databases; a set of tables that reside in said plurality of databases, wherein each object from said set of objects is contained in a table from said plurality of tables; said processor configured to associate an object id with each object from said set of objects; said processor configured to associate a table id with each table of said plurality of tables; wherein the table id associated with each of said plurality of tables is not assigned to any other table in any of said plurality of databases; said processor configured to locate a table that contains said object based on the table id that is associated with the table that contains the object; and said processor configured to locate said object within said table based on the object id that is associated with said object.
Claim 48
Dependent Claim
162 words
A computer system comprising: a processor; a memory coupled to said processor; a plurality of databases; a set of objects that reside in said plurality of databases; a set of tables that reside in said plurality of databases, wherein each object from said set of objects is contained in a table from said plurality of tables; said processor configured to associate an object id with each object from said set of objects; said processor configured to associate a table id with each table of said plurality of tables; wherein the table id associated with each of said plurality of tables is not assigned to any other table in any of said plurality of databases; said processor configured to locate a table that contains said object based on the table id that is associated with the table that contains the object; and said processor configured to locate said object within said table based on the object id that is associated with said object.
Claim 49
Dependent Claim
127 words
A computer system comprising: a processor; a memory coupled to said processor; a set of one or more databases; a plurality of tables that reside in the set of databases; a set of objects that reside in the set of one or more databases, wherein each object from said set of objects is contained in a table from said plurality of tables; said processor configured to receive a reference to an object, wherein the object is from the set of objects that reside in the set of databases; said processor configured to read a table identifier from the reference; said processor configured to locate a table associated with the table identifier; and said processor configured to access the object from the table associated with the table identifier.
Claim 50
Dependent Claim
127 words
A computer system comprising: a processor; a memory coupled to said processor; a set of one or more databases; a plurality of tables that reside in the set of databases; a set of objects that reside in the set of one or more databases, wherein each object from said set of objects is contained in a table from said plurality of tables; said processor configured to receive a reference to an object, wherein the object is from the set of objects that reside in the set of databases; said processor configured to read a table identifier from the reference; said processor configured to locate a table associated with the table identifier; and said processor configured to access the object from the table associated with the table identifier.
Claim 51
Dependent Claim
138 words
A computer system comprising: a processor; a memory coupled to said processor; a set of one or more databases; a set of objects that reside in the set of databases; said processor configured to receive a reference to an object that has a first object identifier, wherein said object is from said set of objects; said processor configured to read a row-id from the reference; said processor configured to read a second object identifier from a row that resides at a location identified by the row-id; said processor configured to access the object from said row if the second object identifier matches said first object identifier; and said processor configured to search for a row that contains an object identifier that matches said first object identifier if the second object identifier does not match said first object identifier.
Claim 52
Dependent Claim
138 words
A computer system comprising: a processor; a memory coupled to said processor; a set of one or more databases; a set of objects that reside in the set of databases; said processor configured to receive a reference to an object that has a first object identifier, wherein said object is from said set of objects; said processor configured to read a row-id from the reference; said processor configured to read a second object identifier from a row that resides at a location identified by the row-id; said processor configured to access the object from said row if the second object identifier matches said first object identifier; and said processor configured to search for a row that contains an object identifier that matches said first object identifier if the second object identifier does not match said first object identifier.
References Cited (Backward Citations)
US5594899A
Cited
US5261098A
Cited
US5581758A
Cited
US5551027A
Cited
US5560005A
Cited
US5724575A
Cited
US5729730A
Cited
US5978791A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2003-10-17 | 2004-04-17 | 2004-10-17 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2007-10-17 | 2008-04-17 | 2008-10-17 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2011-10-17 | 2012-04-17 | 2012-10-17 | $7700.00 | Window Closed / Lapsed |