Database Design Process

As a data container, the database not only has a great impact on the performance of the program, but also has a great impact on the expansion of the application. therefore, for applications, a well-designed database is very important. how can we design a database with good performance and support for expansion? This is a question that we all need to explore. there are many database design procedures. however, this is only one way to design a better database at the current stage. A better and better database design process is our goal. but now, let's take a look at the standard database design process at the current stage. this helps us to use it when developing applications.
Let's take a look at the next data design flowchart (I found it online and would like to thank this drawing elder brother)

It is a relatively standard flowchart for database design. We will explain the various stages of Database Design for this process.
Demand analysis stage
Pay attention to the following two points in the demand phase:
1: considering the possible expansion and modification, the design can be easily modified and expanded.
2: emphasize customer Participation: The purpose is to better understand the customer's needs, understand the customer's requirements for program security and integrity, and the user's processing needs.
Conceptual Structure Design Stage
At this stage, we need to design a model that can truly reflect objective things. At the same time, we need to make the model easy to understand, expand, and easily transfer to other databases.
Logical Structure Design
1: Attributes of object information must be atomic. that is. when we draw an ergraph, the relationship between objects must be between objects, not between attributes and objects.
2: Determine the dependency between data (to minimize the relationship and eliminate redundancy), and check the relationship model according to the data dependency theory.
Physical Database Design Stage
Data storage structure and configuration
Database implementation stage
Define the database structure, data loading, and database trial run.
Database Operation and Maintenance
Pay attention to data dumping and recovery, database security and integrity control, monitoring of database performance, analysis and transformation, and database reconstruction.

By Cong zhongxiao

Source: http://mqsuper.cnblogs.com/