Blogs

  • Getting physical with subtypes

    Subtyping is a powerful communication tool on the logical data model, because it allows the modeler to represent the...

    Read more
    0
    Steve Hoberman
  • Creative hierarchy

    An organization has a sales department with four levels, as shown in the following logical data model: Zones are...

    Read more
    0
    Steve Hoberman
  • Definition Differences

    Your coworker calls you in the middle of the night with a data modeling emergency. There needs to be...

    Read more
    0
    Steve Hoberman
  • Super Star

    A star schema is designed to efficiently answer metric business questions, such as those questions that return amounts, quantities,...

    Read more
    0
    Steve Hoberman
  • Rules on rules

    A logical data model represents a business solution independent of technology, including the business rules. For example, the rule,...

    Read more
    0
    Steve Hoberman
  • Data Dictionary, are you out there?

    A global manufacturing company needs a data dictionary to assist them with maintaining and publishing definitions of business concepts...

    Read more
    0
    Steve Hoberman
  • 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