The pros and cons of common relational database and its choice

Common relational databases are: IBM DB2, ORACLE, Sybase, SQL Server, MySQL, Access, today we focus on Oracel, SQL Server, MySQL three big database.

Oracle databases are designed for larger project development with complex business logic and large data volumes.

The SQL Server database features a comprehensive and efficient database platform for midsize enterprises or organizations. The disadvantage is that you can only run under Windows systems.

MySQL database is widely used in small and medium-sized websites on the internet. MySQL database is small, fast, low total cost of ownership, open source.

Pros and cons comparison

1. Openness

SQL Server: Can only run on Windows, without the slightest openness, the system stability of the operating system is very important to the database. (The reliability, security, scalability of the Windows platform is very limited)

ORACLE: Can be run on all major platforms.

DB2: Can be run on all major platforms. Most suitable for Yu Hai volume data.

2, scalability, parallelism

SQL Server: The parallel implementation and coexistence model is immature. It is difficult to handle an increasing number of users and data volumes. Limited scalability.

ORACLE: Parallel servers extend the capabilities of WINDOWNT by enabling a set of nodes to share work in the same cluster, providing solutions for high availability and highly scalable clusters.

DB2: It has good parallelism.

3. Security

SQL Server: No security certificate was obtained.

ORACLE: Obtains the highest certification level of ISO Standard certification.

DB2: Obtains the highest certification level of the ISO standard certification.

4. Performance

SQL Server: Poor performance for multiple users.

ORACLE: Highest performance, keeping the world record of tpc-d and Tpc-c under WindowsNT.

DB2: For database warehouse and online things processing, high performance.

5. Client Support and Application mode

SQL SERVER:C/S structure, supported only for Windows customers, can be connected with ADO, DAO, OLE DB, ODBC.

ORACLE: Multi-level network computing, supporting a variety of industry standards, can be used in ODBC, JDBC, OCI and other network customers connect.

DB2: Cross-platform, multi-layered structure, support ODBC, JDBC and other customers.

Note: The top ten letter features of SQL Server2016

The pros and cons of common relational database and its choice