At a glance
3 days
AUD $2200 inc GST
to run this course in-house.
Advanced Data Modeling
There are many challenges regularly faced by experienced data modelers, and these can include anything from difficulties enforcing complex business rules, to dealing with existing databases or commercial-off-the-shelf applications.
This intense, participative course covers a range of important strategic and technical issues including:
- The role of enterprise models
- How a data architecture team can add value
- Conceptual, Logical and Physical models
- Quality criteria for data models - content and presentation
- Engaging the business and getting informed input
- Working with DBAs and other technical stakeholders
- Working with different approaches, including agile methods
The course provides students with direction for resolving some of the common technical issues faced by data modelers by providing a concrete set of frameworks, methods, tips, techniques, and other tools that they draw on to keep the process moving, with everyone engaged, even when complex, difficult situations are encountered.
Intended For
- Data Architects, Data Administrators
- Data Analysts, Data Consultants
- Data Warehouse Managers, Database Administrators
- Business and Systems Analysts involved in Corporate modeling
Prerequisites
The course does not focus on any particular modeling notation or database product, and attendees should have a good understanding of data modeling conventions and activities and some practical experience in the area.
It is recommended that attendees have 2 to 3 years practical experience with data modeling.
Please note: The concepts of Normalisation to 3NF are pre-requisite and will not be re-taught. Fundamentals of data modeling, including Normalisation to 3NF, are covered in Software Education’s Business Systems Analysis course.
Learning outcomes
By the end of this course, participants will be able to:
- Appreciate the need for ‘resilience’ in data models
- Explore a range of advanced modeling problems
- more precise techniques for Control (business rules)
- more powerful designs to accommodate Flexibility/Extensibility - Understand how to involve corporate stakeholders meaningfully in the process
- Utilise a portfolio of skills to deliver high quality data models that will ‘stand the test of time’ for the business.
Content
Data Modeling - Past, Present, Future
Operational Files
The Integrated Database
The Operational Level
The Management Level
The Client’s View
The Corporate Model
Tools & Techniques
The Zachman Framework
Model Limitations
‘Levelled’ Models
The Price Stairway
Limitations of 3NF
1NF, 2NF, 3NF reviewed
BCNF
The Primary Key
Alternate Keys
Virtual Attributes
Combination controls
Foreign Keys - extended
Tools For Business Rules
Beyond 3NF
Ternary Relationships
Facts and Rules
4NF
5NF
De-Normalising 4NF & 5NF
Super-Types & Sub-Types
Sub-Set Components
Aggregation
Non-Exclusive Sub-Types
Sub-Set Variants
Conflicting Attributes
Exclusive Sub-Types
DKNF
Nested Sub-Types
Dimensions
Overlapping
Stable Structures
Virtual Sub-Types
Recursions
Fixed Structures
Recursive Structures
1:1 Recursion
1:M Recursion
M:M Recursion
Benefits Of Recursions
Spotting Recursions
Recursive Functionality
Structural Rules
Controlling Recursions
Sub-Typing Recursions
Performance Issues
The Dimension Of Time
Modeling For Time
Existence Rules
Continuous v Disjoint
Co-Existent v Discrete
Units Of Time
The ‘Grain Of Sand’
Generalisation
Levels Of Abstraction
‘Classification’
Implied Roles
Multiple Relationships
Modeling Our Roles
Modeling Ourselves
Generic Functions
Patterns
Metadata
Data About Data
Key Attributes
Virtual Attributes
Attribute Domains
Dynamic Grouping
The Data Dictionary
The Data Warehouse
XML
Method Used
Lecturing is kept to the minimum necessary. The workshop contains a comprehensive case study that the participants work through over the three days, applying all the techniques and learning how to combine the requirements of ‘control’ with those of ‘flexibility’.
Documentation
Course notes, including guides, templates and checklists. References to Web sites and further reading.
