| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Siebel.
Yeah, but things do change over time, and that book is a few years old now.
There's good reason at times to use RI with a data mart, such as you need it if you expect star joins to work.
Oracle has made some changes that reduce the impact of having the RI in place.
Jared
Scott Shafer
<sknd100_at_YAHOO To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
.COM> cc:
Sent by: Subject: Re: Siebel.
root_at_fatcity.c
om
11/28/01 04:15
PM
Please respond
to ORACLE-L
I seem to remember Ralph Kimball writing in one of his DW books that the RI and constraints should be enforced in the app layer as well. However I might be wrong (once this year isn't too bad, eh?) ;-P
Scott Shafer
San Antonio, TX
Henry Poras wrote:
>
> That is probably true to an extent but it doesn't explain some of the
messes
> I've seen.
>
> Henry
>
> -----Original Message-----
> Sent: Wednesday, November 28, 2001 3:14 PM
> To: Multiple recipients of list ORACLE-L
>
> I have heard that they do this on purpose because their products have to
be
> RDBMS neutral. They have to work on RDBMS's that don't have built-in RI.
>
> Tom Terrian
> Oracle DBA
> WPAFB - DAASC
> tterrian_at_daas.dla.mil
> 937-656-3844
>
> -----Original Message-----
> Sent: Wednesday, November 28, 2001 2:46 PM
> To: Multiple recipients of list ORACLE-L
>
> Does anybody else get the same feeling as me that it is not that vendors
are
> ignoring proper data models, they don't even know what they are.
>
> Henry
>
> -----Original Message-----
> Sent: Wednesday, November 28, 2001 2:14 PM
> To: Multiple recipients of list ORACLE-L
>
> Unfortunately it's the case way too often. Even at the enlightened place
> where I work, our RI is done at the application level.
>
> Not much I can do about it. Our development is done on MySQL and then
> "ported" to Oracle.
>
> --Walt Weaver
> Bozeman, Montana, USA
>
> -----Original Message-----
> Sent: Wednesday, November 28, 2001 11:55 AM
> To: Multiple recipients of list ORACLE-L
>
> <RANT MODE>
>
> BAH!! These bloody application providers leaving the integrity to their
> bloody applications instead of leaving it in it's rightful place in the
> database!!! Makes my life 10 times harder!!! Got no consideration at all
> have they?
>
> </RANT MODE>
>
> :P
>
> Thanks!
>
> Mark
>
> -----Original Message-----
> Linda.Miller-Coker_at_jpmorgan.com
> Sent: 28 November 2001 17:46
> To: Multiple recipients of list ORACLE-L
>
> We use Siebel and no it does NOT have RI.
>
> "Mark Leith" <mark_at_cool-tools.co.uk>@fatcity.com on 11/28/2001 10:56:07
AM
>
> Please respond to ORACLE-L_at_fatcity.com
>
> Sent by: root_at_fatcity.com
>
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> cc:
>
> Hi Gang,
>
> Does anybody use Siebel - I believe it's a CRM package?
>
> I'm trying to find out of the Siebel application enforces RI within the
> database or the application? Anybody know?
>
> Cheers
>
> Mark
>
> ===================================================
> Mark Leith | T: +44 (0)1905 330 281
> Sales & Marketing | F: +44 (0)870 127 5283
> Cool Tools UK Ltd | E: mark_at_cool-tools.co.uk
> ===================================================
> http://www.cool-tools.co.uk
> Maximising throughput & performance
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mark Leith
> INET: mark_at_cool-tools.co.uk
>
> 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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Linda.Miller-Coker_at_jpmorgan.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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mark Leith
> INET: mark_at_cool-tools.co.uk
>
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Weaver, Walt
> INET: wweaver_at_rightnow.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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Henry Poras
> INET: Henry.Poras_at_ctp.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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Terrian, Tom
> INET: tterrian_at_daas.dla.mil
>
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Henry Poras
> INET: Henry.Poras_at_ctp.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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: sknd100_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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Jared.Still_at_radisys.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 Dec 07 2001 - 19:36:16 CST
 |
 |