Comparison of several common databases-MySQL

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. Currently, commercial database management systems are dominated by relational databases, and the technology is mature. 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.

　　2. SQL Server

SQL Server is a database management system developed by Microsoft and the most popular database for data storage on the Web, it has been widely used in e-commerce, banking, insurance, power, and other database-related industries.

Currently, the latest version is SQL Server 2005, which can only run on Windows. The system stability of the operating system is very important to the database. The parallel implementation and coexistence model is not mature, and it is difficult to process the increasing number of users and data volumes, with limited scalability.

SQL Server provides a wide range of Web and e-commerce functions, such as the rich support for XML and Internet standards, allowing you to easily and securely access data through the Web, powerful, flexible, Web-based, and secure application management. In addition, because of its ease of operation and friendly operation interface, it is favored by the majority of users.

　　3. Oracle

The first company that comes to mind when talking about databases is Oracle ). Founded in 1977, the company was initially a specialized database development company. Oracle has been in the leading position in the database field. In 1984, relational databases were first transferred to desktop computers. Then, Oracle5 took the lead in introducing new concepts such as distributed databases and customer/server structures. Oracle 6's first line lock mode and support for symmetric multi-processing computers ...... The latest Oracle 8 mainly adds object technology to become a relational-object database system. Currently, Oracle products cover dozens of large, medium, and minicomputers. Oracle databases have become one of the world's most widely used relational data systems.

Oracle database has the following excellent features.

(1) compatibility

Oracle adopts standard SQL and has been tested by NIST. Compatible with ibm SQL/DS, DB2, INGRES, IDMS/R, etc.

(2) Portability

Oracle products can run on a wide range of hardware and operating system platforms. It can be installed on 70 or more large, medium, and small computers, and can work in VMS, DOS, UNIX, Windows, and other operating systems.

(3) connectability

Oracle can be connected to multiple communication networks and support various protocols (TCP/IP, DECnet, LU6.2, etc ).

(4) High Productivity

Oracle provides a variety of development tools to facilitate further development.

(5) openness

Oracle's good compatibility, portability, connectivity, and productivity make Oracle RDBMS open.

　　4. Sybase

In 1984, Mark B. Hiffman and Robert Epstern created Sybase and launched Sybase database products in 1987. Sybase has three major versions: one is the version running in the UNIX operating system, the other is the version running in the Novell Netware environment, and the other is the version running in the Windows NT environment. Currently, the most widely used UNIX operating systems are SYBASE 10 and SYABSE 11 for sco unix.

Sybase database features:

(1) it is a database based on the customer/server architecture.

(2) it is a truly open database.

(3) It is a high-performance database.

　　5. DB2

DB2 is a database management system embedded in IBM's AS/400 system, directly supported by hardware. It supports standard SQL languages and has gateways connected to heterogeneous databases. Therefore, it has the advantages of high speed and good reliability. However, the DB2 database management system can be used only when the ibm as/400 is selected for the hardware platform.

DB2 can run on all major platforms (including Windows) and is most suitable for massive data volumes.

DB2 is the most widely used in enterprise-level applications. almost 500 of the 85% largest enterprises in the world use DB2 database servers, and about 1997 in China by 5%.

In addition, Microsoft's Access database and FoxPro database are available. Now that there are so many database systems, what kind of database should we choose in game programming? The first principle is to consider the game development budget based on actual needs. Currently, common databases include SQL Server, My SQL, Oracle, and FoxPro. Among them, MySQL is a completely free database system, and its functions also provide the standard database function. Therefore, we recommend that you use it for independent production. Although Oracle is powerful, it exists for commercial purposes and is rarely used in games.