Availability Guide for Application Design

Data Protection and Recovery
Availability Guide for Application Design—525637-004
4-26
Solution Using Low-Priority Transaction Processing
to Perform the Batch Function
Design Considerations in Support of Batch Operations
You should consider in advance the needs of the batch operations on your database.
Consider what types of summary reports, data transformations, maintenance updates,
and so on will likely be required. You can then avoid extensive sorting when the batch
application goes online by providing appropriate columns or fields to enable useful
indexes or alternate keys for your batch operations.
When designing the database, you might consider including appropriate timestamp
fields if you intend to use the database snapshot technique.
Solution Using Low-Priority Transaction Processing to Perform
the Batch Function
A second approach to running batch processing concurrently with online operations is
to run the batch job as a sequence of low-priority transactions. Figure 4-9 on page 4-27
shows one way of doing this.
Figure 4-8. Eliminating Batch Windows With NetBatch-Plus
Server
High-Priority OLTP Server Class
Online
Transaction
Requester
Database of
Record
NetBatch-Plus
Application
Low-Priority Batch and Decision Support
VST308.vdd