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

yi02Asked:
Who is Participating?
 
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
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.