REALTIME SNAPSHOT INDICES
A system and method for realtime snapshot indices is presented. A query is calculated on all target data of a data warehouse, with all variable combinations, to generate a result. The result is stored in a snapshot index associated with the data warehouse. The result is recalcualated to generate a subresult, and the snapshot index is updated with the subresult. A conversion routine is generated to recalculate the subresult into a separate table, and the separate table is then recalculated by a background job to recalculate the subresult.
1 . A computer-implemented method comprising:
calculating, by at least one system comprising one or more processors, a query on all target data of a data warehouse with all variable combinations to generate a result;
storing, by the at least one system, the result in a snapshot index associated with the data warehouse;
recalculating, by the at least one system, the result to generate a subresult;
updating, by the at least one system, the snapshot index with the subresult;
generating, by the one or more processors, a conversion routine to recalculate the subresult into a separate table; and
recalculating, by the at least one system, the separate table by a background job to recalculate the subresult.
2 . The method in accordance with claim 1 , further comprising updating, by the at least one system, the snapshot index with the recalculated subresult.
3 . The method in accordance with claim 1 , wherein the background job is implemented by a scheduler associated with the data warehouse.
4 . The method in accordance with claim 1 , further comprising generating, by the one or more processors, at least one report using the recalculated subresult.
5 . The method in accordance with claim 1 , further comprising applying a system landscape transformation tool (SLT) as a default replication mechanism.
6 . A non-transitory, computer-readable medium containing instructions to configure a processor to perform operations comprising:
calculating a query on all target data of a data warehouse with all variable combinations to generate a result;
storing the result in a snapshot index associated with the data warehouse;
recalculating the result to generate a subresult;
updating the snapshot index with the subresult;
generating a conversion routine to recalculate the subresult into a separate table; and
recalculating the separate table by a background job to recalculate the subresult.
7 . The computer-readable medium in accordance with claim 6 , wherein the operations further comprise updating the snapshot index with the recalculated subresult.
8 . The computer-readable medium in accordance with claim 6 , wherein the background job is implemented by a scheduler associated with the data warehouse.
9 . The computer-readable medium in accordance with claim 6 , wherein the operations further comprise generating at least one report using the recalculated subresult.
10 . The computer-readable medium in accordance with claim 6 , wherein the operations further comprise applying a system landscape transformation tool (SLT) as a default replication mechanism.
11 . A system comprising:
at least one programmable processor; and
at least one computer-readable storage medium, the computer readable storage medium storing instructions that, when executed by the at least one programmable processor, cause the at least one programmable processor to perform operations comprising:
calculating a query on all target data of a data warehouse with all variable combinations to generate a result;
storing the result in a snapshot index associated with the data warehouse;
recalculating the result to generate a subresult;
updating the snapshot index with the subresult;
generating a conversion routine to recalculate the subresult into a separate table; and
recalculating the separate table by a background job to recalculate the subresult.
12 . The system in accordance with claim 11 , wherein the operations further comprise updating the snapshot index with the recalculated subresult.
13 . The system in accordance with claim 11 , wherein the background job is implemented by a scheduler associated with the data warehouse.
14 . The system in accordance with claim 11 , wherein the operations further comprise generating at least one report using the recalculated subresult.
15 . The system in accordance with claim 11 , wherein the operations further comprise applying a system landscape transformation tool (SLT) as a default replication mechanism.