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

My question will reflect the fact that my experience is limited to PC-based dbms' (Paradox, Access): OTHER THAN SPEED, why would a user be concerned with when software flushes its info to disk? Why specifically try and find a system which implements its work in memory?
Doug Kanter
dkanter_at_eznet.net

CHANGE username to westes 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
Received on Thu Oct 21 1999 - 13:18:28 CDT