Transforming an operational system model to a data warehouse model: A survey of techniques

Proceedings - IEEE International Conference on Software - Science, Technology and Engineering 2005, SwSTE '05

Volumn 2005, Issue , 2005, Pages 47-56

  Dori, Dov ^a   Feldman, Roman ^a   Sturm, Arnon ^b  

^a TECHNION ISRAEL INSTITUTE OF TECHNOLOGY   (Israel)

^b BEN GURION UNIVERSITY OF THE NEGEV   (Israel)

Author keywords

[No Author keywords available]

Indexed keywords

COMPUTATIONAL METHODS; DATA ACQUISITION; KNOWLEDGE BASED SYSTEMS; MATHEMATICAL MODELS; SYSTEMS ANALYSIS;

BUSINESS PROCESSES; FEATURE-BASED COMPARISON METHOD; TRANSACTIONAL ENTITIES;

DATA WAREHOUSES;

EID: 33744497261     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/SWSTE.2005.22     Document Type: Conference Paper

References (30)

1. Boehnlein, M. and. Ende, A. U, "Deriving initial data warehouse structures from the conceptual data models of the underlying operational information systems", In Proc. 2nd DOLAP, Kansas City, USA, 1999.
2. Boehnlein, M. and. Ende, A. U, "Business Process Oriented Development of Data Warehouse Structures", In Proc. DW2000, Friedrichshafen, Germany, 2000.
3. Chang, D.T., and Poole, J.D. "Extending UML for Data Warehousing and Business Common Warehouse Metamodel". OMG's First Workshop on "UML in the .com Enterprise", Nov. 6-9, 2000, Palm Springs, CA.
4. Chaudhuri, S. and Dayal, U. An overview of data warehousing and OLAP technology. ACM SIGMOD Record, 26(1):65-74, 1997.
5. Chen, P., "The Entity-Relationship Model - Toward a Unified View of Data", QACM Transactions on Database Systems, Vol. 1, No. 1, 1976, pp. 9-36.
6. Ferstl, O.K., Sinz, E.J.: SOM Modeling of Business Systems, in: Bernus, P.; Mertins, K.; Schmidt, G. (Eds.): Handbook on Architectures of Information Systems - International Handbook on Information Systems, Springer, Berlin 1998, pp. 339-358.
7. Glassey K., "Business Intelligence is a Smart Move", IEEE IT Professional, 1999.
8. Golfarelli, M., Maio, D. and Rizzi, S., "Conceptual Design of Data Warehouses from E/R Schemes", In Proc. 31st HICSS, Hawaii, USA, 1998.
9. Golfarelli, M., Maio, D. and Rizzi, S., "The Dimensional Fact Model: a conceptual Model for Data Warehouses", Int. Journal of Cooperative Information Systems, 7, 2&3, 1998.
10. Golfarelli, M. and Rizzi, S., "Designing the Data Warehouse: Key Steps and Crucial Issues", Journal of Computer Science and Information Management, Vol. 2, N. 3, 1999.
11. Golfarelli, M., Rizzi, S. and Vrdoljak, B., "Data Warehouse Design from XML Sources", In Proc. 4th DOLAP, Atlanta, USA, 2001.
12. Gopalkrishnan, V., Li, Q., and Karlapalem, K., "Issues of Object-Relational View Design in Data Warehousing Environment", In Proc. IEEE SMC Conference 1998, pp. 2732-2737.
13. Gopalkrishnan, V., Li, Q. and Karlapalem, K., "Star/Snow Flake Schema Driven Object-Relational Data Warehouse Design and Query Processing Strategies", Lecture Notes in Computer Science, 1676, 1999, pp. 11-22.
14. Husemann, B., Lechtenborger, J. and Vossen, G., "Conceptual Data Warehouse Design", In Proc. 2nd DMDW, Stockholm, Sweeden, 2000.
15. Kaldeich, K., Oliviera e Sa, J., "Data Warehouse Methodology: A Process Driven Approach", In Proc. CAiSE 2004, Lecture Notes in Computer Science 3084, 2004.
16. Kim, H., Lee, T.H., Lee, S., Chun, J., "Automated Data Warehousing for Rule-based CRM Systems", In Proc. 14th Australasian Database Conference (ADC), Adelaide, Australia, 2003.
17. Kimball, R., "The Data Warehouse Toolkit", John Willey & Sons, Inc., 1996.
18. Lehner, W., Albrecht, J., Wedekind, H., "Normal Forms for Multidimensional Databases", In Proc. 10th SSDBM, Capri, Italy, 1998.
19. List, B., Schiefer, J., Tjoa, A.M., Quirchmayr, G., " Multidimensional Business Process Analysis with the Process Warehouse", in: Abramowicz, W., Zurada, J. (Eds.): "Knowledge Discovery for Business Information Systems", Kluwer Academic Publishing, Boston 2000, pp. 211-227.
20. Marotta, A. and Ruggia, R., "Data Warehouse Design: A Schema-transformation Approach", In Proc. 12th SCCC, Atacama, Chile, 2002.
21. Medina, E., Trujillo, J., "A Standard for Representing Multidimensional Properties: The Common Warehouse Metamodel (CWM)", In Proc. 6th ADBIS, Bratislava, Slovakia, 2002;
22. Lecture Notes in Computer Science, 2435, 2002.
23. Moody, D. L. and Kortink, M. A. R., "From Enterprise Models to Dimensional Models: A Methodology for Data Warehouse and Data Mart Design", In Proc. 2nd DMDW, Stockholm, Sweden, 2000.
24. Phipps, C., Davis, K., "Automating Data Warehouse Conceptual Schema Design and Evaluation", In Proc. 4th DMDW, Toronto, Canada, 2002.
25. Red Brick Systems Inc., "Star Schema Processing for complex queries", White Paper 1997.
26. Romm, M., "Introduction to Data Warehousing", White Paper by the Database Interest Group, www.mutualmentor.com/dig.
27. Sapia, C., Blaschka, M., Hofling, G. and Dinter, B., "Extending the E/R model for the Multidimensional Paradigm", In Proc.1st Intl. Workshop on Data Warehouse and Data Mining (DWDM), 1998, Lecture Notes in Computer Science, 1552, 1998.
28. Trujillo, J., Palomar, M., Gomez, J. and Song, I.Y., "Designing Data Warehouses with OO Conceptual Models", IEEE Computer, 2001.
29. Tryfona, N., Busborg, F. and Cristiansen, J. G. B., "StarER: A Conceptual Model for Data Warehouse Design", In Proc. 1st DOLAP, Washington DC, USA, 1998.
30. Unified Modeling Language Home Page www.uml.org.