Comparison between Oracle, MySql, and SQL Server

1. Price

MySql: Cheap (partially free): currently, MySQL uses DualLicensed, a commercial license agreement developed by GPL and MySQLAB. If you use MySQL in a free (Open Source) project that complies with GPL, you can follow the GPL protocol to use MySQL for free. Otherwise, you need to purchase the commercial license agreement developed by MySQLAB. Windows $200, Unix or Linux installation free of charge,. Unix or Linux third-party installation $200.

SQL Server: Moderate. SQL 2008 Standard Edition: [1CPU unlimited user R2 version] ￥31900 [R2 5 Users] ￥5500 SQL 2008 Enterprise Edition: [1CPU unlimited user R2 version] ￥143800 [R2 10 users] ￥25400

Oracle:More expensive. oracle 10G // 11G standard edition [10 users] ￥25600; Oracle 10G // 11G standard edition [1 CPU unlimited user] ￥157600; oracle 10G // 11G enterprise edition [25 users] ￥213500; Oracle 10G // 11G enterprise edition [1 CPU unlimited user] ￥276000.

2. Platform and software support

Mysql:Various platforms are often used with Linux. Generally, php programs prefer mysql: PHP + MySql + Linux.
SQL Server:It can only run on the Windows platform. It provides better support for. net programs and is sufficient for general applications. Basically, database products other than SQL Server are rarely used in the. net camp:. net + SQL SERVER + windows
Oracle: Most platforms are supported, but the performance in windows is lower than that in SQL Server and the price is higher, so it is generally used in unix or linux. It is generally used to develop large-scale applications (such as distributed applications). Most of the development languages are java and C ++.

3. Running Speed

In windows, SQL Server> mysql> oracle is the fastest in hundreds of millions of data records.

4. Applicable Systems

The performance of MySQLOLTP players is not very different from that of oracle players. In terms of OLAP, Oracle and MSSQL have excellent performance in OLTP and OLAP.

5. scalability

The advantage of the native distributed architecture of MySQL is concurrency support, but the latency issue has been widely criticized. Therefore, distributed splitting is implemented in most scenarios. However, the Replication feature and consistency constraints are weaker than those of Oracle, making the architecture highly flexible.

Due to its extremely high consistency requirements, Oracle has many restrictions on the architecture. As a result, the expansion cost is much higher.

MSSQL does not have the corresponding Oracle RAC function.

6. Business Support

MySQL supports commercial services, but the documentation is relatively simple and contains less content.

Oracle and SQL Server commercial software, a full set of commercial service support. Supports hundreds of documents and covers almost all content.

7. Interface operability

Early Microsoft SQL Server Interface operations are the easiest to use, and you can perform operations without too many settings. However, in Oracle 11g, the interface is quite simple, and few parameters need to be adjusted. MySQL should be the most difficult to use in interface operations.