RE: Siebel - ODB.

2001-11-29 Thread Henry Poras
Title: RE: Siebel - ODB.



Of 
course a well designed database should (??!!) be used by multiple applications. 
So ideally, constraints which are data driven (long term) would be in the 
database, and constraints which are application driven (business rules) would 
reside in the application. But when application vendors create the database with 
no need to share data between other applications ...
 
Henry

  -Original Message-From: Mercadante, Thomas F 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, November 29, 2001 
  8:00 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Siebel - ODB.
  Lisa,
   
  One 
  arguement I lost regarding business rules (foreign keys) in the application, 
  rather than in the database was that it made the application "database 
  independent", not relying on database tools that might exist in one database 
  but not another.  In theory, this gave this person more opportunity to 
  sell the application to another organization that would prefer to use, say, 
  DB2 rather than Oracle.
   
  I'm 
  not agreeing with the philosophy, but at the time, it made some business 
  sense.
  Tom Mercadante Oracle Certified Professional 
  
-Original Message-From: Koivu, Lisa 
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 28, 
2001 4:26 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Siebel - ODB.
Why implement it in the database when 
you can write more bloated, more complex code?  Databases don't work 
anyway.  It also gives us a chance to issue more patches.  

I have NEVER understood why some people 
take the angle of not letting the database do what it is designed for.  
And I don't think I ever will.  I pray I never meet the DBA's of Yore 
and Yesteryear.
Rant on, Mark! 
Lisa Koivu Oracle 
Database Bimbo. Fairfield Resorts, Inc. 
954-935-4117 

  -Original Message- From:   Mark Leith [SMTP:[EMAIL PROTECTED]] Sent:   Wednesday, November 28, 2001 1:55 PM To: Multiple recipients of list ORACLE-L Subject:    RE: Siebel. 
   
  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? 
   
  :P 
  Thanks! 
  Mark 
  -Original Message- [EMAIL PROTECTED] 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" 
  <[EMAIL PROTECTED]>@fatcity.com on 11/28/2001 10:56:07 AM 
  
  Please respond to [EMAIL PROTECTED] 
  
  Sent by:  [EMAIL PROTECTED] 
  To:   Multiple recipients of list 
  ORACLE-L <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] 
  === 
     http://www.cool-tools.co.uk    Maximising throughput & 
  performance 
  -- Please 
  see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 
    INET: [EMAIL PROTECTED] 
  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: 
  [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 
  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: 
  [EMAIL PROTECTED] (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 co

RE: Siebel - ODB.

2001-11-29 Thread Mercadante, Thomas F
Title: RE: Siebel - ODB.



Lisa,
 
One 
arguement I lost regarding business rules (foreign keys) in the application, 
rather than in the database was that it made the application "database 
independent", not relying on database tools that might exist in one database but 
not another.  In theory, this gave this person more opportunity to sell the 
application to another organization that would prefer to use, say, DB2 rather 
than Oracle.
 
I'm 
not agreeing with the philosophy, but at the time, it made some business 
sense.
Tom Mercadante Oracle Certified Professional 

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 28, 
  2001 4:26 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Siebel - ODB.
  Why implement it in the database when you 
  can write more bloated, more complex code?  Databases don't work 
  anyway.  It also gives us a chance to issue more patches.  
  
  I have NEVER understood why some people 
  take the angle of not letting the database do what it is designed for.  
  And I don't think I ever will.  I pray I never meet the DBA's of Yore and 
  Yesteryear.
  Rant on, Mark! 
  Lisa Koivu Oracle Database 
  Bimbo. Fairfield Resorts, Inc. 954-935-4117 
  
-Original Message- From:   Mark 
Leith [SMTP:[EMAIL PROTECTED]] Sent:   Wednesday, 
November 28, 2001 1:55 PM To: Multiple recipients of list ORACLE-L Subject:    RE: Siebel. 
 
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? 

 
:P 
Thanks! 
Mark 
-Original Message- [EMAIL PROTECTED] 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" 
<[EMAIL PROTECTED]>@fatcity.com on 11/28/2001 10:56:07 AM 

Please respond to [EMAIL PROTECTED] 

Sent by:  [EMAIL PROTECTED] 
To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] 
===    http://www.cool-tools.co.uk    Maximising throughput & 
performance 
-- Please see 
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 
  INET: [EMAIL PROTECTED] 
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: 
[EMAIL PROTECTED] (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: [EMAIL PROTECTED] 
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: 
[EMAIL PROTECTED] (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: [EMAIL PROTECTED] 
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: 
[EMAIL PROTECTED] (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). 


RE: Siebel - ODB.

2001-11-28 Thread Koivu, Lisa
Title: RE: Siebel - ODB.





Why implement it in the database when you can write more bloated, more complex code?  Databases don't work anyway.  It also gives us a chance to issue more patches.  

I have NEVER understood why some people take the angle of not letting the database do what it is designed for.  And I don't think I ever will.  I pray I never meet the DBA's of Yore and Yesteryear.

Rant on, Mark!


Lisa Koivu
Oracle Database Bimbo.
Fairfield Resorts, Inc.
954-935-4117



-Original Message-
From:   Mark Leith [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, November 28, 2001 1:55 PM
To: Multiple recipients of list ORACLE-L
Subject:    RE: Siebel.





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?





:P


Thanks!


Mark


-Original Message-
[EMAIL PROTECTED]
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" <[EMAIL PROTECTED]>@fatcity.com on 11/28/2001 10:56:07 AM


Please respond to [EMAIL PROTECTED]




Sent by:  [EMAIL PROTECTED]



To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
  INET: [EMAIL PROTECTED]


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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]


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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]


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: [EMAIL PROTECTED] (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).