Fig. 11.1.13 Dividing the day into different types of processing hours.One solution to resolving the conflict between long-running programs and the need for
consistent response time is to partition off the time slots for running on the computer. All
fast-running transactions run during the daytime when business needs for there to be
good response time, and long-running programs are able to be executed in the wee hours
of the morning, when no one else is using the machine.
An alternative is to execute long-running programs on a different machine on a different
DBMS than the database and machine that the transactions are operating on. This
alternative works whenever there is no need for the long-running program to access the
actual data that are being transacted against.
Chapter 11.1: Operational Analytics: Response Time