From: | Leif Biberg Kristensen <leif(at)solumslekt(dot)org> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Postgresql database |
Date: | 2010-05-14 09:51:02 |
Message-ID: | 201005141151.02716.leif@solumslekt.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Friday 14. May 2010 10.42.17 Trinath Somanchi wrote:
> Hi All,
[snipped]
> This way the data in the table is tree structured. Also A single
> manufacturer has all mode of vehicles. I'm in my way to design this DB for
> use in PgSQL. But for a vast data, data retrieval is a very costly task
> (Joining all tables).
>
> Can any one guide me of this design, on how the structure looks like. Hard
> about Inheritance feature of pgSQL. But not aware of how implementation
> goes.
You should think about a more normalized structure. Think about a table of
"manufacturers", and a table of "models", the latter with a foreign key
referencing the id of the former. The number of wheels is obviously an
attribute of "models".
regards,
--
Leif Biberg Kristensen
http://solumslekt.org/blog/
From | Date | Subject | |
---|---|---|---|
Next Message | silly sad | 2010-05-14 10:23:19 | Re: Postgresql database |
Previous Message | Trinath Somanchi | 2010-05-14 09:28:03 | Re: Postgresql database |