A detailed comparison of several mainstream databases

http://blog.csdn.net/zhouhx08/article/details/7528254

It is very important to develop database application and choose a good database. At present, the commercialized database management system takes the relational database as the leading product, the technology is more mature. Object-oriented database management system Although the technology is advanced, the database is easy to develop and maintain, but has not yet mature products. International and domestic leading relational database management systems include SQL Server, ORACLE, SYBASE, Informix, and DB2.

1. Performance
SQL Server

The old version of multi-user performance is poor, the new version of the performance has been significantly improved, the processing capacity has been significantly improved. Maintained a number of tpc-c records. See http://www.tpc.org/for details.
Oracle
Highest performance, keeping the world record of tpc-d and tpc-c under Windows NT.
Sybase
High performance, supporting the features of the Sun, IBM, HP, Compaq, and Veritas cluster devices, enabling highly available availability. Performance is close to SQL Server, but concurrency under the UNIX platform is superior to SQL Server. Suitable for systems with very high security requirements.
DB2
Suitable for Data warehouse and online thing processing, high performance. Client support and Application mode.
Informix
High performance, support for clustering, and higher availability. It is suitable for the system with high security requirements, especially the application of bank and securities system.

2, scalability, parallelism
SQL Server
Previous versions of SQL Server parallel implementation and coexistence models are immature. It is difficult to handle a large number of users and data volumes. Limited scalability. The new version of nature has improved significantly, with a prominent performance on Microsoft advanced servers, surpassing his major rivals.
Oracle
Parallel servers extend the capabilities of Windows NT by enabling a set of nodes to share work within the same cluster, providing a solution for high availability and highly scalable clusters. If Windows NT does not meet the needs, users can move the database to UNIX, with good scalability. Oracle's parallel servers have a fairly high level of integration into the clustering mechanisms of various UNIX platforms.
Sybase
The new version has the good parallelism, the speed is fast, has no obvious influence to the massive data, but the technology realizes the complexity, needs the program support, the elasticity is limited. Although there is a DB switch to support its parallel server, DB switch is technically immature and only supports ASE server with version 12.5 or more. DB switch technology requires a server to act as a switch, causing some trouble on the hardware.
DB2
The DB2 has good parallelism. DB2 extends the database management to a parallel, multi-node environment. A database partition is a part of a database that contains its own data, indexes, configuration files, and transaction logs. Database partitioning is sometimes referred to as a node or database node with limited scalability.
Informix
Using single process multithreading technology, it has good parallelism. But it only runs on Unix platforms with limited scalability.

3. Security
SQL Server
Microsoft Advanced Server obtains the highest security certification, the stability of the server platform is the basis of the stability of the database, the new version of SQL Security has greatly improved.
Oracle Server
Obtain the highest certification level of ISO Standard certification.
Sybase
Obtain the highest certification level of ISO standard certification through the Sun Company's EE certification test.
CBU
Obtain the highest certification level of ISO Standard certification.
Informix
Obtain the highest certification level of ISO Standard certification.

4. Operation
SQL Server
Easy to operate, with a graphical interface. Management is also very convenient, and the programming interface is particularly friendly (its SQL-DMO makes programming very convenient.) ), the obvious advantage of SQL Server in terms of serviceability and price.
Oracle

More complex, while providing both GUI and command line, in Windows NT and UNIX, the same operation under Linux. Higher requirements for database administrators.
Sybase
Complex, with command-line operations, the requirements for database administrators are high. Both the GUI and the command line are available. However, the GUI is poor and often cannot be in a timely state, it is recommended to use command line.
DB2
The operation is simple and provides both a GUI and a command line, operating under Windows NT and UNIX.
Informix
Use and manage complex, command-line operations. Higher requirements for database administrators.

5. Risk of Use
SQL Server
Full rewrite of the code, performance and compatibility has been greatly improved, and ORACLE,DB2 performance gap significantly reduced. The product has undergone a long-term testing, for product safety and stability of the comprehensive testing, safety and stability has been significantly improved. After a long period of testing and delays, many functions take time to prove and are not very compatible.
Oracle
Long-time development experience, fully backwards compatible, is widely used, no risk at all. The database can be upgraded safely and widely used in enterprises and government. And if the data can not be met on the Winnt, it is safe to transfer the data to UNIX.
Sybase
Backwards compatible, but the ct-library procedure is not beneficial to transplant. The development time is longer, the upgrade is more complex, the stability is good, the data security is guaranteed. Less risk. In the security-demanding banks, the securities industry has been widely used.
DB2
It is widely used in giant enterprises and has good backward compatibility. Less risk.
Informix
The development time is longer, the upgrade is more complex, the stability is good, the data security is guaranteed. Less risk. In the security-demanding banks, the securities industry has been widely used.

6. Openness
SQL Server
Can only run on Windows, C/s structure, without the slightest openness, the stability of the operating system is very important to the database. Only Windows customers are supported and can be connected using ADO,DAO,OLEDB,ODBC. Windows9x Series products are focused on desktop applications, NT server suitable for a variety of large and medium-sized enterprises. The stability of the operating system is very important to the database. The reliability and security of the Windows platform is C2 certified at the highest level. Provides better performance when dealing with the critical business of large data volumes. And the reliability, security and scalability of the Windows platform are very limited. It is not as proven as UNIX, especially when dealing with large databases.
Oracle
Can be run on all major platforms (including Windows). Full support for all industry standards. Adopt a fully open strategy. Multi-level network computing, supporting a variety of industry standards, can be connected with ODBC,JDBC,OCI and other network customers. Enables customers to choose the solution that best suits them. Full support to developers.
Sybase
Can be run on all major platforms, C/s structure, can be connected with ODBC, Jconnect, Ct-library and other network customers. has been widely used in the banking industry. However, due to the low integration of early Sybase and OS, the following versions of VERSION11.9.2 require more OS and DB-level patches. In a multi-platform hybrid environment, there are some problems.
DB2
Can be run on all major platforms (including Windows). Have a good openness, the most suitable for massive data. Cross-platform, multi-layered structure, support ODBC,JDBC and other customers. The most widely used in large-scale international enterprises, nearly 85% of the 500 largest enterprises in the world use DB2 database server, and the domestic by 97 accounted for about 5%.
Iinformix
Run only on UNIX platforms, including SunOS, HPUX, Alfaosf/1. Are widely used in banks.

 

7. Ease of maintenance and price
SQL Server
SQL Server has an obvious advantage in terms of serviceability and price. Based on Microsoft's consistent style, SQL Server's graphical management interface brings obvious ease of use, Microsoft's Database Manager training is relatively adequate, can easily find a good database administrator, database management cost is low, SQL server price is also very low, But the price will be raised in license's purchase. In general, the price of SQL Server is the lowest in a commercial database.
Oracle
Oracle's price is relatively high from maintainability and price, and management is complex, as Oracle's application is extensive, and experienced Oracle database administrators can be found more easily for good management of Oracle. As a result, Oracle has the best performance price ratio in a commercial database.
Sybase
Sybase's price is relatively low, but Sybase's application in the enterprise and government is less, it is difficult to find experienced administrators, the operation of high-cost management.

DB2
High price, fewer administrators, less application in China, running management costs are very high, suitable for large enterprise data warehouse applications.
Informix
Prices are in the middle of these systems, and, like Sybase, they are used less in businesses and governments, and are widely used only in banks. Less experienced management staff, high operational management costs.

8, the database two times development
SQL Server
The database has a number of two development tools, including Visual C + +, Visual Basic, and other development tools that can be implemented in a good Windows application. Easy to develop.
Oracle
The database has a lot of two development tools, covering all stages of database development, easy to develop.
Sybase
There are fewer development tools and few experienced people.
DB2
In foreign giant enterprises have been widely used, China has few experienced personnel.
Informix
It has been widely used in banking, but there are few experienced people in China.