DBQA: Multi-Environment Analyzer for Query Execution Time and Cost

In today's computational world, many ways are available for storing and retrieving database. Numbers of commercial database management systems are available in the market with their superiors. The primary goal of DBMSs is to provide a way to store and retrieve database information that is both convenient and efficient. The question is which one to be selected according to our need and usage. While selecting DBMSs the main agenda is its performance. The performance of the system measured in terms of cost and time. If a larger query process with minimum time and cost, we can say the performance of the system is good. The care of performance is taken by query optimization technique in query processing. This is a core part of the paper; in the paper, we have developed DBQA (Database Query Analyzer) to analyze performance of the top four DBMSs on select queries with respect to time and cost. The DBMSs used for performance are MySQL, PostgreSQL, Oracle and MS SQL Server. The standard dataset DBLP have used for testing with 9360103 records.