Shulou(Shulou.com)06/03 Report--

What are the traditional relational databases? Many novices are not very clear about this. In order to help you solve this problem, the following editor will explain it in detail. People with this need can come and learn. I hope you can gain something.

Traditional relational database refers to the database that uses relational model to organize data, which stores data in the form of rows and columns, such as Oracle, DB2, PostgreSQL, Microsoft SQL Server, Microsoft Access, MySQL, tide K-DB and so on.

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

Relational database:

Relational model refers to two-dimensional table model, so a relational database is a data organization composed of two-dimensional tables and their relationships.

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

Non-relational databases:

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

NoSQL (Not only SQL) generally refers to non-relational databases. With the rise of the Internet web2.0 website, the traditional relational database has been unable to cope with the web2.0 website, especially the super-large-scale and highly concurrent SNS type web2.0 pure dynamic website, which has exposed many insurmountable problems, while the non-relational database has developed rapidly because of its own characteristics. The emergence of NoSQL database is to solve the challenges brought by large-scale data collection and multiple data types, especially the application problem of big data. Philippine relational database can build a fast and scalable repository for big data.

The difference between the two databases:

For relational databases

Characteristics of Relational Database

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

2. The most important feature of relational database is the consistency of transactions.

3. To put it simply, the relational model refers to the two-dimensional table model, and a relational database is a data organization composed of two-dimensional tables and their relationships.

Advantages of Relational Database

1. Easy to understand: 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, hierarchy and so on.

2. Easy to use: the general SQL language makes it very convenient to operate relational databases.

3. Easy to maintain: rich integrity (physical integrity, referential integrity, and user-defined integrity) greatly reduces the probability of data redundancy and data inconsistency

4. Support SQL, which can be used for complex queries.

Disadvantages of Relational Database

1. The huge price paid for maintaining consistency is its poor reading and writing performance.

2. Fixed table structure

3. High concurrent read and write requirements

4. Efficient reading and writing of massive data

For non-relational databases

Characteristics of non-relational database

1. Use key-value pairs to store data

2. Distributed

3. Generally, ACID is not supported.

4. Strictly speaking, non-relational database is not a kind of database, but a collection of structured data storage methods.

Advantages of non-relational database

1. There is no need to parse in the sql layer, and the read and write performance is very high.

2. Based on the key-value pair, the data is not coupled and is easy to expand.

3, storage data format: nosql storage format is key,value form, document form, picture form and so on, document form, picture form and so on, while relational database only supports basic types.

Disadvantages of non-relational database

1. Without sql support, the cost of learning and using is high.

2. No transaction processing, and poor support for additional functions such as bi and reports.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.