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

Polyhedra is a transactional IMDB with several methods for handling persistent data. (if data is not specified in the DDL as persistent it is transient. SQL transactions can be written to disk via a historian or journaled to disk. No chance to lose and data. Performance is on a scale of 20-40 times faster than a conventional "paging" disk-database running all in cache. We have seen 30k inserts and 40k updates PER SECOND on a 400 MHz Pentium running NT.

Active queries (persistent SQL queries that continue to send changes to client) provide additional features you need. The ORDB database is SQL with extentions to support inheritance, polymorphism, encapsulation of methods, and more.

See www.polyhedra.com

Look for the article about Polyhedra in the current addition of INFOWORLD Magazine!
<http://www.infoworld.com/cgi-bin/displayArchive.pl?/99/40/e03-40.75.htm>

ANGE username to westes wrote in message <7t684c$k7f_at_chronicle.concentric.net>...
>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 Tue Oct 12 1999 - 14:32:27 CDT