Data collecting and processing method based on report tool

Abstract

A data collecting and processing method based on a report tool comprises the following steps: S1, constructing a database; S2, collecting data, and storing actively and passively collected data in a database to form source data, wherein the data collection process comprises active collection and passive collection, the active collection is ETL tool collection, and the passive collection is carriedout through data reporting collection; S3, generating a report: creating a new report, inputting a report rule, and importing the source data in the database into the report according to the report rule to form the report; and S4, reading report. Two groups of data collection systems, namely an active collection system and a passive collection system, are arranged, so data distributed at all levels can be centralized into the database, the problem of information islands at all levels originally is solved, the integration degree and the exchange speed of information are improved, and the difficulty of information exchange at all levels is reduced; and meanwhile, a report engine is arranged, so that custom design of table styles and dynamic generation of table contents are realized.

Description

technical field [0001] The invention relates to the technical field of data collection and processing, in particular to a data collection and processing method based on a reporting tool. Background technique [0002] Most of the professional application systems currently in operation are managed in a vertical chimney style and run independently. There is a lack of data interaction and linkage control between systems, and there are information islands. The data is scattered in the historical databases inside each dedicated system, and presented to the business leaders independently in the form of reports; when the leaders need to comprehensively consider the data from two or more systems, they often cannot The required comprehensive information is obtained from the data source through appropriate tools. Especially when the data sources are scattered in different security areas, it is more difficult to perform unified query statistics. These valuable data are not related to ...

AI Technical Summary

Problems solved by technology

The data is scattered in the historical databases inside each dedicated system, and presented to the business leaders independently in the form of reports; when the leaders need to comprehensively consider the data from two or more systems, they often cannot Obtain the required comprehensive information through appropriate tools in the data source

Especially when the data sources are scattered in different security areas, it is more difficult to perform unified query statistics

These valuable data are not related to each other, so it is impossible to make a unified and complete description of various components in the power system

[0003] In the actual production process, the dispatching business of provinces, prefectures and counties is mostly contacted through telephone layers. In the process of reporting fault statistics, new high regional loads, distribution of new energy units, and grid-connected capacity, etc., telephone or email contact often occurs. Requires inconsistent understanding, time-consuming and labor-intensive, and lack of historical data preservation and statistical analysis means

When the current scheduling business uses data to query reports, business personnel and technical personnel need to communicate repeatedly, and technical personnel then generate templates to export reports according to specific business processes. In this mode, the workload of technical support personnel is heavy, and the waiting time for business personnel is long. And the format of the generated template is fixed and cannot be extended

Images