Search

CN-122023048-A - Data analysis method, device, equipment and storage medium based on audit platform

CN122023048ACN 122023048 ACN122023048 ACN 122023048ACN-122023048-A

Abstract

The application relates to a data analysis method, a device, equipment and a storage medium based on an audit platform, which are used for responding to clicking operation of a data analysis control in a data analysis page of the audit platform, determining a current data level where the data analysis control is located and a target data level where candidate data associated with the data analysis control are located, screening target associated fields matched with the current data level and the target data level in a preset level association rule based on the current data level and the target data level, filling the target associated fields according to page display content of the data analysis page to obtain target associated field values, inquiring the candidate data associated with the data analysis control from a database according to the target data level and the target associated field values, and outputting abnormal target data in the candidate data according to a business rule corresponding to the data analysis control. And the complicated operation of inquiring the service systems one by one is avoided, and the data analysis efficiency is improved.

Inventors

  • Lei Yangkun
  • ZHANG ZHIKUN

Assignees

  • 北京大学

Dates

Publication Date
20260512
Application Date
20260212

Claims (10)

  1. 1. An audit platform-based data analysis method, the method comprising: Responding to clicking operation of a data analysis control in a data analysis page of the audit platform, and determining a current data level where the data analysis control is located and a target data level where candidate data associated with the data analysis control is located; screening target association fields matched with the current data hierarchy and the target data hierarchy from a preset hierarchy association rule based on the current data hierarchy and the target data hierarchy, wherein the preset hierarchy association rule comprises association fields between different data hierarchies and different data hierarchies, and the different data hierarchies are determined based on service data corresponding to a target service scene; filling the target associated field according to the page display content of the data analysis page to obtain a target associated field value; querying candidate data associated with the data analysis control from a database according to the target data hierarchy and the target associated field value; And outputting target data with abnormality in the candidate data according to the business rule corresponding to the data analysis control.
  2. 2. The method of claim 1, wherein the determining a current data level at which the data analysis control is located and a target data level at which candidate data associated with the data analysis control is located comprises: The configuration information of the data analysis control is obtained, wherein the configuration information comprises a data level identification and a data level jump path of the data analysis control; And determining a target data level of candidate data associated with the data analysis control according to the current data level of the data analysis control and a data level jump path.
  3. 3. The method of claim 1, wherein querying the database for candidate data associated with the data analysis control based on the target data hierarchy and target association field values comprises: If the target data hierarchy is a first data hierarchy, inquiring candidate data associated with the data analysis control in a distributed database according to the target associated field value, wherein summarized data are stored in the distributed database; And if the target data level is a second data level, inquiring the candidate data associated with the data analysis control in a relational database according to the target associated field value, wherein the relational database stores the detail data associated with the summarized data.
  4. 4. The method of claim 3, wherein querying a distributed database for candidate data associated with the data analysis control based on the target-associated field value comprises: Matching target cube data in multi-dimensional cube data of a distributed database based on target query dimensions and target query indexes in the target associated field values, wherein the target cube data are summary data corresponding to the target query indexes in the target query dimensions generated in advance; And taking the target party data as the candidate data associated with the data analysis control.
  5. 5. The method of claim 4, wherein the multi-dimensional cube data is constructed by: Determining candidate query dimensions and candidate query indexes of multi-dimensional cube data to be constructed; Determining shell fragments of multi-dimensional cube data according to different dimension combinations obtained by combining different candidate query dimensions, wherein the shell fragments are a set of the different dimension combinations; For each dimension combination, taking a candidate query dimension in the dimension combination as an index key, taking a candidate query index and a service data identifier as index values, determining a candidate query index value in service data corresponding to the service data identifier, and taking the candidate query index value as candidate cube data of the dimension combination, wherein the candidate query index value is summary data corresponding to the candidate query index in the candidate query dimension; and constructing the multi-dimensional square data according to the candidate square data of each dimensional combination.
  6. 6. The method according to claim 1, wherein the method further comprises: Matching corresponding chart types based on the data types and/or analysis requirements of the candidate data associated with the data analysis control; And displaying the candidate data associated with the data analysis control in the page corresponding to the target data level in a matched chart type.
  7. 7. An audit platform based data analysis device, the device comprising: The determining module is used for responding to clicking operation of the data analysis control in the data analysis page of the audit platform and determining the current data level of the data analysis control and the target data level of candidate data associated with the data analysis control; The screening module is used for screening target association fields matched with the current data hierarchy and the target data hierarchy from a preset hierarchy association rule based on the current data hierarchy and the target data hierarchy, wherein the preset hierarchy association rule comprises association fields between different data hierarchies and different data hierarchies, and the different data hierarchies are determined based on service data corresponding to a target service scene; the filling module is used for analyzing page display content of a page according to the data, filling the target associated field and obtaining a target associated field value; the query module is used for querying the candidate data associated with the data analysis control from a database according to the target data hierarchy and the target associated field value; and the display module is used for outputting and displaying the target data with the abnormality in the candidate data according to the business rule corresponding to the data analysis control.
  8. 8. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor implements the steps of the method of any of claims 1 to 6 when the computer program is executed.
  9. 9. A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1 to 6.
  10. 10. A computer program product comprising a computer program, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1 to 6.

Description

Data analysis method, device, equipment and storage medium based on audit platform Technical Field The present application relates to the field of database technologies, and in particular, to a data analysis method, apparatus, device, and storage medium based on an audit platform. Background Informatization of universities has been developed for decades, so that a plurality of core business systems such as finance, assets, educational administration, personnel, scientific research, training and the like are formed, and the operation of economic business in the universities is supported. The system analysis such as integration, penetration and excavation is carried out on the information data generated by each core service system of the university, and the method has important significance for the internal audit of the university and even the management of the university. In the traditional technology, only data of a single data system is usually supported, when related data related to a plurality of data systems are required to be analyzed, related service systems are required to be queried one by one or paper documents are required to be browsed one by one for analysis, and the problems that the data analysis efficiency is low, the analysis result cannot be accurate and the like exist. Disclosure of Invention In view of the foregoing, it is desirable to provide a data analysis method, apparatus, device and storage medium based on an audit platform, which can improve data analysis efficiency. In a first aspect, the present application provides a data analysis method, comprising: Responding to clicking operation of a data analysis control in a data analysis page of the audit platform, and determining a current data level where the data analysis control is located and a target data level where candidate data associated with the data analysis control is located; screening target association fields matched with the current data hierarchy and the target data hierarchy from a preset hierarchy association rule based on the current data hierarchy and the target data hierarchy, wherein the preset hierarchy association rule comprises association fields between different data hierarchies and different data hierarchies, and the different data hierarchies are determined based on service data corresponding to a target service scene; filling the target associated field according to the page display content of the data analysis page to obtain a target associated field value; querying candidate data associated with the data analysis control from a database according to the target data hierarchy and the target associated field value; And outputting target data with abnormality in the candidate data according to the business rule corresponding to the data analysis control. In one embodiment, the determining the current data hierarchy in which the data analysis control is located and the target data hierarchy in which the candidate data associated with the data analysis control is located includes: The configuration information of the data analysis control is obtained, wherein the configuration information comprises a data level identification and a data level jump path of the data analysis control; And determining a target data level of candidate data associated with the data analysis control according to the current data level of the data analysis control and a data level jump path. In one embodiment, the querying the candidate data associated with the data analysis control from the database according to the target data hierarchy and the target associated field value includes: If the target data hierarchy is a first data hierarchy, inquiring candidate data associated with the data analysis control in a distributed database according to the target associated field value, wherein summarized data are stored in the distributed database; And if the target data level is a second data level, inquiring the candidate data associated with the data analysis control in a relational database according to the target associated field value, wherein the relational database stores the detail data associated with the summarized data. In one embodiment, the querying the distributed database for candidate data associated with the data analysis control according to the target associated field value includes: Matching target cube data in multi-dimensional cube data of a distributed database based on target query dimensions and target query indexes in the target associated field values, wherein the target cube data are summary data corresponding to the target query indexes in the target query dimensions generated in advance; And taking the target party data as the candidate data associated with the data analysis control. In one embodiment, the multidimensional cube data is constructed by: Determining candidate query dimensions and candidate query indexes of multi-dimensional cube data to be constructed; Determining shell fragments of multi-dimensi