Re: [MonetDB-users] can we create cache group in MonetDB

24 Sep 2007

      On 9/24/07, Pradeep Gowda  wrote:
...
On 9/24/07, Niels Nes  wrote:
...
On Fri, Sep 21, 2007 at 01:56:04AM -0700, pawan123 wrote:
...
all we know about Timesten Database with oracle. can we use this
   MonetDB like Timesten Database with oracle.means can we create cache
   group in MonetDB. Thanks Pawan
I have great problems understanding your question. Could you rephrase
your question?
I think he wants to know whether he can use
http://en.wikipedia.org/wiki/TimesTen with MonetDB.
From the wikipedia entry, TimesTen provides "low latency, high-volume
data, event and transaction management".
AFAIK, MonetDB's design goals are not in the area of transaction
managment, but more in OLAP and analysis.
On reading further about TimesTen, i see that TT uses in-memory
caching to provide boost to data access. (Perhaps, the name Times Ten
refers to speedup in data acess rates).  Traditional row oriented
databases are "slow" for 'read-mostly' kind of scenarios. So,
solutions like TT try to address that issue by caching the data in
memory, thus trying to overcome disk latency etc.

MonetDB already achieves this by rethinking how data is stored and
using a column oriented approach to increase read-speeds.

TT acts as a caching server to a row oriented database like Oracle,
where MonetDB is a DBMS itself(like Oracle), with its own novel
storage engine.

MonetDB = Oracle + Caching(eg: TimesTen) ?

-Pradeep