Home Forums Database Design Design Ideas and Questions Temporal SQL Server Databases RE: Temporal SQL Server Databases

  • October 20, 2014 at 8:53 am

    #1753523

    Ian Massi (10/20/2014)

    I've added effective dates to one of the fact tables in my data warehouse to allow reporting using different points in time. The application that generates the data for this only deals with history in a limited way, but I could see how an off the shelf solution to handle temporal stuff cleanly would easily be worth many developer-hours.

    I guess I don't understand the problems people are having with temporal data. Type 2 SCDs are easy to setup, implement, and use. As with certain COTS automated testing systems, I wonder if the cure might be worse that the original problem. Even hierarchical data is fairly easy to query for Point-In-Time results using Type 2 SCDs.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)