Businesses today demand and depend on real-time access to critical information produced by their online systems, and reporting is a necessary and expected business ‘utility’. However, report processing and generation is a hardware intensive activity that can dramatically affect the performance of online transactional databases - and simply pointing a report writer at one of these systems can be a recipe for disaster.
One way to balance these conflicting demands is to deploy a separate version of the production database that is used specifically to create reports. This whitepaper will examine this approach, which aims to reduce contention of the online systems for computing resources, and offers additional benefits such as specific tuning and structural configuration of the reporting database to speed up report generation.
DOWNLOAD HERE >