What are the common databases in China? Introduction to various databases

What is a database?

# 俗 Explanation The database is "warehouses that organize, store and manage data according to the data structure". In the daily work of economic management This "warehouse" will be processed accordingly according to management needs. For example, some units often store the basic information of employees (such as name, gender, age, salary, basic status, etc.) in a table. This table can be regarded as a database, through which you can query certain information at any time as needed. Basic information about employees, you can also check the number of employees within a certain age group, etc. If all these tasks can be automatically performed on computers, then our personnel management can reach an extremely high level. In addition, in financial management, warehouse management, production management and other management undertakings, it is also necessary to establish numerous such "databases" so that computers can be used to realize automated management of finance, warehouse and production. To put it bluntly, a database is like a very scientific collection of data arranged in rows and columns. You can add them in a certain order (or rows or columns) at any time, and you can read the data in any order at any time when you want to use it, which is very convenient.

You may be dazzled after reading so much. In fact, simply speaking, a database is a set of data organized by a computer and stored in one or more files. The software that manages this database is called Database management system. Generally, a database system (Database System) can be divided into two parts: database (Database) and data management system (Database Management System, DBMS).

Several commonly used databases

International and domestic leadingRelational databaseManagement systems include Oracle, Sybase, INFORMIX and INGRES. These products all support multiple platforms, such as UNIX, VMS, and Windows, but the degree of support is different. IBM's DB2 is also a mature relational database. However, 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. It is developed and published by MySQL AB and support. MySQL AB is a commercial company based on MySQL developers, 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 the use of mission-critical, heavy-load production systems, and can also be embedded in a mass-deployed software.

2.SQL Server

SQL Server is a database management system developed by Microsoft. It is the most popular database for storing data on the Web. It has been widely used in e-commerce, banking, Insurance, electricity and other database-related industries. The latest version is SQL Server 2005, which can only run on Windows. The system stability of the operating system is very important for the database. The parallel implementation and coexistence model are immature, difficult to handle the increasing number of users and data volumes, and have 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 easy operation and friendly operation interface, it is deeply loved by the majority of users.

3.Oracle

When it comes to databases, the first company that comes to mind is usually Oracle. The company was founded in 1977 as a company specializing in database development. Oracle has always been a leader in the database field. In 1984, the relational database was first moved to desktop computers. Then, Oracle5 took the lead in launching new concepts such asdistributed databaseand client/server structure. Oracle 6 pioneered row locking mode and support for symmetric multi-processing computers...The latest Oracle 8 mainly adds object technology and becomes a relational-object database system. At present, Oracle products cover dozens of models of large, medium and small computers, and the Oracle database has become one of the most widely used relational data systems in the world.

4. Sybase
Sybase was founded in 1984. The company name "Sybase" is taken from the combination of "system" and "database". Bob Epstein, one of the founders of Sybase, is the main designer of Ingres University Edition (a relational database model product at the same time as System/R). The company's first relational database product was Sybase SQLServer1.0 launched in May 1987. Sybase first proposed the idea of Client/Server database architecture and was the first to implement it in Sybase SQLServer.

In addition, there are Microsoft Access database, FoxPro database, etc. Since there are so many database systems now, what kind of database should you choose when programming games? The first principle is based on actual needs. On the other hand, the game development budget must also be considered. Currently commonly used databases include: SQL Server, My SQL, Oracle, and FoxPro. Among them, MySQL is a completely free database system, and its functions also have the functions of a standard database. Therefore, it is recommended to use it when producing independently.

【Related recommendations】

Mysql free video tutorial

2.17 points of MySQL performance optimization

3.Mysql diagnosis startup problems and detailed explanation of viewing log files

4.Detailed explanation of backup and maintenance of MySQL database

5.MySQL Detailed Explanation of Setting Access Permissions Example

The above is the detailed content of What are the common databases in China? Introduction to various databases. For more information, please follow other related articles on the PHP Chinese website!