1. Relational Database :
RDBMS stands for Relational Database Management Systems. It is most popular database. In it, data is store in the form of row that is in the form of tuple. It contain numbers of table and data can be easily accessed because data is store in the table. This Model was proposed by E.F. Codd.
2. NoSQL :
NoSQL Database stands for a non-SQL database. NoSQL database doesn’t use table to store the data like relational database. It is used for storing and fetching the data in database and generally used to store the large amount of data. It supports query language and provides better performance.
Difference between Relational database and NoSQL :
|It is used to handle data coming in low velocity.||It is used to handle data coming in high velocity.|
|It gives only read scalablity.||It gives both read and write scalablity.|
|It manages structured data.||It manages all type of data.|
|Data arrives from one or few locations.||Data arrives from many locations.|
|It supports complex transactions.||It supports simple transactions.|
|It has single point of failure.||No single point of failure.|
|It handles data in less volume.||It handles data in high volume.|
|Transactions written in one location.||Transactions written in many locations.|
|Deployed in vertical fashion.||Deployed in Horizontal fashion.|
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.
- Difference between Relational Algebra and Relational Calculus
- Difference between Tuple Relational Calculus (TRC) and Domain Relational Calculus (DRC)
- Difference between CouchDB and Relational Database
- Apache Cassandra (NOSQL database)
- Cassandra (NoSQL) Database
- Difference between Database Administrator (DBA) and Database Engineer
- Difference between Centralized Database and Distributed Database
- Difference between SQL and NoSQL
- Difference between Oracle NoSQL and Oracle
- Violation of constraints in relational database
- Constraints on Relational database model
- How to pre populate database in Android using SQLite Database
- Difference between Relational operator(==) and std::string::compare() in C++
- Difference between E-R Model and Relational Model in DBMS
- Difference between Relational model and Document Model
- Difference between Hierarchical and Relational data model
- Difference between Network and Relational data model
- Difference between Hierarchical, Network and Relational Data Model
- Introduction to NoSQL
- NoSQL Data Architecture Patterns
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to firstname.lastname@example.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.