Re: Object Oriented Databases

-----Original Message----- 
From: oracle-l-bounce@xxxxxxxxxxxxx 
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Peter Barnett 


We are building a web application that will be 
accessing a database cache for its queries. 
Essentially, the system of record will be polled 
periodically and any updates will be applied to the 
cache database. One of the developers is pushing for 
an Object Oriented Database. Since we would be 
querying text data or xml I am not sure what it really 
buys us. 

His leading candidate is Intersystem Cache Database. 
...
----- Original Message ---- 
From: Robert Freeman <robertgfreeman@xxxxxxxxx> 
Roberts rule #110: 

When a developer comes recommending a "leading candidate" database... 
run...run...run... 

----------------------------
Peter 

Intersystems Caché has quite a good reputation, and I've come across it being 
used in the London Stock Exchange and a number of financial institutions 
(though I've never used it myself).

Robert's reservations about OO databases are not entirely unfounded - though a 
more cogent argument against abandoning Oracle and/or adding any other 
technology (even another RDBMS) is the cost and time taken to reskill 
developers and dbas. The question would have to be - is it worth it? Can you 
get the necessary skills in house or on the open market when you need them?

You might like to take a look as well at Oracle (formerly Tangosol) Coherence  
- see http://www.oracle.com/technology/products/coherence/index.html. It 
provides you with a wide range of distributed and hierarchical cache 
configurations/topologies (clustered, replicated, partitioned) and to configure 
appropriate data load and eviction strategies (polling sounds like a 
particularly dubious idea; think about lazy load, pre-load, time to live, 
update dependencies etc). You can also combine Coherence with Toplink or 
Hibernate if you want an O/R mapping layer included. Lots of information in the 
knowledge base.

HTH

Regards Nigel

Other related posts: