System and method for metadata sandboxing and what-if analysis in a multidimensional database environment
AssigneeOracle International Corporation
InventorKumar Ramaiyer
Life of this patent
Estimating the term…
Abstract
In accordance with an embodiment, described herein are systems and methods for supporting metadata sandboxing and what-if analysis in a multidimensional database, comprising. A system allow for various iterations of “what-if” analysis that allows users and administrators to test various situations and changing metadata relationships between data dimensions without altering a primary copy of the hierarchical data structure.
Claims20
A system for supporting metadata sandboxing and what-if analysis in a multidimensional database, comprising:
- a computer that includes one or more microprocessors;
- a multidimensional database server executing on the computer, wherein the multidimensional database server supports a hierarchical structure of a plurality data dimensions with a primary database;
- wherein a plurality of metadata relationships are provided between each of the plurality of data dimensions;
- wherein a request is received at the multidimensional database server to perform one or more changes to the hierarchical structure of a plurality data dimensions within a sandbox database;
- wherein, upon receiving the request, a copy of the hierarchical data structure of the plurality of data dimensions is made and placed into the sandbox database, the sandbox database being supported by the multidimensional database server;
- wherein upon the copy of the hierarchical data structure of the plurality of data dimensions being placed into a metadata sandbox, altering a metadata relationship of the plurality of metadata relationships between at least two of the plurality of data dimensions according to a received user input.
A method for supporting metadata sandboxing and what-if analysis in a multidimensional database, comprising:
- providing, at computer that includes one or more microprocessors, a multidimensional database server executing on the computer, wherein the multidimensional database server supports a hierarchical structure of a plurality data dimensions with a primary database;
- providing a plurality of metadata relationships between each of the plurality of data dimensions;
- receiving a request at the multidimensional database server to perform one or more changes to the hierarchical structure of a plurality data dimensions within a sandbox database;
- upon receiving the request, generating a copy of the hierarchical data structure of the plurality of data dimensions;
- placing the generated copy of the hierarchical data structure of the plurality of data dimensions into the sandbox database, the sandbox database being supported by the multidimensional database server;
- upon the copy of the hierarchical data structure of the plurality of data dimensions being placed into a metadata sandbox, altering a metadata relationship of the plurality of metadata relationships between at least two of the plurality of data dimensions according to a received user input.
A non-transitory computer readable storage medium having instructions thereon for supporting metadata sandboxing and what-if analysis in a multidimensional database, which when read and executed cause a computer to perform steps comprising:
- providing, at computer that includes one or more microprocessors, a multidimensional database server executing on the computer, wherein the multidimensional database server supports a hierarchical structure of a plurality data dimensions with a primary database;
- providing a plurality of metadata relationships between each of the plurality of data dimensions;
- receiving a request at the multidimensional database server to perform one or more changes to the hierarchical structure of a plurality data dimensions within a sandbox database;
- upon receiving the request, generating a copy of the hierarchical data structure of the plurality of data dimensions;
- placing the generated copy of the hierarchical data structure of the plurality of data dimensions into the sandbox database, the sandbox database being supported by the multidimensional database server;
- upon the copy of the hierarchical data structure of the plurality of data dimensions being placed into a metadata sandbox, altering a metadata relationship of the plurality of metadata relationships between at least two of the plurality of data dimensions according to a received user input.
Dependencies are inferred from the claim text.