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

Editor to share with you what the main content of database design is, I believe that most people do not know much about it, so share this article for your reference, I hope you will learn a lot after reading this article. Let's go and learn about it!

Database design mainly includes: demand analysis, conceptual structure design, logical structure design, physical structure design, database implementation and database operation and maintenance.

Requirements Analysis:

Investigate and analyze users' business activities and the use of data, find out the type, scope and quantity of data used and their communication in business activities, and determine users' requirements for the use of the database system and various constraints, to form a user requirements specification.

Requirements analysis is on the basis of user survey, through analysis, gradually clarify the needs of users for the system, including data requirements, business processing requirements around these data, security and integrity requirements.

Conceptual structure design:

To describe the real world of user requirements (may be a factory, a shopping mall or a school, etc.), through data abstraction, synthesis, induction and abstraction, an abstract conceptual data model is established, which is generally called Emurr model.

This conceptual model should reflect the information structure, the flow of information, the mutual restriction between information and the requirements of various departments for information storage, query and processing.

Logical structure design:

Transform the conceptual structure into a data model supported by a DBMS, such as a relational model, and optimize it.

Physical structure design:

Design the storage structure and access methods of data, such as the design of indexes; transform the conceptual structure into a data model supported by a DBMS, such as a relational model, and optimize it.

Implementation of the database:

Using the data language provided by DBMS (such as SQL) and its host language (such as C), the database is established according to the results of logical design and physical design, application programs are compiled and debugged, data are stored, applications are compiled, and trial runs are carried out.

Operation and maintenance of database:

After trial operation, the database application system can be put into formal operation. Long-term maintenance work is needed in the operation of the database system, and it must be constantly evaluated, adjusted and modified.

Explanation: the design of a perfect database application system can not be achieved overnight, it is often repeated to carry out the above six stages.

The above is all the contents of the article "what is the main content of database design?" Thank you for your reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to 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.