Managing aged index data for a database

• US 20080154994A1
• Filed: 12/22/2006
• Published: 06/26/2008
• Est. Priority Date: 12/22/2006
• Status: Abandoned Application

• Current Assignee: SAP AG (SAP SE)
• Original Assignee: SAP AG (SAP SE)
• Inventors: Kuhr, Gernot, Schmidt, Olaf, Brinkmoeller, Bernhard, Fischer, Martin P.
• Application Number:
  US11/644,201
• Publication Number:
  US 20080154994A1
• Time in Patent Office: Days
• US Class Current: 707/206
• CPC Class Codes: G06F 16/2272 Management thereof

Abstract

Index data is maintained in a first index of current data objects and in a second index of aged data objects. A database management system may categorize data objects as either current or aged based either on processes associated with the data objects or based upon time. The database management system may later re-categorizing the data object to reflect changes in processes or time. The database management system may receive a query for data and first search the index of current data objects, then search the index of aged data objects.

Claims

1. A computer-implemented method for maintaining index data for a database, comprising:

maintaining a first index of current data objects; and

maintaining a second index of aged data objects.

2. The method of claim 1, wherein at least a subset of the data objects are business objects.

3. The method of claim 1 further comprising categorizing an updated data object as one of current and aged.

4. The method of claim 3, wherein categorizing the data object comprises categorizing the data object as current if the data object is related to a pending business process.

5. The method of claim 3, the updated data object comprising a new data object.

6. The method of claim 3, wherein categorizing the data object comprises categorizing the data object as aged if the object has not been accessed for more than a predefined time.

7. The method of claim 1 further comprising:

categorizing a data object as current;

re-categorizing the data object as aged; and

transferring an individual index of the data object from the index of current data objects to the index of aged data objects.

8. The method of claim 1 further comprising:

receiving a query for particular data objects;

searching the index of current data objects based on the query; and

if the query is not satisfied, searching the index of aged data objects based on the query, subsequently to searching the index of current data objects.

9. The method of claim 1 further comprising:

receiving a query for data, the query including a parameter representing a request to search the index of current data objects; and

searching the index of current data objects.

10. The method of claim 1 further comprising:

receiving a query for data, the query including a parameter representing a request to search the index of aged data objects; and

searching the index of aged data objects.

11. The method of claim 1 further comprising:

receiving a query for data;

executing a first sub-query representing a request to search the index of current data objects; and

executing a second sub-query representing a request to search the index of aged data objects.

12. The method of claim 11 further comprising:

retrieving at least one data object using the index of current data objects;

retrieving at least one data object using the index of aged data objects;

aggregating the retrieved data objects; and

sending the aggregated data to the query requester.

13. The method of claim 1, the current data objects and the aged business objects associated with the same database table.

14. A computer-readable medium for maintaining index data for a database, the computer readable medium including computer-readable instructions operable when executed on a processor to:

maintain a first index of current data objects; and

maintain a second index of aged data objects.

15. The computer-readable medium claim 14, wherein the computer-readable instructions are further operable to perform categorize a particular data object as one of current and aged.

16. The computer-readable medium claim 14, wherein the computer-readable instructions further cause the processor to perform:

categorizing a data object as current;

re-categorizing the data object as aged; and

transferring an individual index of the data object from the index of current data objects to the index of aged data objects.

17. The computer-readable medium claim 14, wherein the computer-readable instructions further cause the processor to perform:

receiving a query for data, the query including a parameter representing a request to search the index of current data objects; and

searching the index of current data objects.

18. The computer-readable medium claim 14, wherein the computer-readable instructions further cause the processor to perform:

receiving a query for data;

creating a first sub-query representing a request to search the index of current data objects; and

creating a second sub-query representing a request to search the index of aged data objects.

19. A system for maintaining index data for a database, comprising:

a first index of current data objects;

a second index of aged data objects; and

a database management system operable to;

maintain a first index of current data objects; and

maintain a second index of aged data objects.

20. The system of claim 19, wherein the database management system is further operable to automatically categorize a particular data object as one of current and aged.

21. The system of claim 19, wherein the database management system is further operable to:

categorize a data object as current;

re-categorize the data object as aged based on certain criteria; and

transfer a particular index entry of the data object from the index of current data objects to the index of aged data objects.

22. A computer implemented method for managing aged indexed data comprising:

identifying a plurality of data objects using a first index;

indexing a first subset of the data objects using a second index based on a business categorization of the data objects; and

indexing a second subset of the data objects using a third index based on the business categorization of the data objects.

23. The method of claim 22, the business categorization associated with particular business logic.

24. The method of claim 22 further comprising:

receiving a query for one or more of the data objects, the query associated with the first index and a client context;

executing an instance of the query on the first subset of the data objects using the second index; and

skipping the second subset of the data objects based on the third index and the client context.