Storing and querying alternate scenarios of data in a database

A non-transitory computer readable storage medium storing instructions that when executed by one or more computer processors, cause the one or more computer processors to performs steps for managing alternate scenarios in a database, the steps comprising:

• storing a source dataset comprising a set of documents in a document database of a production system, each document storing values of a set of fields;
• receiving an alternate scenario specification comprising instructions for determining alternate values for at least a subset of fields of a subset of documents;
• determining an alternate dataset comprising values of the subset of fields for the subset of documents according to the alternate scenario specification, wherein the source dataset includes values of the subset of fields of the subset of documents that are updated based on requests received by the production system independent of the alternate dataset;
• receiving a request for executing a database query using the alternate scenario specification;
• executing the database query to determine a result set by combining data from the alternate dataset with data from the source dataset, wherein values of the subset of fields for the subset of documents are obtained from the alternate dataset and remaining data used for determining the result set is obtained from the source dataset;
• and
• sending the result set as a response to the request.

A computer system comprising:

• one or more computer processors;
• and
• a non-transitory computer readable storage medium storing instructions that when executed by one or more computer processors, cause the one or more computer processors to performs steps for managing alternate scenarios in a database, the steps comprising:
• storing a source dataset comprising a set of documents in a document database of a production system, each document storing values of a set of fields;
• receiving an alternate scenario specification comprising instructions for determining alternate values for at least a subset of fields of a subset of documents;
• determining an alternate dataset comprising values of the subset of fields for the subset of documents according to the alternate scenario specification, wherein the source dataset includes values of the subset of fields of the subset of documents that are updated based on requests received by the production system independent of the alternate dataset;
• receiving a request for executing a database query using the alternate scenario specification;
• executing the database query to determine a result set by combining data from the alternate dataset with data from the source dataset, wherein values of the subset of fields for the subset of documents are obtained from the alternate dataset and remaining data used for determining the result set is obtained from the source dataset;
• and
• sending the result set as a response to the request.