Unlike the object model, the traditional relational model does not support many-to-many relationships. In this XML model for example, a cardigan sweater (men's, size medium) could refer to many color swatches. Inversely, a given color swatch could refer to many different types of sweaters of various sizes. This is a many-to-many relationship.
In the relational model, these relationships are represented using intersection entities.
This figure illustrates the schema with the intersection entity of Size Color.
These intersection entities, if they are left in the model in this way, will require additional joins that slow down the mapping process to the XML model. One approach to this situation is to "de-normalize" these intersection entities by restricting the number of colors that a catalog item can have. The outcome of such an approach might be to increase maintenance costs; the model no longer accurately represents the real world, which might require a change in the future. Data changes such as these can also have ripple effects on the code.
EDI to XML: A Practical Approach SYS-CON Media, NJ - 19 hours ago NETDJ News Desk db4objects has announced that its db4o object database is now optimized for Microsoft's LINQ. With the new support, developers can choose an ...
Which EII Solution Is Right for You? Web Services Journal, NJ - May 8, 2008 Depending on the approach, the EII servers would appear to applications as an object database, a relational database, or an XML database. ...
Greensboro Radiology Selects InterSystems Ensemble As Enterprise ... Business Wire (press release), CA - May 5, 2008 Its product line includes the InterSystems CACHÉ® high-performance object database, Intersystems HealthShare? platform for regional and national electronic ...
Tally 9 -The Complete Business Solution Daily Mirror, Sri Lanka - May 9, 2008 ... Technology Engine) ? Tally 9 is the result of a perfect fusion between the Concurrent Multi-lingual Platform and Object Oriented Database Engine. ...
Data Access Patterns: Database Interactions in Object-Oriented Applications (paperback) (Software Patterns) by Clifton Nock Average Customer Review: based on 7 reviews. Customer Review: I have to disagree with the previous review. I will try to explain why I think 'b88zhou' review is inadequate after presenting my overview of this book. After reading numerous pattern books, it is nice to see a pattern book with very good organization. Each pattern is presented with the following subsections. * Description * Context ...
Object-Oriented Application Development Using the Caché Postrelational Database by W. Kirsten, M. Ihringer, M. Kühn, B. Röhrig, A.S. Rudd Average Customer Review: based on 5 reviews. Customer Review: Intersystems' Caché Postrelational Database is a relatively little known but very powerful & extremely scalable database engine, that has very few -if any- serious competitors in that features/price/performance group, especially after Intersystem changed their licensing policy recently. The book gives detailed information about Caché...
Object-Oriented Database Design Clearly Explained by Jan L. Harrington Average Customer Review: based on 7 reviews. Customer Review: "Object Oriented Database Design" is a book for beginners and, as far as I have been able to investigate, it is a perfect walkthrough along the background of object structures. Figures, exemples, syntax of codes and clear explanations lead the learner through theory towards practice. Exemples are often very nice.