Analyze the advantages of various databases to help you make accurate choices

Access database

A computerized database management system launched by Microsoft in the United States in 1994. It has the characteristics of friendly interface, easy to learn and easy to use, simple development and flexible interface, and is a typical new generation desktop database management system. The main features are as follows:

(1) Perfect management of various database objects, with a strong data organization, user management, security checks and other functions.

(2) powerful data processing functions, in a workgroup-level network environment, a multiuser database management system developed using Access has traditional xbase (DBASE, foxbase collectively) client server (cient/server) that the database system cannot implement Structure and the corresponding database security mechanism, access has the characteristics of many advanced large database management systems, such as transaction processing/error rollback capabilities.

(3) can easily generate a variety of data objects, the use of stored data to establish forms and reports, good visibility.

(4) As part of the Office suite, you can integrate with Office to achieve seamless connectivity.

(5) The ability to use the Web to retrieve and publish data to connect to the Internet. Access is primarily available for small and medium applications, or as a client database in a client/server system.

Informix Database

The relational database management system developed by American Infomixsoftware Company. Informix has two versions of Informix-se and Informix-online. The INFORMIX-SE is designed for use in UNIX and WindowsNT platforms, for small to medium sized applications, informix-online run under UNIX operating systems, can provide multi-threaded servers, support symmetric multiprocessor, and is suitable for large applications.

Informix can provide screen-oriented data entry queries and design-oriented query Language Report Builder. Data definitions include defining relationships, undoing relationships, defining indexes, and redefining indexes. Informix can not only build a database, but also easily refactor the database, the system is very robust protection, not only to protect data from users outside the purview of access, and can re-establish the lost files and recover the corrupted data. The size of the file is not limited by disk space, the size of the field and the length of the record can reach 2K. With the subscript sequential access method, Informix is compatible with COBOL software and supports the C language program. Informix is highly portable and compatible, and is applied to many microcomputers and small machines, especially for the personnel, warehousing and financial management of small and medium-sized enterprises.

Orcale Database

A relational database management system developed by American Orcale Corporation is an open RDBMS that coordinates servers and supports mission-determined applications. It supports a wide range of hardware and operating system platforms, from desktops to large and super computers, provides a high degree of scalability for a variety of hardware architectures, supports symmetric multiprocessor, cluster multiprocessor, large scale processors, and provides extensive international language support. Orcale is a multiuser system that automatically recovers from system failures in batch processing or online environments. The system provides a complete software development tool Developer2000, including interactive application builder, report printing software, word processing software, and centralized data dictionary, which enable users to build their own applications. Orcale represents data as a two-dimensional table and provides SQL (Structured Query language) to perform basic database management functions such as data query, operation, definition, and control. Orcale has a good portability, through its communication function, the microcomputer program can be with small and even large computer orcale, and can pass data to each other. In addition Orcale also has the C language with the electronic form, graphics processing and other software. Orcale is a large database system, mainly suitable for large and medium sized applications, or as a server-side database system in the client/server system.

DB2 Database

A relational database system developed by IBM. DB2 is mainly used in large-scale application system, it has good scalability, it can support from mainframe to Single-user environment, apply to OS/2, Windows and other platforms. DB2 delivers high levels of data utilization, integrity, security, recoverability, and execution capabilities for small-scale to large-scale applications with platform-independent basic functionality and SQL commands. DB2 uses data-grading technology to enable mainframe data to be easily downloaded to LAN database servers, enabling client/server users and lan-based applications to access mainframe data and to make database localization and remote connectivity transparent. It is known for having a very complete query optimizer whose external connections improve query performance and support multitasking parallel queries. DB2 has a good network support capability, each subsystem can connect a hundred thousand of distributed users, can activate thousands of active threads at the same time, for large-scale distributed application system is particularly applicable.