Patent ID: 11921742
Assignee: BEIJING BORRUI DATA TECHNOLOGY CO., LTD.
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 0:
1. A method for intelligent visual analysis and display of cross-source heterogeneous data, wherein the method is being applied to a system comprising a visual data intelligence platform, a distributed in-memory database and a plurality of heterogeneous data sources, the method comprising:
when a visual display command for the target heterogeneous data is detected, creating a connector in the distributed in-memory database corresponding to each target data source where the target heterogeneous data is located via a Java Database Connectivity (JDBC) driver, and connecting the distributed in-memory database and each the target data source via each connector;
creating a connection between the visual data intelligence platform and the distributed in-memory database via python driver and SQLAIchemy framework of the distributed in-memory database in the visual data intelligence platform;
generating SQL table building statements in the visual data intelligence platform based on associated information corresponding to the target heterogeneous data;
fetching the target heterogeneous data from the target data source via each connector in the distributed in-memory database based on the SQL table building statements, and generating a target data table associated with a plurality of tables;
visual displaying the target heterogeneous data in the visual data intelligence platform based on the target data table; wherein, the associated information includes an associated data table, an associated field and an associated type; and
visual displaying the target heterogeneous data in the visual data intelligence platform based on the target data table, specifically by: mapping the associated data table to the target data table based on the SQLAlchemy framework, and recording the target table name of the target data table in the metadata database; selecting the target table name in the visual data intelligence platform, and obtaining the visual data corresponding to the target data table from the distributed in-memory database based on the target table name; returning the visual data to the front end for visual displaying the target heterogeneous data.