Inheritance implementation in relational model
i just came across with idea of implementing inheritance in relational database where i have seen there are about four apporaches
1. Map the entire class hierarchy to a single table
2. Map each concrete class to its own table
3. Map each class to its own table
4. Map the classes into a generic table structure
The fourth approach seems to be more comfortable and dynamic. I like to ask you guys about ur experience how you implement inheritance. It would be also great if you furnish me with sample code in java with hibernate that i can have at least more concrete picture of above mentioned theortical approaches.
Thanks in advance.
By Steven Hughes in forum Architecture and Design
Last Post: 02-19-2008, 08:07 AM
By hammera1 in forum Architecture and Design
Last Post: 07-26-2006, 04:26 PM
By William Yeo in forum Database
Last Post: 10-01-2002, 07:40 AM
By Jeff Johnson in forum .NET
Last Post: 07-23-2001, 03:36 PM
By George Palmer in forum VB Classic
Last Post: 05-18-2001, 12:11 PM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL