Solution with Jabatix
Through additional smart processing between the raw source data and the desired reports, Jabatix eliminates a large number of same or similar update operations. This is the core functionality of Continuous Reporting, a new technology that translates the gains in efficiency from smart inserts and updates into near-real-time availability of decision-critical reports.
In our example scenario, when a new product is added to the database, Jabatix updates all 100 reports/report data marts with the information about this new product and only for this product. Through intelligent optimization and the resulting large-scale reduction of the required operations, processing is carried out so fast that you are able to keep your mission-critical reporting up to date in near-real-time.
How does it work?
Jabatix reads the existing data sources in blocks. On the basis of the report repositories and related metadata, Jabatix decides, which content and data marts need to be updated. The relevant aggregates are formed (in memory) only for data marts that must be changed and written back into the data mart at the end of the last block.
This functionality can be automated through an event-based operational process that automatically performs data mart and report updates when source data changes warrant these updates. As a result, the latest information is always available for reports or dashboard displays.