Software and method for utilizing a common database layout
First Claim
1. A tangible computer readable storage medium storing software for accessing a database table, the software comprising instructions that are operable when executed by a processor to:
- access a first database table having a first layout and a generic index using a first instance of a query by performing the following processes;
creating a database table record including the generic index;
reading a database table record including the generic index;
updating a database table record including the generic index; and
deleting a database table record including the generic index;
access a second database table having a second layout and the generic index using a second instance of the query, the second layout disparate from the first layout; and
wherein the first database table and second database table each include at least one identical key field used by the generic index.
2 Assignments
0 Petitions
Accused Products
Abstract
This disclosure provides various embodiments of software for utilizing a common database layout. In one aspect, a first database table having a first layout and a generic index is accessed using a first instance of a query, and a second database table having a second layout and the generic index is accessed using a second instance of the query. Some implementations may have a generic index that consists of a globally unique identifier. Other implementations may have a generic index that is a combination of database table fields. In some implementations, the first and second database tables may be resident in a first data repository, and the software may access a third database table having a third layout and the generic index using a third instance of the query, wherein the third database table is resident in a second data repository.
-
Citations
15 Claims
-
1. A tangible computer readable storage medium storing software for accessing a database table, the software comprising instructions that are operable when executed by a processor to:
-
access a first database table having a first layout and a generic index using a first instance of a query by performing the following processes; creating a database table record including the generic index; reading a database table record including the generic index; updating a database table record including the generic index; and deleting a database table record including the generic index; access a second database table having a second layout and the generic index using a second instance of the query, the second layout disparate from the first layout; and wherein the first database table and second database table each include at least one identical key field used by the generic index. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A computerized method for causing a processor to utilize a common database layout, the method comprising the following steps performed by at least one processor:
-
accessing a first database table having a first layout and a generic index using a first instance of a query by performing the following processes; creating a database table record including the generic index; reading a database table record including the generic index; updating a database table record including the generic index; and deleting a database table record including the generic index; accessing a second database table having a second layout and the generic index using a second instance of the query, the second layout disparate from the first layout;
storing a result of the access of the first database table in memory; andwherein the first database table and second database table each include at least one identical key field used by the generic index. - View Dependent Claims (9, 10, 11, 12, 13, 14, 15)
-
Specification