Logical Data Modeling

Logical Data Modeling
Tom Haughey
February 25-27, 2009
Atlanta, GA

This course is about taking knowledge of the business and its rules and converting these into a stable data model. The data model is a representation of the objects that the business uses, the characteristics of those objects and the rules that govern their relationship.

By attending this course you will be able to produce models that are:

• Independent of implementation and organizational
structure
• Accurate representation of the business
• Stable
• Simple (because they use refinement)
• Appropriately scoped
• Based on sound theoretical principles
• Easy to understand

This is a pragmatic workshop. There are many exercises and one continuous case study. This course offers comprehensive coverage of mainstream data modeling concepts. You learn a rigorous method for defining data. You also learn how to gather the data, define and analyze business rules, perform normalization, and use the results to create a stable model of the data within a business area You learn state of the art refinement techniques like subtyping and recursive relationships. Above all, you learn how to do data modeling rapidly.

Proven techniques are stressed for normalization, data model creation, interaction of data and process models and data views analysis. Both top-down and bottom-up methods are used.

You will learn the importance of business rules. Several types of business rules are addressed: static business rules, which are reflected in the relationships of the data model and dynamic business rules, which are processing rules reflected in the process models.

You will also learn three primary ways to validate a data model: a CRUD matrix, a data view and a data usage map. It is important to know when a data model is done. The workshop covers various criteria for determining when you have finished a data model. Specific steps for the conversion of a business area data model to a logical data model will be discussed and exercised.

The workshop covers the definition and purpose of data modeling. It reviews the steps in creating a rigorous data model. Where data modeling fits into the overall life cycle is stressed. To accomplish this, a framework is established into which data modeling fits.

A practical case study is used throughout the workshop. The case study provides experience with data identification, normalization, detailed data identification and model verification.

Topics will include:

• Introduction to data modeling
• The benefits of data modeling
• Data driven development
• Modeling concepts
• Characteristics of good models
• High level data modeling
• Explanation of major objects
o Entities, attributes, relationships
o Business rules
o Multiple relationships
o Recursive relationship
• Detailed data modeling
• Normalization
• Data view
• Current systems analysis
• Model consolidation
• Data model refinement
• Abstraction
• Subtyping
• Aggregation
• Bill of materials
• Derived data
• Model interaction
• Preparing for design
• Data model review
• Introduction to design
• Data design trade-offs
• Aggressive data design trade-offs
• Advanced topics

Click here for detailed agenda.

Prerequisite:
There are no pre-requisites. Everything you need to know about data modeling is taught in the class.

We also recommend this class for anyone who wants to brush up on their Data modeling skills.

Tom Haughey is currently President of InfoModel, Inc., a training and consulting company specializing in practical and rapid development methods. His courses on data management, data warehousing, and software development have been delivered to Fortune 1000 companies around the world. He has worked on the development of seven different CASE tools, over 40,000 copies of which have been sold to date. He was formerly Chief Technology Officer for the Pepsi Bottling Group and Enterprise Director of Data Warehousing for Pepsico. He wrote his own CASE tool in 1984.He formerly worked for IBM for 17 years as a Senior project manager. He is the author of many articles on Data Management, Information Engineering and Data Warehousing.

Tuition
$1795

$1595 if registered and paid by Jan 25, 2009

Additional $100 discount for members of DAMA, ERwin Groups, IDMA and MPO

Group discounts are available.

We encourage you to register early.

PLEASE NOTE:
REGISTRATION FOR THIS CLASS CLOSES FEB. 11, 2009.

For registration please click here.

Seminar location and hotel accommodations
The seminar will be held at the
AMA Atlanta Executive Conference Center
1170 Peachtree Street
Atlanta, Georgia

Class attendees are eligible for discounted hotel rooms nearby.

Please click here for hotel information. When reserving please ask for the AMA rate.

For additional information please email davida@debtechint.com or call (973) 379-7212.