2-Day (SQ-DMODPTR-201-EN)
Description
Author
Audience
Prerequisites
Course Outline
Description
Data Model Patterns Workshop is based on thesis that a modeling techniques expertise is mandatory, but not sufficient prerequisite to successfully build data models of real life, complex businesses and enterprises. Knowing the underlying structure of an enterprise and nature of a business is the missing piece.
Although it is true that no two organizations share exactly the same model, it is also noticeable that even widely differing enterprises have many similar components. Understanding those similarities gives us the basis for creating a starting model, which can then be adjusted as necessary to match the specifics of a particular organization.
Data Model Patterns Workshop deals exactly with these patterns and concepts that are common to different businesses and enterprises. The main intention of the workshop is to arm analysts and data modelers with a toolkit of data model patterns and conceptual data models that will help them ask the right questions, discover specifics of a particular organization and prepare a good model of a real business.
Author
The author of this course is Mario Korbar:
Mario works for many years now as the main designer of applications and databases. He was the program manager for many different projects in Croatia and other countries. In this course, Mario has collected the best of his experiences.
Audience
This course is intended for application developers. Database Administrators can gain a lot from the course as well.
Prerequisites
Participants should be familiar with data modeling theory and techniques. They should also have a basic knowledge of UML class diagrams.
Course Outline
Module 0: Introduction
- At the beginning, instructor and attendants introduce themselves. Instructor gives an overview of the agenda and provides info about the course facilities.
Module 1: Introducing Data Model Patterns
- This module gives an overview of data modeling process in the context of a software development lifecycle and discusses differences between a conceptual, logical and physical data model. The module also introduces the concept of data model patterns and the motivation behind them. At the end of module, we introduce several problem domains that will be explored in more details during the course.
Module 2: People and Organizations
- Module 2 explores party pattern. We use that pattern to model people and organizations. Since people and organizations share lots of common characteristics (attributes and relationships to other entities in the enterprise), we introduce a party entity as their supertype and explore their common characteristics.
However, while supertyping of people and organizations into a party is rather obvious, subtyping of these entities isn't so straightforward and can significantly differ between various systems. The main considerations for subtyping people and organizations are also discussed in the module.
Module 3: Business Documents and Contracts
- All business solutions deal with various kinds of business documents and contracts (sales orders, purchase orders .). Module 3 explores their conceptual data model.
Module 4: Activities and Work Orders
- This module explores the planning, scheduling and recording activities in the context of both production and service delivery in an enterprise. Work orders are introduced and modeled as the means of organizing enterprise activities.
Module 5: Bookkeeping
- Module 5 defines the conceptual data model essential to bookkeeping. In this module we want to extract similarities and common structure of different bookkeeping activities (receivables, payables, fixed assets...) and to create a uniform bookkeeping data model.
Module 6: Security
- This module promotes a systematic and uniform approach to security rules modeling in the software system. We will discuss modeling and implementation of "horizontal" (row level) data security rules in more details.