AI MetadataBot Visual Linking for Drill-Through Data Retrieval

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Current data drilling methods in networked computing environments fail to efficiently identify and visualize drill through data links, requiring manual iteration and are resource-intensive, especially during data migration or backup, leading to inefficiencies and human errors.

Innovation Solution

Implementing an AI-driven MetadataBot (DDMB) that automatically identifies and generates visual indicators for drill through data, using machine learning to detect user interactions and automate data link dependencies, thereby enhancing drill through data retrieval.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Productivity

If manual methods are used to identify and navigate drill through data links, then users can access related information, but the process is time-consuming and resource-intensive

Engineering Contradiction:
Improvedata retrieval efficiencyVSAvoidtime to identify drill through links
Core Design Contradiction:
ProductivityVSLoss of time

Solution Approach 1:

The system automatically identifies drill through data links and generates visual indicators without requiring manual user intervention. The MetadataBot autonomously searches metadata, identifies relationships between data items and target reports, and enhances the source report with visual cues, allowing the system to serve itself rather than relying on manual user actions.

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The patent replaces manual mechanical processes (user clicking, searching, and navigating) with an automated artificial intelligence system. The MetadataBot uses machine learning to detect user interactions and automatically generates visual indicators, substituting the mechanical manual exploration process with an intelligent automated system that continuously monitors and enhances reports.

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

2Reliability

If manual iteration is used to explore drill through data, then users can discover related information, but human errors increase and resource consumption rises

Engineering Contradiction:
Improveaccuracy of data link identificationVSAvoidhuman errors in manual navigation
Core Design Contradiction:
ReliabilityVSObject-generated harmful factors

Solution Approach 1:

The system continuously monitors user interactions with reports and uses this feedback to improve its identification of drill through data links. The MetadataBot detects how users interact with reports and uses this information to refine its metadata searching and visual indicator generation, creating a closed-loop system that learns from user behavior to reduce errors and improve accuracy over time.

Inventive Principle:
Principle #23Feedback

Solution Approach 2:

The automated system eliminates human error by performing the identification and navigation tasks itself. The MetadataBot autonomously searches metadata, identifies correct relationships between source and target reports, and generates accurate visual indicators without the possibility of human mistakes in link identification or navigation.

Inventive Principle:
Principle #25Self-service

3Productivity

If automated MetadataBot is implemented to identify drill through links, then data retrieval efficiency improves, but system complexity increases

Engineering Contradiction:
Improveautomated data link identification speedVSAvoidcomplexity of AI-driven system
Core Design Contradiction:
ProductivityVSDevice complexity

Solution Approach 1:

The MetadataBot is designed as a universal system that performs multiple functions: it searches metadata, identifies drill through relationships, generates visual indicators, and continuously learns from user interactions. This multi-functional approach consolidates what would otherwise require multiple separate systems into a single versatile platform, managing complexity through functional integration.

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

Solution Approach 2:

The MetadataBot acts as an intermediary layer between the user and the complex metadata infrastructure. It abstracts the complexity of metadata searching and relationship identification by providing a simple visual interface with enhanced reports that automatically indicate drill through links, shielding users from system complexity while enabling efficient data retrieval.

Inventive Principle:
Principle #24Intermediary (Mediator)

Data Source

PatentUS12455892B2Artificial intelligence based bot-enhanced retrieval of drill through data
Publication Date: 2025.10.28 INTERNATIONAL BUSINESS MACHINE CORPORATION
  • US12455892B2 patent drawing
  • US12455892B2 patent drawing
  • US12455892B2 patent drawing

AI summary

An approach for enhancing retrieval of drill through data is provided. A determination is made as to whether a source report generated from query results of a query by a user contains a data item that is associated with drill through data. In response to a positive determination, a data drill MetadataBot (DDMB) is initiated. In response to activation, the DDMB searches metadata associated with the query results to identify a set of DDMB parameters for the data item. These DDMB parameters can include the cell that contains the data item and a target report containing the drill through data for the cell. Based on this search, the DDMB generates an augmented report that contains a visual identifier for the drill through data-associated cell, allowing the user to retrieve the target report by interacting with the visual identifier.