I've not been to that place but one colleague (ex-job)
describe it this way :
The developpers only know the objects, they're not
aware of the tables. All the locking and relation
between the objects is done at the application server
level. The application server generates the sql to
read/write the tables. So for them a database or a a
file, they do not care.
I have to start reading about objects, j2ee, xml, uml,
java, ... and I thought I would have time to go
snowboarding during the Christmas time ;-)
- dgoulet_at_vicr.com a écrit : > Just because the
development tools are object
> orientated does not mean that the
> database has to be as well.
>
> Dick Goulet
>
> ____________________Reply
> Separator____________________
> Subject: RE: Object relational features and
> performance
> Author: =?iso-8859-1?q?Stephane=20Paquette?=
> <stephane_paquette_at_yahoo.com>
> Date: 12/20/2002 9:04 AM
>
> Is this the future ???
>
> I know one big bank where the development is object
> oriented and the database (DB2 UDB in this case) is
> used as a big flat file. The development is using
> java, j2ee, bea weblogic.
>
>
> --- DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> a
> écrit
> : > Stefan - I believe the general consensus had
> emerged
> > that usually object
> > features aren't worth the effort. Often there are
> > few benefits, and if you
> > don't do it correctly you may see bad performance.
> > Two questions:
> > 1. Are your developers/management enamored with
> > the concept of object, or
> > is this just your own curiosity?
> > 2. Is there something about your application
> that
> > leads you to believe
> > that it might derive significant benefit from the
> > object features?
> > For general business applications it is hard to
> beat
> > the flexibility of the
> > good old traditional relational data modeling.
> > The lack of discussion may provide part of the
> > answer to your question.
> >
> > Dennis Williams
> > DBA, 40%OCP
> > Lifetouch, Inc.
> > dwilliams_at_lifetouch.com
> >
> >
> > -----Original Message-----
> > Sent: Friday, December 20, 2002 6:35 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi everybody
> >
> > I'm not quite sure wether this has been discussed
> in
> > deep before, but I
> > couldn't find anything satisfieing (hope the
> > spelling is correct ;)) things
> > in the archive.
> > Anyway: Due to my lack of experience with any real
> > life scenarios with
> > Oracle's object relational features, I never tried
> > to recommend the usage of
> > these and always kept to a "normal" relational
> > approach. Does anybody have
> > any experience with Types / Nested Tables and the
> > like in a (preferrably
> > big) production system of any kind ? What's
> > recommendable, where are the
> > pitfalls ?
> >
> > Any input deeply appreciated,
> > TIA, Stefan
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > --
> > Author: Stefan Jahnke
> > INET: Stefan.Jahnke_at_bov.de
> >
> > Fat City Network Services -- 858-538-5051
> > http://www.fatcity.com
> > San Diego, California -- Mailing list and
> web
> > hosting services
> >
>
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be
> removed
> > from). You may
> > also send the HELP command for other information
> > (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > --
> > Author: DENNIS WILLIAMS
> > INET: DWILLIAMS_at_LIFETOUCH.COM
> >
> > Fat City Network Services -- 858-538-5051
> > http://www.fatcity.com
> > San Diego, California -- Mailing list and
> web
> > hosting services
> >
>
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be
> removed
> > from). You may
> > also send the HELP command for other information
> > (like subscribing).
> >
>
> =====
> Stéphane Paquette
> DBA Oracle et DB2, consultant entrepôt de données
> Oracle and DB2 DBA, datawarehouse consultant
> stephane_paquette_at_yahoo.com
>
>
> Lèche-vitrine ou lèche-écran ?
> magasinage.yahoo.ca
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: =?iso-8859-1?q?Stephane=20Paquette?=
> INET: stephane_paquette_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
>
Stéphane Paquette
DBA Oracle et DB2, consultant entrepôt de données
Oracle and DB2 DBA, datawarehouse consultant
stephane_paquette_at_yahoo.com
Lèche-vitrine ou lèche-écran ?
magasinage.yahoo.ca
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?iso-8859-1?q?Stephane=20Paquette?=
INET: stephane_paquette_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Dec 20 2002 - 12:20:51 CST