I have a very large hierarchy of domain objects like this one:
------------
| Person |
------------
^
|
|
------------ ------------ ------------ ------------
| PersonA | | PersonB | | PersonC | | PersonD |
------------ ------------ ------------ ------------
And the apropiate relationship diagram to support polimorphis to
this model is:
tbl_person
----------
id_person PK
name
phone
tbl_person_a
------------
id_person FK
other different attributes
tbl_person_b
------------
id_person FK
other different attributes
tbl_person_c
------------
id_person FK
other different attributes
tbl_person_d
------------
id_person FK
other different attributes
But is to complex to model that with CMP, because when i need to access
the attribute name of the super class Person, i need to get a reference
to a Person entity from the relationship with the entity PersonB (for
example)
Is more natural to have, the same database schema, but with an
abstraction layer with four updatable views. This views give to the
tbl_person_c the common attributes of the tbl_person.
I plan to use oracle as DBMS, so i dont think as the uptable views as a
restriction.
Someone, take this approach?
In general, a J2EE Application Server, support this? the application
server view a updatable view as a table?
TIA
--
Juan Alvarez Fluidsignal Group S.A.
mailto:[EMAIL PROTECTED] http://www.fluidsignal.com/
Key fingerprint: 15C4 0986 A174 862A B607 8EEA 934F 8649 07E2 EA40
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
