Journal of Computer Engineering & Information TechnologyISSN : 2324-9307

Reach Us +1 850 754 6199
All submissions of the EM system will be redirected to Online Manuscript Submission System. Authors are requested to submit articles directly to Online Manuscript Submission System of respective journal.

Research Article, J Comput Eng Inf Technol Vol: 2 Issue: 3

Performance Analysis of Query Optimizers under Varying Hardware Components in RDBMS

Boukari Souley* and Danlami Mohammed
1Abubakar Tafawa Balewa University (ATBU), Bauchi, Nigeria
Corresponding author : Boukari Souley
Mathematical Sciences Programme, Abubakar Tafawa Balewa University (ATBU), Bauchi, Nigeria
E-mail: [email protected]
Received: June 07, 2013 Accepted: September 16, 2013 Published: September 25, 2013
Citation: Souley B, Mohammed D (2013) Performance Analysis of Query Optimizers under Varying Hardware Components in RDBMS. J Comput Eng Inf Technol 2:3. doi:10.4172/2324-9307.1000110

Abstract

Performance Analysis of Query Optimizers under Varying Hardware Components in RDBMS

Query Optimization is the process of choosing the most efficient way to execute a Structured Query Language (SQL) statement, while query optimizer is a tool in Relational Database Management System (RDBMS) that carries out the process of optimizing a query. In this paper, four different RDBMS were considered namely Microsoft SQL 2010 Server, Oracle 11g Release 2, My SQL 5.6 and Microsoft Access 2010. For the purpose of testing four different data sets were used. The data was run using each data set (1 310 116, 1 047 999, 750 000, 500 000, 250 000 and 125 000). It was discovered that adding more memory to the system shows improved performance of the RDBMS query optimizer. Also, increasing Hard Disk Size has little effect on the performance of RDBMS. While changing the processor size from single core to duo core does not visibly show improved performance of the RDBMS. In all the cases stated, SQL Server 2010 offers better performance followed by My SQL 5.6, Oracle 11g release 2 and Ms Access 2010 respectively. Therefore this paper provides a framework to monitor the trend of the increasing/decreasing changes in hardware components on the performance of query optimizers in RDBMS. The application is recommended for RDBMS developers and maintainers.

Keywords: Query Optimization; Relational Database Management System(RDBMS); SQL Server

Track Your Manuscript

Share This Page