Scribd
Upload
16 views1 page

Database Inheritance Strategies Explained

Uploaded by

vishalwdv
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
16 views1 page

Database Inheritance Strategies Explained

Uploaded by

vishalwdv
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

5-Oct

2)Table per concrete class


----------------------------
-A seperate table is created for each class
-subclass table has super class columns +its own columns

Limitation:-
super class columns repeat in the sub class table
hence duplicate columns
-Annotations used
@MappedSuperClass instead of @Entity for the superclass
@Inheritance(strategy=InheritanceType.TABLE_PER_CLASS)
@AttributeOverrides
This annotation allows the super class column names to be changed in subclass table
________________________________________________________

3)Table per subclass


-----------------------
-There is a seperate super class table having supr class columns
-subclass tables are related with the super class table using foreign key[specified
by @PrimaryKeyJoinColumn applied in the subclass]
-Annotations used
@Inheritance(strategy=InheritanceType.JOINED)
@PrimaryKeyJoinColumn
____________________________________________________
Lab)table per subclass
Address
-------
String street,city,state,country,zip

Student
-------
int rollno
String studentName
Date admissionDate
Address perAddr
2 subclasses

PrimaryStudent
--------------
String grade

SecondaryStudent
--------------
float percentage

________________________________________________

You might also like