MySQL Database Design Review notes and project combat _mysql

Source: Internet
Author: User

Author: Yang Xinchi

Recently, 3 projects have been started on hand, the other 2 are starting from the bottom, one has been started for some time, in small cities under the conditions of small team development, there is no dedicated DBA to do the design and maintenance of the database, is often the top of the developers, but looked at a lot of database design, Feel a lot of design is not very perfect, including DZ Ucenter and Ucenterhome database, so this time words for nearly 5 hours of time to properly collate the basic content of the database, with the existing framework to achieve a fast database design, to meet the needs of the current project

Reference database documents mainly include: The current domestic common PHP system database

DZ6.0 database ecshop SUPESITE7 uchome ucenter database structure and DEDECMS database structure, these are from the Phpchina forum, the need for friends can contact me or leave a message I sent the past, today in reading these paradigms, Design considerations in the article, I think of the University of the database course, remember freshman year, Tao Tao will pull me to listen to the 03 session of the database course, feel that time to listen to also more fascinated, feel the teacher also speak good, and then to our own database course, the teacher will be able to speak PPT, Just graduated graduate students who have no design experience to teach us, Gaga, at that time do not want to go to class, a little study of the impulse is not, the teacher himself to teach tired, we learn also tired, now think of college time really did not put the Foundation dozen good, now want to evil to fill up. Despise under their own college life and mentality, did not well learn good professional courses, hehe, the book used when the side hate less ...

Entry question:

Database design, I mainly divided into the following:

First, design tools

Because now only to do Lnmp (Linux + Nginx +php +mysql) Aspects of the development, so the database design I chose the database design tool, now using the MySQL own development tools: MySQL Workbench 5.2.16 OOS Beta The development version of the design, this aspect is mainly for MySQL database development, from 5.2 of each version has been used, found that a lot of bugs but for the present design is still very useful, the bug is still a lot, to be perfected, the main characteristics finally a, only do MySQL comparison professional B, you can reverse the database C , you can manage and monitor MySQL D, the interface is similar to SQL Server Manager, or to use more comfortable, well, the previous picture

Second, the realization of database design and basic knowledge review

These are directly above the diagram

We can download the next look, too big

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.