in memory db of 200 GB

Thread view:

ugianka - 26 Mar 2004 12:27 GMT

We are considering a solution for a J2EE application
that stores the whole database in memory
(using a persistence layer as hibernate in order to manager
concurrency and transactions).
The db in production will reach 200 GB in size.
Is such a thing feasable?
I know the design is very extreme but the kind
of requirements of the application are very
unconventional.

thanks in advance

Reply to this Message

Robert Klemme - 26 Mar 2004 14:30 GMT

> We are considering a solution for a J2EE application
> that stores the whole database in memory
> (using a persistence layer as hibernate in order to manager
> concurrency and transactions).
> The db in production will reach 200 GB in size.
> Is such a thing feasable?

You'll need a 64 bit operating system because otherwise no process can
address that much mem.

> I know the design is very extreme but the kind
> of requirements of the application are very
> unconventional.

Out of curiosity: what are those requirements?

Cheers

robert

Reply to this Message

Dieter Bender - 26 Mar 2004 15:21 GMT

Hi,

would be no problem for OS/400 running on AS/400, only the memory on this
box is very expensive

Dieter Bender

>> We are considering a solution for a J2EE application
>> that stores the whole database in memory
[quoted text clipped - 15 lines]
>
> robert

Reply to this Message

Gregory Burd - 02 Apr 2004 21:59 GMT

Ugianka,

I have a suggestion. Try using Berkeley DB Java Edition (JE) to store
your data. It automatically manages moving data to and from disk
within limits set by your application. Take a look and I think that
you will see that it is a good solution for managing such data storage
issues.

http://www.sleepycat.com/products/je.shtml

-greg

_____________________________________________________________________

Gregory Burd
Product Manager gburd@sleepycat.com
Sleepycat Software, Inc. http://www.sleepycat.com/

Reply to this Message

Roedy Green - 04 Apr 2004 20:03 GMT

>I have a suggestion. Try using Berkeley DB Java Edition (JE) to store
>your data. It automatically manages moving data to and from disk
[quoted text clipped - 3 lines]
>
>http://www.sleepycat.com/products/je.shtml

That's a great idea. Having to install a standalone database which
may conflict with ones already installed is a pain. This way the
install and administration is much simpler. This necessarily makes it
single user.

I have added it to the list of databases at
http://mindprod.com/jgloss/sql.html

You don't mention pricing. I would like it for the table.

--
Canadian Mind Products, Roedy Green.
Coaching, problem solving, economical contract programming.
See http://mindprod.com/jgloss/jgloss.html for The Java Glossary.

Reply to this Message

Gregory Burd - 05 Apr 2004 15:02 GMT

>> I have a suggestion. Try using Berkeley DB Java Edition (JE) to store
>> your data. It automatically manages moving data to and from disk
[quoted text clipped - 13 lines]
>
> You don't mention pricing. I would like it for the table.

Thanks for your interest and listing JE in your table. I've replied to
you via email with the details.

regards,

-greg

_____________________________________________________________________

Gregory Burd
Product Manager gburd@sleepycat.com
Sleepycat Software, Inc. http://www.sleepycat.com/

Reply to this Message

in memory db of 200 GB

Free Magazines