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

Home -> Community -> Usenet -> comp.databases.oracle -> Re: acceptable way to program

Re: acceptable way to program

From: Ann <Ann_at_nospam.invalid>
Date: Sat, 01 Jan 2005 04:23:38 GMT
Message-ID: <eBpBd.311721$HA.34608@attbi_s01>

"steve" <me_at_me.com> wrote in message
news:0001HW.BDFB22EC00191A71F03055B0_at_news.newsguy.com...
> 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.
> 2. the object becomes "closed", in that it cannot be modified or checked
in
> situ
> 3. it cannot be searched , without de-serialization.

How do you sort on a field that contains just picures (not pictures in objects.)

>
>
> 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.
>
> does anyone have any thoughts how to accomplish this task.
>
>
> steve
>
>
>
Received on Fri Dec 31 2004 - 22:23:38 CST

Original text of this message

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