RE: Siebel - ODB.
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.
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.
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).