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