What the database design process does not include

The database design process does not include algorithm design.

The database design process mainly includes Requirements analysis, Conceptual structure design,Logical structure analysis, Database physical design, Database implementation, Database operation and Maintenance phase.

Database Design

Database Design refers to the design of a given application environment , construct the optimal database model, establish the database and its application system, so that it can effectively store data and meet the application needs of various users (information requirements and processing requirements). In the field of databases, various systems that use databases are often collectively referred to as database application systems.

Definition

(Database Design) refers to designing a specific On the database management system, design the structure of the database and the process of establishing the database. The database system requires the support of the operating system.

Database design is the technology for establishing databases and their application systems, and is the core technology in the development and construction of information systems. Due to the complexity of the database application system, in order to support the operation of related programs, the database design becomes extremely complex. Therefore, the optimal design cannot be achieved overnight, but can only be a process of "repeated exploration and gradual refinement", that is, planning and the process of structuring data objects in a database and the relationships between these data objects.

Features

Database construction is a combination of hardware, software and software

Three points technology, seven points management, twelve points basic data

The interface between technology and management is called "dryware"

Database design should be combined with application system design

Structural (data) design: Design database framework or database structure

Behavioral (processing) design: Design applications, transaction processing, etc.

Design of separation of structure and behavior

Traditional software engineering ignores the analysis and abstraction of data semantics in applications, and tries to postpone decisions on data structure design as long as possible. Early database design was devoted to the study of data models and modeling methods, but ignored the design of behavior.

For more technical articles related to SQL, please visit the SQL Tutorial column to learn!

The above is the detailed content of What the database design process does not include. For more information, please follow other related articles on the PHP Chinese website!