Methods and systems for data aggregation and reporting

• US 9,811,553 B2
• Filed: 03/11/2011
• Issued: 11/07/2017
• Est. Priority Date: 03/11/2010
• Status: Active Grant

• Current Assignee: Entegrity LLC
• Original Assignee: Entegrity LLC
• Inventors: Hill, David Gordon
• Primary Examiner(s): Nguyen, Laura
• Application Number:
  US13/046,352
• Publication Number:
  US 20110227754A1
• Time in Patent Office: 2,433 Days
• Field of Search: 34087001-87003, 34087005, 702 61- 62, 37910603
• CPC Class Codes: G06F 16/244 Grouping and aggregation
• CPC Class Codes: G06F 16/24556 Aggregation; Duplicate elimination
• CPC Class Codes: G06Q 50/06 Energy or water supply

Abstract

The present application is generally directed to mediums, methods, and systems for providing a data aggregator and reporting engine for utilities data. Exemplary embodiments provide procedures for aggregating and reporting data. According to exemplary embodiments, a base configuration for a data aggregator is provided. A variety of characteristics and functionality are built into the base configuration of the aggregator. Each characteristic may include a plurality of built-in options. By selecting one or more relevant options for each characteristic, a utility provider can build an aggregator that applies a custom profile to aggregate and report utilities data. The options may be selected prior to run-time, or may be selected at run-time. A dynamic reporting framework is also provided. The dynamic reporting framework allows for data aggregations to be calculated during the aggregation process without requiring that either the aggregator or the reporting framework be rebuilt or redesigned.

Claims

1. A non-transitory electronic device readable storage medium storing instructions for aggregating and reporting data, the instructions when executed causing one or more processors to:

provide a customizable aggregator for retrieving and analyzing the data, the aggregator being deployed in a base configuration that is not customized for any utility provider;

receive a plurality of settings at the aggregator, each setting accepting one or more values, the plurality of settings together describing a configuration of the aggregator, wherein the aggregator accepts different values for the settings to generate different configurations;

configure the aggregator by providing one or more values for one or more of the settings to customize the aggregator for a specified utility provider, the values representing input data that defines a manner in which the aggregator aggregates the data and corresponding to a set of aggregation requirements of the specified utility provider wherein the settings specify how transmission losses are calculated for the specified utility provider and specify an identity of a market for which aggregation is being performed;

access the data;

aggregate the data to summarize the data, combine the data into a new representation, draw a conclusion from the data, or collect related data,

wherein the aggregating is based on one or more of the provided values such that the aggregator is configurable into the different configurations without providing additional code for the aggregator beyond the base configuration; and

generate a report summarizing the aggregated data, wherein the report is generated based on one or more of the provided values.

2. The medium of claim 1, wherein configuring the aggregator further comprises retrieving the one or more settings from one or more database tables.

3. The medium of claim 2, wherein generating a report further comprises retrieving the one or more settings from the one or more database tables.

4. The medium of claim 1, wherein the data aggregation is calculated without rebuilding the aggregator after configuring the aggregator.

5. The medium of claim 1, further comprising instructions for providing a dynamic reporting framework for generating the report.

6. The medium of claim 5, wherein the data aggregation is calculated and the report is generated without rebuilding the dynamic reporting framework after configuring the aggregator.

7. The medium of claim 1, wherein data available to the aggregator determines one or more reporting options for generating the report.

8. The medium of claim 1, wherein the data is aggregated during an aggregation run, and the aggregator is configured at a run-time of the aggregation run.

9. The medium of claim 1, wherein the settings comprise one or more of a retailer identity, a distribution company, a meter type, a weather sensitivity, a weather zone, a profile type, a TOU type, a loss class, location information, and campaign information.

10. The medium of claim 1, wherein the values for the settings are retrieved from one or more database tables that store variables and characteristics used during a data aggregation process.

11. The medium of claim 1, wherein the data is loaded into a memory of the aggregator prior to aggregating the data.

12. An electronic device implemented method comprising:

providing a customizable aggregator for retrieving and analyzing data, the aggregator being deployed in a base configuration that is not customized for any utility providers;

receiving a plurality of settings at the aggregator, each setting accepting one or more values, the plurality of settings together describing a configuration of the aggregator, wherein the aggregator accepts different values for the settings to generate different configurations;

configuring the aggregator by providing one or more values for one or more of the settings to customize the aggregator for a specified utility provider, the values representing input data that defines a manner in which the aggregator aggregates the data and corresponding to a set of aggregation requirements for the specified utility provider wherein the settings specify how transmission losses are calculated for the specified utility provider and specify an identity of a market for which aggregation is being performed;

accessing the data;

aggregating the data to summarize the data, combine the data into a new representation, draw a conclusion from the data, or collect related data,

wherein the aggregating is based on one or more of the provided values such that the aggregator is configurable into the different configurations without providing additional code for the aggregator beyond the base configuration; and

generating a report summarizing the aggregated data, wherein the report is generated based on one or more of the provided values.

13. The method of claim 12, further comprising providing a dynamic reporting framework for generating the report, wherein the data aggregation is calculated and the report is generated without rebuilding the dynamic reporting framework after configuring the aggregator.

14. A system comprising:

a storage for storing data; and

a processor for;

providing a customizable aggregator for retrieving and analyzing the data, the aggregator being deployed in a base configuration that is not customized for any utility providers;

receiving a plurality of settings at the aggregator, each setting accepting one or more values, the plurality of settings together describing a configuration of the aggregator, wherein the aggregator accepts different values for the settings to generate different configurations;

configuring the aggregator by providing one or more values for one or more of the settings to customize the aggregator for a specified utility provider, the values representing input data that defines a manner in which the aggregator aggregates the data and corresponding to aggregation requirements of the specified utility provider wherein the settings specify how transmission losses are calculated for the specified utility provider and specify an identity of a market for which aggregation is being performed;

accessing the data;

aggregating the data to summarize the data, combine the data into a new representation, draw a conclusion from the data, or collect related data,

wherein the aggregating is based on one or more of the provided values such that the aggregator is configurable into the different configurations without providing additional code for the aggregator beyond the base configuration; and

generating a report summarizing the aggregated data, wherein the report is generated based on one or more of the provided values.

15. The system of claim 14, wherein the processor further provides a dynamic reporting framework for generating the report, wherein the data aggregation is calculated and the report is generated without rebuilding the dynamic reporting framework after configuring the aggregator.