Unlock instant, AI-driven research and patent intelligence for your innovation.

A method and device for recommending report data sources based on semantic analysis

A technology for report data and semantic analysis, applied in the field of data processing, can solve problems such as multiple workloads and spend more time, and achieve the effect of simplifying workload, reducing time consumption, and quickly generating

Active Publication Date: 2022-07-08
国家电网有限公司大数据中心
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, the data source definition process of manually defining the data source requires a lot of work, which makes report generation take a lot of time

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • A method and device for recommending report data sources based on semantic analysis
  • A method and device for recommending report data sources based on semantic analysis
  • A method and device for recommending report data sources based on semantic analysis

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0022] Embodiment 1 of the present invention provides a method for recommending report data sources based on semantic analysis. The method can be implemented by a report data source recommendation device based on semantic analysis, wherein the device can be implemented by software and / or hardware, and can generally be integrated into a server with similar index recommendation functions, which is suitable for report modeling. The indicators in the report table that need to define data sources recommend available data sources. figure 1 A schematic flowchart of a method for recommending a report data source based on semantic analysis provided in Embodiment 1 of the present invention, such as figure 1 As shown, the method includes:

[0023] S110: Acquire attribute information of a target index of a data source that needs to be defined in the business report.

[0024] Exemplarily, the server may, when detecting that a user of a client that establishes a communication connection w...

Embodiment 2

[0033] figure 2A schematic flowchart of a method for recommending a report data source based on semantic analysis provided in Embodiment 2 of the present invention. On the basis of the above-mentioned embodiment, this embodiment optimizes "determining the similar index of the target index according to the attribute information" as: generating the target feature vector of the target index according to the attribute information; The vector and the candidate feature vector of each candidate indicator in the indicator library perform a clustering operation on the target indicator and each candidate indicator, and determine the target class to which the target indicator belongs; according to the relationship between the target indicator and the target indicator. A set number of candidate indicators are obtained from the target class in descending order of similarity as similarity indicators of the target indicators.

[0034] Further, after the sending the similar indicators to th...

Embodiment 3

[0062] Embodiment 3 of the present invention provides a device for recommending report data sources based on semantic analysis. The device can be implemented by software and / or hardware, and can generally be integrated into a server with a similar indicator recommendation function. It is suitable for recommending available data sources for indicators that need to define data sources in the report table during report modeling. The determination method of performing a data source pair assists the user in the data source definition. image 3 A structural block diagram of the device for recommending report data sources based on semantic analysis provided in Embodiment 3 of the present invention, such as image 3 As shown, the device includes an acquisition module 301, a determination module 302 and a transmission module 303, wherein,

[0063] The obtaining module 301 is used to obtain the attribute information of the target index that needs to define the data source in the busine...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The embodiment of the present invention discloses a method and device for recommending report data sources based on semantic analysis. The method includes: acquiring attribute information of a target index of a data source that needs to be defined in a business report; determining a similar index of the target index according to the attribute information; sending the similar index to a target client, so that the target The user terminal defines the target data source of the target indicator based on the similar data source of the similar indicator. By adopting the above technical solution, the embodiment of the present invention recommends similar indicators of the target indicator to the user terminal, so that the user terminal can directly use the similar data source of the similar indicator as the target data source of the target indicator, and does not need to manually identify the target indicator. It can realize the rapid generation of report data source access rules, reduce the time spent on defining data source access rules, and simplify the workload required for report settings.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a method and device for recommending report data sources based on semantic analysis. Background technique [0002] When conducting business analysis, it is usually necessary to perform statistical operations on business data and present them to users in the form of reports. [0003] When generating a report, you need to define a data source for each indicator in the report. However, since the data required for most of the business reports of an enterprise often come from different systems and / or different fields, there are various types of data such as structured, semi-structured, and unstructured, and the data consumption scenarios faced are different. At the same time, the description methods of the same data in the report are often different, etc., which makes it necessary to face a more complex data retrieval environment when generating a report. In the prior art, d...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/2458G06F16/28
CPCG06F16/2462G06F16/285
Inventor 王继业杨志程志华王宏刚刘识任征东李贤慧彭放张海峰
Owner 国家电网有限公司大数据中心