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.