I am planning to create a java application which run as a standalone desktop application. I am trying to find the suitable database for it.
Below are the constraints -
Database should be standalone and should be maintainable along with the application.
Write frequency = 100 records(each record is 100 characters) / 3 secs
Read frequency(each query has 2 inner joins) = 10,000 records(each record is 100 characters) / 3 secs
Size of the database on hard disk wouldn't exceed 50 MB
What database is more suitable in this scenario and why? I have few in mind(my mind is open for other DBs as well) -