• Home
  • Nov Half Day Workshop: Introduction to Fact Modeling - Getting out of the traps of "Table Think"

Nov Half Day Workshop: Introduction to Fact Modeling - Getting out of the traps of "Table Think"

  • November 14, 2014
  • 8:00 AM - 12:00 PM
  • Sila Solutions Group, 6840 Fort Dent Way Suite 375 Seattle, WA 98188
  • 22

Registration

  • Includes one-year memberhsip *NEW Member ONLY
  • Please contact marketing@dama-ps.org for registration eligibility and code.

Registration is closed

 

SPECIAL: Non-Member price includes an individual membership ($50 value).  All non-member registrants will be enrolled in a one-year membership after the event. Please contact membership@dama-ps.org if you would like to OPT OUT of the free membership. *New Member ONLY


Summary

Following the step by step process presented in this workshop, you can produce a data model with all the information needed to correctly put attributes into entity tables, and to formally define much richer integrity constraints leading to higher quality data.

To appreciate Fact Oriented Modeling (FOM, such as ORM) you must approach data modeling differently than in relational modeling. This tutorial will show you exactly how you need to change your thinking, your approach to data modeling. You will find it to be more intuitive and direct. In fact, you may discover that you are already thinking in this way somewhat. Here we will formalize the approach so you can apply it in your data modeling projects immediately. You are no longer constrained by thinking about relational tables, what attributes or columns to include in those tables, wondering if you have done it “right” or not, and whether or not you have violated any of the rules of normalization. We will work through some simple exercises to solidify your understanding. After this you will never think about data modeling the same way again.


What You Will Learn

Learn how to generate tables by applying two simple transformation rules. You are not left with a paper and pencil approach -- data modeling tools exist to support this modeling process and generate the relational tables automatically, guaranteed to be fully normalized.

  • Basics of fact-oriented modeling and how it contrasts with the traditional ER/Relational approach to data modeling.
  • Apply it in some small design problems and discover how much easier it is to arrive at a better final data model. 
  • See a demonstration of this process using an open source data modeling tool.

Speaker Profile

Dr. Gordon Everest is Professor Emeritus of MIS and Database in the Carlson School of Management at the University of Minnesota. With early "retirement," he continues to teach as an adjunct. 

His Ph.D. dissertation at the Univ of Pennsylvania Wharton School entitled "Managing Corporate Data Resources" became the text from McGraw-Hill, "Database Management: Objectives, System Functions, and Administration".

Gordon has been teaching all about databases, data modeling, database management systems, database administration, and data warehousing since he joined the University in 1970. Students learn the theory of databases, gain practical experience with real data modeling projects, and with hands-on use of data modeling tools and DBMSs. Besides teaching about databases, he has helped many organizations and government agencies design their databases. Gordon is the recipient of the DAMA-I Academic Achievement Award, 2006 and again in 2011. 

Gordon facilitates data modeling projects working with subject matter experts to elicit a common understanding of their world to be modeled. Actually doing it informs his teaching and presentations. His presentations tend to be very informative, fairly intense and challenging to the attendees, both novice and advanced. They have always been well received. They generally cut to the essence of things to help clarify fuzzy thinking. 



© DAMA Puget Sound 2017

Powered by Wild Apricot Membership Software