Re: [OT] "advanced" database design (long)
От | David Fetter |
---|---|
Тема | Re: [OT] "advanced" database design (long) |
Дата | |
Msg-id | 20080204162228.GL4626@fetter.org обсуждение исходный текст |
Ответ на | Re: [OT] "advanced" database design (long) ("Masse Jacques" <jacques.masse@bordeaux.cemagref.fr>) |
Список | pgsql-general |
On Mon, Feb 04, 2008 at 10:49:51AM +0100, Masse Jacques wrote: > Hello [much garbage including HTML trimmed.] Please set your mail client to text-only. HTML does not make your point better, and it annoys the heck out of people whose mail readers use text. > This model is known as Entity-Value-Attribute and not well > appreciated by relational designers. I think it is not relational, > but I use it as storage for data (in some case, I don't know the > database structure -relational- where data will be stored). It's > like a truck container used for office removal :). It's more like sitting on a land mine and hoping it won't go off. > Imho, don't use it with a complex database structure; as a minimum, > use lookup tables for Value (to avoid uncontrolled new parameters) > and add a column to store the attribute type. Putting lipstick on the EAV pig does not help. Cheers, David. -- David Fetter <david@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate
В списке pgsql-general по дате отправления: