Software and method for utilizing a common database layout

• US 7,730,056 B2
• Filed: 12/28/2006
• Issued: 06/01/2010
• Est. Priority Date: 12/28/2006
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Dehn, Rene, Anzuinelli, Gisella Dominguez, Kaiser, Martin, Gross, Rene
• Primary Examiner(s): Fleurantin; Jean B.
• Assistant Examiner(s): Ly; Anh
• Application Number:
  US11/647,909
• Publication Number:
  US 20080162415A1
• Time in Patent Office: 1,251 Days
• Field of Search: 707 1- 7, 707100-102, 707/104.1, 707200-201, 707/10, 707/715, 707/741, 707/803, 707/809
• US Class Current: 707/715
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application

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.

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.

2. The computer readable storage medium of claim 1 wherein the generic index consists of a globally unique identifier.

3. The computer readable storage medium of claim 1 wherein the generic index is a combination of database table fields.

4. The computer readable storage medium of claim 1 wherein the generic index is separated into single include structures with a unique group name.

5. The computer readable storage medium of claim 1, where the first and second database tables are resident in a first data repository, and the software further operable to access a third database table having a third layout disparate from the first and second layouts and the generic index using a third instance of the query, wherein the first, second, and third database tables each include at least one identical key field used by the generic index, wherein the third database table is resident in a second data repository.

6. The computer readable storage medium of claim 1, wherein the query is embodied in SQL programming language.

7. The computer readable storage medium of claim 1, wherein accessing the second database table using a second instance of the query comprises performing any one of 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;

or

deleting a database table record including the generic index.

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; and

wherein the first database table and second database table each include at least one identical key field used by the generic index.

9. The method of claim 8, wherein the generic index consists of a globally unique identifier.

10. The method of claim 8, wherein the generic index is a combination of database table fields.

11. The method of claim 8, wherein the generic index is separated into single include structures with a unique group name.

12. The method of claim 8, where the first and second database tables are resident in a first data repository, and the method further comprising accessing a third database table having a third layout disparate from the first and second layouts and the generic index using a third instance of the query, wherein the first, second, and third database tables each include at least one identical key field used by the generic index, wherein the third database table is resident in a second data repository.

13. The method of claim 8, wherein the query is embodied in SQL programming language.

14. The method of claim 8, wherein the result comprises a status message of the particular access.

15. The method of claim 8, wherein accessing the second database table using a second instance of the query comprises performing any one of 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;

or

deleting a database table record including the generic index.