1.SQLServer
It can only run on windows without any openness, and the stability of the operating system is very important to the database. Windows9X series products are mainly desktop applications, and NTserver is only suitable for small and medium-sized enterprises. Moreover, the reliability, security and expansibility of windows platform are very limited. It is not tested like unix, especially when dealing with large databases.
2. Oracle
It can run on all major platforms (including windows). Fully support all industrial standards. Adopt a completely open strategy. Allow customers to choose the most suitable solution. Give full support to developers.
3.SybaseASE enzyme
It can run on all major platforms (including windows). However, due to the low integration between early Sybase and OS, versions below 1 1.9.2 need more OS and DB patches. In the multi-platform mixed environment, there will be some problems.
4.DB2
It can run on all major platforms (including windows). Most suitable for massive data. DB2 is the most widely used enterprise. In the world's 500 largest enterprises, almost 85% use DB2 database server, while in China, the figure of 1997 is only 5%.
Second, scalability and parallelism.
1.SQLserver
Parallel implementation and * * * storage model are immature, so it is difficult to handle the increasing number of users and data, and its scalability is limited.
2. Oracle
Parallel server expands the capability of windownt by making a group of nodes share the work in the same cluster, and provides a cluster solution with high availability and high scalability. If windowsNT can't meet the needs, users can migrate the database to UNIX. Oracle's parallel server is highly integrated with the cluster mechanism of various UNIX platforms.
3.SybaseASE enzyme
Although there is a DBSWITCH to support its parallel server, the DBSWITCH is not mature in technology and only supports 12.5 version of ASESERVER. DBSWITCH technology needs a server to act as a switch, which brings some troubles in hardware.
4.DB2
It has good parallelism. DB2 extends database management to parallel and multi-node environments. Database partition is a part of the database, which contains its own data, indexes, configuration files and transaction logs. Database partitioning is sometimes called node security.
Third, safety certification.
1.SQLserver
No security certificate has been obtained.
2.OracleServer
Obtain the ISO standard certification with the highest certification level.
3.SybaseASE enzyme
Obtain the ISO standard certification with the highest certification level.
4.DB2
Obtain the ISO standard certification with the highest certification level.
Fourth, performance.
1.SQLServer
Poor performance in multi-user environment
2. Oracle
The performance is the highest, keeping the world records of TPC-D and TPC-C under the open platform.
3.SybaseASE
The performance is close to SQLServer, but the concurrency on UNIX platform is better than SQLServer.
4.DB2
High performance is suitable for data warehouse and online transaction processing.
Verb (abbreviation for verb) client support and application mode
1.SQLServer
C/S structure, only supports windows customers, and can connect ADO, DAO, OLEDB and ODBC.
2. Oracle
Multi-level network computing supports a variety of industrial standards and can be connected with network customers such as ODBC, JDBC and OCI.
3.SybaseASE
C/S structure, you can use ODBC, Jconnect, Ct-library and other network customers to connect.
4.DB2
Cross-platform, multi-layer structure, support ODBC, JDBC and other customers.
Sixth, the operation is simple.
1.SQLServer
Simple operation, but only graphical interface.
2. Oracle
It is complicated, and provides both GUI and command line. The operation is the same under windowsNT and unix.
3.SybaseASE
More complex, providing both GUI and command line. However, the GUI is poor and often not timely. Command line is recommended.
4.DB2
The operation is simple, and both GUI and command line are provided. The operation under windowsNT and unix is the same.
Seven. Use risk
1.SQLserver
Completely rewritten code has been tested for a long time and delayed constantly, and many functions need time to prove. Not quite in tune.
2. Oracle
Long-term development experience, fully backward compatible. It has been widely used. There is no risk at all.
3.SybaseASE enzyme
Backward compatibility, but ct-library program is not conducive to transplantation.
4.DB2
It is widely used in giant enterprises and has good downward compatibility. The risk is small.