Re: Database for EAV model

> There are a couple of options. Please see my blog:
> 
> 
> ttp://weblogs.java.net/blog/terrencebarr/archive/2007/
> 12/databases_for_y.html
> 
> The fundamental question is: WHat is your platform
> (CLDC/MIDP or CDC)? That determines some of the
> database choices you can make.
> 
> -- Terrence

Thanks for your reply and great link!
The targeted platform would be CLDC/MIDP and it would be deployed on mobile phones.

But here are my problems (please bear to read :) ):

#1. Most of the API's (OpenBaseMovil, Perst Lite (rms), Floggy and J2MicroDB) are based on the RMS (Record Store) of the J2ME. But I found out that the RecordStore's maximum size varies for each phone and most are limited to ~1MB (e.g. Nokia S40 devices). As you've noticed, the records that I'm expecting to handle are really huge and I should have store it in only one table (EAV model). I doubt if "simple Java-enabled phones" can allow this amount of bulk/size. (though, I [b]must still[/b] try it).

#2. My second option is to use a file-based database. And the Perst-jsr75 is the only one that I've found. The problem is : I haven't seen even a single example using this API. The only example I've found out for Perst Lite is the ProScout/Basketball project (that you've also mentioned in one of your blog :) ) but I believe it uses the perst-rms and not the perst-jsr75 API/jar.

#3. My other option is to use the SQLite. But then again, I haven't seen any manual/guide that shows how to install/embed this one(SQLite) on a mobile phone. I'm also not sure if it's possible to use, because as far as I know (not so far), there is no JDBC API available yet for CLDC/MIDP platform.

and #4. And my last resort, I believe, is to store the data/records on a 'flat' or an xml file. And I assume this is gonna be a daunting task (both for me and the running device).!


Sorry for a lengthy reply and hoping for your reply :)...


(p.s. I've mentioned "simple Java-enabled phones", because the application will be (hopefully) deployed on[b] rural community health centers[/b] here in the Philippines and the cost of the phone is highly considered. Also, the doctor suggest that the cellular phone must act like a simple desktop computer which denotes the large database to be stored/maintained. Lastly, sorry for my 'quite' troublesome English :) )
[Message sent by forum member 'public2public' (public2public)]

http://forums.java.net/jive/thread.jspa?messageID=297842

===========================================================================
To unsubscribe, send email to [email protected] and include in the body
of the message "signoff KVM-INTEREST".  For general help, send email to
[email protected] and include in the body of the message "help".