Common Large Database Compare __ Database

At present, the commercialized database management system takes the relational database as the leading product and the technology is more mature. Although the Object-oriented database management system is advanced in technology, the database is easy to develop and maintain, but there is no mature product yet. The international and domestic leading relational database management system is Oracle, SYBASE, Informix and Ingres. These products support multiple platforms, such as UNIX, VMS, and WINDOWS, but have different levels of support. Their platform support capabilities are compared in the following analysis. IBM's DB2 is also a mature relational database. However, DB2 is embedded in IBM's AS/400 series and supports only the os/400 operating system.
Based on the selection of database management system, we compare and analyze the performance of these database management systems:
1. Oracle Database Management System

* No paradigm requirements, the database can be constructed according to the actual system requirements.
* Adopt a standard SQL Structured Query language.
* With rich development tools, covering all stages of the development cycle.
* Support for large databases, data types support numbers, characters, large to 2GB binary number
It provides data support for database object-oriented storage.
* Development tools with fourth-generation languages (Sql*forms, Sql*reports, Sql*menu, etc.).
* with character interface and graphical interface, easy to develop. ORACLE7. Version 1 has faces
CDE2 to the development environment of the object.
* Control user Rights through SQL*DBA, provide data protection function, monitor the database
Run state, adjust the size of the data buffer.
* Distributed optimization query function.
* With data transparency, network transparency, support heterogeneous networks, heterogeneous database systems. Parallel
The process adopts dynamic data slicing technology.
* Support for client/server architectures and mixed architectures (centralized, distributed,
Client/server).
* Implementation of two-stage submission, multiple-clue query means.
* Support a wide range of system platforms (HPUX, SUNOS, OSF/1, VMS,
WINDOWS, Windows/nt, OS/2).
* Data Security protection measures: do not read the lock, take snapshot snap mode completely eliminates the points
Cloth Read and write conflict. Automatically detects deadlocks and conflicts and resolves them.
* The level of data security is C2 (highest level).
* The database model supports multibyte code, and supports multiple language encoding.
* With a manufacturing system-oriented management information system and financial systems application system.
*oracle7. 1 version server supports 1000-10000 users.
WORKGROUP/2000 has a oracle7workgroup server,
Power OBJECTS (Graphics development environment, support OS/2, UNIX, windows/nt platform.
* Sales share in China accounted for more than 50%.

2. SYBASE 10 Database management System
Sybase database system developed since November 1992, after 12-24 months of development and formation of products, products include: SQL Server 10 (the core of the database management system), REPLICATION server (the server that implements the database distribution), BACKUP Server (a fast backup server in a networked environment), Omini SQL GATEWAY (heterogeneous database library), navigation server (scalable parallel processing capability on the network), control server (database Administrator server). is a client/server architecture that provides an exchange of database data on each node in a network environment.
The technical features of Sybase database management system are:

TRANSACTION processing), which provides high performance requirements for hundreds of of users.
* Using single process multiple threads (porcess and multi-threaded)
Technology to query, save system overhead, improve memory utilization.
* Support stored procedures, customers only need to issue the implementation request through the network, can be horse

It is possible to greatly improve the operation efficiency of the network environment and increase the service capacity of the database.
* Virtual server architecture combined with symmetric multiprocessor (SMP) technology to fully
High performance with multiple CPU hardware platforms.
* Database management System DBA adjusts the performance of the monitoring database system online.
* Provide log and database mirror image, improve database fault-tolerant capability.
* Support fast failover in the computer's Nest (CLUSTER) environment.
* The server restricts the integrity of the data through storage and triggers (TRIGGER).
* Multiple security mechanisms to authorize tables, views, stored procedures, and commands.
* Distributed transaction Processing using 2PC (two PHASE COMMIT) technology access
* Support image and text data types, for engineering database and multimedia should
provided a good foundation.

Sybase's development tools are:

DATA WORKBENCH
* VISUAL Query Languange (Graphics search language)
* Report WORKBENCH (statement system)
* INTERACTIVE SQL (Interactive SQL Environment)
* Data ENTRY (Fast entry)
  APT WORKBENCH
  embeded SQL
  SQR WORKBENCH (open report System)
* Easy SQR (Report Builder based on menus)
* SQR 4GL (fourth generation language Report Builder)
* SQR Debug (Debug tool)
* Sql-execute (Dynamic table configuration)
  GAIN momentum (Object-oriented multimedia development platform, can
  Editing animations, sounds, bitmaps)

The lack of Sybase:

* Multi-server system does not support distributed transparency
The performance of *replication server data is poor and does not
Integration with the operating system
* Poor support for Chinese
* More for the banking system, etc.
* There is no enterprise management information system based on this database

3. Ingres Intelligent relational Database management system
The Ingres database system has a number of technologies that are directly based on the latest findings of the University of Berkeley. Technology has been at the leading level. Ingres databases not only manage data, but also manage knowledge and objects (objects refer to the combination of data and operations, and the computer handles them as a whole). Ingres products are divided into three categories: the first category is the basic database system, including data management, knowledge management, and object management. The second category is the development tool. The third category is open interconnection products. Data management in Ingres's basic database management system supports the following features:

* Open client/server architecture that allows users to build multiple threaded servers.
* Compile the database process. The database process is compiled using the Ingres fourth generation language
Write. Managed by the server, used to implement predefined transactions, reduce CPU load, and reduce network overhead.
* Intelligent optimization function. According to the query language requirements, automatically adjust the query order in the network environment and find the best path.
* Online backup of data. Backup maintains consistent database backups without disrupting the system's normal operation.
*I/O reduction processing. Provides fast submission, group submissions, multiple read and write techniques. Reduce I/O volume.
* Multi-file storage data. A table is stored in a file to facilitate the recovery of data inventory under exceptional circumstances.
* The two-stage commit protocol is used to ensure the consistency of network distributed transactions.
* has a database rule system. Automatically activates rules that satisfy behavior conditions, with unrestricted number of independent rules for each table.
* Unrestricted forward reasoning and infinite recursion to ensure consistency of the database.
* With alarm system, when the data in the specified amount of data limit, automatically make the appropriate operation.
* The combination of resource control and query optimization, the server controls the resource consumption of the query, and ensures the predictable performance of the system.
* The ability to process, store, and define the effective range of data that the user defines.
* Allows users to embed their defined functions into the database management system.

Ingres's Application development tools:
Ingres/windows 4GL, the tool improves programmer productivity through an object-oriented fourth-generation language and debugger. Supports window environments such as Microsoft WINDOWS, OPEN Look, Decwin, and so on. Ingres/vision. is an application code generator that includes support for advanced interface features (graphical representations of application structures, menu drivers, online Help, dynamic selection of valid data). He also allows the user to adjust the generated code. User decision Support Tools. Includes GQL (GRAPHIC QUERY LANGUAGE), Grafsman, IPM (INTERACTIVE performance MONITOR) Ingres/net, a global communications architecture that enables OSI-compliant clients/ Server communication protocol. It supports the transparency of the verse, the transparency of the network and the transparency of the platform. Ingre/star, a distributed information management mechanism, allows users to view the databases distributed in different sites as a whole, providing multiple database storage integration, distributed data dictionary, distributed query optimization and distribution processing for distributed databases. Ingres/gateway, non-INGRES database system and INGRES database interconnect products. INGRES enhanced security enhanced security system, according to the U.S. B1 security indicators designed safety system, to meet data consistency, availability, credibility requirements, with row-level labels, the underlying multi-layer security system, security tag data types and complex consistency mechanism.
Lack of Ingres system:
Academic value is greater than practical value. That is, in the academic mastery of leading technology, in the product services are relatively weak.
4. Informix Database Management System
Informix runs on the UNIX platform, supporting SunOS, HPUX, Alfaosf/1. Adopt double engine mechanism, occupy resource small, simple and easy to use. Suitable for small and medium sized database management. It has:

*DSA (Dymanic Scalable architecture) dynamic adjustable structure supports SMP query statements
* Multi-clue query mechanism
* With three task queues
* With Virtual processor
* Provides parallel indexing capabilities and is a high-performance OLTP database
* Data physical structure is static fragmentation
* Support for two-machine cluster (CLUSTER) (only sesquent platform support)
* Informix 4GL Cade tool for complex system application development

The disadvantages are:

* Network performance is not good, heterogeneous network is not supported. That is, data transparency is only supported and network transparency is not supported.
* Concurrency control deadlock.
* The data backup has the software mirror function, the speed is slow, the reliability is poor.
* No good performance for large database systems.
* Development tools are immature, with only character interface, weak multimedia data, no case tool covering the whole development process.
* Non-client/server distributed processing mode
* Portability is poor and different versions of the data structure are incompatible.
*4GL and Cade code are not portable.

The main products of Informix are:

Informix-se
Informix-online
Informix-sql
Informix-4gl
Informix-open Case/tool Bus
Informix-view Point
Informix-star
Informix-net
Informix-gateway
        ......

5. DB2 Database Management System
DB2 is a database management system embedded in IBM's as/400 system, directly supported by hardware. It supports the standard SQL language and has a gateway connected to heterogeneous databases. Therefore, it has the advantages of high speed and good reliability. However, only the hardware platform chooses IBM's as/400 to choose to use the DB2 database management system.