Project Database Design and Project Database Design
The database system is not only designed once. I was designed during this interview, so I once again flipped out the textbooks I used to take the test and made some new discoveries in the database design of the entire book. Share with you:
First, the database design is divided into four parts:
Define Data Structure
Data Loading
Compilation and debugging
Trial Run
(1) define the data structure: It mainly determines the database model design, including the conceptual model, logical model and physical model. The conceptual model is mainly embodied in the design of ergraphs. Currently, the logical structure is commonly used to design the relational model using three paradigms, while the physical structure is mainly the design of tables.
(2) Data Loading: transfers data to the database. In small enterprises, manual data is mainly used, including format conversion, input data, and validation data. Data Loading in large and medium-sized enterprises is divided into the following five steps: data filtering, data input, data verification, data conversion, and data integration.
(3) Prepare and debug the application: This step is synchronized with the data warehouse receiving prevention function. Note that when you debug an application, you can use the simulated data because the data warehouse has not been completed.
(4) database trial run: it can also be combined debugging, which can be divided into two parts: functional and performance testing.