Email this article 
Multidimensional Pattern Construction and Logical Reuse for the Design of Data Marts
(*) Corresponding author
DOI's assignment:
the author of the article can submit here a request for assignment of a DOI number to this resource!
Cost of the service: euros 10,00 (for a DOI)
Abstract
Design patterns have demonstrated their advantages in accelerating the development of complex systems. These advantages motivated us to investigate their integration in the design of decisional systems. As a result of our investigation, we propose a method for data mart (DM) design, based on the reuse of multidimensional patterns (MP). These latter are multidimensional schemas that represent typical, analytical requirements in a given domain. In addition, MP are generic, i.e., independent of a particular operational information system. An MP can be adapted by a decision-maker through a set of reuse operations to derive a DM schema. Furthermore, to provide for this DM design approach, we have developed a method for the construction of MP.
Copyright © 2016 Praise Worthy Prize - All rights reserved.
Keywords
References
B. J. Lechtenbörger Hüsemann, . Vossen, Conceptual Data Warehouse Design, Proc. of the Int’l Workshop on Design and Management of Data Warehouses, Stockholm, Sweden, 2000, pp. 6.1-6.11.
D. Moody, M. Kortnik, From Enterprise Models to Dimensional Models: A Methodology for Data Warehouse and Data Mart Design, DMDW’00, Sweden, 2000.
L. Cabibbo, R. Torlone, A logical Approach to Multidimensional Databases, EDBT’98. Spain, 1998.
M. Golfarelli., D. Maio, S. Rizzi, Conceptual design of data warehouses from E/R schemes, 31st Hawaii International Conference on System Sciences, 1998.
M. Golfarelli, S. Rizzi, A Methodological framework for Data Warehouse Design, DOLAP’98, USA, 1998.
R. Kimball, M. Ross, The Data Warehouse Toolkit (John Wiley and Sons. 2002).
A. F. Bonifati, S. Ceri Cattaneo, A. Fuggetta., S araboschi, Designing Data Marts for Data Warehouse, ACM Transaction on Software Engineering and Methodology, ACM, vol. 10, October 2001, pp. 452-483.
C. Phipps, K. Davis, Automating data warehouse conceptual schema design and evaluation, DMDW'02, Canada, 2000.
E. Gamma, R. Helm, J. Johnson, J. Vlissides, Design patterns: Elements of reusable Object Oriented Software. (Addisson-Wesley, 1999).
J. Feki, H. Ben-Abdallah, Preinstantiating Star Patterns for the Design of Data Marts, Information Conference on Control, Modeling and Diagnosis ICCMD’06, Annaba Algeria, 22-24 May 2006.
M. Ben-Abdallah, J. Feki, H. Ben-Abdallah, Star-Patterns for data mart design: Definition and logical reuse operator, International Conference on Computer and Communication Engineering, (ICCCE’06), Kuala Lumpur Malysia, 9-11 Mai 2006.
J. Feki, H. Ben-Abdallah, Designing Data Mart Schema from Real World Entities, ACIT’05 International Arab Conference on Information Technology (ACIT’05), Jordan, 6-8 December 2005.
W. Inmom, Building the data warehouse. Second edition 1996, New York, J. Wiley & Sons.
A. Soussi., J. Feki, F. Gargouri, “Approche semi-automatisée de conception de schémas multidimensionnels valides”. Revue des Nouvelles Technologies de l’information (RNTI), vol. B-1, pp. 71-90, 10 June 2005.
C.A. Hurtado, A.O. Mendelzon, OLAP Dimension Constraints, in 21st ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems (PODS’02), Madison, USA, juin 2002, pp 169-179.
A. Nabli, J. Feki, F. Gargouri, Adapting Multidimensional Schemes to Data sources using Algebraic Operators, 17 th International conference on Software Engineering and Knowledge Engineering SEKE’05, Taipei, Taiwan, Republic of China, 14-16 July 2005, pp 713-718.
J. Feki, H. Ben-Abdallah, M. Ben-Abdallah, Réutilisation des patrons en étoile, 24th Congres INFORSID’06, Tunisia 1-3 June 2006, pp 687-701.
Refbacks
- There are currently no refbacks.
Please send any question about this web site to info@praiseworthyprize.com
Copyright © 2005-2024 Praise Worthy Prize
