Comparison of four major databases

I. Openness

1. SQL Server

It can only run on windows without any openness. The stability of the operating system is very important to the database. The Windows9x series products focus on desktop applications, and the NT Server is only suitable for small and medium enterprises. In addition, the reliability, security, and scalability of the Windows platform are very limited. It is not as tested as UNIX, especially when dealing with large databases.

2. Oracle

Can run on all major platforms (including windows ). Fully supports all industrial standards. Adopt a fully open policy. Customers can select the most suitable solution. Provide full support to developers.

3. Sybase ASE

Can run on all major platforms (including windows ). However, due to the low integration level between Sybase and OS in earlier versions, versions earlier than version11.9.2 require a large number of OS and DB-level patches. In a multi-platform hybrid environment, some problems may occur.

4. DB2

Can run on all major platforms (including windows ). It is most suitable for massive data volumes. DB2 is the most widely used in enterprise-level applications. Of the 500 largest enterprises in the world, almost 85% of them use DB2 database servers, and about 5% in China to 97 years.

Ii. scalability and concurrency

1. SQL Server

The parallel implementation and coexistence model is not mature, and it is difficult to process the increasing number of users and data volumes, with Limited scalability.

2. Oracle

The parallel server enables a group of nodes to share the work of the same cluster to expand the capabilities of the windoupstream, providing high-availability and high-scalability cluster solutions. If WindowsNT cannot meet your needs, you can move the database to Unix. The Parallel Server of Oracle has a high degree of integration with the cluster mechanism of Various UNIX platforms.

3. Sybase ASE

Although dB switches support their parallel servers, DB switches are not yet mature at the technical level and only support ASE servers with Versions later than 12.5. DB switch technology requires a server to act as a switch, which brings some hardware troubles.

4. DB2

Good concurrency. DB2 expands database management to a parallel, multi-node environment. Database partitioning is a part of a database that contains its own data, indexes, configuration files, and transaction logs. Database partitions are sometimes called node security.

Iii. Security Authentication

1. SQL Server

No security certificate is obtained.

2. Oracle Server

Obtain the highest level of ISO certification.

3. Sybase ASE

Obtain the highest level of ISO certification.

4. DB2

Obtain the highest level of ISO certification.

Iv. Performance

1. SQL Server

Poor performance when multiple users

2. Oracle

Highest performance, keeping world records of TPC-D and TPC-C under open platform.

3. Sybase ASE

The performance is similar to that of SQL Server, but the concurrency on the UNIX platform must be better than that on SQL Server.

4. DB2

High performance is suitable for data warehouses and online transaction processing.

V. Client Support and Application Mode

1. SQL Server

C/S structure, only supports windows customers, can be connected using ADO, Dao, oledb, ODBC.

2. Oracle

Multi-layer network computing supports multiple industrial standards and can be connected by network customers such as ODBC, JDBC, and OCI.

3. Sybase ASE

The C/S structure can be connected by network customers such as ODBC, jconnect, and CT-library.

4. DB2

Cross-platform, multi-layer structure, supporting ODBC, JDBC, and other customers.

Vi. Easy to operate

1. SQL Server

Simple operation, but only graphic interface.

2. Oracle

Complex: provides both GUI and command lines, and operates the same way in WindowsNT and UNIX.

3. Sybase ASE

Complex: provides both GUI and command lines. However, the GUI is poor and often cannot be in a timely manner. We recommend that you use the command line.

4. DB2

It is easy to operate and provides both GUI and command line. The operation is the same in WindowsNT and UNIX.

VII. Use risks

1. SQL Server

The Code that has been completely rewritten has undergone long-term tests and is constantly delayed. Many features require time to prove. Not very compatible.

2. Oracle

Long development experience is fully backward compatible. It is widely used. There is no risk at all.

3. Sybase ASE

Backward compatible, but the CT-library program is not portable.

4. DB2

It is widely used in giant enterprises and has good downward compatibility. Low risk.

(T111)