Technical Data Modeling is a technique for developing high quality data structures. Technical data modeling transforms a business object model to a conceptual data model, to a logical data model then to a physical data model.
Technical data modeling shifts from a business view of the natural world to a technical view of data structures and their organization.
Since the data models are direct transformations of the business object model, the resulting data structures are: - Stable - The structure is prepared for unanticipated queries
- Flexible - New relationships and new objects can be added without altering the initial data structure
- Intuitive - Users can efficiently find the data they need since the data structure matches their view of the world
- Complete - Containing all the business objects and relationships (and therefore data) the users care about
- Compact – Eliminating unnecessary redundant data and unmanaged data
Data structures that are stable, flexible, intuitive, complete, and compact provide more value to an enterprise and require less spending on maintenance, support, training and enhancements.
Course Outcomes:
Students of Advanced Strategies’ Technical Data Modeling Course will return to work with the skills necessary to construct high quality logical data specifications using data structure diagrams in their actual work settings.
In addition, they will understand typical constraints and considerations in physical database design.
Note: This course is not geared towards the specifics of any particular DBMS.
Course Outline:
Review of Business Object Modeling
- The Focus Statement
- Entities
- Relationships
- Cardinality
- Attributes
|
Developing a Conceptual Data Model
- Logical Records
- Logical Record Links
- Data Elements
- Converting a Business Object Model to a Conceptual Data Model
- Confirming Normalization
|
Developing a Logical Data Model
- Converting a Conceptual Data Model to a Logical Data Model
- Implementation Focus
- Business Policy Requirements
- Security, Control, and Audit Requirements
|
Structure Adjustment
- What? Why? and When?
- Expanding the Structure
- Reducing the Structure
|
Transaction Analysis
- Performance Optimization
- Transaction Analysis Procedure
- Composite Transaction Analysis
|
Developing a Physical Data Model
- Converting a Logical Data Model to a Physical Data Model
- Data Architecture Constraints
- Data Organization Paradigm Constraints
- Typical DBMS Constraints
- Performance Considerations
|
Who Should Attend:
This course is targeted for Data Modelers, Database Administrators, Systems and Business Analysts, and other individuals involved in data analysis and design.
Course Prerequisites:
Business Object Modeling
Course Duration:
Three Days
Class Availability:
Request It Now!
Materials Provided:
Student Workbook including Case Studies and Live Examples
____________________________________________________________________________
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
|
