Comparison of NoSQL Databases and Traditional SQL Databases

By



TABLE OF CONTENTS

CHAPTER 1: INTRODUCTION1

Structured Query Language (SQL)1

NoSQL Database2

Problem Statement2

Research Aims and Objectives3

Research Questions3

CHAPTER 2: LITERATURE REVIEW4

Advantages of SQL4

Disadvantages for SQL database4

Scalability4

Complexity5

Advantages of NoSQL5

Following are the advantages of NoSQL:5

No schema required:5

Auto elasticity5

Integrated caching:6

Speed comparison6

CHAPTER 3: METHODOLOGY7

WORKS CITED8

CHAPTER 1: INTRODUCTION

Traditional data management technologies originated and grew from the business domain, and they are facing many challenges from other domains. Data structures in databases are becoming more and more complex and data query functions are moving from the back-end database level towards the front-end user-interface level. Traditional query languages such as SQL, OQL, and form-based query interfaces cannot fully meet the needs today.

Relational database is also known as SQL data base, and relational database utilizes relations and these relations are shown in the forms of the tables fro storing of the data. The relational database uses some vernacular characteristics for matching the data from the data set. The table of relational database is divided in the form of rows and columns.

Structured Query Language (SQL)

Structured Query Language (SQL) is the most popular query language used to create, modify and retrieve data from relational DBMS. It is a set-based, declarative computer language rather than an imperative language. SQL standard has been established by ANSI (American National Standards Institute) and ISO (International Standards Organization) in 1986 and 1987. It has gone through a number of revisions. Most current relational database managing systems implement SQL2 standard, and a lot of the expanded features of SQL3 have yet to be implemented by some DBMS vendors. It is the language which is standard and this language is used for the database access, and manipulation of the databases. This is used for managing data which is in the relational database. The best example of SQL is Microsoft SQL; this is employ for storing and keeping the data in the forms of applications. An example of connecting a local application directly to a remote database over the Internet is to use the MySQL client connecting over the MySQL port using SSL to a remote MySQL server

NoSQL Database

While traditional relational databases base their operation on tables, joins and ACID transactions. NoSQL databases are storage systems, and databases do not require a data structure in the form of tables and relationships between them (do not impose a pre-set schedule of tables). That is the reason it is more flexible, as by using this system tends to store information in other formats such as key-value (similar to hash tables), Mapping Columns, Documents, or graphs.

The main characteristic of NoSQL databases is that it designs to handle massive amounts of information very quickly. This usually store all the information in memory (using the disk as a mere tool of persistence), and are prepared to scale horizontally without compromising performance. They tend to work quite well on low cost hardware (PC's ordinary), and allow scaling out by adding new machines (ideally without having to restart).

Problem Statement

The world is moving towards globalization with increasing ...