Non-relational and relational databases

Relational database and non-relational differences

Relational database and non-relational differences: data consistency is different, data storage is different, and expansion is different.

1, data consistency is different

Non-relational databases generally emphasize the ultimate consistency of the data, but not as strong as ACID emphasizes the consistency of the data, read from a non-relational database may still be in an intermediate state of the data.

2, different data storage

The main difference between relational and non-relational databases is the way the data is stored. Relational data is naturally tabular, so it is stored in the rows and columns of a data table. Data tables can be stored collaboratively in relation to each other and it is also easy to extract data.

In contrast, non-relational data doesn’t fit into the rows and columns of a data table, but is grouped together in large chunks. Non-relational data is usually stored in datasets, like documents, key-value pairs, or graph structures. Your data and its characteristics are the primary influencing factor in choosing how to store and extract data.

3. Scale differently

Because the data is stored in relational tables, the performance bottleneck of the operation may involve a lot of tables, which all need to be improved by improving the performance of the computer to customer service. Although the SQL database has a lot of room for expansion, but eventually will certainly reach the upper limit of vertical expansion.

Common non-relational databases

1. MongoDB: It is the most famous NoSQL database. It is a document-oriented open source database.MongoDB is a scalable and accessible database. It is in c++.

MongoDB can also be used as a file system. JavaScript can be used as a query language in MongoDB. By using shardingMongoDB scales horizontally. It is useful in popular JavaScript frameworks.

2, Cassandra: is developed by Facebook for inbox search. cassandra is a distributed data storage system for processing large amounts of structured data. Typically, this data is distributed across many common servers.

Data storage capacity can also be added to keep your service online. you can easily accomplish this task. Since all nodes in the cluster are identical, there is no need to deal with complex configurations.

3. Redis: It is a key-value store. Moreover, it is the most famous key-value store.Redis supports some c++, PHP, Ruby, Python, Perl, Scala, etc. Redis is written in C language. Moreover, it is licensed under BSD.

Reference for the above: Baidu Encyclopedia-Database

Relational database and non-relational database difference?

1. Data is stored differently.