METHOD AND APPARATUS FOR ENHANCING PERFORMANCE OF DATABASE AND ENVIRONMENT THEREOF

• US 20090240711A1
• Filed: 03/20/2008
• Published: 09/24/2009
• Est. Priority Date: 03/20/2008
• Status: Active Grant

• Current Assignee: DBSophic Ltd. (FutureIT, Inc.)
• Original Assignee: DBSophic Ltd. (FutureIT, Inc.)
• Inventors: LEVIN, Amihai
• Granted Patent: US 8,239,369 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures

Abstract

A method and apparatus for enhancing the performance of an environment comprising a database system. The method and apparatus employ collection stage for collecting data related to substantially all aspects of the system, including hardware, operating system, database, database schema, content and activity. Multiple issues relating to multiple categories are detected within the collected information. Then the detected issues are analyzed by correlating and prioritizing them. The issues that receive the highest priority are preferably those whose correction will yield the most significant improvement on the overall performance of the system. One or more recommendations are then issued for correcting the root issues hindering performance. Preferably, for one or more recommendations, scripts are generated which are then executed manually or automatically.

Claims

1. In a computerized environment comprising at least one computing platform executing a database engine, a method for enhancing the performance of the database engine or the computerized environment, the method comprising the steps of:

receiving data related to at least two aspects of the environment;

detecting from the data at least two detection issues associated with at least two detection categories of the system; and

analyzing at least one analysis issue related to at least one analysis category, according to the at least two detection issues and correlation between the at least two detection issues.

2. The method of claim 1 further comprising a step of issuing at least one recommendation related to at least two detection issues.

3. The method of claim 2 further comprising a step of generating a script for implementing at least one recommendation.

4. The method of claim 3 further comprising a step of executing the script.

5. The method of claim 1 further comprising a step of collecting the data related to at least two aspects of the environment.

6. The method of claim 1 wherein the data relates to any at least two aspects selected from the group consisting of:

hardware;

operating system;

database engine;

database meta data;

data stored in the database;

activity;

performance metrics; and

historical trends.

7. The method of claim 6 wherein the database meta data comprises at least one item from the group consisting of:

database schema;

database objects; and

database code.

8. The method of claim 1 wherein at least one of at least two detection categories are selected from the group consisting of:

database schema;

index schema;

programming objects code;

programming objects usage;

database configuration;

instance configurations;

server configuration;

hardware;

security; and

activity.

9. The method of claim 8 wherein the activity detection category relates to at least one activity from the group consisting of:

retrieving data from a database;

adding data to a database;

updating data within a database; and

deleting data from a database.

10. The method of claim 1 wherein the at least one analysis category is selected from the group consisting of:

hardware, operating system configuration;

instance configuration;

database configuration;

application configuration;

database schema;

index schema;

server side object;

application query coding;

security; and

maintenance.

11. The method of claim 1 further comprising a reporting step for reporting to a user the information related to the detection step or to the analysis step.

12. In a computerized environment comprising at least one computing platform executing a database engine an apparatus for enhancing the performance of the database engine or the computerized environment, the apparatus comprising:

detection components, the detection components comprising

at least one specific detection component for assessing the existence of a situation associated with the detection rule within the environment;

analysis components, the analysis components comprising;

at least one specific analysis component for applying an at least one analysis rule on the situation associated with the detection; and

a performance enhancement estimation component for evaluating the performance enhancement of resolving the situation associated with the at least one analysis rule.

13. The apparatus of claim 12 wherein at least one specific detection component comprises at least one component from the group consisting of:

an activity detection component;

an indexing detection component;

a query detection component;

a schema detection component;

a data detection component; and

a programming object detection component.

14. The apparatus of claim 12 wherein the detection components further comprise a rule engine for activating the at least one specific detection component.

15. The apparatus of claim 12 wherein the at least one specific analysis component comprises at least one component from the group consisting of:

database schema analysis component;

indexing schema analysis component;

server side code analysis component;

application code analysis component;

server configuration analysis component;

instance configuration analysis component;

database configuration analysis component;

application configuration analysis component;

hardware analysis component;

security analysis component; and

maintenance analysis component.

16. The apparatus of claim 12 wherein the analysis components further comprise a prioritization estimation component for prioritizing the at least one analysis rule.

17. The apparatus of claim 12 further comprising recommendation components, the recommendation components comprising a recommendation issuing component for issuing at least one recommendation for resolving the situation associated with the at least one analysis rule.

18. The apparatus of claim 17 wherein the recommendation components further comprise a script generation component for generating a script for resolving the situation associated with the at least one analysis rule.

19. The apparatus of claim 17 wherein the recommendation components further comprise a script execution component for executing a script for resolving the situation associated with the at least one analysis rule.

20. The apparatus of claim 12 further comprising collection components for collecting the data from the environment.

21. The apparatus of claim 20 wherein the collection components comprise at least one component from the group consisting of:

database query component;

operating system component;

hardware component;

memory structures component;

registry access component;

trace collection component;

log collection component; and

data aggregator component.

22. The apparatus of claim 12 further comprising a reporting component for reporting to a user at least one result of the detection components or the analysis components.

23. The apparatus of claim 12 wherein the computerized environment comprises at least one client computing platform.

24. A computer readable storage medium containing a set of instructions for a general purpose computer, the set of instructions comprising:

receiving data related to at least two aspects of a computerized environment comprising at least one computing platform executing a database engine;

detecting from the data at least two detection issues associated with at least two detection categories of the system; and

analyzing at least one analysis issue related to at least one analysis category, according to the at least two detection issues and correlation between the at least two detection issues.