Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2008
    Posts
    8

    Temporal Databases

    Just wondering...

    Do any of you guys have experience implementing temporal databases?

    I'm trying to get the hang of it, and for my next project I want to go ahead and implement Valid Time and Transaction Time for all of my entities.

    The big headache I foresee right now is that neither of the DBMS's that I have experience with (MS SQL Server / MySQL) have any native support for the concept, so far as I know.

    So I'll have to meticulously impose all the temporal constraints on my own, table by table.

    I guess I'm just looking for general advice on common problems that come up when trying to design and implement a temporal schema.

    Much obliged for your wisdom.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    My method is to design the base schema without temporal dimensions, and then add an archive table for each base table.
    This script will create the archive tables for you.
    Attached Files Attached Files
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •