Divided by function, database management systems can be broadly divided into six parts:
(1) mode translation: Data definition language (ddl). Use it to write the database model is translated into internal representation. The logical structure of the database, integrity constraints, and the physical storage structure of the data stored in the internal dictionary. Database, a variety of data manipulation (such as search, modify, insert and delete, etc.) and database maintenance and management are based on database schema based.
(2) application of the compilers: To access the database contains the statement that applications compiled to run in the dbms support of the object program.
(3) Interactive query: Provides easy to use interactive query language, such as sql. Dbms responsible for implementing the query command and query results displayed on the screen.
(4) data organization and access: Provide data in the external storage device, the physical organization and access methods.
⑸ services operation and management: Provision of services operation and management and operational logs, transaction monitoring the safety of operation and data integrity checks, transaction concurrency control and system recovery functions.
(6) Database maintenance: Database administrators to provide software support, including data security control, integrity protection, database backup, database restructuring and performance monitoring maintenance tool.
Based on the relational model database management system has been perfected and has been widely used in all walks of life as a commercial software. It is in all families, distributed server architecture in the application of multi-user environment, so that further expansion of the application of database systems. With the new data model and data management techniques to promote the implementation can be expected dbms software will also update and improve the performance, applications will also be further broadened.