当前在线人数16790
首页 - 分类讨论区 - 电脑网络 - 数据库版 -阅读文章
未名交友
[更多]
[更多]
文章阅读:Re: A simple DB design question
[同主题阅读] [版面: 数据库] [作者:xlxie] , 2007年06月24日10:28:59
xlxie
进入未名形象秀
我的博客
[上篇] [下篇] [同主题上篇] [同主题下篇]

发信人: xlxie (三老爷), 信区: Database
标  题: Re: A simple DB design question
发信站: BBS 未名空间站 (Sun Jun 24 10:28:59 2007)

Assail got your key.
No matter what you need, 专门用一个field来标记 won't be a good idea.
IF you want to do so, you can build a view for the recommended, and add the
column you want into the view.

You will keep the ref integraty and the performance in your mind.
Also, for the recommended history, in case you want, you want to use the
dimentional/fct model, the dimentional table will be your book table, and
keep the id with the history to build the transctional history fct table.

【 在 muzhimei (taoye) 的大作中提到: 】
: 现有一个table存放书籍,需要单独列出几本(<10)来推荐,每天更新。
: 问题:是专门用一个field来标记好呢,还是另外建一个table好呢?



--

※ 来源:·WWW 未名空间站 海外: mitbbs.com 中国: mitbbs.cn·[FROM: 69.138.]

[上篇] [下篇] [同主题上篇] [同主题下篇]
[转寄] [转贴] [回信给作者] [修改文章] [删除文章] [同主题阅读] [从此处展开] [返回版面] [快速返回] [收藏] [举报]
 
回复文章
标题:
内 容:

未名交友
将您的链接放在这儿

友情链接


 

Site Map - Contact Us - Terms and Conditions - Privacy Policy

版权所有,未名空间(mitbbs.com),since 1996