Database Performance Analyser S/W Test Tool

Abstract — The role of a database is indispensable in the successful running of any business. The advent of the internet has totally changed the business scenario and how industries operate which has led to the growing popularity of online database. There are many scenarios in which there are multiple DB queries fired at a single point on time as multiple clients can access database at the same time. It may be possible that thousands of clients are accessing same table using same stored procedure. So it is important to check database capabilities/performance and its stored procedures in multi threaded environment before launching it into real world. DB_Performance_Analyser_Software_Test_Tool is a tool that helps to simulate multiple clients ’ environment and generate logs that can be use to analyze the capability of stored procedures created and database selected. This tool gives user a freedom to create as many clients as he wants that will interact with the database at the same time. By creation of this tool, we try to approach to non- functional quality attributes of DataBase ( DB) like reliability, robustness, etc. In this paper, we are focusing only on creating a simulated environment in which, multiple queries will be fired on DB for simultaneous updation / deletion / addition of DB rows. There will be a possibility of some queries not entertained by DB because DB handling other query at that particular time. So, an error log will be generated which will depict total queries fired in a give span of time, total successful queries fired, total unsuccessful queries. The purpose of this paper is to run simulation and share the performance of the DB_Performance_Analyser_Software_Test_Tool