Re: generic modelling of data models; enforcing constraints dynamically...

Поиск
Список
Период
Сортировка
От David Fetter
Тема Re: generic modelling of data models; enforcing constraints dynamically...
Дата
Msg-id 20090926202349.GC7952@fetter.org
обсуждение исходный текст
Ответ на generic modelling of data models; enforcing constraints dynamically...  (InterRob <rob.marjot@gmail.com>)
Ответы Re: generic modelling of data models; enforcing constraints dynamically...  (InterRob <rob.marjot@gmail.com>)
Список pgsql-general
On Thu, Sep 24, 2009 at 06:28:28PM +0200, InterRob wrote:
> Dear List,
> I am trying to implement the following:
>
> In a database I wish to implement a GENERIC datamodel, thus on a
> meta-level.

That's not a very bright idea, even though it seems so when you first
think of it.

Relational database management explicitly trades flexibility for size
and speed.  You won't be able to constrain the things you think you'll
be constraining, and the query complexity will go up like O(n!).

Instead of going down this dead-end road, get the stakeholders
together, try a few prototypes of your schema, get them together
again, etc.

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 по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Column names in rowsets returned from function
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: