Call for Paper - January 2024 Edition
IJCA solicits original research papers for the January 2024 Edition. Last date of manuscript submission is December 20, 2023. Read More

Enhancement of SDLC Process by integrating it with SQL-PASS (SQL Performance Assurance Services)

International Conference and Workshop on Emerging Trends in Technology
© 2011 by IJCA Journal
Number 9 - Article 1
Year of Publication: 2011
Dattatraya M. Tendulkar
Chetan Phalak

Dattatraya M Tendulkar and Chetan Phalak. Enhancement of SDLC process by integrating it with SQL-PASS (SQL Performance Assurance Services). IJCA Proceedings on International Conference and workshop on Emerging Trends in Technology (ICWET) (9):1-7, 2011. Full text available. BibTeX

	author = {Dattatraya M. Tendulkar and Chetan Phalak},
	title = {Enhancement of SDLC process by integrating it with SQL-PASS (SQL Performance Assurance Services)},
	journal = {IJCA Proceedings on International Conference and workshop on Emerging Trends in Technology (ICWET)},
	year = {2011},
	number = {9},
	pages = {1-7},
	note = {Full text available}


The Software Development Life Cycle (SDLC) Models which are used in the software development process provide the control over the execution process and help to track the project progress. In this whole process, performance testing stage comes quite late and that is limited to the load testing where the system is tested against predefined number of concurrent users doing various transactions in the predefined pattern. This process gives the fair idea about the performance of the developed application but this is not adequate to test the impact of data volumes as test database is populated with the bare minimum data which is needed for the functional testing.
The data retrieving from a table having 100 rows will be definitely faster than a table having 10 millions rows. Impact of volume of data is not getting considered in the performance testing process and this holds the developer/tester back from assuring the performance in the production environment. This is very critical issue as the information systems are becoming more and more complex and it is very common these days where database sizes are in hundreds of GBs. The tools available in the market and the existing methodologies are suitable for the production environment but not effective in the development environment. This creates a gap between database application development and its deployment in the production environment. Therefore assuring the performance against high volume is an indisputable problem faced by the application developer and tester.
In this paper, we have discussed a tool ‘SQL-PASS’ (SQL Performance Assurance Services) based on database emulation technique and its integration with SDLC process which helps in validating and assuring the SQL performance at different stages of SDLC.


  • The Design of a System for Testing Database-Centric Software Applications Using Database Surrogates by Adrian Bonar -
  • High Utility Data Generation Using DataXplod -
  • System & Process for evaluating the performance of a database system – Publication number US 2003/0115212 A1 ( Inventors - Hornibrook, John F,Totonto)
  • Chaware; Jeetendra (Andhra Pradesh, IN), Brown; Douglas P. (Rancho Santa Fe, CA), Sinclair; Paul L. (Manhattan Beach, CA), Julien; Thomas P. (San Diego, CA)
  • Paper “Self-Tuning Database Systems: A Decade of Progress” published by Surajit Chaudhuri & Vivek Narasayya from Microsoft Research Group
  • Explanation of Cost-based Optimizer and Rule-based Optimizer
  • Oracle APIs (package) for manipulating the database statistics
  • Cost Control: Inside the Oracle Optimizer