Database design (i) concepts, content, procedures and references

Concept

Baidu Encyclopedia to the database design gave the following description:

Database design is to construct the optimal database schema for a given application environment, establish the database and its application system so that it can effectively store the data and meet the needs of various users (information requirements and processing requirements). In the field of database, we often refer to all kinds of systems that use database as database application system.

The design content of database design includes: Requirement analysis, conceptual structure design, logical structure design, physical structure design, database implementation and database operation and maintenance.

Today's Web applications are mostly based on the database, the general Daniel will not write code, but the design of the application, database design is a very important part of the application. After the database has been designed, the model is built, and then the code is ready to begin.

I wait for the chicken at this time also to learn about database design knowledge, perhaps that day will go to the whole system to come out?

Back to the concept, we'll deconstruct it.

Database schema: I only know that the database has a few design paradigms, I am sorry to forget the light, as if there are at most 7 paradigms, the two should have a common place.

Store data: A basic function of a database is not the storage and retrieval of data?

Application requirements: The database can have what operations: adding and removing changes, real-life human activities (do not go to extremes, such as molecular atoms, cell trajectories, and so on) can be used to record almost all databases and processing, the database a very cool thing is to meet people's pursuit of business. For me a more shocking place is the activity workflow that piece, workflow is more common in human activities, if you use activity, you will understand its bottom is to rely on a few tables to support.

Database application System: Now the application of cattle fork almost all the database application system, even if your application what the actual function is not, you have a user login system, you say you want to not database it. So, do not talk about that language all day good use of that bad, are only used for business, logical processing, if you do not use, you can write a slightly.

Database design content So many, I have also participated in a number of requirements, but the scale is not small, also on the 3, 4 table design, the guy is the analysis of the need to start the physical structure of the design ah, while the design of the database, while coding, at the beginning of the model changes more frequently. Here to improve the sense of skill or to systematically learn a little better.

The following study will take MySQL as an example.

The following list of references

Getting Started with Database design Classic

Database design and development

Database Design Tutorials

Getting Started with Database Design Solutions Classic

Database Course Design

Designing an Effective database system

MySQL Core technology

Database system implementation

MySQL Developer SQL authoritative guide

Database design (i) concepts, content, procedures and references