Database Answers Header Maldive Islands is a great break from job-Hunting
Integrating Objects and Relations
Home Ask a Question Careers Data Models FAQs SQL Scripts Search Site Map  
Background

There are a number of alternatives for mapping Objects onto Tables :-

  1. Store everything in one table
  2. Create one table per class and one SQL view per superclass/subclass relationship
  3. Create one table per subclass (in the case of inheritance that includes superclass attributes as well)

Each alternative has different Performance implications which need to be evaluated for any specific situation.
Here are some Useful Links ...
CATEGORY LINK ORIGIN DESCRIPTION
Books Amazon.com Michael Stonebreaker Object-Relational DBMSs,(ISBN 1-55860-397-2)
Books Amazon.com Oracle Building Web Applications with UML(4.5 Stars)
Books Amazon.com Oracle Business Modelling with UML (4 Stars)
Books Amazon.com Oracle Design using UML Object Modelling (ISBN 0-07-882474-5)
Books Amazon.com Paul Reed Developing Applications with Visual Basic and UML
Books Amazon.com Oracle Enterprise Modelling with UML (4 Stars)
Books Amazon.com Oracle UML Distilled - a Brief Guide to the Standard Object Modelling Language (4 Stars)
Books Amazon.com Oracle Visual Modelling with Rational Rose 2000 and UML (4 Stars)
Consultants Object Architects Germany Worth checking out
Consultants Object Architects Germany Patterns for Object/Relational Layers
Developers Wolfgang Keller Germany Paper on Architecture
Objects in Use including Jim O'Connell's Answer    
Publication Scott Ambler USA Paper on Mapping Objects Relational Databases(pdf file)
Publication Scott Ambler USA List of Scott Ambler's Online Writings
Vendor Data Objects Design Studio Enhydra Open Source Java/XML Application Server
Vendor New Hibernate Open Source Tool for Object-Relational Mapping - controversial to use.
Offers its own portable SQL extension (HQL), and native SQL, or an object-oriented API.
Vendor Object Driver France An Open Object Wrapper for Relational Databases
Vendor Persistence Vendor  
Vendor Polyhedra Vendor  
Vendor RogueWave Vendor Very popular
Vendor TopLink Oracle Tool that Maps Java Classes onto Relational Tables.
Vendor TopLink Oracle Discussion 1.
Vendor TopLink Oracle Discussion 2.
Vendor TopLink Oracle Discussion 3.
 

[ Home Page | Ask a Question | Contact Us | Email Us | Search | Site Map ]

© DatabaseAnswers.com 2006