Data warehouse system is used to support the process of organizational decision making. Hence, the system must extract and integrate information from heterogeneous data sources in order to uncover relevant knowledge suitable for decision making process. However, the development of data warehouse is a difficult and complex process especially in its conceptual design (multidimensional modeling). Thus, there have been various approaches proposed to overcome the difficulty. This study surveys and compares the approaches of multidimensional modeling and highlights the issues, trend and solution proposed to date. The contribution is on the state of the art of the multidimensional modeling design.
REFERENCES
1.
R.
Kimball
, and M.
Ross
. The Data Warehouse Toolkit
. 2nd ed. (John Wiley & Sons
, New York
, 2009
).2.
S.
Rizzi
, A. A.
Abello
, J.
Lechtenborger
, and J.
Trujillo
. Research in data warehouse modeling and design: dead or alive?
. Proceedings of the 9ᵗʰ ACM International Workshop on Data Warehousing and OLAP
, (ACM
, New York
, 2006
), pp. 3
–10
.3.
M.
Golfarelli
. From user requirements to conceptual design in data warehouse design: A survey. In: Bellatreche
, L.
(ed.) Data Warehousing Design and Advanced Engineering Applications: Methods for Complex Construction
. (IGI Global
, 2009
).4.
O.
Romero
, A.
Abello
. A Survey of Multidimensional Modeling Methodologies
. International Journal of Data Warehousing and Mining
, 5
(2
), 1
–23
(2009
).5.
A.
Cravero
, S.
Sepulveda
, S. A chronological study of paradigms for data warehouse design
. Ingenieria e Investigacion
, 32
(2
), 58
–62
(2012
).6.
J. N.
Mazon
, J.
Trujillo
. A hybrid model driven development framework for the multidimensional modeling of data warehouses
. SIGMOD Record
, (38
), 12
–17
(2009
).7.
R.
Kimball
. The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses. (John Wiley
; New York
, 1996
).8.
R.
Winter
, B.
Strauch
. Information requirements engineering for data warehouse systems. Proceedings of the 2004 ACM SAC ’04
, New York, USA
: ACM
, (2004
), pp. 1359
–1365
.9.
N.
Prat
, J.
Akoka
, I.
Comyn-Wattiau
. A UML-based Data Warehouse Design Method
. Decision Support Systems
, 42
(3
), 1449
–1473
(2006
).10.
N.
Prakash
, A.
Gosain
. An approach to engineering the requirements of data warehouses
. Requirements Eng
, 13
(1
), 49
–72
(2008
).11.
A.
Sarkar
. Data Warehouse Requirements Analysis Framework: Business-Object Based Approach
. International Journal of Advanced Computer Science and Applications
, 3
(1
), 25
–34
(2012
).12.
M.
Golfarelli
, D.
Maio
, S.
Rizzi
, The dimensional fact model: a conceptual model for data warehouses
. International Journal of Cooperative Information Systems
, 7
(2-3
), 215
–247
(1998
).13.
C.
Phipps
, K. C.
Davis
. Automating data warehouse conceptual schema design and evaluation
, In L.V.S.
Lakshmanan
(Ed.). Proceedings of 4th International Workshop on Design and Management of Data Warehouses
, Toronto, Canada: CEUR-WS.org2002
, (2002
), pp. 23
–32
.14.
D. L.
Moody
, M. A. R.
Kortink
. From ER Models to Dimensional Models: Bridging the Gap between OLTP and OLAP Design
. Journal of Business Intelligence
, 8
, 7
–24
(2003
).15.
M. R.
Jensen
, T.
Holmgren
, T. B.
Pedersen
. Discovering Multidimensional Structure in Relational Data
. Data Warehouse and Knowledge Discovery
, (2004
), pp. 138
–148
.16.
O.
Romero
, A.
Abello
. A framework for multidimensional design of data warehouses from ontologies
. Data & Knowledge Engineering
, 69
, 1138
–1157
(2010b
).17.
Y.
Hachaichi
, J.
Feki
. An Automatic Method for the Design of Multidimensional Schemas From Object Oriented Databases
. International Journal of Information Technology & Decision Making
, 12
(6
), 1223
–1259
(2013
).18.
L.
Cabibbo
, R.
Torlone
, Lecture Notes of Computer Science
(Valencia, Spain
:Springer
,1998
).H.
Schek
, F.
Saltor
, I.
Ramos
and G.
Alonso
, “A Logical Approach to Multidimensional Databases
”, in Poceedings of 6ᵗʰ International Conference on Extending Database Technology
, 1377
, 183
–197
.19.
M.
Bohnlein
, A. Ulbrich-vom
Ende
, Business Process Oriented Development of Data Warehouse Structures, in Data Warehousing 2000 – Methoden, Anwendungen, Strategien
, edited by R.
Jung
and R.
Winter
(Physica
, Heidelberg
, 2000
), pp. 3
–21
.20.
A.
Bonifati
, F.
Cattaneo
, S.
Ceri
, A
, Fuggetta
, S.
Paraboschi
. Designing data marts for data warehouses
. ACM Transactions on Software Engineering and Methodology
, 10
(4
), 452
–483
(2001
).21.
P.
Giorgini
, S.
Rizzi
, M.
Garzetti
. GRAnD: A goal-oriented approach to requirement analysis in data warehouses
. Decision Support Systems
, 45
(1
), 4
–21
(2008
).22.
J. N.
Mazon
, J.
Trujillo
, J.
Lechtenborger
. Reconciling Requirement-Driven Data Warehouses with Data Sources Via Multidimensional Forms
. Data & Knowledge Engineering
, 23
(3
), 725
–751
(2007
).23.
O.
Romero
, and A.
Abello
. Automatic validation of requirements to support multidimensional design
. Data & Knowledge Engineering
, 69
(2010a
), 917
–942
.24.
D. T.
Francesco
, E.
Lefons
, F.
Tangorra
. Hybrid methodology for data warehouse conceptual design by UML schemas
. Inf. Softw. Technol
, 54
(4
), 360
–379
(2012
), doi:25.
M.
Thenmozhi
, K.
Vivekanandan
. Ontology based Hybrid Approach to Derive Multidimensional Schema for Data Warehouse
. International Journal of Computer Application
, 54
(8
), 36
–42
(2012
)26.
E.
Elhaj
, F.
Jamel
. Toward an Ontology Based Approach for Data Warehousing: State of the Art and Proposal. The International Arab Conference on Information Technology (ACIT2014)
, University of Nizwa
, Oman
, (2014
), pp. 170
–179
.27.
I. M.
Aljawarneh
. Design of a data warehouse model for decision support at higher education: A case study
, Information Development
. (2015
), pp. 1
–16
.28.
V. R.
Basili
, G.
Caldiera
, and H. D.
Rombach
. The Goal Question Metric Approach
. Encyclopedia of Software Engineering
, 2
(1994
), 528
–532
29.
P.
Bresciani
, P.
Giorgini
, F.
Giunchilia
, J.
Mylopoulos
, A.
Perini
. Tropos: an agent-oriented software development methodology
. Journal of Autonomous Agents and Multi-Agent Systems
, 8
(3
), 203
–236
(2004
).30.
E.
Yu
, Modelling Strategic Relationships for Process Reengineering
, Pd.D. thesis, University of Toronto
, (1995
), available at ftp://ftp.db.toronto.edu/pub/eric/DKBS-TR-94-6.pdf
This content is only available via PDF.
© 2016 Author(s).
2016
Author(s)
You do not currently have access to this content.
