Blog Timeline Full Width

  • 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
  • Where does XML fit?

    I have been working on the 2nd Edition of Data Modeling Made Simple, and the last chapter addresses several new challenges including this one on XML: Here is a subset of a recipe XML document: <recipe name=”bread”> <ingredient amount=”4″ unit=”cup”>Flour</ingredient> <ingredient amount=”10″ unit=”tablespoons”>Yeast</ingredient> <ingredient amount=”2″ unit=”...

    Read more
    0
    Steve Hoberman
  • Recycle, Reduce, Reuse

    The model below is an example of an Event and Event Line concept, a familiar structure in many of our organizations. Each of these entities contains data elements that are not shown on this model as well as other relationships that are not shown such as...

    Read more
    0
    Steve Hoberman