TOWARDS MODEL-DRIVEN EVOLUTION OF DATA WAREHOUSES

Christian Kurze, Marcus Hofmann, Frieder Jacobi, André Müller, Peter Gluchowski

2011

Abstract

Data warehouse systems represent centralized data collections used for the purposes of data analysis and decision support. Development and maintenance of extensive data warehouse systems require appropriate support through methods and tools. Therefore, we introduce the project Computer-Aided Warehouse Engi-neering (CAWE). It is a model-driven approach to the engineering of data warehouse systems. Especially the process of data warehouse evolution, i.e. the maintenance of the core data storage component, the data warehouse in narrow sense, is a tedious task since the change of data structures implies the challenge of en-suring integrity and history of corporate data. The paper at hand provides research in progress and suggests the adoption of a multidimensional algebraic formalism to the model-driven development paradigm.

References

  1. Aiken, P., 1996. Data Reverse Engineering: Slaying the Legacy Dragon, McGraw-Hill. New York et al.
  2. Barr, A., Feigenbaum, E. A., 1990. The Handbook of Artificial Intelligence, Volume 1, Addison-Wesley. Reading et al, 2nd edition.
  3. Bernstein, P. A., Melnik, S., 2007. Model management 2.0: manipulating richer mappings. In Proceedings of the 2007 ACM SIGMOD international conference on Management of data. ACM, pp. 1-12.
  4. Blaschka, M., 2000. FIESTA: A Framework for Schema Evolution in Multidimensional Databases. Dissertation Thesis at Technical University Munich, Germany.
  5. Bulos, D., Forsman, S., 2006. Getting started with ADAPT. Online available: http://www.symcorp.com/ downloads/ADAPT_white_paper.pdf. Last access: 2011-01-11.
  6. Chaudhuri, S., Dayal, U., 1997. An overview of data ware housing and OLAP technology. ACM SIGMOD Record, 26(1), pp. 65-74.
  7. Chikofsky, E. J., Cross, J. H., 1990. Reverse engineering and design recovery: a taxonomy. IEEE Software, 7(1), pp. 13-17.
  8. Czarnecki, K., Helsen, S., 2006. Feature-based survey of model transformation approaches. IBM Systems Journal, 45(3), pp.621-645.
  9. Favre, C., Bentayeb, F., Boussaid, O., 2009. A Survey of Data Warehouse Model Evolution. In Handbook of Research on Innovations in Database Technologies and Applications: Current and Future Trends, Hershey. New York.
  10. Gluchowski, P., Kurze, C., Schieder, C., 2009. A Modeling Tool for Multidimensional Data using the ADAPT Notation. In Proceedings of the 42nd Hawaii International Conference on System Sciences. IEEE.
  11. Guo, Y., Tang, S., Tong, Y., Yang, D., 2006. Triple-driven data modeling methodology in data warehousing: a case study. In Proceedings of the 9th ACM international workshop on Data warehousing and OLAP. ACM, p. 59-66.
  12. Inmon, W. H., Strauss, D., Neushloss, G., 2008. DW 2.0: the architecture for the next generation of data warehousing, Morgan Kaufmann. Amsterdam et al.
  13. Kaas, C., Pedersen, T. B., Rasmussen, B., 2004. Schema evolution for stars and snowflakes. In Proceedings of the 6th International Conference on Enterprise Information Systems. INSTICC, pp. 425-433.
  14. Kurze, C., Gluchowski, P., 2010. Computer-Aided Warehouse Engineering (CAWE): Leveraging MDA and ADM for the development of Data Warehouses. In Proceedings of the 16th Americas Conference on Information Systems. AIS, paper 282.
  15. Mazón, J. N., Trujillo, J., 2008. An MDA approach for the development of data warehouses. Decision Support Systems, 45(1), pp. 41-58.
  16. Object Management Group, 2003. MDA Guide Version 1.0.1. Online available: http://www.omg.org/cgi-bin/ doc?omg/03-06-01. Last access: 2011-01-11.
  17. Ulrich, W., Newcomb, P. H., 2010. Information Systems Transformation: Architecture-Driven Modernization Case Studies, Morgan Kaufmann. Amsterdam et al.
Download


Paper Citation


in Harvard Style

Kurze C., Hofmann M., Jacobi F., Müller A. and Gluchowski P. (2011). TOWARDS MODEL-DRIVEN EVOLUTION OF DATA WAREHOUSES . In Proceedings of the 13th International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-8425-53-9, pages 356-360. DOI: 10.5220/0003444303560360


in Bibtex Style

@conference{iceis11,
author={Christian Kurze and Marcus Hofmann and Frieder Jacobi and André Müller and Peter Gluchowski},
title={TOWARDS MODEL-DRIVEN EVOLUTION OF DATA WAREHOUSES},
booktitle={Proceedings of the 13th International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2011},
pages={356-360},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0003444303560360},
isbn={978-989-8425-53-9},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 13th International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - TOWARDS MODEL-DRIVEN EVOLUTION OF DATA WAREHOUSES
SN - 978-989-8425-53-9
AU - Kurze C.
AU - Hofmann M.
AU - Jacobi F.
AU - Müller A.
AU - Gluchowski P.
PY - 2011
SP - 356
EP - 360
DO - 10.5220/0003444303560360