
In this lesson we discuss the definition of data, information and knowledge. Furthermore we look at the four aspects of data
We discuss the various aspects of modeling, including the DaMa definitions, the modeling techniques and some general definitions
Introduction to the basic modeling concepts like getting around, repository based modeling and using perspectives.
Introduction to the navigation and usage for the various data modeling techniques, creating basic diagrams and creating a repository structure
Discussion of the conceptual data modeling techniques. Including tips and tricks for conceptual data modeling
Techniques and usage for concept lists and trees
Description of the modeling technique Supplier - Input - Process - Output - Consumer
Using the Enterprise Architecture modeling language ArchiMate for creating conceptual data models
Description of why and how to create logical data models using UML modeling techniques
Basic concepts of class diagrams explained from a data perspective.
Extend UML Class Diagrams with extra notations for the expression of cardinalities, attributes and roles
Use UML Object Models and simulators for explaining class models to stakeholders
Learn about advanced concepts like enumerations and complex data types. There is a downloadable example repository with the NIEM and UBL logical datamodel.
Introduction, including tips and tricks on creating physical data models
Basic ER modeling techniques explained
Advanced modeling concepts like indexes, unique constraints and checks
Modeling for data in motion: XML Schema Definition
Discussion of the first 3 normal forms and why they are relevant for physical data models
Learn how to integrated the modeling layers, including the approach in Sparx Enterprise Architect
Learn how to apply CRUD, RACI or OET matrix diagrams
Using an information system modeling technique: Data Flows
Describing a detailed data modeling technique: Data Mappings
Introduction to the data modeling techniques for DWH like star and snowflake models
Examples of data model applications like Service Orientation or Master Data Management
Discussions on Data Modeling and a look to the future
This course draws a picture of the workfield of data and information modeling. Addressing the various modeling methodologies and the reasons behind choosing these different modeling methods. We will provide practical tips on how data modeling offers added value for your organisation, based on numerous backgrounds including databases, datawarehousing, messaging, data architecture, data governance, software development, big data and (master) data management.
You can create your own models based on a simple case giving you the opportunity to create a three layer information and data model based on:
The conceptual data model for business representatives
The logical data model for describing details of the data and information for both business and technical representatives
The physical data model, for database design and message modelling for technical staff.
The following modeling techniques are demonstrated:
Concept lists and trees,
SIPOC,
ArchiMate,
UML class and object modeling,
Entity Relationship,
XSD,
CRUD,
RACI,
OET,
Data Flows,
Snowflake and Star ModelsBased
All these techniques can be applied on the simple case so you are able to practice the theory. You get examples of how to create every modeling technique discussed. The demo models are prepared in Sparx Enterprise Architect, but you can also create your own modeling tool. Furthermore you will receive an example repository for Sparx Enterprise Architect with all the modeling techniques discussed.