Blog Timeline Full Width

  • Blockchain on Data Modeling

    I am talking about the impact of blockchain on data modeling for an upcoming ER/Studio Webinar, and here are a few of the impacts I think we will face: Herding cats. If you have the word “data” or “analyst” in your job title, no doubt at...

    Read more
    0
    Steve Hoberman
  • Data Model Size

    There is a project manager looking to estimate development and support tasks based on the number of entities on the physical data model. How many entities would you think characterize a small, medium, and large data model?

    Read more
    0
    Steve Hoberman
  • Foreign key on a logical data model?

    I often get into passionate discussions with data modelers on whether a logical data model (LDM) should contain foreign keys. Those that believe an LDM should not include foreign keys explain foreign keys are relational database constructs and therefore should appear on the physical only. Those that...

    Read more
    0
    Steve Hoberman
  • Tips to spot subtypes and supertypes

    Adding supertypes and subtypes to your logical data model (LDM) helps improve communication, enforce additional rules, and organize thought. Sometimes however, it is not always apparent where to add a supertype to store the common attributes and relationships of subtypes, or where to add subtypes to...

    Read more
    0
    Steve Hoberman
  • Experience with the data vault

    The data vault is a data warehouse design structure which varies from traditional data warehouse architecture in several ways including the practice of separating the “thing” from how this thing changes over time. For example, there is something about a Customer that could never change over time,...

    Read more
    0
    Steve Hoberman