Compare SQL Server with Oracle, DB2_ Database Digest

It is very important to develop database applications and choose a good database. This article compares SQL Server with Oracle, DB2 three kinds of database from some aspects, provides some reference for you to choose the database.

Open

SQL Server
Can only run on Windows, without the slightest openness, the stability of operating system systems is very important to the database. Windows9x Series products are focused on desktop applications, NT server only for small and medium enterprises. And the reliability, security, and scalability of Windows platforms are very limited. It is not as time-tested as UNIX, especially when it comes to dealing with the critical business of large amounts of data.

Oracle
Can be run on all major platforms (including Windows). Full support for all industrial standards. Adopt a fully open policy. Enables customers to choose the solution that best suits them. Full support to developers.

Dbz
Can be run on all major platforms (including Windows). Most suitable for mass data. DB2 is the most widely used enterprise class, and almost 85% of the world's 500 largest companies use DB2 database servers, while the country accounts for about 5% of the 97.

scalability, parallelism

SQL Server
Parallel implementation and coexistence models are not mature. It is difficult to handle the increasing number of users and data volumes. Scalability is limited. Oracle Parallel Servers Extend Window NT's capabilities by enabling a set of nodes to share work in the same cluster, providing high-availability and highly scalable clusters of solutions. If WindowsNT does not meet the needs, users can move the database to UNIX.

DB2
DB2 has a good parallelism. The DB2 extends the database management to the parallel, multi-node environment. A database partition is a part of a database that contains its own data, indexes, configuration files, and transaction logs. A database partition is sometimes called a node or a database node.

Security

SQL Server
No security certificate was obtained.

Oracle Server
Obtain the highest certification level ISO standard certification.

DB2
Obtain the highest certification level ISO standard certification.

Performance
SQL Server
Poor performance when multiuser

Oracle
The highest performance, keeping windowsnt under the tpc-d and Tpc-c world records.

DB2
Suitable for Data warehouse and online things processing, high performance. Client support and Application mode.


SQL Server
c/S structure, only support Windows customers, you can connect with ADO,DAO,OLEDB,ODBC.

Oracle
Multi-level network computing, supporting a variety of industrial standards, can be used ODBC,JDBC,OCI and other network clients to connect.

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

Easy to operate

SQL Server
Simple to operate, but only graphical interface.

Oracle
is more complex, providing both GUI and command lines, and operates the same under Windows NT and UNIX.

DB2
Simple to operate, provide both GUI and command lines, and operate the same under Windows NT and UNIX.

Use risk

SQL Server
Full rewrite of the code, experienced a long period of testing, continuous delay, many features need time to prove. Not very compatible with early products. Use requires a certain risk.

Oracle
Long-time development experience, completely backward-compatible. has been widely used. There is no risk at all.

DB2
It is widely used in mega-enterprises and has good backward compatibility. Risk is small.