What are the traditional relational databases?

Traditional relational database refers to a database that uses a relational model to organize data. It stores data in the form of rows and columns. Common ones include Oracle, DB2, PostgreSQL, Microsoft SQL Server, Microsoft Access, MySQL, and Inspur. K-DB and other databases.

#What are the common relational databases and non-relational databases?

Relational database:

The relational model refers to the two-dimensional table model, so a relational database is a data organization composed of two-dimensional tables and the relationships between them.

Common ones include: Oracle, DB2, PostgreSQL, Microsoft SQL Server, Microsoft Access, MySQL, Inspur K-DB, etc.

Non-relational databases:

Common ones include : NoSql, Cloudant, MongoDB, redis, HBase

NoSQL (Not only SQL), generally refers to non-relational databases. With the rise of Internet web2.0 websites, traditional relational databases have become unable to cope with web2.0 websites, especially ultra-large-scale and high-concurrency SNS type web2.0 pure dynamic websites, exposing many insurmountable problems. Non-relational databases have developed very rapidly due to their own characteristics. NoSQL databases were created to solve the challenges brought by large-scale data collections and multiple data types, especially big data application problems. Philippine relational databases can create fast, scalable repositories for big data.

The difference between the two databases:

For relational database

Characteristics of relational database

1. Relational database, It refers to a database that uses a relational model to organize data;

2. The biggest feature of a relational database is the consistency of transactions;

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

Advantages of relational database

1. Easy to understand: the two-dimensional table structure is a concept very close to the logical world, and the relational model is easier to understand than other models such as mesh and hierarchy;

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 and 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;

For non-relational databases

Non-relational databases Features

1. Use key-value pairs to store data;

2.Distributed;

3. Generally does not support ACID features;

4. Non-relational database is not strictly a database, but a collection of structured data storage methods.

Advantages of non-relational database

1. No need to parse through the sql layer, high read and write performance;

2. Based on key-value pairs, the data has no coupling , 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 database only supports Base type.

Disadvantages of non-relational database

1. No SQL support is provided, and the cost of learning and use is high;

2. No transaction processing, additional functions bi and reports, etc. Support is not good either

The above is the detailed content of What are the traditional relational databases?. For more information, please follow other related articles on the PHP Chinese website!