RE: Siebel - ODB.

From: Henry Poras <Henry.Poras_at_ctp.com>
Date: Thu, 29 Nov 2001 09:42:26 -0800
Message-ID: <F001.003D0A56.20011129083522@fatcity.com>

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:NDATFM_at_labor.state.ny.us]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:lisa.koivu_at_efairfield.com]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----- <FONT 
      face=Arial size=1>From:   <FONT face=Arial 
      size=1>Mark Leith [SMTP:mark_at_cool-tools.co.uk] <FONT 
      face=Arial size=1>Sent:   <FONT face=Arial 
      size=1>Wednesday, November 28, 2001 1:55 PM <FONT face=Arial 
      size=1>To:     <FONT face=Arial 
      size=1>Multiple recipients of list ORACLE-L <FONT face=Arial 
      size=1>Subject:        <FONT 
      face=Arial size=1>RE: Siebel. 


      <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----- <FONT 
      face=Arial size=2>Linda.Miller-Coker_at_jpmorgan.com <FONT 
      face=Arial size=2>Sent: 28 November 2001 17:46 <FONT face=Arial 
      size=2>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> <FONT face=Arial 
      size=2>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 <FONT face=Arial 
      size=2>database or the application? Anybody know? 
      Cheers 
      Mark 


      <FONT face=Arial 

      size=2>=================================================== 
       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 


      <FONT face=Arial 

      size=2>=================================================== 


      <FONT face=Arial 

      size=2>           <A 
      href="http://www.cool-tools.co.uk" 
      target=_blank>http://www.cool-tools.co.uk <FONT face=Arial 
      size=2>       Maximising throughput & 
      performance 
      -- Please 
      see the official ORACLE-L FAQ: <A href="http://www.orafaq.com" 
      target=_blank>http://www.orafaq.com <FONT face=Arial 
      size=2>-- Author: Mark Leith 
        INET: mark_at_cool-tools.co.uk 
      Fat City Network Services    -- 
      (858) 538-5051  FAX: (858) 538-5051 <FONT face=Arial 
      size=2>San Diego, California        -- 
      Public Internet access / Mailing Lists <FONT face=Arial 
      size=2>-------------------------------------------------------------------- 
      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 <FONT 
      face=Arial size=2>also send the HELP command for other information (like 
      subscribing). 
      -- Please 
      see the official ORACLE-L FAQ: <A href="http://www.orafaq.com" 
      target=_blank>http://www.orafaq.com <FONT face=Arial 
      size=2>-- Author: <FONT 
      face=Arial size=2>  INET: Linda.Miller-Coker_at_jpmorgan.com 
      Fat City Network Services    -- 
      (858) 538-5051  FAX: (858) 538-5051 <FONT face=Arial 
      size=2>San Diego, California        -- 
      Public Internet access / Mailing Lists <FONT face=Arial 
      size=2>-------------------------------------------------------------------- 
      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 <FONT 
      face=Arial size=2>also send the HELP command for other information (like 
      subscribing). 
      -- Please 
      see the official ORACLE-L FAQ: <A href="http://www.orafaq.com" 
      target=_blank>http://www.orafaq.com <FONT face=Arial 
      size=2>-- Author: Mark Leith 
        INET: mark_at_cool-tools.co.uk 
      Fat City Network Services    -- 
      (858) 538-5051  FAX: (858) 538-5051 <FONT face=Arial 
      size=2>San Diego, California        -- 
      Public Internet access / Mailing Lists <FONT face=Arial 
      size=2>-------------------------------------------------------------------- 
      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 <FONT 
      face=Arial size=2>also send the HELP command for other information (like 
      subscribing).

Received on Thu Nov 29 2001 - 11:42:26 CST