Hierarchy Management Server for Reference Data Synchronization

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Hierarchical data systems face challenges in managing and synchronizing reference data across multiple heterogeneous systems, leading to data inconsistencies and increased maintenance complexity due to the lack of knowledge and intercommunication between systems.

Innovation Solution

The implementation of a hierarchy management server that maintains a master set of reference data, generates data dimension mappings, and provides tools for incremental rationalization, governance pools, application materialization, data intersection mastering, and change request visualization to ensure data integrity and consistency across systems.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If multiple heterogeneous systems maintain their own independent hierarchies of reference data, then each system can operate autonomously with its own data organization, but data inconsistencies arise and maintenance complexity increases due to lack of intercommunication between systems

Engineering Contradiction:

Improvesystem autonomyVSAvoidmaintenance complexity

Core Design Contradiction:

Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent introduces a hierarchy management server as an intermediary component that mediates between multiple heterogeneous systems. This server maintains a master set of reference data and provides services to subscriber systems, allowing them to operate autonomously while ensuring data consistency through centralized management and synchronization mechanisms.

Inventive Principle:

Principle #24Intermediary (Mediator)

2Reliability

If a centralized master set of reference data is maintained to provide a single source of truth, then data integrity and consistency are improved, but system complexity increases due to the need for synchronization and governance mechanisms

Engineering Contradiction:

Improvedata integrityVSAvoidsystem complexity

Core Design Contradiction:

ReliabilityVSDevice complexity

Solution Approach 1:

The patent segments the hierarchy management functionality into distinct modular components including a hierarchy management server, subscriber systems, governance pools, and change request management mechanisms. This segmentation allows the complex centralized management function to be broken down into manageable, independently deployable modules that can be configured and maintained separately.

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The hierarchy management server acts as an intermediary that implements synchronization mechanisms between the master reference data and subscriber systems. It manages change requests, validates modifications, and propagates updates while maintaining data integrity, thereby reducing the overall system complexity through centralized coordination.

Inventive Principle:

Principle #24Intermediary (Mediator)

3Measurement precision

If change requests are manually processed and validated across multiple systems, then data accuracy can be ensured, but processing time and operational overhead increase significantly

Engineering Contradiction:

Improvedata accuracyVSAvoidprocessing time

Core Design Contradiction:

Measurement precisionVSLoss of time

Solution Approach 1:

The patent implements automated validation mechanisms where the hierarchy management server automatically validates change requests against predefined rules and constraints. The system self-services by autonomously determining whether changes are valid, notifying appropriate administrators, and propagating approved changes without requiring manual intervention for each validation step, thereby maintaining data accuracy while reducing processing time.

Inventive Principle:

Principle #25Self-service

Solution Approach 2:

The system implements feedback mechanisms where change requests are automatically validated and administrators are notified of pending changes. The validation results and approval statuses are fed back through the system, enabling automated decision-making and reducing manual processing time while maintaining data accuracy through structured validation rules.

Inventive Principle:

Principle #23Feedback

4Reliability

If comprehensive governance mechanisms are implemented to manage changes across all systems, then data consistency is improved, but ease of operation deteriorates due to increased administrative overhead

Engineering Contradiction:

Improvedata consistencyVSAvoidease of operation

Core Design Contradiction:

ReliabilityVSEase of operation

Solution Approach 1:

The hierarchy management server provides universal governance services that can be applied across multiple heterogeneous systems through a standardized interface. It handles change requests, validations, notifications, and propagations in a unified manner, allowing diverse systems to benefit from consistent governance mechanisms without requiring system-specific administrative procedures, thereby improving ease of operation while maintaining data consistency.

Inventive Principle:

Principle #6Universality (Multi-functionality)

Data Source

PatentUS20220382719A1Change request visualization in hierarchical systems

Publication Date: 2022.12.01 ORACLE INT CORP

AI summary

Various techniques are disclosed herein for storing and managing master data in hierarchical data systems. Several related concepts, embodiments, and examples are disclosed, including techniques for incremental rationalization in a hierarchical data model, techniques for implementing governance pools in a hierarchical data model, techniques for application materialization in a hierarchical data model, techniques for data intersection mastering in a hierarchical data model, techniques for change request visualization in a hierarchical data model, and techniques for hierarchy preparation in a hierarchical data model.