CN116303462A - Report processing method and device, storage medium and electronic equipment - Google Patents
Report processing method and device, storage medium and electronic equipment Download PDFInfo
- Publication number
- CN116303462A CN116303462A CN202310278980.0A CN202310278980A CN116303462A CN 116303462 A CN116303462 A CN 116303462A CN 202310278980 A CN202310278980 A CN 202310278980A CN 116303462 A CN116303462 A CN 116303462A
- Authority
- CN
- China
- Prior art keywords
- target
- report
- data
- analyzed
- analysis
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 24
- 238000004458 analytical method Methods 0.000 claims abstract description 277
- 238000012545 processing Methods 0.000 claims abstract description 93
- 238000000034 method Methods 0.000 claims abstract description 39
- 238000012986 modification Methods 0.000 claims description 17
- 230000004048 modification Effects 0.000 claims description 17
- 238000006243 chemical reaction Methods 0.000 claims description 6
- 238000004590 computer program Methods 0.000 claims description 6
- 238000005516 engineering process Methods 0.000 abstract description 3
- 230000006870 function Effects 0.000 description 33
- 238000011161 development Methods 0.000 description 21
- 230000008569 process Effects 0.000 description 17
- 238000001914 filtration Methods 0.000 description 12
- 238000012216 screening Methods 0.000 description 12
- 238000010586 diagram Methods 0.000 description 10
- 230000004044 response Effects 0.000 description 9
- 238000007667 floating Methods 0.000 description 5
- 238000007405 data analysis Methods 0.000 description 4
- 230000000694 effects Effects 0.000 description 3
- 230000001960 triggered effect Effects 0.000 description 3
- 230000008878 coupling Effects 0.000 description 2
- 238000010168 coupling process Methods 0.000 description 2
- 238000005859 coupling reaction Methods 0.000 description 2
- 230000007334 memory performance Effects 0.000 description 2
- 238000012544 monitoring process Methods 0.000 description 2
- 230000006978 adaptation Effects 0.000 description 1
- 230000001174 ascending effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000012790 confirmation Methods 0.000 description 1
- 238000013480 data collection Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000004141 dimensional analysis Methods 0.000 description 1
- 238000003780 insertion Methods 0.000 description 1
- 230000037431 insertion Effects 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000009877 rendering Methods 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
- G06F11/3466—Performance evaluation by tracing or monitoring
- G06F11/3476—Data logging
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24564—Applying rules; Deductive queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
- G06F2201/80—Database-specific techniques
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Computer Hardware Design (AREA)
- Quality & Reliability (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a report processing method, a report processing device, a storage medium and electronic equipment, and relates to the field of financial science and technology. Wherein the method comprises the following steps: obtaining a report file to be analyzed, wherein the report file to be analyzed comprises a plurality of reports to be analyzed, and the reports to be analyzed comprise performance data of target equipment; determining at least one target report to be analyzed from a plurality of reports to be analyzed according to a first analysis condition, wherein the first analysis condition comprises at least one of the following: report generation date, report type and report version; determining a target analysis rule corresponding to at least one target report to be analyzed, and analyzing the at least one target report to be analyzed according to the target analysis rule to obtain an analysis result, wherein the analysis result represents the performance condition of target equipment. The invention solves the technical problem of low processing efficiency in the prior art by manually collecting and analyzing report data.
Description
Technical Field
The invention relates to the field of financial science and technology, in particular to a report processing method, a report processing device, a storage medium and electronic equipment.
Background
The IBM mainframe has the characteristics of high integration, high reliability and strong expansibility, is widely applied to processing large-scale transactions, most financial institutions use the mainframe to process core business, and DB2 (relational database management system) is used as a core product of a mainframe system, and has the characteristics of stability and timeliness in terms of data storage and transaction response.
At present, the data collection and analysis of the performance monitoring report (Performance Monitor, PM) of the large-scale host DB2 product mainly comprises the steps of manually filtering and screening report files, collecting performance data, and using EXCEL and other tools to conduct comparison chart analysis, so that the problems of low processing efficiency and high error rate exist, the use time efficiency of a user cannot be met, and the data analysis process has higher requirements on the experience and technical level of the user.
In view of the above problems, no effective solution has been proposed at present.
Disclosure of Invention
The embodiment of the invention provides a report processing method, a report processing device, a storage medium and electronic equipment, which at least solve the technical problem of low processing efficiency in the prior art by manually collecting and analyzing report data.
According to an aspect of the embodiment of the present invention, there is provided a report processing method, including: obtaining a report file to be analyzed, wherein the report file to be analyzed comprises a plurality of reports to be analyzed, and the reports to be analyzed comprise performance data of target equipment; determining at least one target report to be analyzed from a plurality of reports to be analyzed according to a first analysis condition, wherein the first analysis condition comprises at least one of the following: report generation date, report type and report version; determining a target analysis rule corresponding to at least one target report to be analyzed, and analyzing the at least one target report to be analyzed according to the target analysis rule to obtain an analysis result, wherein the analysis result represents the performance condition of target equipment.
Further, the report processing method further comprises the following steps: acquiring a plurality of initial reports associated with target equipment; adding corresponding scene identifiers to names of the plurality of initial reports according to scene information corresponding to the plurality of initial reports to obtain a plurality of reports to be analyzed; and generating a report file to be analyzed according to the multiple reports to be analyzed.
Further, the report type includes at least one of: the first type and the second type are different in corresponding performance data, and the report processing method further comprises the following steps: acquiring a rule data table of an analysis rule corresponding to the report version; inquiring target data corresponding to the report type from a rule data table, and performing splicing processing on the target data to obtain a target analysis rule, wherein the target data comprises at least one of the following: the name of the performance data, the data type of the performance data and the analysis rule data, and the analysis rule data represents the analysis mode of the performance data.
Further, the report processing method further comprises the following steps: determining target performance data from the performance data of at least one target report to be analyzed according to the name of the performance data and the data type of the performance data; and analyzing the target performance data according to the analysis rule data to obtain an analysis result.
Further, the report processing method further comprises the following steps: after the report file to be analyzed is obtained, carrying out format conversion processing on the report file to be analyzed to obtain a converted report file to be analyzed, and storing the converted report file to be analyzed into a first directory.
Further, the report processing method further comprises the following steps: before determining at least one target report to be analyzed from a plurality of reports to be analyzed according to a first analysis condition, acquiring editing request information in a first target request under the condition that the first target request is received, wherein the first target request is one of the following: adding an editing request and modifying the editing request, wherein editing request information characterizes editing information of an analysis rule; and generating a first analysis rule according to the editing request information.
Further, the edit request information includes at least one of: the report processing method further comprises the steps of: if the first target request is a new editing request, generating a first target data table according to the first report type and the first report version; according to the name of the first performance data and the data type of the first performance data, acquiring first target data from a database, and storing the first target data in a first target data table; and newly adding first analysis rule data in the first target data table to generate a first analysis rule.
Further, the report processing method further comprises the following steps: if the first target request is a modification editing request, generating a second target data table according to the first report type and the first report version; according to the name of the first performance data and the data type of the first performance data, acquiring first target data from a database, and storing the first target data in a second target data table; and in the second target data table, updating the analysis rule corresponding to the first target data according to the first analysis rule data to generate a first analysis rule.
Further, the report processing method further comprises the following steps: before determining a target analysis rule corresponding to at least one target report to be analyzed, and analyzing the at least one target report to be analyzed according to the target analysis rule to obtain an analysis result, acquiring query request information in a second target request under the condition that the second target request is received, wherein the query request information comprises at least one of the following components: the target report generation date, the target report type, the target report version and the name of the target performance data; acquiring target analysis result data from a database according to the query request information, and generating a target analysis result file; and generating a target chart according to the target analysis result file, wherein the target chart is used for displaying target analysis result data to the target object.
According to another aspect of the embodiment of the present invention, there is also provided a report processing apparatus, including: the system comprises an acquisition module, a storage module and a storage module, wherein the acquisition module is used for acquiring a report file to be analyzed, the report file to be analyzed comprises a plurality of reports to be analyzed, and the reports to be analyzed comprise performance data of target equipment; the determining module is used for determining at least one target report to be analyzed from the multiple reports to be analyzed according to a first analysis condition, wherein the first analysis condition comprises at least one of the following: report generation date, report type and report version; the processing module is used for determining a target analysis rule corresponding to at least one target report to be analyzed, and analyzing the at least one target report to be analyzed according to the target analysis rule to obtain an analysis result, wherein the analysis result represents the performance condition of target equipment.
According to another aspect of the embodiments of the present invention, there is also provided a computer readable storage medium having a computer program stored therein, wherein the computer program is configured to execute the report processing method described above when running.
According to another aspect of an embodiment of the present invention, there is also provided an electronic device including one or more processors; and a memory for storing one or more programs which, when executed by the one or more processors, cause the one or more processors to implement a method for running the programs, wherein the programs are configured to perform the report processing method described above when run.
In the embodiment of the invention, a mode of automatically analyzing report performance data is adopted, a report file to be analyzed is firstly obtained, then at least one target report to be analyzed is determined from a plurality of reports to be analyzed according to a first analysis condition, then a target analysis rule corresponding to the at least one target report to be analyzed is determined, and analysis processing is carried out on the at least one target report to be analyzed according to the target analysis rule, so that an analysis result is obtained. The report file to be analyzed comprises a plurality of reports to be analyzed, the reports to be analyzed comprise performance data of target equipment, and the first analysis condition comprises at least one of the following: the report forms generate date, report forms type and report forms version, and the analysis results represent the performance condition of the target equipment.
In the process, a data basis is provided for subsequent analysis processing by acquiring the report file to be analyzed; according to the first analysis condition, at least one target to-be-analyzed report can be determined from a plurality of to-be-analyzed reports, so that target analysis rules corresponding to the at least one target to-be-analyzed report can be determined, further, the at least one target to-be-analyzed report can be analyzed according to the target analysis rules, labor cost and time cost are saved, the processing efficiency of the report analysis processing is improved, the accuracy of the report analysis processing is improved, the reliability of a system is improved, the requirement of a user for timely acquiring accurate performance analysis reports can be well met, and convenience is provided for the user to carry out the report analysis processing.
Therefore, the technical scheme of the invention achieves the aim of reducing the labor cost and the time cost of report analysis processing, thereby realizing the technical effect of improving the processing efficiency of report analysis processing, and further solving the technical problem of low processing efficiency in the prior art by manually collecting and analyzing report data.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this application, illustrate embodiments of the invention and together with the description serve to explain the invention and do not constitute a limitation on the invention. In the drawings:
FIG. 1 is a flow chart of an alternative report processing method according to an embodiment of the invention;
FIG. 2 is a schematic diagram of an alternative report processing system in accordance with an embodiment of the invention;
FIG. 3 is a flowchart of an alternative implementation of PM report uploading in accordance with an embodiment of the invention;
FIG. 4 is a flowchart of an alternative implementation of PM report parsing in accordance with an embodiment of the invention;
FIG. 5 is an alternative PM report specific resolution flow diagram in accordance with an embodiment of the invention;
FIG. 6 is a flowchart of an implementation of an alternative PM report agile secondary development deployment in accordance with an embodiment of the invention;
FIG. 7 is a modified flow diagram of an alternative index module and resolution module in secondary development according to an embodiment of the invention;
FIG. 8 is an alternative PM report parsing result query flow diagram in accordance with an embodiment of the invention;
FIG. 9 is a flowchart of an alternative implementation of PM report one-touch export in accordance with an embodiment of the invention;
FIG. 10 is a schematic diagram of an alternative report processing apparatus according to an embodiment of the invention;
fig. 11 is a schematic diagram of an alternative electronic device according to an embodiment of the invention.
Detailed Description
In order that those skilled in the art will better understand the present invention, a technical solution in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in which it is apparent that the described embodiments are only some embodiments of the present invention, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the present invention without making any inventive effort, shall fall within the scope of the present invention.
It should be noted that the terms "first," "second," and the like in the description and the claims of the present invention and the above figures are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments of the invention described herein may be implemented in sequences other than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
It should be noted that, the related information (including, but not limited to, user equipment information, user personal information, etc.) and data (including, but not limited to, data for presentation, analyzed data, etc.) related to the present invention are information and data authorized by the user or sufficiently authorized by each party. For example, an interface is provided between the system and the relevant user or institution, before acquiring the relevant information, the system needs to send an acquisition request to the user or institution through the interface, and acquire the relevant information after receiving the consent information fed back by the user or institution.
Example 1
In accordance with an embodiment of the present invention, there is provided an embodiment of a report processing method, it being noted that the steps shown in the flowchart of the figures may be performed in a computer system such as a set of computer executable instructions, and, although a logical order is shown in the flowchart, in some cases, the steps shown or described may be performed in an order other than that shown or described herein.
FIG. 1 is a flow chart of an alternative report processing method according to an embodiment of the invention, as shown in FIG. 1, the method comprising the steps of:
step S101, a report file to be analyzed is obtained, wherein the report file to be analyzed comprises a plurality of reports to be analyzed, and the reports to be analyzed comprise performance data of target equipment;
Step S102, determining at least one target report to be analyzed from a plurality of reports to be analyzed according to a first analysis condition, wherein the first analysis condition comprises at least one of the following: report generation date, report type and report version;
step S103, determining a target analysis rule corresponding to at least one target report to be analyzed, and analyzing the at least one target report to be analyzed according to the target analysis rule to obtain an analysis result, wherein the analysis result represents the performance condition of target equipment.
Specifically, in the step S101, the report file to be analyzed may be obtained through an application system, a processor, an electronic device, and other devices. Alternatively, the report file to be analyzed is obtained through a report processing system, the report to be analyzed can be a performance monitoring report (PM report) of DB2, and the target device can be a large-scale host. The PM report of DB2 comprises two types of ACCOUNTING report and STAT report, wherein the ACCOUNTING report focuses on analysis of the number of database data manipulation languages (Data Manipulation Language, DMLs) and the processing performance of the DMLs, and the STAT report focuses on analysis of the consumption performance of resources such as a database CPU and a memory. Alternatively, the performance data may be DML processing performance data, CPU performance data, memory performance data, and the like.
FIG. 2 is a schematic diagram of an alternative report processing system according to an embodiment of the invention, as shown in FIG. 2, including a PM report performance automatic analysis requesting device (D1), a PM report performance automatic analysis result storing device (D2), and a PM report performance automatic analysis responding device (D3). The D1 comprises a PM report uploading request module, a PM report one-key analysis request module, a multi-dimensional analysis chart display request module of a webpage end, a chart one-key archiving request module and an agile development request module; d2 comprises a definition module of index field types, a read-write module of analysis results and an analysis method module under various DB2 product versions; and D3, a report storage module, an analysis module, a response module and a newly added demand module. The analysis method module under various DB2 product versions comprises an index field type definition module version and an analysis module version under a certain DB2 version.
Optionally, in this embodiment, the report processing system is formed by a VUE front-end scaffold, a MYSQL database, and a full stack structure for data processing at a PYTHON back-end, where the foregoing functional module of D1 is implemented by the VUE front-end, the foregoing functional module of D2 is implemented by the MYSQL database, and the foregoing functional module of D3 is implemented by using PYTHON at the back-end.
Alternatively, in this embodiment, the above modules are linked with each other, so that the following functional points may be implemented:
function 1: when a user triggers a front-end webpage to request a PM report uploading function, a back-end response module links a designated URL to a report storage module and stores report files into a back-end temporary directory;
function 2: when a user designates PM report generation date and a DB2 product version to trigger a front-end webpage to request a PM report one-key analysis function, a back-end response module finishes report analysis by an analysis module of designating a URL linkage response DB2 product version, and stores an analysis result into a MYSQL storage device according to a data type linkage analysis result writing module of an index field type definition module, and after analysis is finished, a scheduling report storage module deletes the PM report in a temporary directory;
function 3: when a user designates items such as dimension, PM report generation date, DB2 product version, index name or table name and the like and triggers a front-end webpage to request a multi-dimension analysis chart display function, a back-end response module takes the designated URL and the response item as a joint main key, a linkage analysis result reading function outputs analysis data to be displayed, the analysis data is returned to the front-end webpage through the URL, and the front-end webpage finishes rendering of the analysis data by utilizing a chart drawing component;
Function 4: when a user designates two types of items of PM report generation date and DB2 product version and triggers a front-end webpage to request a chart one-key archiving function, a back-end response module combines the designated URL with the designated item, a WORD template is archived through the chart, an analysis result reading function is linked, and the front-end docxtemplate, a file-saver and other components are utilized to complete one-key generation of analysis report archiving forms of original analysis data.
Function 5: when the version of the DB2 product is updated to influence the PM performance report format of the DB2 product and change the index screening rules or index number, a user designates the version of the DB2 product, triggers a front-end webpage request agility development function, a rear-end response module completes index modification by linking a designated URL with a newly-added demand module, a definition module and an analysis module of a scheduling index field type complete synchronous modification after the work of the newly-added demand module is completed, and the modified version is stored in a data table of an analysis method module under various DB2 product versions.
The implementation flow of the above functions will be specifically described below.
FIG. 3 is a flowchart of an alternative implementation of PM report uploading according to an embodiment of the invention, as shown in FIG. 3, the implementation flow for function 1 (PM report uploading) specifically includes the following steps:
Step S201, remotely logging in the large host server terminal, downloading the PM report of the DB2 product to a local path, and modifying the current file name to be 'scene name + original file name'. By file name it can be specified what scene each file was generated from, e.g. original file name D221021, scene reference scene, modified file name scene1_base+d221021.
In an alternative embodiment, in the process of acquiring the report file to be analyzed, firstly, acquiring a plurality of initial reports associated with the target device, then adding corresponding scene identifiers to names of the plurality of initial reports according to scene information corresponding to the plurality of initial reports to obtain a plurality of report files to be analyzed, and then generating the report file to be analyzed according to the plurality of report files to be analyzed.
Optionally, the PM report file (i.e., multiple initial reports associated with the large-scale host) is downloaded to the local from the large-scale host server, and then corresponding scene identifiers are added to the names of the multiple initial reports according to the scene information corresponding to the multiple initial reports, so as to obtain multiple reports to be analyzed (i.e., reports after modifying the names), i.e., modifying the current file name to be "scene name+original file name", for example, the original file name is D221021, the scene is a reference scene, and the modified file name is scene1_base+d221021. Further, generating a report file to be analyzed according to the multiple reports to be analyzed.
Step S202, a user triggers a PM report uploading function, and the front end calls an el-uploading component to request the uploaded file to be in a format of formdata through a designated URL to request a back end report file storage service.
Step S203, after the rear end receives the front end request, the format data transmitted by the front end is converted into a UTF-8 format file through a designated URL.
And step S204, saving the UTF-8 format file to a temporary storage directory of the report original file appointed by the rear end.
In an alternative embodiment, after the report file to be analyzed is obtained, format conversion processing is performed on the report file to be analyzed, a converted report file to be analyzed is obtained, and the converted report file to be analyzed is stored in the first catalog.
Alternatively, the first directory may be a temporary directory. After receiving a PM report uploading request triggered by a target object (namely a user), the front end uploads the PM report from a local path and stores the PM report in a report original file temporary storage directory appointed by the rear end. Optionally, format conversion processing is performed on the report file to be analyzed, for example, format data input from the front end is converted into a file with UTF-8 format, the converted report file to be analyzed is obtained, the converted report file to be analyzed is stored in a temporary directory, namely, the file with UTF-8 format is stored under a temporary storage directory of a report original file appointed by the rear end.
Specifically, in the foregoing steps S102 and S103, the first analysis condition may be an analysis condition generated according to a report generation date, a report type, and a report version in the analysis request of the user, and according to the first analysis condition, at least one target report to be analyzed may be determined from a plurality of reports to be analyzed, for example, the report generation date is X years, X months, and X days, the report type is an active report, and the report version is DB 2.0 version.
FIG. 4 is a flowchart of an implementation of an alternative PM report parsing according to an embodiment of the invention, as shown in FIG. 4, the implementation of the function 2 (PM report parsing) specifically includes the following steps:
in step S301, the front end uses the el-dialog component to make a form, and the content of the made form includes "PM report creation date", "PM report type", and "DB2 product version".
Step S302, before analysis, a user touches a form button, fills in the contents of PM report generation date, PM report type and DB2 product version, and clicks to confirm.
Step S303, the user triggers a report analysis function, and the report content is transmitted to the back end through the designated URL and requests a back end report analysis service.
Step S304, the rear end receives the front end form content, confirms the report analysis mode, analyzes the report file under the temporary storage directory, and splits the report file name under the temporary storage directory to extract the scene name. Determining at least one target to-be-analyzed report form from the multiple report forms to be analyzed according to the first analysis condition, determining a target analysis rule corresponding to the at least one target to-be-analyzed report form, and analyzing the at least one target to-be-analyzed report form according to the target analysis rule to obtain an analysis result. Optionally, under the condition that the DB2 product version is not specified, using the DB2 version defaulted for the first time, the analysis modes of other DB2 product versions can be generated by agile secondary development, and the report analysis methods corresponding to different types of PM reports are different.
In step S305, after the back-end parsing is completed, the received front-end form content, scene name and parsing result field are stored in a memory table of the MYSQL memory device.
Step S306, deleting the report file which is uploaded to the temporary storage directory at the rear end by the front end.
By the aid of the process, labor cost and time cost are saved, processing efficiency of report analysis processing is improved, accuracy of report analysis processing is improved, and accordingly reliability of the system is improved.
Based on the above-mentioned schemes defined in step S101 to step S103, it can be known that, in the embodiment of the present invention, a manner of automatically analyzing report performance data is adopted, a report file to be analyzed is first obtained, then at least one target report to be analyzed is determined from a plurality of reports to be analyzed according to a first analysis condition, then a target analysis rule corresponding to the at least one target report to be analyzed is determined, and analysis processing is performed on the at least one target report to be analyzed according to the target analysis rule, so as to obtain an analysis result. The report file to be analyzed comprises a plurality of reports to be analyzed, the reports to be analyzed comprise performance data of target equipment, and the first analysis condition comprises at least one of the following: the report forms generate date, report forms type and report forms version, and the analysis results represent the performance condition of the target equipment.
It is easy to notice that in the process, a data basis is provided for the subsequent analysis processing by acquiring the report file to be analyzed; according to the first analysis condition, at least one target to-be-analyzed report can be determined from a plurality of to-be-analyzed reports, so that target analysis rules corresponding to the at least one target to-be-analyzed report can be determined, further, the at least one target to-be-analyzed report can be analyzed according to the target analysis rules, labor cost and time cost are saved, the processing efficiency of the report analysis processing is improved, the accuracy of the report analysis processing is improved, the reliability of a system is improved, the requirement of a user for timely acquiring accurate performance analysis reports can be well met, and convenience is provided for the user to carry out the report analysis processing.
Therefore, the technical scheme of the invention achieves the aim of reducing the labor cost and the time cost of report analysis processing, thereby realizing the technical effect of improving the processing efficiency of report analysis processing, and further solving the technical problem of low processing efficiency in the prior art by manually collecting and analyzing report data.
In an alternative embodiment, the report type includes at least one of: the method comprises the steps of obtaining a rule data table of an analysis rule corresponding to a report version in the process of determining a target analysis rule corresponding to at least one target report to be analyzed, inquiring target data corresponding to the report type from the rule data table, and performing splicing processing on the target data to obtain the target analysis rule, wherein the target data comprises at least one of the following: the name of the performance data, the data type of the performance data and the analysis rule data, and the analysis rule data represents the analysis mode of the performance data.
Optionally, the first type report may be an ACCOUNTING report, and the second type report may be a STAT report, so that the names, types and analysis rules of the analysis indexes are different due to different emphasis points of the report contents.
FIG. 5 is an optional PM report specific resolution flowchart according to an embodiment of the invention, as shown in FIG. 5, specifically comprising the following steps:
step S401, according to the parameter of the 'DB 2 product version' acquired from the front end, the data table of the index definition and analysis mode module under the corresponding version (namely, the rule data table for acquiring the analysis rule corresponding to the report version) is called, and according to the parameter of the 'PM report type' acquired from the front end, the corresponding index in the data table and the record of the index type and analysis rule thereof (namely, the target data corresponding to the report type is queried from the rule data table).
And step S402, polling the query records obtained in the step S401 to obtain all index performance values, namely, performing splicing processing on the target data to obtain a target analysis rule. Specifically, a record is taken out and spliced to obtain an index performance value, for example, an index name (i.e. the name of performance data) is a CPU, a data type (i.e. the data type of performance data) is a floating point type, analysis rule data is line_data [ i+2] [15:25] (i.e. each line of a file is converted into a list format), a target analysis rule obtained through splicing processing is cpu=float (line_data [ i+2] [15:25 ]), wherein i is a line number, a first bracket represents the line number of the line, a second bracket represents the column number of the line, and other recording processing modes are the same, and all performance index data are obtained after all recording polling is completed.
Step S403, reading a report file under the temporary storage directory at the rear end, and acquiring the scene name of the report file according to step S304.
In step S404, the above contents ("PM report generation date", "PM report type", "DB2 product version", "scene name", "MEMBER name", "corresponding performance index value") are put into the MYSQL storage table. Optionally, if the PM report type is an ACCOUNTING type, placing the PM report type in an ACCOUNTING data table; if the PM report type is the STAT type, the PM report type is put into a STAT data table.
It should be noted that, by performing the splicing processing on the target data, the target analysis rule can be obtained, and a data base is provided for the subsequent data analysis, so that the accuracy of the report analysis processing can be improved, and the error rate can be reduced.
In an alternative embodiment, in the process of analyzing at least one target report to be analyzed according to the target analysis rule to obtain an analysis result, the target performance data is determined from the performance data of the at least one target report to be analyzed according to the name of the performance data and the data type of the performance data, and then the target performance data is analyzed according to the analysis rule data to obtain the analysis result.
Optionally, according to the name of the performance data and the data type of the performance data, the target performance data may be determined from the performance data of at least one target report to be analyzed, for example, the name of the performance data is a CPU, the data type of the performance data is a floating point type, and then the CPU performance data of the target performance data is a floating point type may be determined from the performance data such as the DML processing performance data, the CPU performance data, the memory performance data, and the like.
Further, according to the analysis rule data, the target performance data is analyzed to obtain an analysis result, for example, the analysis rule data is line_data [ i+2] [15:25] (i.e. each line of the file is converted into a list format), and the floating point type CPU performance data is analyzed to obtain a corresponding CPU resource performance consumption condition, so that the analysis result is obtained.
It should be noted that, by performing analysis processing on the target performance data to obtain an analysis result, the processing efficiency of report analysis processing is improved, and then the required PM report performance analysis data can be obtained by screening and filtering according to dimensions (index level or table level), PM report generation date, DB2 product version, index name or table name, etc., so that the requirement of a user for timely obtaining an accurate performance analysis report is well met, and convenience is provided for the user to perform report analysis processing.
In an alternative embodiment, before determining at least one target report to be analyzed from the multiple reports to be analyzed according to the first analysis condition, editing request information in the first target request is acquired under the condition that the first target request is received, and then a first analysis rule is generated according to the editing request information. Wherein the first target request is one of: adding an editing request and modifying the editing request, wherein editing request information characterizes editing information of the analysis rule.
Alternatively, the first target request may be a secondary development request, that is, an additional editing request or a modification editing request, and the first parsing rule may be a new parsing rule obtained by additional editing or modification editing.
Fig. 6 is a flowchart of an implementation of an alternative smart secondary development deployment of a PM report according to an embodiment of the invention, and as shown in fig. 6, the implementation flow for the function 5 (smart secondary development deployment) specifically includes the following steps:
in step S501, the front end uses the el-dialog component to make a secondary development requirement form, and makes a form entry including "DB2 product version, report type (ACCOUNTING or STAT), adds an index name, an index type, and an parsing rule, and specifies an index name to modify the index name, the index type, and the parsing rule.
Step S502, before deploying the agile secondary development function, namely adding the report analysis mode, a user touches a form button, edits corresponding items according to requirements, clicks confirmation, and the front end transmits the required items to the rear end through the designated URL.
In step S503, the back end receives the requirement entry (i.e. obtains the editing request information in the first target request in case of receiving the first target request), and processes (i.e. generates the first parsing rule according to the editing request information) the requirement entry is received from the front end, firstly creates a field with the same name and a parsing mode data table for the DB2 product version, secondly copies the initial index definition module, modifies the index definition module according to the added or modified index name or type, and finally modifies the created parsing mode module according to the requirement of the newly added or modified field screening rule.
Step S504, the new analysis mode is completed through the steps, when the user invokes the report analysis function, the analysis module under the corresponding version can be invoked by selecting the DB2 product version and the report type (ACCOUNTING or STAT), and the analysis result is also stored in the data table under the corresponding version.
In the process, the agile deployment function of secondary development is realized, and when indexes are changed, development requirements are added through web pages, so that the PM report analysis mode can be newly increased and online, and the use requirements of users are better met.
In an alternative embodiment, the edit request information includes at least one of: the method comprises the steps of generating a first target data table according to a first report type and a first report version, acquiring the first target data from a database according to the name of the first performance data and the data type of the first performance data, storing the first target data in the first target data table, and then adding the first analysis rule data in the first target data table to generate the first analysis rule in the process of generating the first analysis rule according to edit request information, if the first target request is a new edit request.
In an alternative embodiment, in the process of generating the first analysis rule according to the edit request information, if the first target request is a modification edit request, a second target data table is generated according to the first report type and the first report version, then the first target data is obtained from the database according to the name of the first performance data and the data type of the first performance data, the first target data is stored in the second target data table, and then the analysis rule corresponding to the first target data is updated according to the first analysis rule data in the second target data table, so as to generate the first analysis rule.
FIG. 7 is a flowchart of a modification of the index module and the resolution module in an alternative secondary development according to an embodiment of the present invention, and as shown in FIG. 7, the modification process specifically includes the following steps:
step S601, according to the DB2 product version item (namely the first report version) in the secondary development requirement, creating a data table with the same name for storing the modified index definition and analysis mode module, namely creating a data table with the same name of the report corresponding to the version. Optionally, if the first target request is a new editing request, generating a first target data table (i.e., a data table corresponding to the new editing request) according to the first report type (ACCOUNTING or STAT) and the first report version; if the first target request is a modification editing request, a second target data table (namely, a data table corresponding to the modification editing request) is generated according to the first report type and the first report version.
In step S602, when the secondary development requirement function is triggered, the content of the initial data table (i.e. the data table storing the initial index definition and parsing mode module) and the parsing mode (i.e. the first parsing rule data, i.e. the field filtering rule, e.g. the value of a certain index is in several columns of data containing a certain key) are copied (i.e. the name of the first performance data, the data type of the first performance data, e.g. the name of the first performance data is CPU, the data type of the performance data is floating point type, numeric type or string type) into the newly added data table (i.e. the first target data table or the second target data table). Optionally, if the first target request is a new editing request, acquiring the first target data from the database according to the name of the first performance data and the data type of the first performance data, and storing the first target data in a first target data table; if the first target request is a modification editing request, the first target data is obtained from a database according to the name of the first performance data and the data type of the first performance data, and the first target data is stored in a second target data table.
Step S603, if the requirement of the secondary development is a new index (i.e. if the first target request is a new editing request), a row of records is newly added in the data table (i.e. the first target data table) obtained in step S602 by using an SQL statement, for example insert into tablename (name, kind, rule) values (new index name, new index name type, new index screening rule), where table= 'counting'), i.e. the new insertion of the index definition and the analysis mode data table thereof (i.e. the new first analysis rule data is added in the first target data table, and the first analysis rule is generated); if the requirement of the secondary development is the requirement of modifying the original index (i.e. if the first target request is a modification editing request), the record to be modified is updated after filtering (for example, update tablename set kind =modify index name type, rule=index filtering rule table= 'counting' and name=modify index name), and the update of index definition and modification of the parsing mode is completed (i.e. in the data table (i.e. the second target data table) obtained in step S602, the parsing rule corresponding to the first target data is updated according to the first parsing rule data, and the first parsing rule is generated).
In step S604, when the report parsing function is invoked, definition and numerical screening rules of the index in the corresponding data table are filtered out through the DB2 product version and report type (ACCOUNTING or STAT), and the final parsing result is obtained.
In the process, the agile deployment function of secondary development is realized, and when indexes are changed, development requirements are added through web pages, so that the PM report analysis mode can be newly increased and online, and the use requirements of users are better met.
In an alternative embodiment, before determining a target analysis rule corresponding to at least one target report to be analyzed, and analyzing the at least one target report to be analyzed according to the target analysis rule to obtain an analysis result, acquiring query request information in a second target request under the condition that the second target request is received, acquiring target analysis result data from a database according to the query request information, generating a target analysis result file, and generating a target chart according to the target analysis result file. The target chart is used for displaying target analysis result data to the target object, and the query request information comprises at least one of the following components: the target report generation date, the target report type, the target report version and the name of the target performance data.
Optionally, the second target request may be a query request, and the target analysis result data may be data determined according to query request information such as a target report generation date, a target report type, a target report version, a name of target performance data, and the like.
FIG. 8 is an alternative PM report parsing result query flow diagram according to an embodiment of the invention, as shown in FIG. 8, the implementation flow for function 3 (report parsing result query) specifically includes the following steps:
in step S701, the front end uses the el-form component to make a filtering item, where the filtering item content includes "filtering dimension (index level or table level), PM report generation date, DB2 product version, index name or table name".
In step S702, the front end is set in the early warning rule of each performance index under multiple scenes, the early warning rule includes two types, namely, threshold warning and trend warning, and the threshold warning priority is higher than the trend warning, wherein the threshold warning indicates that when a certain type of performance index exceeds a set value under a certain scene, a bar graph (or a line graph, etc.) displayed on the graph is red, and when a numerical value of a certain type of performance index under multiple scenes presents an ascending trend, the bar graph (or the line graph, etc.) displayed on the graph is orange.
Step S703, before screening, the user fills in the screening item (i.e. the query request information, including at least one of the target report generation date, the target report type, the target report version, and the name of the target performance data) in the front-end Web page, and triggers the query function.
Step S704, after the query function is triggered, the filtering item is transmitted to the back end through the designated URL, and the MYSQL storage table record is acquired according to the filtering item serving as the filtering condition request back end (namely, under the condition that the second target request is received, the query request information in the second target request is acquired, and then the target analysis result data is acquired from the database according to the query request information).
Step S705, each record format is "field name: the dictionary format of the field value ", the obtained plurality of records form a list type (namely, the target analysis result file is generated) and return to the front end.
In step S706, the front end uses the echart component to draw an analysis chart of the report (i.e. generate a target chart according to the target analysis result file), the data returned to the front end contains a plurality of scene data at the index level or at the table level, the processed data uses the field name as the abscissa and the field value as the ordinate, and a plurality of columns or fold lines are drawn according to the scene type for comparison analysis, and the multi-scene data returned to the front end through the rear end is displayed for early warning (refer to step S702 specifically).
FIG. 9 is a flowchart of an alternative implementation of one-touch export of PM reports according to an embodiment of the invention, as shown in FIG. 9, the implementation for function 4 (one-touch export of reports) specifically includes the following steps:
In step S801, the front end uses the el-form component to make a screening item, where the content of the screening item includes "PM report generation date, DB2 product version", and in the analysis PM report, the account and STAT reports are simultaneously analyzed, and under one date and DB2 product version, an analysis chart of the account and STAT is generated.
Before one-key export, the user fills in the filter item in the front end Web page to trigger the one-key export function, step 802.
Step S803, after triggering, the screening item is transmitted to the back end through the designated URL, and the back end requests the back end database to acquire all data (including index level and table level) meeting the conditions according to the screening item as a filtering condition.
In step S804, each record format is "field name: the dictionary format of the field value ", the acquired plurality of records form a list type and return to the front end.
In step S805, the front end creates a WORD empty file in the static file, draws the data into a multi-scenario comparison chart form and an early warning display by using echart, docxtemplater and file-saver components (refer to step S702 specifically), and files the data as files for returning to the user.
It should be noted that in this embodiment, a performance automatic analysis method based on a large-scale host DB2 product PM report is provided, and by means of interaction between the back end and the front end, it is convenient for a user to provide various processing functions for the PM report in view of the front end WEB page; through the one-key triggering instruction, PM report analysis, result query and archiving functions are realized, analysis processing efficiency of DB2 product performance data is effectively improved, time cost and labor cost are saved, and requirements of a data analysis process on experience and technical level of a user are reduced. In addition, in the embodiment, the agile deployment function of secondary development can be realized, for example, when indexes are changed, development requirements are added through web pages, so that the PM report analysis mode can be newly increased and online, and the use requirements of users can be better met.
Therefore, the technical scheme of the invention achieves the aim of reducing the labor cost and the time cost of report analysis processing, thereby realizing the technical effect of improving the processing efficiency of report analysis processing, and further solving the technical problem of low processing efficiency in the prior art by manually collecting and analyzing report data.
Example 2
According to an embodiment of the present invention, there is provided an embodiment of a report processing apparatus, wherein fig. 10 is a schematic diagram of an alternative report processing apparatus according to an embodiment of the present invention, as shown in fig. 10, the apparatus includes: the obtaining module 1001 is configured to obtain a report file to be analyzed, where the report file to be analyzed includes a plurality of reports to be analyzed, and the plurality of reports to be analyzed includes performance data of the target device; the determining module 1002 is configured to determine at least one target report to be analyzed from the multiple reports to be analyzed according to a first parsing condition, where the first parsing condition includes at least one of: report generation date, report type and report version; and the processing module 1003 is configured to determine a target parsing rule corresponding to the at least one target to-be-parsed report, and parse the at least one target to-be-parsed report according to the target parsing rule to obtain a parsing result, where the parsing result characterizes a performance condition of the target device.
It should be noted that the above-mentioned obtaining module 1001, determining module 1002, and processing module 1003 correspond to steps S101 to S103 in the above-mentioned embodiment, and the three modules are the same as examples and application scenarios implemented by the corresponding steps, but are not limited to those disclosed in the above-mentioned embodiment 1.
Optionally, the acquiring module includes: the first acquisition module is used for acquiring a plurality of initial reports associated with the target equipment; the first processing module is used for adding corresponding scene identifiers to the names of the plurality of initial reports according to the scene information corresponding to the plurality of initial reports to obtain a plurality of reports to be analyzed; and the second processing module is used for generating report files to be analyzed according to the multiple reports to be analyzed.
Optionally, the report type includes at least one of: the first type and the second type, the performance data corresponding to the first type and the second type are different, and the processing module comprises: the second acquisition module is used for acquiring a rule data table of the analysis rule corresponding to the report version; the third processing module is used for inquiring target data corresponding to the report type from the rule data table and performing splicing processing on the target data to obtain a target analysis rule, wherein the target data comprises at least one of the following: the name of the performance data, the data type of the performance data and the analysis rule data, and the analysis rule data represents the analysis mode of the performance data.
Optionally, the processing module further includes: the first determining module is used for determining target performance data from the performance data of at least one target report to be analyzed according to the name of the performance data and the data type of the performance data; and the fourth processing module is used for carrying out analysis processing on the target performance data according to the analysis rule data to obtain an analysis result.
Optionally, the report processing device further includes: and the fifth processing module is used for carrying out format conversion processing on the report file to be analyzed to obtain a converted report file to be analyzed, and storing the converted report file to be analyzed into the first catalog.
Optionally, the report processing device further includes: the third acquisition module is used for acquiring editing request information in the first target request under the condition that the first target request is received, wherein the first target request is one of the following: adding an editing request and modifying the editing request, wherein editing request information characterizes editing information of an analysis rule; and the sixth processing module is used for generating a first analysis rule according to the editing request information.
Optionally, the editing request information includes at least one of: the sixth processing module includes: the seventh processing module is used for generating a first target data table according to the first report type and the first report version if the first target request is a new editing request; the fourth acquisition module is used for acquiring first target data from the database according to the name of the first performance data and the data type of the first performance data and storing the first target data in a first target data table; and the eighth processing module is used for adding the first analysis rule data in the first target data table to generate a first analysis rule.
Optionally, the sixth processing module further includes: the ninth processing module is used for generating a second target data table according to the first report type and the first report version if the first target request is a modification editing request; a fifth acquisition module, configured to acquire first target data from the database according to the name of the first performance data and the data type of the first performance data, and store the first target data in a second target data table; and the tenth processing module is used for updating the analysis rule corresponding to the first target data according to the first analysis rule data in the second target data table to generate a first analysis rule.
Optionally, the report processing device further includes: a sixth obtaining module, configured to obtain, when the second target request is received, query request information in the second target request, where the query request information includes at least one of: the target report generation date, the target report type, the target report version and the name of the target performance data; the seventh acquisition module is used for acquiring target analysis result data from the database according to the query request information to generate a target analysis result file; and the eleventh processing module is used for generating a target chart according to the target analysis result file, wherein the target chart is used for displaying target analysis result data to the target object.
Example 3
According to another aspect of the embodiments of the present invention, there is also provided a computer readable storage medium having a computer program stored therein, wherein the computer program is configured to execute the report processing method described above when running.
Example 4
According to another aspect of the embodiments of the present invention, there is also provided an electronic device, wherein fig. 11 is a schematic diagram of an alternative electronic device according to an embodiment of the present invention, as shown in fig. 11, the electronic device including one or more processors; and a memory for storing one or more programs which, when executed by the one or more processors, cause the one or more processors to implement a method for running the programs, wherein the programs are configured to perform the report processing method described above when run. The processor when executing the program implements the following steps: obtaining a report file to be analyzed, wherein the report file to be analyzed comprises a plurality of reports to be analyzed, and the reports to be analyzed comprise performance data of target equipment; determining at least one target report to be analyzed from a plurality of reports to be analyzed according to a first analysis condition, wherein the first analysis condition comprises at least one of the following: report generation date, report type and report version; determining a target analysis rule corresponding to at least one target report to be analyzed, and analyzing the at least one target report to be analyzed according to the target analysis rule to obtain an analysis result, wherein the analysis result represents the performance condition of target equipment.
Optionally, the processor when executing the program further implements the following steps: acquiring a plurality of initial reports associated with target equipment; adding corresponding scene identifiers to names of the plurality of initial reports according to scene information corresponding to the plurality of initial reports to obtain a plurality of reports to be analyzed; and generating a report file to be analyzed according to the multiple reports to be analyzed.
Optionally, the report type includes at least one of: the first type and the second type are different in corresponding performance data, and the processor further realizes the following steps when executing the program: acquiring a rule data table of an analysis rule corresponding to the report version; inquiring target data corresponding to the report type from a rule data table, and performing splicing processing on the target data to obtain a target analysis rule, wherein the target data comprises at least one of the following: the name of the performance data, the data type of the performance data and the analysis rule data, and the analysis rule data represents the analysis mode of the performance data.
Optionally, the processor when executing the program further implements the following steps: determining target performance data from the performance data of at least one target report to be analyzed according to the name of the performance data and the data type of the performance data; and analyzing the target performance data according to the analysis rule data to obtain an analysis result.
Optionally, the processor when executing the program further implements the following steps: after the report file to be analyzed is obtained, carrying out format conversion processing on the report file to be analyzed to obtain a converted report file to be analyzed, and storing the converted report file to be analyzed into a first directory.
Optionally, the processor when executing the program further implements the following steps: before determining at least one target report to be analyzed from a plurality of reports to be analyzed according to a first analysis condition, acquiring editing request information in a first target request under the condition that the first target request is received, wherein the first target request is one of the following: adding an editing request and modifying the editing request, wherein editing request information characterizes editing information of an analysis rule; and generating a first analysis rule according to the editing request information.
Optionally, the edit request information includes at least one of: the first report type, the first report version, the name of the first performance data, the data type of the first performance data and the first analysis rule data, and the processor further realizes the following steps when executing the program: if the first target request is a new editing request, generating a first target data table according to the first report type and the first report version; according to the name of the first performance data and the data type of the first performance data, acquiring first target data from a database, and storing the first target data in a first target data table; and newly adding first analysis rule data in the first target data table to generate a first analysis rule.
Optionally, the processor when executing the program further implements the following steps: if the first target request is a modification editing request, generating a second target data table according to the first report type and the first report version; according to the name of the first performance data and the data type of the first performance data, acquiring first target data from a database, and storing the first target data in a second target data table; and in the second target data table, updating the analysis rule corresponding to the first target data according to the first analysis rule data to generate a first analysis rule.
Optionally, the processor when executing the program further implements the following steps: before determining a target analysis rule corresponding to at least one target report to be analyzed, and analyzing the at least one target report to be analyzed according to the target analysis rule to obtain an analysis result, acquiring query request information in a second target request under the condition that the second target request is received, wherein the query request information comprises at least one of the following components: the target report generation date, the target report type, the target report version and the name of the target performance data; acquiring target analysis result data from a database according to the query request information, and generating a target analysis result file; and generating a target chart according to the target analysis result file, wherein the target chart is used for displaying target analysis result data to the target object.
The device herein may be a server, PC, PAD, cell phone, etc.
The foregoing embodiment numbers of the present invention are merely for the purpose of description, and do not represent the advantages or disadvantages of the embodiments.
In the foregoing embodiments of the present invention, the descriptions of the embodiments are emphasized, and for a portion of this disclosure that is not described in detail in this embodiment, reference is made to the related descriptions of other embodiments.
In the several embodiments provided in the present application, it should be understood that the disclosed technology content may be implemented in other manners. The above-described embodiments of the apparatus are merely exemplary, and the division of the units, for example, may be a logic function division, and may be implemented in another manner, for example, a plurality of units or components may be combined or may be integrated into another system, or some features may be omitted, or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be through some interfaces, units or modules, or may be in electrical or other forms.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
In addition, each functional unit in the embodiments of the present invention may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units may be implemented in hardware or in software functional units.
The integrated units, if implemented in the form of software functional units and sold or used as stand-alone products, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied essentially or in part or all of the technical solution or in part in the form of a software product stored in a storage medium, including instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a removable hard disk, a magnetic disk, or an optical disk, or other various media capable of storing program codes.
The foregoing is merely a preferred embodiment of the present invention and it should be noted that modifications and adaptations to those skilled in the art may be made without departing from the principles of the present invention, which are intended to be comprehended within the scope of the present invention.
Claims (12)
1. A report processing method, comprising:
acquiring a report file to be analyzed, wherein the report file to be analyzed comprises a plurality of reports to be analyzed, and the reports to be analyzed comprise performance data of target equipment;
determining at least one target report to be analyzed from the multiple reports to be analyzed according to a first analysis condition, wherein the first analysis condition comprises at least one of the following: report generation date, report type and report version;
determining a target analysis rule corresponding to the at least one target report to be analyzed, and analyzing the at least one target report to be analyzed according to the target analysis rule to obtain an analysis result, wherein the analysis result represents the performance condition of the target equipment.
2. The method of claim 1, wherein obtaining the report file to be analyzed comprises:
Acquiring a plurality of initial reports associated with the target equipment;
adding corresponding scene identifiers to names of the plurality of initial reports according to scene information corresponding to the plurality of initial reports to obtain a plurality of reports to be analyzed;
and generating the report file to be analyzed according to the multiple reports to be analyzed.
3. The method of claim 1, wherein the report type comprises at least one of: the first type and the second type are different in performance data corresponding to the first type and the second type, wherein determining the target analysis rule corresponding to the at least one target report to be analyzed comprises the following steps:
acquiring a rule data table of an analysis rule corresponding to the report version;
inquiring target data corresponding to the report type from the rule data table, and performing splicing processing on the target data to obtain the target analysis rule, wherein the target data comprises at least one of the following: the method comprises the steps of name of performance data, data type of the performance data and analysis rule data, wherein the analysis rule data represents analysis modes of the performance data.
4. The method of claim 3, wherein parsing the at least one target report to be analyzed according to the target parsing rule to obtain a parsing result comprises:
Determining target performance data from the performance data of the at least one target report to be analyzed according to the name of the performance data and the data type of the performance data;
and according to the analysis rule data, analyzing the target performance data to obtain the analysis result.
5. The method of claim 1, wherein after obtaining the report file to be analyzed, the method further comprises:
and carrying out format conversion processing on the report file to be analyzed to obtain a converted report file to be analyzed, and storing the converted report file to be analyzed into a first catalog.
6. The method of claim 1, wherein prior to determining at least one target report to be analyzed from the plurality of reports to be analyzed according to a first parsing condition, the method further comprises:
acquiring editing request information in a first target request under the condition that the first target request is received, wherein the first target request is one of the following: adding an editing request and modifying the editing request, wherein the editing request information represents editing information of an analysis rule;
and generating a first analysis rule according to the editing request information.
7. The method of claim 6, wherein the edit request information includes at least one of: the first report type, the first report version, the name of the first performance data, the data type of the first performance data and the first analysis rule data, wherein the generating the first analysis rule according to the editing request information comprises the following steps:
if the first target request is the newly added editing request, a first target data table is generated according to the first report type and the first report version;
according to the name of the first performance data and the data type of the first performance data, first target data are obtained from a database, and the first target data are stored in the first target data table;
and newly adding the first analysis rule data in the first target data table to generate the first analysis rule.
8. The method of claim 7, wherein generating a first parsing rule based on the edit request information comprises:
if the first target request is the modification editing request, generating a second target data table according to the first report type and the first report version;
Acquiring the first target data from the database according to the name of the first performance data and the data type of the first performance data, and storing the first target data in the second target data table;
and in the second target data table, updating the analysis rule corresponding to the first target data according to the first analysis rule data, and generating the first analysis rule.
9. The method according to claim 1, wherein before determining a target parsing rule corresponding to the at least one target report to be parsed, and parsing the at least one target report to be parsed according to the target parsing rule, the method further comprises:
obtaining query request information in a second target request under the condition that the second target request is received, wherein the query request information comprises at least one of the following: the target report generation date, the target report type, the target report version and the name of the target performance data;
acquiring target analysis result data from a database according to the query request information, and generating a target analysis result file;
And generating a target chart according to the target analysis result file, wherein the target chart is used for displaying the target analysis result data to a target object.
10. A report processing apparatus, comprising:
the system comprises an acquisition module, a storage module and a storage module, wherein the acquisition module is used for acquiring a report file to be analyzed, the report file to be analyzed comprises a plurality of reports to be analyzed, and the reports to be analyzed comprise performance data of target equipment;
the determining module is used for determining at least one target report to be analyzed from the multiple reports to be analyzed according to a first analysis condition, wherein the first analysis condition comprises at least one of the following: report generation date, report type and report version;
the processing module is used for determining a target analysis rule corresponding to the at least one target report to be analyzed, and analyzing the at least one target report to be analyzed according to the target analysis rule to obtain an analysis result, wherein the analysis result represents the performance condition of the target equipment.
11. A computer readable storage medium, characterized in that the computer readable storage medium has stored therein a computer program, wherein the computer program is arranged to execute the report processing method of any of the claims 1 to 9 at run-time.
12. An electronic device, the electronic device comprising one or more processors; a memory for storing one or more programs that, when executed by the one or more processors, cause the one or more processors to implement a method for running a program, wherein the program is configured to perform the report processing method of any of claims 1 to 9 when run.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202310278980.0A CN116303462A (en) | 2023-03-21 | 2023-03-21 | Report processing method and device, storage medium and electronic equipment |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202310278980.0A CN116303462A (en) | 2023-03-21 | 2023-03-21 | Report processing method and device, storage medium and electronic equipment |
Publications (1)
Publication Number | Publication Date |
---|---|
CN116303462A true CN116303462A (en) | 2023-06-23 |
Family
ID=86802857
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202310278980.0A Pending CN116303462A (en) | 2023-03-21 | 2023-03-21 | Report processing method and device, storage medium and electronic equipment |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN116303462A (en) |
-
2023
- 2023-03-21 CN CN202310278980.0A patent/CN116303462A/en active Pending
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN110325961B (en) | Spreadsheet-based software application development | |
CN110908997B (en) | Data blood relationship construction method and device, server and readable storage medium | |
US9477786B2 (en) | System for metadata management | |
US8396894B2 (en) | Integrated repository of structured and unstructured data | |
US7546533B2 (en) | Storage and utilization of slide presentation slides | |
CN111819534A (en) | Spreadsheet-based software application development | |
US20140297680A1 (en) | Analyzing multiple data streams as a single data object | |
US20090327277A1 (en) | Methods and apparatus for reusing data access and presentation elements | |
US6915303B2 (en) | Code generator system for digital libraries | |
CN102314497B (en) | Method and equipment for identifying body contents of markup language files | |
AU2015331030A1 (en) | System generator module for electronic document and electronic file | |
JP7209306B2 (en) | Online work system for Excel documents based on templates | |
CN110990403A (en) | Business data storage method, system, computer equipment and storage medium | |
CN114218218A (en) | Data processing method, device and equipment based on data warehouse and storage medium | |
CN107748748B (en) | Full text retrieval system for water conservancy and hydropower technology standard | |
US20240036890A1 (en) | System and method of a modular framework for configuration and reuse of web components | |
US12039416B2 (en) | Facilitating machine learning using remote data | |
Sagalowicz | IDA: An intelligent data access program | |
CN113407678B (en) | Knowledge graph construction method, device and equipment | |
CN116303462A (en) | Report processing method and device, storage medium and electronic equipment | |
CN114707953A (en) | Main data full life cycle management method, system, engine and storage medium | |
Wiley | Essential system requirements: a practical guide to event-driven methods | |
CN111221846B (en) | Automatic translation method and device for SQL sentences | |
CN112258607B (en) | Slide rendering method and device and electronic equipment | |
JP2009003780A (en) | Module management method, module management device, module management system, and module management program |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination |