one thing was glaringly obvious -- the data modeler on this project has
SQL Server and DB2 experience but no Oracle.
so... even though a data model is supposed to be database INDEPENDENT,
he was designing with SQL Server functionality in mind.
horse hockey.
I hate "generic data models" that take into account specific database
functions
- Tim Gorman <Tim_at_SageLogix.com> wrote:
> I haven't been following this thread, but I saw the phrase "database
> independent" and couldn't help chiming in...
>
> For the past couple years, whenever someone mentioned "database
> independence" as justification for certain decisions, I suggest that
> they
> stick with MySQL and save themselves the licensing costs of Oracle.
> If you
> wish to program to the lowest common denominator and ignore all the
> features
> that have been bought and paid for, then have the courage to go all
> the
> way...
>
> Second argument is more fun: I like to challenge them that we'll be
> throwing out their newly-written "database independent" application
> code
> long before we change database vendors. After all, Java has only
> been
> around for a couple years; it stands to reason that it might just as
> easily
> disappear as quickly as it appeared, rather than persist. "That C#
> stuff is
> looking pretty cool; better get some training!"
>
> The intent is not really to tweak their tail (well, just a little!)
> and
> start an argument (but that's fun too), but to shake them out of
> their
> self-centric, auto-justified way of thinking...
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Thursday, July 18, 2002 7:08 AM
>
>
> > no, I do have SOME input -- we'll be hiring a consultant DBA on
> this,
> > at least to get it up and running. I have some control over who we
> > hire. I'm going to make sure I get someone who is willing and able
> to
> > say NO.
> >
> > And I refuse to mention the "ANY" datatype :)
> >
> > Rachel
> >
> > --- Connor McDonald <hamcdc_at_yahoo.co.uk> wrote:
> > > "database indepdent"...
> > >
> > > oh dear...You're doomed :-)
> > >
> > > --- Rachel Carmichael <wisernet100_at_yahoo.com> wrote:
> > > > and here they want to be "database independent"
> > > >
> > > >
> > > > sigh. it's for a content management system
> > > >
> > > > --- "Toepke, Kevin M" <ktoepke_at_trilegiant.com>
> > > > wrote:
> > > > > I agree, it looks messy and confusing... However,
> > > > I found an example
> > > > > that
> > > > > makes it a little easier to understand.
> > > > >
> > > > >
> > > >
> > >
> >
>
http://asktom.oracle.com/pls/ask/f?p=4950:8:1062923::NO::F4950_P8_DISPLAYID,
> > > > > F4950_P8_CRITERIA:3099475696866,%7Banydata%7D
> > > > >
> > > > > My guess it was implemented for 2 reasons
> > > > > 1) to say they have every feature as M$
> > > > > 2) to support 3rd party vendors porting stuff
> > > > from M$
> > > > >
> > > > > Kevin
> > > > >
> > > > > -----Original Message-----
> > > > > Sent: Wednesday, July 17, 2002 1:35 PM
> > > > > To: Toepke, Kevin M; Multiple recipients of list
> > > > ORACLE-L
> > > > >
> > > > >
> > > > > Kevin,
> > > > >
> > > > > Looks messy to me, and damned confusing to
> > > > boot.
> > > > >
> > > > > Dick Goulet
> > > > >
> > > > > "The more you overtake the pluming the easier it
> > > > is to stop up the
> > > > > drain."
> > > > >
> > > > > Scotty of Star Trek, Search for Spock.
> > > > >
> > > > > ____________________Reply
> > > > Separator____________________
> > > > > Author: "Toepke; Kevin M" <ktoepke_at_trilegiant.com>
> > > > > Date: 7/17/2002 9:58 AM
> > > > >
> > > > > Rachel
> > > > >
> > > > > Check out the SYS.ANY datatype in Oracle 9i (from
> > > > the SQL reference).
> > > > > Me
> > > > > thinks its what SQL server would call a variant
> > > > data type.
> > > > >
> > > > > Follow this link for more info
> > > > >
> > > >
> > >
> >
>
http://download-east.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/to
> > > > > c.htm
> > > > >
> > > > > Kevin
> > > > > --------
> > > > > The "Any" types provide highly flexible modeling
> > > > of procedure
> > > > > parameters and
> > > > > table columns where the actual type is not known.
> > > > These datatypes let
> > > > > you
> > > > > dynamically encapsulate and access type
> > > > descriptions, data instances,
> > > > > and
> > > > > sets of data instances of any other SQL type.
> > > > These types have OCI
> > > > > and
> > > > > PL/SQL interfaces for construction and access.
> > > > >
> > > > >
> > > > > SYS.AnyData
> > > > > This type contains an instance of a given type,
> > > > with data, plus a
> > > > > description of the type. AnyData can be used as a
> > > > table column
> > > > > datatype and
> > > > > lets you store heterogeneous values in a single
> > > > column. The values
> > > > > can be of
> > > > > SQL built-in types as well as user-defined types.
> > > > >
> > > > >
> > > > > -----Original Message-----
> > > > > Sent: Wednesday, July 17, 2002 1:09 PM
> > > > > To: Multiple recipients of list ORACLE-L
> > > > >
> > > > >
> > > > > Okay, I'm working on what feels like 30 new
> > > > projects all at once and
> > > > > I
> > > > > WILL be RTFM'ing as soon as I can get more than 5
> > > > minutes out of
> > > > > meetings but....
> > > > >
> > > > >
> > > > > first: has anyone heard of any problems with
> > > > 64-bit Oracle on a
> > > > > Solaris 64-bit OS?
> > > > >
> > > > > second (and this one confuses me a bit)... I've
> > > > been asked if
> > > > > Oracle9i
> > > > > supports a "variant" datatype -- they are not
> > > > familiar with oracle
> > > > > but
> > > > > are familiar with SQL Server and say that there is
> > > > a datatype called
> > > > > "variant" there where you can basically overload
> > > > the column with
> > > > > whatever datatype you want (string, number, date)
> > > > and the database
> > > > > knows what type of data it is storing within the
> > > > column. They
> > > > > referred
> > > > > me to C++ and Java, neither of which I know.
> > > > >
> > > > > Can anyone point in the right direction to start
> > > > researching this?
> > > > >
> > > > > Thanks!
> > > > >
> > > > > Rachel
> > > > >
> > > > >
> > > > > __________________________________________________
> > > > > Do You Yahoo!?
> > > > > Yahoo! Autos - Get free new car price quotes
> > > > > http://autos.yahoo.com
> > > > > --
> > > > > Please see the official ORACLE-L FAQ:
> > > > http://www.orafaq.com
> > > > > --
> > > > > Author: Rachel Carmichael
> > > > > INET: wisernet100_at_yahoo.com
> > > > >
>
=== message truncated ===
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Jul 19 2002 - 09:08:20 CDT
