[go: up one dir, main page]

CN116303462A - Report processing method, device, storage medium and electronic equipment - Google Patents

Report processing method, device, storage medium and electronic equipment Download PDF

Info

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
Application number
CN202310278980.0A
Other languages
Chinese (zh)
Inventor
闫美阳
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Industrial and Commercial Bank of China Ltd ICBC
Original Assignee
Industrial and Commercial Bank of China Ltd ICBC
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Industrial and Commercial Bank of China Ltd ICBC filed Critical Industrial and Commercial Bank of China Ltd ICBC
Priority to CN202310278980.0A priority Critical patent/CN116303462A/en
Publication of CN116303462A publication Critical patent/CN116303462A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/30Monitoring
    • G06F11/34Recording 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/3466Performance evaluation by tracing or monitoring
    • G06F11/3476Data logging
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, administration or maintenance of databases
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2455Query execution
    • G06F16/24564Applying rules; Deductive queries
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/284Relational databases
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F2201/00Indexing scheme relating to error detection, to error correction, and to monitoring
    • G06F2201/80Database-specific techniques
    • YGENERAL 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
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02PCLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/30Computing 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

报表处理方法、装置、存储介质及电子设备Report processing method, device, storage medium and electronic equipment

技术领域technical field

本发明涉及金融科技领域,具体而言,涉及一种报表处理方法、装置、存储介质及电子设备。The present invention relates to the field of financial science and technology, in particular to a report processing method, device, storage medium and electronic equipment.

背景技术Background technique

IBM大型集成式主机具有高度集成、高可靠性以及强扩展性的特点,被广泛应用于处理大规模交易,大多数金融机构都使用大型主机处理核心业务,DB2(关系型数据库管理系统)作为主机系统的核心产品,在数据存储和交易响应方面具备稳定、及时的特点。IBM's large-scale integrated mainframe has the characteristics of high integration, high reliability and strong scalability, and is widely used to process large-scale transactions. Most financial institutions use large-scale mainframes to process core business, and DB2 (relational database management system) is used as the mainframe The core product of the system is stable and timely in terms of data storage and transaction response.

目前,大型主机DB2产品的性能监控报表(Performance Monitor,PM)的数据收集和分析,主要通过人工过滤和筛选报表文件、收集性能数据,并使用EXCEL等工具进行比较型图表分析,存在处理效率低、出错率大的问题,无法满足用户的使用时效,且数据分析过程对用户的经验和技术水平有较高的要求。At present, the data collection and analysis of the performance monitoring report (Performance Monitor, PM) of the mainframe DB2 product is mainly through manual filtering and screening of report files, collecting performance data, and using tools such as EXCEL for comparative chart analysis, which has low processing efficiency , The problem of high error rate cannot meet the user's time limit, and the data analysis process has high requirements for the user's experience and technical level.

针对上述的问题,目前尚未提出有效的解决方案。For the above problems, no effective solution has been proposed yet.

发明内容Contents of the invention

本发明实施例提供了一种报表处理方法、装置、存储介质及电子设备,以至少解决现有技术中通过人工收集和分析报表数据,存在处理效率低的技术问题。Embodiments of the present invention provide a report processing method, device, storage medium, and electronic equipment to at least solve the technical problem of low processing efficiency in the prior art through manual collection and analysis of report data.

根据本发明实施例的一个方面,提供了一种报表处理方法,包括:获取待分析报表文件,其中,待分析报表文件包括多个待分析报表,多个待分析报表包括目标设备的性能数据;根据第一解析条件,从多个待分析报表中确定至少一个目标待分析报表,其中,第一解析条件包括以下至少之一:报表生成日期、报表类型、报表版本;确定至少一个目标待分析报表对应的目标解析规则,并根据目标解析规则,对至少一个目标待分析报表进行解析处理,得到解析结果,其中,解析结果表征目标设备的性能情况。According to an aspect of an embodiment of the present invention, a report processing method is provided, including: obtaining a report file to be analyzed, wherein 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 a target device; According to the first analysis condition, at least one target report to be analyzed is determined from a plurality of reports to be analyzed, wherein the first analysis condition includes at least one of the following: report generation date, report type, report version; at least one target report to be analyzed is determined Corresponding target analysis rules, and according to the target analysis rules, at least one target report to be analyzed is analyzed and processed to obtain an analysis result, wherein the analysis result represents the performance of the target device.

进一步地,报表处理方法还包括:获取目标设备关联的多个初始报表;根据多个初始报表对应的场景信息,对多个初始报表的名称添加对应的场景标识,得到多个待分析报表;根据多个待分析报表,生成待分析报表文件。Further, the report processing method also includes: obtaining multiple initial reports associated with the target device; according to the scene information corresponding to the multiple initial reports, adding corresponding scene identifiers to the names of the multiple initial reports to obtain multiple reports to be analyzed; Multiple reports to be analyzed, generate report files to be analyzed.

进一步地,报表类型包括以下至少之一:第一类型、第二类型,第一类型和第二类型对应的性能数据不同,报表处理方法还包括:获取与报表版本对应的解析规则的规则数据表;从规则数据表中查询与报表类型对应的目标数据,并对目标数据进行拼接处理,得到目标解析规则,其中,目标数据包括以下至少之一:性能数据的名称、性能数据的数据类型、解析规则数据,解析规则数据表征对性能数据的解析方式。Further, the report type includes at least one of the following types: the first type and the second type, and the performance data corresponding to the first type and the second type are different, and the report processing method further includes: obtaining a rule data table of a parsing rule corresponding to the report version ;Query the target data corresponding to the report type from the rule data table, and splicing the target data to obtain the target parsing rules, wherein the target data includes at least one of the following: the name of the performance data, the data type of the performance data, the analysis Rule data, parsing rule data represents the way of parsing performance data.

进一步地,报表处理方法还包括:根据性能数据的名称和性能数据的数据类型,从至少一个目标待分析报表的性能数据中确定目标性能数据;根据解析规则数据,对目标性能数据进行解析处理,得到解析结果。Further, the report processing method further includes: according to the name of the performance data and the data type of the performance data, determining the target performance data from the performance data of at least one target report to be analyzed; analyzing and processing the target performance data according to the analysis rule data, Get the analysis result.

进一步地,报表处理方法还包括:在获取待分析报表文件之后,对待分析报表文件进行格式转换处理,得到转换后的待分析报表文件,并将转换后的待分析报表文件存储至第一目录。Further, the report processing method further includes: after obtaining the report file to be analyzed, performing format conversion processing on the report file to be analyzed, obtaining the converted report file to be analyzed, and storing the converted report file to be analyzed in the first directory.

进一步地,报表处理方法还包括:在根据第一解析条件,从多个待分析报表中确定至少一个目标待分析报表之前,在接收到第一目标请求的情况下,获取第一目标请求中的编辑请求信息,其中,第一目标请求为以下之一:新增编辑请求、修改编辑请求,编辑请求信息表征对解析规则的编辑信息;根据编辑请求信息,生成第一解析规则。Further, the report processing method further includes: before determining at least one target report to be analyzed from a plurality of reports to be analyzed according to the first parsing condition, in the case of receiving the first target request, obtaining the Editing request information, wherein the first target request is one of the following: adding an editing request, modifying an editing request, and the editing request information represents editing information for the parsing rules; the first parsing rule is generated according to the editing request information.

进一步地,编辑请求信息包括以下至少之一:第一报表类型、第一报表版本、第一性能数据的名称、第一性能数据的数据类型、第一解析规则数据,报表处理方法还包括:若第一目标请求为新增编辑请求,则根据第一报表类型和第一报表版本,生成第一目标数据表;根据第一性能数据的名称和第一性能数据的数据类型,从数据库中获取第一目标数据,并将第一目标数据存储于第一目标数据表;在第一目标数据表中新增第一解析规则数据,生成第一解析规则。Further, the editing request information includes at least one of the following: 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 parsing rule data, and the report processing method further includes: if The first target request is a new editing request, then according to the first report type and the first report version, generate the first target data table; according to the name of the first performance data and the data type of the first performance data, obtain the first target data table from the database a target data, and store the first target data in the first target data table; add the first parsing rule data in the first target data table to generate the first parsing rule.

进一步地,报表处理方法还包括:若第一目标请求为修改编辑请求,则根据第一报表类型和第一报表版本,生成第二目标数据表;根据第一性能数据的名称和第一性能数据的数据类型,从数据库中获取第一目标数据,并将第一目标数据存储于第二目标数据表;在第二目标数据表中,根据第一解析规则数据更新第一目标数据对应的解析规则,生成第一解析规则。Further, the report processing method further includes: if the first target request is a modification and editing request, generating a second target data table according to the first report type and the first report version; the data type, obtain the first target data from the database, and store the first target data in the second target data table; in the second target data table, update the parsing rules corresponding to the first target data according to the first parsing rule data , generating the first parsing rule.

进一步地,报表处理方法还包括:在确定至少一个目标待分析报表对应的目标解析规则,并根据目标解析规则,对至少一个目标待分析报表进行解析处理,得到解析结果之前,在接收到第二目标请求的情况下,获取第二目标请求中的查询请求信息,其中,查询请求信息包括以下至少之一:目标报表生成日期、目标报表类型、目标报表版本、目标性能数据的名称;根据查询请求信息,从数据库中获取目标解析结果数据,生成目标解析结果文件;根据目标解析结果文件,生成目标图表,其中,目标图表用于向目标对象展示目标解析结果数据。Further, the report processing method further includes: after determining the target analysis rule corresponding to at least one target report to be analyzed, and according to the target analysis rule, performing analysis processing on at least one target report to be analyzed, and obtaining the analysis result, before receiving the second In the case of a target request, obtain the query request information in the second target request, wherein the query request information includes at least one of the following: target report generation date, target report type, target report version, target performance data name; according to the query request information, obtain target analysis result data from the database, and generate a target analysis result file; generate a target chart according to the target analysis result file, wherein the target chart is used to display the target analysis result data to the target object.

根据本发明实施例的另一方面,还提供了一种报表处理装置,包括:获取模块,用于获取待分析报表文件,其中,待分析报表文件包括多个待分析报表,多个待分析报表包括目标设备的性能数据;确定模块,用于根据第一解析条件,从多个待分析报表中确定至少一个目标待分析报表,其中,第一解析条件包括以下至少之一:报表生成日期、报表类型、报表版本;处理模块,用于确定至少一个目标待分析报表对应的目标解析规则,并根据目标解析规则,对至少一个目标待分析报表进行解析处理,得到解析结果,其中,解析结果表征目标设备的性能情况。According to another aspect of the embodiments of the present invention, there is also provided a report processing device, including: an acquisition module for obtaining a report file to be analyzed, wherein the report file to be analyzed includes a plurality of reports to be analyzed, and a plurality of reports to be analyzed Including performance data of the target device; a determining module, configured to determine 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 includes at least one of the following: report generation date, report Type, report version; processing module, used to determine at least one target analysis rule corresponding to the target report to be analyzed, and according to the target analysis rule, analyze and process at least one target report to be analyzed, and obtain the analysis result, wherein the analysis result represents the target The performance of the equipment.

根据本发明实施例的另一方面,还提供了一种计算机可读存储介质,该计算机可读存储介质中存储有计算机程序,其中,计算机程序被设置为运行时执行上述的报表处理方法。According to another aspect of the embodiments of the present invention, a computer-readable storage medium is also provided, and a computer program is stored in the computer-readable storage medium, wherein the computer program is configured to execute the above report processing method when running.

根据本发明实施例的另一方面,还提供了一种电子设备,该电子设备包括一个或多个处理器;存储器,用于存储一个或多个程序,当一个或多个程序被一个或多个处理器执行时,使得一个或多个处理器实现用于运行程序,其中,程序被设置为运行时执行上述的报表处理方法。According to another aspect of the embodiments of the present invention, there is also provided an electronic device, the electronic device includes one or more processors; memory, used to store one or more programs, when one or more programs are used by one or more When the processors are executed, one or more processors are implemented to run the program, wherein the program is set to execute the above report processing method when running.

在本发明实施例中,采用自动化分析报表性能数据的方式,首先获取待分析报表文件,然后根据第一解析条件,从多个待分析报表中确定至少一个目标待分析报表,然后确定至少一个目标待分析报表对应的目标解析规则,并根据目标解析规则,对至少一个目标待分析报表进行解析处理,得到解析结果。其中,待分析报表文件包括多个待分析报表,多个待分析报表包括目标设备的性能数据,第一解析条件包括以下至少之一:报表生成日期、报表类型、报表版本,解析结果表征目标设备的性能情况。In the embodiment of the present invention, the method of automatically analyzing report performance data is adopted. First, the report file to be analyzed is obtained, and then according to the first analysis condition, at least one target report to be analyzed is determined from a plurality of reports to be analyzed, and then at least one target report is determined. A target analysis rule corresponding to the report to be analyzed, and according to the target analysis rule, at least one target report to be analyzed is analyzed to obtain an analysis result. Wherein, the report file to be analyzed includes multiple reports to be analyzed, and the multiple reports to be analyzed include performance data of the target device, and the first analysis condition includes at least one of the following: report generation date, report type, report version, and the analysis result represents the target device performance situation.

在上述过程中,通过获取待分析报表文件,为后续进行解析处理提供了数据基础;根据第一解析条件,可以从多个待分析报表中确定出至少一个目标待分析报表,从而能够确定出至少一个目标待分析报表对应的目标解析规则,进而能够根据目标解析规则,对至少一个目标待分析报表进行解析处理,节省了人力成本和时间成本,提高了报表分析处理的处理效率,提高了报表分析处理的准确率,从而提升了系统的可靠性,还可以很好地满足用户及时获取准确的性能分析报告的需求,为用户进行报表分析处理提供了便利。In the above process, by obtaining the report file to be analyzed, a data basis is provided for subsequent analysis processing; according to the first analysis condition, at least one target report to be analyzed can be determined from a plurality of reports to be analyzed, so that at least A target analysis rule corresponding to a target report to be analyzed can then analyze and process at least one target report to be analyzed according to the target analysis rule, which saves labor costs and time costs, improves the processing efficiency of report analysis and processing, and improves report analysis. The accuracy of the processing improves the reliability of the system, and it can also meet the needs of users to obtain accurate performance analysis reports in a timely manner, and provides convenience for users to analyze and process reports.

由此可见,通过本发明的技术方案,达到了减少报表分析处理的人力成本和时间成本的目的,从而实现了提高报表分析处理的处理效率的技术效果,进而解决了现有技术中通过人工收集和分析报表数据,存在处理效率低的技术问题。It can be seen that, through the technical solution of the present invention, the purpose of reducing the labor cost and time cost of report analysis and processing is achieved, thereby realizing the technical effect of improving the processing efficiency of report analysis and processing, and then solving the problem of manual collection in the prior art. And analysis of report data, there is a technical problem of low processing efficiency.

附图说明Description of drawings

此处所说明的附图用来提供对本发明的进一步理解,构成本申请的一部分,本发明的示意性实施例及其说明用于解释本发明,并不构成对本发明的不当限定。在附图中:The accompanying drawings described here are used to provide a further understanding of the present invention and constitute a part of the application. The schematic embodiments of the present invention and their descriptions are used to explain the present invention and do not constitute improper limitations to the present invention. In the attached picture:

图1是根据本发明实施例的一种可选的报表处理方法的流程图;FIG. 1 is a flow chart of an optional report processing method according to an embodiment of the present invention;

图2是根据本发明实施例的一种可选的报表处理系统的示意图;FIG. 2 is a schematic diagram of an optional report processing system according to an embodiment of the present invention;

图3是根据本发明实施例的一种可选的PM报表上传的实现流程图;Fig. 3 is the implementation flowchart of a kind of optional PM report upload according to the embodiment of the present invention;

图4是根据本发明实施例的一种可选的PM报表解析的实现流程图;Fig. 4 is an implementation flowchart of an optional PM report analysis according to an embodiment of the present invention;

图5是根据本发明实施例的一种可选的PM报表具体解析流程图;Fig. 5 is a kind of optional concrete analysis flowchart of PM statement according to the embodiment of the present invention;

图6是根据本发明实施例的一种可选的PM报表敏捷二次开发部署的实现流程图;FIG. 6 is an implementation flow chart of an optional agile secondary development and deployment of PM reports according to an embodiment of the present invention;

图7是根据本发明实施例的一种可选的二次开发中指标定义模块和解析方式模块的修改流程图;Fig. 7 is a modification flow chart of an optional secondary development index definition module and analysis mode module according to an embodiment of the present invention;

图8是根据本发明实施例的一种可选的PM报表解析结果查询流程图;FIG. 8 is a flow chart of an optional PM report analysis result query according to an embodiment of the present invention;

图9是根据本发明实施例的一种可选的PM报表一键式导出的实现流程图;Fig. 9 is an implementation flowchart of an optional one-click export of PM reports according to an embodiment of the present invention;

图10是根据本发明实施例的一种可选的报表处理装置的示意图;FIG. 10 is a schematic diagram of an optional report processing device according to an embodiment of the present invention;

图11是根据本发明实施例的一种可选的电子设备的示意图。Fig. 11 is a schematic diagram of an optional electronic device according to an embodiment of the present invention.

具体实施方式Detailed ways

为了使本技术领域的人员更好地理解本发明方案,下面将结合本发明实施例中的附图,对本发明实施例中的技术方案进行清楚、完整地描述,显然,所描述的实施例仅仅是本发明一部分的实施例,而不是全部的实施例。基于本发明中的实施例,本领域普通技术人员在没有做出创造性劳动前提下所获得的所有其他实施例,都应当属于本发明保护的范围。In order to enable those skilled in the art to better understand the solutions of the present invention, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only It is an embodiment of a part of the present invention, but not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts shall fall within the protection scope of the present invention.

需要说明的是,本发明的说明书和权利要求书及上述附图中的术语“第一”、“第二”等是用于区别类似的对象,而不必用于描述特定的顺序或先后次序。应该理解这样使用的数据在适当情况下可以互换,以便这里描述的本发明的实施例能够以除了在这里图示或描述的那些以外的顺序实施。此外,术语“包括”和“具有”以及他们的任何变形,意图在于覆盖不排他的包含,例如,包含了一系列步骤或单元的过程、方法、系统、产品或设备不必限于清楚地列出的那些步骤或单元,而是可包括没有清楚地列出的或对于这些过程、方法、产品或设备固有的其它步骤或单元。It should be noted that the terms "first" and "second" in the description and claims of the present invention and the above drawings are used to distinguish similar objects, but not necessarily used to describe a specific sequence or sequence. It is to be understood that the data so used are interchangeable under appropriate circumstances such that the embodiments of the invention described herein can be practiced in sequences other than those illustrated or described herein. Furthermore, the terms "comprising" and "having", as well as any variations thereof, are intended to cover a non-exclusive inclusion, for example, a process, method, system, product or device comprising a sequence of steps or elements is not necessarily limited to the expressly listed instead, may include other steps or elements not explicitly listed or inherent to the process, method, product or apparatus.

需要说明的是,本发明所涉及的相关信息(包括但不限于用户设备信息、用户个人信息等)和数据(包括但不限于用于展示的数据、分析的数据等),均为经用户授权或者经过各方充分授权的信息和数据。例如,本系统和相关用户或机构间设置有接口,在获取相关信息之前,需要通过接口向前述的用户或机构发送获取请求,并在接收到前述的用户或机构反馈的同意信息后,获取相关信息。It should be noted that the relevant information (including but not limited to user equipment information, user personal information, etc.) and data (including but not limited to data for display, data for analysis, etc.) involved in the present invention are authorized by the user. Or information and data fully authorized by the parties. For example, there is an interface between this system and relevant users or institutions. Before obtaining relevant information, it is necessary to send an acquisition request to the aforementioned user or institution through the interface, and obtain relevant information after receiving the consent information fed back by the aforementioned user or institution. information.

实施例1Example 1

根据本发明实施例,提供了一种报表处理方法的实施例,需要说明的是,在附图的流程图示出的步骤可以在诸如一组计算机可执行指令的计算机系统中执行,并且,虽然在流程图中示出了逻辑顺序,但是在某些情况下,可以以不同于此处的顺序执行所示出或描述的步骤。According to an embodiment of the present invention, an embodiment of a report processing method is provided. It should be noted that the steps shown in the flowcharts of the accompanying drawings can be executed in a computer system such as a set of computer-executable instructions, and, although In the flowcharts, a logical order is shown, but in some cases the steps shown or described may be performed in an order different from that shown or described herein.

图1是根据本发明实施例的一种可选的报表处理方法的流程图,如图1所示,该方法包括如下步骤:Fig. 1 is a flow chart of an optional report processing method according to an embodiment of the present invention. As shown in Fig. 1, the method includes the following steps:

步骤S101,获取待分析报表文件,其中,待分析报表文件包括多个待分析报表,多个待分析报表包括目标设备的性能数据;Step S101, obtaining a report file to be analyzed, wherein 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;

步骤S102,根据第一解析条件,从多个待分析报表中确定至少一个目标待分析报表,其中,第一解析条件包括以下至少之一:报表生成日期、报表类型、报表版本;Step S102: Determine at least one target report to be analyzed from a plurality of reports to be analyzed according to the first analysis condition, wherein the first analysis condition includes at least one of the following: report generation date, report type, and report version;

步骤S103,确定至少一个目标待分析报表对应的目标解析规则,并根据目标解析规则,对至少一个目标待分析报表进行解析处理,得到解析结果,其中,解析结果表征目标设备的性能情况。Step S103: Determine the target analysis rule corresponding to at least one target report to be analyzed, and perform analysis processing on 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 of the target device.

具体的,在上述步骤S101中,可以通过应用系统、处理器、电子设备等装置获取待分析报表文件。可选的,通过报表处理系统获取待分析报表文件,待分析报表可以是DB2的性能监控报表(PM报表),目标设备可以是大型主机。其中,DB2的PM报表包含ACCOUNTING报表和STAT报表两种类型,ACCOUNTING报表侧重对数据库数据操纵语言(Data ManipulationLanguage,DML)个数和DML处理性能的分析,STAT报表侧重对数据库CPU、内存等资源消耗性能的分析。可选地,性能数据可以是DML处理性能数据、CPU性能数据、内存性能数据等。Specifically, in the above step S101, the report file to be analyzed may be obtained through an application system, a processor, an electronic device and other devices. Optionally, the report file to be analyzed is obtained through the report processing system, the report to be analyzed may be a performance monitoring report (PM report) of DB2, and the target device may be a mainframe. Among them, the PM report of DB2 includes ACCOUNTING report and STAT report. The ACCOUNTING report focuses on the analysis of the number of database data manipulation languages (Data ManipulationLanguage, DML) and DML processing performance. The STAT report focuses on the consumption of resources such as database CPU and memory. Analysis of performance. Optionally, the performance data may be DML processing performance data, CPU performance data, memory performance data, and the like.

图2是根据本发明实施例的一种可选的报表处理系统的示意图,如图2所示,包括PM报表性能自动化分析请求装置(D1)、PM报表性能自动化分析结果存储装置(D2)、PM报表性能自动化分析响应装置(D3)。其中,D1包含PM报表上传请求模块、PM报表一键解析请求模块、网页端的多维度分析图表展示请求模块、图表一键归档请求模块、敏捷开发请求模块;D2包含指标字段类型的定义模块、解析结果的读写模块、各类DB2产品版本下的解析方法模块;D3包含报表存储模块、解析模块、响应模块、新增需求模块。其中,各类DB2产品版本下的解析方法模块包括某个DB2版本下的指标字段类型定义模块版本和解析模块版本。Fig. 2 is the schematic diagram of a kind of optional report processing system according to the embodiment of the present invention, as shown in Fig. 2, comprises PM report performance automatic analysis request device (D1), PM report performance automatic analysis result storage device (D2), PM report performance automatic analysis response device (D3). Among them, D1 includes the PM report upload request module, the PM report one-click analysis request module, the multi-dimensional analysis chart display request module on the web page, the one-key chart archiving request module, and the agile development request module; D2 includes the index field type definition module, analysis The result reading and writing module, the analysis method module under various DB2 product versions; D3 includes the report storage module, analysis module, response module, and new demand module. Among them, the analysis method modules under various DB2 product versions include the index field type definition module version and the analysis module version under a certain DB2 version.

可选地,在本实施例中,报表处理系统通过VUE前端脚手架、MYSQL数据库以及PYTHON后端数据处理的全栈架构组成,其中,通过VUE前端实现了D1的上述功能模块,通过MYSQL数据库实现了D2的上述功能模块,后端通过使用PYTHON实现了D3的上述功能模块。Optionally, in this embodiment, the report processing system is composed of VUE front-end scaffolding, MYSQL database and PYTHON back-end data processing full-stack architecture, wherein, the above-mentioned functional modules of D1 are realized through the VUE front-end, and the MYSQL database realizes The above-mentioned functional modules of D2, the back-end realizes the above-mentioned functional modules of D3 by using PYTHON.

可选地,在本实施例中,上述各个模块之间互相联动,可以实现以下功能点:Optionally, in this embodiment, the above-mentioned modules are linked with each other to realize the following functions:

功能1:用户触发前端网页请求PM报表上传功能时,后端响应模块将指定URL联动报表存储模块,将报表文件存储到后端临时目录中;Function 1: When the user triggers the front-end web page to request the PM report upload function, the back-end response module will specify the URL to link with the report storage module, and store the report file in the back-end temporary directory;

功能2:用户指定PM报表产生日期和DB2产品版本触发前端网页请求PM报表一键解析功能时,后端响应模块将指定URL联动响应DB2产品版本的解析模块完成报表解析,并按照指标字段类型定义模块的数据类型联动解析结果写入模块将解析结果存储到MYSQL存储装置中,解析完成后将调度报表存储模块将临时目录中的PM报表删除;Function 2: When the user specifies the generation date of the PM report and the DB2 product version to trigger the front-end web page to request the one-click analysis function of the PM report, the back-end response module will link the specified URL to respond to the parsing module of the DB2 product version to complete the report parsing, and define it according to the index field type The data type of the module is linked with the analysis result writing module to store the analysis result in the MYSQL storage device. After the analysis is completed, the scheduling report storage module will delete the PM report in the temporary directory;

功能3:用户指定维度、PM报表产生日期、DB2产品版本、指标名称或表名称等条目,触发前端网页请求多维度分析图表展示功能时,后端响应模块将指定URL结合响应条目作为联合主键,联动解析结果读取功能输出需要展示的分析数据,并通过URL将分析数据返回至前端网页,前端网页利用图表绘制组件完成分析数据的渲染;Function 3: When user-specified dimensions, PM report generation date, DB2 product version, indicator name or table name and other items trigger the front-end web page to request the multi-dimensional analysis chart display function, the back-end response module will combine the specified URL with the response item as the joint primary key, The linkage analysis result reading function outputs the analysis data that needs to be displayed, and returns the analysis data to the front-end web page through the URL, and the front-end web page uses the chart drawing component to complete the rendering of the analysis data;

功能4:用户指定PM报表产生日期和DB2产品版本两类条目,触发前端网页请求图表一键式归档功能时,后端响应模块将指定URL结合指定条目,通过图表归档WORD模板,联动解析结果读取功能,利用前端docxtemplater和file-saver等组件完成原始分析数据的一键生成分析报告的归档形式。Function 4: The user specifies PM report generation date and DB2 product version. When the front-end web page requests the one-click archiving function for charts, the back-end response module will combine the specified URL with the specified items, archive the WORD template through the chart, and read the linked analysis results. The extraction function uses front-end components such as docxtemplater and file-saver to complete the one-click generation of original analysis data in the form of archiving analysis reports.

功能5:当DB2产品版本升级,影响DB2产品的PM性能报表格式,导致指标筛选规则或指标个数发生改变时,用户指定DB2产品版本,触发前端网页请求敏捷开发功能,后端响应模块将指定URL联动新增需求模块完成指标修改,新增需求模块工作完成后将调度指标字段类型的定义模块和解析模块完成同步修改,并将修改后的版本存储至各类DB2产品版本下的解析方法模块的数据表中。Function 5: When the DB2 product version is upgraded, which affects the PM performance report format of the DB2 product, resulting in a change in the indicator screening rules or the number of indicators, the user specifies the DB2 product version, triggers the front-end web page to request the agile development function, and the back-end response module will specify URL linkage new requirement module completes index modification. After the new requirement module is completed, the definition module and analysis module of scheduling index field type will be modified synchronously, and the modified version will be stored in the analysis method module under various DB2 product versions. in the data table.

下面将具体说明以上功能的实现流程。The implementation process of the above functions will be described in detail below.

图3是根据本发明实施例的一种可选的PM报表上传的实现流程图,如图3所示,针对功能1(PM报表上传)的实现流程具体包括如下步骤:Fig. 3 is a kind of implementation flow chart of optional PM report uploading according to the embodiment of the present invention, as shown in Fig. 3, the realization process for function 1 (PM report uploading) specifically includes the following steps:

步骤S201,远程登录大型主机服务器终端,将DB2产品的PM报表下传至本地路径,并修改现文件名为“场景名+原文件名”。通过文件名可以指定每个文件是由什么场景产生的,例如,原文件名为D221021,场景为基准场景,修改后的文件名为scene1_BASE+D221021。Step S201, remotely log in to the mainframe server terminal, download the PM report of the DB2 product to the local path, and modify the current file name to "scene name + original file name". You can specify what scene each file is generated by using the file name. For example, the original file name is D221021, the scene is the base scene, and the modified file name is scene1_BASE+D221021.

在一种可选的实施例中,在获取待分析报表文件的过程中,首先获取目标设备关联的多个初始报表,然后根据多个初始报表对应的场景信息,对多个初始报表的名称添加对应的场景标识,得到多个待分析报表,然后根据多个待分析报表,生成待分析报表文件。In an optional embodiment, in the process of obtaining the report file to be analyzed, first obtain multiple initial reports associated with the target device, and then add A plurality of reports to be analyzed are obtained for corresponding scene identifiers, and then a report file to be analyzed is generated according to the plurality of reports to be analyzed.

可选地,首先从大型主机服务器端将PM报表文件(即大型主机关联的多个初始报表)下载到本地,然后根据多个初始报表对应的场景信息,对多个初始报表的名称添加对应的场景标识,得到多个待分析报表(即修改名称后的报表),即修改现文件名为“场景名+原文件名”,例如,原文件名为D221021,场景为基准场景,修改后的文件名为scene1_BASE+D221021。进一步地,根据多个待分析报表,生成待分析报表文件。Optionally, first download the PM report file (that is, multiple initial reports associated with the mainframe) from the mainframe server to the local, and then add corresponding Scenario identification, to get multiple reports to be analyzed (reports with modified names), that is, modify the current file name to "scene name + original file name", for example, the original file name is D221021, the scene is the benchmark scene, and the modified file name is It is scene1_BASE+D221021. Further, a report file to be analyzed is generated according to the plurality of reports to be analyzed.

步骤S202,用户触发PM报表上传功能,前端调用el-upload组件将上传的文件以formdata的格式,通过指定URL请求后端报表文件存储服务。Step S202, the user triggers the PM report upload function, and the front-end calls the el-upload component to request the back-end report file storage service by specifying the URL to upload the uploaded file in formdata format.

步骤S203,后端接收到前端请求后,通过指定URL将前端传入的formdata格式数据转化成UTF-8格式文件。Step S203, after receiving the front-end request, the back-end converts the formdata format data passed in by the front-end into a UTF-8 format file by specifying the URL.

步骤S204,将UTF-8格式文件保存到后端指定的报表原始文件临时存储目录下。Step S204, saving the UTF-8 format file to the temporary storage directory of the original report file specified by the backend.

在一种可选的实施例中,在获取待分析报表文件之后,对待分析报表文件进行格式转换处理,得到转换后的待分析报表文件,并将转换后的待分析报表文件存储至第一目录。In an optional embodiment, after the report file to be analyzed is obtained, format conversion processing is performed on the report file to be analyzed to obtain the converted report file to be analyzed, and the converted report file to be analyzed is stored in the first directory .

可选地,第一目录可以是临时目录。前端在接收到目标对象(即用户)触发的PM报表上传请求之后,从本地路径将PM报表上传并保存至后端指定的报表原始文件临时存储目录下。可选地,首先对待分析报表文件进行格式转换处理,例如,将前端传入的formdata格式数据转化成UTF-8格式文件,得到转换后的待分析报表文件,并将转换后的待分析报表文件存储至临时目录,即将UTF-8格式文件保存到后端指定的报表原始文件临时存储目录下。Optionally, the first directory may be a temporary directory. After receiving the PM report upload request triggered by the target object (that is, the user), the front end uploads and saves the PM report from the local path to the temporary storage directory of the original report file specified by the back end. Optionally, first perform format conversion processing on the report file to be analyzed, for example, convert the formdata format data imported from the front end into a UTF-8 format file, obtain the converted report file to be analyzed, and convert the converted report file to be analyzed Store to a temporary directory, that is, save the UTF-8 format file to the temporary storage directory of the original report file specified by the backend.

具体的,在上述步骤S102和S103中,第一解析条件可以是根据用户的解析请求中的报表生成日期、报表类型、报表版本生成的解析条件,根据第一解析条件,可以从多个待分析报表中确定至少一个目标待分析报表,例如,报表生成日期为X年X月X日,报表类型为ACCOUNTING报表,报表版本为DB2 1.0版本。Specifically, in the above steps S102 and S103, the first analysis condition may be an analysis condition generated according to the report generation date, report type, and report version in the user's analysis request, and according to the first analysis condition, multiple Determine at least one target report to be analyzed in the report, for example, the report generation date is X month X day, the report type is ACCOUNTING report, and the report version is DB2 1.0 version.

图4是根据本发明实施例的一种可选的PM报表解析的实现流程图,如图4所示,针对功能2(PM报表解析)的实现流程具体包括如下步骤:Fig. 4 is the implementation flowchart of a kind of optional PM report parsing according to the embodiment of the present invention, as shown in Fig. 4, the realization process for function 2 (PM report parsing) specifically includes the following steps:

步骤S301,前端使用el-dialog组件制作表单,制作表单内容包含“PM报表产生日期”、“PM报表类型”以及“DB2产品版本”。Step S301, the front end uses the el-dialog component to create a form, and the content of the created form includes "PM report generation date", "PM report type" and "DB2 product version".

步骤S302,解析前,用户触发表单按钮,填写“PM报表产生日期”、“PM报表类型”以及“DB2产品版本”内容,并点击确认。Step S302, before parsing, the user triggers the form button, fills in the contents of "PM report generation date", "PM report type" and "DB2 product version", and clicks OK.

步骤S303,用户触发报表解析功能,通过指定URL将表单内容传送至后端并请求后端报表解析服务。Step S303, the user triggers the report parsing function, transmits the form content to the backend through a specified URL and requests the backend report parsing service.

步骤S304,后端接收前端表单内容,确认报表解析方式,对临时存储目录下的报表文件进行解析,并将临时存储目录下的报表文件名进行拆分,提取场景名。即根据第一解析条件,从多个待分析报表中确定至少一个目标待分析报表,确定至少一个目标待分析报表对应的目标解析规则,并根据目标解析规则,对至少一个目标待分析报表进行解析处理,得到解析结果。可选地,在未指定DB2产品版本下,使用首次默认的DB2版本,其他DB2产品版本的解析方式可以是由敏捷二次开发产生的,不同类型的PM报表对应的报表解析方法不同。Step S304, the backend receives the frontend form content, confirms the report analysis method, analyzes the report file in the temporary storage directory, splits the report file name in the temporary storage directory, and extracts the scene name. That is, according to the first analysis condition, at least one target report to be analyzed is determined from a plurality of reports to be analyzed, a target analysis rule corresponding to at least one target report to be analyzed is determined, and at least one target report to be analyzed is analyzed according to the target analysis rule Process to get the analysis result. Optionally, if the DB2 product version is not specified, the default DB2 version is used for the first time. The parsing methods of other DB2 product versions can be generated by agile secondary development. Different types of PM reports correspond to different report parsing methods.

步骤S305,后端解析完成后,将接收的前端表单内容、场景名以及解析结果字段存储到MYSQL存储装置的存储表中。Step S305, after the back-end analysis is completed, the received front-end form content, scene name and analysis result fields are stored in the storage table of the MYSQL storage device.

步骤S306,删除前端上传至后端临时存储目录下的报表文件。Step S306, delete the report file uploaded by the front end to the temporary storage directory of the back end.

需要说明的是,通过上述过程,节省了人力成本和时间成本,提高了报表分析处理的处理效率,提高了报表分析处理的准确率,从而提升了系统的可靠性。It should be noted that, through the above process, labor costs and time costs are saved, the processing efficiency of report analysis and processing is improved, and the accuracy of report analysis and processing is improved, thereby improving the reliability of the system.

基于上述步骤S101至步骤S103所限定的方案,可以获知,在本发明实施例中,采用自动化分析报表性能数据的方式,首先获取待分析报表文件,然后根据第一解析条件,从多个待分析报表中确定至少一个目标待分析报表,然后确定至少一个目标待分析报表对应的目标解析规则,并根据目标解析规则,对至少一个目标待分析报表进行解析处理,得到解析结果。其中,待分析报表文件包括多个待分析报表,多个待分析报表包括目标设备的性能数据,第一解析条件包括以下至少之一:报表生成日期、报表类型、报表版本,解析结果表征目标设备的性能情况。Based on the scheme defined in the above steps S101 to S103, it can be known that in the embodiment of the present invention, using the method of automatically analyzing report performance data, the report file to be analyzed is first obtained, and then according to the first analysis condition, from a plurality of reports to be analyzed Determine at least one target report to be analyzed in the report, then determine the target analysis rule corresponding to the at least one target report to be analyzed, and perform analysis processing on the at least one target report to be analyzed according to the target analysis rule to obtain an analysis result. Wherein, the report file to be analyzed includes multiple reports to be analyzed, and the multiple reports to be analyzed include performance data of the target device, and the first analysis condition includes at least one of the following: report generation date, report type, report version, and the analysis result represents the target device performance situation.

容易注意到的是,在上述过程中,通过获取待分析报表文件,为后续进行解析处理提供了数据基础;根据第一解析条件,可以从多个待分析报表中确定出至少一个目标待分析报表,从而能够确定出至少一个目标待分析报表对应的目标解析规则,进而能够根据目标解析规则,对至少一个目标待分析报表进行解析处理,节省了人力成本和时间成本,提高了报表分析处理的处理效率,提高了报表分析处理的准确率,从而提升了系统的可靠性,还可以很好地满足用户及时获取准确的性能分析报告的需求,为用户进行报表分析处理提供了便利。It is easy to notice that in the above process, by obtaining the report file to be analyzed, a data basis is provided for subsequent analysis processing; according to the first analysis condition, at least one target report to be analyzed can be determined from multiple reports to be analyzed , so that at least one target analysis rule corresponding to the target report to be analyzed can be determined, and at least one target report to be analyzed can be analyzed and processed according to the target analysis rule, which saves labor costs and time costs, and improves the processing of report analysis and processing Efficiency improves the accuracy of report analysis and processing, thereby improving the reliability of the system. It can also well meet the needs of users to obtain accurate performance analysis reports in a timely manner, and provides convenience for users to perform report analysis and processing.

由此可见,通过本发明的技术方案,达到了减少报表分析处理的人力成本和时间成本的目的,从而实现了提高报表分析处理的处理效率的技术效果,进而解决了现有技术中通过人工收集和分析报表数据,存在处理效率低的技术问题。It can be seen that, through the technical solution of the present invention, the purpose of reducing the labor cost and time cost of report analysis and processing is achieved, thereby realizing the technical effect of improving the processing efficiency of report analysis and processing, and then solving the problem of manual collection in the prior art. And analysis of report data, there is a technical problem of low processing efficiency.

在一种可选的实施例中,报表类型包括以下至少之一:第一类型、第二类型,第一类型和第二类型对应的性能数据不同,其中,在确定至少一个目标待分析报表对应的目标解析规则的过程中,首先获取与报表版本对应的解析规则的规则数据表,然后从规则数据表中查询与报表类型对应的目标数据,并对目标数据进行拼接处理,得到目标解析规则,其中,目标数据包括以下至少之一:性能数据的名称、性能数据的数据类型、解析规则数据,解析规则数据表征对性能数据的解析方式。In an optional embodiment, the report type includes at least one of the following types: the first type and the second type, and the performance data corresponding to the first type and the second type are different, wherein, when determining at least one target to be analyzed report corresponds to In the process of target parsing rules, first obtain the rule data table of the parsing rules corresponding to the report version, then query the target data corresponding to the report type from the rule data table, and splicing the target data to obtain the target parsing rules. Wherein, the target data includes at least one of the following: the name of the performance data, the data type of the performance data, and analysis rule data, and the analysis rule data represents an analysis method for the performance data.

可选地,第一类型的报表可以是ACCOUNTING报表,第二类型的报表可以是STAT报表,因报表内容的侧重点不同,所以解析指标的名称、类型及解析规则不同。Optionally, the first type of report may be an ACCOUNTING report, and the second type of report may be a STAT report. Because the report contents have different emphases, the name, type and analysis rules of the analytical indicators are different.

图5是根据本发明实施例的一种可选的PM报表具体解析流程图,如图5所示,具体包括如下步骤:Fig. 5 is a kind of optional PM report specific parsing flowchart according to the embodiment of the present invention, as shown in Fig. 5, specifically comprises the following steps:

步骤S401,根据从前端获取的“DB2产品版本”参数,调用相应版本下的指标定义和解析方式模块的数据表(即获取与报表版本对应的解析规则的规则数据表),根据从前端获取的“PM报表类型”参数,查询该数据表中相应指标及其指标类型和解析规则的记录(即从规则数据表中查询与报表类型对应的目标数据)。Step S401, according to the "DB2 product version" parameter obtained from the front end, call the data table of the index definition and analysis mode module under the corresponding version (that is, obtain the rule data table of the analysis rules corresponding to the report version), according to the obtained from the front end The "PM report type" parameter is used to query the records of corresponding indicators and their indicator types and parsing rules in the data table (that is, query the target data corresponding to the report type from the rule data table).

步骤S402,轮询步骤S401得到的查询记录,获取所有指标性能数值,即对目标数据进行拼接处理,得到目标解析规则。具体的,取出一条记录进行拼接得到指标性能数值,例如,指标名称(即性能数据的名称)为CPU,数据类型(即性能数据的数据类型)为浮点类型,解析规则数据为line_data[i+2][15:25](即将文件每一行转化成列表格式),通过拼接处理得到的目标解析规则为CPU=float(line_data[i+2][15:25]),其中,i是行序号,第一个中括号表示该行的行号,第二个中括号是该行的列号,其他记录处理方式同上,当所有记录轮询完成后,即获取了所有性能指标数据。Step S402: Polling the query records obtained in step S401 to obtain all index performance values, that is, splicing the target data to obtain target analysis rules. Specifically, a record is taken out and spliced to obtain the index performance value. For example, the index name (that is, the name of the performance data) is CPU, the data type (that is, the data type of the performance data) is the floating point type, and the parsing rule data is line_data[i+ 2][15:25] (that is, convert each line of the file into a list format), the target parsing rule obtained through splicing processing is CPU=float(line_data[i+2][15:25]), where i is the line number , the first square bracket indicates the row number of the row, and the second square bracket indicates the column number of the row. Other records are processed in the same way as above. When all records are polled, all performance indicator data is obtained.

步骤S403,读取后端临时存储目录下的报表文件,根据步骤S304获取该报表文件的场景名。Step S403, read the report file in the back-end temporary storage directory, and obtain the scene name of the report file according to step S304.

步骤S404,将以上内容(“PM报表产生日期”、“PM报表类型”、“DB2产品版本”、“场景名”、“MEMBER名”、“相应性能指标数值”)放到MYSQL存储装置存储表内。可选地,若PM报表类型为ACCOUNTING类型,则放到ACCOUNTING数据表;若PM报表类型为STAT类型,则放到STAT数据表。Step S404, put the above content ("PM report generation date", "PM report type", "DB2 product version", "scene name", "MEMBER name", "corresponding performance index value") into the MYSQL storage device storage table Inside. Optionally, if the PM report type is ACCOUNTING type, put it into the ACCOUNTING data table; if the PM report type is STAT type, then put it into the STAT data table.

需要说明的是,通过对目标数据进行拼接处理,可以得到目标解析规则,为后续数据分析提供了数据基础,从而能够提高报表分析处理的准确率,降低出错率。It should be noted that by splicing the target data, target parsing rules can be obtained, which provides a data basis for subsequent data analysis, thereby improving the accuracy of report analysis and processing and reducing error rates.

在一种可选的实施例中,在根据目标解析规则,对至少一个目标待分析报表进行解析处理,得到解析结果的过程中,首先根据性能数据的名称和性能数据的数据类型,从至少一个目标待分析报表的性能数据中确定目标性能数据,然后根据解析规则数据,对目标性能数据进行解析处理,得到解析结果。In an optional embodiment, in the process of parsing at least one target report to be analyzed according to the target parsing rules and obtaining the parsing result, firstly, according to the name of the performance data and the data type of the performance data, at least one The target performance data is determined from the performance data of the target report to be analyzed, and then the target performance data is analyzed and processed according to the analysis rule data to obtain the analysis result.

可选地,根据性能数据的名称和性能数据的数据类型,可以从至少一个目标待分析报表的性能数据中确定出目标性能数据,例如,性能数据的名称为CPU,性能数据的数据类型为浮点类型,则可以从DML处理性能数据、CPU性能数据、内存性能数据等性能数据中确定出目标性能数据为浮点类型的CPU性能数据。Optionally, according to the name of the performance data and the data type of the performance data, the target performance data can be determined from the performance data of at least one target report to be analyzed, for example, the name of the performance data is CPU, and the data type of the performance data is float point type, then it can be determined from DML processing performance data, CPU performance data, memory performance data and other performance data that the target performance data is CPU performance data of floating point type.

进一步地,根据解析规则数据,对目标性能数据进行解析处理,得到解析结果,例如,解析规则数据为line_data[i+2][15:25](即将文件每一行转化成列表格式),对浮点类型的CPU性能数据进行解析处理,可以得到对应的CPU资源性能消耗情况,即得到解析结果。Further, according to the analysis rule data, the target performance data is analyzed and processed to obtain the analysis result. For example, the analysis rule data is line_data[i+2][15:25] (that is, each line of the file is converted into a list format), and the floating The CPU performance data of the point type is analyzed and processed, and the corresponding CPU resource performance consumption can be obtained, that is, the analysis result is obtained.

需要说明的是,通过对目标性能数据进行解析处理,得到解析结果,提高了报表分析处理的处理效率,后续便可根据维度(指标级别或表级别)、PM报表产生日期、DB2产品版本、指标名称或表名称等进行筛选过滤,获取到所需的PM报表性能分析数据,很好地满足了用户及时获取准确的性能分析报告的需求,为用户进行报表分析处理提供了便利。It should be noted that by analyzing and processing the target performance data, the analysis results are obtained, which improves the processing efficiency of report analysis and processing, and can be followed up according to dimensions (indicator level or table level), PM report generation date, DB2 product version, indicator Name or table name, etc. are filtered to obtain the required PM report performance analysis data, which satisfies the user's needs for timely and accurate performance analysis reports, and provides convenience for users to analyze and process reports.

在一种可选的实施例中,在根据第一解析条件,从多个待分析报表中确定至少一个目标待分析报表之前,在接收到第一目标请求的情况下,获取第一目标请求中的编辑请求信息,然后根据编辑请求信息,生成第一解析规则。其中,第一目标请求为以下之一:新增编辑请求、修改编辑请求,编辑请求信息表征对解析规则的编辑信息。In an optional embodiment, before at least one target report to be analyzed is determined from a plurality of reports to be analyzed according to the first parsing condition, when the first target request is received, the The edit request information, and then generate the first parsing rule according to the edit request information. Wherein, the first target request is one of the following: adding an editing request, modifying an editing request, and the editing request information represents editing information for the parsing rule.

可选地,第一目标请求可以是二次开发请求,即新增编辑请求或修改编辑请求,第一解析规则可以是通过新增编辑或修改编辑得到的新的解析规则。Optionally, the first target request may be a secondary development request, that is, a new editing request or a modification editing request, and the first parsing rule may be a new parsing rule obtained through adding editing or modifying editing.

图6是根据本发明实施例的一种可选的PM报表敏捷二次开发部署的实现流程图,如图6所示,针对功能5(敏捷二次开发部署)的实现流程具体包括如下步骤:Fig. 6 is an implementation flowchart of an optional agile secondary development and deployment of PM reports according to an embodiment of the present invention. As shown in Fig. 6, the implementation process for function 5 (agile secondary development and deployment) specifically includes the following steps:

步骤S501,前端使用el-dialog组件制作二次开发需求表单,制作表单条目包含“DB2产品版本,报表类型(ACCOUNTING或STAT),添加指标名称、指标类型以及解析规则,指定指标名修改指标名称、指标类型以及解析规则”。Step S501, the front end uses the el-dialog component to create a secondary development demand form, and the form entries include "DB2 product version, report type (ACCOUNTING or STAT), add indicator name, indicator type and analysis rules, specify indicator name, modify indicator name, Indicator types and parsing rules".

步骤S502,部署敏捷二次开发功能即添加报表解析方式前,用户触发表单按钮,根据需求编辑相应条目,并点击确认,前端通过指定URL将需求条目传送至后端。Step S502, before deploying the agile secondary development function, that is, before adding the report analysis method, the user triggers the form button, edits the corresponding item according to the requirement, and clicks OK, and the front end transmits the required item to the back end through the specified URL.

步骤S503,后端接收前端传入的需求条目(即在接收到第一目标请求的情况下,获取第一目标请求中的编辑请求信息),并分别进行处理(即根据编辑请求信息,生成第一解析规则),首先针对DB2产品版本创建同名称的字段及解析方式数据表,其次拷贝初始指标定义模块,并根据添加或修改的指标名称或类型进行指标定义模块的修改,最后,根据新增或修改字段筛选规则的需求,对创建的解析方式模块进行修改。Step S503, the backend receives the requirement entry from the frontend (that is, in the case of receiving the first target request, obtains the edit request information in the first target request), and processes them respectively (that is, generates the first target request information according to the edit request information) First, create a data table with the same name as the field and analysis method for the DB2 product version, then copy the initial index definition module, and modify the index definition module according to the added or modified index name or type, and finally, according to the newly added Or modify the requirements of the field filtering rules, and modify the created parsing mode module.

步骤S504,通过以上步骤即完成了解析方式的新增,当用户调用报表解析功能时,选择DB2产品版本及报表类型(ACCOUNTING或STAT),即可调用相应版本下的解析模块,解析结果也将存储到相应版本下的数据表中。Step S504, through the above steps, the addition of the analysis method is completed. When the user calls the report analysis function, select the DB2 product version and the report type (ACCOUNTING or STAT), and the analysis module under the corresponding version can be called, and the analysis result will also be Stored in the data table under the corresponding version.

需要说明的是,在上述过程中,实现了二次开发的敏捷部署功能,在指标发生改变时,通过网页添加开发需求,即可实现PM报表解析方式的新增和上线,更好地满足用户的使用需求。It should be noted that in the above process, the agile deployment function of the secondary development has been realized. When the indicators change, the development requirements can be added through the webpage, and the PM report analysis method can be added and launched to better satisfy users. usage requirements.

在一种可选的实施例中,编辑请求信息包括以下至少之一:第一报表类型、第一报表版本、第一性能数据的名称、第一性能数据的数据类型、第一解析规则数据,其中,在根据编辑请求信息,生成第一解析规则的过程中,若第一目标请求为新增编辑请求,则根据第一报表类型和第一报表版本,生成第一目标数据表,然后根据第一性能数据的名称和第一性能数据的数据类型,从数据库中获取第一目标数据,并将第一目标数据存储于第一目标数据表,然后在第一目标数据表中新增第一解析规则数据,生成第一解析规则。In an optional embodiment, the editing request information includes at least one of the following: 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 parsing rule data, Wherein, in the process of generating the first parsing rule according to the editing request information, if the first target request is a newly added editing request, the first target data table is generated according to the first report type and the first report version, and then the first target data table is generated according to the first The name of a performance data and the data type of the first performance data, obtain the first target data from the database, and store the first target data in the first target data table, and then add the first analysis in the first target data table The rule data is used to generate the first parsing rule.

在一种可选的实施例中,在根据编辑请求信息,生成第一解析规则的过程中,若第一目标请求为修改编辑请求,则根据第一报表类型和第一报表版本,生成第二目标数据表,然后根据第一性能数据的名称和第一性能数据的数据类型,从数据库中获取第一目标数据,并将第一目标数据存储于第二目标数据表,然后在第二目标数据表中,根据第一解析规则数据更新第一目标数据对应的解析规则,生成第一解析规则。In an optional embodiment, in the process of generating the first parsing rule according to the editing request information, if the first target request is a modification editing request, then according to the first report type and the first report version, a second The target data table, then according to the name of the first performance data and the data type of the first performance data, obtain the first target data from the database, and store the first target data in the second target data table, and then in the second target data In the table, the parsing rules corresponding to the first target data are updated according to the first parsing rule data to generate the first parsing rules.

图7是根据本发明实施例的一种可选的二次开发中指标定义模块和解析方式模块的修改流程图,如图7所示,修改流程具体包括如下步骤:Fig. 7 is a modification flow chart of an optional secondary development index definition module and analysis mode module according to an embodiment of the present invention. As shown in Fig. 7, the modification process specifically includes the following steps:

步骤S601,根据二次开发需求中DB2产品版本条目(即第一报表版本),创建同名的存放修改后指标定义和解析方式模块的数据表,即创建与版本对应的报表同名的数据表。可选地,若第一目标请求为新增编辑请求,则根据第一报表类型(ACCOUNTING或STAT)和第一报表版本,生成第一目标数据表(即新增编辑请求对应的数据表);若第一目标请求为修改编辑请求,则根据第一报表类型和第一报表版本,生成第二目标数据表(即修改编辑请求对应的数据表)。Step S601, according to the DB2 product version entry (ie the first report version) in the secondary development requirements, create a data table with the same name for storing the modified indicator definition and analysis mode module, that is, create a data table with the same name as the report corresponding to the version. Optionally, if the first target request is a new editing request, then according to the first report type (ACCOUNTING or STAT) and the first report version, generate the first target data table (that is, the data table corresponding to the new editing request); If the first target request is a modification and editing request, a second target data table (that is, a data table corresponding to the modification and editing request) is generated according to the first report type and the first report version.

步骤S602,当触发二次开发需求功能时,拷贝初始数据表(即存放初始指标定义和解析方式模块的数据表)内容(即根据第一性能数据的名称和第一性能数据的数据类型,从数据库中获取第一目标数据)至新增的数据表(即第一目标数据表或第二目标数据表)中,内容包含报表类型(ACCOUNTING或STAT)、每个指标名称及其类型(即第一性能数据的名称、第一性能数据的数据类型,例如,第一性能数据的名称为CPU,性能数据的数据类型为浮点类型、数值类型或字符串类型)及其解析方式(即第一解析规则数据,也就是字段筛选规则,例如,某个指标的值为含有某个关键字的几列数据中)。可选地,若第一目标请求为新增编辑请求,则根据第一性能数据的名称和第一性能数据的数据类型,从数据库中获取第一目标数据,并将第一目标数据存储于第一目标数据表;若第一目标请求为修改编辑请求,则根据第一性能数据的名称和第一性能数据的数据类型,从数据库中获取第一目标数据,并将第一目标数据存储于第二目标数据表。Step S602, when the secondary development requirement function is triggered, copy the content of the initial data table (that is, the data table that stores the initial index definition and analysis mode module) (that is, according to the name of the first performance data and the data type of the first performance data, from The first target data from the database) to the newly added data table (ie the first target data table or the second target data table), the content includes the report type (ACCOUNTING or STAT), the name of each indicator and its type (ie the first target data table) The name of the performance data, the data type of the first performance data, for example, the name of the first performance data is CPU, and the data type of the performance data is a floating point type, a numerical type or a character string type) and its resolution method (i.e. the first Parsing rule data, that is, field filtering rules, for example, the value of a certain indicator is in several columns of data containing a certain keyword). Optionally, if the first target request is a new editing request, then according to the name of the first performance data and the data type of the first performance data, the first target data is obtained from the database, and the first target data is stored in the first A target data table; if the first target request is a modification editing request, then according to the name of the first performance data and the data type of the first performance data, the first target data is obtained from the database, and the first target data is stored in the first Two target data tables.

步骤S603,若二次开发的需求为新增指标(即若第一目标请求为新增编辑请求),在步骤S602得到的数据表(即第一目标数据表)内使用SQL语句新增一行记录,例如,insertinto tablename(name,kind,rule)values(新增指标名称、新增指标名称类型、新增指标筛选规则)where table=’accounting’),即完成指标定义及其解析方式数据表新增的插入(即在第一目标数据表中新增第一解析规则数据,生成第一解析规则);若二次开发的需求为修改原指标需求(即若第一目标请求为修改编辑请求),需过滤修改的记录后进行更新(例如,update tablename set kind=修改指标名称类型,rule=指标筛选规则wheretable=’accounting’and name=修改指标名称),完成指标定义和解析方式修改的更新(即在步骤S602得到的数据表(即第二目标数据表)中,根据第一解析规则数据更新第一目标数据对应的解析规则,生成第一解析规则)。Step S603, if the demand for secondary development is a new index (that is, if the first target request is a new editing request), use a SQL statement to add a row of records in the data table obtained in step S602 (that is, the first target data table) , for example, insertinto tablename(name,kind,rule)values(new indicator name, new indicator name type, new indicator filtering rule)where table='accounting'), that is, to complete the indicator definition and its parsing method data table new Added insertion (that is, adding the first analysis rule data in the first target data table to generate the first analysis rule); if the secondary development requirement is to modify the original index requirement (that is, if the first target request is a modification editing request) , it is necessary to update the modified records after filtering (for example, update tablename set kind = modify the index name type, rule = index filtering rule wheretable = 'accounting' and name = modify the index name), complete the update of the index definition and parsing method modification ( That is, in the data table obtained in step S602 (ie, the second object data table), the analysis rule corresponding to the first object data is updated according to the first analysis rule data, and the first analysis rule is generated).

步骤S604,当调用报表解析功能时,会通过DB2产品版本和报表类型(ACCOUNTING或STAT),过滤出对应数据表内指标的定义及数值筛选规则,获取最终的解析结果。Step S604, when calling the report parsing function, the DB2 product version and report type (ACCOUNTING or STAT) will be used to filter out the definition of indicators in the corresponding data table and the value filtering rules to obtain the final parsing result.

需要说明的是,在上述过程中,实现了二次开发的敏捷部署功能,在指标发生改变时,通过网页添加开发需求,即可实现PM报表解析方式的新增和上线,更好地满足用户的使用需求。It should be noted that in the above process, the agile deployment function of the secondary development has been realized. When the indicators change, the development requirements can be added through the webpage, and the PM report analysis method can be added and launched to better satisfy users. usage requirements.

在一种可选的实施例中,在确定至少一个目标待分析报表对应的目标解析规则,并根据目标解析规则,对至少一个目标待分析报表进行解析处理,得到解析结果之前,在接收到第二目标请求的情况下,获取第二目标请求中的查询请求信息,然后根据查询请求信息,从数据库中获取目标解析结果数据,生成目标解析结果文件,然后根据目标解析结果文件,生成目标图表。其中,目标图表用于向目标对象展示目标解析结果数据,查询请求信息包括以下至少之一:目标报表生成日期、目标报表类型、目标报表版本、目标性能数据的名称。In an optional embodiment, after determining the target parsing rule corresponding to at least one target report to be analyzed, and according to the target parsing rule, at least one target report to be analyzed is parsed, and before the parsing result is obtained, before receiving the first In the case of a second target request, obtain the query request information in the second target request, then obtain the target analysis result data from the database according to the query request information, generate a target analysis result file, and then generate a target chart according to the target analysis result file. Wherein, the target graph is used to display the target analysis result data to the target object, and the query request information includes at least one of the following: target report generation date, target report type, target report version, and target performance data name.

可选地,第二目标请求可以是查询请求,目标解析结果数据可以是根据目标报表生成日期、目标报表类型、目标报表版本、目标性能数据的名称等查询请求信息确定出的数据。Optionally, the second target request may be a query request, and the target parsing result data may be data determined according to query request information such as target report generation date, target report type, target report version, and target performance data name.

图8是根据本发明实施例的一种可选的PM报表解析结果查询流程图,如图8所示,针对功能3(报表解析结果查询)的实现流程具体包括如下步骤:Fig. 8 is a kind of optional flow chart of querying PM report analysis results according to an embodiment of the present invention. As shown in Fig. 8, the implementation process for function 3 (report analysis result query) specifically includes the following steps:

步骤S701,前端使用el-form组件制作筛选条目,筛选条目内容包含“筛选维度(指标级别或表级别)、PM报表产生日期、DB2产品版本、指标名称或表名称”。In step S701, the front end uses the el-form component to create a filter item, and the content of the filter item includes "filter dimension (index level or table level), PM report generation date, DB2 product version, index name or table name".

步骤S702,前端设置在多个场景下每个性能指标的预警规则,预警规则包含两类,即阈值报警和趋势报警,且阈值报警优先级高于趋势报警,其中,阈值报警表示当某类性能指标在某个场景下超过设定值时,图表显示的柱形图(或折线图等)为红色,当某类性能指标在多个场景下的数值呈现上升趋势时,图表显示的柱形图(或折线图等)为橙色。Step S702, the front end sets the early warning rules for each performance indicator in multiple scenarios. The early warning rules include two types, namely, threshold alarms and trend alarms, and the priority of threshold alarms is higher than that of trend alarms. Threshold alarms indicate when certain types of performance When the indicator exceeds the set value in a certain scenario, the column graph (or line graph, etc.) displayed on the chart is red. When the value of a certain performance indicator shows an upward trend in multiple scenarios, the column graph displayed on the graph (or line graphs, etc.) are orange.

步骤S703,筛选前,用户在前端Web网页填写筛选条目(即查询请求信息,包括以下至少之一:目标报表生成日期、目标报表类型、目标报表版本、目标性能数据的名称),触发查询功能。Step S703, before screening, the user fills in the screening items (that is, query request information, including at least one of the following: target report generation date, target report type, target report version, and target performance data name) on the front-end web page to trigger the query function.

步骤S704,触发查询功能后,通过指定URL将筛选条目传送至后端,根据筛选条目作为过滤条件请求后端获取MYSQL存储表记录(即在接收到第二目标请求的情况下,获取第二目标请求中的查询请求信息,然后根据查询请求信息,从数据库中获取目标解析结果数据)。Step S704, after the query function is triggered, the filter item is sent to the backend through the specified URL, and the backend is requested to obtain the MYSQL storage table record according to the filter item as the filter condition (that is, when the second target request is received, the second target query request information in the request, and then obtain target analysis result data from the database according to the query request information).

步骤S705,每一条记录格式为“字段名:字段值”的字典格式,获取的多条记录组成列表类型(即生成目标解析结果文件)返回至前端。Step S705, the format of each record is a dictionary format of "field name: field value", and the obtained multiple records form a list type (that is, generate a target parsing result file) and return to the front end.

步骤S706,前端利用echart组件进行报表的分析图表绘制(即根据目标解析结果文件,生成目标图表),不管在指标级别还是在表级别下,返回至前端的数据包含多个场景数据,处理数据以字段名作为横坐标,以字段值作为纵坐标,根据场景类型绘制多条柱形或折线等进行比较分析,并通过后端返回至前端中的多场景数据进行预警显示(具体参照步骤S702)。Step S706, the front-end uses the echart component to draw the analysis chart of the report (that is, generate the target chart according to the target analysis result file), no matter at the index level or at the table level, the data returned to the front-end contains multiple scene data, and the data is processed to The field name is used as the abscissa, the field value is used as the ordinate, and multiple columns or polylines are drawn according to the scene type for comparative analysis, and the multi-scene data returned to the front end through the back end is used for early warning display (refer to step S702 for details).

图9是根据本发明实施例的一种可选的PM报表一键式导出的实现流程图,如图9所示,针对功能4(报表一键式导出)的实现流程具体包括如下步骤:Fig. 9 is an implementation flowchart of an optional one-click export of PM reports according to an embodiment of the present invention. As shown in Fig. 9, the implementation process for function 4 (one-click export of reports) specifically includes the following steps:

步骤S801,前端使用el-form组件制作筛选条目,筛选条目内容包含“PM报表产生日期、DB2产品版本”,在解析PM报表中,ACCOUNTING和STAT报表同时解析,在一个日期下和DB2产品版本下,将产生ACCOUNTING和STAT的分析图表。Step S801, the front-end uses the el-form component to make filter items, and the content of the filter items includes "PM report generation date, DB2 product version". In parsing the PM report, the ACCOUNTING and STAT reports are parsed at the same time, under the same date and under the DB2 product version , will generate analysis charts for ACCOUNTING and STAT.

步骤802,一键式导出前,用户在前端Web网页填写筛选条目,触发一键式导出功能。Step 802, before the one-click export, the user fills in the screening items on the front-end Web page to trigger the one-click export function.

步骤S803,触发后,通过指定URL将筛选条目传送至后端,后端根据筛选条目作为过滤条件,请求后端数据库获取符合条件的所有数据(包含指标级别、表级别)。Step S803, after triggering, the filter item is sent to the backend through the specified URL, and the backend uses the filter item as a filter condition to request the backend database to obtain all data (including index level and table level) that meet the conditions.

步骤S804,每一条记录格式为“字段名:字段值”的字典格式,获取的多条记录组成列表类型返回至前端。In step S804, the format of each record is a dictionary format of "field name: field value", and the obtained multiple records form a list type and return to the front end.

步骤S805,前端在静态文件中创建WORD空文件,利用echart、docxtemplater以及file-saver组件,将数据绘制为多场景比较型图表形式和预警显示(具体参照步骤S702),并归档为文件返回给用户。Step S805, the front end creates a WORD empty file in the static file, uses echart, docxtemplater and file-saver components to draw the data into a multi-scenario comparative chart form and early warning display (refer to step S702 for details), and archives it as a file and returns it to the user .

需要说明的是,在本实施例中,提供了一种基于大型主机DB2产品PM报表的性能自动化分析方法,通过后端与前端交互方式,便于用户以前端WEB网页的视角针对PM报表提供各类处理功能;通过一键式触发指令,实现PM报表解析、结果查询以及归档功能,有效地提高了DB2产品性能数据的分析处理效率,节省了时间成本和人力成本,降低了数据分析过程对用户的经验和技术水平的要求。并且,在本实施例中,可以实现二次开发的敏捷部署功能,例如,在指标发生改变时,通过网页添加开发需求,即可实现PM报表解析方式的新增和上线,更好地满足用户的使用需求。It should be noted that, in this embodiment, an automatic performance analysis method based on the mainframe DB2 product PM report is provided. Through the interaction between the back end and the front end, it is convenient for the user to provide various types of PM reports from the perspective of the front-end WEB page. Processing function; through one-click trigger command, PM report analysis, result query and archiving functions are realized, which effectively improves the analysis and processing efficiency of DB2 product performance data, saves time and labor costs, and reduces the burden on users during the data analysis process. Experience and skill level required. Moreover, in this embodiment, the agile deployment function of secondary development can be realized. For example, when the indicators change, the development requirements can be added through the webpage, and the PM report analysis method can be added and launched to better satisfy users. usage requirements.

由此可见,通过本发明的技术方案,达到了减少报表分析处理的人力成本和时间成本的目的,从而实现了提高报表分析处理的处理效率的技术效果,进而解决了现有技术中通过人工收集和分析报表数据,存在处理效率低的技术问题。It can be seen that, through the technical solution of the present invention, the purpose of reducing the labor cost and time cost of report analysis and processing is achieved, thereby realizing the technical effect of improving the processing efficiency of report analysis and processing, and then solving the problem of manual collection in the prior art. And analysis of report data, there is a technical problem of low processing efficiency.

实施例2Example 2

根据本发明实施例,提供了一种报表处理装置的实施例,其中,图10是根据本发明实施例的一种可选的报表处理装置的示意图,如图10所示,该装置包括:获取模块1001,用于获取待分析报表文件,其中,待分析报表文件包括多个待分析报表,多个待分析报表包括目标设备的性能数据;确定模块1002,用于根据第一解析条件,从多个待分析报表中确定至少一个目标待分析报表,其中,第一解析条件包括以下至少之一:报表生成日期、报表类型、报表版本;处理模块1003,用于确定至少一个目标待分析报表对应的目标解析规则,并根据目标解析规则,对至少一个目标待分析报表进行解析处理,得到解析结果,其中,解析结果表征目标设备的性能情况。According to an embodiment of the present invention, an embodiment of a report processing device is provided, wherein FIG. 10 is a schematic diagram of an optional report processing device according to an embodiment of the present invention. As shown in FIG. 10 , the device includes: Module 1001 is used to obtain the report file to be analyzed, wherein 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 determination module 1002 is used to select from multiple reports according to the first analysis condition. Determine at least one target report to be analyzed in the report to be analyzed, wherein the first parsing condition includes at least one of the following: report generation date, report type, report version; processing module 1003, used to determine at least one target report to be analyzed corresponding to Target parsing rules, and according to the target parsing rules, at least one target report to be analyzed is parsed to obtain a parsing result, wherein the parsing result represents the performance of the target device.

需要说明的是,上述获取模块1001、确定模块1002以及处理模块1003对应于上述实施例中的步骤S101至步骤S103,三个模块与对应的步骤所实现的示例和应用场景相同,但不限于上述实施例1所公开的内容。It should be noted that the acquisition module 1001, the determination module 1002 and the processing module 1003 correspond to steps S101 to S103 in the above embodiment, and the examples and application scenarios implemented by the three modules are the same as those of the corresponding steps, but are not limited to the above The content disclosed in embodiment 1.

可选的,获取模块包括:第一获取模块,用于获取目标设备关联的多个初始报表;第一处理模块,用于根据多个初始报表对应的场景信息,对多个初始报表的名称添加对应的场景标识,得到多个待分析报表;第二处理模块,用于根据多个待分析报表,生成待分析报表文件。Optionally, the acquisition module includes: a first acquisition module, configured to acquire a plurality of initial reports associated with the target device; a first processing module, configured to add A plurality of reports to be analyzed are obtained corresponding to the scene identifier; the second processing module is used to generate a report file to be analyzed according to the plurality of reports to be analyzed.

可选的,报表类型包括以下至少之一:第一类型、第二类型,第一类型和第二类型对应的性能数据不同,处理模块包括:第二获取模块,用于获取与报表版本对应的解析规则的规则数据表;第三处理模块,用于从规则数据表中查询与报表类型对应的目标数据,并对目标数据进行拼接处理,得到目标解析规则,其中,目标数据包括以下至少之一:性能数据的名称、性能数据的数据类型、解析规则数据,解析规则数据表征对性能数据的解析方式。Optionally, the report type includes at least one of the following: 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 includes: a second obtaining module, configured to obtain the report version corresponding to A rule data table for parsing rules; a third processing module, configured to query the target data corresponding to the report type from the rule data table, and splicing the target data to obtain target parsing rules, wherein the target data includes at least one of the following : The name of the performance data, the data type of the performance data, the parsing rule data, and the parsing rule data represent the parsing method of the performance data.

可选的,处理模块还包括:第一确定模块,用于根据性能数据的名称和性能数据的数据类型,从至少一个目标待分析报表的性能数据中确定目标性能数据;第四处理模块,用于根据解析规则数据,对目标性能数据进行解析处理,得到解析结果。Optionally, the processing module further includes: a first determining module, configured to determine the 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; the fourth processing module uses The target performance data is analyzed and processed according to the analysis rule data, and the analysis result is obtained.

可选的,报表处理装置还包括:第五处理模块,用于对待分析报表文件进行格式转换处理,得到转换后的待分析报表文件,并将转换后的待分析报表文件存储至第一目录。Optionally, the report processing device further includes: a fifth processing module, configured to convert the format of the report file to be analyzed, obtain the converted report file to be analyzed, and store the converted report file to be analyzed in the first directory.

可选的,报表处理装置还包括:第三获取模块,用于在接收到第一目标请求的情况下,获取第一目标请求中的编辑请求信息,其中,第一目标请求为以下之一:新增编辑请求、修改编辑请求,编辑请求信息表征对解析规则的编辑信息;第六处理模块,用于根据编辑请求信息,生成第一解析规则。Optionally, the report processing device further includes: a third obtaining module, configured to obtain the editing request information in the first target request when the first target request is received, wherein the first target request is one of the following: Adding an editing request and modifying an editing request, where the editing request information represents editing information on the parsing rules; the sixth processing module is configured to generate the first parsing rules according to the editing request information.

可选的,编辑请求信息包括以下至少之一:第一报表类型、第一报表版本、第一性能数据的名称、第一性能数据的数据类型、第一解析规则数据,第六处理模块包括:第七处理模块,用于若第一目标请求为新增编辑请求,则根据第一报表类型和第一报表版本,生成第一目标数据表;第四获取模块,用于根据第一性能数据的名称和第一性能数据的数据类型,从数据库中获取第一目标数据,并将第一目标数据存储于第一目标数据表;第八处理模块,用于在第一目标数据表中新增第一解析规则数据,生成第一解析规则。Optionally, the editing request information includes at least one of the following: 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 parsing rule data, and the sixth processing module includes: The seventh processing module is used to generate the 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 to generate the first target data table according to the first performance data name and the data type of the first performance data, obtain the first target data from the database, and store the first target data in the first target data table; the eighth processing module is used to add the first target data in the first target data table Analyzing rule data, generating a first parsing rule.

可选的,第六处理模块还包括:第九处理模块,用于若第一目标请求为修改编辑请求,则根据第一报表类型和第一报表版本,生成第二目标数据表;第五获取模块,用于根据第一性能数据的名称和第一性能数据的数据类型,从数据库中获取第一目标数据,并将第一目标数据存储于第二目标数据表;第十处理模块,用于在第二目标数据表中,根据第一解析规则数据更新第一目标数据对应的解析规则,生成第一解析规则。Optionally, the sixth processing module further includes: a ninth processing module, configured to generate 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 module, configured to obtain 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 store the first target data in the second target data table; the tenth processing module is used to In the second target data table, the parsing rules corresponding to the first target data are updated according to the first parsing rule data to generate the first parsing rules.

可选的,报表处理装置还包括:第六获取模块,用于在接收到第二目标请求的情况下,获取第二目标请求中的查询请求信息,其中,查询请求信息包括以下至少之一:目标报表生成日期、目标报表类型、目标报表版本、目标性能数据的名称;第七获取模块,用于根据查询请求信息,从数据库中获取目标解析结果数据,生成目标解析结果文件;第十一处理模块,用于根据目标解析结果文件,生成目标图表,其中,目标图表用于向目标对象展示目标解析结果数据。Optionally, the report processing device further includes: a sixth obtaining module, configured to obtain query request information in the second target request when receiving the second target request, wherein the query request information includes at least one of the following: Target report generation date, target report type, target report version, and name of target performance data; the seventh acquisition module is used to obtain the target analysis result data from the database according to the query request information, and generate the target analysis result file; the eleventh processing The module is configured to generate a target chart according to the target analysis result file, wherein the target chart is used to display the target analysis result data to the target object.

实施例3Example 3

根据本发明实施例的另一方面,还提供了一种计算机可读存储介质,计算机可读存储介质中存储有计算机程序,其中,计算机程序被设置为运行时执行上述的报表处理方法。According to another aspect of the embodiments of the present invention, a computer-readable storage medium is also provided, and a computer program is stored in the computer-readable storage medium, wherein the computer program is configured to execute the above report processing method when running.

实施例4Example 4

根据本发明实施例的另一方面,还提供了一种电子设备,其中,图11是根据本发明实施例的一种可选的电子设备的示意图,如图11所示,电子设备包括一个或多个处理器;存储器,用于存储一个或多个程序,当一个或多个程序被一个或多个处理器执行时,使得一个或多个处理器实现用于运行程序,其中,程序被设置为运行时执行上述的报表处理方法。处理器执行程序时实现以下步骤:获取待分析报表文件,其中,待分析报表文件包括多个待分析报表,多个待分析报表包括目标设备的性能数据;根据第一解析条件,从多个待分析报表中确定至少一个目标待分析报表,其中,第一解析条件包括以下至少之一:报表生成日期、报表类型、报表版本;确定至少一个目标待分析报表对应的目标解析规则,并根据目标解析规则,对至少一个目标待分析报表进行解析处理,得到解析结果,其中,解析结果表征目标设备的性能情况。According to another aspect of the embodiments of the present invention, an electronic device is also provided, wherein, FIG. 11 is a schematic diagram of an optional electronic device according to an embodiment of the present invention. As shown in FIG. 11 , the electronic device includes one or A plurality of processors; memory for storing one or more programs which, when executed by the one or more processors, cause the one or more processors to be implemented for running the programs, wherein the programs are set Execute the above report processing method for runtime. When the processor executes the program, the following steps are implemented: obtain the report file to be analyzed, wherein the report file to be analyzed includes a plurality of reports to be analyzed, and the plurality of reports to be analyzed include performance data of the target device; Determine at least one target report to be analyzed in the analysis report, wherein the first analysis condition includes at least one of the following: report generation date, report type, report version; determine at least one target analysis rule corresponding to the target report to be analyzed, and analyze according to the target The rule is to analyze and process at least one target report to be analyzed to obtain an analysis result, wherein the analysis result represents the performance of the target device.

可选地,处理器执行程序时还实现以下步骤:获取目标设备关联的多个初始报表;根据多个初始报表对应的场景信息,对多个初始报表的名称添加对应的场景标识,得到多个待分析报表;根据多个待分析报表,生成待分析报表文件。Optionally, when the processor executes the program, the following steps are also implemented: obtaining multiple initial reports associated with the target device; according to the scene information corresponding to the multiple initial reports, adding corresponding scene identifiers to the names of the multiple initial reports to obtain multiple A report to be analyzed; generate a report file to be analyzed according to multiple reports to be analyzed.

可选地,报表类型包括以下至少之一:第一类型、第二类型,第一类型和第二类型对应的性能数据不同,处理器执行程序时还实现以下步骤:获取与报表版本对应的解析规则的规则数据表;从规则数据表中查询与报表类型对应的目标数据,并对目标数据进行拼接处理,得到目标解析规则,其中,目标数据包括以下至少之一:性能数据的名称、性能数据的数据类型、解析规则数据,解析规则数据表征对性能数据的解析方式。Optionally, the report type includes at least one of the following: the first type and the second type, the performance data corresponding to the first type and the second type are different, and the processor also implements the following steps when executing the program: obtaining the parsing data corresponding to the report version The rule data table of the rule; the target data corresponding to the report type is queried from the rule data table, and the target data is spliced to obtain the target parsing rule, wherein the target data includes at least one of the following: the name of the performance data, the performance data The data type, parsing rule data, and parsing rule data represent the parsing method for performance data.

可选地,处理器执行程序时还实现以下步骤:根据性能数据的名称和性能数据的数据类型,从至少一个目标待分析报表的性能数据中确定目标性能数据;根据解析规则数据,对目标性能数据进行解析处理,得到解析结果。Optionally, when the processor executes the program, the following steps are also implemented: according to the name of the performance data and the data type of the performance data, determining the target performance data from the performance data of at least one target report to be analyzed; The data is analyzed and processed to obtain the analysis result.

可选地,处理器执行程序时还实现以下步骤:在获取待分析报表文件之后,对待分析报表文件进行格式转换处理,得到转换后的待分析报表文件,并将转换后的待分析报表文件存储至第一目录。Optionally, the processor also implements the following steps when executing the program: after obtaining the report file to be analyzed, performing format conversion processing on the report file to be analyzed, obtaining the converted report file to be analyzed, and storing the converted report file to be analyzed to the first directory.

可选地,处理器执行程序时还实现以下步骤:在根据第一解析条件,从多个待分析报表中确定至少一个目标待分析报表之前,在接收到第一目标请求的情况下,获取第一目标请求中的编辑请求信息,其中,第一目标请求为以下之一:新增编辑请求、修改编辑请求,编辑请求信息表征对解析规则的编辑信息;根据编辑请求信息,生成第一解析规则。Optionally, when the processor executes the program, the following steps are further implemented: before at least one target report to be analyzed is determined from a plurality of reports to be analyzed according to the first parsing condition, when the first target request is received, obtain the second Editing request information in a target request, wherein the first target request is one of the following: adding an editing request, modifying an editing request, and the editing request information represents the editing information for the parsing rule; according to the editing request information, the first parsing rule is generated .

可选地,编辑请求信息包括以下至少之一:第一报表类型、第一报表版本、第一性能数据的名称、第一性能数据的数据类型、第一解析规则数据,处理器执行程序时还实现以下步骤:若第一目标请求为新增编辑请求,则根据第一报表类型和第一报表版本,生成第一目标数据表;根据第一性能数据的名称和第一性能数据的数据类型,从数据库中获取第一目标数据,并将第一目标数据存储于第一目标数据表;在第一目标数据表中新增第一解析规则数据,生成第一解析规则。Optionally, the editing request information includes at least one of the following: 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 parsing rule data. The following steps are implemented: if the first target request is a new editing request, then according to the first report type and the first report version, generate the first target data table; according to the name of the first performance data and the data type of the first performance data, The first target data is obtained from the database and stored in the first target data table; the first parsing rule data is added in the first target data table to generate the first parsing rule.

可选地,处理器执行程序时还实现以下步骤:若第一目标请求为修改编辑请求,则根据第一报表类型和第一报表版本,生成第二目标数据表;根据第一性能数据的名称和第一性能数据的数据类型,从数据库中获取第一目标数据,并将第一目标数据存储于第二目标数据表;在第二目标数据表中,根据第一解析规则数据更新第一目标数据对应的解析规则,生成第一解析规则。Optionally, when the processor executes the program, the following steps are also implemented: if the first target request is a modification and editing request, then generate a second target data table according to the first report type and the first report version; and the data type of the first performance data, obtain the first target data from the database, and store the first target data in the second target data table; in the second target data table, update the first target according to the first parsing rule data A parsing rule corresponding to the data is generated to generate a first parsing rule.

可选地,处理器执行程序时还实现以下步骤:在确定至少一个目标待分析报表对应的目标解析规则,并根据目标解析规则,对至少一个目标待分析报表进行解析处理,得到解析结果之前,在接收到第二目标请求的情况下,获取第二目标请求中的查询请求信息,其中,查询请求信息包括以下至少之一:目标报表生成日期、目标报表类型、目标报表版本、目标性能数据的名称;根据查询请求信息,从数据库中获取目标解析结果数据,生成目标解析结果文件;根据目标解析结果文件,生成目标图表,其中,目标图表用于向目标对象展示目标解析结果数据。Optionally, the processor also implements the following steps when executing the program: before determining at least one target analysis rule corresponding to the target report to be analyzed, and according to the target analysis rule, at least one target report to be analyzed is analyzed and processed, and before the analysis result is obtained, In the case of receiving the second target request, acquire the query request information in the second target request, where the query request information includes at least one of the following: target report generation date, target report type, target report version, target performance data Name; according to the query request information, the target analysis result data is obtained from the database, and a target analysis result file is generated; according to the target analysis result file, a target chart is generated, wherein the target chart is used to display the target analysis result data to the target object.

本文中的设备可以是服务器、PC、PAD、手机等。The devices in this article can be servers, PCs, PADs, mobile phones, etc.

上述本发明实施例序号仅仅为了描述,不代表实施例的优劣。The serial numbers of the above embodiments of the present invention are for description only, and do not represent the advantages and disadvantages of the embodiments.

在本发明的上述实施例中,对各个实施例的描述都各有侧重,某个实施例中没有详述的部分,可以参见其他实施例的相关描述。In the above-mentioned embodiments of the present invention, the descriptions of each embodiment have their own emphases, and for parts not described in detail in a certain embodiment, reference may be made to relevant descriptions of other embodiments.

在本申请所提供的几个实施例中,应该理解到,所揭露的技术内容,可通过其它的方式实现。其中,以上所描述的装置实施例仅仅是示意性的,例如所述单元的划分,可以为一种逻辑功能划分,实际实现时可以有另外的划分方式,例如多个单元或组件可以结合或者可以集成到另一个系统,或一些特征可以忽略,或不执行。另一点,所显示或讨论的相互之间的耦合或直接耦合或通信连接可以是通过一些接口,单元或模块的间接耦合或通信连接,可以是电性或其它的形式。In the several embodiments provided in this application, it should be understood that the disclosed technical content can be realized in other ways. Wherein, the device embodiments described above are only illustrative. For example, the division of the units may be a logical function division. In actual implementation, there may be other division methods. For example, multiple units or components may be combined or may be Integrate into another system, or some features may be ignored, or not implemented. In another point, the mutual coupling or direct coupling or communication connection shown or discussed may be through some interfaces, and the indirect coupling or communication connection of units or modules may be in electrical or other forms.

所述作为分离部件说明的单元可以是或者也可以不是物理上分开的,作为单元显示的部件可以是或者也可以不是物理单元,即可以位于一个地方,或者也可以分布到多个单元上。可以根据实际的需要选择其中的部分或者全部单元来实现本实施例方案的目的。The units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, that is, they may be located in one place, or may be distributed to multiple units. Part or all of the units can be selected according to actual needs to achieve the purpose of the solution of this embodiment.

另外,在本发明各个实施例中的各功能单元可以集成在一个处理单元中,也可以是各个单元单独物理存在,也可以两个或两个以上单元集成在一个单元中。上述集成的单元既可以采用硬件的形式实现,也可以采用软件功能单元的形式实现。In addition, each functional unit in each embodiment of the present invention may be integrated into one processing unit, each unit may exist separately physically, or two or more units may be integrated into one unit. The above-mentioned integrated units can be implemented in the form of hardware or in the form of software functional units.

所述集成的单元如果以软件功能单元的形式实现并作为独立的产品销售或使用时,可以存储在一个计算机可读取存储介质中。基于这样的理解,本发明的技术方案本质上或者说对现有技术做出贡献的部分或者该技术方案的全部或部分可以以软件产品的形式体现出来,该计算机软件产品存储在一个存储介质中,包括若干指令用以使得一台计算机设备(可为个人计算机、服务器或者网络设备等)执行本发明各个实施例所述方法的全部或部分步骤。而前述的存储介质包括:U盘、只读存储器(ROM,Read-Only Memory)、随机存取存储器(RAM,Random Access Memory)、移动硬盘、磁碟或者光盘等各种可以存储程序代码的介质。If the integrated unit is realized in the form of a software function unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on such an understanding, the essence of the technical solution of the present invention or the part that contributes to the prior art or all or part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a storage medium , including several instructions to make a computer device (which may be a personal computer, a server, or a network device, etc.) execute all or part of the steps of the methods described in various embodiments of the present invention. The aforementioned storage media include: U disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), mobile hard disk, magnetic disk or optical disk and other media that can store program codes. .

以上所述仅是本发明的优选实施方式,应当指出,对于本技术领域的普通技术人员来说,在不脱离本发明原理的前提下,还可以做出若干改进和润饰,这些改进和润饰也应视为本发明的保护范围。The above is only a preferred embodiment of the present invention, it should be pointed out that, for those of ordinary skill in the art, without departing from the principle of the present invention, some improvements and modifications can also be made, and these improvements and modifications can also be made. It should be regarded as the protection 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.
CN202310278980.0A 2023-03-21 2023-03-21 Report processing method, device, storage medium and electronic equipment Pending CN116303462A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202310278980.0A CN116303462A (en) 2023-03-21 2023-03-21 Report processing method, 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, 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, device, storage medium and electronic equipment

Country Status (1)

Country Link
CN (1) CN116303462A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN116860754A (en) * 2023-07-07 2023-10-10 中国平安人寿保险股份有限公司 Report data processing method and device, electronic equipment and storage medium

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103207853A (en) * 2012-01-12 2013-07-17 国际商业机器公司 Providing Direct Manipulation Of An Analytics Data Visualization Within An Analytics Report
CN105243022A (en) * 2015-11-10 2016-01-13 中国建设银行股份有限公司 Method and device for analyzing performance data of host application software system
CN110688369A (en) * 2019-09-30 2020-01-14 北京天融信网络安全技术有限公司 Method, device, storage medium and electronic equipment for analyzing DB2 message
CN115794433A (en) * 2022-11-09 2023-03-14 中国工商银行股份有限公司 Data processing method and device, storage medium and electronic equipment

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103207853A (en) * 2012-01-12 2013-07-17 国际商业机器公司 Providing Direct Manipulation Of An Analytics Data Visualization Within An Analytics Report
CN105243022A (en) * 2015-11-10 2016-01-13 中国建设银行股份有限公司 Method and device for analyzing performance data of host application software system
CN110688369A (en) * 2019-09-30 2020-01-14 北京天融信网络安全技术有限公司 Method, device, storage medium and electronic equipment for analyzing DB2 message
CN115794433A (en) * 2022-11-09 2023-03-14 中国工商银行股份有限公司 Data processing method and device, storage medium and electronic equipment

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN116860754A (en) * 2023-07-07 2023-10-10 中国平安人寿保险股份有限公司 Report data processing method and device, electronic equipment and storage medium

Similar Documents

Publication Publication Date Title
US11755387B1 (en) Updating code of an app feature based on a value of a query feature
CN112685433B (en) Metadata updating method and device, electronic equipment and computer-readable storage medium
CN103631969B (en) A kind of generation method and device of report data
CN105144080B (en) System for metadata management
US8756593B2 (en) Map generator for representing interrelationships between app features forged by dynamic pointers
US8589876B1 (en) Detection of central-registry events influencing dynamic pointers and app feature dependencies
CN115061721A (en) A report generation method, device, computer equipment and storage medium
US20180324041A1 (en) Automatically Determining Requirements for Provisioning A Hosted Computing Environment
US8037402B2 (en) Method and system for flexible creation and publication of forms
CN113268500B (en) Service processing method and device and electronic equipment
CN109241384B (en) Scientific research information visualization method and device
CN111651296A (en) Intercept backup method, device, device and storage medium for data deletion operation
CN113934733A (en) Problem locating method, device, system, storage medium and electronic device
US9208244B2 (en) Referencing change(s) in data utilizing a network resource locator
CN115408453A (en) Configured report generation method and device, computer equipment and storage medium
CN113282555A (en) Data processing method, device, equipment and storage medium
CN111143450A (en) Method and device for importing data
CN116303462A (en) Report processing method, device, storage medium and electronic equipment
CN111045983B (en) Nuclear power plant electronic file management method, device, terminal equipment and medium
CN111352917A (en) Information input method and device, electronic equipment and storage medium
CN110515747A (en) Method and related device for generating interface help information document
CN115718754A (en) Inquiry method, device and electronic equipment for electronic accounting file data
CN115563938A (en) Method for automatically converting Web table into Excel file
CN121009871B (en) Methods for dynamically exporting complex data based on templated configuration, computer program products and systems
CN113778886B (en) Processing method and device for test cases

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