Dynamic Data Aggregation System for Energy Market Rule Adaptation

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Existing data management solutions in energy markets, such as bespoke and COTS systems, become obsolete due to frequent changes in market-specific rules and network configurations, leading to inaccuracies in data aggregation and processing.

Innovation Solution

A dynamic data aggregation system that allows for real-time modification of aggregation hierarchies and settlement points using a graphical interface, enabling configuration of market-specific rules and network changes without manual code updates, ensuring current data aggregation.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Measurement precision

If bespoke systems are custom developed according to exact market specifications, then the system accurately reflects market-specific rules at development time, but the system becomes obsolete when market rules or network configuration change

Engineering Contradiction:

Improveaccuracy of data aggregationVSAvoidadaptability to market rule changes

Core Design Contradiction:

Measurement precisionVSAdaptability or versatility

Solution Approach 1:

The patent implements dynamic configurability by allowing market participants to modify aggregation hierarchies, settlement points, and data characteristics through a graphical user interface without requiring custom code updates. This enables the system to adapt to changing market rules and network configurations in real-time, resolving the contradiction between initial accuracy and future adaptability

Inventive Principle:

Principle #15Dynamics

Solution Approach 2:

The system allows users to change parameters such as aggregation rules, settlement characteristics, and data characteristics by configuring them through the graphical interface. These parameter changes enable the system to maintain accuracy under new market conditions without becoming obsolete, addressing both the need for precision and adaptability

Inventive Principle:

Principle #35Parameter changes

2Productivity

If COTS solutions are configured for market-specific rules at installation time, then the system can process data according to established rules, but custom updates become labor intensive and slow when rules change

Engineering Contradiction:

Improvedata processing efficiencyVSAvoidtime for custom updates

Core Design Contradiction:

ProductivityVSLoss of time

Solution Approach 1:

The patent enables market participants to perform their own configuration updates through the graphical user interface without requiring vendor support or manual code edits. Users can independently modify aggregation hierarchies and settlement points, eliminating the need for labor-intensive custom updates and reducing time loss while maintaining productivity

Inventive Principle:

Principle #25Self-service

Solution Approach 2:

The system provides a universal graphical configuration interface that handles multiple market-specific rules and aggregation scenarios through a single platform. This multi-functional approach eliminates the need for separate custom development for each rule change, reducing update time while maintaining efficient data processing across different market conditions

Inventive Principle:

Principle #6Universality (Multi-functionality)

3Reliability

If manual edits of COTS solution code are performed to update market rules, then the system can reflect new rules, but the process becomes labor intensive and prone to inaccuracies

Engineering Contradiction:

Improveaccuracy of data aggregationVSAvoidease of system updates

Core Design Contradiction:

ReliabilityVSEase of manufacture

Solution Approach 1:

The patent replaces manual code editing (mechanical process) with a graphical user interface-based configuration system. Users interact with visual elements representing aggregation hierarchies and settlement points, eliminating the need for manual code edits and reducing both labor intensity and the risk of inaccuracies while maintaining reliability

Inventive Principle:

Principle #28Mechanics substitution (Replace mechanical system)

Solution Approach 2:

The graphical user interface acts as an intermediary between the user and the underlying data aggregation system. This intermediary layer translates user-friendly configuration actions into system updates, eliminating the need for direct code manipulation and reducing errors while maintaining ease of updates and data aggregation accuracy

Inventive Principle:

Principle #24Intermediary (Mediator)

Data Source

PatentUS11106699B2Computer system and method to update data aggregation configurations and control data aggregation

Publication Date: 2021.08.31 ORACLE INT CORP

AI summary

Systems, methods, and other embodiments associated with updating data aggregation configurations and controlling data aggregation are described. Illustratively, a hierarchy of nodes is generated and displayed in a graphical representation of an energy supply network. The nodes store energy consumption data, and are selectable to identify where aggregations of the energy consumption data are to be performed. A settlement point is created to define an aggregation of the energy consumption data based on at least data from a plurality of the nodes identified from the hierarchy. The created settlement includes one or more characteristics selected from the database. The aggregation of the energy consumption data according to the settlement point is executed and controlled, and an electronic report including the aggregated energy consumption data is generated.