MySQL Database Design Review notes and project practices

Author: Yang xinqi

 

Recently, three projects were started on hand, and the other two started from the bottom layer. One was started for a while and developed by a small team in a small city, there are no dedicated DBAs for database design and maintenance, which are usually on top of developers. However, after reading a lot of database design, I feel that many designs are not perfect, this includes the DZ ucenter and ucenterhome databases. Therefore, during this time, we spent nearly five hours working properly to sort out the basic database content, works with the existing framework to implement quick database design to meet the needs of current projects

 

The reference database documents mainly include: databases of common PHP Systems in China

Dz6.0 database ecshop supesite7 uchome ucenter database structure and dedecms database structure. These are all from the phpchina Forum. If you need them, please contact me or leave an email to send them, today, we are reading these paradigms and designing considerationsArticleI thought of Database courses in college. I remember when I was a freshman, Tao took me to listen to Database courses of the 03 session. I felt that he was quite impressed at that time, I felt that the teacher spoke well. Later, when we went to the database course on our own, the teacher came to feel like he could talk about PPT, And the graduate students who had no design experience could teach us, ga ga, I didn't want to go to class at that time. I had no impulse to learn at all. The teacher taught me tired and we learned tired, now I think that I have never laid a good foundation in college. Now I want to make up for it. Despise your college life and mentality, and fail to take a good professional course .......

 

Question:

I mainly divided the database design into the following aspects:

I. Design Tools

Because I only developed lnmp (Linux + nginx + PHP + MySQL), I chose the database design tool, mySQL workbench 5.2.16 OOS beta is a development tool developed by MySQL. It is mainly developed for MySQL databases, I have been using various versions of MySQL 5.2 and found many bugs, but they are still very useful for the current design. There are still many bugs that need to be improved. The main features are finally, only professional MySQL B can be used, reverse database C can be used, and MySQL D can be managed and monitored. The interface is similar to sqlserver manager, so it is easy to use.

II. Implementation of database design and basic knowledge Review

These are directly

You can download it and see it's too big.

Iii. Current Design Experience

Current Method

A public table can be created separately, and each project can be shared.

 

Other

 

This article will be updated continuously