Database Answers Header

Integrating Objects and Tables

Ancient Bristlecone

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.
The aspect of Mapping is discussed in more detail elsewhere.
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
Software Data Objects Design Studio Enhydra Open Source Java/XML Application Server
Vendor Object Driver France An Open Object Wrapper for Relational Databases
Vendor Persistence Vendor  
Vendor Polyhedra Vendor  
Vendor RogueWave Vendor Very popular
Vendor TopLink Vendor A Tool for Mapping Java Classes onto Relational Tables
WorkShop NetObjectDays 2000 Germany October 9-12th. 2000

[ Home Page | Ask me a Question | Email | FAQs | History of Databases | Useful Links ]

© IceBreaker WebDesigns 2000