Blog Timeline Full Width

  • My Hero Zero

    The Data Model Scorecard™ contains over 400 rules to apply when reviewing a data model. One of these rules requires justifying optionality on a relationship. For example, on this model We have these two business rules: Each Customer can place many Orders. Each Order must be...

    Read more
    0
    Steve Hoberman
  • Data becoming Metadata

    Last week at a holiday dinner, a friend of mine who is a partner at a large accounting firm shared with me this story: He asked someone to prepare an archive of all of the important documents produced this past year. After three weeks of work,...

    Read more
    0
    Steve Hoberman
  • Producing Adequate Definitions

    We know how important definitions are, yet we also know that definitions are often missing or of poor quality in data deliverables. Over the years I have used a number of techniques to ensure adequate definitions are present. For example, one technique is to write the...

    Read more
    0
    Steve Hoberman
  • Swimming in Rough Water

    I haven’t opened my bank statements since September, my favorite haunts are going out of business, and budgets have tightened to the point where last night the Tooth Fairy gave my six-year-old only a single dollar. These are exciting times. I find myself though continuing to...

    Read more
    0
    Steve Hoberman
  • Is Cost a Fact?

    The following logical dimensional model is built for a book publisher to track sales. There is a need to track sales by calendar, by book, and by location. Sales is the fact table and Calendar, Book, and Location are the dimensions. This model can answer questions...

    Read more
    0
    Steve Hoberman