Improving the completeness and timeliness by horizontal fragmentation of data warehouse tables

Authors:
Ljiljana Brkić;Mirta Baranović;Igor Mekterović
Affiliations:
Faculty of Electrical Engineering and Computing, University of Zagreb, Zagreb, Croatia;Faculty of Electrical Engineering and Computing, University of Zagreb, Zagreb, Croatia;Faculty of Electrical Engineering and Computing, University of Zagreb, Zagreb, Croatia
Venue:
SITE'12 Proceedings of the 11th international conference on Telecommunications and Informatics, Proceedings of the 11th international conference on Signal Processing
Year:
2012

Citing 4
Cited 0

Toward quality data: an attribute-based approach

Decision Support Systems - Special issue on information technologies and systems
Data quality assessment

Communications of the ACM - Supporting community and building social capital
Data Quality: Concepts, Methodologies and Techniques (Data-Centric Systems and Applications)

Data Quality: Concepts, Methodologies and Techniques (Data-Centric Systems and Applications)
Improving the ETL process and maintenance of higher education information system data warehouse

WSEAS Transactions on Computers

Quantified Score

Hi-index	0.00

Visualization

Abstract

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.