Comparison of various mainstream databases

First, openness

1. SQL Server
Only running on windows, without the slightest openness, the stability of the operating system is very important to the database. The Windows9x series is focused on desktop applications, and NT server is only suitable for small and midsize businesses. 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.

2. Oracle
Can be run on all major platforms (including Windows). Full support for all industry standards. Adopt a fully open strategy. Enables customers to choose the solution that best suits them. Full support to developers.

3. Sybase ASE
Can be run on all major platforms (including Windows). 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.

4. DB2
Can be run on all major platforms (including Windows). Best suited for massive data. DB2 is the most widely used enterprise-class, with nearly 85% of the world's 500 largest enterprises using DB2 database servers, while the country accounts for about 5% in 97.

second, scalability, parallelism

1. SQL Server
The parallel implementation and coexistence model is immature, and it is difficult to handle the increasing number of users and data volumes with limited scalability.

2. Oracle
Parallel servers extend the capabilities of WINDOWNT by enabling a set of nodes to share work in the same cluster, providing a solution for high availability and highly scalable clusters. If the windowsnt does not meet the needs, the user can move the database to UNIX. Oracle's parallel servers have a fairly high level of integration into the clustering mechanisms of various UNIX platforms.

3. Sybase ASE
Although there is a DB switch to support its parallel server, Dbswitch is technically immature and supports only version 12.5 and above Aseserver. DB switch technology requires a server to act as a switch, causing some trouble on the hardware.

4. DB2
Has a 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 node security.

third, safety certification

1. SQL Server
No security certificate was obtained.

2. Oracle Server
Obtain the highest certification level of ISO Standard certification.

3. Sybase ASE
Obtain the highest certification level of ISO Standard certification.

4. DB2
Obtain the highest certification level of ISO Standard certification.

Iv.. Performance

1. SQL Server
Poor performance for multiple users

2. Oracle
Highest performance, keeping the world record of tpc-d and tpc-c under open platforms.

3. Sybase ASE
Performance is close to SQL Server, but concurrency under the UNIX platform is superior to SQL Server.

4. DB2
High performance applies to data warehousing and online transaction processing.

v. Client support and Application Mode

1. SQL Server
c/S structure, only support Windows customers, you can use ADO, DAO, OLE DB, ODBC connection.

2. Oracle
Multi-level network computing, supporting a variety of industry standards, can be used in ODBC, JDBC, OCI and other network customers connect.

3. Sybase ASE
c/S structure, can be connected with ODBC, Jconnect, Ct-library and other network customers.

4. DB2
Cross-platform, multi-layered structure, support ODBC, JDBC and other customers.

six, easy to operate

1. SQL Server
Simple operation, but only graphical interface.

2. Oracle
More complex, providing both GUI and command line, operating under WindowsNT and UNIX.

3. Sybase ASE
More complex, providing both GUI and command line. However, the GUI is poor and often cannot be in a timely state, it is recommended to use command line.

4. DB2
The operation is simple and provides both GUI and command line, and operates the same under WindowsNT and UNIX.

vii. risk of Use

1. SQL Server
The completely rewritten code, experienced long-term testing, is constantly delayed, and many functions take time to prove. is not very compatible.

2. Oracle
Long-time development experience, fully backwards compatible. are widely used. There is no risk at all.

3. Sybase ASE
Backwards compatible, but the ct-library procedure is not beneficial to transplant.

4. DB2
It is widely used in giant enterprises and has good backward compatibility. Less risk.

Comparison of various mainstream databases (RPM)

Now the database is in the mainstream of relational database, but in order to fashion, the major databases are also developing object-oriented relational database,
Seamlessly connect high-level programming languages and databases to make their own pros and cons work. Advanced programming languages are good at describing complex
The process, and the database has a strong management function and operability, our current database is a table-based storage unit
(Describe an object), but now it is growing faster and more complex to data. So our two-dimensional database
To move to a three-dimensional database development, the following describes the characteristics of the various databases, so that we can choose to set up their own database

MSSQL: Microsoft's SQL Server, can only run on the Windows platform, the volume is large, occupy a lot of system resources,
But the use is very convenient, supports the command and the graphical management, mainly unifies the ASP language development; MSSQL is the Department of Money.
According to the library

MySQL: is an open source database server that can run on a variety of platforms, such as Windows,unix/linux; he's a small size.
is designed for Web database, characterized by a particularly fast response, mainly for small and medium-sized enterprises, for the massive database
It is not enough, it is a real multi-user multi-tasking database system, he occupies little system resources but the function
Very strong, can be used as a large database system, the most important is that its standard version is free. Yahoo used to be
MySQL: The main combination of PHP language development. MySQL support basically relies on the network and the community

PostgreSQL: Known as "the world's most advanced Open source database", can run on a variety of platforms, is a terabyte database, and performance
It's good, too.

Oracle:1. Can be run on all major platforms (including Windows). Full support for all industry standards. Adopt a fully open policy
Slightly. Enables customers to choose the solution that best suits them. Full support to developers.

2. Obtain the highest certification level of ISO standard safety certification

3. Highest performance, maintain the world record of tpc-d and Tpc-c under the open platform.

4. Multi-level network computing, supporting a variety of industry standards, can be connected with ODBC,JDBC,OCI and other network customers

5. More complex, while providing GUI and command line, operate the same under WindowsNT and UNIX

6. Long-time development experience, fully backwards compatible. are widely used. No risk at all

Db2:1. Can be run on all major platforms (including Windows). Best suited for massive data. DB2 is the most widely used enterprise-class,
Of the 500 largest enterprises in the world, almost 85% use DB2 database servers, while the domestic by 97 accounted for about 5%.

2. Good parallelism. DB2 extends the database management to a parallel, multi-node environment. The database partition is a
section that contains your own data, indexes, profiles, and transaction logs. Database partitions are sometimes referred to as nodes or database nodes

3. Highest performance, maintain the world record of tpc-d and Tpc-c under the open platform.

4. High performance is suitable for data warehouse and online thing processing.

5. Cross-platform, multi-layer structure, support ODBC,JDBC and other customers

6. Simple operation with GUI and command line, same operation under WindowsNT and UNIX

7. It is widely used in mega-enterprises and has good backward compatibility. Less risk

Comparison of various mainstream databases (RPM)