Postgresql database - Mailing list pgsql-sql
| From | Trinath Somanchi |
|---|---|
| Subject | Postgresql database |
| Date | |
| Msg-id | AANLkTikmPaFrIhuYUkxuhsC6kRgRJlmb0IfFAb7EE2x-@mail.gmail.com Whole thread Raw |
| Responses |
Re: Postgresql database
Re: Postgresql database Re: Postgresql database |
| List | pgsql-sql |
Hi All,
--
Regards,
----------------------------------------------
Trinath Somanchi,
I have Tree structured database to maintain.
Its as follows.
Vehicles
|__> Two Wheelers
|__> Manufacturer
|__> Name of Manufacturer
|__> Year of make.
|__> Manuf. Plant.
|__> Model.
|__> Model Name
|__> Model Version
|__> Model Re-make Version.
|__> Year of Release
|__> Serial Number
|__> Capacity
| |__> Capacity Type
| |__> Capacity Version
|__> Contact Information
|__> Company Name
|__> Company Address
| |__> Street Address
| | |__> Lane 1
| | |__> Lane 2
| |__> City
| |__> Pin
|__> Contact Information
| |__> Phone
| |__> Fax
| |__> Email
|__> Website
|__> Three Wheelers
|__> Manufacturer
|__> Name of Manufacturer
|__> Year of make.
|__> Manuf. Plant.
|__> Model.
|__> Model Name
|__> Model Version
|__> Model Re-make Version.
|__> Year of Release
|__> Serial Number
|__> Capacity
| |__> Capacity Type
| |__> Capacity Version
|__> Contact Information
|__> Company Name
|__> Company Address
| |__> Street Address
| | |__> Lane 1
| | |__> Lane 2
| |__> City
| |__> Pin
|__> Contact Information
| |__> Phone
| |__> Fax
| |__> Email
|__> Website
|__> Four Wheelers
|__> Manufacturer
|__> Name of Manufacturer
|__> Year of make.
|__> Manuf. Plant.
|__> Model.
|__> Model Name
|__> Model Version
|__> Model Re-make Version.
|__> Year of Release
|__> Serial Number
|__> Capacity
| |__> Capacity Type
| |__> Capacity Version
|__> Contact Information
|__> Company Name
|__> Company Address
| |__> Street Address
| | |__> Lane 1
| | |__> Lane 2
| |__> City
| |__> Pin
|__> Contact Information
| |__> Phone
| |__> Fax
| |__> Email
|__> Website
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.
Thanks in advance.
--
Regards,
----------------------------------------------
Trinath Somanchi,