Schema-Based Integration Platform for Back-End Data Analysis Tools

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Existing data analysis tools require labor-intensive custom applications and third-party involvement, leading to miscommunication, delays, and difficulty in integrating multiple tools for comprehensive data analysis, especially in organizations with diverse data management systems.

Innovation Solution

A computer-implemented method and system that uses a graphical user interface to select and integrate component functions across multiple back-end data analysis tools, translating these into pre-configured commands to expose datasets and generate results, enabling users to combine tools without specialized programming skills.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If custom applications are constructed to perform new data analysis, then the analysis functionality is improved, but the development time and cost increase significantly

Engineering Contradiction:

Improvedata analysis functionalityVSAvoiddevelopment time

Core Design Contradiction:

Adaptability or versatilityVSLoss of time

Solution Approach 1:

The system pre-configures multiple data analysis tools and their associated datasets before users need them. When a user wants to perform analysis, the tools are already assembled and ready to use, eliminating the time-consuming custom application development process while maintaining versatile analysis capabilities.

Inventive Principle:

Principle #10Preliminary action

Solution Approach 2:

The system creates a universal platform that can perform multiple types of data analysis functions through pre-configured tools. Instead of building separate custom applications for each analysis type, a single system provides versatile functionality across different analysis scenarios, reducing both development time and improving adaptability.

Inventive Principle:

Principle #6Universality (Multi-functionality)

2Adaptability or versatility

If third-party developers are engaged to build custom applications, then the analysis capability is improved, but communication errors and implementation mistakes increase

Engineering Contradiction:

Improveanalysis capabilityVSAvoidimplementation accuracy

Core Design Contradiction:

Adaptability or versatilityVSReliability

Solution Approach 1:

The system enables users to perform data analysis themselves using pre-configured tools without needing third-party developers. Users can directly access and operate the analysis tools through the graphical interface, eliminating communication gaps and ensuring that their exact analysis needs are implemented correctly, thus improving both capability and reliability.

Inventive Principle:

Principle #25Self-service

3Adaptability or versatility

If multiple separate data analysis tools are used, then the comprehensive analysis capability is improved, but the complexity of operating and integrating the tools increases

Engineering Contradiction:

Improvecomprehensive analysis capabilityVSAvoidtool integration complexity

Core Design Contradiction:

Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The system merges multiple separate data analysis tools into a single integrated platform. Different analysis tools are combined and made accessible through one graphical interface, allowing users to perform comprehensive analysis while avoiding the complexity of managing and integrating multiple separate tools manually.

Inventive Principle:

Principle #5Merging (Combining)

Solution Approach 2:

The system introduces an intermediary layer (the graphical user interface and translation service) that mediates between the user and the complex backend tools. This intermediary translates simple user commands into the appropriate tool-specific operations, hiding the complexity of tool integration from users while maintaining comprehensive analysis capability.

Inventive Principle:

Principle #24Intermediary (Mediator)

4Reliability

If data is hidden and managed by different applications in different locations, then the data security is improved, but the accessibility and discoverability of data decreases

Engineering Contradiction:

Improvedata securityVSAvoiddata accessibility

Core Design Contradiction:

ReliabilityVSEase of operation

Solution Approach 1:

The system creates a universal access point that can retrieve data from multiple different locations and applications through a single interface. Users can access data regardless of its original location or managing application, maintaining security through controlled access while improving ease of operation by providing centralized data discovery and retrieval.

Inventive Principle:

Principle #6Universality (Multi-functionality)

Data Source

PatentUS20240184539A1Platform for integrating back-end data analysis tools using schema

Publication Date: 2024.06.06 ORACLE INT CORP

AI summary

Systems, methods, and other embodiments associated with schema-based integration of back-end data analysis tools are described. In one embodiment, an example method includes receiving, through a graphical user interface, a selection of a component function for operation on a first dataset that spans a plurality of back-end tools. The example method translates the selected component function into a set of pre-configured commands specific to the back-end tools to expose the first dataset and exclude a second dataset of the back-end tools. The example method executes the pre-configured commands to create synonyms for the first dataset in a workspace schema associated with the graphical user interface. And, the example method executes the selected component function on the synonyms to generate a result from the first dataset.