Techniques for Performance Enhancement of SQL Queries in Relational Databases

  IJCTT-book-cover
 
International Journal of Computer Trends and Technology (IJCTT)          
 
© 2018 by IJCTT Journal
Volume-63 Number-1
Year of Publication : 2018
Authors : Praveena M.V., Dr.Ajeet A. Chikkamannur
DOI :  10.14445/22312803/IJCTT-V63P108

MLA

MLA Style: Praveena M.V., Dr.Ajeet A. Chikkamannur "Techniques for Performance Enhancement of SQL Queries in Relational Databases" International Journal of Computer Trends and Technology 63.1 (2018): 41-43.

APA Style:Praveena M.V., Dr.Ajeet A. Chikkamannur (2018). Techniques for Performance Enhancement of SQL Queries in Relational Databases. International Journal of Computer Trends and Technology, 63(1), 41-43.

Abstract
Information is the most important and critical component of any enterprise. It is a processed form of data and communicated to a user to make decisions.The demand for reliable database systems is on the rise with the consolidation and standardization of information systems. In today’s highly competitive world, every organizations require skilled database professionals to manage their information system. The employees need to know the basics of data and databases for its effective utilization. Therefore, the demand and requirement for skilled database professionals is increasing. The database manipulation in relational databases is generally handled through structured query language (SQL) queries. Composing and fine tuning of SQL queries for large and complex databases is an incredibly difficult task. We propose several techniques to enhance the performance of SQL queries written and used in several relational databases to get optimal results. SQL queries plays a vital role in finding solutions in organizational databases in effective and efficient ways.

Reference
[1] Yong-Lak Choi, Woo-SeongJeon, Seok-Hwan Yoon, “ Improving Database System Performance by Applying NoSQL”, J Inf Process Syst, Vol.10, No.3, page 355-364, September 2014.
[2] Maria Jose Suarez-Cabal, Javier Tuya, “Improvement of Test Data by Measuring SQL Statement Coverage”, IEEE proceedings of the Eleventh Annual International Workshop on Software Technology and Engineering Practice (STEP?04), 2004.
[3] Dr M. Senthil, K. Sivaraman, “Performance Improvements In DBMS”, International Journal of Advance d Computer Technology, Vol. 2, No. 4, page 12-15, 2016.
[4] Law Y., Wangl H., Zaniolo C., “Query Languages and Data Models for Database Sequences and Data Streams” Proceedings of the 30th VLDB Conference, Canada, vol.30, page 492-503, 2004..
[5] Bahmani A. H., Naghibzadeh M., Bahmani B., “Automatic database normalization and primary key generation” IEEE CCECE/CCGEI, May 5-7, Niagara Falls, Canada, page 11-16, 2008..
[6] Ajeet A Chikkamannur, Handigund S. M.,” A concoct semiotic for recursion in SQL”, International Journal of Emerging Trends and Technology in Computer Science, Vol 2, Issue 3, page 204-210, ISSN 2278-6856, 2013.
[7] Dr. Shivanand M. Handigund, Bhat S., “ An Ameliorated Methodology for the Abstraction of Object Class Structures for an Information Systems”, CETS 2010, International Conference on E-business Technology & Strategy, Ottawa, Canada, page 362-367, 2010.
[8] Elmasri, Navathe, “Fundamentals of Database Systems”, 5th Edition, Pearson Education, 2008.
[9] Ramkrishnan R., Geherke J., “Database Management Systems”, McGraw Hill International Editions, Third Edition. 2004.
[10] O?Neil P., O?Neil E., “Database: principles, programming and performance”, 2nd Edition, Morgan Kaufmann, 2001.
[11] Date C. J., Darwen H., “Guide to The SQL Standard”, third edition, Addison Wesley Publishing Company.
[12] Sumeet Bajaj, RaduSion, “CorrectDB: SQL Engine with practical query authentication”, 39thInternational Conference on International Conference on Very Large Data Bases, Trento, Italy, page 529-540, 2013.
[13] Ogden W. C., “Implications of a cognitive model of database query: comparison of a natural language, formal language and direct manipulation interface”, ACM SIGCHI Bulletin 51, Volume 18, Number 2, page 51-54,1986.
[14] Parlikar A., Shrivastava N., Khullar V., Sanyal S., “NQML: Natural Query Markup Language”, IEEE Proceeding of NLP - KE `05, page 184-188, 2005.

Keywords
Database, Performance, Query, RDBMS, Relation, SQL.