A simple DB design question# Database - 数据库
m*i
1 楼
现有一个table存放书籍，需要单独列出几本（<10）来推荐，每天更新。
问题：是专门用一个field来标记好呢，还是另外建一个table好呢?
问题：是专门用一个field来标记好呢，还是另外建一个table好呢?
a*t
2 楼
don't really understand your question/requirement. for example, any
performance consideration?
but I'll try to answer
I think the logical deisgn would be to build a new table, and only store the
daily recoomendation list, with forigen key referrance to the main table.
if performance is an issue, I would actually copy the full contents of the
fields to the recommendation table
and do you need to keep track of the history of the "recommended"?
【在 m******i 的大作中提到】
: 现有一个table存放书籍，需要单独列出几本（<10）来推荐，每天更新。
: 问题：是专门用一个field来标记好呢，还是另外建一个table好呢?
performance consideration?
but I'll try to answer
I think the logical deisgn would be to build a new table, and only store the
daily recoomendation list, with forigen key referrance to the main table.
if performance is an issue, I would actually copy the full contents of the
fields to the recommendation table
and do you need to keep track of the history of the "recommended"?
【在 m******i 的大作中提到】
: 现有一个table存放书籍，需要单独列出几本（<10）来推荐，每天更新。
: 问题：是专门用一个field来标记好呢，还是另外建一个table好呢?
d*l
3 楼
Agree.
the
【在 a*******t 的大作中提到】
: don't really understand your question/requirement. for example, any
: performance consideration?
: but I'll try to answer
: I think the logical deisgn would be to build a new table, and only store the
: daily recoomendation list, with forigen key referrance to the main table.
: if performance is an issue, I would actually copy the full contents of the
: fields to the recommendation table
: and do you need to keep track of the history of the "recommended"?
the
【在 a*******t 的大作中提到】
: don't really understand your question/requirement. for example, any
: performance consideration?
: but I'll try to answer
: I think the logical deisgn would be to build a new table, and only store the
: daily recoomendation list, with forigen key referrance to the main table.
: if performance is an issue, I would actually copy the full contents of the
: fields to the recommendation table
: and do you need to keep track of the history of the "recommended"?
x*e
4 楼
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.
【在 m******i 的大作中提到】
: 现有一个table存放书籍，需要单独列出几本（<10）来推荐，每天更新。
: 问题：是专门用一个field来标记好呢，还是另外建一个table好呢?
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.
【在 m******i 的大作中提到】
: 现有一个table存放书籍，需要单独列出几本（<10）来推荐，每天更新。
: 问题：是专门用一个field来标记好呢，还是另外建一个table好呢?
q*1
5 楼
你要的就是一个query，根本不需要什么新表和新的field。。
【在 m******i 的大作中提到】
: 现有一个table存放书籍，需要单独列出几本（<10）来推荐，每天更新。
: 问题：是专门用一个field来标记好呢，还是另外建一个table好呢?
【在 m******i 的大作中提到】
: 现有一个table存放书籍，需要单独列出几本（<10）来推荐，每天更新。
: 问题：是专门用一个field来标记好呢，还是另外建一个table好呢?
t*g
6 楼
Yes, cache the result in your application instead of database.
【在 q**1 的大作中提到】
: 你要的就是一个query，根本不需要什么新表和新的field。。
【在 q**1 的大作中提到】
: 你要的就是一个query，根本不需要什么新表和新的field。。
相关阅读
一个装ORACLE8I的问题？阐爵衄oracle administration □□唳腔□□□sort关于Powerbuilder的DB的问题Question about MySQLQuestion about T-SQLWhere can I download Personnal Oracle7请教SQL Server的问题~偶将感激不尽Re: ~{Gk=L~}SQL Server~{5DNJLb~}~~{E<=+P<$2;>~}?Help with Oracle8i Litewhere is ora 00922 from?い瓣ㄈ瑆程淮计沮畐盡產Some thoughts为什么我的postgres SQL的日期总是12-31-1999??在SQL SERVER 或其他DBMS中, 有没有类似于ACCESS中的RELATIONSHIP的东西?Oracle中文问题oracle8i配置求助question about oracle 8i personal edition[转载] Why Data Center Server domed?how to see all the tables in SQL*PLUS?