Comparison of several common databases

At present, the commercialized database management system takes the relational database as the leading product, the technology is more mature. Object-oriented database management system Although the technology is advanced, the database is easy to develop and maintain, but has not yet mature products. The leading relational database management system in the world is Oracle, Sybase, Informix, and Ingres. These products support multiple platforms, such as UNIX, VMS, Windows, but not the same level of support. IBM's DB2 is also a well-established relational database. However, the DB2 is embedded in IBM's AS/400 series machines and only supports the os/400 operating system.

1.MySQL

MySQL is the most popular open source SQL database management system, developed, distributed, and supported by MySQL AB. MySQL AB is a MySQL developer-based business company, a second-generation open source company that uses a successful business model to combine open source values and methodologies. MySQL is a registered trademark of MySQL AB.

MySQL is a fast, multi-threaded, multi-user, and robust SQL database server. MySQL server supports mission-critical, heavy-duty production system use, or it can be embedded in a large configuration (mass-deployed) software.

Compared to 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 in a client/server or embedded system.

(5) A large number of MySQL software can be used.

2.SQL Server

SQL Server, a database management system developed by Microsoft, is the most popular database for storing data on the web, and it has been widely used in the fields of e-commerce, banking, insurance, electricity and other related databases.

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

SQL Server provides numerous web and e-commerce features, such as rich support for XML and Internet standards, easy and secure access to data through the Web, and powerful, flexible, web-based, and secure application management. Moreover, due to its ease of operation and its friendly operating interface, the majority of users are loved.

3.Oracle

When you bring up a database, the first company you think of is Oracle (Oracle). The company was founded in 1977 and was originally a company specializing in database development. Oracle has been a leader in the database industry. In 1984, the relational database was first transferred to the desktop computer. Then, Oracle5 pioneered the new concepts of distributed databases, client/server architectures, and more. Oracle 6 first-line lockdown mode and support for Chenduo processing computers ... The latest Oracle 8 increases the object technology and becomes the relational-object database system. Oracle is now one of the most widely used relational data systems in the world, covering dozens of models, including large, medium and small machines.

Oracle database products have the following excellent features.

(1) Compatibility

Oracle products are standard SQL and tested by the U.S. National Institute of Standards and Technology (NIST). Compatible with IBM Sql/ds, DB2, INGRES, IDMS/R, and more.

(2) Portability

Oracle's products can run on a wide range of hardware and operating system platforms. Can be installed in more than 70 different large, medium and small machines, can be in VMs, DOS, UNIX, Windows and other operating systems under the work.

(3) Possible connectivity

Oracle can connect to a variety of communication networks, supporting a variety of protocols (TCP/IP, DECnet, LU6.2, etc.).

(4) High productivity

Oracle products provide a variety of development tools that can greatly facilitate further development of the user.

(5) Openness

Oracle's good compatibility, portability, connectivity, and high productivity make Oracle RDBMS a good open-ended.

4.Sybase

In 1984, Mark B. Hiffman and Robert Epstern created Sybase and launched the Sybase database product in 1987. Sybase has three main versions: one is the version running under the UNIX operating system, the other is the version running under Novell NetWare environment, and the third is the version running under Windows NT. For UNIX operating systems, the most widely used are Sybase 10 and syabse for SCO Unix.

Features of the Sybase database:

(1) It is a database based on the client/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, supported directly by the hardware. It supports the standard SQL language and has a gateway connected to heterogeneous databases. Therefore, it has the advantages of fast speed and good reliability. However, only the hardware platform chooses IBM's as/400 to choose to use the DB2 database management system.

DB2 can be run on all major platforms (including Windows), and is best suited for massive amounts of data.

DB2 is the most widely used enterprise-class, with nearly 85% of the world's 500 largest enterprises using DB2 database servers, and the country accounts for about 5% in 1997.

In addition, there are Microsoft's Access database, FoxPro database and so on. Now that there are so many database systems, what kind of database should be chosen in game programming? The first principle is to consider the game development budget on the other hand, depending on the actual needs. Databases that are commonly used now are SQL Server, My sql, Oracle, FoxPro. MySQL is a completely free database system, its function also has the function of standard database, therefore, in the independent production, it is recommended to use. Oracle is powerful, but it is for commercial use, and is rarely used in games.

Transferred from: http://www.cnblogs.com/wuzhanwen/p/6883394.html

Comparison of several common databases