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

What this article shares to you is about the main stages of the database design process. The editor thinks it is very practical, so I share it with you. I hope you can get something after reading this article. Let's take a look at it with the editor.

The database design stage includes five stages, namely: requirements analysis stage, conceptual structure design stage, logical structure design stage, physical design stage, database implementation stage, database operation and maintenance stage.

Independent of the database management system are: requirements analysis stage, conceptual design stage, logical design stage, physical design stage.

What depends on the database management system is: implementation phase, operation and maintenance phase.

Database design is the technology of establishing database and its application system, and it is the core technology in the development and construction of information system. Because of the complexity of the database application system, in order to support the operation of related programs, the database design becomes extremely complex.

Therefore, the best design can not be achieved overnight, but can only be a process of "repeated exploration and gradual refinement", that is, the process of planning and structured database data objects and the relationship between these data objects.

Extended data:

Formation process

1. Requirement analysis stage: synthesize the application needs of each user (data flow chart (DFD).

2. Conceptual design stage: form a conceptual model independent of machine characteristics and independent of each DBMS product (Emurr diagram).

3. Logical design stage: first, the Emurr diagram is transformed into a specific data model supported by database products, such as a relational model, to form a database logical schema; then, according to the requirements of user processing and security considerations, necessary views (View) are established on the basis of the basic table to form the external schema of the data.

4. Physical design stage: according to the characteristics of DBMS and the needs of processing, the physical storage is arranged, the index is established, and the schema in the database is formed.

The above are the main stages of the database design process, and the editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

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.