Database management system and method which monitors action results and adjusts user parameters in response

• US 20020087587A1
• Filed: 11/21/2001
• Published: 07/04/2002
• Est. Priority Date: 11/22/2000
• Status: Active Grant

• Current Assignee: BMC Software Incorporated (KKR & Co., Inc.)
• Original Assignee: BMC Software Incorporated (KKR & Co., Inc.)
• Inventors: Slavin, Jeff, Vos, Melody
• Granted Patent: US 8,271,457 B2
• Time in Patent Office: Days
• US Class Current: 707/203
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: G06F 16/2453 Query optimisation
• CPC Class Codes: G06F 2201/80 Database-specific techniques
• CPC Class Codes: G06F 2201/86 Event-based monitoring
• CPC Class Codes: Y10S 707/955 Object-oriented
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image

Abstract

A system and method for automated database management are provided. Statistics relating to operation of a database may be collected, wherein the database comprises one or more database objects. Characteristics of the database objects may be determined, either automatically or by user intervention, using the collected statistics, one or more policies, and/or one or more definitions. The policies and definitions may be defaults or may be customized by a user. Actions to be performed on the database objects may be determined, either automatically or by user intervention, based on the characteristics of the database objects. A schedule for performing the actions on the database objects may be automatically determined. The actions may be performed on the database objects based on the schedule. The actions on the database objects may be confirmed. The results of the actions on the database objects may be analyzed or monitored. Policies and/or definitions may be reconfigured based on the results. The system and method may automatically decide to perform one or more REORG actions on the database objects based on the statistics. A recommendation of a modification to one or more of the database objects may be generated based on the statistics. The scheduled actions may be modified as a result of detecting a change in the characteristics or usage of at least one of the database objects.

Claims

1. A database management method comprising:

determining actions to be performed on one or more database objects, wherein a database comprises the one or more database objects;

performing the actions on the database objects;

monitoring results of the performing the actions on the database objects; and

reconfiguring one or more policies or definitions based on the monitoring the results of the performing the actions on the database objects.

2. The database management method of claim 1, further comprising:

automatically determining a schedule for performing the actions on the database objects, wherein the performing the actions on the database objects comprises performing the actions on the database objects based on the schedule.

3. The database management method of claim 2,

wherein the performing the actions on the database objects based on the schedule comprises automatically performing the actions on the database objects based on the schedule.

4. The database management method of claim 1, further comprising:

confirming the performing the actions on the database objects.

5. The database management method of claim 1, further comprising:

collecting statistics relating to operation of a database; and

determining characteristics of the database objects.

6. The database management method of claim 5,

wherein the determining the characteristics of the database objects comprises automatically determining the characteristics of the database objects.

7. The database management method of claim 5,

wherein the determining the actions to be performed on the database objects comprises determining the actions to be performed on the database objects based on the characteristics of the database objects.

8. The database management method of claim 7,

wherein the determining the actions to be performed on the database objects based on the characteristics of the database objects comprises automatically determining the actions to be performed on the database objects based on the characteristics of the database objects.

9. The database management method of claim 5,

wherein the statistics comprise object-level statistics.

10. The database management method of claim 5,

wherein the statistics comprise activity-level statistics.

11. The database management method of claim 5,

wherein the determining the characteristics of the database objects comprises determining the characteristics of the database objects using the collected statistics.

12. The database management method of claim 5,

wherein the determining the characteristics of the database objects comprises determining the characteristics of the database objects using the one or more policies.

13. The database management method of claim 5,

wherein the determining the characteristics of the database objects comprises determining the characteristics of the database objects using the one or more definitions.

14. The database management method of claim 1, further comprising:

customizing the one or more definitions.

15. The database management method of claim 1, further comprising:

customizing the one or more policies.

17. The carrier medium of claim 16, wherein the program instructions are further computer-executable to implement:

automatically determining a schedule for performing the actions on the database objects, wherein the performing the actions on the database objects comprises performing the actions on the database objects based on the schedule.

18. The carrier medium of claim 17,

wherein the performing the actions on the database objects based on the schedule comprises automatically performing the actions on the database objects based on the schedule.

19. The carrier medium of claim 16, wherein the program instructions are further computer-executable to implement:

confirming the performing the actions on the database objects.

20. The carrier medium of claim 16, wherein the program instructions are further computer-executable to implement:

collecting statistics relating to operation of a database; and

determining characteristics of the database objects.

21. The carrier medium of claim 20,

wherein the determining the characteristics of the database objects comprises automatically determining the characteristics of the database objects.

22. The carrier medium of claim 20,

wherein the determining the actions to be performed on the database objects comprises determining the actions to be performed on the database objects based on the characteristics of the database objects.

23. The carrier medium of claim 22,

wherein the determining the actions to be performed on the database objects based on the characteristics of the database objects comprises automatically determining the actions to be performed on the database objects based on the characteristics of the database objects.

24. The carrier medium of claim 20,

wherein the statistics comprise object-level statistics.

25. The carrier medium of claim 20,

wherein the statistics comprise activity-level statistics.

26. The carrier medium of claim 20,

wherein the determining the characteristics of the database objects comprises determining the characteristics of the database objects using the collected statistics.

27. The carrier medium of claim 20,

wherein the determining the characteristics of the database objects comprises determining the characteristics of the database objects using the one or more policies.

28. The carrier medium of claim 20,

wherein the determining the characteristics of the database objects comprises determining the characteristics of the database objects using the one or more definitions.

29. The carrier medium of claim 16, wherein the program instructions are further computer-executable to implement:

customizing the one or more definitions.

30. The carrier medium of claim 16, wherein the program instructions are further computer-executable to implement:

customizing the one or more policies.

16. A carrier medium comprising program instructions, wherein the program instructions are computer-executable to implement:

determining actions to be performed on one or more database objects, wherein a database comprises the one or more database objects;

performing the actions on the database objects;

monitoring results of the performing the actions on the database objects; and

reconfiguring one or more policies or definitions based on the monitoring the results of the performing the actions on the database objects.

31. A database management system comprising:

a CPU;

a database coupled to the CPU, wherein the database comprises one or more database objects;

a memory coupled to the CPU, wherein the memory stores program instructions which are executable by the CPU to;

determine actions to be performed on the database objects;

perform the actions on the database objects;

monitor results of the performing the actions on the database objects; and

reconfigure one or more policies or definitions based on the monitoring the results of the performing the actions on the database objects.

32. The database management system of claim 31, wherein the program instructions are further executable by the CPU to:

automatically determine a schedule for performing the actions on the database objects, wherein in performing the actions on the database objects, the program instructions are further executable by the CPU to perform the actions on the database objects based on the schedule.

33. The database management system of claim 32,

wherein in performing the actions on the database objects based on the schedule, the program instructions are further executable by the CPU to automatically perform the actions on the database objects based on the schedule.

34. The database management system of claim 31, wherein the program instructions are further executable by the CPU to:

confirm the performing the actions on the database objects.

35. The database management system of claim 31, wherein the program instructions are further executable by the CPU to:

collect statistics relating to operation of a database; and

determine characteristics of the database objects.

36. The database management system of claim 35,

wherein in determining the characteristics of the database objects, the program instructions are further executable by the CPU to automatically determine the characteristics of the database objects.

37. The database management system of claim 35,

wherein in determining the actions to be performed on the database objects, the program instructions are further executable by the CPU to determine the actions to be performed on the database objects based on the characteristics of the database objects.

38. The database management system of claim 37,

wherein in determining the actions to be performed on the database objects based on the characteristics of the database objects, the program instructions are further executable by the CPU to automatically determine the actions to be performed on the database objects based on the characteristics of the database objects.

39. The database management system of claim 35,

wherein the statistics comprise object-level statistics.

40. The database management system of claim 35,

wherein the statistics comprise activity-level statistics.

41. The database management system of claim 35,

wherein in determining the characteristics of the database objects, the program instructions are further executable by the CPU to determine the characteristics of the database objects using the collected statistics.

42. The database management system of claim 35,

wherein in determining the characteristics of the database objects, the program instructions are further executable by the CPU to determine the characteristics of the database objects using the one or more policies.

43. The database management system of claim 35,

wherein in determining the characteristics of the database objects, the program instructions are further executable by the CPU to determine the characteristics of the database objects using the one or more definitions.

44. The database management system of claim 31, wherein the program instructions are further executable by the CPU to:

customize the one or more definitions.

45. The database management system of claim 31, wherein the program instructions are further executable by the CPU to:

customize the one or more policies.