数据库设计 - web项目,mysql数据库只会增删改查,应该怎样提高?有没有书籍推荐?
巴扎黑
巴扎黑 2017-04-17 11:55:28
0
2
828

感觉就会将数据通过php来进行增删改查,不知道在一个web项目中具体怎样来设计数据库,根据网站的功能,应该设计多少个表这样的。比如我要实现对于一篇文章添加标签这样的功能(像本站这样的),应该怎样设计数据表,当然这个功能我在本站搜索到有几篇文章谈到这个问题的。

我想有没有专门的书籍或者视频教程,专门讲项目实战中数据库应该怎样设计,我在亚马逊没搜到这样的书籍,要么是底层原理的实现,要么就是基本的类似用户手册的基本语法。我看过一些开源项目后台的数据表,但是不怎么系统,自己也不一定就理解正确了,所以希望有没有专门的教程呢,这样学起来便捷和系统。

巴扎黑
巴扎黑

reply all(2)
刘奇

Personally, I think that database related experience is a matter of getting in and out of pits. Others have told you this countless times, but you still can’t remember it until you do it yourself
Moreover, for large projects and large amounts of data, the larger and more complex the data is, the more it tests people’s ability. For small projects with tens of thousands of data, even if I don’t do indexing, it probably won’t get stuck (some people say that full table query for data within 8,000 pieces is faster than indexing. I don’t know. Is it a rumor?)
On another note, I think the most important part of adding tags to articles lies in the NLP named entity part. I don’t choose tags and you help me generate tags. The database design is not too complicated

PHPzhong

Don’t learn PHP, this is my advice

Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template