Any system with online 'live' updates as opposed to saving up all the
updates and running them through a batch process
would be considered an OLTP application.
Ron Smith
Database Administration
[EMAIL PROTECTED]
-----Original Message-----
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 13, 2001 8:01 AM
To: Multiple recipients of list ORACLE-L
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
[EMAIL PROTECTED]
--
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: Smith, Ron L.
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).
