DB2 and Oracle, Sybase, Infomix
A more early article should be before INFOMIX is not acquired. From IBM.
First, DB2 and Oracle comparison
Features DB2 Oracle
1, open / portability
IBMDB2UDB at all levels, from the network protocol supports programming interfaces, database storage programs, and triggers, distributed operations between servers, are based on the latest international standards to ensure their openness and portability. Many of Oracle uses its private, non-open technologies. For example: OraclePL / SQL language is Oracle private. Its storage program is not compliant with ANSISQL and ISOSQL standards, and the client / server programming interface, Oracle's SQL * NET is not based on standard definitions.
2, processing performance
IBM invented relational databases and its optimization techniques, and continuous development, the DB2 occupied the prior position in various performance tests. IBM has confident that can transcend Oracle in various standard test environments. DB2 has excellent technology in high-end applications, with many user instances of more than 1tera-bytes data. Since Oracle restrictions cannot publish their performance tests without permission, general users are not easy to obtain Oracle comparison. The customer instance of Oracle has more than 1tera-bytes data.
3, parallelism
The parallel page of DB2 supports bitmap index and object relationships. Therefore, DB2 has better scalability and performance; Oracle trigger cannot support parallel: In some special reference integrity (ReferenceialIntegrity), the parallel cannot be used in parallel: If there is a large object in the form, the parallel is not applicable due to the foregoing restrictions (the table cannot be divided). In short, Oracle did not implement bitmap index and object relationships in the parallel system.
4, distributed database
DB2 distributed database processing (such as two-stage commit) and connection function are built in the core of DB2 and does not require other product accessories. Good performance, easy to use, reduce expenses. Oracle's distributed features require additional purchase of distributedOption and SQL * NET to connect to the distributed database.
5, heterogeneous platform support
In the heterogeneous environment, the IBM database scheme is simple, more seamless and better than the cost of Oracle; Oracle's heterogeneous gateway performance, when accessing the heterogeneous database, Oracle lacks global optimization, resulting in too many data and network transmission.
6, copying ability
DB2 offers the industry's best efficiency and the most open replication scheme; DB2 provides automatic conflict detection and solution. Oracle only provides example programs for automatic conflict detection and solution, and users must customize the copy conflict after customization of examples.
7, support for e-commerce
IBM's Java technology is recognized as the industry, DB2 is recognized as an e-commerce cornerstone. The JDBC interface provided by DB2, and the Java language write storage process and user-defined functions Oracle is only limited to database and ERP applications.
8, support for business intelligence
DB2OLAPSERVER is more easier to use and implement than Express. DB2OLAPSERVER provides read / write capabilities - this is very useful for some key multi-dimensional analysis extensions such as predictions and budgets (Express only supports reading). In an IBM's Business Intelligence Solution, there is a data mining (IntelligentMiner) tool. OracleExpress only supports reading capacity, which is not conducive to support forecasting and budget. Oracle lacks tools in data mining.
9, software quality and reliability
DB2 software development laboratory has passed the verification and recognition of ISO9000 international quality management standards in 1994. Therefore, the software quality of DB2 is the highest reliability and the lowest failure rate in all database manufacturers. Oracle Version 6 and Version 7 After the launch, there must be a number of revised upgrades to achieve a certain degree of availability, which gives users a great inconvenience, and seriously affects the availability and reliability of the production system. Second, DB2 and SYBASE comparison
Features DB2 Sybase
1, open / portability
The programming interface of IBMDB2 follows the ANSI, X / Open standard CLI (CalllevelInterface) and ANSISQL embedded SQL and other open standards. The storage program and trigger mechanism of IBMDB2 uses the latest SQL international standards and supports standard open languages such as C / C . In DB2COMMONSERV2.1.2 (1996) and DB2UDB (1997), the function of developing storage programs and triggers with Java languages is added.
1. Cheng interface: The programming interface used by Sybase is not open because he uses its own OpenClient / OpenServer interface instead of a standard interface.
2. StoredProcedure: Since Sybase's client / server technology is developed in the 1980s, it is also useful to prepare the storage programs and triggers. Transact-SQL.
2, processing performance
IBM invented relational databases and its optimization techniques, and continuous development, the DB2 occupied the prior position in various performance tests. DB2 has excellent technology in high-end applications, with many user instances of more than 1tera-bytes data. The Sybase's Optimizer cannot effectively support complex queries (complexqueries). A slightly complex SQL statement in the application, the Sybase's optimizer cannot be properly optimized. Sybase has just entered the area of massive multiprocessor MPP, lacks this experience and precedent, and Sybase is more than one TB data amount.
3, parallelism
The parallel page of DB2 supports bitmap index and object relationships. Therefore, DB2 has better scalability and performance; Sybase database core structure is older, especially in a multiprocessor (SMP) server, unable to match hardware Extension and expansion (Scale) cannot play a multi-processor. The structure of its single process multi-clue cannot be able to run on the SMP and other machines in the multi-process multi-line structure of DB2.
4, high availability
DB2 can be backed up and recovered by two granularity (Granularity) of the database and tablespace, and the backup can be performed under the online mode without affecting the simultaneous use of multiple users. This makes DB2 to really meet 24 hours a day, 24 days a week. Sybase requires the system to a single user mode to ensure the integrity and consistency of data in the database, and after Backup, run the consistency of DBCC check data, which makes the Sybase database in availability restricted.
5, data complete and manageability
Databases in IBMDB2 can automatically maintain the consistency between two tables without programming by DBA. Sybase introduces RI (ReferenceialIntegrity data reference integrity) in its database technology, and is limited. For example, when column A in Table A is the ForeignKey of the column B in another table B, to delete a record in Table A, it is not allowed in Sybase, only through the trigger (TRIGGER) and the storage process (STOREDPROCEDURE) can delete a record in Table A while deleting related records in Table B, or sets its value to NULL.
6, heterogeneous platform support
In the heterogeneous environment, the IBM database scheme is simple, more seamless and cost; Oracle's heterogeneous gateway performance is poor, when accessing the heterogeneous database, Oracle lacks global optimization, resulting in too much data and network transmission. 7, copying ability
DB2 provides industry best efficiency and the most open replication scheme; DB2 supports the data to be preprocessed and then copied to the far end, more efficient and less network traffic. Sybase is immediately replicating trading, data, and network traffic, according to user reflection, Sybase's replication is difficult to implement. The data replication between SybaseAdAptiveServeRAnywhere and AdaptiveServereNterPrise is not seamless connection and requires integration.
8, support for e-commerce
IBM's Java technology is recognized as the industry, DB2 is recognized as an e-commerce cornerstone. The JDBC interface provided by DB2, and the Java language write storage process and user-defined functions Oracle is only limited to database and ERP applications.
DB2wareHouseManager has built-in data warehouse management functions for business intelligence support. In an IBM's Business Intelligence Solution, there is a data mining (IntelligentMiner) tool. Sybase Data Market (DATAMART) does not provide a warehouse management and automation.
9, software quality and reliability
DB2 software development laboratory has passed the verification and recognition of ISO9000 international quality management standards in 1994. Therefore, the software quality of DB2 is the highest reliability and the lowest failure rate in all database manufacturers. The data is corrupted in the IBM system (Corrupted) is not only unheard, but also impossible for IBM traditional users. The data in Sybase requires careful maintenance because data is likely to be "corrupted" in the database. If these data is backed up without prior patches, they cannot be used. To this end, SYBASE has to provide a check program (DBCC) for our customers.
Third, DB2 and Informix
Features DB2 Informix
1, open / portability
IBMDB2UDB at all levels, from the network protocol supports programming interfaces, database storage programs, and triggers, distributed operations between servers, are based on the latest international standards to ensure their openness and portability. Informix private 4GL written programs can only be run on Informix.
2, processing performance
IBM invented relational databases and its optimization techniques, and continuous development, the DB2 occupied the prior position in various performance tests. DB2 has excellent technology in high-end applications, with many user instances of more than 1tera-bytes data. Since INFORMIX is a small database, its product design is still limited to many small databases. Many users have encountered INFORMIX issues in data storage, log management, backup, recovery. Informix's extension parallel options are difficult when supporting multiple users concurrent access. Informix has lacks management experience of large amounts of data, its optimizer technology cannot be optimized for a lot of data.
3, parallelism
DB2EEE can use the HACMP to automatically replace the fault node, INFORMIX can't do it. DB2eee has been many years of history, promulgated the highest TPC-D and TPC-H benchmark values. DB2eee supports dynamic bitmap index completing Star-Jion, thereby improving performance without increasing the amount of maintenance of database system administrators. On the parallel SP, the InformixXPS database will be paralyzed when the high performance switch (SWITCH) cannot communicate. When the node of the parallel is fails, the InformixXPS database will be in a state, and the downtime is 4 to 24 hours; InformixXPS has no backup and recovery. InformixXPS does not have a monitoring mechanism for the query, there is a possibility of a user's query to exhaust all resources without letting other users. 4, distributed database
DB2 supports the XA interface through the core, and provides the XA advanced features of many other vendors. For example, the DB2 application of the Industrial and Commercial Bank Shandong Branch uses the DB2XA interface to achieve large online business processing systems combined with CICS. OLTP) to support applications such as provinces. The support of the INFORMIX to the heterogeneous distributed database is implemented by X / Open, XA. Although INFORMIX claims that it can support X / Open, XA interface, but just completed by additional options in a few versions. And in this regard, Informix rarely uses the precedent, and there is no technical support in this regard.
5, heterogeneous platform support
In heterogeneous environments, IBM database schemes are simple, more seamless and low; INFORMIX is very weak in terms of connection between databases and databases. For example, Informix does not connect to other databases such as bboracle, Sybase and other databases.
6, copying ability
DB2 offers the industry's best efficiency and the most open replication scheme; DB2 provides automatic conflict detection and solution. Informix only supports replication between Informix database. To copy each other with other databases, third-party support software must be purchased.
success case
DB2 in China, international user base
The user of DB2 is not an enumeration. It has more than one million license and more than 40 million users around the world, which has 10,000 enterprise-class users around the world. The data of 70% of the world is stored in the IBM database.
Li Shouliang sorted out SLLI@founder.com.cn
2003-3-26
