From brian_wisniewski@yahoo.com Tue, 13 Feb 2001 08:49:50 -0800 From: Brian Wisniewski Date: Tue, 13 Feb 2001 08:49:50 -0800 Subject: Re: Opinions on OLTP Message-ID: MIME-Version: 1.0 Content-Type: text/plain I'm working on a project which is converting from DB2 to Oracle and possibly UDB. All of the current constraints are in the Cobol code and none are database enforced. A version of the data model is stored in Cool:Gen and we need to update this and use it to move all of the constraints from the code into the database. We need to have someone who is familiar with Cool:Gen and the Cobol code go through and get the model updated before we move it to ErWin. Very tedious task which I am glad not to be tasked to do. I agree the constraints should be enforced in the database for consistency sake. Good luck. - Brian --- Sherrie.Kubis@swfwmd.state.fl.us wrote: > I am starting a Data Warehouse project, possibly using Oracle > Warehouse > Builder. One of the databases that I must bring together comes from > IBM > DB2 database. We have reverse engineered a piece of their database > so that > we can produce an ER diagram so that we can start understanding their > data. > A hindrance to us is that they do not use any constraints or > referential > integrity, but place all of their checks into their COBOL code. They > tell > me this is because they are an online transaction processing system, > and > that's how things are handled in that environment. I always thought > that > OLTP systems were airlines and such, but they, at best, have 20 data > entry > people. Is any database within DB2 under CICS considered OLTP, > perhaps? > What thresholds would you use to determine what is an OLTP system? > Has > anyone ever heard about putting all of the RI into code as opposed to > allowing the database to do its job? It seems silly to me to put all > of > your checks into code because changes and maintenance would just kill > you, > not to mention consistency, or lack thereof. > > Any insights into this would be appreciated. > > > Sherrie Kubis > Southwest Florida Water Management District > 2379 Broad Street > Brooksville, FL 34604 > 352.796.7211 Ext 4033 > Fax: 352-754-6776 > sherrie.kubis@swfwmd.state.fl.us > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: Sherrie.Kubis@swfwmd.state.fl.us > > 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@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). __________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: brian_wisniewski@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@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).