What are the mainstream databases?

What are the mainstream databases?

The mainstream databases are:

1. MySQL

MySQL is a relational database management system developed by the Swedish MySQL AB company , a product of Oracle.

MySQL is one of the most popular relational database management systems. In terms of WEB applications, MySQL is one of the best RDBMS (Relational Database Management System) application software.

2. SQL Server

SQL Server is a relational database management system launched by Microsoft.

It has the advantages of ease of use, good scalability and high degree of integration with related software. It can be used across a variety of platforms ranging from laptops running Microsoft Windows 98 to large multi-processor servers running Microsoft Windows 2012. .

3. Oracle Database

Oracle Database is a relational database management system of Oracle Corporation.

It is a product that has always been in the leading position in the database field. The system has good portability, easy use and strong functions, and is suitable for various large, medium, small and microcomputer environments. It is a database solution with high efficiency, good reliability and adaptability to high throughput.

Types of databases

1. Relational database

Relational database, the storage format can intuitively reflect the relationship between entities. Relational databases are similar to common tables. There are many complex relationships between tables in relational databases. Common relational databases include Mysql, SqlServer, etc.

In lightweight or small applications, using different relational databases has little impact on the performance of the system. However, when building large applications, you need to choose the appropriate one based on the business needs and performance requirements of the application. Relational Database.

2. Non-relational database

Non-relational database refers to a distributed, non-relational data storage system that does not guarantee compliance with ACID principles. Non-relational database technology is closely related to CAP theory and consistent hashing algorithm.

The so-called CAP theory simply means that it is impossible for a distributed system to meet the three requirements of availability, consistency and partition fault tolerance. Meeting two requirements at once is the upper limit of the system.

Consistent hashing refers to a data algorithm that is usually generated to meet work needs during the application process of non-relational databases. This algorithm can effectively solve many work problems. But there are also disadvantages, that is, the quality of work completion will fluctuate with changes in nodes. When there are too many nodes, the related work results will not be so accurate.

For more programming related content, please pay attention to the Programming Introduction column on the php Chinese website!

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