Blogs

  • Null AK?

    An Alternate Key (AK) is a unique identifier for an entity instance that has not been selected as the...

    Read more
    0
    Steve Hoberman
  • Broken shells

    A great way to sharpen our analysis and modeling skills is to continuously address real-world scenarios. A modeling scenario...

    Read more
    0
    Steve Hoberman
  • Recursive fact table?

    To better understand the requirements for an analytics data mart, you and a business user are standing at the...

    Read more
    0
    Steve Hoberman
  • A Dimensional EDM

    One day a colleague asks you for feedback on an enterprise data model (EDM) she has been tasked with...

    Read more
    0
    Steve Hoberman
  • Thinking Data

    I was teaching a data modeling class a few weeks back, and we were in the middle of building...

    Read more
    0
    Steve Hoberman
  • Timeless Dimensional Model

    When I teach dimensional modeling, I always stress the need for a time dimension. Recently in a session, a...

    Read more
    0
    Steve Hoberman
  • Subtype key

    A subtype inherits its primary key from its supertype. If the supertype is Party for example, we copy the...

    Read more
    0
    Steve Hoberman
  • Customer Id

    I was showing examples of both complete and incomplete definitions during a recent training class, when I shared the...

    Read more
    0
    Steve Hoberman
  • Ontology and Taxonomy

    Like many concepts in our field, Ontology and Taxonomy have more than one definition. In addition, these definitions can...

    Read more
    0
    Steve Hoberman
  • Product Availability

    An organization sells products in many countries. The logical data model below captures which product is available in which...

    Read more
    0
    Steve Hoberman