Re: Database schema for univesal usage

From: Bernard Peek <bap_at_shrdlu.com>
Date: Mon, 9 May 2005 22:32:04 +0100
Message-ID: <UuEkQgJUb9fCFw6H@shrdlu.com>

In message <1115646883.597498.284870_at_o13g2000cwo.googlegroups.com>, Chris <cw23_at_greenmail.ch> writes

>I nearly can believe that noone has tried to build a multi purpose
>table/view set which - once generated - does not need to be redesigned
>for any change of usage.

I think what you are describing is often called the Entity, Attribute, Value database system. It is one of those ideas that looks good on paper and continues to look good as long as it stays on paper. There are very real problems in managing the structure of the database, which is why there are no commercial implementations (that I know of.)

-- 
Bernard Peek
London, UK. DBA, Manager, Trainer & Author.

Received on Mon May 09 2005 - 16:32:04 CDT