Contents
Introduction 1
SQL database 1
Limitations of SQL database 2
NoSQL database 2
Features of NoSQL 3
CAP Theorem (Consistency, Availability, Partition Tolerance) 4
Different Types of NoSQL Databases 4
NoSQL Challenges 5
Conclusion 6
Introduction
In this era where almost everything is based on web starting from e-shopping, websites etc, and millions to trillions of users are accessing the system (websites or business application) and due to huge number of users tremendous data size comes out on daily basis through all these Web based systems. A large section of these data is handled by RDMS (Relational Databases Management systems). The relational model is well-suited to client-server programming and today …show more content…
Below are important types of SQL databases:
• Oracle
• My SQL
• Postgres
• TeraData
•Main Focus of SQL database is ACID
•Atomicity –If one part of it fails, the entire transaction fails (and is rolled back)
•Consistency – Every transaction is subject to a consistent set of rules
•Isolation – No transaction should interfere with another transaction
•Durability – Once a Commit or Rollback is done transaction will be committed or rolled back
In the below example, we can experience the storing the information of a form into a SQL database table. The information taken from a form is written across a row in the database, each one field from the structure has its own particular section made in a table. Each row is stored as an individual unique record.
With the above design, it is not easy to hold data that changes columns. We should strictly couple the input-form to the database and everything in between, if we change one thing, we have to change it …show more content…
NoSQLbased systems are used in large databases which are prone to performance problems due to the relational structure of databases as the NoSQL databases do not use fixed schema structures and SQL Joins.It is also known as a scale out database.
Nosql databases are those databases that are non-social, open source, disseminated in nature and in addition it is having elite in a straight manner that is evenly versatile. Non-social database does not compose its information in related tables (i.e., information is put away in a non-standardized manner).NoSQL databases are open source. Distributed means data is spread to different machines and is managed by different machines so here it uses the concept of data replication.
Relational databases don’t scale our very well in a distributed system. It means when a relational databases grows out of one server, it is no longer that easy to use as earlier it was, whereas with the NoSQL databases the schema is defined by the developer at run time. In case of Nosql Database an API is use to get the data what they need instead of writing an SQL statements against the RDBMS.Scaling across different servers easily without knowing which server the data is required is an important feature of Nosql database.