Blog Timeline Full Width

  • How should project teams use the Enterprise Data Model?

    There is a team of data architects that have been working on a logical enterprise data model (EDM) for three months, and the EDM is estimated to be 40% complete. Many projects are underway that can benefit from the EDM, yet the architects are divided as...

    Read more
    1
    Steve Hoberman
  • Having the same primary key in two or more logical entities

    You are a data modeler designing a data mart, and have come across at least two different entities on your logical data model that happen to have the same primary key. On your physical data model, would you keep them in separate tables or merge them...

    Read more
    0
    Steve Hoberman
  • Create a logical data model?

    You are a data modeler creating the design for a non-relational database. “Non-relational” means the underlying database does not follow relational database theory – for instance the database could be hierarchical or object oriented. It is even possible that the underlying structure will be a set...

    Read more
    0
    Steve Hoberman
  • Convincing project teams of the need to normalize

    In our last design challenge we agreed that we should normalize regardless of database platform, and we discussed a number of benefits the normalized design can offer. Some of these benefits are longer term and have broader scope than the current project to which you are...

    Read more
    0
    Steve Hoberman
  • Techniques in reviewing a data model

    There are a number of techniques I apply when I review a data model. Using these techniques over the years helped me quickly summarize models and look for ways to improve them. Many times the 80/20 rule seems to prevail when reviewing a model. That is,...

    Read more
    0
    Steve Hoberman