Design and implementation of decomposing views system for data warehouse self-maintenance
Pan Jiu-hui
Abstract
Pan Jiu-hui
Abstract
The data warehouse self-maintenance problem is substantially the problem of making materialized views self-maintainable.Because the exiting policies of materialized views self-maintenance cannot effectually reduce superfluous data in the integration and data sources of data warehouse,the response velocity of data warehouse environment will be tampered.The decomposing views system for data warehouse self-maintenance and improves the present pattern of decomposing views through deriving local views definations of single data source from the global definitions of materialized views.In conclution,the system not only can realize the functions of de-composing and rewriting materialized views,but also can heighten the efficiency of data warehouse self-maintainance.
A significance statement is not available in the OpenAlex record.
A contribution statement is not available in the OpenAlex record.
Method details are not available in the OpenAlex metadata.
Findings are not separately available in the OpenAlex metadata.
Limitations are not available in the OpenAlex metadata.
Application details are not available in the OpenAlex metadata.
The data warehouse self-maintenance problem is substantially the problem of making materialized views self-maintainable.Because the exiting policies of materialized views self-maintenance cannot effectually reduce superfluous data in the integration and data sources of data warehouse,the response velocity of data warehouse environment will be tampered.The decomposing views system for data warehouse self-maintenance and improves the present pattern of decomposing views through deriving local views definations of single data source from the global definitions of materialized views.In conclution,the system not only can realize the functions of de-composing and rewriting materialized views,but also can heighten the efficiency of data warehouse self-maintainance.
Key concepts: Materialized view, Data warehouse, Computer science, Dimensional modeling, Rewriting, Database, Warehouse, Data mining