Home > Database > Mysql Tutorial > body text

What are relational and non-relational databases? Introduction and comparison of two common types of databases

不言
Release: 2019-01-17 11:13:04
forward
6363 people have browsed it

This article brings you what are relational and non-relational databases? The introduction and comparison of two common types of databases has certain reference value. Friends in need can refer to it. I hope it will be helpful to you.

Relational database:

Oracle, DB2, Microsoft SQL Server, Microsoft Access, MySQL

Non-relational database:

NoSql, Cloudant, MongoDb, redis, HBase

The difference between the two databases:

Relational database

Characteristics of relational database

 1. Relational database refers to A database that uses relational model to organize data;

2. The biggest feature of relational database is transaction consistency;

3. Simply put, the relational model refers to the two-dimensional table model, and a relational database is a data organization composed of two-dimensional tables and the connections between them.

Advantages of relational database

1. Easy to understand: The two-dimensional table structure is very close to the logical world Concepts, relational models are easier to understand than other models such as network and hierarchical models;
2. Easy to use: The common SQL language makes it very convenient to operate relational databases;
3.Easy to maintain: Rich integrity (entity integrity, referential integrity and user-defined integrity) greatly reduces the probability of data redundancy and data inconsistency;
4. Supports SQL, can be used for complex queries.

Disadvantages of relational database

1. The huge price paid to maintain consistency is its poor read and write performance;
2. Fixed table structure ;
3. High concurrent reading and writing requirements ;
4. Highly efficient reading and writing of massive data;

Non-relational database

Features of non-relational database

1. Use the key Value pair stores data;
2. Distributed ;
3. Generally does not support ACID features;
4. Non-relational databases are strictly It is not a database, it should be a collection of structured data storage methods.

Advantages of non-relational database

1. No need to parse through the sql layer, reading and writing performance is very high;
2. Based on key-value pairs, the data has no coupling, is easy to expand;
3. The format of storing data: the storage format of nosql is key, value form, document form, picture form, etc. Document form, picture form, etc., while relational databases only support basic types.

Disadvantages of non-relational databases

1. Does not provide sql support, and the cost of learning and using is high;
2.No transaction processing, additional functions bi and report support are not good;

The above is the detailed content of What are relational and non-relational databases? Introduction and comparison of two common types of databases. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:cnblogs.com
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template