I'm exploring options for implementing a large-scale temporal database. There will likely be billions of records managed with minimal temporal churn, and I'd like a vendor implemented solution to avoid placing too much responsibility in the application(s) that will populate, update, and query the warehouse.
Oracle Workspace Manager is one potential solution I'm looking at, but I've gotten the impression from online research that OWM isn't practical for a production system. Does anyone have any experience with using OWM for a temporal database, in particular using the TSQL2 constructs?
Many thanks.