a presentation by W H Inmon

1
a presentation by W H Inmon
2
oltp performance - - small transactions -
many users - predictable arrival pattern -
2/3 second performance
3
DSS environment - - large transactions -
few users - lots of data - 5 min to 24 hour
response time
4
DSS
OLTP
the whole concept of performance is radically
different from one environment to the next
- 2/3 seconds
- 5 min to 24 hours
5
what is a transaction?
OLTP
what is oltp response time?
the time from query initiation until the first of
the output returns
6
what is a transaction?
DSS
what is DSS response time?
the time from query initiation until the first of
the output returns and the time from query
initiation until the last of the output returns
7
what is a transaction?
DSS
what is DSS response time?
the time from query initiation until the first of
the output returns and the time from query
initiation until the last of the output returns
8
DSS
OLTP
tx
tx
the tx is so small that only first I/O
activity is relevant
the tx is so large that first and last I/O
activity is important
9
even basic access to disk is measured differently
10
tx
OLTP
in the oltp environment the basic measurement of
disk transfer is time to first record (ttfr)
11
tx
OLTP
ttfr is important when you have many small txs
each doing high performance processing
12
tx
DSS
whats important in the DSS environment is time
to average record - ttar
- few transactions - lots of records - sequential
access