Any BI manipulates source data and during that time, The reports may have some downtime or it could be stale for a while.
Example, Ledger postings at EoD takes 45 min approx. to complete the ETL process and load the Daily Accounting reports.
For that 45 min. The reports should still be accessible by the users without any Downtime or exceptions.
Note :
Few OLAP BI tools already provides Cache techniques or auto refresh capabilities.
It can be implemented for FOSS based ETL/reporting tools where the Features are limited.
Synonym Togging:
Assume MAIN_SYN(Synonym) is a most importing source table through which the DIM,FACT and SUMMARY gets refreshed.
You can apply the concept for any number of tables.
STAGING_TEMP1 and STAGING_TEMP2 are just same copies of Staging tables which is called by the synonym MAIN_SYN.
Example, Ledger postings at EoD takes 45 min approx. to complete the ETL process and load the Daily Accounting reports.
For that 45 min. The reports should still be accessible by the users without any Downtime or exceptions.
Note :
Few OLAP BI tools already provides Cache techniques or auto refresh capabilities.
It can be implemented for FOSS based ETL/reporting tools where the Features are limited.
Synonym Togging:
Assume MAIN_SYN(Synonym) is a most importing source table through which the DIM,FACT and SUMMARY gets refreshed.
You can apply the concept for any number of tables.
STAGING_TEMP1 and STAGING_TEMP2 are just same copies of Staging tables which is called by the synonym MAIN_SYN.
No comments:
Post a Comment