Enterprise Relationship Data Consolidation via Hierarchy Manager

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Enterprises face challenges in obtaining a comprehensive view of customer interactions due to disparate data sources and different data models, leading to fragmented customer relationship data and missed opportunities for revenue and profitability.

Innovation Solution

A system that consolidates and normalizes relationship data across multiple sources, using a hierarchy manager to cleanse, standardize, and map data into an enterprise-normalized format, providing a 360° view of customer relationships and enabling cross-hierarchy navigation.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If enterprises use multiple independent data sources for different business functions, then each application can be managed independently with specialized data models, but data becomes dispersed across multiple sources making it difficult to obtain a comprehensive view of customer relationships

Engineering Contradiction:
Improveapplication independenceVSAvoidcustomer relationship data completeness
Core Design Contradiction:
Adaptability or versatilityVSLoss of information

Solution Approach 1:

The patent merges data from multiple independent data sources into a unified customer view by establishing entity relationships between records across different applications. The system consolidates customer data, account data, and interaction data from disparate sources while maintaining the independence of each source system, resolving the contradiction between application independence and data completeness.

Inventive Principle:
Principle #5Merging (Combining)

Solution Approach 2:

The patent creates a universal data model that can represent customer relationships across multiple business functions and applications. This universal model serves as a common framework that accommodates data from different specialized applications, enabling comprehensive customer views without requiring changes to the independent application architectures.

Inventive Principle:
Principle #6Universality (Multi-functionality)

2Productivity

If different applications use different data models to track customer interactions, then each application can optimize for its specific function, but reconciling relationship data between applications becomes difficult

Engineering Contradiction:
Improveapplication functionalityVSAvoiddata reconciliation complexity
Core Design Contradiction:
ProductivityVSDevice complexity

Solution Approach 1:

The patent introduces an intermediary layer that translates between different application-specific data models and a unified customer relationship model. This intermediary handles the complexity of data reconciliation by mapping data from various sources using standardized entity relationships, allowing applications to maintain their optimized data models while enabling comprehensive data integration.

Inventive Principle:
Principle #24Intermediary (Mediator)

3Ease of manufacture

If enterprises maintain data in disparate data sources, then data can be stored in application-optimized formats, but opportunities for cross-sell and up-sell are lost due to incomplete customer views

Engineering Contradiction:
Improvedata storage efficiencyVSAvoidcustomer interaction insights
Core Design Contradiction:
Ease of manufactureVSLoss of information

Solution Approach 1:

The patent segments customer relationship data into distinct entity types (customers, accounts, interactions) while maintaining the organizational structure of source systems. This segmentation allows data to remain in application-optimized formats at the source while creating a consolidated view that reveals cross-sell and up-sell opportunities by connecting previously siloed information.

Inventive Principle:
Principle #1Segmentation

Data Source

PatentUS8065266B2Relationship data management
Publication Date: 2011.11.22 INFORMATICA CORP
  • US8065266B2 patent drawing
  • US8065266B2 patent drawing
  • US8065266B2 patent drawing

AI summary

Some embodiments provide a system for processing relationship data that expresses relationship between various entities. In some embodiments, the entities are entities associated directly with an enterprise. The entities in some embodiments described below also include entities associated indirectly with the enterprise through other entities. However, one of ordinary skill will realize that some embodiments might only track relationships between entities directly associated with an enterprise. In some embodiments, the system consolidates disparate relationship data sets that relate to the same set of entities. For instance, in some embodiments, the system includes several data storages that store relationship data. For at least two entities, at least two different data storages store two different relationship data sets that differently express the relationship between the two entities. The system includes a hierarchy manager that receives the two different relationship data sets and consolidates the two different relationship data sets into one relationship data set that best expresses the relationship between the two entities.