News for hackers. Stuff that matters.
Re:Clever ideas that failed by raphar on Tuesday September 22, 2009 @02:42PM (#837615)
Hey what a coincidence! I dunno why he failed with the 4th one.

We maintain a leasing administration system here, and one of the most important/critical features is doing the thing he describes. You can know the exact state of any leasing contract (or a group, or all of them) by chosing a date of the future and past. That way you can compare the expected result vs reality. It is implemented fully inside a SQL DBMS (and works fine)....

Re:Clever ideas that failed by akeefer on Tuesday September 22, 2009 @04:07PM (#837802)
Yeah, that bit made me cringe a bit too, since you have to do the something similar for storing insurance policies (track when things become effective, including forward-dated changes, storing past versions, etc.). No predictions necessary in our case. I'm guessing dealing with the time dimension is a general property of any system that needs to store anything that qualifies as a legal contract.

It is true, however, that adding in that time dimension makes everything a much, much harder problem.