Keywords
How to Cite
Abstract
Complexity, and Handling of huge data is a crucial target for all management systems. Databases are the backbone, central and core component of a computer application to store data in a logical way, which define the structure and mechanism for manipulation of data. Many Databases are available for handling and saving huge data including commercial and non-commercial like Microsoft SQL Server, Oracle Database, and MYSQL etc. Many vendors are working on modern techniques of databases spatio-temporal, object-relational, parallel databases etc. This novel research evaluates the comparative study and execution performance of top three databases according to their particular scenario and situation, after reading the paper the computer related experts especially developers easily judge, which database is most reliable in particular scenario, choosing the right decision for development of huge computer applications for hospitals, banks, and industries.
References
Silberschatz A, Korth HF, Sudarsham S. Database System Concepts, 4th Ed. McGraw-Hill Higher Education; 2001.
MS SQL Server [homepage on the Internet]. Database, cited 2016 Oct 28, Available from https://www.microsoft.com/en-us/sql-server/sql-server-2016
Oracle Database [homepage on the Internet]. Databases cited 2016 Oct 28 Available from https://docs.oracle.com/cd/ B19306_01/server.102/b14220/intro.htm
MySQL Database [homepage on the Internet]., Access On 28-Oct-2016,http://www.mysql.com/products/community/
Commercial and Open Sourced databases [homepage on the Internet]., Access On 28-Oct-2016, http://db-engines.com/en/ranking_osvsc
Letkowski J. “Doing database design with MySQL”, Journal of Technology Research Volume 6, 2014.
Microsoft SQL Server, Access On 28-Oct-2016, https://en.wikipedia.org/wiki/Microsoft_SQL_Server
MS SQL Server 2016 Features, Access On 28-Oct-2016, http://www.databasejournal.com/features/mssql/slideshows/10-new-features-worth-exploring-in-sql-server-2016.html
Oracle 12c Database History, Access On 28-Oct-2016, https://en.wikipedia.org/wiki/Oracle_Database
Oracle 12c Database Features, Access On 28-Oct-2016, http://allthingsoracle.com/oracle-database-12c-new-features-part-i/
MySQL Server 5.7 Features, Access On 28-Oct-2016, http://dev.mysql.com/doc/refman/5.7/en/mysql nutshell.html.
Tudose C, Odub??teanu C. Database Management Systems Comparative Study: Performances of Microsoft SQL Server Versus Oracle.
Bassil Y. A Comparative Study on the Performance of the Top DBMS Systems February 2012; No 1: pp. 20-31.
Bajaj P, Dhindsa Kaur S. A Comparative Study of Database Systems 2012; 1(2277-3754): 267-269.
Gyorodi C, Gyorodi R, Livia B. A Comparative Study of Databases with Different Methods of Internal Data Management April 2016; Volume IJACSA.2016.070433.
Faraj A, Shareef T, Rashid B. Comparative Study of Relational and Non-Relational Database Performances using Oracle and MongoDB Systems November 2014; 5(11): 11-12.
Kumar L, Rajawat S, Joshi K. Comparative analysis of NoSQL(MongoDB) with MySQL database May 2015; 2(5): 122-127.
B Damodaran D, Salim S, Varghese MS. MongoDB vs MYSQL: A comparative study of performance in super market management system May 2016; 4(2): 31-38.
Gy?rödi C, Gy?rödi R, Sotoc R. A Comparative Study of Relational and Non-Relational Database Models in a Web- Based Application 2015; 6(11): 78-83.
Jatana N, Puri S, Ahuja M, Kathuria I, Gosain D. A survey and comparison of relational and non-relational databases August 2012; 1(6): 1-5.
Padhy RP, Patra MR, Satapathy SC. RDBMS to NoSQL:Reviewing Some Next-Generation Non-Relational Database’s 2011; 11(1): 015-030.
Nayak A, Poriya A, Poojary D. Type of NOSQL Databases and its Comparison with Relational Databases. March 2013; 5(4).
Jha SK, Kumar P, Dwivedi AKD. An Experimental Analysis of MYSQL Database Server Reliability March 2012; 3(2): 354-371.
Sanobar K, Vanita M. SQL Support over MongoDB using Metadata October 2013; 3(10).
Dipina Damodaran B, Salim S, Vargese SM. Performance evaluation of MYSQL and mongoDB databases April 2016; 5(2).
Parameters of Databases [homepage on the Internet]., Access On 30-Oct-2016, http://db-engines.com/en/system/ Microsoft+SQL+Server%3BMySQL%3BOracle
Ranking of Databases, Access On 2-Oct-2016, http://db-engines.com/en/ranking_trend
Trend Chart of SQL Server 2016, Oracle Database 12c and MySQL Database 5.7, Access On 12-Oct-2016, http://db-engines.com/en/ranking_trend/system/Microsoft+SQL+Server%3BMySQL%3BOracle
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
Copyright (c) 2017 Khawar Islam, Kamran Ahsan, S.A.K. Bari, Muhammad Saeed , Syed Asim Ali