Paper Info
Title
ORE: an iterative approach to the design and evolution of multi-dimensional schemas
Abstract
Designing a data warehouse (DW) highly depends on the information requirements of its business users. However, tailoring a DW design that satisfies all business requirements is not an easy task. In addition, complex and evolving business environments result in a continuous emergence of new or changed business needs. Furthermore, for building a correct multidimensional (MD) schema for a DW, the designer should deal with the semantics and heterogeneity of the underlying data sources. To cope with such an inevitable complexity, both at the beginning of the design process and when a potential evolution event occurs, in this paper we present a semi-automatic method, named ORE, for constructing the MD schema in an iterative fashion based on the information requirements. In our approach, we consider each requirement separately and incrementally build the unified MD schema satisfying the entire set of requirements.
Year
DOI
Venue
2012
10.1145/2390045.2390047
DOLAP
Keywords
Field
DocType
md schema,business requirement,data warehouse,unified md schema,changed business need,multi-dimensional schema,iterative approach,dw design,design process,business environments result,information requirement,business user
Data warehouse,Data mining,Multi dimensional,Computer science,Business requirements,Engineering design process,Schema (psychology),Database,Semantics
Conference
Citations 
PageRank 
References 
6
0.43
21
Authors
4
Name
Order
Citations
PageRank
Petar Jovanovic1627.78
Oscar Romero246735.46
Alkis Simitsis3166594.62
Alberto Abelló484861.88