-2

I vaguely remember reading a blog entry (written by a well-known blogger I think) about how to model price changes over time, and that you could model most changes by saving two dates only (two columns in a db). The blog talked about prices on a website changing over time and how you could figure out the right price to charge knowing only when the purchase had been made.

Very vague, I know, but my google-fu is failing me, everyone at IRC are busy talking about other stuff and I don't know what to do! :)

Charles Sprayberry
  • 7,741
  • 3
  • 41
  • 50
Alexander Torstling
  • 18,552
  • 7
  • 62
  • 74

1 Answers1

1

I figured out that i meant Patterns for things that change with time by Martin Fowler, but more generally about Bitemporal data.

Paul
  • 6,572
  • 2
  • 39
  • 51
Alexander Torstling
  • 18,552
  • 7
  • 62
  • 74
  • The Martin Fowler piece is a neat summary of all the issues. I could have done with this last summer, to settle a long-running argument, er, design discussion. – APC May 12 '10 at 13:13