Automatic method of generating decision cubes from cross dependent data sets
Systems and methods are directed to oil and gas management. In example implementations, data relating to oil and gas management is aggregated and placed in a cube along several cube dimensions, which can include scalar, temporal and spatial dimensions. The dimensions can be structured as a hierarchy, such that output can be generated as a roll up or roll down along the hierarchy.
1. A method, comprising:
identifying one or more processes related to oil and gas management from managed rig systems;
mapping at least one of stream and database data to the one or more processes related to oil and gas management;
identifying one or more attributes for the one or processes related to the oil and gas management;
incorporating the one or more attributes into a decision cube comprising at least a scalar dimension, a spatial dimension, and a temporal dimension;
applying one or more class functions on the at least the scalar dimension, the spatial dimension, and the temporal dimension of the decision cube;
generating key performance indicators related to the oil and gas management from the applying of the one or more class functions on the at least the scalar dimension, the spatial dimension, and the temporal dimension of the decision cube, the generating key performance indicators comprising generating an instance of the decision cube Configured to facilitate at least one of roll-up, roll-down, or online analytical processing (OLAP) operations on the one or more attributes incorporated into the decision cube.
2. The method of claim 1 , wherein each of the at least the scalar dimension, the spatial dimension, and the temporal dimension comprises a corresponding hierarchy representation; wherein the applying of the one or more class functions on the at least the scalar dimension, the spatial dimension, and the temporal dimension is conducted based on the corresponding hierarchy representation.
3. The method of claim 2 , wherein generating the key performance indicators comprises displaying output across at least one of at least the scalar dimension, the spatial dimension, and the temporal dimension of the cube from the applying the one or more class functions on a level selected from the corresponding hierarchy representation.
4. The method of claim 1 , wherein the at least one of the stream and the database data is obtained from one or more wellsites.
5. The method of claim 1 , wherein the one or more class functions comprise scalar functions, spatial functions and temporal functions, wherein each of the one or more attributes is assigned a category of one of a scalar category, a spatial category, and a temporal category; and wherein the applying the one or more class functions comprises:
applying the scalar functions to the one or more attributes in the scalar category;
applying the spatial functions to the one or more attributes in the spatial category; and
applying the temporal functions to the one or more attributes in the temporal category.
6. A non-transitory computer readable medium, storing instructions for executing a process, the instructions when executed by a processor causes the processor to perform the steps comprising:
identifying one or more processes related to oil and gas management from managed rig systems;
mapping at least one of stream and database data to one or more processes related to oil and gas management;
identifying one or more attributes for the one or processes related to the oil and gas management;
incorporating the one or more attributes into a decision cube comprising at least a scalar dimension, a spatial dimension, and a temporal dimension;
applying one or more class functions on the at least the scalar dimension, the spatial dimension, and the temporal dimension of the decision cube; and
generating key performance indicators related to the oil and gas management from the applying of the one or more class functions on the at least the scalar dimension, the spatial dimension, and the temporal dimension of the decision cube, the generating key performance indicators comprising generating an instance of the decision cube configured to facilitate at least one of roll-up, roll-down, or online analytical processing (OLAP) operations on the one or more attributes incorporated into the decision cube.
7. The non-transitory computer readable medium of claim 6 , wherein each of the at least the scalar dimension, the spatial dimension, and the temporal dimension comprises a corresponding hierarchy representation; wherein the applying of the one or more class functions on the at least the scalar dimension, the spatial dimension, and the temporal dimension is conducted based on the corresponding hierarchy representation.
8. The non-transitory computer readable medium of claim 7 , wherein generating the key performance indicators comprises displaying output across at least one of at least the scalar dimension, the spatial dimension, and the temporal dimension of the cube from the applying the one or more class functions on a level selected from the corresponding hierarchy representation.
9. The non-transitory computer readable medium of claim 6 , wherein the stream or the database data is obtained from one or more wellsites.
10. The non-transitory computer readable medium of claim 6 , wherein the one or more class functions comprise scalar functions, spatial functions and temporal functions, wherein each of the one or more attributes is assigned a category of one of a scalar category, a spatial category, and a temporal category; and wherein the applying the one or more class functions comprises:
applying the scalar functions to the one or more attributes in the scalar category;
applying the spatial functions to the one or more attributes in the spatial category; and
applying the temporal functions to the one or more attributes in the temporal category.
11. A management server, comprising:
a memory configured to manage cube management information to facilitate a cube and one or more processes related to oil and gas management from rig systems managed by the management server; and
a processor, configured to:
map at least one of stream and database data to the one or more processes related to oil and gas management;
identify one or more attributes for the one or processes related to the oil and gas management;
incorporate the one or more attributes into the decision cube comprising dimensions of at least a scalar dimension, a spatial dimension, and a temporal dimension;
apply one or more class functions on the at least the scalar dimension, the spatial dimension, and the temporal dimension of the decision cube; and
generate key performance indicators related to the oil and gas management from the application of the one or more class functions on the at least the scalar dimension, the spatial dimension, and the temporal dimension of the cube through a generation of an instance of the decision cube configured to facilitate at least one of roll-up, roll-down, or online analytical processing (OLAP) operations on the one or more attributes incorporated into the decision cube.
12. The management server of claim 11 , wherein each of the at least the scalar dimension, the spatial dimension, and the temporal dimension comprises a corresponding hierarchy representation; wherein the processor is configured to apply the one or more class functions on the at least the scalar dimension, the spatial dimension, and the temporal dimension is conducted based on the corresponding hierarchy representation.
13. The management server of claim 12 , wherein the processor is configured to generate the key performance indicators from displaying output across at least one of at least the scalar dimension, the spatial dimension, and the temporal dimension of the cube from the applying the one or more class functions on a level selected from the corresponding hierarchy representation.
14. The management server of claim 11 , wherein the processor is configured to obtain the stream or the database data from one or more wellsites.
15. The management server of claim 11 , wherein the one or more class functions comprise scalar functions, spatial functions and temporal functions, wherein each of the one or more attributes is assigned a category of one of a scalar category, a spatial category, and a temporal category; and wherein the processor is configured to apply the one or more class functions by:
applying the scalar functions to the one or more attributes in the scalar category;
applying the spatial functions to the one or more attributes in the spatial category; and
applying the temporal functions to the one or more attributes in the temporal category.