Openness

1.SQLServer

Can only run on windows, there is not the slightest openness, the stability of the operating system system is very important to the database. windows9X series products are biased towards desktop applications, NTserver is only suitable for small and medium-sized enterprises. And windows platform reliability, security and scalability is very limited. It is not as tried and tested as unix, especially when dealing with large databases.

2. Oracle

Can run on all major platforms (including windows). Fully supports all industry standards. Adopts a completely open strategy. Enables customers to choose the most suitable solution. Full support for developers.

3. SybaseASE

Can run on all major platforms (including windows). However, due to early Sybase's poor integration with OS, versions below VERSION 11.9.2 require more OS and DB level patches. This can be problematic in a mixed multi-platform environment.

4. DB2

Can run on all major platforms (including windows). The most suitable for massive data. DB2 is most widely used in the enterprise level, in the world's 500 largest enterprises, almost 85% of more than with DB2 database server, while the domestic to 97 years about 5%.

Two, scalability, parallelism

1.SQLserver

Parallel implementation and *** storage model is not mature, it is difficult to deal with the increasing number of users and data volumes, limited scalability.

2.Oracle

Parallel servers extend the capabilities of windowsNT by enabling a group of nodes to **** enjoy work in the same cluster, providing a solution for clustering with high availability and high scalability. If windowsNT does not meet the needs, users can move the database to UNIX. oracle's parallel server has a fairly high level of integration with the clustering mechanisms of various UNIX platforms.

3. SybaseASE

Although there is DBSWITCH to support its parallel server, but DBSWITCH in the technical level is not yet mature, and only supports version 12.5 or more of ASESERVER. DBSWITCH technology requires a server to act as a SWITCH, which in turn brings some trouble in the hardware.

4. DB2

With good parallelism. DB2 expands database management to a parallel, multi-node environment. A database partition is a part of the database that contains its own data, indexes, configuration files, and transaction logs. Database partitions are sometimes referred to as node security.

3. Security certificates

1. SQLserver

has not been granted any security certificates.

2. OracleServer

has been certified to the highest certification level, the ISO standard.

3. SybaseASE

Has received the highest certification level of ISO standards certification.

4. DB2

To obtain the highest certification level of ISO standards certification.

Four, performance

1.SQLServer

poor performance in multi-user

2.Oracle

highest performance, maintains the world record of TPC-D and TPC-C under the open platform.

3. SybaseASE

Performance is close to SQLServer, but concurrency is better than SQLServer on UNIX platforms.

4. DB2

Higher performance is suitable for data warehousing and online thing processing.

V. Client support and application modes

1. SQLServer

C/S structure, only supports windows clients, you can use ADO, DAO, OLEDB, ODBC connection.

2.Oracle

Multi-level network computing, support for a variety of industry standards, you can use ODBC, JDBC, OCI and other network clients to connect.

3. SybaseASE

C/S structure, can use ODBC, Jconnect, Ct-library and other network clients to connect.

4.DB2

Cross-platform, multi-tier structure, support for ODBC, JDBC and other customers.

Six, easy to operate

1.SQLServer

Simple to operate, but only the graphical interface.

2. Oracle

more complex, while providing GUI and command line, in windowsNT and unix under the same operation.

3. SybaseASE

more complex, providing both GUI and command line. But the GUI is poor, often can not be timely status, it is recommended to use the command line.

4.DB2

Simple operation, while providing GUI and command line, in windowsNT and unix under the same operation.

Seven, the use of risk

1.SQLserver

completely rewritten code, after a long period of testing, constant delays, many features need time to prove. Not very compatible.

2.Oracle

Long development experience, fully backward compatible. Widely used. No risk at all.

3. SybaseASE

Backwards compatible, but the ct-library program does not benefit from transplantation.

4. DB2

Widely used in giant enterprises, good backward compatibility. Risks are small.