No Pains No Gains : Distributed Database Solutions

A Relational Database Management System (RDBMS) is a type of database management system that stores data in the form of related tables. The system does not require many assumptions about how data is related t or how it is to be extracted from the database. The database can be viewed in several forms.

An RDBMS is a software program that allows users to enter, manipulate, and retrieve data.

According to one database pioneer, the future development of databases and data warehouses will depend on _______________.

Coronel, C. (2013). Database Systems: Design, Implementation, and Management, Tenth Edition. Mason, Ohio, United States: Cengage Learning.

Relational database contains data records that do not have a preset of relationships, permitting the user to define his or her relationship when accessing the data. Since users have much control over the data being accessed, relational databases can perform a variety of tasks. Such as defining the database; querying the database; adding, editing, and deleting data from the database; modifying the structure of the database; securing data from public access; communicating within the network; and exporting and importing data (Murthy, 2008).

The database was first introduced in the 1960s with the access of storage disks. As technology advanced, interest in database grew. Charles Bachman founded the ‘Database Task Group’, which used databases among a group, and it allowed them to use it daily. In the late 1970s SQL came about and stands for a standardized query language. It was used to code databases and make queries, which took the information from the databases and joined tables together to make them simpler to use and show the relationship between the various tables.

Database system design can be extremely time-consuming as it takes sophisticated software to create and control it. The design process becomes less user-friendly as it takes a more extensive knowledge of how to use it. The standard of an excellent database is one, which is complete, integral, simple, understandable, flexible and

The idea of relational database was first introduced by E.F.Codd at IBM in 1970. It is a kind of computer database in which data is stored in Relations and is represented in the form of tables with rows and columns. Databases can vary in sizes, ranging from very small and simple to very large and complex ones. Database users can access the data practically in an unlimited number of ways. Relational databases help in finding the information in a quick and efficient manner that one is looking for.Today many popular databases use the model of relational database.

A relational database Management system (RDBMS) is the physical and logical implementation of a relational

The database is a collection of related data that is organized in some way so it can be accessed easily and can be managed & updated. Relational database management system (RDBMS) is DBMS system that is based on relational model. In this model, data is represented in tuples. The query is the type of request for the information from the database. Database report is the formatted result of the query & contains data for decision analysis & making. Decision support system is an information system that supports the decision-making activities of the business or an organization.

It has become hard to scale relational databases in the direction and to the degree needed to manage big data in a successful and less expensive way. Instead, a new system, known as “NoSQL” or “Not Only SQL”, has been created that makes the processing of terabytes and even petabytes of data possible (Paghy, “RDBMS to NoSQL”).

A relational database is a collection of data which organized into a set of tables that can be accessed in multiple ways without having to reorganize the tables’ oftenly.Relational Database was proposed by Edgar Codd around the time 1969.It has become prevalent for commercial applications. In the 20th century there were countless Relational Database System (RDBMS) take for instance: IBM.DB2 and Oracle.

.In this paper, we analyze the design choices that allowed modern scalable data management systems to achieve orders of magnitude higher levels of scalability compared to traditional databases. The challenge of building consistent, available, and scalable data management systems capable of serving petabytes of data for millions of users has confronted the data management research community as well as large internet enterprises. Current proposed solutions to scalable data management, driven primarily by prevalent application requirements, limit consistent access to only the granularity of single objects, rows, or keys, thereby trading off consistency for high scalability

The Relational database and the No SQL database are both appropriate database methods depending on the way they are being implemented and the purpose of the business for which they are being incorporated. However, both the database approaches have distinct wide variety of characteristics, based on which they can be compared and contrasted in the following way.

In this paper, we will review one of the graph database (Neo4j), which the graph database is part of the emerging technology that is called NoSQL and compared it with one of the traditional relational databases (MySQL). MySQL, it is being another name for Relational Databases and it has been used for a long time period until now. However, with the emergence of Big Data there was clearly a need for more flexible databases. Facebook 's Graph Search use Neo4j, a graph database, is an application which clearly displays how relationships need to be modeled in a more efficient and sophisticated manner than using conventional relational models. In this paper, we will make a comparison between MySQL and Neo4j based on the features like ACID, replication, availability and the language that is used in both of them.