What are the dbms database management systems?

This article is about dbms database management system. Xiao Bian thinks it is quite practical, so share it for everyone to make a reference. Let's follow the editor and have a look.

DBMS is database management system, database management system is a kind of manipulation and management database of large-scale software, used to establish, use and maintain the database, referred to as DBMS.

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

1) Oracle

Oracle Database, also known as Oracle RDBMS, or simply Oracle. Oracle is a relational database management system, its main features are:

1, processing speed is fast, very fast.

2. High security level. Support 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 30s.

Grid control and data warehousing are also very powerful.

II. 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 code;

2. Highly non-procedural;

3. Set oriented operation mode;

4. Provide multiple usage modes with one syntax structure;

5. Simple language, easy to learn and use.

III. ACCESS

ACCESS database is a database management software released by Microsoft research, ACCESS full name is Microsoft Office Access, Microsoft is more representative of a database management software, its advantages are:

1, storage mode is single, easy for users to operate and manage.

2, friendly interface, easy to operate. Access is a visual tool, is exactly the same style as Windows, users want to generate objects and applications, as long as the use of the mouse drag and drop can be very intuitive and convenient.

3. Integrate environment and process various data information.

Access supports ODBC.

MS SQL Server

SQLserver database is an RMDBS database released by Microsoft Corporation in the United States, which is a relational database system.

The advantages of SQL Server are:

A true client server architecture.

2, graphical user interface, more intuitive and simple.

3. Rich programming interface tools provide more choices for users to design programs.

SQL Server and Windows NT complete integration, you can take advantage of NT's more versatile features.

5. It has good scalability and can operate across borders. Multi-use from laptop to large processor.

Support for web technologies, enabling users to easily publish data from databases to the web.

Thank you for reading! What about dbms database management system to share here, I hope the above content can be of some help to everyone, so that everyone can learn more knowledge. If you think the article is good, you can share it so that more people can see it!