Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsWhite Papers
Discussion GroupsFirst AidDatabasesJavaBeansGUIJava 3DVirtual MachineCORBASecurityToolsGeneral
Java DirectoryOpen Source ProjectsSample Book ChaptersUser GroupsWeb Resources
Related Topics
Databases.NETMore Topics ...

Java Forum / Databases / November 2005

Tip: Looking for answers? Try searching our database.

DBModelled Storage in JAVA

Thread view: 
JK - 24 Nov 2005 17:52 GMT
Hi all,

Here goes my requirement . I hava a set of tables in Database , which
will be accessed by my application frequently . My application has to
answer a lot of queries and that too a lot faster for which the
database is not able to cope up with. So Iam in need to store all the
values in memory for faster retreival.

Is there any specific methodology to store all the values in the table
as it is present in the database
( am i clear here) or should i remodel the data and store it using
Collection (Vector,Hashtable etcc...) objects.

Is there any tool/project available satisfying the above requirement ?
i.e storing all the table data in memory so that i can retreive them
using Java Objects.  It would be nice if its free too !!

Thanks for your help.

Regards
JK
IchBin - 24 Nov 2005 18:36 GMT
> Hi all,
>
[quoted text clipped - 17 lines]
> Regards
> JK

Not sure if this is a suitable answer. You can change your database to
HSQLDB. You can run your DB from memory. http://hsqldb.org/

Signature

Thanks in Advance...
IchBin, Pocono Lake, Pa, USA
http://weconsultants.servebeer.com/JHackerAppManager
__________________________________________________________________________

'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor,  Regular Guy (1952-)

JK - 25 Nov 2005 02:33 GMT
I know about HSQLDB , it wil be faster than Traditional database but
will not be as fast as i have the data in memory . However thanks for
your reply.

Regards
JK
IchBin - 25 Nov 2005 04:52 GMT
> I know about HSQLDB , it wil be faster than Traditional database but
> will not be as fast as i have the data in memory . However thanks for
> your reply.
>
> Regards
> JK

Will not be all that much faster since you can define the table to load
and run from memory.

Define table as.. *CREATE MEMORY TABLE t*
Signature


Thanks in Advance...
IchBin, Pocono Lake, Pa, USA
http://weconsultants.servebeer.com/JHackerAppManager
__________________________________________________________________________

'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor,  Regular Guy (1952-)

JK - 25 Nov 2005 06:04 GMT
Hi,

Though HSQLDB will store data in memory , it will not be as fast as
accessing objects. I want use an Object model to retreive the data .
One more thing , I will have huge amount of data , only a part of which
will be stored in memory . So its really difficult to have and maintain
two DB engines.

I need a Object Modelled Approach.

Regards
JK


Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.