Software and method for utilizing a common database layout

• US 20080162415A1
• Filed: 12/28/2006
• Published: 07/03/2008
• Est. Priority Date: 12/28/2006
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Anzuinelli, Gisella Dominguez, Dehn, Rene, Kaiser, Martin, Gross, Rene
• Granted Patent: US 7,730,056 B2
• Time in Patent Office: Days
• US Class Current: 707/2
• 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. Software comprising instructions stored on a computer readable medium, the software operable when executed to:

access a first database table having a first layout and a generic index using a first instance of a query; and

access a second database table having a second layout and the generic index using a second instance of the query.

2. The software of claim 1 wherein the generic index consists of a globally unique identifier.

3. The software of claim 1 wherein the generic index is a combination of database table fields.

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

5. The software 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 and the generic index using a third instance of the query, wherein the third database table is resident in a second data repository.

6. The software of claim 1 wherein accessing the first database table using a first instance of the query comprises one of the following:

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.

7. The software of claim 1, wherein the query is embodied in SQL programming language.

8. A computerized method for utilizing a common database layout, comprising:

accessing a first database table having a first layout and a generic index using a first instance of a query; and

accessing a second database table having a second layout and the generic index using a second instance of the query.

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 and the generic index using a third instance of the query, wherein the third database table is resident in a second data repository.

13. The method of claim 8, wherein accessing the first database table using a first instance of the query comprises one of the following:

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.

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

15. A system for utilizing a common database layout, comprising:

means for accessing a first database table having a first layout and a generic index using a first instance of a query; and

means for accessing a second database table having a second layout and the generic index using a second instance of the query.

16. The system of claim 15, wherein the generic index consists of a globally unique identifier.

17. The system of claim 15, wherein the generic index is a combination of database table fields.

18. The system of claim 15, where the first and second database tables are resident in a first data repository, and the system further comprising means for accessing 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.