Re: schema design question

From: "mark overmeer" <markovermeer(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: schema design question
Date: 2007-08-19 15:23:14
Message-ID: ea41f7570708190823m5b63fc85jfe57c2d3b5d4d842@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi Adam,

Thanks for the fast reply. What should inherit from what? Class A (e.g.
'todo item') is certainly not derived from property X (e.g. 'startdate').
Class A version 2 has different properties (some are removed, others are
added). Can you elaborate / say I'm wrong / give an example ? Thanks,

Mark

2007/8/19, Adam Tauno Williams <adamtaunowilliams(at)gmail(dot)com>:
>
>
> > Maybe not completely the wright place to ask but... I have this schema
> > design question (db is postgres of course). I have a couple of classes
> > with attributes. The only goal is to search the object that I want to
> > find (which is stored on the harddrive).
> > I have hundreds of classes that are similar but not the same. They all
> > have attributes/properties (type is probably String), e.g. (in pseudo
> > code):
>
> Use table inheritance.
>
> --
> Adam Tauno Williams, Network & Systems Administrator
> Consultant - http://www.whitemiceconsulting.com
> Developer - http://www.opengroupware.org
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message David Fetter 2007-08-19 18:12:16 Re: schema design question
Previous Message Adam Tauno Williams 2007-08-19 14:24:14 Re: schema design question