Fifth, client support and application mode 1. SQL Server C / S structure, only support windows clie

An openness 1. SQL Server runs only on windows, without the slightest opening, stable operating system for the database is very important. Windows9X series is the emphasis on desktop applications, NT server is only suitable three way catalyst for small and medium three way catalyst enterprises. And windows platform reliability, security and scalability is very limited. It is not as proven as unix, especially when dealing with large databases. 2. Oracle can run on all major platforms (including windows). Fully supports all industry standards. A fully open strategy. Allows customers to choose the most appropriate solution. Full support for developers. 3. Sybase ASE to run on all major platforms (including windows). However, due to the early Sybase and OS integration is not high, so VERSION11.9.2 following versions require more OS and DB level patches. In a mixed environment multi-platform, there will be some problems. 4. DB2 can run on all major platforms (including windows). The most suitable for mass data. DB2 is the most widely used enterprise level in the global 500 largest enterprises, almost 85% with DB2 database server, and domestic to 97 years accounted for about 5%. Second, scalability, parallelism 1. SQL server parallel implementation and coexistence model is not mature, very difficult to deal with the increasing number of users and data volumes, limited scalability. 2. Oracle Parallel Server by making a set of nodes in the cluster three way catalyst share the same work to expand the capacity windownt, providing high availability and highly scalable cluster solution. If windowsNT not meet the needs, the user can move the database to UNIX. Oracle Parallel Server cluster mechanism of various UNIX platforms have a very high degree of integration. 3. Sybase ASE Although DB SWITCH to support its Parallel Server, DB SWITCH at the technical level but not yet mature, and only supports version 12.5 or more ASE SERVER. DB SWITCH technology requires a server to act as SWITCH, so bring some trouble in hardware. 4. DB2 has good parallelism. DB2 database management expanded to the parallel, three way catalyst multi-node environment. Database partition is part of a database that contains its own data, indexes, configuration files, and transaction logs. Database partition is sometimes called nodes security. Third, the safety certification 1. SQL server does not receive any security certificate. 2. Oracle Server highest level of ISO standards. 3. Sybase three way catalyst ASE highest level of ISO standards. 4. DB2 highest level of ISO standards. Fourth, the performance of a poor performance 2. Oracle's highest performance when multi-user SQL Server., Maintaining an open platform for the world record TPC-D and TPC-C's. 3. Sybase ASE performance is close to SQL Server, but in the UNIX platform to be excellent three way catalyst concurrency and SQL Server. 4. DB2 higher performance for data warehousing and online transaction processing.
Fifth, client support and application mode 1. SQL Server C / S structure, only support windows client, you can use ADO, DAO, OLEDB, ODBC connection. 2. Oracle multi-level network computing, support a variety three way catalyst of industry-standard, you can use ODBC, JDBC, OCI and other network client connections. 3. Sybase ASE C / S structure, you can connect using ODBC, Jconnect, Ct-library and other network clients. three way catalyst 4. DB2 cross-platform, multi-layered structure, support ODBC, JDBC and other customers. Six, easy to operate a simple SQL Server operations, but only graphical interface. 2. Oracle is more complex, while providing GUI and command three way catalyst line, and the same operation three way catalyst windowsNT under unix. 3. Sybase ASE is more complex, while providing GUI and command line. But the GUI is poor, and often can not be timely, it is recommended to use the command line. 4 Simple DB2 operation, while providing GUI and command line, and the same operation windowsNT under unix. Seven, the use of risk 1. SQL server completely rewritten code, through a long-term test, continuous delays, many of the features needed time to prove. Not very compatible. 2 long experience in the development Oracle, fully backward compatible. Widely used. Completely without risk. 3. Sybase ASE backward compatible, but ct-library three way catalyst program does not benefit three way catalyst transplant. 4. DB2 giant companies in widely used, downward compatibility. Small risk.