engleski

Improving the Completeness and Timeliness by Horizontal Fragmentation of Data Warehouse Tables

In this paper we discuss the procedure for horizontal fragmentation of data warehouse tables. This procedure is suitable when there are multiple independent organizational units that are producing data of the same structure that is eventually loaded into the consolidated fact table. In such cases, it is important for one organizational unit’s errors not to influence the others. We show that horizontal fragmentation improves data warehouse’s data quality, namely, completeness and timeliness data quality dimensions. The proposed procedure relies on metadata and is generic and applicable to any data warehouse.

Data warehouse; Completeness; Timeliness; ETL; Horizontal fragmentation

nije evidentirano