09-02-2010, 08:33 PM
[attachment=1871]
Project title: DB Query Verification tool
Objective
The purpose of the DB Query Verification Tool is to provide the database team with the ability to test queries for databases across different RDBMS. This tool also aims at querying databases for the presence of database object as well as retrieving information about stored procedure across different RDBMS.
Why DB Query Verification Tool is needed
The client company has database team and number of software developing teams. The software developing teams work on different software that has different back end server. The developer teamsâ„¢ uses the database queries and objects which are created by the database team. In the due course of time there are huge numbers of entities such as tables, stored procedures; views etc. created by the database team that has to be used by the software developing team. During the development of a project some time it is possible that a developer reports non existence of a database object or occurrence of an error while the object is used. The db team is provided with database object name. Now, it becomes necessary for a db team member to confirm the existence of the database object and to get the database id of the object as proof and to find out whether the error is caused by the database object or not. Sometime it happens that a developer reports some inconsistency with a stored procedure developed and provided by the database team and there is no problem with the code that works with the stored procedure. In this scenario the developer provides only the name of the stored procedure that shows inconsistency. The DB team has to first check the existence of the stored procedure. Then they have to find out the parameters to be passed to the stored procedure, their types and their direction. During development of certain software the test queries are to be run on database having real time data or secured data. So it is required that the execution of test queries for creating or checking them for consistency should not affect the existing data. The database team needs a common interface wherein they can perform the above processes on different database management system such as SQL Server, Oracle and MySql.
Process Flow
