Data Mart Integration at Measure Level

Claudia Diamantini () and Domenico Potena ()
Additional contact information
Claudia Diamantini: Università Politecnica delle Marche
Domenico Potena: Università Politecnica delle Marche

A chapter in Information Systems: Crossroads for Organization, Management, Accounting and Engineering, 2012, pp 123-131 from Springer

Abstract: Abstract In the present literature Data Mart integration is typically considered from a dimension point of view. Approaches elaborate upon the hierarchical structure of dimensions to find the minimum common hierarchy where original dimensions can be mapped to. Although the problem of the conformance of measures has been recognized in the literature (see e.g. Kimball R, Ross M (2002) The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (2nd Ed.), John Wiley & Sons, p. 87) as a condition for effective Data Mart integration, it is considered as a pre-requisite, so that integration strategies borrowed from the Database domain can be used. Considering the functional structure of a measure, that is the formula used to compute it, method and tools can be developed to support conformance checking and reconciliation. In this paper we review the problem of Data Mart integration, introducing the major types of conflicts considered in the literature. Next, we define novel types of conflicts hindering the conformance of measures and propose strategies for their reconciliation based on formula manipulation.

Keywords: Data Warehouse; Virtual View; Data Mart; Mathematical Axiom; Dimension Conflict (search for similar items in EconPapers)
Date: 2012
References: Add references at CitEc
Citations:

There are no downloads for this item, see the EconPapers FAQ for hints about obtaining it.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:spr:sprchp:978-3-7908-2789-7_15

Ordering information: This item can be ordered from
http://www.springer.com/9783790827897

DOI: 10.1007/978-3-7908-2789-7_15

Access Statistics for this chapter

More chapters in Springer Books from Springer
Bibliographic data for series maintained by Sonal Shukla () and Springer Nature Abstracting and Indexing ().