System and method for use of a dynamic flow in a multidimensional database environment
In accordance with an embodiment, described herein is a system and method for use of a dynamic flow process (referred to herein in some examples as Query Processing Dynamic Flow (QPDF)) in a multidimensional database computing environment. The dynamic flow process enables hybrid use of, for example, aggregate storage option, block storage option, or other types of storage containers, and provides a common flow to process a received input query in bottom-up mode. The approach can be used to reduce the size of the cube, which provides for efficient calculation of dynamic members.
1. A system for use of a dynamic flow in a multidimensional database environment, comprising:
a computing, including a processor;
a multidimensional database, for at least one of storage or analysis of data; and
wherein a dynamic flow process is operated, the dynamic flow process enabling processing of an input query and a hybrid use of at least one or more of block storage option, aggregate storage option, or other data storage container, said dynamic flow process including
expanding the input query;
based upon the expanded input query, defining a plurality of calculation units, determining one or more dependencies, and determining an order of calculation;
building a processing flow comprising the plurality of defined calculation units arranged in an order based upon the determined order of calculation; and
executing the processing flow to determine a response to the input query, wherein executing the processing flow includes executing each of the plurality of defined calculation units according to the determined order of calculation;
wherein the at least one or more of block storage option, aggregate storage option, or other data storage container provides an interface for reading data from the multidimensional database and providing data for aggregation and calculation by the dynamic flow process.
2. The system of claim 1 , wherein the dynamic flow process is a Query Processing Dynamic Flow (QPDF) that provides a common flow for querying both block storage option and aggregate storage option engines, to generate a response to the input query.
3. The system of claim 1 , wherein the dynamic flow process enables users to mark upper-level members as dynamic, for use during processing of the input query.
4. The system of claim 1 , wherein each defined calculation unit comprises a calculation process directed to an associated one of the block storage option, aggregate storage option, or other data storage container.
5. A method for use of a dynamic flow in a multidimensional database environment, comprising:
providing, at a computer system, a multidimensional database, for at least one of storage or analysis of data; and
operating a dynamic flow process that enables processing of an input query and a hybrid use of at least one or more of block storage option, aggregate storage option, or other data storage container, said dynamic flow process including
expanding the input query;
based upon the expanded input query, defining a plurality of calculation units, determining one or more dependencies, and determining an order of calculation;
building a processing flow comprising the plurality of defined calculation units arranged in an order based upon the determined order of calculation; and
executing the flow processing to determine a response to the input query, wherein executing the processing flow includes executing each of the plurality of defined calculation units according to the determined order of calculation;
wherein the at least one or more of block storage option, aggregate storage option, or other data storage container provides an interface for reading data from the multidimensional database and providing data for aggregation and calculation by the dynamic flow process.
6. The method of claim 5 , wherein the dynamic flow process is a Query Processing Dynamic Flow (QPDF) that provides a common flow for querying both block storage option and aggregate storage option engines, to generate a response to the input query.
7. The method of claim 5 , wherein the dynamic flow process enables users to mark upper-level members as dynamic, for use during processing of the input query.
8. The method of claim 5 , wherein each defined calculation unit comprises a calculation process directed to an associated one of the block storage option, aggregate storage option, or other data storage container.
9. A non-transitory computer readable storage medium, including instructions stored thereon which when read and executed by one or more computers cause the one or more computers to perform the method comprising:
providing, at a computer system, a multidimensional database, for at least one of storage or analysis of data; and
operating a dynamic flow process that enables processing of an input query and a hybrid use of at least one or more of block storage option, aggregate storage option, or other data storage container, said dynamic flow process including
expanding the input query;
based upon the expanded input query, defining a plurality of calculation units, determining one or more dependencies, and determining an order of calculation;
building a processing flow comprising the plurality of defined calculation units arranged in an order based upon the determined order of calculation; and
executing the flow processing to determine a response to the input query, wherein executing the processing flow includes executing each of the plurality of defined calculation units according to the determined order of calculation;
wherein the at least one or more of block storage option, aggregate storage option, or other data storage container provides an interface for reading data from the multidimensional database and providing data for aggregation and calculation by the dynamic flow process.
10. The non-transitory computer readable storage medium of claim 9 , wherein the dynamic flow process is a Query Processing Dynamic Flow (QPDF) that provides a common flow for querying both block storage option and aggregate storage option engines, to generate a response to the input query.
11. The non-transitory computer readable storage medium of claim 9 , wherein the dynamic flow process enables users to mark upper-level members as dynamic, for use during processing of the input query.
12. The non-transitory computer readable storage medium of claim 9 , wherein each defined calculation unit comprises a calculation process directed to an associated one of the block storage option, aggregate storage option, or other data storage container.