Oracle, MYSQL, SQL Server comparison

1. Price

mysql: cheap (partly free): Currently, MYSQL uses dual authorization (duallicensed), which is a commercial license agreement developed by the GPL and Mysqlab. If you use MySQL in a free (open source) project that follows the GPL, you can use MySQL free of charge under the GPL protocol. Otherwise, you will need to purchase the commercial license agreement established by Mysqlab. Windows $200,unix or Linux self-installing is free. Unix or Linux third-party installation.

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

Oracle: more expensive. Oracle 10g//11g Standard Edition [10 Users]￥25600;oracle 10g//11g Standard Edition [1CPU Unlimited users]￥157600;oracle 10G//11g Enterprise Edition [25 users]￥213500;oracle 10G//1 1G Enterprise Edition [1CPU Unlimited user]￥276000.

2. Platform and Software support

Mysql: Various platforms, often paired with Linux; PHP programs generally prefer to use MYSQL:P hp+mysql+linux
SQL Server: can only execute on the Windows platform, the. NET program support is better, for the general application is enough. Basically, there is very little use of database products other than SQL Server in the. NET camp:. net+sqlserver+windows
Oracle: Supports most platforms, but under Windows performance is less expensive than SQL Server, so it is generally used under UNIX or Linux. Generally used to develop large-scale applications (such as distributed), the development of the language is Java, C + + and so on.

3. Execution speed

Sqlserver>mysql>oracle at Tens when under Windows, Oracle is the fastest in billions of levels.

4. Applicable system

MYSQLOLTP, the difference between performance and Oracle is not very large. The relative lack of OLAP, Oracle and MSSQL in OLTP in the OLAP aspects of performance.

5. Ability to expand

MySQL native distributed architecture has the advantage of concurrent support, but the delay problem has been widely criticized. So most of the scenes are human flesh distributed split, but its replication characteristics and consistency constraints compared to Oracle weak, so that its architectural flexibility is very high.

Oracle has a number of architectural constraints due to its high consistency requirements. Cause its expansion costs are relatively high.

MSSQL has no Oracle-corresponding RAC capability.

6. Business Support

MySQL There are commercial service support, but the document is relatively simple and includes less content.

Oracle with the SQL Server commercial software, full range of business services support. Hundreds of manual support for this document, almost covering all the content.

7. Interface operability

            early microsoft SQL Server The interface operation is easiest to use, and it does not require too many settings to be able to do it. However, in oracle 11g mysql should be the most difficult to use in interface operations.