You can use it for "what if" analysis.
- Take a fork of the database
- Transform data in the fork. i.e. costs+5%
- Point your current queries to run on the fork
You can see how with just the effort repointing queries a reporting app could show the real world and the world you are modelling.
That’s helpful, maybe I’m naive but isn’t that like an Excel workload? I haven’t seen scenarios where the entire database needs that kind of functionality. Can you elaborate on what kind of data and business problem one would be working on where they need that level of robust versioning?
You can see how with just the effort repointing queries a reporting app could show the real world and the world you are modelling.