Solved

Secure Embedded Database

Posted on 2011-02-15
2
637 Views
Last Modified: 2012-05-11
I'm doing some retail software that I plan to distribute, and security of the data is a big issue. Not so much that the data is sensitive, but that I need to secure it from users being able to access it outside of the application. Reason being is that it ties back into my company that I would offer an additional data access option (Web), but if they have free access to it, then the push is pointless.

I can't require an internet connection, so SQL Server and MySQL are out. I know I can embed MySQL, but I just don't want the hassle of handling that in my JAVA app.

SQLite seems to lack any real security, but I have read that you can use SQLCipher to encrypt the database and decrypt at need for the data. How effective has this been for others? Is this a reasonable option?

What about HSQLDB? That seems to have a bit more options that I'd like to take advantage of, but I can't find much information on the web regarding security of the data.

JavaDB promotes security, but I haven't had a chance to play with it yet. Do you have any experience with it? Is it capable of what I'm after? Or maybe other suggestions?

Any and all suggestions would be greatly appreciated. In case it matters, this will be a swing application.
0
Comment
Question by:ALaRiva
2 Comments
 
LVL 6

Accepted Solution

by:
dr_linux earned 500 total points
ID: 34898682
If it's not tons and tons of data you simply read and write the data in files and encrypt and decrypt the data using something like
http://www.experts-exchange.com/Programming/Languages/Java/Q_23044531.html

Db4o is another option for a Java embedded database.  Works really well with Java.  However I used it back when it was free and I really didn't use any security at the time.  It has come a long way since then (and it is now commercial) http://www.db4o.com/ 
0
 
LVL 10

Author Closing Comment

by:ALaRiva
ID: 35993087
Not exactly what I was looking for, and this is far from resolved, but the provided information helped open up a few ideas and set me ahead a bit further in the project, so I feel points are appropriate.

Thank You.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
The viewer will learn how to implement Singleton Design Pattern in Java.
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now