A lot of data is collected in the live system to allow a maximum level of detail. To simultaneously increase performance for long-term queries, the data is aggregated in automated compaction runs.
The data is aggregated to a maximum time window of 60 minutes. This hour can be split by different orders.
This aggregation is repeated in different time intervals so that subsequent changes can also be included.
HR bonus reports
After a month change, the calculation of the employee bonus is also manifested by a compaction run.
Manual post-compactions can be triggered at any time. This is then relevant if the data is not plausible. This can occur if there are disconnections to the central database of the data warehouse (DWH) in the cloud or at the headquarters.