I had an interview with Boeing, and found out that they did work with Sybase to develop some DB extensions for just that purpose. I think they license them out, but that's not going to work well with your FOSS desires. Postgres seems to have extensions to allow temporal work - check here. http://pgfoundry.org/projects/temporal/