English 中文(简体)
数据库设计链接列表与顺序
原标题:Database design linked list vs. order by

I 有一个表格需要按顺序持续一些用户动作。我可以通过使用像链接列表的自参考表格来保存它,或者根本不使用自引用,而只是使用时间戳来保持序列。本表格引用了其它表格,例如用户和与动作相关的文件。操作需要支持 CROUD。操作的频率依此顺序:检索 & gt; 插入 > 更新 & gt; 删除

您的设计偏好和为什么? 谢谢!

最佳回答

i 会避免“链接列表”如瘟疫。 关于它们唯一有用的是检索“ 下一步” 项目。 问题是, 每一个额外的“ 请求” 都需要加入, 所以如果您想要在此上面进行参数化( 例如提供函数, 在给定项目之后检索 < code> N < / code> 项), 那么您需要 (1) 机生成的连接 (2) 多个选择 (3) SQL, 它不可能被您的 ORM 移动和/ 或支持 。

但上面的第(3)款(也许我是个老古板, 有人会说这些树现在得到了很好的支持-如果这样的话,我想我会学到...) 。

问题回答

暂无回答


上一篇:
下一篇:


相关问题
what is wrong with this mysql code

$db_user="root"; $db_host="localhost"; $db_password="root"; $db_name = "fayer"; $conn = mysqli_connect($db_host,$db_user,$db_password,$db_name) or die ("couldn t connect to server"); // perform query ...

Users asking for denormalized database

I am in the early stages of developing a database-driven system and the largest part of the system revolves around an inheritance type of relationship. There is a parent entity with about 10 columns ...

Easiest way to deal with sample data in Java web apps?

I m writing a Java web app in my free time to learn more about development. I m using the Stripes framework and eventually intend to use hibernate and MySQL For the moment, whilst creating the pages ...

join across databases with nhibernate

I am trying to join two tables that reside in two different databases. Every time, I try to join I get the following error: An association from the table xxx refers to an unmapped class. If the ...

How can I know if such value exists in database? (ADO.NET)

For example, I have a table, and there is a column named Tags . I want to know if value programming exists in this column. How can I do this in ADO.NET? I did this: OleDbCommand cmd = new ...

Convert date to string upon saving a doctrine record

I m trying to migrate one of my PHP projects to Doctrine. I ve never used it before so there are a few things I don t understand. In my current code, I have a class similar to this: class ...

热门标签