Comparison of four major databases (SQL Server, Oracle, Sybase and DB2)
This article invoked the company's database master. Pure personal opinion, for reference only.
1, openness
2, scalability, parallelism
3, safety
4, performance
5, client support and application mode
6, easy to operate
7, use risk
1, openness:
SQL Server
It can only be run on Windows, without the openness of openness, the stability of the operating system's system is important to the database. The Windows9x series products are biased on desktop applications, and NT Server is only suitable for small and medium-sized businesses. And the reliability, security and scalability of the Windows platform are very limited. It is not like UNIX, especially when dealing with key services in processing large data.
Oracle
Can run on all mainstream platforms (including Windows). Fully support all industrial standards. Using a fully open policy. You can make customers choose the most suitable solution. Find support for developers.
Sybase ASE
Can run on all mainstream platforms (including Windows). However, since the early Sybase and OS integration are not high, Version 11.9.2 The following versions require more OS and DB-level patches. In a multi-platform hybrid environment, there is a problem. Version 12.0 The above version has been improved.
DB2
Can run on all mainstream platforms (including Windows). Ultimate to massive data. DB2 is the most extensive application in enterprise-class applications, almost 85% of the world's largest enterprises, with DB2 database servers, while domestic to 97 years accounts for 5%.
2, scalability, parallelism:
SQL Server
Parallel implementation and coexistence models are not mature. It is difficult to handle increasing number of users and data volumes. Smalllability is limited.
Oracle
By sharing a set of nodes sharing the work in the same cluster to extend the ability of Windownt, providing high availability and highly scalability. If WindowsNT does not meet the needs, the user can move the database into UNIX. Oracle's parallel server has a fairly high integration of clustering mechanisms for various UNIX platforms.
Sybase ASE
Although there is DB Switch to support its parallel servers, since DB Switch is not mature in the technical level, it only supports ASE Server, which is 10.5 or more, because DB Switch technology requires a server to act as Switch, which will have some in hardware overhead. increase.
DB2
Has good parallelism. DB2 expands database management to parallel, multi-node environments. The database partition is part of the database, including your own data, index, profile, and transaction logs. Database partitions are sometimes referred to as nodes or database nodes.
3, security:
SQL Server
No security certificate is obtained.
Oracle Server
Get the highest certification level ISO standard certification.
Sybase ASE
Get the highest certification level ISO standard certification.
DB2
Get the highest certification level ISO standard certification.
4, performance:
SQL Server
Multi-user performance is poor
Oracle
The highest performance, maintains the world records of TPC-D and TPC-C under open platforms.
Sybase ASE
Performance is close to SQL Server. However, the concurrency in the UNIX platform is superior to SQL Server.
DB2
Performance is suitable for data warehouses and online processing.
5, 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 connected with network clients such as ODBC, JDBC, OCI.
Sybase ASE
The C / S structure can be connected to network clients such as ODBC, JCONNECT, CT-Library.
DB2 cross-platform, multi-layer structure, support ODBC, JDBC and other customers
6, easy to operate:
SQL Server
Simple operation, but only the graphical interface.
Oracle
More complex, also provide GUI and command line, the same operation under WindowsNT and UNIX
Sybase ASE
More complex while providing the GUI and command line. But GUI is poor, often unable to be timely, it is recommended to use the command line.
DB2
Simple operation, but also provide the GUI and command line, the same as the WindowsNT and UNIX
7, use risk:
SQL Server
The code completely rewritten has experienced long-term testing, continuous delays, and many functions take time to prove. It is not very compatible with early products. Use needs to take a risk.
Oracle
Long-term development experience is fully compatible. Get a wide range of applications. There is no risk at all.
Sybase ASE
It is compatible down, but the CT-Library program is not intended to transplant.
DB2
Giant businesses have been widely used, which is compatible downward. low risk.
After the above comparison, we don't really find that DB2 is the best database.
Li Shouliang sorted out SLLI@founder.com.cn
2003-3-26
