SYSTEM AND METHOD FOR SANDBOXING SUPPORT IN A MULTIDIMENSIONAL DATABASE ENVIRONMENT

摘要

In accordance with an embodiment, described herein is a system and method for providing sandboxing support in a multidimensional database environment. A plurality of sandboxes and a baseline data can be provided in a multidimensional database server, with each sandbox created for a particular “what-if” analysis, and configured to store one or more changes to the baseline data. When a request is received for a report on a particular “what-if” analysis from a client/user, the multidimensional database server can split the request into a first query and the second query, with the first query directed to a sandbox associated with the client/user, and the second query directed to the baseline data. The multidimensional database server can merge results from the first query and the second query, and perform aggregations and calculations on the merged data, before sending the merged data to a client.

主权项

1. A system for providing sandboxing support in a multidimensional database environment, comprising:
a computer that includes one or more microprocessors; a multidimensional database server executing on the computer, wherein the multidimensional database server includes a baseline data, and a plurality of sandboxes, wherein each sandbox is associated with a user, and stores one or more changes to the baseline data; a query processor in the multidimensional database server, wherein the query processor is configured to
split a query received from a user into a first query and a second query,direct the first query to the baseline data, and the second query to a sandbox associated with the user,merge results from the first query and the second query, andreturn the merged data to the user.