AUTOMATED DATABASE OPTIMIZATION

• US 20140074792A1
• Filed: 09/07/2012
• Published: 03/13/2014
• Est. Priority Date: 09/07/2012
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: Sumanth Hegde, V Santosh
• Inventors: V, SANTOSH, HEGDE, SUMANTH
• Granted Patent: US 9,081,806 B2
• Time in Patent Office: Days
• US Class Current: 707/667
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409

Abstract

Various embodiments of systems and methods of optimizing a database are described herein. Database tables are rated based on at least one of table size and table growth rate. One or more of the database tables are then selected based on the rating of the database tables. Archiving objects for the one or more selected tables are obtained. An archiving object includes one or more archiving programs and defines data related to a business object. The archiving objects are ranked based on dependencies between them. Based on the ranking of the archiving objects, an archiving schedule including an archiving order for the archiving objects is generated. The archiving schedule is then displayed.

Claims

1. An article of manufacture including a non-transitory computer readable storage medium to tangibly store instructions, which when executed by a computer, cause the computer to:

rate database tables based on at least one of table size and table growth rate;

select one or more of the database tables based on the rating of the database tables;

obtain archiving objects for the one or more selected tables, wherein an archiving object includes one or more archiving programs and defines data related to a business object;

rank the archiving objects based on dependencies between the archiving objects;

based on the ranking of the archiving objects, generate an archiving schedule including an archiving order for the archiving objects; and

display the archiving schedule.

2. The article of manufacture of claim 1, wherein the instructions to rate the database tables based on at least one of table size and table growth rate, further comprises instructions to:

determine a composite rating for each of the database tables based on the based the table size and the table growth rate.

3. The article of manufacture of claim 2, wherein the instructions to select the one or more of the database tables based on the rating of the database tables, further comprises instructions to:

select the one or more of the database tables based on a threshold value of the composite rating.

4. The article of manufacture of claim 3, further comprising instructions which when executed by the computer further causes the computer to:

display the composite rating and the dependencies between the archiving objects.

5. The article of manufacture of claim 1, further comprising instructions which when executed by the computer further causes the computer to:

select data slice variants for one or more of the archiving objects based on an attribute, wherein the data slice variants for an archiving object of the one or more of the archiving objects are mutually exclusive.

6. The article of manufacture of claim 5, wherein the archiving schedule further includes the data slice variants for the one or more of the archiving objects.

7. The article of manufacture of claim 1, further comprising instructions which when executed by the computer further causes the computer to:

execute archiving processes according to the archiving schedule.

8. A computerized method of optimizing a database, the method comprising:

rating database tables based on at least one of table size and table growth rate;

selecting one or more of the database tables based on the rating of the database tables;

obtaining archiving objects for the one or more selected tables, wherein an archiving object includes one or more archiving programs and defines data related to a business object;

ranking the archiving objects based on dependencies between the archiving objects;

based on the ranking of the archiving objects, generating an archiving schedule including an archiving order for the archiving objects; and

displaying the archiving schedule.

9. The method of claim 8, wherein rating the database tables based on at least one of table size and table growth rate, comprising:

determining a composite rating for each of the database tables based on the based the table size and the table growth rate.

10. The method of claim 9, wherein selecting the one or more of the database tables based on the rating of the database tables, comprising:

selecting the one or more of the database tables based on a threshold value of the composite rating.

11. The method of claim 10, further comprising:

displaying the composite rating and the dependencies between the archiving objects.

12. The method of claim 8, further comprising:

selecting data slice variants for one or more of the archiving objects based on an attribute, wherein the data slice variants for an archiving object of the one or more of the archiving objects are mutually exclusive.

13. The method of claim 12, wherein the archiving schedule further includes the data slice variants for the one or more of the archiving objects.

14. The method of claim 8, further comprising:

execute archiving processes according to the archiving schedule.

15. A computer system for optimizing a database, comprising:

a computer memory to store program code; and

a processor to execute the program code to;

rate database tables based on at least one of table size and table growth rate;

select one or more of the database tables based on the rating of the database tables;

obtain archiving objects for the one or more selected tables, wherein an archiving object includes one or more archiving programs and defines data related to a business object;

rank the archiving objects based on dependencies between the archiving objects;

based on the ranking of the archiving objects, generate an archiving schedule including an archiving order for the archiving objects; and

display the archiving schedule.

16. The system of claim 15, wherein the program code to rate the database tables based on at least one of table size and table growth rate, further comprises program code to:

determine a composite rating for each of the database tables based on the based the table size and the table growth rate; and

the program code to select the one or more of the database tables based on the rating of the database tables, further comprises program code to;

select the one or more of the database tables based on a threshold value of the composite rating.

17. The system of claim 16, wherein the processor further executes the program code to:

display the composite rating and the dependencies between the archiving objects

18. The system of claim 15, wherein the processor further executes the program code to:

select data slice variants for one or more of the archiving objects based on an attribute, wherein the data slice variants for an archiving object of the one or more of the archiving objects are mutually exclusive.

19. The system of claim 18, wherein the archiving schedule further includes the data slice variants for the one or more of the archiving objects.

20. The system of claim 15, wherein the processor further executes the program code to:

execute archiving processes according to the archiving schedule.