Hi,
Doing my masters project, was wondering if any one had any suggestions.
My data set keeps rapidly changing. So instead to reduce inconsistency in the database. I am using was thinking about using HyperSonic database, which is a database that resides completely in the RAM. TO make the data persistant I would write it intermittently to another (persistant) database.

Anybody have a better suggestion???

umm well Hypersonic SQL operates in one of three modes: in-memory, standalone, and client/server. The most useful one is the standalone mode where one application accesses the database exclusively.

Hypersonic SQL has several interesting characteristics: It is written entirely in Java, so it will run on all the Java platforms; it is compact, weighing only 155 K and, since it is an open source project, there is no per CPU license.


well the important part is it depends what type of project you are in

If you look for alternative Java databases with mainstream offerings. There are excellent Java drivers for the major databases in the market: Oracle, IBM DB2, Sybase, and Microsoft SQL server.

Still, these databases were designed for enterprise-level applications. They are complex and costly products. Their power, which is a strength for server-side development, becomes a liability for desktop or standalone projects.

cheers