Comparison of database types

Large databases are: Oracle, Sybase, DB2, SQL Server small database: Access, MySQL, BD2, etc.First, openness1. SQL Server can only run 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 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 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, parallelism1. The SQL Server 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 within the same cluster, providing solutions 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 has DB switch to support its parallel server, but 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. 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 node security.third, safety certification1. SQL Server does not obtain any security credentials. 2. Oracle server obtains the highest certification level of ISO Standard certification. 3. Sybase ASE is certified to the highest certification level of ISO standards. 4. DB2 obtains the highest certification level of ISO Standard certification.Iv.. Performance1. SQL Server Multi-user performance is poor 2. Oracle has the highest performance, keeping the world record for tpc-d and tpc-c under open platforms.
3. Sybase ASE performance is close to SQL Server, but concurrency on UNIX platforms is superior to SQL Server.
4. DB2 performance is more suitable for data warehousing and online transaction processing.v. Client support and Application Mode
1. SQL SERVERC/S structure, supported only for Windows customers, can be connected with ADO, DAO, OLE DB, ODBC. 2. Oracle Multi-level network computing, support a variety of industry standards, can be used in ODBC, JDBC, OCI and other network customers connect.
3. Sybase asec/s structure, can be connected with ODBC, Jconnect, Ct-library and other network customers. 4. DB2 cross-platform, multi-layer structure, support ODBC, JDBC and other customers.six, easy to operate1. SQL Server operation is simple, but only the graphical interface. 2. Oracle is more complex, providing both GUI and command line, operating under WindowsNT and UNIX. 3. Sybase ASE is more complex and provides 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. The DB2 is simple to operate, providing both GUI and command line, same operation under WindowsNT and UNIX.vii. risk of Use1. SQL Server completely rewrites the code, has undergone long-term testing, constantly delayed, many functions need time to prove. is not very compatible.
2. Oracle's long-time development experience is completely backwards compatible. are widely used. There is no risk at all.
3. Sybase ASE is backwards compatible, but the Ct-library program does not benefit from porting. 4. DB2 is widely used in giant enterprises and has good backward compatibility. Less risk.--------------------------------------------------------------------------------------------------------------- --------the most "easy" database system-microsoft SQL Server if you are going to be a DBA, it is recommended that you choose the database system that is now more popular. This means you will have more job opportunities, communication and training opportunities, and you can worry a lot about the popularity of popular reasons. Of course, the pressure of employment competition is also relatively large. The general beginner chooses Microsoft SQL Server, which is a very good database system for small and midsize businesses, and it is easy for readers who are familiar with access to be able to initially use Microsoft SQL Server as a Dbbs. J Microsoft SQL Server 7.0 quote, 5 User version 1399 USD, increase user when 127 USD per user. The most "difficult" database-uncrowned King Oracle
If you have access to Oracle, that's a good chance. Oracle is currently the most promising database vendor, and Oracle DBA pay is typically higher than that of other database administrators due to its powerful capabilities and configurable and manageable capabilities. Moreover, Oracle's critical applications in large and medium-sized enterprises are more prevalent. Oracle can run on Windows NT, Sun Solaris, Linux and other platforms. 　　In many cases, you are not only familiar with NT, but also you are familiar with UNIX, and Oracle's unfriendly interface and Oracle product data in the box can be an obstacle. Oracle 8i Standard Edition quote, if run on Windows NT, comes with Jserver and intermedia, support 5 concurrent users, quote is $3925 per CPU. 785 USD per user when adding concurrent users. Add additional named users when 392.5 USD per user. The aristocracy of the database system-IBM UDB/DB2
As a result of the 30 database research, IBM DB2 is indeed called "the aristocracy of the database system". Whether it's a small business system or a big banking system, it's safe to use DB2. The latest release of the new DB2 6.1, management and tuning tools for greater excellence and ease of use. The DB2 can be run on an Intel architecture or on an IBM s/390 mainframe computer. If your industry is particularly praised for IBM machines, it is recommended that you study IBM DB2. There are two versions of DB2: Workgroup Edition and Enterprise Edition. The Workgroup Edition is $999 per server, plus $249 per concurrent user. And the Enterprise Edition is $12500 per CPU, unlimited concurrent users. Java-centric database-sybase Adaptive Server Enterprise (ASE) 12.0 is about to release Sybase ASE 12.0, directly oriented to Java programmers. This Java-centric database system is the best choice for businesses that are ready to build enterprise applications under the Java platform. But ASE says it is not a leader in the database field, although it has improved a lot compared to its previous version, and supports multiple CPUs and more concurrency, with many new features. But the scenery of Sybase seems to have ceased.

Comparison of database types