Visual Data Analysis System for Real-Time Multi-Source Integration
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing visual data analysis systems are limited by their ability to handle diverse data sources, including those from external open interfaces and temporary caches, which occupy storage resources and hinder massive data analysis on cloud platforms.
Innovation Solution
A visual data analysis method and device that establishes connections with various data sources in real time, allowing for the combination and real-time analysis of multiple data sources. This is achieved by obtaining and displaying table information from each data source, generating a target dataset based on user-defined associations, and visualizing the results through charts.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If data from external open interfaces and temporary caches are solidified into the database for visual display, then the data can be displayed through the database visualization system, but storage resources of the visualization system are occupied and massive data analysis on the cloud platform is hindered
Solution Approach 1:
The patent introduces a data connection module as an intermediary layer between the visualization system and multiple data sources (databases, open interfaces, temporary caches). This mediator establishes connection relationships with various data sources without requiring data to be solidified into the visualization system's database, thereby maintaining data display capability while avoiding storage resource occupation.
Solution Approach 2:
The visualization system is enhanced with universal data connection capabilities that can connect to multiple types of data sources (relational databases, open interfaces, temporary caches, cloud platforms) through a unified interface. This multi-functionality allows the system to access and analyze data from diverse sources without requiring separate processing for each source type, enabling massive data analysis on cloud platforms while preserving display capabilities.
2Productivity
If data is solidified into the database for visual display, then the data can be analyzed through the visualization system, but the analysis of massive data on the cloud platform is not conducive
Solution Approach 1:
The patent implements a dynamic data connection architecture where the visualization system can flexibly connect to and switch between different data sources based on analysis requirements. The system dynamically establishes connection relationships with databases, open interfaces, temporary caches, and cloud platforms, enabling adaptive data analysis without requiring data to be statically stored in the visualization system's database. This dynamic approach maintains high productivity while improving adaptability to different data sources and analysis scenarios.
3Speed
If multiple types of data sources are connected and analyzed in real time, then real-time data analysis is achieved, but the system complexity increases
Solution Approach 1:
The patent segments the data connection and analysis functionality into distinct modular components: a data connection module that manages connections to multiple data sources, a data analysis module that processes data, and a visualization module that displays results. This segmentation allows real-time analysis of multiple data sources while managing system complexity through clear separation of concerns and modular architecture.
Data Source
AI summary
The present disclosure provides a visual data analysis method and device used for visual analysis for multiple types of data sources. By establishing connection relationships with various types of data sources, multiple types of data sources can be obtained in real time, and various types of data sources are combined and analyze in real time. The method includes: obtaining multiple types of data sources, and establishing a connection with each type of data source, wherein the type of data source is used to represent a source from which data is obtained; displaying, through a visual page, each piece of table information contained in each type of data source with which the connection is made.