MySQL database design review notes and project practices _ MySQL

MySQL database design review notes and project practices bitsCN.com

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, when I was reading these paradigm and designing considerations, I thought of the database course in college. I remember when I was a freshman, Tao took me to listen to the database course of 03, at that time, I felt that I had heard a lot of attention, and I felt that my teacher spoke well. later, when we went to database courses on our own, I felt that I could talk about PPT, graduate students who have no design experience will teach us at the same time. They don't want to go to class at that time, and they don't have the impulse to learn any more. The teachers are tired of teaching by themselves, we are also tired of learning. now I think we 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.

BitsCN.com