Graph Rule Normalization Engine for Data Quality

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

In resource management, data integration in databases is often inconsistent and incomplete, leading to complex connection maintenance issues and errors that impact data quality and applications utilizing this data, necessitating improved data quality through effective connection maintenance.

Innovation Solution

A computer system with a normalization engine that defines and applies graph rules to entities and relationships, identifying discrepancies and performing actions to update and correct them, ensuring clean graph models and improved data quality.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If manual browsing and correction of connection errors is performed, then connection maintenance can be achieved, but labor intensity and time consumption increase significantly

Engineering Contradiction:
Improveconnection maintenanceVSAvoidlabor intensive correction time
Core Design Contradiction:
ReliabilityVSLoss of time

Solution Approach 1:

The system enables self-service through automatic detection and correction of connection errors. The normalization engine autonomously identifies discrepancies in CI relationships and applies corrections without requiring manual intervention, allowing the system to maintain and improve itself automatically.

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

Manual mechanical browsing and correction processes are replaced with an automated computational system. The normalization engine uses algorithmic rules to detect and correct connection errors, substituting human labor with an automated information processing system that operates continuously and efficiently.

Inventive Principle:
Principle #28Mechanics substitution (Replace mechanical system)

2Quantity of substance

If data integration is performed from multiple discovery providers, then data completeness can be improved, but data consistency and quality deteriorate due to integration errors

Engineering Contradiction:
Improvedata completenessVSAvoiddata consistency
Core Design Contradiction:
Quantity of substanceVSReliability

Solution Approach 1:

The system changes the state of integrated data by applying normalization rules that modify inconsistent parameters. The normalization engine detects parameter discrepancies across data from multiple sources and transforms them into consistent states, ensuring data quality while maintaining completeness.

Inventive Principle:
Principle #35Parameter changes

Solution Approach 2:

The system implements feedback mechanisms where the normalization engine continuously monitors integrated data for consistency errors and automatically applies corrections. This closed-loop feedback process ensures that data from multiple discovery providers maintains both completeness and consistency through ongoing validation and correction.

Inventive Principle:
Principle #23Feedback

3Reliability

If graph rules are applied to validate entities and relationships, then data quality improves, but processing complexity increases

Engineering Contradiction:
Improvedata qualityVSAvoidnormalization engine complexity
Core Design Contradiction:
ReliabilityVSDevice complexity

Solution Approach 1:

The normalization engine is segmented into distinct functional modules: rule definition module for creating validation rules, rule application module for executing rules against data, and rule action module for implementing corrections. This segmentation reduces overall system complexity by breaking down the validation process into manageable, independent components.

Inventive Principle:
Principle #1Segmentation

Data Source

PatentUS11010359B2Multi-entity normalization
Publication Date: 2021.05.18 BMC HELIX INC
  • US11010359B2 patent drawing
  • US11010359B2 patent drawing
  • US11010359B2 patent drawing

AI summary

In accordance with aspects of the disclosure, systems and methods are provided for normalizing data representing entities and relationships linking the entities including defining one or more graph rules describing searchable characteristics for the data representing the entities and relationships linking the entities, applying the one or more graph rules to the data representing the entities and the relationships linking the entities, identifying one or more matching instances between the one or more graph rules and the data representing the entities and the relationships linking the entities, and performing one or more actions to update the one or more matching instances between the one or more graph rules and the data representing the entities and the relationships linking the entities.