SYSTEM AND METHOD FOR SQL PERFORMANCE ASSURANCE SERVICES

• US 20130067440A1
• Filed: 05/18/2011
• Published: 03/14/2013
• Est. Priority Date: 05/18/2010
• Status: Active Grant

• Current Assignee: TATA Consultancy Services Limited (Tata Sons Pvt Ltd.)
• Original Assignee: TATA Consultancy Services Limited (Tata Sons Pvt Ltd.)
• Inventors: Tendulkar, Dattatraya Mohan
• Granted Patent: US 8,930,918 B2
• Time in Patent Office: Days
• US Class Current: 717/134
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06F 16/24542 Plan optimisation
• CPC Class Codes: G06F 8/70 Software maintenance or management

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.

Claims

1. A system for performance assurance in development environment, the said system comprising:

a. at least one virtual testing platform generating plurality of instances of the development process;

b. plurality of users communicatively coupled with the said virtual testing platform, executing at least one instance of development process on the said testing platform;

c. a user management means controlling user creation and user access to the said testing platform;

d. a SQL performance tuning means;

e. a load testing means adapted to operate in a single user mode;

f. at least one input instruction adapted to be bundled in a SQL batch file;

g. an input means adapted to receive instructions and statistics for executing said process;

h. an emulated framework means adapted to receive said input instructions in order to obtain emulated parameters in relation to said input instructions;

i. a development framework means adapted to receive said input instructions in order to obtain development parameters in relation to said input instructions, said development framework having;

production database means adapted to store production database parameters;

j. computational means adapted to compute development parameters in relation to said production database parameters;

k. production framework extrapolation means adapted to extrapolate actual production parameters from said emulated parameters and said development parameter in relation to pre-defined functions to obtain an estimation of pre-defined parameters required for executing the process in the production environment; and

l. an output means adapted to receive processed results and downloading of generated reports in relation to each process to the user executing the said process on the said testing platform.

2. A system as per claim 1, estimates the execution time in the production environment, wherein the said estimation is based on the emulated environment test results.

3. A system as per claim 1, forecasting the execution time, wherein the said forecasting is based on the emulated environment test results.

4. A system as per claim 1, wherein the performance assurance process identifies the performance problems before deployment in the production environment.

5. A system as per claim 1, wherein the input instructions in relation to one or more processes are executed in the development life cycle of the processes on the said virtual testing platform.

6. A system as per claim 1, wherein virtual testing platform is created by means of a cloud computing.

7. A system as per claim 1, wherein SQL performance tuning is done by user by making the necessary changes in SQL to improve the performance while executing it.

8. A method for performance assurance in development environment, the said method comprising of:

a. generating plurality of instances of the development process by means of virtual testing platform;

b. executing at least one instance of development process on the said testing platform by means of plurality of users communicatively coupled with said system

c. controlling user creation and user access to the said testing platform by means of user management

d. tuning of SQL performance

e. inputting the instructions which are to be bundled in a SQL batch file for executing said process

f. estimating and forecasting the execution time in the production environment, wherein the said estimation and forecasting are based on the emulated environment test results

g. capturing the execution time and cost in the production environment

h. comparing the forecasted results with actual results in the form of a report

i. downloading the generated reports.

9. A method as per claim 8, wherein virtual testing platform is created by means of a cloud computing.

10. A method as per claim 8, wherein the performance assurance process identifies the performance problems before deployment in the production environment.

11. A method as per claim 8, wherein tuning of SQL performance is done by user by making the necessary changes in SQL to improve the performance while executing.

12. (canceled)