Re: schema design question

Поиск
Список
Период
Сортировка
От mark overmeer
Тема Re: schema design question
Дата
Msg-id ea41f7570708190823m5b63fc85jfe57c2d3b5d4d842@mail.gmail.com
обсуждение исходный текст
Ответ на Re: schema design question  (Adam Tauno Williams <adamtaunowilliams@gmail.com>)
Список 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@gmail.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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Adam Tauno Williams
Дата:
Сообщение: Re: schema design question
Следующее
От: David Fetter
Дата:
Сообщение: Re: schema design question