Compare SQL Server with Oracle, DB2 database Some knowledge _ database other

Open
SQL Server
can only run on Windows, without the slightest openness, and the stability of the operating system is 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 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.
DB2
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 immature. 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. The
DB2
DB2 has 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
does not obtain any security certificates.
Oracle Server
obtains the highest certification level of ISO Standard certification.
DB2
Obtains the highest certification level of ISO Standard certification.

Performance
SQL Server
Multiuser performance
Oracle
has the highest performance, keeping the world record of tpc-d and Tpc-c under WindowsNT.
DB2
is high performance for data warehousing and online processing. Client support and Application mode.
SQL Server
C/S structure, which only supports Windows customers and can be connected using ADO,DAO,OLEDB,ODBC.
Oracle
Multi-level Network computing that supports a wide range of industry standards and can be connected to network clients such as ODBC,JDBC,OCI.
DB2
Cross-platform, multi-tier architecture to support customers such as ODBC,JDBC. The
easy Operation
SQL Server
operation is simple, but only the graphical interface.
Oracle
is more complex, providing both GUI and command lines, and operates the same under Windows NT and UNIX. The
DB2
operation is simple, provides both GUI and command lines, and operates the same under Windows NT and UNIX.
uses code that is completely rewritten with risk
SQL Server
, which has undergone lengthy testing and delays, and many features take time to prove. Not very compatible with early products. Use requires a certain risk.
Oracle
has a long history of development and is fully backward compatible. has been widely used. There is no risk at all.
DB2
is widely used in mega-enterprises and has a good backward compatibility. Small risk