Blog Timeline Full Width

  • PDM = Implementation?

    Does your organization distinguish a “physical data model” from an “implementation data model”? In other words, is the physical data model (PDM for short) a model of “what” the design should look like, and the implementation data model is a model of “how” this design should...

    Read more
    0
    Steve Hoberman
  • A Party for Vanishing Definitions

    You are in the midst of building the underlying data model to support a large business intelligence project. This type of data model goes by many names (such as a corporate data model or enterprise data model), and crosses departments and broad functional areas. There is...

    Read more
    1
    Steve Hoberman
  • A surrogate key without an alternate key, can it be?

    A surrogate key is a unique identifier for a table, often a simple counter created by developers or database administrators. In my classes, I strongly recommend tagging what the “real” primary key is in the table – that is, the one that a business professional would...

    Read more
    0
    Steve Hoberman
  • What decade is this quote from?

    One of the most important books in our field is William Kent’s, Data and Reality, which was published back in….well a long time ago. Technics Publications has the honor of republishing this book, and I have updated this 3rd edition with my commentary. Graeme Simsion has...

    Read more
    0
    Steve Hoberman
  • Batman vs the Evil Definitions

    Batman once said, “It’s not who I am underneath, but what I do that defines me.” Can we apply this same reasoning when defining key terms on our data models? It can be a daunting task to define a simple term such as “Customer”, but it...

    Read more
    0
    Steve Hoberman