Software and method for utilizing a generic database query

• US 8,606,799 B2
• Filed: 12/28/2006
• Issued: 12/10/2013
• Est. Priority Date: 12/28/2006
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Dehn, Rene, Kaiser, Martin
• Primary Examiner(s): CHANNAVAJJALA, SRIRAMA T
• Application Number:
  US11/647,802
• Publication Number:
  US 20080162457A1
• Time in Patent Office: 2,539 Days
• Field of Search: 707 1- 7, 707/100, 707/102, 707/103.R, 707/103.Z, 707/104.1, 707200-201, 707/601, 707/609, 707790-793, 707/796, 707/807, 707961-962, 707/758, 707/769, 707/770, 707802-803, 706 45- 50, 715/968
• US Class Current: 707/758
• CPC Class Codes: G06F 16/00 Information retrieval; Database structures therefor; File system structures therefor
• CPC Class Codes: G06F 16/256 in federated or virtual databases

Abstract

This disclosure provides various embodiments of software for identifying and utilizing a generic database query. In one aspect, the software identifies a generic query such that the generic query is independent of a particular database layout, and accesses a database table having a first layout using the generic query. In some implementations, the software may comprise a business application associated with a database, where the generic query is embedded in the business application without knowledge of the associated database'"'"'s table layout. In other implementations, the generic query may be embedded in the software before the database table is created.

Claims

1. An article comprising computer readable instructions for accessing a database table, the computer readable instructions stored on a non-transitory computer readable medium and operable when executed by a processor to:

identify a generic query such that the generic query is independent of a particular database layout, wherein the generic query comprises;

a standard portion of the generic query common to each instance of the generic query; and

a placeholder that represents one or more database table fields excluded from the standard portion of the generic query and is operable to be activated or deactivated based upon the particular layout of an associated database table;

execute a first instance of the generic query against a first database table having a first layout, the placeholder deactivated in the first instance of the generic query based on the first layout; and

execute a second instance of the generic query against a second database table having a second layout disparate from the first layout, wherein particular fields of the placeholder specific to the second database table are activated in the second instance of the generic query based on the second layout.

2. The article of claim 1, wherein computer readable instructions comprise a business application, the generic query is embedded in the business application associated with the database, and the application is decoupled from the layout of the database table.

3. The article of claim 1, wherein the generic query is embedded before the database table is created.

4. The article of claim 1, wherein the second database table is generated after appending at least one data field into the first database table.

5. The article of claim 1, wherein the second database table is generated after deleting at least one data field from the first database table.

6. The article of claim 1, wherein the second database table is generated by joining a table to the first database table.

7. The article of claim 1, wherein the second database table is generated by changing the data type of at least one data field in the first database table.

8. The article of claim 1, wherein executing the first instance of the generic query against the database table comprises:

determining whether the first layout of the first database table is compatible with the standard portion of the generic query; and

if the first layout of the first database table is incompatible with the standard portion of the generic query, then modifying the generic query by populating the placeholder with one or more additional fields associated with the first layout of the first database table.

9. The article of claim 1, wherein the first database table is the same as the second database table.

10. The article of claim 1, wherein the standard portion of the generic query is generated at design time.

11. An article comprising computer readable instructions for accessing a database table, the computer readable instructions stored on a non-transitory computer readable medium and operable when executed by a processor to:

execute a first instance of a generic query against a database table having a first layout, wherein the generic query is independent of a particular database layout and comprises;

a standard portion of the generic query; and

a placeholder that represents one or more database table fields excluded from the standard portion of the generic query and is operable to be activated or deactivated based upon the particular layout of an associated database table;

modify the database table such that the database table has a second layout; and

execute a second instance of the generic query against the database table having a second layout, wherein executing the second instance of the generic query further comprises;

activating the placeholder in the generic query at runtime of the generic query; and

populating the placeholder in response to the modifications of the database table.

12. The article of claim 11, wherein the modifying of the database table is performed by appending at least one data field into the database table.

13. The article of claim 11, wherein the modifying of the database table is performed by deleting at least one data field from the database table.

14. The article of claim 11, wherein the modifying of the database table is performed by joining a table to the database table.

15. The article of claim 11, wherein the modifying of the database table is performed by changing the data type of at least one data field in the database table.

16. The article of claim 11, wherein the placeholder is represented by a name distinct from field names of the database table.

17. The article of claim 11, wherein the generic query contains a separator.

18. The article of claim 11, wherein the placeholder is deactivated to execute the first instance of the generic query against the database table having the first layout.

19. The article of claim 11, wherein only the standard portion of the first instance of the generic query is executed against the database table having the first layout.

20. The article of claim 11, wherein the standard portion of the generic query is generated at design time.

21. A computerized method for generically querying database tables, the method comprising the following steps performed by at least one processor:

executing a first instance of a generic query against a database table having a first layout, wherein the generic query is independent of a particular database layout and comprises;

a standard portion of the generic query; and

a placeholder that represents one or more database table fields excluded from the standard portion of the generic query and is operable to be activated or deactivated based upon the particular layout of an associated database table;

modifying the database table such that the database table has a second layout; and

executing a second instance of the generic query against the database table having a second layout, wherein executing the second instance of the generic query against the database table having the second layout further comprises;

activating the placeholder in the generic query at runtime of the generic query; and

populating the placeholder in response to the modifications of the database table.

22. The method of claim 21, wherein the modifying of the database table is performed by appending at least one data field into the database table.

23. The method of claim 21, wherein the modifying of the database table is performed by deleting at least one data field from the database table.

24. The method of claim 21, wherein the modifying of the database table is performed by joining a table to the database table.

25. The method of claim 21, wherein the modifying of the database table is performed by changing the data type of at least one data field in the database table.

26. The method of claim 21, wherein the placeholder is represented by a name distinct from field names of the database table.

27. The method of claim 21, wherein the generic query contains a separator.

28. The method of claim 21, wherein the placeholder is deactivated to execute the first instance of the generic query against the database table having the first layout.

29. The method of claim 21, wherein only the standard portion of the first instance of the generic query is executed against the database table having the first layout.