Java embedded database with about 500 million of records : <p>In my Java application I need to use some kind of embedded DB (SQL or NoSQL doesn't matter), which is able to hold about 500 millions of records (mostly single table, but splittion to more tables is not an issue). The number of records is the key part. The task is simple: check if such string is in DB if not insert it. Also the DB will not be under heavy load. I've been thinking about Derby, H2, Hypersonic DB, HSQLDB or ... . Could you suggest?</p>

<p>Thanks</p>

<p>Pat</p>
