COMPARATIVE STUDY BETWEEN VARIOUS DATABASE MANAGEMENT SYSTEMS COMPARATIVE STUDY BETWEEN RELATIONAL, NON-RELATIONAL DATABASE AND COULD AND ON-PREMISE DATABAE SWINBURN UNIVERSITY OF TECHNOLOGY Ahmad Qasim
Contents No table of contents entries found.
1 Introduction I This article presents a comparative study between a non-relational database such as MongoDB and various relational database like, MySQL, MSSQL and Oracle as well as comparing Database from Cloud and on-premises perspective. In General, Database can be classified as relational and non-relational, also known as Structured Query Language and No- Structured Query Language respectively, where SQL is a type of database that stores and provides access to data points "also known as tables" that are related to one another, while NoSQL is type of database that does not use the tabular schema of rows and columns and uses different data models for managing, accessing and storing data. (AltexSoft, 2020) 2 The Technology The focus in this report is to find the best solution that fits with our E-learning website; therefore, we are conducting comparative study of how each database may imply on our application after considering four main factors, Scalability, Performance, Security and Cost. 2.1 MongoDB Is one of the most famous non-relational DBMS, open source which can be employed for unstructured and structured data despite that it was developed to be employed for unnormalized data (AltexSoft, 2020). 2.1.1 Scalability For enterprises operating big data application where data are distributed across multiple of servers, MongoDB has a great advantage over relational DBMS, as it leads to better application performance due to faster data processing. It also support significant