DAMA - Puget Sound
The Premier Organization for Data Management Professionals in the Northwest


RECAP - October 1/2 Day Workshop

  • November 11, 2016 2:26 PM
    Message # 4380440
    Anonymous member (Administrator)

    Dr. Gordon Everest was the presentor at the October 1/2 Day Workshop with the topic being Data Modeler's Most Valuable Construct:  Subtypes & Supertypes.


    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. 

    Summary of Workshop:

    The Data Modeler's Most Valuable Construct:  Subtypes & Supertypes

    S/Stypes offer a means to formally represent overlapping entity/object populations at the very beginning of the design process. If you are not using S/Stypes in your data modeling, or want to deepen your understanding of these constructs, this session is for you. Knowledge and use of subtypes/supertypes should be in every data modeler's toolkit.

    What Was Learned:

    • “Abstractions” v. Collections  v. Generalization
    • Attribute, Relationship & Entity Generalization
    • Subtypes and Supertypes (Entity Generalization)
    •      -Underlying assumptions; conditions
    •      -Generalizations vs. Specialization
    •      -Diagramming – Graphical Representations
    • Subtype / Supertype Constraints
    • Subtype Definition – distinguishing attribute
    • Sub/Supertype Hierarchy / Partial Lattice
    •      -The Universal Relation
    • Inheritance (single; multiple) & Reuse
    • Comparison of Modeling Schemes
    • Mapping to (Relational) Tables
    • Benefits of Subtype / Supertype

    Last modified: November 11, 2016 2:34 PM | Anonymous member (Administrator)

© DAMA Puget Sound 2013

Powered by Wild Apricot Membership Software