The Importance Of A Relational Database Management System

Since 1960 and beyond the need for an efficient data management and retrieval of data has always been an issue due to the growing need in business and academia. To resolve these issues a number of databases models have been created. Relational databases allow data storage, retrieval and manipulation using a standard Structured Query Language (SQL). Until now, relational databases were an optimal enterprise storage choice. However, with an increase in growth of stored and analyzed data, relational databases have displayed a variety of limitations. The limitations of scalability, storage and efficiency of queries due to the large volumes of data [1] [2].

The wider insight about relational and non-relational database performance, particularly MySQL and Hadoop was gathered through the literature survey. By read textbooks, reviewing academic journals and research papers, I founded a gap in the performance of relational database compare to the non-relational.

Provide reasoning to support the use of the NoSQL database as the database of choice to solve the problem faced by TWC. Identify one strength and one weakness for each of the other three kinds of databases to solve the problem for TWC.

Abstract – With companies such as Facebook and Google producing large volumes of data, known as Big Data, the popularity of NoSQL databases has risen in the past decade as traditional relational databases cannot handle the vast amount of data as it was not designed to effectively manage such a large data collection. The following research paper gives an introduction to non-relational databases otherwise known as NoSQL. It defines what a NoSQL database is, the origins of its existence and the various types of NoSQL databases. It goes on to discuss the advantages and disadvantages of non-relational databases and the reason companies in the past decade are selecting to implement these databases over traditional relational databases.

Relational databases play a major role in making many apps and programs work. They provide an easy way to store large amounts of data in a consistent, non duplicating, and maintainable way to be used by developers for analytical or software use ("Advantages of a relational database", n.d.). However, more and more applications and companies with a tremendous amount of data such as search engines, social networks, and e-commerce sites have been requiring a level of speed and scalability that relational databases can not provide ("Why NoSQL?", n.d.). NoSQL is a name given to a quickly growing type of database known as non-relational databases, which are being used to store and manage huge amounts of structured, semi-structured, and non-structured data known as "Big Data" ("Why NoSQL?" n.d.). With the advent of social networks and apps with millions of users, the rate of growth of non-structured and semi-structured data is exponential, and the value in being able to quickly traverse it, analyze it, and use it for development is also growing quickly (McGuire, Manyika, & Chui, 2012).

The reality is, the IoT requires characteristics of both relational [6] and NoSQL databases; the flexibility of NoSQL, which allows different types of data to be stored, and the agility to adapt the underlying data models to specific business requirements and applications, and the data integrity aspects of the relational

Other Nosql and hybrid databases: Apart from the traditional databases and the Nosql databases various hybrid data stores have been introduced such as DEX, PNUTS and

Apache Cassandra is open source NoSQL database and it was found in Facebook. Cassandra 's data model offers the convenience of column indexes with the performance of log-structured updates. It provides horizontal scalability and the downtime is lesser compared to

Over many ago relational databases reside most of the data but after the introduction of NoSQL database had changed this procedure. Most of the unstructured data had been sent to NoSQL database. Relational database systems, which showed good performance before the birth of internet and cloud computing era is now unable to control the heat of new technologies. To stabilize this situation new requirements were set to design by RDBMS. To meet these challenges they need highly scalable and unstructured data model with high performance; so they choose NoSQL database (Muhammad Mughees, 2013).

NoSQL databases are a significant departure from the relational model that has dominated the business world for the past few decades. Standing for “Not Only SQL,” these products are all some variation of a non-relational, key-value pair database, and they are becoming very popular with companies that use Big Data and prioritize speed or availability over consistency of data.

Big data are grooming in reality. SQL does not have capacity to handle a very huge amount of data. All applications are now working in view to a vast volume of data. Data is increasing massively in almost all stream of jobs , let it be employee details or health records. So the applications being used to manage these type of data should be modified too. Not only the applications but the databases and warehouses where we store these data have to be modifies too. SQL can store data in different tables and databases but later it is very difficult task to retrieve the same as that will include loads of join operation and very multifaceted transactions. So in this paper we propose to build an application for hospital management and to handle patient health records . Our application uses a NoSQL database(i.e here we use mongodb) for storing and retrieving the data. We are implementing Mongo lab in our application deployment. Each record and its associated data will be stored in a single document thus simplifies the data access. Here, unlike SQL databases, the documents stored are schema free and similar to each other, this is a big advantage of NoSQL and helps in modelling unstructured data. We also use the tokenization concept to ensure security. We convert the user credentials like name, password, phone no, email id etc. into ASCII values and store it in separate mongo db. The patients’ medical history, lab reports, medicine prescription etc. will be stored in a separate Mongo

NoSQL databases are databases designed to run on clusters of computers/servers, built for the ever-increasing data storage needs for websites. Devised as a way of scaling databases horizontally which is a challenge with traditional relational databases. Scaling horizontally is the ability to add more computers/servers as nodes to a database. These “clusters” work well with write-heavy systems and allow increase storage and processing power limited only by the number of connections you can have on the network. Defined as No-Schema, No-SQL data structures mean they are not limited to the original data structure. Objects and fields etc can be implemented at

It is easier to compare no-SQL systems to the characteristics of traditional relational databases because they have evolved from them. No-SQL models can be characterised by:

NoSQL databases had made for unraveling the Big Data issue by utilizing a distributed system to bring out excellent performance in data storage and retrieval at very large-scale. At this scale, pieces of the system often fail and NoSQL is created to handle these failures (Chow, 2013) (Ron, Shulman-Peleg, & Bronshtein, 2015). Various companies have espouse different sorts of non-relational databases, ordinarily alluded to as

The modern RDBMS advancements are not capable of supporting unstructured information with ideal space necessity. The plan winds up plainly mind-boggling and is henceforth troublesome for designers. The requirement for unstructured information administration is so annoying with conventional RDBMS arrangements (Big data in financial services industry: Market trends, challenges, and prospects 2013 - 2018). Moreover, RDBMS turns out to be an exorbitant answer for creating light-footed web applications with direct information investigation necessities. NoSQL is developing as a proficient possibility in this situation, which connects the issues related with RDBMS innovation. The market development can credit to creative dispatches of NoSQL arrangements, and collective endeavors by NoSQL sellers and clients. The endeavors of organizations, to enhance their market offerings, are creating the request of NoSQL, as a back-end bolster (Big data in financial services industry: Market trends, challenges, and prospects 2013 - 2018). The emergence of agile software development is creating the demand for NoSQL (Big data in financial services industry: Market trends, challenges, and prospects 2013 - 2018). They offer users much more avenues to accept data in many different forms. NoSQL is adaptable as SQL but offers many more uses that can apply to many organizations.