Re: OT: OpenDatabase Model ? - Mailing list pgsql-sql

From Jesper K. Pedersen
Subject Re: OT: OpenDatabase Model ?
Date
Msg-id 44E37A1A.7080006@solnet.homeip.net
Whole thread Raw
In response to Re: OT: OpenDatabase Model ?  (Andrew Sullivan <ajs@crankycanuck.ca>)
Responses Re: OT: OpenDatabase Model ?
List pgsql-sql
Andrew Sullivan wrote:

>On Wed, Aug 16, 2006 at 06:12:06PM +0200, Jesper K. Pedersen wrote:
>  
>
>>Doing a bit of database work for several friends (golf clubs and so on) 
>>I was very keen to start using a sort of "standard" and not least open 
>>database model with predefined tables.
>>    
>>
>
>If I understand your question correctly, I think this is what the
>various Normal Forms are for, no?
>
>A
>
>  
>
I may be a bit "vague" in saying what the project was about as the last 
time I visited them was when they were actually active and offering 
standard table defenitions.
The normal forms are as far as I know just how you decide to tie 
together your tables.

The opendatabase model actually offered a standard set of table 
definitions covering a wide range of data storage.

Of course this means that the tables would often have stuff you dont 
need, and may not have the things you need, but at least there is a 
common "thread" in how you different databases look. For the big company 
that can afford having people optimizing databases that isnt the best 
choice, but for the common small scale users it is rather nice that we 
dont have to reinvent the tables each time we make a new database.

Best regards
Jesper K. Pedersen


pgsql-sql by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: DB creation script questions
Next
From: Kyle Bateman
Date:
Subject: Re: Using bitmap index scans-more efficient