Comparison of several common databases such as DB2 (1)

The database management system is a very important part in all kinds of information systems. The database systems used are important issues for information system developers. This article will introduce you to several common databases such as DB2, for your reference.

Currently, commercial database management systems are dominated by relational databases, with mature technologies. Although the object-oriented database management system is advanced in technology and easy to develop and maintain, there are no mature products yet. Leading relational database management systems at home and abroad include Oracle, Sybase, INFORMIX, and INGRES. These products support multiple platforms, such as UNIX, VMS, and Windows, but the degree of support is different. IBM DB2 is also a mature relational database. However, DB2 is embedded in IBM's AS/400 series machines and only supports OS/400 operating systems.

1. MySQL

MySQL is the most popular open-source SQL database management system. It is developed, released, and supported by MySQL AB. MySQL AB is a commercial company based on MySQL developers. It is a second-generation open-source company that uses a successful business model to combine open-source value and methodology. MySQL is a registered trademark of MySQL AB.

MySQL is a fast, multi-threaded, multi-user, and robust SQL database server. The MySQL Server supports the use of key tasks and heavy load production systems. It can also be embedded into a large configuration (mass-deployed) software.

Compared with other database management systems, MySQL has the following advantages:

(1) MySQL is a relational database management system.

(2) MySQL is open source.

(3) MySQL Server is a fast, reliable and easy-to-use database server.

(4) the MySQL server works on the client/server or embedded system.

(5) There are a large number of MySQL software available.