Shulou(Shulou.com)06/02 Report--

This article is to share with you what is the core of the database system on the Internet. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

The core of the database system is the database management system (DBMS), which works under the support of the operating system to solve how to organize and store data scientifically and how to obtain and maintain data efficiently; DBMS can manage and control the database uniformly to ensure the security and integrity of the database.

The operating environment of this tutorial: windows7 system, Dell G3 computer.

Database system is an ideal data processing system developed to meet the needs of data processing, and it is also a software system that provides data for practical operational storage, maintenance and application systems. it is a collection of storage media, processing objects and management systems.

The database system generally consists of four parts:

(1) A database (database,DB) is a collection of organized and shareable data stored in a computer for a long time. The data in the database is organized, described and stored according to a certain mathematical model, with less redundancy, high data independence and easy expansibility, and can be shared by all kinds of users.

(2) hardware: various physical devices that make up a computer system, including external devices needed for storage. The configuration of hardware should meet the needs of the whole database system.

(3) Software: including operating system, database management system and application program.

Database management system (database management system,DBMS) is the core software of the database system, which works with the support of the operating system to solve how to organize and store data scientifically and how to obtain and maintain data efficiently. Its main functions include: data definition function, data manipulation function, database operation management and database establishment and maintenance.

(4) personnel: there are mainly four categories. The first category is system analysts and database designers: system analysts are responsible for the requirement analysis and specification of the application system. They work with users and database administrators to determine the hardware configuration of the system and participate in the summary design of the database system. Database designers are responsible for the determination of data in the database and the design of schemas at all levels of the database. The second category is application programmers, who are responsible for writing applications that use databases. These applications can retrieve, create, delete, or modify data. The third category is the end user, who uses the system interface or query language to access the database. The fourth type of user is the database administrator (data base administrator,DBA), who is responsible for the overall information control of the database. The specific duties of DBA include: the information content and structure of the specific database, determining the storage structure and access strategy of the database, defining the security requirements and integrity constraints of the database, monitoring the use and operation of the database, and being responsible for the performance improvement of the database, the reorganization and reconstruction of the database, in order to improve the performance of the system.

Database management system (DBMS)

DBMS is a large software for manipulating and managing databases, which is used to establish, use and maintain databases. It unifies the management and control of the database to ensure the security and integrity of the database.

Users access the data in the database through DBMS, and the database administrator also maintains the database through DBMS. It can support multiple applications and users to build, modify and query databases at the same time or at different times in different ways. Most DBMS provide data definition language DDL (Data Definition Language) and data manipulation language DML (Data Manipulation Language) for users to define the schema structure and permission constraints of the database and to implement operations such as appending and deleting data.

Database management system is a data operation software that can provide data input, modification and query, with data definition, data operation, data storage and management, data maintenance, communication and other functions, and can allow multi-users to use. In addition, the development of database management system is closely related to the development of computer technology. And in recent years, computer network has gradually become an important part of people's life. For this reason, if we want to further improve the computer database management system, technicians should constantly innovate and reform computer technology, and constantly broaden the scope of application of computer database management system, so as to really promote the innovation of computer database management system technology.

Main functions:

Data definition: DBMS provides data definition language DDL (Data Definition Language) for users to define the three-level schema structure, two-level image, integrity constraints and confidentiality restrictions of the database. DDL is mainly used to establish and modify the database structure. The library structure described by DDL only gives the framework of the database, and the frame information of the database is stored in the data dictionary (Data Dictionary).

Data manipulation: DBMS provides data manipulation language DML (Data Manipulation Language) for users to add, delete, update, query and other operations.

Database operation management: the database operation management function is the operation control and management function of DBMS, including concurrency control, security check and access restriction control, integrity check and execution, operation log organization and management, transaction management and automatic recovery, that is, ensuring the atomicity of transactions. These functions ensure the normal operation of the database system.

Data organization, storage and management: DBMS needs to classify, organize, store and manage all kinds of data, including data dictionaries, user data, access paths, etc., need to determine what file structure and access mode to organize these data at the storage level, and how to achieve the relationship between the data. The basic goal of data organization and storage is to improve the utilization of storage space and choose appropriate access methods to improve access efficiency.

Database protection: the data in the database is the strategic resource of the information society, so the data protection is very important. The database protection of DBMS is realized through four aspects: database recovery, database concurrency control, database integrity control and database security control. Other protection functions of DBMS include the management of system buffers and some adaptive adjustment mechanisms for data storage.

Database maintenance: this part includes database data loading, conversion, dump, database reconfiguration and performance monitoring and other functions, these functions are completed by each user program.

Communication: DBMS has related interfaces with online processing, time-sharing system and remote job input of the operating system, which is responsible for data transmission. The database system under the network environment should also include the communication function between DBMS and other software systems in the network and the interoperation function between the database.

Thank you for reading! This is the end of the article on "what is the core of the database system in the Internet". I hope the above content can be of some help to you, so that you can learn more knowledge. If you think the article is good, you can share it for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.