Investigation in MYSQLdatabase and NEO4J database

Currently, there are two major of database management systems which are used to deal with data, the first one called Relational Database Management System (RDBMS) which is the traditional relational databases, it deals with structured data and have been popular since decades from 1970, while the second one called Not only Structure Query Language databases (NoSQL), they have been dealing with semi-structured and unstructured data; the NoSQL term was introduced for the first time in 1998 by Carlo Strozzi and Eric Evans reintroduced the term NoSQL in early 2009, and now the NoSQL types are gaining their popularity with the development of the internet and the social media. NoSQL are intending to override the cons of RDBMS, such as fixed schemas, JOIN operations and handling the scalability problems. With the appearance of Big Data, there was clearly a need for more flexible databases. In this study, a theoretical study of investigating in two types of databases MySQL one of the traditional relational databases, and Neo4j one of the graph databases. First of all, choosing these two types of the databases according to their features, both of them depending on the replication and sharding in their systems. Secondly, a brief background with literature review will introduce the opinions for some researchers with some concepts. Thirdly, mentioning relational database and NoSQL in generally and MySQL and Neo4j in specifically, then try to make a comparison between the features for both of them. Moreover, all the websites, the researches, and the journals are the resources for this study. In addition, this study is like mentioned before is a theoretical study so there was no implementation work. However, the comparison presented the result in this study. All in all, we try to provide an understanding for MySQL and Neo4j, that leads us to find both of MySQL and Neo4j have their features, pros and cons that differ from each other. Keywords: RDBMS, NoSQL, MySQL, Neo4j, Replication, Sharding.