Hibernate Community • View topic - Mapping a denormalized table

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Mapping a denormalized table

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

forkbomb

Post subject: Mapping a denormalized table

Posted: Thu Sep 30, 2004 10:56 am

Newbie

Joined: Thu Sep 30, 2004 10:31 am
Posts: 4

I've read the documentation, but I can't find any way to map a denormalized table. For example, suppose I have a CAT table that has several fields, but also has a relationship to a collection of multivalued attributes located in a CAT_ATTRIBUTE table. For example, the CAT_ATTRIBUTE table might contain the following data:

Code:

CAT_ID     CAT_ATTRIBUTE_ID    CAT_ATTRIBUTE_VALUE
------     ----------------    -------------------
SPARKY     COLOR               BROWN
SPARKY     COLOR               WHITE
SPARKY     EYE_COLOR           BLACK
SPARKY     FLUFFY              TRUE
JOE        COLOR               WHITE
JOE        EYE_COLOR           BLUE
JOE        EYE_COLOR           BROWN
JOE        FLUFFY              FALSE

In the object model, this would be represented as Cat has a collection of attributes, each of which has a collection of attribute values (Cat -> CatAttribute -> CatAttributeValue). The (admittedly not so great) database schema cannot be changed. Is this mapping possible using Hibernate?

Top