Choosing the Right OODB Solution


Performance
As I discussed in
Object Oriented Databases Are Worth a Closer Look, OODBs excel in some performance areas and fall short in others. Although details about the performance benchmarks for each product would be too extensive to cover here, an understanding of the architecture and feature limitations that could hinder performance is important.

Criteria Look for...
Locking strategy Depends on the application—object-level locks can provide more confidence, but page-level locking mechanisms can fly under certain conditions
Load balancing Ability to transparently distribute database, invoke method calls on remote servers, share objects in concurrent threads/accesses
Maximum database size Bigger is better
Transaction support Checkpoints: one transaction shared by multiple threads, one thread sharing multiple transactions, nested transactions; Ensure that you understand how synchronization across client/server works in combination with client-side caching in case the implementation of a given product affects your application.
Query/performance profiler Ability to extract information, which assists you in debugging performance bottlenecks; OODBs typically offer fewer optimization and tuning options than RDBs, but tools that help you profile and explain queries still can be very useful.

Scalability and Availability
Although not every project needs enterprise recovery, availability, and scalability functionality, knowing that your chosen OODB solution can grow with your project down the road still is worthwhile.

Criteria Look for...
Failover Transparent switch to redundant database when the primary server experiences problems
Load balancing Ability to distribute performance across redundant servers, partition objects across servers, and synchronize views of data across client-side object caches
Replication and incremental backup Ability to seamlessly duplicate data to support load balancing or recovery
Ad hoc query engine Rich query language that allows rapid access to data, ideally can join information across objects that do not have direct associations

Compatibility and Features

Product Reviews

In this Article
Introduction Performance and Scalability/Availability
Compatibility and Features Product Reviews


Read Part 1 of the OODB series: "Object-Oriented Databases Are Worth a Closer Look"







FEATURE SOFTWARE:
SQLDC
Create SQL applications quickly and easily.
Buy Now!

FEATURE BOOK:
VBCommander
Speed app and component design time with this set of more than 20 add-in tools.
Buy Now!


The Database Development Zone has all the content and resources you need to fine-tune your data access apps.

Read Part 1 of the OODB series: "Object-Oriented Databases Are Worth a Closer Look"

Read Part 2 of the OODB series: "Using Object-Oriented Databases: A Step-By-Step Tutorial"

OODB newsgroup: comp.databases.object

Java DB newsgroup: comp.lang.java.databases

Cetus Links OODB Section

Akmal Chaudhri's excellent OODB site and his "Succeeding with Object Databases" book

Join the discussions in the DevX Database Design forum

Barry & Associate's compliance matrix

Barry & Associate's ODBMS Fact Book





 
Sponsored Links

Advertising Info  |   Member Services  |   Contact Us  |   Help  |   Feedback  |   Site Map
Jupiterweb networks

internet.comearthweb.comDevx.comClickZ

Search Jupiterweb:

Jupitermedia Corporation has four divisions:
JupiterWeb, JupiterResearch, JupiterEvents, and JupiterImages

Copyright 2004 Jupitermedia Corporation All Rights Reserved.
Legal Notices, Licensing, Reprints, & Permissions, Privacy Policy.

Jupitermedia Corporate Info | Newsletters | Tech Jobs | E-mail Offers

Copyright Information/Privacy Statement