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