-----Original Message-----
From: oracle-l-bounce@freelists.org
[mailto:oracle-l-bounce@freelists.org]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@yahoo.com>
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
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 19 2007 - 05:12:57 CDT
