Chatbot Interface for ETL and MDM Server Accessibility

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Existing Extract Transform and Load (ETL) and Master Data Management (MDM) servers are inaccessible and complex, requiring extensive training, leading to slow adoption and difficulty in mobile application development due to outdated graphical user interfaces and lack of integration with social media platforms.

Innovation Solution

Implementing a social media gateway interface with chat adapters to create chatbots that represent data system components, allowing for interactive management and access via social media applications, enabling users to interact with ETL and MDM servers through familiar interfaces like chat applications.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Ease of operation

If traditional graphical user interfaces are used for ETL and MDM servers, then comprehensive data management functionality is provided, but the interface complexity requires extensive training and reduces ease of operation

Engineering Contradiction:

Improveease of operationVSAvoidinterface complexity

Core Design Contradiction:

Ease of operationVSDevice complexity

Solution Approach 1:

The patent introduces chatbots as intermediary agents that mediate between users and the complex ETL/MDM server systems. These chatbots provide a simplified conversational interface while handling the underlying complexity of data management operations, thus improving ease of operation without sacrificing functionality.

Inventive Principle:

Principle #24Intermediary (Mediator)

Solution Approach 2:

The patent replaces traditional mechanical graphical user interfaces with an automated chatbot-based system. This substitution eliminates the need for manual navigation through complex menus and forms, replacing it with natural language interactions that are inherently easier to use while maintaining access to all underlying data management capabilities.

Inventive Principle:

Principle #28Mechanics substitution (Replace mechanical system)

2Productivity

If traditional graphical user interfaces are used for ETL and MDM servers, then full data management capabilities are available, but extensive training is required leading to slow adoption

Engineering Contradiction:

Improveadoption rateVSAvoidtraining time

Core Design Contradiction:

ProductivityVSLoss of time

Solution Approach 1:

The patent creates simplified chatbot interfaces that copy and replicate the full functionality of the underlying ETL/MDM systems through conversational commands. Users interact with these simplified copies rather than the complex original interfaces, eliminating training requirements while preserving all data management capabilities through the chatbot mediation layer.

Inventive Principle:

Principle #26Copying

3Adaptability or versatility

If mobile applications are developed for ETL tools, then mobile access to data is enabled, but development complexity increases due to multiple devices and interfaces

Engineering Contradiction:

Improvemobile accessVSAvoiddevelopment complexity

Core Design Contradiction:

Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent implements a universal chatbot interface that functions across all mobile devices and platforms without requiring separate applications. The chatbot adapts to different devices and communication platforms, providing consistent data management capabilities through a single unified interface rather than requiring multiple device-specific applications.

Inventive Principle:

Principle #6Universality (Multi-functionality)

4Ease of operation

If traditional ETL and MDM server interfaces are used, then comprehensive data management is achieved, but access is closed and highly specialized

Engineering Contradiction:

ImproveaccessibilityVSAvoidspecialization requirement

Core Design Contradiction:

Ease of operationVSDevice complexity

Solution Approach 1:

Inventive Principle:

Principle #24Intermediary (Mediator)

Data Source

PatentUS10122655B2Personalizing data system components and data sources as chatbots in a group chat session

Publication Date: 2018.11.06 INTERNATIONAL BUSINESS MACHINE CORPORATION

AI summary

Provided are techniques for personalizing data system components and data sources as chatbots in a group chat session. A social media gateway interface with a chat adapter for a chat application is provided. One or more chatbots that each represent a corresponding component of a data system are created. The one or more chatbots and the chatbot adapter are used to manage each corresponding component of the data system.