Method and apparatus for enhancing performance of database and environment thereof
First Claim
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:
- 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, wherein one of the at least two detection categories is a query code category, the query code category defines issues related to coding of query statements executed by the environment;
correlating the detection issues to determine at least one analysis issue;
analyzing the at least one analysis issue related to at least one analysis category, wherein the at least one analysis category is selected from analysis categories influenced by issues detected in the coding of the query statements; and
issuing at least one recommendation based, in part, on the analysis of the at least analysis issue and the coding of the query statements.
1 Assignment
0 Petitions
Accused Products
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.
-
Citations
24 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:
-
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, wherein one of the at least two detection categories is a query code category, the query code category defines issues related to coding of query statements executed by the environment; correlating the detection issues to determine at least one analysis issue; analyzing the at least one analysis issue related to at least one analysis category, wherein the at least one analysis category is selected from analysis categories influenced by issues detected in the coding of the query statements; and issuing at least one recommendation based, in part, on the analysis of the at least analysis issue and the coding of the query statements. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11)
-
-
12. In a computerized environment comprising at least one computing platform executing a database engine executed by a first computing platform, 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 at least two detection issues associated with at least two detection categories within the environment, according to a detection rule, wherein one of the at least two detection categories is a query code category, the query code category defines issues related to coding of query statements executed by the environment; analysis components, the analysis components comprising;
at least one specific analysis component for correlating the detection issues to determine at least one analysis issue and analyzing the at least one analysis issue related to at least one analysis category from the at least two detection issues by applying at least one analysis rule, wherein the at least one analysis category is selected from analysis categories influenced by issues detected in the coding of the query statements;a performance enhancement estimation component for evaluating the performance enhancement of resolving the situation associated with the at least one analysis rule; and at least one recommendation component for issuing at least one recommendation to resolve the situation based, in part, on the analysis of the at least analysis issue and the coding of the query statements, wherein the at least one specific detection component or the at least one at least one specific analysis component or the performance enhancement estimation component is adapted to be executed by the first computing platform or by a second computing platform, each of the first computing platform and the second computing platform includes a processor coupled to a memory. - View Dependent Claims (13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23)
-
-
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, wherein one of the at least two detection categories is a query code category, the query code category defines issues related to coding of query statements executed by the environment; correlating the detection issues to determine at least one analysis issue; analyzing the at least one analysis issue related to at least one analysis category, wherein the at least one analysis category is selected from analysis categories influenced by issues detected in the coding of the query statements; and issuing at least one recommendation based, in part, on the analysis of the at least analysis issue and the coding of the query statements.
-
Specification