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

Claim 7:
8. An apparatus for intelligent visual analysis and display of cross-source heterogeneous data, wherein it is applied to a system comprising a visual data intelligence platform, a distributed in-memory database and a plurality of heterogeneous data sources, the apparatus comprises: a processor, a first creation module, for 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 the connector; a second creation module, for creating a connection between the visual data intelligence platform and the distributed in-memory database via python driver and SQLAIchemy framework in the visual data intelligence platform; a first generation module, for generating SQL table building statements in the visual data intelligence platform based on associated information corresponding to the target heterogeneous data; a second generation module, for fetching the target heterogeneous data from the target data source via each the 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; a display module, for visualizing 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;
visualizing 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 display of the target heterogeneous data.