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

what is database

Database DB refers to a warehouse that organizes, stores, and manages data according to a data structure. It is a collection of related data stored together.

What is a database management system?

Database Management System (DBMS) is a kind of large software that manipulates and manages data. It is used to establish/use and maintain databases. He manages and controls the database uniformly to ensure its security and integrity. users access the data in the database through the database management system, database administrators also maintain the database through the database management system,

Definition of data.

DBMS provides a data definition language that allows users to share constraints such as database object/integrity constraints and confidentiality restrictions

data operation

DBMS provides a data manipulation language for users to perform operations on data, such as insert, modify, delete, and query.

Data organization, storage and management

DBMS should classify, organize, store and manage all kinds of data, including data dictionary, user data, access path, etc. It is necessary to determine what kind of file structure and storage mode to organize these data in spring and how to realize the relationship between data. The basic goal of data organization and storage is to provide you with storage space utilization, select the appropriate access method to provide you with access efficiency, and ensure that the data is correct and effective.

Database Security Management

Data in database is strategic resource of information society, security management of all data is very important, DBMS protects database mainly through database recovery/concurrency control/integrity control/security control.

database the establishment and the maintenance

The establishment and maintenance of database includes initial data loading, database storage/recovery/reorganization, system performance monitoring, analysis and other functions.

database system

Database System (DBS) is a software system that can store/maintain and provide data for in-use systems. Ishimura ring, an aggregation of management systems that process objects

data model

Data is a symbolic record describing things. Model is the abstraction of real world, data model is the abstraction of data feature, and it is the teaching framework of database management. A formal architecture used by database systems to provide information representation and manipulation tools. The data model includes the structure part, operation part and constraint condition of database data.

Data models are classified into three types according to different dingdong hierarchies: conceptual model, data model and physical model

conceptual model

The first layer model abstracted from the display world is mainly used to describe the conceptual structure of the world, analyze data and display the relationship between data, etc., and has nothing to do with the specific data management system. The conceptual model must be replaced by the data model to be realized in DBMS.

The most widely used conceptual model is the E-R model, which takes the form of an E-R diagram. An E-R diagram, also known as an entity-relationship diagram, provides you with a method for identifying strength types, attributes, and relationships. It is an effective way to describe the conceptual structure of the world

data model

The data model is the model seen from the database and supported by the specific DBMS. This model is both user-oriented and system-oriented, and is mainly used for the implementation of DBMS.

Hierarchical model, network model and relational model are adopted in database domain

physical model

A physical model is a computer-oriented physical representation of organized data, describing the organizational structure of data on a storage ring. It is not only related to a specific DBMS, but also to an operating system and hardware. In order to ensure rationality and portability, most of the physical data models are implemented automatically by the DBMS, while the designer designs special structures such as indexes and aggregates.

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.