Archives for August 4, 2009

Ozymandias

by Percy Bysshe Shelley I met a traveler from an antique landWho said: Two vast and trunkless legs of stoneStand in the desert. Near them, on the sand,Half sunk, a shattered visage lies, whose frown,And wrinkled lip, and sneer of cold command,Tell that its sculptor well those passions readWhich yet survive, stamped on these lifeless things,The hand that mocked them and the heart that fed;And on the pedestal these words appear:"My name is Ozymandias, king of kings:Look on my works, ye Mighty, and despair!"Nothing beside remains. Round the decayOf that colossal wreck, … [Read more...]

Bitemporal Data

Any IT pro with more than a year or two of experience will have faced the challenges of version control for an application, but what if you have to implement version control for data? The most common way to tackle this problem is implementing something called "bitemporal data". Under this method, each row in a table includes the current valid time and the transaction time. Since two distinct time values are stored, we get the term bitemporal. A great place to start is Adam Machanic's excellent article at … [Read more...]