System and method for SQL performance assurance services
First Claim
Patent Images
1. A system for assuring performance of a plurality of structure query language (SQL) statements, the system comprising:
- a memory comprising instructions;
a processor coupled to the memory, where the processor is configure to execute the instructions to perform a method comprising;
capturing a volume baseline from a production database, wherein the volume baseline indicates a plurality of production database statistics;
retrieving an empty schema of the production database;
creating an emulated environment based on the production database statistics and the empty schema, wherein the emulated environment is created for testing the performance of each of the plurality of SQL statements to be executed in the production database;
executing the plurality of SQL statements in the emulated environment to forecast an execution time required by each of the plurality of SQL statements in the production database, wherein the execution time is forecasted using a formula; and
optimizing an execution plan of at least one of the plurality SQL statements by tuning the at least one of the plurality of SQL statements, wherein the at least one of the plurality of SQL statements is tuned based on the execution time thereby assuring the performance of each of the plurality of SQL statements.
1 Assignment
0 Petitions
Accused Products
Abstract
The present invention relates to a field of evaluating the performance of a Structure Query Language (SQL) in information system. In particular, the invention proposes system and method of integration of a tool in Software Development Life Cycle (SDLC) which assures performance of SQL by estimating an execution time and remote installation of the same in a cloud based testing services. So, it can be used to detect the queries which may not perform well in the production environment.
-
Citations
13 Claims
-
1. A system for assuring performance of a plurality of structure query language (SQL) statements, the system comprising:
-
a memory comprising instructions; a processor coupled to the memory, where the processor is configure to execute the instructions to perform a method comprising; capturing a volume baseline from a production database, wherein the volume baseline indicates a plurality of production database statistics; retrieving an empty schema of the production database; creating an emulated environment based on the production database statistics and the empty schema, wherein the emulated environment is created for testing the performance of each of the plurality of SQL statements to be executed in the production database; executing the plurality of SQL statements in the emulated environment to forecast an execution time required by each of the plurality of SQL statements in the production database, wherein the execution time is forecasted using a formula; and optimizing an execution plan of at least one of the plurality SQL statements by tuning the at least one of the plurality of SQL statements, wherein the at least one of the plurality of SQL statements is tuned based on the execution time thereby assuring the performance of each of the plurality of SQL statements. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A method for assuring performance of a plurality of structure query language (SQL) statements, the method comprising:
-
capturing, by a processor, a volume baseline from a production database, wherein the volume baseline indicates a plurality of production database statistics; retrieving, by the processor, an empty schema of the production database; creating, by the processor, an emulated environment based on the production database statistics and the empty schema, wherein the emulated environment is created for testing the performance of each of the plurality of SQL statements to be executed in the production database; executing, by the processor, the plurality of SQL statements in the emulated environment to forecast an execution time required by each of the plurality of SQL statements in the production database, wherein the execution time is forecasted using a formula; and optimizing, by the processor, an execution plan of at least one of the plurality of SQL statements by tuning the at least one of the plurality of SQL statements, wherein the at least one of the plurality of SQL statements is tuned based on the execution time thereby assuring the performance of the plurality of SQL statements. - View Dependent Claims (9, 10, 11, 12, 13)
-
Specification