Monthly Archive for: ‘July, 2011’

  • shadowManaging Bitemporal Data
    image
    shadow

    Managing Bitemporal Data

    In this post, Data Education founder and trainer Adam Machanic discusses how to manage bitemporal data. Here, he explains that because data isn’t always straightforward, it’s important to update it very carefully. A central truth that we need to embrace to be successful as database …

    Read More

  • shadowTime Intervals in SQL Server: Part 2
    image
    shadow

    Time Intervals in SQL Server: Part 2

    In Part 1 of this post, Machanic discussed modeling and querying continuous intervals. In this second part, he discusses independent intervals. He explains that both gaps and overlaps can be represented. As mentioned previously, modeling intervals as a start time/end time combination may make more …

    Read More

  • shadowTime Intervals in SQL Server: Part 1
    image
    shadow

    Time Intervals in SQL Server: Part 1

    Given the commonality of the requirement in virtually every possible application to store temporal data, it’s surprising how involved a discussion of techniques for dealing with the data can become. Depending on the business requirements, systems may need to be able to deal with users …

    Read More