Query navigation

Querying object structures requires navigation. An example object structure was shown on the navigating objects page (new window). An example of an ODMG OQL query follows. This query appears in the published ODMG standard (new window). For those of you who know SQL, you will notice that it is similar to an SQL query, but with object extensions. The similarity occurs because OQL is based on SQL-92.

select c.address
from Persons p,
   p.children c where p.address.street = "Main Street" and
count(p.children) >= 2 and
c.address.city != p.address.city

The "dot" notation used in the query traverses the data structure shown on the navigating objects page (new window). The query inspects all children of all Persons to find people who live on Main Street with at least two children. It returns only those addresses of children who do not live in the same city as their parents. It navigates from the Person class using the child reference to another instance of the Person class and then to the Address and City classes.

ODMG OQL is not the only way to write these object queries. Similar queries can be written using the other query languages used by some of the object database products.

Based on this information, we can now go to the better DBMS Matrix page.

 

Web Services and Service-Oriented Architectures
Online articles>
Consulting
Mentoring
Speaking
Suggested programs
Stencils for the Savvy Manager's Guide
Links
Mail list
Privacy policy
Sitemap
Contact
Web Services articles
XML standards and vocabularies
Application server articles
Database concepts and standards
Object database articles>
Relational database articles
Object-relational mapping articles
XML database articles
XML middleware articles
Article Sponsorship
Reprint policy
Object-oriented database management system (OODBMS) definition
When an object database should be used
ODBMS FAQ
Caching for object database management systems
Architectures that use object database products
Everyday uses of object databases
ODBMS myths>
Object database problems?
Article suggestions
Myth: ODBMSs have a steep learning curve
Myth: ODBMSs are slow
Myth: ODBMS do not support queries>
Myth: ODBMS products do not scale
Stonebraker's DBMS Matrix>
Errors in Stonebraker's DBMS Matrix
Navigating objects
Query navigation>
A better DBMS Matrix

Related recent articles from Google News


db4o First Open Source Object-Oriented Database in the Industry to ...
Business Wire (press release), CA - May 5, 2008
(BUSINESS WIRE)--db4objects (www.db4o.com), creator of the leading open source object database, has announced that its db4o object database is now optimized ...

SYS-CON Media

I am a big fan of Flex...but it is not a tool that every ...
SYS-CON Media, NJ - 13 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 ...

Developer Spotlight Series: #12
AndroidGuys, OH - May 13, 2008
StuffBee will not concurrence existing associations and websites; instead, we will contact them in order to broadcast our ?free object database? ...

Where 2.0 Keynotes: EveryBlock, Nokia, FortiusOne
O'Reilly Radar, CA - May 13, 2008
... to get their applications to run efficiently on traditional databases, before they decided to build a lightweight object database on their own. ...

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. ...

More related news: "object database" OR "object-oriented database" - Google News

Related books at Amazon.com


Data Access Patterns: Database Interactions in Object-Oriented Applications (paperback) (Software Patterns)
by Clifton Nock
Average Customer Review: 4 stars 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 ...

The Object Database Handbook: How to Select, Implement, and Use Object-Oriented Databases
by Douglas K. Barry
Publisher: Wiley
Publication Date: May 1996

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: 2 stars 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: 3 stars 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.

Introduction to Object-Oriented Databases (Computer Systems Series)
by Won Kim
Publisher: The MIT Press
Publication Date: November 1990

More related books: Search Amazon.com for object database

 

Copyright © 2000-2008 Barry & Associates, Inc. All Rights Reserved.
You can use this material for your work or classes. Click here for our reprint policy.
www.service-architecture.com

 

 Information on becoming a sponsor

 

 

Google

 

Barry & Associates, Inc.