CN109271411B - Report generation method, report generation device, computer equipment and storage medium - Google Patents
Report generation method, report generation device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN109271411B CN109271411B CN201811137603.0A CN201811137603A CN109271411B CN 109271411 B CN109271411 B CN 109271411B CN 201811137603 A CN201811137603 A CN 201811137603A CN 109271411 B CN109271411 B CN 109271411B
- Authority
- CN
- China
- Prior art keywords
- field
- data
- demand information
- service demand
- data set
- 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.)
- Active
Links
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Abstract
The application discloses a report generation method, a report generation device, computer equipment and a storage medium, wherein the report generation method comprises the following steps: constructing a data set according to the historical service demand information and a database script corresponding to the historical service demand information; the database script is used for acquiring corresponding data of a single field or a combined field from the database; receiving service demand information, extracting corresponding fields from the data set according to the service demand information, and data corresponding to the fields; and generating a target report according to the field, and filling the data into each cell of the corresponding field of the target report. The method realizes analysis of all required contents by utilizing big data analysis, and obtains fields with high use frequency, thereby analyzing the target report needing to be created.
Description
Technical Field
The present application relates to the field of data processing technologies of reports, and in particular, to a report generating method, a report generating device, a computer device, and a storage medium.
Background
At present, when an enterprise collects massive user data, business data and other data and generates a report according to business requirements set forth by a demand end (such as a business person or a financial staff), a database engineer generally analyzes the business requirements after the business requirements are approved by a high-authority manager and manually selects fields according to experience to generate the report, which results in that the accuracy of generating the report is limited by experience of the database engineer and the efficiency of manually generating the report is low.
Content of the application
The embodiment of the application provides a report generation method, a device, computer equipment and a storage medium, which aim to solve the problem that when a report is generated by a business requirement set forth by a data demand party in the prior art method, a database engineer usually analyzes the business requirement after the business requirement is approved by a high-authority manager, and manually selects fields according to experience to generate the report, so that the report generation efficiency is low.
In a first aspect, an embodiment of the present application provides a report generating method, including:
constructing a data set according to the historical service demand information and a database script corresponding to the historical service demand information; the database script is used for acquiring corresponding data of a single field or a combined field from the database;
receiving service demand information, extracting corresponding fields from the data set according to the service demand information, and data corresponding to the fields;
and generating a target report according to the field, and filling the data into each cell of the corresponding field of the target report.
In a second aspect, an embodiment of the present application provides a report generating apparatus, including:
The data set construction unit is used for constructing a data set according to the historical service demand information and the database script corresponding to the historical service demand information; the database script is used for acquiring corresponding data of a single field or a combined field from the database;
the data extraction unit is used for receiving the service demand information, extracting corresponding fields from the data set according to the service demand information, and extracting data corresponding to the fields;
and the data filling unit is used for generating a target report according to the field and filling the data into each cell of the corresponding field of the target report.
In a third aspect, an embodiment of the present application further provides a computer device, which includes a memory, a processor, and a computer program stored in the memory and capable of running on the processor, where the processor implements the report generating method described in the first aspect when executing the computer program.
In a fourth aspect, an embodiment of the present application further provides a storage medium, where the storage medium stores a computer program, where the computer program includes program instructions, where the program instructions when executed by a processor cause the processor to perform the report generating method according to the first aspect.
The embodiment of the application provides a report generation method, a report generation device, computer equipment and a storage medium. And receiving service demand information, extracting corresponding fields and data corresponding to the fields in a pre-constructed data set according to the service demand information, generating a target report according to the fields extracted from the data set, and filling the data corresponding to the fields into corresponding cells of the target report. And analyzing all the required contents by utilizing big data analysis to obtain fields with high use frequency, so that the target report needing to be created is analyzed.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings required for the description of the embodiments will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present application, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a schematic flow chart of a report generating method according to an embodiment of the present application;
FIG. 2 is a schematic sub-flowchart of a report generating method according to an embodiment of the present application;
FIG. 3 is a schematic diagram of another sub-flowchart of a report generating method according to an embodiment of the present application;
FIG. 4 is a schematic diagram of another sub-flowchart of a report generating method according to an embodiment of the present application;
FIG. 5 is a schematic diagram of another sub-flowchart of a report generating method according to an embodiment of the present application;
FIG. 6 is a schematic block diagram of a report generating device according to an embodiment of the present application;
FIG. 7 is a schematic block diagram of a subunit of the report generating device according to an embodiment of the present application;
FIG. 8 is a schematic block diagram of another subunit of the report generating apparatus according to an embodiment of the present application;
FIG. 9 is a schematic block diagram of another subunit of the report generating apparatus according to an embodiment of the present application;
FIG. 10 is a schematic block diagram of another subunit of the report generating apparatus according to an embodiment of the present application;
fig. 11 is a schematic block diagram of a computer device according to an embodiment of the present application.
Detailed Description
The following description of the embodiments of the present application will be made clearly and fully with reference to the accompanying drawings, in which it is evident that the embodiments described are some, but not all embodiments of the application. All other embodiments, which can be made by those skilled in the art based on the embodiments of the application without making any inventive effort, are intended to be within the scope of the application.
It should be understood that the terms "comprises" and "comprising," when used in this specification and the appended claims, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof.
It is also to be understood that the terminology used in the description of the application herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the application. As used in this specification and the appended claims, the singular forms "a," "an," and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise.
It should be further understood that the term "and/or" as used in the present specification and the appended claims refers to any and all possible combinations of one or more of the associated listed items, and includes such combinations.
Referring to fig. 1, fig. 1 is a schematic flowchart of a report generating method according to an embodiment of the present application. The report generating method is applied to the management server, the method is executed through application software installed in the management server, and a plurality of user terminals are connected with the management server through a network to transmit information. The user terminal is terminal equipment with an internet access function, such as a desktop computer, a notebook computer, a tablet computer or a mobile phone; the management server is an enterprise terminal for report generation.
As shown in fig. 1, the method includes steps S101 to S103.
S101, constructing a data set according to historical service demand information and a database script corresponding to the historical service demand information; the database script is used for acquiring the data of the corresponding single field or the corresponding combined field from the database.
In this embodiment, the accumulation process of the historical service requirement information and the corresponding database script thereof is as follows: after acquiring the historical service demand information sent by the service data demand end, the management server informs a database manager of extracting fields which are required to be acquired and correspond to the historical service demand information after reading and analyzing the historical service demand information, writes a database script according to the fields which are required to be acquired and correspond to the historical service demand information after the acquisition requests of the fields are approved by higher authority personnel, extracts required data from mass data stored in the management server, and forms a report corresponding to the fields which are required to be acquired and the extracted data, and finally feeds the report back to the service data demand end.
It can be seen that the historical business requirement information and the database script corresponding to the historical business requirement information can be used as a sample of data analysis statistics, so as to construct a data set. According to the historical service demand information and the corresponding database script, the demand of the demand end on which fields is larger can be known, and the demand of the demand end on the table consisting of which fields is larger can also be known.
In one embodiment, as shown in fig. 2, step S101 includes:
s1011, acquiring historical service demand information and a database script corresponding to the historical service demand information;
s1012, according to the database script corresponding to the historical service demand information, counting and obtaining each single field in a plurality of scripts included in the database script and the frequency of each single field;
s1013, according to the database script corresponding to the historical service demand information, counting and obtaining each combined field in a plurality of scripts included in the database script and the frequency of each combined field;
s1014, collecting according to each single field, each single field frequency, each combined field and each combined field frequency in the scripts, and correspondingly establishing a data set.
In this embodiment, after the history service requirement information and the database script corresponding to the history service requirement information are obtained from the management server, single fields appearing in the database script and frequencies corresponding to each single field respectively may be counted; the combined fields that appear in the database script, and the frequencies that correspond to each combined field, respectively, may also be counted.
For example, a query statement, a select field name Afrom data table, exists in the database script, and the frequency of the field name A being queried can be increased by one; for example, the database script has query statement of select field name a, field name B, and field name Cfrom, which can increase the frequency of the query of the combined field A, B, C by one, and increase the frequency of the query of the field name a by one, increase the frequency of the query of the field name B by one, and increase the frequency of the query of the field name C by one; the frequency of counting the combined fields is to set the corresponding relation between the service scene information or the mechanism source information and the target field, that is, the field name a, the field name B and the field name C are the query fields required by a certain service scene or mechanism source, and the frequency of the combined fields A, B, C is higher, so that the corresponding relation between the service scene information or the mechanism source information and the target field A, B, C is preconfigured in the management server, and the subsequent rapid customization and generation of a report according to the service scene or the mechanism source can be facilitated.
S102, receiving service demand information, and extracting corresponding fields and data corresponding to the fields from the data set according to the service demand information.
In this embodiment, the service requirement information is sent from the service data requirement end to the management server, and may be descriptive requirement information of plain text (for example, the a institution needs to sort out a performance report, the required information includes a policy number, a policy fee, a policy start date, and a policy end date), or requirement information filled in an Excel form (for example, in a plurality of columns in the Excel form, each column fills in a field, and these fields are fields that need to be extracted from a data set), that is, the service requirement information is a requirement information proposed by a user for acquiring data of a relevant field.
In one embodiment, as shown in fig. 3, as a first implementation of step S102, step S102 includes:
s1021a, analyzing a target field and a target field screening condition included in the service demand information;
s1022a, comparing each target field with the fields in the data set one by one, and judging whether each target field exists in the data set;
s1023a, if each target field exists in the data set, extracting the corresponding field in the data set, and extracting the data corresponding to each field according to the target field screening condition.
In this embodiment, in order for the management server to obtain the target field and the screening condition of the target field included in the service requirement information, the service requirement information in the text form or the table form needs to be converted into an SQL statement, that is, a structured query statement, where the converted SQL statement is, for example, a selected field name from a field name=field value of a data table where; and according to the conversion from the service requirement information to the SQL statement, the target field and the target field screening condition contained in the service requirement information can be rapidly acquired.
The target fields (the number of the target fields included in the service requirement information can be 1 or more) included in the service requirement information are analyzed, and after the target field screening condition is met, the target fields can be compared with the data set to judge whether each target field exists in the data set. If each target field exists in the data set, the corresponding field is extracted in the data set, and the data corresponding to each field is extracted in the data set according to the screening condition of the target field. For example, the service data request end performs field selection on a UI interface mapped by the pre-constructed data set (i.e. the fields included in the data set are uniformly mapped on the UI interface), and completes the field selection and the field setting screening condition (e.g. the selected field includes a start-stop time field, if the user needs to screen the start-stop time is located in 2018, 1, 31, or 31, i.e. the start-stop time field is set as 20180101-20180131), and then the data corresponding to each field can be extracted according to the target field screening condition.
In one embodiment, as shown in fig. 4, as a second implementation of step S102, step S102 includes:
s1021b, analyzing service scene information corresponding to the service demand information;
s1022b, using the business scene information as the input of a preset report field configuration model, and extracting a field corresponding to the business scene information from a data set;
s1023b, extracting data corresponding to each field according to the target field screening condition corresponding to the service demand information.
In this embodiment, the service data demand end reports its own service scenario, and in the management server, according to the historical service demand information and the corresponding database script, it can acquire which service scenario demands which target fields, so that the corresponding relation between some service scenario information and the target fields is preconfigured, once the management server detects the service scenario information corresponding to the service demand information, it can quickly screen out the target fields according to the corresponding relation, and then extract the data corresponding to each field in the data set according to the screening condition of the target field, and form the target report filled with data by the target fields and the data.
In one embodiment, as shown in fig. 5, as a third implementation of step S102, step S102 includes:
S1021c, analyzing mechanism source information corresponding to the service demand information;
s1022c, taking the mechanism source information as input of a preset report field configuration model, and extracting fields corresponding to the mechanism source information from a data set;
s1023c, extracting data corresponding to each field according to the target field screening condition corresponding to the service demand information.
In this embodiment, if a certain organization (such as a certain sales network point in each sales network point of insurance) presents that the demand amount of a plurality of fixed fields is very large in the historical service demand information, the corresponding relationship between some organization source information and the target fields may be preconfigured at the server, once the management server detects the organization source information corresponding to the service demand information, the target fields may be quickly screened out according to the corresponding relationship, then the data corresponding to each field is extracted in the data set according to the screening condition of the target fields, and the target report filled with the data is formed by the target fields and the data.
And S103, generating a target report according to the field, and filling the data into each cell of the corresponding field of the target report.
After the corresponding fields are extracted from the data set according to the service requirement information, the columns included in the target report to be generated can be obtained, namely, each column corresponds to one extracted field. And after the empty target report is generated, filling the data corresponding to each field into the column.
The method comprises the steps of receiving service demand information, extracting corresponding fields in a pre-constructed data set according to the service demand information, generating a target report according to the fields extracted from the data set, and filling the data corresponding to the fields into corresponding cells of the target report. And analyzing all the required contents by utilizing big data analysis to obtain fields with high use frequency, so that the target report needing to be created is analyzed.
The embodiment of the application also provides a report generating device which is used for executing any embodiment of the report generating method. Specifically, referring to fig. 6, fig. 6 is a schematic block diagram of a report generating apparatus according to an embodiment of the present application. The report generating apparatus 100 may be configured in a management server.
As shown in fig. 6, the report generating apparatus 100 includes a data set constructing unit 101, a data extracting unit 102, and a data populating unit 103.
A data set construction unit 101, configured to construct a data set according to historical service requirement information and a database script corresponding to the historical service requirement information; the database script is used for acquiring the data of the corresponding single field or the corresponding combined field from the database.
In this embodiment, the accumulation process of the historical service requirement information and the corresponding database script thereof is as follows: after acquiring the historical service demand information sent by the service data demand end, the management server informs a database manager of extracting fields which are required to be acquired and correspond to the historical service demand information after reading and analyzing the historical service demand information, writes a database script according to the fields which are required to be acquired and correspond to the historical service demand information after the acquisition requests of the fields are approved by higher authority personnel, extracts required data from mass data stored in the management server, and forms a report corresponding to the fields which are required to be acquired and the extracted data, and finally feeds the report back to the service data demand end.
It can be seen that the historical business requirement information and the database script corresponding to the historical business requirement information can be used as a sample of data analysis statistics, so as to construct a data set. According to the historical service demand information and the corresponding database script, the demand of the demand end on which fields is larger can be known, and the demand of the demand end on the table consisting of which fields is larger can also be known.
In an embodiment, as shown in fig. 7, the data set construction unit 101 includes:
the historical data analysis unit 1011 is configured to obtain historical service demand information and a database script corresponding to the historical service demand information;
a first statistics unit 1012, configured to statistically obtain, according to a database script corresponding to the historical service requirement information, each single field in the plurality of scripts included in the database script, and a frequency of each single field;
a second statistics unit 1013, configured to statistically obtain, according to a database script corresponding to the historical service requirement information, each of the combined fields in the plurality of scripts included in the database script, and frequencies of each of the combined fields;
the aggregation unit 1014 is configured to perform aggregation according to each single field, frequency of each single field, each combined field, and frequency of each combined field in the plurality of scripts, and correspondingly establish a data set.
In this embodiment, after the history service requirement information and the database script corresponding to the history service requirement information are obtained from the management server, single fields appearing in the database script and frequencies corresponding to each single field respectively may be counted; the combined fields that appear in the database script, and the frequencies that correspond to each combined field, respectively, may also be counted.
For example, a query statement, a select field name Afrom data table, exists in the database script, and the frequency of the field name A being queried can be increased by one; for example, the database script has query statement of select field name a, field name B, and field name Cfrom, which can increase the frequency of the query of the combined field A, B, C by one, and increase the frequency of the query of the field name a by one, increase the frequency of the query of the field name B by one, and increase the frequency of the query of the field name C by one; the frequency of counting the combined fields is to set the corresponding relation between the service scene information or the mechanism source information and the target field, that is, the field name a, the field name B and the field name C are the query fields required by a certain service scene or mechanism source, and the frequency of the combined fields A, B, C is higher, so that the corresponding relation between the service scene information or the mechanism source information and the target field A, B, C is preconfigured in the management server, and the subsequent rapid customization and generation of a report according to the service scene or the mechanism source can be facilitated.
The data extraction unit 102 is configured to receive service requirement information, extract a corresponding field from the data set according to the service requirement information, and data corresponding to the field.
In this embodiment, the service requirement information is sent from the service data requirement end to the management server, and may be descriptive requirement information of plain text (for example, the a institution needs to sort out a performance report, the required information includes a policy number, a policy fee, a policy start date, and a policy end date), or requirement information filled in an Excel form (for example, in a plurality of columns in the Excel form, each column fills in a field, and these fields are fields that need to be extracted from a data set), that is, the service requirement information is a requirement information proposed by a user for acquiring data of a relevant field.
In one embodiment, as shown in fig. 8, as a first implementation of the data extraction unit 102, the data extraction unit 102 includes:
a first parsing unit 1021a, configured to parse a target field and a target field screening condition included in the service requirement information;
a first comparing unit 1022a, configured to compare each target field with the fields in the dataset one by one, and determine whether each target field exists in the dataset;
the first data filling unit 1023a is configured to extract corresponding fields in the data set if each target field exists in the data set, and extract data corresponding to each field according to the target field screening condition.
In this embodiment, in order for the management server to obtain the target field and the screening condition of the target field included in the service requirement information, the service requirement information in the text form or the table form needs to be converted into an SQL statement, that is, a structured query statement, where the converted SQL statement is, for example, a selected field name from a field name=field value of a data table where; and according to the conversion from the service requirement information to the SQL statement, the target field and the target field screening condition contained in the service requirement information can be rapidly acquired.
The target fields (the number of the target fields included in the service requirement information can be 1 or more) included in the service requirement information are analyzed, and after the target field screening condition is met, the target fields can be compared with the data set to judge whether each target field exists in the data set. If each target field exists in the data set, the corresponding field is extracted in the data set, and the data corresponding to each field is extracted in the data set according to the screening condition of the target field. For example, the service data request end performs field selection on a UI interface mapped by the pre-constructed data set (i.e. the fields included in the data set are uniformly mapped on the UI interface), and completes the field selection and the field setting screening condition (e.g. the selected field includes a start-stop time field, if the user needs to screen the start-stop time is located in 2018, 1, 31, or 31, i.e. the start-stop time field is set as 20180101-20180131), and then the data corresponding to each field can be extracted according to the target field screening condition.
In one embodiment, as shown in fig. 9, as a second implementation of the data extraction unit 102, the data extraction unit 102 includes:
a second parsing unit 1021b, configured to parse service scenario information corresponding to the service requirement information;
a second comparison unit 1022b, configured to use the service scenario information as input of a preset report field configuration model, and extract a field corresponding to the service scenario information in the data set;
and a second data filling unit 1023b, configured to extract data corresponding to each field according to the target field screening condition corresponding to the service requirement information.
In this embodiment, the service data demand end reports its own service scenario, and in the management server, according to the historical service demand information and the corresponding database script, it can acquire which service scenario demands which target fields, so that the corresponding relation between some service scenario information and the target fields is preconfigured, once the management server detects the service scenario information corresponding to the service demand information, it can quickly screen out the target fields according to the corresponding relation, and then extract the data corresponding to each field in the data set according to the screening condition of the target field, and form the target report filled with data by the target fields and the data.
In one embodiment, as shown in fig. 10, as a third implementation of the data extraction unit 102, the data extraction unit 102 includes:
a third parsing unit 1021c, configured to parse the mechanism source information corresponding to the service requirement information;
a third comparing unit 1022c, configured to use the mechanism source information as an input of a preset report field configuration model, and extract a field corresponding to the mechanism source information in the data set;
and a third data filling unit 1023c, configured to extract data corresponding to each field according to the target field screening condition corresponding to the service requirement information.
In this embodiment, if a certain organization (such as a certain sales network point in each sales network point of insurance) presents that the demand amount of a plurality of fixed fields is very large in the historical service demand information, the corresponding relationship between some organization source information and the target fields may be preconfigured at the server, once the management server detects the organization source information corresponding to the service demand information, the target fields may be quickly screened out according to the corresponding relationship, then the data corresponding to each field is extracted in the data set according to the screening condition of the target fields, and the target report filled with the data is formed by the target fields and the data.
And the data filling unit 103 is used for generating a target report according to the field and filling the data into each cell of the corresponding field of the target report.
After the corresponding fields are extracted from the data set according to the service requirement information, the columns included in the target report to be generated can be obtained, namely, each column corresponds to one extracted field. And after the empty target report is generated, filling the data corresponding to each field into the column.
The device extracts corresponding fields in a pre-constructed data set according to the service demand information, and data corresponding to the fields, generates a target report according to the fields extracted in the data set, and fills the data corresponding to the fields into corresponding cells of the target report. And analyzing all the required contents by utilizing big data analysis to obtain fields with high use frequency, so that the target report needing to be created is analyzed.
The report generating means described above may be implemented in the form of a computer program which can be run on a computer device as shown in fig. 11.
Referring to fig. 11, fig. 11 is a schematic block diagram of a computer device according to an embodiment of the present application.
With reference to FIG. 11, the computer device 500 includes a processor 502, memory, and a network interface 505 connected by a system bus 501, where the memory may include a non-volatile storage medium 503 and an internal memory 504.
The non-volatile storage medium 503 may store an operating system 5031 and a computer program 5032. The computer program 5032 includes program instructions that, when executed, cause the processor 502 to perform a report generating method.
The processor 502 is used to provide computing and control capabilities to support the operation of the overall computer device 500.
The internal memory 504 provides an environment for the execution of a computer program 5032 in the non-volatile storage medium 503, which computer program 5032, when executed by the processor 502, causes the processor 502 to perform a report generating method.
The network interface 505 is used for network communications, such as providing for the transmission of data traffic for network access, etc. It will be appreciated by those skilled in the art that the structure shown in FIG. 11 is merely a block diagram of some of the structures associated with the present inventive arrangements and does not constitute a limitation of the computer device 500 to which the present inventive arrangements may be applied, and that a particular computer device 500 may include more or fewer components than shown, or may combine some of the components, or have a different arrangement of components.
Wherein the processor 502 is configured to execute a computer program 5032 stored in a memory to perform the following functions: constructing a data set according to the historical service demand information and a database script corresponding to the historical service demand information; the database script is used for acquiring corresponding data of a single field or a combined field from the database; receiving service demand information, extracting corresponding fields from the data set according to the service demand information, and data corresponding to the fields; and generating a target report according to the field, and filling the data into each cell of the corresponding field of the target report.
In one embodiment, the processor 502 is configured to construct a data set according to the historical service requirement information and a database script corresponding to the historical service requirement information; the database script is used for acquiring the corresponding data of the single field or the combined field from the database, and executing the following operations: acquiring historical service demand information and a database script corresponding to the historical service demand information; according to the database script corresponding to the historical service demand information, counting and acquiring each single field in a plurality of scripts included in the database script and the frequency of each single field; according to the database script corresponding to the historical service demand information, counting and acquiring each combined field in a plurality of scripts included in the database script and the frequency of each combined field; and carrying out aggregation according to each single field, the frequency of each single field, each combined field and the frequency of each combined field in the scripts, and correspondingly establishing a data set.
In one embodiment, the processor 502 performs the following operations in extracting the corresponding fields in the data set according to the service requirement information, and the data corresponding to the fields: analyzing a target field and a target field screening condition included in the service demand information; comparing each target field with the fields in the data set one by one, and judging whether each target field exists in the data set; if each target field exists in the data set, extracting the corresponding field in the data set, and extracting the data corresponding to each field according to the screening condition of the target field.
In one embodiment, the processor 502 performs the following operations in extracting the corresponding fields in the data set according to the service requirement information, and the data corresponding to the fields: analyzing service scene information corresponding to the service demand information; the method comprises the steps of taking business scene information as input of a preset report field configuration model, and extracting fields corresponding to the business scene information from a data set; and extracting data corresponding to each field according to the target field screening condition corresponding to the service demand information.
In one embodiment, the processor 502 performs the following operations in extracting the corresponding fields in the data set according to the service requirement information, and the data corresponding to the fields: analyzing mechanism source information corresponding to the service demand information; the mechanism source information is used as input of a preset report field configuration model, and a field corresponding to the mechanism source information is extracted from a data set; and extracting data corresponding to each field according to the target field screening condition corresponding to the service demand information.
Those skilled in the art will appreciate that the embodiment of the computer device shown in fig. 11 is not limiting of the specific construction of the computer device, and in other embodiments, the computer device may include more or less components than those shown, or certain components may be combined, or a different arrangement of components. For example, in some embodiments, the computer device may include only a memory and a processor, and in such embodiments, the structure and function of the memory and the processor are consistent with the embodiment shown in fig. 11, and will not be described again.
It should be appreciated that in an embodiment of the application, the processor 502 may be a Central processing unit (Central ProcessingUnit, CPU), and the processor 502 may also be other general purpose processors, digital signal processors (DigitalSignalProcessor, DSP), application specific integrated circuits (ApplicationSpecificIntegrated Circuit, ASIC), off-the-shelf programmable gate arrays (Field-ProgrammableGateArray, FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, or the like. Wherein the general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.
In another embodiment of the present application, a storage medium is provided. The storage medium may be a non-volatile computer readable storage medium. The storage medium stores a computer program, wherein the computer program includes program instructions. The program instructions, when executed by a processor, implement the steps of: constructing a data set according to the historical service demand information and a database script corresponding to the historical service demand information; the database script is used for acquiring corresponding data of a single field or a combined field from the database; receiving service demand information, extracting corresponding fields from the data set according to the service demand information, and data corresponding to the fields; and generating a target report according to the field, and filling the data into each cell of the corresponding field of the target report.
In one embodiment, the program instructions when executed by a processor perform the steps of: acquiring historical service demand information and a database script corresponding to the historical service demand information; according to the database script corresponding to the historical service demand information, counting and acquiring each single field in a plurality of scripts included in the database script and the frequency of each single field; according to the database script corresponding to the historical service demand information, counting and acquiring each combined field in a plurality of scripts included in the database script and the frequency of each combined field; and carrying out aggregation according to each single field, the frequency of each single field, each combined field and the frequency of each combined field in the scripts, and correspondingly establishing a data set.
In one embodiment, the program instructions when executed by a processor perform the steps of: analyzing a target field and a target field screening condition included in the service demand information; comparing each target field with the fields in the data set one by one, and judging whether each target field exists in the data set; if each target field exists in the data set, extracting the corresponding field in the data set, and extracting the data corresponding to each field according to the screening condition of the target field.
In one embodiment, the program instructions when executed by a processor perform the steps of: analyzing service scene information corresponding to the service demand information; the method comprises the steps of taking business scene information as input of a preset report field configuration model, and extracting fields corresponding to the business scene information from a data set; and extracting data corresponding to each field according to the target field screening condition corresponding to the service demand information.
In one embodiment, the program instructions when executed by a processor perform the steps of: analyzing mechanism source information corresponding to the service demand information; the mechanism source information is used as input of a preset report field configuration model, and a field corresponding to the mechanism source information is extracted from a data set; and extracting data corresponding to each field according to the target field screening condition corresponding to the service demand information.
It will be clearly understood by those skilled in the art that, for convenience and brevity of description, specific working procedures of the apparatus, device and unit described above may refer to corresponding procedures in the foregoing method embodiments, which are not repeated herein. Those of ordinary skill in the art will appreciate that the elements and algorithm steps described in connection with the embodiments disclosed herein may be embodied in electronic hardware, in computer software, or in a combination of the two, and that the elements and steps of the examples have been generally described in terms of function in the foregoing description to clearly illustrate the interchangeability of hardware and software. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the solution. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present application.
In the several embodiments provided by the present application, it should be understood that the disclosed apparatus, device and method may be implemented in other manners. For example, the apparatus embodiments described above are merely illustrative, and for example, the division of the units is merely a logical function division, there may be another division manner in actual implementation, or units having the same function may be integrated into one unit, for example, multiple units or components may be combined or may be integrated into another system, or some features may be omitted, or not performed. In addition, the coupling or direct coupling or communication connection shown or discussed with each other may be an indirect coupling or communication connection via some interfaces, devices, or elements, or may be an electrical, mechanical, or other form of connection.
The units described as separate units may or may not be physically separate, and units shown as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the embodiment of the present application.
In addition, each functional unit in the embodiments of the present application may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units may be implemented in hardware or in software functional units.
The integrated units may be stored in a storage medium if implemented in the form of software functional units and sold or used as stand-alone products. Based on such understanding, the technical solution of the present application is essentially or a part contributing to the prior art, or all or part of the technical solution may be embodied in the form of a software product stored in a storage medium, comprising several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method according to the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-only memory (ROM), a magnetic disk, an optical disk, or other various media capable of storing program codes.
While the application has been described with reference to certain preferred embodiments, it will be understood by those skilled in the art that various changes and substitutions of equivalents may be made and equivalents will be apparent to those skilled in the art without departing from the scope of the application. Therefore, the protection scope of the application is subject to the protection scope of the claims.
Claims (9)
1. A report generation method, comprising:
constructing a data set according to the historical service demand information and a database script corresponding to the historical service demand information; the database script is used for acquiring corresponding data of a single field or a combined field from the database;
receiving service demand information, extracting corresponding fields from the data set according to the service demand information, and data corresponding to the fields;
generating a target report according to the field, and filling the data into each cell of the corresponding field of the target report;
the service demand information is descriptive demand information of plain text and demand information filled in an Excel form;
the extracting the corresponding field and the data corresponding to the field in the data set according to the service requirement information comprises the following steps:
Analyzing service scene information corresponding to the service demand information;
the method comprises the steps of taking business scene information as input of a preset report field configuration model, and extracting fields corresponding to the business scene information from a data set;
extracting data corresponding to each field according to a target field screening condition corresponding to the service demand information;
wherein, after the step of constructing the data set according to the historical service demand information and the database script corresponding to the historical service demand information, the method comprises the following steps: and pre-configuring the corresponding relation between the service scene information and the target field.
2. The report generating method as set forth in claim 1, wherein the constructing a data set is performed according to historical business requirement information and a database script corresponding to the historical business requirement information; the database script is used for acquiring the data of the corresponding single field or the corresponding combined field from the database, and comprises the following steps:
acquiring historical service demand information and a database script corresponding to the historical service demand information;
according to the database script corresponding to the historical service demand information, counting and acquiring each single field in a plurality of scripts included in the database script and the frequency of each single field;
According to the database script corresponding to the historical service demand information, counting and acquiring each combined field in a plurality of scripts included in the database script and the frequency of each combined field;
and carrying out aggregation according to each single field, the frequency of each single field, each combined field and the frequency of each combined field in the scripts, and correspondingly establishing a data set.
3. The report generating method as set forth in claim 1, wherein the extracting the corresponding field and the data corresponding to the field in the dataset according to the service requirement information includes:
analyzing a target field and a target field screening condition included in the service demand information;
comparing each target field with the fields in the data set one by one, and judging whether each target field exists in the data set;
if each target field exists in the data set, extracting the corresponding field in the data set, and extracting the data corresponding to each field according to the screening condition of the target field.
4. The report generating method as set forth in claim 1, wherein the extracting the corresponding field and the data corresponding to the field in the dataset according to the service requirement information includes:
Analyzing mechanism source information corresponding to the service demand information;
the mechanism source information is used as input of a preset report field configuration model, and a field corresponding to the mechanism source information is extracted from a data set;
and extracting data corresponding to each field according to the target field screening condition corresponding to the service demand information.
5. A report generating apparatus, comprising:
the data set construction unit is used for constructing a data set according to the historical service demand information and the database script corresponding to the historical service demand information; the database script is used for acquiring corresponding data of a single field or a combined field from the database;
the data extraction unit is used for receiving the service demand information, extracting corresponding fields from the data set according to the service demand information, and extracting data corresponding to the fields;
the data filling unit is used for generating a target report according to the field and filling the data into each cell of the corresponding field of the target report;
the service demand information is descriptive demand information of plain text and demand information filled in an Excel form;
the extracting the corresponding field and the data corresponding to the field in the data set according to the service requirement information comprises the following steps:
Analyzing service scene information corresponding to the service demand information;
the method comprises the steps of taking business scene information as input of a preset report field configuration model, and extracting fields corresponding to the business scene information from a data set;
extracting data corresponding to each field according to a target field screening condition corresponding to the service demand information;
wherein, after the step of constructing the data set according to the historical service demand information and the database script corresponding to the historical service demand information, the method comprises the following steps: and pre-configuring the corresponding relation between the service scene information and the target field.
6. The report generating apparatus as recited in claim 5, wherein the data set constructing unit includes:
the historical data analysis unit is used for acquiring historical service demand information and database scripts corresponding to the historical service demand information;
the first statistics unit is used for statistically acquiring each single field in a plurality of scripts included in the database script and the frequency of each single field according to the database script corresponding to the historical service demand information;
the second statistical unit is used for statistically acquiring each combined field in the plurality of scripts included in the database script and the frequency of each combined field according to the database script corresponding to the historical service demand information;
And the aggregation unit is used for carrying out aggregation according to each single field, the frequency of each single field, each combined field and the frequency of each combined field in the plurality of scripts, and correspondingly establishing a data set.
7. The report generating apparatus as recited in claim 5, wherein the data extracting unit includes:
the first analysis unit is used for analyzing the target field and the target field screening condition included in the service demand information;
the first comparison unit is used for comparing each target field with the fields in the data set one by one and judging whether each target field exists in the data set;
and the first data filling unit is used for extracting corresponding fields in the data set if each target field exists in the data set, and extracting data corresponding to each field according to the target field screening condition.
8. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the report generating method of any of claims 1 to 4 when the computer program is executed.
9. A storage medium storing a computer program comprising program instructions which, when executed by a processor, cause the processor to perform the report generating method of any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811137603.0A CN109271411B (en) | 2018-09-28 | 2018-09-28 | Report generation method, report generation device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811137603.0A CN109271411B (en) | 2018-09-28 | 2018-09-28 | Report generation method, report generation device, computer equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109271411A CN109271411A (en) | 2019-01-25 |
| CN109271411B true CN109271411B (en) | 2023-08-29 |
Family
ID=65198139
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811137603.0A Active CN109271411B (en) | 2018-09-28 | 2018-09-28 | Report generation method, report generation device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109271411B (en) |
Families Citing this family (27)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109902272B (en) * | 2019-01-28 | 2024-02-06 | 平安科技（深圳）有限公司 | Electronic form data processing method, electronic form data processing device, computer equipment and storage medium |
| CN111651425A (en) * | 2019-03-04 | 2020-09-11 | 北京沃东天骏信息技术有限公司 | Data extraction method and device for data mart, terminal and storage medium |
| CN111831964A (en) * | 2019-04-10 | 2020-10-27 | 阿里巴巴集团控股有限公司 | Data report information processing method and device and computer system |
| CN110297833A (en) * | 2019-07-05 | 2019-10-01 | 税安科技(杭州)有限公司 | A kind of bordereau error correction method |
| CN110830437B (en) * | 2019-09-25 | 2022-06-10 | 平安科技（深圳）有限公司 | Data compression method, device, equipment and storage medium for high-frequency service data |
| CN110750969B (en) * | 2019-09-29 | 2023-09-01 | 望海康信(北京)科技股份公司 | Report generation method and device |
| CN111143433A (en) * | 2019-12-10 | 2020-05-12 | 中国平安财产保险股份有限公司 | Method and device for counting data of data bins |
| CN111158795A (en) * | 2019-12-24 | 2020-05-15 | 深圳壹账通智能科技有限公司 | Report generation method, device, medium and electronic equipment |
| CN111563368B (en) * | 2020-04-03 | 2023-10-31 | 江苏苏宁物流有限公司 | Report generation method, report generation device, computer equipment and storage medium |
| CN111553133B (en) * | 2020-04-21 | 2023-04-07 | 招商局金融科技有限公司 | Report generation method and device, electronic equipment and storage medium |
| CN111881660A (en) * | 2020-06-29 | 2020-11-03 | 金蝶医疗软件科技有限公司 | Report generation method and device, computer equipment and storage medium |
| CN111797279B (en) * | 2020-07-17 | 2024-01-19 | 西安数据如金信息科技有限公司 | Method and device for storing data |
| CN111680112B (en) * | 2020-08-14 | 2020-11-10 | 支付宝(杭州)信息技术有限公司 | Data analysis method and device |
| CN112000647A (en) * | 2020-08-26 | 2020-11-27 | 支付宝(杭州)信息技术有限公司 | Method and apparatus for data processing |
| CN112685415A (en) * | 2020-12-30 | 2021-04-20 | 平安普惠企业管理有限公司 | Data import method and device, computer equipment and storage medium |
| CN112766910B (en) * | 2021-01-21 | 2023-10-27 | 深圳市极致科技股份有限公司 | Document construction method, generation method, device, electronic equipment and storage medium |
| CN112882702A (en) * | 2021-02-03 | 2021-06-01 | 叮当快药科技集团有限公司 | Information processing method and device for report configuration |
| CN112860700A (en) * | 2021-02-22 | 2021-05-28 | 北京互金新融科技有限公司 | Data table generation method and device, storage medium and electronic device |
| CN113505121A (en) * | 2021-05-25 | 2021-10-15 | 北京达佳互联信息技术有限公司 | Data processing method, device, server and storage medium |
| CN113343653A (en) * | 2021-05-31 | 2021-09-03 | 北京明略软件系统有限公司 | Method and device for generating report, electronic equipment and readable storage medium |
| CN113449028A (en) * | 2021-07-06 | 2021-09-28 | 京东科技控股股份有限公司 | Data extraction method and device, electronic equipment and storage medium |
| CN113298665A (en) * | 2021-07-27 | 2021-08-24 | 太平财产保险有限公司 | Automatic settlement method for car insurance documentary and settlement system based on method |
| CN113591447A (en) * | 2021-07-30 | 2021-11-02 | 高途教育科技集团有限公司 | Data table creating method, device, equipment and storage medium |
| CN115174555A (en) * | 2022-06-28 | 2022-10-11 | 平安科技（深圳）有限公司 | File transmission method and device, electronic equipment and storage medium |
| CN115062025A (en) * | 2022-06-29 | 2022-09-16 | 广州高专资讯科技有限公司 | Method, device, equipment and storage medium for sending business report |
| CN115186023B (en) * | 2022-09-07 | 2022-12-06 | 杭州安恒信息技术股份有限公司 | Data set generation method, device, equipment and medium |
| CN115759014A (en) * | 2022-11-22 | 2023-03-07 | 北京码牛科技股份有限公司 | Dynamic intelligent analysis method and system and electronic equipment |
Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2012248161A (en) * | 2011-05-31 | 2012-12-13 | Oki Electric Ind Co Ltd | Interactive retrieval system and program, and interaction scenario creation system and program |
| CN104361140A (en) * | 2014-12-10 | 2015-02-18 | 用友软件股份有限公司 | Dynamically generated data model configuration device and method |
| CN104516916A (en) * | 2013-09-29 | 2015-04-15 | 华为技术有限公司 | Method and device for analyzing network report incidence relation |
| CN105095249A (en) * | 2014-05-05 | 2015-11-25 | 中国石油化工股份有限公司 | Method generating multi-dimension report form |
| CN105808437A (en) * | 2016-03-09 | 2016-07-27 | 广州彩瞳网络技术有限公司 | Automation testing method and system based on test case data table |
| CN105843945A (en) * | 2016-04-08 | 2016-08-10 | 联动优势科技有限公司 | Report generation method and system |
| CN106844319A (en) * | 2016-12-21 | 2017-06-13 | 泰康保险集团股份有限公司 | Report form generation method and device |
| CN107038218A (en) * | 2017-03-17 | 2017-08-11 | 腾讯科技（深圳）有限公司 | report processing method and system |
| CN107229559A (en) * | 2016-03-23 | 2017-10-03 | 阿里巴巴集团控股有限公司 | For the detection method and device of the test integrity degree of operation system |
| CN107291770A (en) * | 2016-04-11 | 2017-10-24 | 中国移动通信集团山西有限公司 | The querying method and device of mass data in a kind of distributed system |
| CN108280082A (en) * | 2017-01-06 | 2018-07-13 | 北京京东尚科信息技术有限公司 | A kind of extemporaneous querying method and system of statistical data |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7962498B2 (en) * | 2008-12-30 | 2011-06-14 | Sap Ag | Generating attribute-specific electronic documents |
| US8423498B2 (en) * | 2009-06-22 | 2013-04-16 | Integrated Training Solutions, Inc. | System and associated method for determining and applying sociocultural characteristics |
| JP2013196250A (en) * | 2012-03-19 | 2013-09-30 | Ricoh Co Ltd | Content creation support device, method for the same, and program |
| US20140012632A1 (en) * | 2012-07-05 | 2014-01-09 | Sap Ag | Extension of business scenarios |
| US20160048660A1 (en) * | 2014-08-15 | 2016-02-18 | Consilink, LLC | Report generation based on real-time and historical data |
-
2018
- 2018-09-28 CN CN201811137603.0A patent/CN109271411B/en active Active
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2012248161A (en) * | 2011-05-31 | 2012-12-13 | Oki Electric Ind Co Ltd | Interactive retrieval system and program, and interaction scenario creation system and program |
| CN104516916A (en) * | 2013-09-29 | 2015-04-15 | 华为技术有限公司 | Method and device for analyzing network report incidence relation |
| CN105095249A (en) * | 2014-05-05 | 2015-11-25 | 中国石油化工股份有限公司 | Method generating multi-dimension report form |
| CN104361140A (en) * | 2014-12-10 | 2015-02-18 | 用友软件股份有限公司 | Dynamically generated data model configuration device and method |
| CN105808437A (en) * | 2016-03-09 | 2016-07-27 | 广州彩瞳网络技术有限公司 | Automation testing method and system based on test case data table |
| CN107229559A (en) * | 2016-03-23 | 2017-10-03 | 阿里巴巴集团控股有限公司 | For the detection method and device of the test integrity degree of operation system |
| CN105843945A (en) * | 2016-04-08 | 2016-08-10 | 联动优势科技有限公司 | Report generation method and system |
| CN107291770A (en) * | 2016-04-11 | 2017-10-24 | 中国移动通信集团山西有限公司 | The querying method and device of mass data in a kind of distributed system |
| CN106844319A (en) * | 2016-12-21 | 2017-06-13 | 泰康保险集团股份有限公司 | Report form generation method and device |
| CN108280082A (en) * | 2017-01-06 | 2018-07-13 | 北京京东尚科信息技术有限公司 | A kind of extemporaneous querying method and system of statistical data |
| CN107038218A (en) * | 2017-03-17 | 2017-08-11 | 腾讯科技（深圳）有限公司 | report processing method and system |
Non-Patent Citations (1)
| Title |
|---|
| 一套智能的报表生成方法及设计原则;宋永利;《自动化与仪器仪表》;20161125;第200-205页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109271411A (en) | 2019-01-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109271411B (en) | Report generation method, report generation device, computer equipment and storage medium | |
| CN109408535B (en) | Large data volume matching method, device, computer equipment and storage medium | |
| CN108776934B (en) | Distributed data calculation method and device, computer equipment and readable storage medium | |
| CN102404126B (en) | Charging method of cloud computing during application process | |
| WO2020000726A1 (en) | Performance test report generating method, electronic device, and readable storage medium | |
| CA2927580C (en) | Method and system for document data extraction template management | |
| CN109445768B (en) | Database script generation method and device, computer equipment and storage medium | |
| US9298780B1 (en) | Method and system for managing user contributed data extraction templates using weighted ranking score analysis | |
| CN111143286A (en) | Cloud platform log management method and system | |
| US20190149344A1 (en) | Intelligent search system for service cost and method thereof | |
| CN115168400A (en) | External data management system and method | |
| CN110941530A (en) | Method and device for acquiring monitoring data, computer equipment and storage medium | |
| CN113934733A (en) | Problem positioning method, device, system, storage medium and electronic equipment | |
| CN113805777A (en) | Method and system for generating optimal operation path of service system | |
| CN115952398B (en) | Traditional calculation method, system and storage medium based on data of Internet of things | |
| CN113010542A (en) | Service data processing method and device, computer equipment and storage medium | |
| CN111553803A (en) | Claims processing method and device | |
| TWI546758B (en) | Method for transmitting massive data by using dynamically adjusted updating frequency | |
| CN110888733A (en) | Cluster resource use condition processing method and device and electronic equipment | |
| EP4209933A1 (en) | Data processing method and apparatus, and electronic device and storage medium | |
| CN116109322A (en) | Data acquisition method, data acquisition device, and computer-readable storage medium | |
| CN114186958A (en) | Method, computing device and storage medium for exporting list data as spreadsheet | |
| US20140156339A1 (en) | Operational risk and control analysis of an organization | |
| CN114218173A (en) | Batch processing system, processing method, medium and equipment for account-transfer transaction files | |
| CN114116866A (en) | Data acquisition method and device, terminal equipment and storage medium |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |