This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
Hi Malatesh, good question. Many people tend to take it lightly.
The choice of data store completely depends upon the type of desktop application you are creating.
1. If you want a light weight and portable option, I'll recommend SQLite. For instance browsers like Mozilla Firefox use SQLite to store the bookmarks we create. But it has certain limitations. Visit http://www.sqlite.org/ for more details.
2. Another powerful option, I recently learned about is Cassandra. I believe you must be using Facebook and I hope you agree that it is fairly quick. It uses Cassandra as its backend. I think this is a very good option, since you get to learn something new too. http://cassandra.apache.org/
3. Other options include Oracle, MSSQL, MYSQL and PostgreSQL and are more powerful, conventional databases that allow loads of capabilities.
Thank you Pranav Raulkar and Nico Van Belle, that looks like exactly what I was looking for. Let me go through all the hints you have given. By the way I am having the data exactly like bank transaction details.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
subject: Data store Options in Java for Desktop Applications