Oracle Corporation
Flexible energy information aggregation

Abstract:

Systems, methods, and other embodiments associated with flexible aggregation of energy information are described. In one embodiment, a method includes receiving a request via a graphical user interface that comprises a plurality of selectable inputs that define the request. A plurality of energy dimensions are selected from a set of available energy dimensions, a plurality of combinations of the plurality of energy dimensions are determined, an energy bucket is generated for each combination of the plurality of energy dimensions, and the script is generated based upon the energy buckets. A target database is accessed on a remote target server, and the script is executed on the target database to initiate extraction of data that matches each energy bucket into a dynamic table in the target database, and run an energy option on the data extracted into the dynamic table.