Re: Looking for in-memory database that can write to disk as well

In article <7t684c$k7f_at_chronicle.concentric.net>,   "CHANGE username to westes" <junkmail_at_uscsw.com> wrote:
> I'm looking for vendors who sell a specialized kind of database. I
need the
> database to be implemented in memory, but with the ability to flush
changes
> in the database to disk as a background operation. This will be
used to
> store temporary data that needs to be accessed from multiple
machines, but
> which by its nature does not require saving to disk *as part of the
> transaction* that creates the data.
>
> Ideally, the database would allow a transaction from a remote client,
write
> the information to memory, then notify the client that the
transaction is
> finished. Later, as time allows, the database would flush the
transaction
> to disk for permanent storage, so it would be available the next time
it
> starts up.
>
> Of course we could implement this ourselves, using a write cache
layer on
> top of a commercial database, but I'm hoping someone already has this
done
> as a product, or maybe there is an option in some commercial
databases for a
> table attribute that means something similar to "write-back
transaction".
>
> Any pointers or tips are appreciated.
>
> --
> Will
>
> NOTE: To reply, CHANGE the username to westes AT uscsw.com
>
>

An Object Database can do this very well. Some vendor sites can be accessed from http://www.odmg.org/

I maintain a couple of pages on OODBs, including some resources and benchmarks, e.g.

http://www.soi.city.ac.uk/~akmal/html.dir/benchmarks.html http://www.soi.city.ac.uk/~akmal/html.dir/resources.html

Another good site to get info is Cetus:

http://www.cetus-links.org/

Caching in such products can be very effective - something I've seen myself in some research work and through various case studies with industry. Such products can also be used as a fast cache for an RDB - I have heard of several cases.

akmal

--
[ http://www.bigfoot.com/~akmal_chaudhri ]

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Oct 03 1999 - 05:10:07 CDT