"If a man empties his purse into his head, no one can take it away from him. An investment in knowledge always pays the best interest."
Benjamin Franklin




TECHNICAL DATA MODELING
 
 
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.

 

Home |  About Us |  Key Services |  Problems Solved |  Resources |  Contact Us
Copyright © 2017 Advanced Strategies, Inc.
Feedback and Suggestions