English 中文(简体)
表1. 继承与否
原标题:Class Table Inheritance vs. Denormalization
最佳回答

B. 设计表格 我通常用一点来设计:使用。

我将如何写到那里的数据,我如何回答。 我在设计上偏重于文字或文字,因为文字对业绩、重复性等都更为重要。

你的问题没有真正解释你的用法,因此,我在这里回答的所有建议都是完全的猜测。 如果你每天插入20k行,设计将不同于每天插入5行。 另外,如果你需要每天对任何类型的一栏进行20k搜查,或每天进行5次搜查。 这会影响到你如何编制表格。

既然如此,一般做法可能是做这样的事情:

50+重叠专业表将是一个夜校,负责撰写有关询问。 我将尝试提出1个主要的一般表格和5个或5个以上其他一般表格,其中你可能将几部分分成“单一表格的切身”部分(如果你可能有几栏不适用于每一类,但列入这些表格,以便你能够涵盖尽可能多的几栏)。 从那以后,与EAV类似做法的其余各栏。

问题回答

暂无回答




相关问题
How to model a many-to-many relationship in App Engine?

I have a question regarding how to model a many-to-many relationship in App Engine: A Blogentry can have many tags, a tag can apply to many blog entries. I see a couple of scenarios: Use a Set of ...

How to emulate tagged union in a database?

What is the best way to emulate Tagged union in databases? I m talking about something like this: create table t1 { vehicle_id INTEGER NOT NULL REFERENCES car(id) OR motor(id) -- not valid ... } ...

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 ...

How to best implement a 1:1 relationship in a RDBMS?

Yesterday while working on a project I came up on a peculiar 1:1 relationship which left me wondering - how to best implement this (clearly, we had done it wrong :D) The idea is that there are two ...

Automatic filling entity properties

I have some type an architect(?) question I develop an application, based on Spring and Hibernate (annotated configuration) For each table in my database I added 4 fields: createdBy and modifiedBy(...

热门标签