Facts are multidimensional concepts of primary interests for knowledge workers because they are related to events occurring dynamically in an organization. Normally, these concepts are modeled in operational data sources as tables. Thus, one of the main steps in conceptual design of a data warehouse is to detect the tables that model facts. However, this task may require a high level of expertise in the application domain, and is often tedious and time-consuming for designers. To overcome these problems, a comprehensive model-driven approach is presented in this paper to support designers in: (1) obtaining a CWM model of business-related relational tables, (2) determining which elements of this model can be considered as facts, and (3) deriving their counterparts in a multidimensional schema. Several heuristics --based on structural information derived from data sources-- have been defined to this end and included in a set of Query/View/Transformation model transformations.
A model-driven heuristic approach for detecting multidimensional facts in relational data sources / A. Carmè; J.-N. Mazón; S. Rizzi. - STAMPA. - (2010), pp. 13-24. (Intervento presentato al convegno 12th International Conference on Data Warehousing and Knowledge Discovery tenutosi a Bilbao, Spain nel 30 agosto - 2 settembre 2010).
A model-driven heuristic approach for detecting multidimensional facts in relational data sources
RIZZI, STEFANO
2010
Abstract
Facts are multidimensional concepts of primary interests for knowledge workers because they are related to events occurring dynamically in an organization. Normally, these concepts are modeled in operational data sources as tables. Thus, one of the main steps in conceptual design of a data warehouse is to detect the tables that model facts. However, this task may require a high level of expertise in the application domain, and is often tedious and time-consuming for designers. To overcome these problems, a comprehensive model-driven approach is presented in this paper to support designers in: (1) obtaining a CWM model of business-related relational tables, (2) determining which elements of this model can be considered as facts, and (3) deriving their counterparts in a multidimensional schema. Several heuristics --based on structural information derived from data sources-- have been defined to this end and included in a set of Query/View/Transformation model transformations.I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.
