Mapping Information Formatting for Data Integration Systems
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Querying and manipulating specific data in data integration systems is tedious and labor-intensive, often requiring manual review of human-written code, especially when transfers have labels that do not reference the specific data target.
Innovation Solution
A user interface tool that generates a graphical user interface (GUI) to accept user input for mapping level dependencies, searching and formatting mapping information into trees or tables based on user requests for forward or backward dependencies, allowing intuitive display of data transfer information.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If manual review of human-written code is used to query specific data, then complete data access is achieved, but the process becomes tedious and labor-intensive
Solution Approach 1:
The patent introduces an intermediary tool that acts as a mediator between the user and the raw mapping information. This tool automatically queries the data integration system, formats the results into readable representations (such as ASCII art or structured text), and presents them to the user. This intermediary layer eliminates the need for users to manually review code while maintaining complete data access, thus resolving the contradiction between ease of operation and time consumption.
Solution Approach 2:
The patent replaces the mechanical process of manual code review with an automated computational system. Instead of humans manually examining and interpreting mapping information, the system automatically queries the data integration system, processes the raw data, and generates formatted representations. This substitution of mechanical human effort with automated computational processes dramatically reduces time requirements while maintaining complete data access.
2Quantity of substance
If mapping information is stored in a data integration system with multiple sources and targets, then comprehensive data storage is achieved, but finding specific data becomes tedious and labor intensive
Solution Approach 1:
The patent extracts specific mapping information from the large body of stored data in the data integration system. When a user queries for specific data, the system automatically extracts only the relevant mapping information related to that query, rather than requiring the user to search through all stored mapping information. This extraction process maintains comprehensive data storage while making specific data easily findable through automated retrieval and formatted presentation.
Data Source
AI summary
Provided are tools and methods for formatting mapping information from a data integration system (DIS) having stored therein a plurality of instances of mapping information, wherein an instance of mapping information includes information related to a data transfer between sources and targets coupled to the data integration system. The method includes generating and displaying a graphical user interface (GUI) on a display system and accepting user selections and input responsive thereto. The method includes receiving a user request for a mapping level dependency or for a port dependency table. The method prompts the user and receives user input to complete a search of the DIS according to the user request. All instances of mapping information matching the user request are found and the information is formatted and displayed in an intuitive format, such as a hierarchical tree structure or a table.