"Turn" five major database comparisons (DB2 Oracle MySQL SyBase SQL Server)

Source: Internet
Author: User
Tags db2 odbc connection sybase most popular database

Inadvertently seen on the internet, I see is reproduced by others, the author is unknown.

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. Oracle database is a large-scale relational database based on Structured Query language, which is one of the most popular database of client-server architectures, which manipulates a collection of regular data in a convenient and logically managed language.


Features of Oracle:
1), support multi-user, transaction processing of big event volume
2), data security and integrity control
3), providing an interface for database operations
4), Support Distributed transaction processing
5) portability, compatibility and connectivity


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.


5.MySQL
Mysql can run on all major platforms (including Windows).


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, 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.

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.


5.Mysql Strong flexibility


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.


5. Mysql is free software (free) and does not obtain any security certificates.


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.


5. Mysql support multi-user operation, high performance


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.


5. MySql

The

supports ODBC for Windows. MySQL supports all ODBC 2.5 functions and many other functions so that access can be used to connect to the MySQL server, allowing MySQL applications to be greatly expanded.  
MySQL can run under a different operating system. Simply put, MySQL can support a variety of operating system platforms such as windows95/98/nt/2000 and Unix, Linux, and Sun OS. This means that applications implemented in one operating system can be easily ported to other operating systems.  


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.

5. MySQL has a graphical interface that provides both GUI and command line

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

5. Mysql is backwards compatible with a certain risk.

"Turn" five major database comparisons (DB2 Oracle MySQL SyBase SQL Server)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.