Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: acceptable way to program

Re: acceptable way to program

From: <joel-garry_at_home.com>
Date: 3 Jan 2005 15:29:29 -0800
Message-ID: <1104794968.990009.251480@c13g2000cwb.googlegroups.com>

thufir wrote:
> steve wrote:
> > Hi,
> >
> > Recently I have been looking at the various ways people are
> implementing,
> > interaction between java & oracle databases.
> >
> > I was always instructed on the purity of the data model,
"normalize
> the
> > data" etc.
> >
> > I have seen people Serializing java objects , such as purchase
> orders
> > orders, customer records etc , then sticking the "object" into am
> oracle blob
> > column.
> >
> > finally when they want to retrieve it they de-serialize the
object.,
> work on
> > it then re-serialize and stuff it back into the oracle blob.
> >
> > to me this causes the following problems:
> >
> > 1. the object can become very big, and can only be recovered in
it's
> > entirety, and if it contains pictures ,etc, it can become huge.

So, do the business requirements necessitate the picture to only be retrieved with the rest of the data or not?

> > 2. the object becomes "closed", in that it cannot be modified or
> checked in
> > situ

So, do the business requirements necessitate modification or not?

> > 3. it cannot be searched , without de-serialization.

So, do the business requirements necessitate searching or not?

> >
> >
> > I'm looking to implement a java front end, (oracle back end),
system
> ,that
> > allows a product , to be inspected by an inspection team , and
> comments/
> > photographic record kept.
> >
> > using an "object approach" would make it very simple, but the size
of
> the
> > resulting object could be very large.

So, do the business requirements necessitate simplicity or not?

> >
> > does anyone have any thoughts how to accomplish this task.

Buy lots and lots and lots and lots of hardware. Then quit. Then buy the hardware for pennies on the dollar at the liquidation sale.

Sounds like your requirements do not match the java object environment when people do as you've seen.

jg

--
@home.com is bogus.
http://www.ritsumei.ac.jp/~akitaoka/index-e.html
Received on Mon Jan 03 2005 - 17:29:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US