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

1. Background and questions

Microsoft SQL Server is a commercial database, which requires a fee. The fee overview is as follows:

The question is: is it worth buying and using Microsoft SQL Server licenses? Especially in the software industry where open source software prevails. Open source software is generally free, and MySQL is the most widely used open source relational database, which costs as follows:

2. Classification and comparison

At present, the database is mainly divided into relational database and non-relational database, and the latter can be further subdivided into NoSQL database and distributed database, commercial database and free database according to charging method, open source database and closed source database according to open source, real-time database and non-real-time database according to real-time application.

Microsoft SQL Server is a commercial, closed source, non-real-time, relational database, Microsoft SQL Server hereinafter referred to as MSSQL.

MSSQL is often compared with ORACLE, and they are both commercial relational databases.

MSSQL is also often compared with MySQL, both of which are relational databases, but MySQL is an open source database, originally free, and now charges a small fee.

MSSQL is also often compared with NoSQL. NoSQL generally refers to a non-relational database, and a typical example of a non-relational database is MongoDB, so MongoDB is often used instead of NOSQL and MSSQL.

The following table compares MSSQL, ORACLE, MYSQL, and MONGODB:

Entry

MSSQL

ORACLE

MYSQL

MONGODB

Whether to charge or not

Yes

Yes

Yes (a small license fee)

No

Whether SQL is supported

Yes (T/SQL)

Yes (PL/SQL)

Yes

No

Is it widely used?

Yes

Yes

Yes

Yes

Expandability

High

Very high

Lower

Very low

Security.

High

Very high

Lower

Very low

Availability (cluster)

High

Very high

High

Low

OLAP (online Analytical processing)

Support

Support

Not supported (additional plug-ins)

Not supported (additional plug-ins)

OLTP (online transaction processing)

Support

Support

Support

Not supported (additional plug-ins)

Standard

SQL-92

SQL-92

SQL-92

Not supported

Access interface

ODBC 、 JDBC 、 OLE DB 、 Native Client

ODBC 、 OLE DB 、 OCI/C 、 OCI/C++

Connector/C 、 Connector/C++ 、 Connector/J 、

Connector/NET 、

Connector/ODBC 、 Connector/Python 、 PHP

Node-JS

The summary is as follows:

(1) MSSQL, ORACLE and MYSQL are more suitable for traditional services, while MongoDB is more suitable for Internet services.

(2) the price of ORACLE is expensive, the price of MSSQL is moderate, and the charge of MySQL is low.

3. Optional path

Based on the above, the options are:

(1) use MSSQL

Commercial relational database is very suitable for traditional business, the main advantage is easy to maintain, the disadvantage is that it needs more fees.

MSSQL Standard Edition costs US $3717 per core. Suppose you rent a CPU with four cores as a database server at a cost of US $14868. The actual domestic price needs to consult Microsoft, which may be lower than this value.

(2) use MySQL

Open source relational database is very suitable for traditional business, the main advantage is that its user base is very large, open source, low fees, the disadvantage is that it is not easy to maintain, the stability is worse than MSSQL, often use clusters to improve the overall stability.

If the business system is not open source, you cannot use the free version of the MySQL community.

MySQL Standard Edition requires an annual fee of US $2000. The actual domestic price needs to consult oracle, which may be lower than this value.

Using MYSQL will involve a certain amount of additional work, which may include:

* replace the database access interface

Estimate: 1 person-month

* write MYSQL database build scripts

Estimate: 1 person-month

* find and convert incompatible structures and data

Estimate: 1 person-month

* regression test

Estimate: 1 person-month

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.