Re: Best practice on inherited tables - Mailing list pgsql-general

From Frank Lanitz
Subject Re: Best practice on inherited tables
Date
Msg-id 51989C2D.4050106@frank.uvena.de
Whole thread Raw
In response to Re: Best practice on inherited tables  (Alfonso Afonso <aafonsoc@gmail.com>)
List pgsql-general
Am 17.05.2013 21:21, schrieb Alfonso Afonso:
> Hi Frank
>
> Although you are thinking in OOP, the SQL is itself one definition
> model that you should not ignore and, IMHO, try to follow the
> normalization statements.
>
> You can build a robust and normalized schema (table primarylocation ,
> table secondlocation that have a idprimarylocation, etc.) and later
> you could build your OOP software translating this to the proper
> classes (in Java you could use a DAO-POJO class or hibernate-jpa, for
> example).
>
> With this solution you can obtain all the benefits of DBRMS besides a
> OOP robust software :)

I was really thinking about this way as it's tradition relational model
and of course kind of a rock stable solution. But I have the fear that
it will end up in a real mess of joins at database layer in the end so I
thought to make usage of such a feature if available ;)

Cheers,
Frank


Attachment

pgsql-general by date:

Previous
From: Chris Travers
Date:
Subject: Re: Best practice on inherited tables
Next
From: Julian
Date:
Subject: Re: Best practice on inherited tables