Currently commonly used dbms

The common database management software (DBMS) currently on the Internet are:

1. Oracle

Oracle Database, and Named Oracle RDBMS, or Oracle for short. It is a relational database management system of Oracle Company. Its main features are:

1. Fast processing speed, very fast.

2. High security level. Supports flash and perfect recovery. Even if the hardware is broken, it can be restored to one second before the failure.

3. Several databases are used as load databases, and failover can be achieved within 30 seconds.

4, grid control, and data warehouse are also very powerful.

2. MySQL

MySQL is a small relational database management system. MySQL is widely used in small and medium-sized websites on the Internet. Its characteristics are:

1. Open source;

2. Highly non-procedural;

3. Collection-oriented operation mode;

4. With a grammatical structure Provides a variety of usage methods;

5. The language is concise, easy to learn and use.

Related recommendations: "FAQ"

3. ACCESS

The ACCESS database is a database released by Microsoft Research Management software, the full name of ACCESS is Microsoft Office Access, which is a relatively representative database management software from Microsoft. Its advantages are:

1. Single storage method, convenient for user operation and management.​

2. Friendly interface and easy to operate. Access is a visual tool with the same style as Windows. If users want to generate objects and apply them, they only need to use the mouse to drag and drop, which is very intuitive and convenient.

3. Integrate the environment and process a variety of data information.

4. Access supports ODBC.

4. MS SQL Server

SQLserver database is an RMDBS database released by Microsoft Corporation of the United States, which is a relational database system. The advantages of SQLserver are:

1. True client-server architecture.

2. Graphical user interface, more intuitive and simple.

3. Rich programming interface tools provide users with more choices for programming.

4. SQLserver and Windows NT are integrated, and you can take advantage of more functions of NT.

5. It has good scalability and can run across borders. Available in multiple units from laptops to large processors.

6. Support for web technology allows users to easily publish data in the database to the web.

Extension of knowledge points:

DBMS is a database management system. A database management system is a large-scale software that manipulates and manages databases and is used to establish, use and maintain databases. , referred to as DBMS. It provides unified management and control of the database to ensure the security and integrity of the database. Users access data in the database through DBMS, and database administrators also perform database maintenance through DBMS. It enables multiple applications and users to use different methods to create, modify and query the database at the same time or at different times. Most DBMS provide data definition language DDL and data operation language DML for users to define the schema structure and permission constraints of the database and implement operations such as appending and deleting data.

The above is the detailed content of Currently commonly used dbms. For more information, please follow other related articles on the PHP Chinese website!