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 computer, including a processor;
a multidimensional database, for at least one of storage or analysis of data;
a storage container that acts as an interface between a data source and the multidimensional database; and
a data buffer of the multidimensional database environment comprising a plurality of buckets;
wherein the system executes a dynamic flow process that operates to
receive an input query for processing against the multidimensional database,
expand the input query to determine calculated data,
determine dependencies and an order of calculation by analyzing the expanded input query,
divide the expanded input query into defined calculation units according to the determined order of calculation,
build an executable flow comprising the defined calculation units connected in an order based on the determined order of calculation,
execute the executable flow, to determine a response to the input query, and
populate a database cube based on the determined response to the input query.
2. The system of claim 1 , wherein the system further operates to place each calculation unit of the plurality of calculation units in a corresponding bucket of the data buffer.
3. 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 determine the response to the input query.
4. 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.
5. A method for use of a dynamic flow in a multidimensional database environment, comprising:
providing, at a computer system including a processor, a multidimensional database for at least one of storage or analysis of data, a storage container that acts as an interface between a data source and the multidimensional database, and a data buffer comprising a plurality of buckets; and
executing a dynamic flow process, including the steps of:
receiving an input query for processing against the multidimensional database;
expanding the input query to determine calculated data;
determining dependencies and an order of calculation by analyzing the expanded input query;
dividing the calculation expanded input query into defined calculation units according to the determined order of calculation;
building an executable flow comprising the defined calculation units connected in an order based on the determined order of calculation;
executing the executable flow, to determine a response to the input query; and
populating a database cube based on the determined response to the input query.
6. The method of claim 5 , further comprising:
placing each calculation unit of the plurality of calculation units in a corresponding bucket of the data buffer.
7. 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 determine the response to the input query.
8. 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.
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 including a processor, a multidimensional database for at least one of storage or analysis of data, a storage container that acts as an interface between a data source and the multidimensional database, and a data buffer comprising a plurality of buckets; and
executing a dynamic flow process, including the steps of
receiving an input query for processing against the multidimensional database;
expanding the input query to determine calculated data;
determining dependencies and an order of calculation by analyzing the expanded input query;
dividing the expanded input query into defined calculation units according to the determined order of calculation;
building an executable flow comprising the defined calculation units connected in an order based on the determined order of calculation;
executing the executable flow, to determine a response to the input query; and
populating a database cube based on the determined response to the input query.
10. The non-transitory computer readable storage medium of claim 9 , further comprising:
placing each calculation unit of the plurality of calculation units in a corresponding bucket of the data buffer.
11. 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 determine the response to the input query.
12. 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.