Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 161
  • Last Modified:

Is there generic database engine or file type (binary etc) to hold data in tabular format (e.g. microsoft Access file in window) that can implement database capacity in a platform independent way?

Dear all:

Is there generic database engine or file type (binary file etc)  to hold data in tabular format (such as microsoft Access file in window) that can implement database capacity in a platform independent way (Window, Mac, Unix/Linux etc)? the "database capacity' means between these files or within the file, I can do database query or join tables etc. In other words, I am looking for generic method or file that can allow my java program to have database capacity  (not neccessary to be complex capacity but very basic database capacity e.g. simple query or join operation etc) but DO NOT have to install any full database engine such as microsoft access, mysql or oracle etc. Anybody has an idea how to do that?
Thanks a lot

yi02

0
yi02
Asked:
yi02
2 Solutions
 
petmagdyCommented:
Hi yi02,
Their are free embeded database engines like cloudscape, pointbase, berkley db, others....

refer to this link for reference:

http://www.devx.com/IBMCloudscape/Article/21773

Cheers!
0
 
TimYatesCommented:
http://www.devarticles.com/c/a/Java/Using-CSV-Files-as-Databases-and-Interacting-with-Them-Using-Java/
http://www.koders.com/java/fid5AC087BE0E0F1197CD4CE8CDC6971464D17C3BC8.aspx

But you won't get any form of locking, or transaction management (commit/rollback)

Why not just include MySQL or Postgres?  THey are both free..
0
 
bloodredsunCommented:
or HyperSonic or Sqlite as other embedded DB options
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
TimYatesCommented:
Hypersonic is quite cool actually :-)  I had a go the other week, and was suprised ;-)
0
 
yi02Author Commented:
Dear TimYates and others:

regarding your comments:
Why not just include MySQL or Postgres?  THey are both free..
Because I want my application work through java web start and do not want to bother users to install MYSQL or postgres even they are free. My applciation did use remote centralized database in our server (this is going to be a 3-tier archtecture with user front end, java servlet and server side database. I wish the front end can has some database capacity in user's local machine and do not bother to access the remote database all the time. So I am looking for some light database capacity which can come along with my program to the user's local machine with minimal installation requirement. That is the point I am looking for such things if existing.

Any more suggestions, thanks a lot.

yi02
0
 
petmagdyCommented:
yi02,

that;'s why i recommend to try my link as those are java based embeded database engines

Cheers!
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now