Re: design question
From: Lars Tetzlaff <lars.tetzlaff_at_gmx.net>
Date: Wed, 10 Sep 2008 21:31:59 +0200
Message-ID: <ga97b5$icr$1@online.de>
Date: Wed, 10 Sep 2008 21:31:59 +0200
Message-ID: <ga97b5$icr$1@online.de>
Chris Seidel schrieb:
> Hi,
>
> I need to store java objects in my oracle database. These objects have
> serveral fields, e.g.
>
> Object1: String f1; String f2; Date f3
> Object1: String f1; BigDecimal f2; Boolean f3
>
> e.g.
> Object1("Hello", "World", 2008-09-05)
> Object2("Foo", 100.20, true)
>
> The database shall scale up at least to 100 million objects.
>
> How to map this to the database?
>
Maybe you could use the object-relational features in oracle. They allow you to create object type hierarchies and store them inside object tables. Look at
http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28371/toc.htm
for an introduction.
Lars Received on Wed Sep 10 2008 - 14:31:59 CDT