Shulou(Shulou.com)05/31 Report--

This article is to share with you about the differences in DB2/Sybase/Oracle, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

At all levels, from the support of network protocols to the programming interface of application development programs, database storage programs and triggers, and the distributed operation between servers, IBMDB2UDB is based on the latest international standards to ensure its openness and portability. Many of the functions of ORACLE use its proprietary, non-open technology. The following editor to explain the differences between DB2/Sybase/Oracle?

What are the differences between DB2/Sybase/Oracle

Processing performance

IBM invented relational database and its optimization technology, and continues to develop, so DB2 takes the lead in all kinds of performance testing. IBM is confident that it can surpass ORACLE in a variety of standard test environments. DB2 has excellent technology in high-end applications, and there are many user instances that exceed the amount of 1Tera-bytes data. Because ORACLE restricts users from publishing their performance tests without permission, it is not easy for ordinary users to obtain comparative information about ORACLE. There are very few customer instances where Oracle exceeds the amount of 1Tera-bytes data.

Parallel ability

The parallel version of DB2 supports bitmap indexing and object relationships, so DB2 has better scalability and performance; Oracle triggers cannot support parallelism: under some special referential integrity (referentialintegrity) restrictions, parallelism cannot be used: if there are large objects in the table, parallelism cannot be used due to the above limitations (the table cannot be split). In short, Oracle does not implement bitmap indexing and object relationships in parallel systems.

Distributed database

The processing (such as two-phase commit) and connection functions of DB2 distributed database are built in the core of DB2 and do not need to use other product accessories. Good performance, easy to use, reduce expenses. The distributed function of ORACLE requires the purchase of other products such as DistributedOption and SQL*NET in order to connect to the distributed database.

Heterogeneous platform support

In the heterogeneous environment, the IBM database scheme is simple, more seamless and cheaper than Oracle; the performance of the heterogeneous gateway of Oracle is poor, when accessing heterogeneous databases, Oracle lacks global optimization, which leads to too much data and network transmission.

Replication ability

DB2 provides the most efficient and open replication solution in the industry; DB2 provides automatic conflict detection and resolution. Oracle only provides an example program for automatic conflict detection and resolution. Users have to customize the example program to resolve replication conflicts later.

Support for e-commerce

IBM's Java technology is recognized by the industry, and DB2 is recognized as the cornerstone of e-commerce. The JDBC interface provided by DB2, the Java technology of writing storage process and user-defined function Oracle in Java language is limited to database and ERP applications.

Support for business intelligence

DB2OLAPServer is much easier to use and implement than Express. DB2OLAPServer provides read / write capabilities-this is useful for key multidimensional analysis extension applications such as forecasting and budgeting (Express supports only reads). IBM has data mining (IntelligentMiner) tools in its business intelligence solution. OracleExpress only supports the ability to read, which is not conducive to supporting forecasts and budgets. Oracle lacks tools for data mining.

Software quality and reliability

DB2's software development laboratory has passed the verification and approval of ISO9000 international quality management standard as early as 1994. Therefore, the software quality of DB2 is the database with the highest reliability and the lowest failure rate among all database manufacturers. After the launch of ORACLE version 6 and version 7, it takes numerous revisions and upgrades to achieve a certain degree of availability, which brings great inconvenience to users and seriously affects the availability and reliability of the production system.

What are the differences between DB2/Sybase/Oracle

Characteristics.

Openness / portability

The programming interface of IBMDB2 follows the open standards such as ANSI, CLI (CallLevelInterface) of X/OPEN standard and embedded SQL of ANSISQL. IBMDB2's stored procedures and triggers use the latest international standards of SQL and support standard open languages such as Chand Clipper +. The function of developing stored programs and triggers in Java language is added in DB2CommonServerV2.1.2 (1996) and DB2UDB (1997). 1. Programming interface: SYBASE uses a programming interface that is not open because it uses its own OpenClient/OpenServer interface rather than an interface based on a certain standard. two。 Stored programs (StoredProcedure): because SYBASE's CLIENT/SERVER technology was developed in the 1980s and does not use related standards such as SQL92, the Transact-SQL used for compiling stored programs and triggers is also dedicated to their own.

Processing performance

IBM invented relational database and its optimization technology, and continues to develop, so DB2 takes the lead in all kinds of performance testing. DB2 has excellent technology in high-end applications, and there are many user instances that exceed the amount of 1Tera-bytes data. SYBASE's optimizer (OPTIMIZER) cannot effectively support complex queries (ComplexQueries). The optimizer of SYBASE cannot properly optimize the slightly more complex SQL statements in the application. SYBASE has just entered the field of massive multiprocessor MPP, lack of experience and precedent in this field, and there are very few customer instances where the Sybase is larger than a TB data.

Parallel ability

The parallel version of DB2 supports bitmap indexing and object relations, so DB2 has better scalability and performance; the core structure of SYBASE database is outdated, especially on multiprocessor (SMP) servers, it can not achieve the extension and extension of hardware and software (scale), can not give full play to the advantages of multiprocessors. Its single-process multi-thread structure can not run more effectively on machines such as SMP like DB2's multi-process multi-thread structure.

High availability

DB2 can use database and tablespace granularity (granularity) to backup and restore data (BACKUP and RESTORE), and backup can be carried out in online mode (ONLINE), without affecting the simultaneous use of multiple users. This allows DB2 to be used 24 hours a day, seven days a week. When SYBASE is in BACKUP database and RESTORE database, it needs to change the system to single-user mode to ensure the integrity and consistency of the data in the database, and after BACKUP, it is necessary to run DBCC to check the consistency of the data, which limits the availability of SYBASE database.

These are the differences between DB2/Sybase/Oracle. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.