Unified Governance Platform for Social Media Data Integration

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Current unified governance and integration platforms do not effectively manage and protect social media data, leading to uncertainties about data correctness and availability, as well as compliance with regulations like GDPR.

Innovation Solution

A computer-implemented method and system that applies a unified governance and integration platform to social media data by using data integration definitions to extract, transform, and load social media data between systems via connectors, enabling governance, integration, and compliance.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If a unified governance and integration platform is applied to social media data, then data correctness, availability, and compliance are improved, but system complexity increases

Engineering Contradiction:
Improvedata correctness and availabilityVSAvoidplatform complexity
Core Design Contradiction:
ReliabilityVSDevice complexity

Solution Approach 1:

The platform segments data governance into modular ETL (Extract-Transform-Load) components that can be independently configured and executed. Each social media data source is handled by dedicated connectors that implement governance rules locally, reducing overall system complexity while ensuring data correctness and compliance.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The patent introduces an intermediary governance layer between social media data sources and target systems. This intermediary platform standardizes data integration processes through predefined connectors and transformation rules, managing complexity internally while presenting a simplified interface to users and ensuring consistent data governance.

Inventive Principle:
Principle #24Intermediary (Mediator)

2Manufacturing precision

If data integration definitions are used to extract and transform social media data, then data quality and compliance are improved, but processing time increases

Engineering Contradiction:
Improvedata qualityVSAvoidprocessing time
Core Design Contradiction:
Manufacturing precisionVSLoss of time

Solution Approach 1:

The platform performs preliminary actions by pre-configuring data integration definitions, transformation rules, and governance policies before data extraction. Connectors are pre-built with embedded compliance logic, allowing data to be processed through standardized pipelines that ensure quality without requiring complex real-time processing decisions.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The system changes parameters by transforming social media data into standardized formats with consistent schemas, data types, and governance metadata. This parameter standardization enables efficient processing while maintaining high data quality, as transformation rules are applied systematically rather than through complex custom processing.

Inventive Principle:
Principle #35Parameter changes

3Adaptability or versatility

If connectors are used to link data between systems, then data availability and integration are improved, but system complexity increases

Engineering Contradiction:
Improvedata integration capabilityVSAvoidconnector complexity
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent implements universal connectors that can interface with multiple social media data sources and target systems through standardized protocols. Each connector is designed to handle various data types and governance requirements through configurable parameters rather than requiring custom development for each integration scenario, reducing overall connector complexity.

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

Solution Approach 2:

Connectors utilize parameter changes to adapt to different data sources and targets. By configuring connectors with source-specific and target-specific parameters, the system achieves high integration versatility without increasing structural complexity, as the same connector framework handles diverse integrations through parameterization.

Inventive Principle:
Principle #35Parameter changes

Data Source

PatentUS11310210B2Applying unified governance and integration platform to social media data
Publication Date: 2022.04.19 INTERNATIONAL BUSINESS MACHINE CORPORATION
  • US11310210B2 patent drawing
  • US11310210B2 patent drawing
  • US11310210B2 patent drawing

AI summary

A computer-implemented method, system and computer program product for applying a unified governance and integration platform to social media data. Data integration definitions for managing and protecting social media data are received. After receiving the data integration definitions for social media data, data integration externalization, governance catalog externalization or lineage externalization may be performed. For example, social media data may be extracted from a database system by a governance and integration unit (“unit”) using the data integration definitions. The extracted social media data is then transformed and loaded to the social media data system via a connector linking the data from the unit to the social media data system. In another example, social media data is extracted from the social media data system by the unit, such as via the connector, using the data integration definitions and then transformed and loaded to the database system for analysis.