Compare SQL Server, Oracle, and DB2

Compare SQL Server, Oracle, and DB2

 

I. Openness:

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 key businesses with large data volumes.

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.

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

SQL Server DB2
The parallel implementation and coexistence model are not mature. It is difficult to process the increasing number of users and data volumes.
Limited scalability.

Oracle
The Parallel Server expands the function of the DRDs instance by allowing a group of nodes to share the work of the same cluster and provides a cluster solution with high availability and scalability.
If Windows NT cannot meet your needs, you can move the database to Unix.

DB2
Good concurrency.
Extends 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 nodes or database nodes.

 

Iii. Security

SQL Server
No security certificate is obtained.

Oracle Server
Obtain the highest level of ISO certification.

DB2
Obtain the highest level of ISO certification.

 

Iv. Performance

SQL Server
Performance is poor for multiple users.

Oracle
The highest performance, keeping world records of TPC-D and TPC-C under Windows NT.

DB2
Applicable to data warehouses and online transaction processing.
High performance.

 

V. Client Support and Application Mode

SQL Server
The C/S structure only supports Windows users. You can use ADO, Dao, oledb, and ODBC to connect.

Oracle
Multi-layer network computing, supporting a variety of industrial standards, can be connected by network customers such as ODBC, JDBC, OCI

DB2
Cross-platform, multi-layer structure, support for ODBC, JDBC, etc.

 

Vi. Easy to operate

SQL Server
Simple operation, but only graphic interface.

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

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

SQL Server
Completely rewrittenCode, Has been tested for a long time, and is constantly delayed. Many features require time to prove.
Not very compatible with earlier products.
Use requires a certain risk.

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

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