DPM-FT2009
From Wiki of the E-Business and Web Science Research Group
Lecture: Data and Process Modeling / Unternehmensmodellierung und -architekturen (DPM)
Prof. Dr. Martin Hepp
Bundeswehr University Munich, FT 2009
News
2009-09-28: Second Exam takes place on September 29, 2009, 9:30 - 10:30, Geb. 35 1210A
2009-08-08: Exam and possible solution published.
2009-06-26: All materials are now online.
2009-04-28: No lecture and tutorial on 4th May.
2009-04-27: All materials up to unit 3 are now online.
2009-04-06: Web page initialized.
Exam
- WOW Bachelor students: Registration via the Office of Academic Affairs (Prüfungsamt).
- WIN Bachelor students: Registration via the Office of Academic Affairs (Prüfungsamt).
- Diploma students: Contact us directly.
Date and Room: July 3, 2009, 9:30 - 10:30, Geb. 35 1210B
Update: Check here for the exam (task description) and here for a possible solution.
Learning Goals
Computers are the most important tool for automating tasks in businesses. A key prequisite to using computers is to create suitable models of all relevant objects and activities in the domain of interest, e.g. data structures and processes.
In this lecture and tutorial, students will learn the theoretical foundations and practical skills of designing, maintaining and using data and process models in information systems. In the beginning, the impact of modeling on the alignment between the IT and the business sphere of entereprises is being discussed. Following that, common notations for conceptual structures and data (e.g. ERM, UML class diagrams, and ORM) and processes (e.g. Petri nets, EPCs, BPMN, and UML Activity diagrams) will be covered and their usage practiced. Lastly. the impact of reference models on the integration of systems and organizations will be discussed.
Eventually, students will develop a sound theoretical understanding of modeling data structures and processes in IT projects. In addition, they will acquire practical skills in using popular modeling languages and respective tools.
General Information
- Lecture: Mondays, 16:45 - 18:15, room 35/01243
- Tutorial and Exercises: Mondays, 18:30 - 20:00, room 35/01241
Resources
Core Literature
[CiWi2005] Cimsion, Graeme C.; Witt, Graham C.: Data Modeling Essentials. 3rd. Aufl., Morgan Kaufmann Publishers, Amsterdam etc. 2005.
[KrOB2007] Krogstie, John et al. (Hrsg.): Conceptual Modeling in Information Systems Engineering. Springer, Berlin etc. 2007.
[Oliv2007] Olivé, Antoni: Conceptual Modeling of Information Systems. Springer, Berlin and Heidelberg 2007.
Additional Literature
[Diet2006] Dietz, Jan L. G.: Enterprise Ontology. Springer, Berlin / Heidelberg 2006.
[DuAH2005] Dumas, Marlon et al. (Hrsg.): Process-Aware Information Systems. John Wileay & Sons, Hoboken, New Jersey, USA 2005.
[GrRo2005] Green, Peter; Rosemann, Michael (Hrsg.): Business Systems Analysis with Ontologies. Idea Group Publishing, Hershey, PA, USA 2005.
[Guar1998] Guarino, Nicola (Hrsg.): Formal Ontology in Information Systems. IOS Press, Amsterdam 1998.
[HeLM2007] Hepp, Martin et al. (Hrsg.): Ontology Management. Semantic Web, Semantic Web Services, and Business Applications. Springer, New Work 2007.
[JaBu1996] Jablonski, Stefan; Bussler, Christoph: Workflow Management. Modeling Concepts, Architecture and Implementation. International Thomson Computer Press, London etc. 1996.
[PaSZ2006] Parent, Christine et al.: Conceptual Modeling for Traditional and Spatio-Temporal Application. Springer, Berlin and Heidelberg 2006.
[StSt2004] Staab, Steffen; Studer, Rudi (Hrsg.): Handbook on Ontologies. Springer, Berlin etc. 2004.
[Thal2000] Thalheim, Bernhard: Entity-Relationship Modeling. Springer, Berlin etc. 2000.
[GrRo2005] Green, Peter; Rosemann, Michael (Hrsg.): Business Systems Analysis with Ontologies. Idea Group Publishing, Hershey, PA, USA 2005.
Tools
- Windows-Terminal-Server of UniBW: https://wts.unibw.de/
- Protege Ontology Editor: http://protege.stanford.edu/
- ER Tools
- RISE Editor: http://www.risetobloome.com/
- Kivio: http://www.koffice.org/kivio/
- Dia: http://live.gnome.org/Dia/
- UML Tools: See list at http://en.wikipedia.org/wiki/List_of_UML_tools
- ORM Tools:
- Toolkit for Conceptual Modeling (TCM): http://wwwhome.cs.utwente.nl/~tcm/ (last update 2003, though)
- ICOM - A Tool for Intelligent Conceptual Modelling: http://www.inf.unibz.it/~franconi/icom/
- ARIS Express (free edition): http://www.ariscommunity.com/aris-express
Links and Other Resources
- Wikipedia article on data modeling: http://en.wikipedia.org/wiki/Data_modeling
- Data Modeling 101: http://www.agiledata.org/essays/dataModeling101.html
- Data Modeling Resource Center: http://infogoal.com/dmc/dmcdmd.htm
Lecture: Schedule and Materials
Unit 1: Introduction (April 6)
Slides as PDF: 1 slide per page (file size: 2.01 MB, MIME TYPE: application/pdf)<span class="fileInfo" />
Reading assignment:
- [Oliv2007], pp. 1-36
- [KrOB2007], pp. 1-18
- Thomas Kuehne: What is a model?
Additional reading: none
Unit 2: Entity-Relationship Modeling (April 20)
Slides as PDF: 1 Slide per page (file size: 833 KB, MIME TYPE: application/pdf)
Reading assignment:
- Hepp, Martin; Thome, Rainer: Datenmodellierung, in: wisu - das wirtschaftsstudium, 30 (2001) 7, (Studienblatt).
Additional reading:
- Ferstl, O.K., Sinz, E.J.: Grundlagen der Wirtschaftsinformatik. Oldenbourg, München und Wien, 2001.
- Chen, P.: The Entity-Relationship Model - Toward a Unified View of Data. ACM Transactions on Database Systems 1 (1976) 9-36
Unit 3: Conceptual Modeling with UML Class Diagrams (April 27)
Slides as PDF: 1 Slide per page (file size: 778 KB, MIME TYPE: application/pdf)
- Tutorial exercises (file size: 126 KB, MIME TYPE:application/pdf)
- Tutorial solutions (file size: 180 KB, MIME TYPE:application/pdf)
- Tutorial solutions -complete version- (file size: 125KB, MIME TYPE:application/pdf)
Reading assignment:
- Jim Arlow and Ila Neustadt: UML 2 and the Unified Process: Practical Object-Oriented Analysis and Design (2nd Edition), Addison-Wesley Object Technology Series, Addison-Wesley 2nd ed, 2005, ISBN 978-0321321275
Additional reading:
Unit 4: Conceptual Modeling Project: Offerings on the Web (May 11)
There are no slides provided for this unit.
Reading assignment:
Additional reading:
Unit 5: Process Modeling (May 18)
Slides as PDF: 1 slide per page (file size: 1.12 MB, MIME type: application/pdf)
Reading assignment:
- Hepp, Martin; Leymann, Frank; Domingue, John; Wahler, Alexander, and Dieter Fensel: Semantic Business Process Management: A Vision Towards Using Semantic Web Services for Business Process Management, in: Proceedings of the IEEE International Conference on e-Business Engineering (ICEBE 2005), October 18-20, 2005, Beijing, China, pp. 535-540.
- Keller, G., Nüttgens, M., Scheer, A.-W.: Semantische Prozessmodellierung auf der Grundlage "Ereignisgesteuerter Prozessketten (EPK)". Veröffentlichung des Instituts für Wirtschaftsinformatik, Saarbrücken (1992)
Additional reading:
- W.M.P. van der Aalst and M. Pesic: DecSerFlow: Towards a Truly Declarative Service Flow Language, Dagstuhl Seminar Proceedings 06291: The Role of Business Processes in Service Oriented Architectures, http://drops.dagstuhl.de/opus/volltexte/2006/829
Unit 6: The Economics of Conceptual Structures for Data Interchange (May 25)
Slides as PDF: 1 slide per page (file size: 1.94 MB, MIME type: application/pdf)
Reading assignment: Hepp, Martin: Possible Ontologies: How Reality Constrains the Development of Relevant Ontologies, in: IEEE Internet Computing, Vol. 11, No. 1, pp. 90-96, Jan-Feb 2007
Additional reading:
- M. L. Katz and C. Shapiro, "Network Externalities, Competition, and Compatibility," American Economic Review, vol. 75, pp. 424-440, 1985.
- C. Shapiro and H. R. Varian, Information Rules: A strategic Guide to the Network Economy. Boston, MA, USA: Harvard Business School Press, 1998.
Unit 7: Object-Role Modeling (June 8 - Part 1)
Slides as PDF: 1 slide per page (file size: 1.94 MB, MIME type: application/pdf)
Reading assignment:
- T. Halpin: Object-Role Modeling: An Overview
Additional reading:
- Halpin, T. 1999: Entity relationship modeling from an ORM perspective: Part 1, Journal of Conceptual Modeling, no. 11, www.inconcept.com.
- Halpin, T. 2000: Entity relationship modeling from an ORM perspective: Part 2, Journal of Conceptual Modeling, no. 12, www.inconcept.com.
Unit 8: Ontology Engineering (June 8 - Part II - rescheduled from June 15)
Slides as PDF: 1 slide per page (file size: 1.94 MB, MIME type: application/pdf)
Reading assignment:
- Uschold & Gruninger: Ontologies: Principles, Methods and Applications, 1996
- Hepp, Martin: Ontologies: State of the Art, Business Potential, and Grand Challenges, in: Hepp, M.; De Leenheer, P.; de Moor, A.; Sure,Y. (Eds.): Ontology Management: Semantic Web, Semantic Web Services, and Business Applications, ISBN 978-0-387-69899-1, Springer, 2007, pp. 3-22.
Additional reading:
- Staab, Steffen; Studer, Rudi (Hrsg.): Handbook on Ontologies. Springer, Berlin etc. 2004.
Unit 9: Exam Review (June 22)
There are no slides provided for this unit.
Tutorials
Tutorial ER/UML exercises (file size: 126 KB, MIME TYPE:application/pdf)
Tutorial ER/UML solutions (file size: 180 KB, MIME TYPE:application/pdf)
Tutorial BPMN exercises (file size: 434 KB, MIME TYPE: application/pdf)
Tutorial BPMN solutions (file size: 239 KB, MIME TYPE: application/pdf)
Video Recordings
There are no video recordings planned for this lecture.
