In a risk regulatory framework, an analyst will be required to build models to assess credit, market, operational, or non-financial risk and submit the models to the regulator for approval. In such a scenario, the analyst will have to store the datasets that are so that regulators can recreate the results independently if needed on a static dataset. If the same analyst worked in the pharmaceutical clinical trial sector, there would be a similar need for preserving the datasets that were used.
But not all analysis needs to be scrutinized in a similar way or needs to be rerun on static databases. In a large car dealership, there might be a surge in orders that are booked at the end of the month, during a promotion, or before the financial year ends. Management might be interested in a report of daily sales figures. In this instance, the query would remain the...
