File generation method, device, electronic device, medium and computer program product

Abstract

The present application discloses a file generation method, device, electronic device, medium and computer program product. The file generation method includes: reverse parsing the script file corresponding to the submitted data to obtain a reverse file corresponding to the script file; wherein the reverse file includes: a data processing flow table and at least one data source table; based on the type of information to be processed in the reverse file, storing different types of information to be processed in different data source tables respectively; splicing the information to be processed in the data source table to obtain sentence information; splicing the sentence information of different sentence ranges to generate a target relationship table corresponding to the submitted data; wherein the target relationship table is used to describe the source corresponding to the submitted data. The effect of quickly generating an explanatory file corresponding to the submitted project can be achieved.

Description

Technical Field

[0001] The present application relates to the field of computers, and in particular to a file generation method, device, electronic device, medium and computer program product. Background Art

[0002] At present, financial institutions are facing the trend of escalating external supervision. Financial regulatory authorities have continuously raised their requirements for the quality of data submitted by financial institutions, and based on the needs of inspection, they have further proposed requirements for the explainability and inspectability of the source and processing of the submitted data. In this context, financial institutions need to improve their own data as soon as possible, especially the explanatory documents on the source, mapping rules and processing methods of the data submitted by the regulator, and other aspects of the data lineage.

[0003] At present, the source of the explanatory document mainly relies on the accumulation of early project development documents. If the design documents of the early data processing are not fully archived, or the data processing and development documents have changed during the actual development process, or the reported data has changed after many iterations over the years, but there is no document record, it is necessary to rely entirely on manual reading of the script files and policy files corresponding to the reported data to rebuild the explanatory document, which is cumbersome and difficult. Summary of the invention

[0004] The purpose of the embodiments of the present application is to provide a file generation method, device, electronic device, medium and computer program product to achieve the effect of quickly generating an explanatory document corresponding to a reported project.

[0005] The technical solution of this application is as follows:

[0006] In a first aspect, a method for generating a file is provided, the method comprising:

[0007] Reversely analyze the script file corresponding to the submitted data to obtain a reverse file corresponding to the script file; wherein the reverse file includes: a data processing flow table and at least one data source table;

[0008] Based on the type of the information to be processed in the reverse file, storing different types of the information to be processed in different data source tables respectively;

[0009] splicing the information to be processed in the data source table to obtain sentence information;

[0010] The sentence information of different sentence ranges is spliced ​​to generate a target relationship table corresponding to the reported data; wherein the target relationship table is used to describe the source corresponding to the reported data.

[0011] In a second aspect, a file generation device is provided, the device comprising:

[0012] A parsing module, used for reverse parsing the script file corresponding to the submitted data to obtain a reverse file corresponding to the script file; wherein the reverse file includes: a data processing flow table and at least one data source table;

[0013] A storage module, used for storing different types of the information to be processed in different data source tables respectively based on the types of the information to be processed in the reverse file;

[0014] A first splicing module is used to splice the information to be processed in the data source table to obtain sentence information;

[0015] The second splicing module is used to splice the sentence information of different sentence ranges to generate a target relationship table corresponding to the reported data; wherein the target relationship table is used to describe the source corresponding to the reported data.

[0016] In a third aspect, an embodiment of the present application provides an electronic device, which includes a processor, a memory, and a program or instruction stored in the memory and executable on the processor, wherein the program or instruction, when executed by the processor, implements the steps of the file generation method described in any one of the embodiments of the present application.

[0017] In a fourth aspect, an embodiment of the present application provides a readable storage medium, on which a program or instruction is stored. When the program or instruction is executed by a processor, the steps of the file generation method described in any one of the embodiments of the present application are implemented.

[0018] In a fifth aspect, an embodiment of the present application provides a computer program product. When the instructions in the computer program product are executed by a processor of an electronic device, the electronic device can perform the steps of the file generation method described in any one of the embodiments of the present application.

[0019] The technical solution provided by the embodiments of the present application brings at least the following beneficial effects:

[0020] The file generation method, device, electronic device, medium and computer program product provided in the embodiments of the present application perform reverse parsing on the script file corresponding to the reported data to obtain a reverse file corresponding to the script file, wherein the reverse file includes: a data processing flow table and at least one data source table; based on the type of information to be processed in the reverse file, the information to be processed is stored in different data source tables respectively; the information to be processed in the data source table is spliced ​​to obtain sentence information; and then the sentence information of different sentence ranges is spliced ​​to generate a target relationship table corresponding to the reported data; since the target relationship table contains the source of the reported data, the corresponding target relationship table is automatically generated based on the script file corresponding to the reported data, without the need to manually read a large number of script folders, thereby improving the generation efficiency of the target relationship table and saving manpower.

[0021] It should be understood that the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the present application. BRIEF DESCRIPTION OF THE DRAWINGS

[0022] The drawings herein are incorporated into the specification and constitute a part of the specification, illustrate embodiments consistent with the present application, and together with the specification are used to explain the principles of the present application, and do not constitute an improper limitation on the present application.

[0023] Figure 1 It is a flowchart of a file generation method provided by an embodiment of the first aspect of the present application;

[0024] Figure 2 It is a flowchart of another file generation method provided by an embodiment of the first aspect of the present application;

[0025] Figure 3 It is a structural schematic diagram of a file generating device provided by an embodiment of the second aspect of the present application;

[0026] Figure 4 It is a structural schematic diagram of an electronic device provided in an embodiment of the third aspect of the present application. DETAILED DESCRIPTION

[0027] In order to make those of ordinary skill in the art better understand the technical scheme of the present application, the technical scheme in the embodiments of the present application will be clearly and completely described below in conjunction with the accompanying drawings. It should be understood that the specific embodiments described herein are only intended to explain the present application, rather than to limit the present application. For those skilled in the art, the present application can be implemented without the need for some of these specific details. The following description of the embodiments is only to provide a better understanding of the present application by illustrating the examples of the present application.

[0028] It should be noted that the terms "first", "second", etc. in the specification and claims of the present application and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchanged where appropriate, so that the embodiments of the present application described here can be implemented in an order other than those illustrated or described here. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with the present application. On the contrary, they are only examples consistent with some aspects of the present application as detailed in the attached claims.

[0029] The acquisition, storage, use and processing of data in the embodiments of this application comply with the relevant provisions of national laws and regulations.

[0030] As described in the background technology section, the prior art has the problem that when reconstructing explanatory documents for reported data, it completely relies on manual reading of script files and policy files corresponding to the reported data, which leads to cumbersome and difficult work. In order to solve the above problems, the embodiments of the present application provide a file generation method, device, electronic device, medium and computer program product. By reverse parsing the script file corresponding to the reported data, a reverse file corresponding to the script file is obtained. The reverse file includes: a data processing flow table and at least one data source table. Based on the type of information to be processed in the reverse file, the information to be processed is stored in different data source tables respectively, and the information to be processed in the data source table is spliced ​​to obtain sentence information. Then, the sentence information of different sentence ranges is spliced ​​to generate a target relationship table corresponding to the reported data. Since the target relationship table has the source of the reported data, the corresponding target relationship table is automatically generated based on the script file corresponding to the reported data, without the need to manually read a large number of script folders, thereby improving the generation efficiency of the target relationship table and saving manpower.

[0031] The following is a detailed description of the file generation method provided in the embodiment of the present application through specific embodiments and their application scenarios in conjunction with the accompanying drawings.

[0032] Figure 1 1 is a flow chart of a file generation method provided in an embodiment of the present application, and the execution subject of the file generation method may be a server. The above execution subject does not constitute a limitation on the embodiment of the present application.

[0033] like Figure 1 As shown, the file generation method provided in the embodiment of the present application may include steps 110 to 140.

[0034] Step 110: reverse parse the script file corresponding to the submitted data to obtain a reverse file corresponding to the script file.

[0035] The reverse file may include: a data processing flow table and at least one data source table.

[0036] Step 120: Based on the type of the information to be processed in the reverse file, different types of information to be processed are stored in different data source tables.

[0037] Step 130: splice the information to be processed in the data source table to obtain sentence information.

[0038] Step 140: splice the sentence information of different sentence ranges to generate a target relationship table corresponding to the reported data.

[0039] Among them, the target relationship table can be used to describe the source corresponding to the reported data.

[0040] In an embodiment of the present application, a reverse file corresponding to the script file is obtained by reverse parsing the script file corresponding to the reported data, and the reverse file includes: a data processing flow table and at least one data source table. Based on the type of information to be processed in the reverse file, the information to be processed is stored in different data source tables respectively, and the information to be processed in the data source table is spliced ​​to obtain sentence information. Then, the sentence information of different sentence ranges is spliced ​​to generate a target relationship table corresponding to the reported data. Since the target relationship table contains the source of the reported data, the corresponding target relationship table is automatically generated based on the script file corresponding to the reported data, without the need to manually read a large number of script folders, thereby improving the generation efficiency of the target relationship table and saving manpower.

[0041] The following is a detailed introduction to the file generation method provided in the embodiment of the present application.

[0042] First, step 110 is introduced, in which the script file corresponding to the submitted data is reversely parsed to obtain a reverse file corresponding to the script file.

[0043] The reported data may be data to be reported, and specifically may be tax data for reporting taxes, etc.

[0044] The reverse file may be a file obtained by reverse parsing the script file corresponding to the reported data.

[0045] In some embodiments of the present application, the reverse file may include: a data processing flow table and at least one data source table.

[0046] In some embodiments of the present application, the data processing flow table (main table) may be a tabular representation of the data (submitted data, and source data of the reported data) from which data table and through what processing.

[0047] In some embodiments of the present application, a data source table (mapping table) may be used to characterize which fields and data are used in a specific step, what processing has been performed, what the upstream field of the field is, what the downstream field is, etc.

[0048] In some embodiments of the present application, the relationship between the data processing flow table and the data source table can be understood as follows: for the example of Fourier transforming a data to obtain the transformed data, the data processing flow table only describes a general process, that is, it describes data A being transformed by Fourier transform to obtain data B, that is, the data processing flow table roughly describes what data, what algorithm is used, and what data is obtained. The data source table will describe in detail where data A comes from, the detailed process of Fourier transforming data A, and what kind of data the obtained data B is, and what the data is used for in the next step, that is, the data source table will describe in detail the specific process of a certain step.

[0049] In some embodiments of the present application, the data source table may include, but is not limited to, a from part, a join part, a where part, and a mapping part.

[0050] In some embodiments of the present application, the from part may be mainly used to describe the source of certain data and what the downstream data of the data is.

[0051] In some embodiments of the present application, the join part may be mainly used to describe the relationship between the tables. Specifically, if the data in a table needs to call the data in another table, the join part is used to describe the relationship between the two tables.

[0052] In some embodiments of the present application, the where part may be mainly used to describe how to select data after two tables are connected.

[0053] In some embodiments of the present application, the mapping part may be mainly used to describe the mapping relationship between fields.

[0054] In some embodiments of the present application, for script files of different formats, the corresponding parsers can be used to reverse parse the script files. Specifically, if the script file is in Perl format, the parser corresponding to the Perl format can be used to reverse parse the script file to obtain the reverse file corresponding to each script file.

[0055] In some embodiments of the present application, the reverse file may be in Excel format.

[0056] In some embodiments of the present application, the purpose of step 110 is to use a parser corresponding to the script file to parse and decompose the Structured Query Language (SQL) statements in the script file into the smallest units of words or symbols, that is, to decompose the complete description in the script file into data, symbols, words, short sentences, etc.

[0057] Then, step 120 is introduced, based on the type of the information to be processed in the reverse file, different types of information to be processed are stored in different data source tables respectively.

[0058] The information to be processed may be the smallest unit disassembled in step 110. For example, it may be, but is not limited to: data corresponding to the data processing flow in the data source table, symbols corresponding to the data processing flow in the data source table, and short sentences corresponding to the data processing flow in the data source table.

[0059] In some embodiments of the present application, different types of information to be processed can be stored in corresponding intermediate tables (from table, join table, where table and mapping table) according to the type of information to be processed in the reverse file. The data such as parsed words, symbols and short sentences of each processing flow in each script file are recorded in each intermediate table.

[0060] Next, step 130 is introduced, in which the information to be processed in the data source table is concatenated to obtain sentence information.

[0061] The sentence information may be a sentence formed by concatenating the information to be processed in the data source table.

[0062] In some embodiments of the present application, in order to further save manpower and improve efficiency, step 130 may specifically include:

[0063] The data, symbols and short sentences corresponding to the data processing flow in the data source table are spliced ​​according to the preset splicing rules to obtain sentence information.

[0064] In some embodiments of the present application, the vocabulary, symbols, short sentences and other elements representing each processing flow in the intermediate table are merged into sentences with better readability to generate complete sentence information such as field transformation and assignment function.

[0065] In some embodiments of the present application, in the process of splicing the data, symbols and short sentences corresponding to the data processing flow in the data source table according to preset splicing rules to obtain sentence information, it is also necessary to record the source files and processing flow marks corresponding to the data in each intermediate table to facilitate subsequent splicing.

[0066] In an embodiment of the present application, sentence information is obtained by splicing the data, symbols and short sentences corresponding to the data processing flow in the data source table according to preset splicing rules. In this way, sentence information with good readability can be automatically obtained, which saves manpower and improves efficiency.

[0067] In some embodiments of the present application, in order to obtain accurate explanatory documents corresponding to the submitted data, before step 130, the above-mentioned file generation method may further include:

[0068] The information to be processed in the data source table is cleaned to obtain the cleaned information to be processed.

[0069] In some embodiments of the present application, the information to be processed in the data source table may be cleaned to obtain cleaned information to be processed.

[0070] Correspondingly, step 130 may specifically include: splicing the cleaned information to be processed in the data source table to obtain sentence information.

[0071] In an embodiment of the present application, the information to be processed in the data source table can be cleaned to obtain the cleaned information to be processed, and then splicing can be performed based on the cleaned information to be processed to obtain accurate sentence information, and then an accurate explanatory document corresponding to the reported data can be obtained.

[0072] In some embodiments of the present application, in order to further obtain an accurate explanatory document corresponding to the reported data, the cleaning of the information to be processed in the data source table to obtain the cleaned information to be processed may specifically include:

[0073] Delete duplicate data in the data source table;

[0074] For short sentences starting with preset characters in the data source table, rewrite them into short sentences that conform to the format of the target relational table to obtain the cleaned information to be processed.

[0075] The preset characters may be pre-set characters.

[0076] The target relational table format may be a format of a target relational table.

[0077] In some embodiments of the present application, the target relationship table may be the final explanatory document corresponding to the submitted data, and the document is in a tabular form.

[0078] In some embodiments of the present application, other data that may cause splicing or writing errors may be pre-processed, for example, to avoid errors in writing into the target relational table during subsequent splicing, some short sentences beginning with '=' (i.e., preset characters) may be transformed, etc. Duplicate data in the data source table may also be deleted.

[0079] In some embodiments of the present application, only two methods of data cleaning are listed above, but those skilled in the art should know that data cleaning is not limited to the two methods listed above, and other specific methods can also be used. Any method of data cleaning falls within the scope of protection of the embodiments of the present application and will not be repeated here.

[0080] In some embodiments of the present application, this step aims to improve the accuracy of subsequent splicing data through preprocessing.

[0081] In an embodiment of the present application, duplicate data in the data source table is deleted, and short sentences in the data source table that begin with preset characters are rewritten into short sentences that conform to the format of the target relationship table to obtain cleaned information to be processed. In this way, accurate information to be processed can be obtained, and then accurate sentence information can be obtained, thereby improving the accuracy of subsequent splicing.

[0082] Finally, step 140 is introduced to splice the sentence information of different sentence ranges to generate a target relationship table corresponding to the reported data.

[0083] The same statement scope may be statements belonging to the same statement scope.

[0084] The target relationship table can be a table corresponding to the reported data generated by splicing the clause information of the same statement range. The target relationship table can be an Excel table, which can be used to describe the source corresponding to the reported data, that is, the explanatory document corresponding to the reported data.

[0085] In some embodiments of the present application, the processing logic statements can be further spliced ​​based on the above-mentioned sentence information. Specifically, the sentence information within different sentence ranges can be spliced ​​to obtain a more complex multi-layer nested sentence assembly, and after the assembly, a target relationship table containing target fields (fields required in the target relationship table), mapping sources corresponding to the reported data, and processing logic corresponding to the reported data can be formed.

[0086] In some embodiments of the present application, in order to obtain an accurate target relationship table, step 140 may specifically include:

[0087] The sentence information of different sentence ranges is spliced ​​to obtain a temporary relation table corresponding to the reported data;

[0088] Supplement the empty fields in the temporary relationship table with data, and delete the temporary data in the temporary data table to generate the target relationship table corresponding to the reported data.

[0089] The temporary relationship table may be a relationship table formed by splicing the clause information of different sentence ranges, wherein the data under some fields in the relationship table is empty, or there is temporary data automatically generated by the system during the splicing process in the table.

[0090] In some embodiments of the present application, the empty data under the fields in the temporary relationship table can be supplemented, and the temporary data automatically generated by the system in the temporary data table can be deleted to generate a target relationship table corresponding to the reported data.

[0091] In some embodiments of the present application, the generated target relationship table may have: script files, processing flows, symbols (AND&OR), English names of auxiliary tables, English names of fields in auxiliary tables, field transformations, conditional values, English names of source tables, English names of source fields, assignment functions, English names of target relationship tables, target relationship table fields or field aliases, assignment expressions, From associations, Join conditions, and Where conditions, etc.

[0092] In some embodiments of the present application, the auxiliary table may be other tables used to generate the target relationship table.

[0093] In some embodiments of the present application, the source table may be a source table of reported data.

[0094] In some embodiments of the present application, the target relationship table can be used to provide support for field-level data sources and processing logic for the subsequent manual construction of an indicator library model.

[0095] In an embodiment of the present application, by splicing the sentence information of different statement ranges, a temporary relationship table corresponding to the reported data is obtained, the empty fields in the temporary relationship table are supplemented with data, and the temporary data in the temporary data table is deleted to generate a target relationship table corresponding to the reported data, thereby improving the standardization of the data and enhancing the readability of the target relationship table.

[0096] In some embodiments of the present application, in order to accurately splice the sentence information of the same sentence range, before step 140, the above-mentioned file generation method may further include:

[0097] Detect the sentence range identifier corresponding to the sentence information;

[0098] When it is determined that the sentence range identifier is detected, the sentence range of the sentence information is determined.

[0099] The sentence range identifier may be an identifier representing the sentence range of the clause information, and may specifically be a left bracket identifier and a right bracket identifier.

[0100] In some embodiments of the present application, the corresponding sentence scope identifier in the sentence information is detected, for example, the left bracket and the right bracket of the sentence information can be detected. When the left bracket and the right bracket of the sentence information are detected, the sentence scope corresponding to the sentence information can be determined.

[0101] In an embodiment of the present application, by detecting the sentence range identifier corresponding to the sentence information, when it is determined that the sentence range identifier is detected, the sentence range of the sentence information is determined. In this way, the sentence range of the sentence information can be accurately determined, and further splicing can be accurately performed to obtain the target relationship table.

[0102] In some embodiments of the present application, in order to more clearly understand the file generation method provided by the embodiments of the present application, the embodiments of the present application also provide another implementable manner of the file generation method. Figure 2 is a flow chart of another file generation method provided in an embodiment of the present application, such as Figure 2 As shown, the file generation method provided in the embodiment of the present application may include steps 210 to 250.

[0103] Step 210: Obtain the script files corresponding to the submitted data.

[0104] Step 220: reverse parse the script file to obtain a reverse file.

[0105] In some embodiments of the present application, step 220 is consistent with step 110 in the above embodiment and will not be described in detail here.

[0106] Step 230: Data collection.

[0107] In some embodiments of the present application, step 230 is consistent with step 120 in the above embodiment, that is, data collection is based on the type of information to be processed in the reverse file in the above step 120, and different types of information to be processed are stored in different data source tables respectively, which will not be repeated here.

[0108] Step 240: data processing.

[0109] In some embodiments of the present application, data processing includes cleaning data, preprocessing data (i.e., splicing the information to be processed in the data source table to obtain sentence information), splicing data (i.e., splicing sentence information of different statement ranges), automatic filling (i.e., supplementing data for empty fields in the temporary relationship table) and standardization (deleting temporary data in the temporary data table).

[0110] Step 250: Output the explanatory document.

[0111] In some embodiments of the present application, outputting the explanatory document is to output the document after data processing into an Excel spreadsheet format.

[0112] It should be noted that the file generation method provided in the embodiment of the present application can be executed by a file generation device, or a control module in the risk determination device for executing the file generation method.

[0113] Based on the same inventive concept as the above-mentioned file generation method, the present application also provides a file generation device. Figure 3 The file generation device provided in the embodiment of the present application is described in detail.

[0114] Figure 3 The figure is a schematic diagram showing the structure of a file generating device according to an exemplary embodiment.

[0115] like Figure 3 As shown, the file generating device 300 may include:

[0116] The parsing module 310 is used to reversely parse the script file corresponding to the submitted data to obtain a reverse file corresponding to the script file; wherein the reverse file includes: a data processing flow table and at least one data source table;

[0117] The storage module 320 is used to store different types of the information to be processed in different data source tables based on the types of the information to be processed in the reverse file;

[0118] A first splicing module 330 is used to splice the information to be processed in the data source table to obtain sentence information;

[0119] The second splicing module 340 is used to splice the sentence information of different sentence ranges to generate a target relationship table corresponding to the reported data; wherein the target relationship table is used to describe the source corresponding to the reported data.

[0120] In an embodiment of the present application, a script file corresponding to the reported data is reverse parsed by a parsing module to obtain a reverse file corresponding to the script file, the reverse file including: a data processing flow table and at least one data source table; the storage module stores the information to be processed in different data source tables based on the type of the information to be processed in the reverse file; the first splicing module splices the information to be processed in the data source table to obtain sentence information; and then the second splicing module splices the sentence information of different sentence ranges to generate a target relationship table corresponding to the reported data; since the target relationship table contains the source of the reported data, the corresponding target relationship table is automatically generated based on the script file corresponding to the reported data, without the need to manually read a large number of script folders, thereby improving the generation efficiency of the target relationship table and saving manpower.

[0121] In some embodiments of the present application, the information to be processed includes at least: data corresponding to the data processing flow in the data source table, symbols corresponding to the data processing flow in the data source table, and short sentences corresponding to the data processing flow in the data source table.

[0122] In some embodiments of the present application, in order to further save manpower and improve efficiency, the first splicing module 330 is specifically used to: splice the data, symbols and short sentences corresponding to the data processing flow in the data source table according to preset splicing rules to obtain sentence information.

[0123] In some embodiments of the present application, in order to obtain an accurate explanatory document corresponding to the reported data, the file generation device mentioned above may further include: a cleaning module, which is used to clean the information to be processed in the data source table to obtain the cleaned information to be processed;

[0124] Correspondingly, the first splicing module can be specifically used to: splice the cleaned information to be processed in the data source table to obtain sentence information.

[0125] In some embodiments of the present application, in order to further obtain accurate explanatory documents corresponding to the reported data, the cleaning module can be specifically used to:

[0126] Duplicate data in the data source table are deleted; short sentences starting with preset characters in the data source table are rewritten into short sentences that conform to the format of the target relationship table to obtain cleaned information to be processed.

[0127] In some embodiments of the present application, in order to accurately splice sentence information within the same sentence range, the file generation device involved above may further include:

[0128] A detection module, used for detecting a sentence range identifier corresponding to the sentence information;

[0129] A determination module is used to determine the sentence scope of the sentence information when it is determined that the sentence scope identifier is detected.

[0130] In some embodiments of the present application, in order to obtain an accurate target relationship table, the second splicing module 340 may be specifically used to:

[0131] Splicing the sentence information of different sentence ranges to obtain a temporary relationship table corresponding to the reported data;

[0132] The empty fields in the temporary relation table are supplemented with data, and the temporary data in the temporary data table is deleted to generate a target relation table corresponding to the submitted data.

[0133] The file generation device provided in the embodiment of the present application can be used to execute the file generation method provided in the above-mentioned method embodiments. Its implementation principle and technical effect are similar, and for the sake of brief introduction, they will not be repeated here.

[0134] Based on the same inventive concept, an embodiment of the present application also provides an electronic device.

[0135] Figure 4 Schematic diagram of the structure of an electronic device provided in an embodiment of the present application. Figure 4 As shown, the electronic device may include a processor 401 and a memory 402 storing computer programs or instructions.

[0136] Specifically, the processor 401 may include a central processing unit (CPU), or an application specific integrated circuit (ASIC), or may be configured to implement one or more integrated circuits of the embodiment of the present invention.

[0137] The memory 402 may include a large capacity memory for data or instructions. For example, but not limitation, the memory 402 may include a hard disk drive (HDD), a floppy disk drive, a flash memory, an optical disk, a magneto-optical disk, a magnetic tape, or a universal serial bus (USB) drive or a combination of two or more of these. In appropriate cases, the memory 402 may include a removable or non-removable (or fixed) medium. In appropriate cases, the memory 402 may be inside or outside the integrated gateway disaster recovery device. In a specific embodiment, the memory 402 is a non-volatile solid-state memory. The memory may include a read-only memory (ROM), a random access memory (RAM), a disk storage medium device, an optical storage medium device, a flash memory device, an electrical, optical or other physical / tangible memory storage device. Therefore, typically, the memory includes one or more tangible (non-transitory) computer-readable storage media (e.g., memory devices) encoded with software including computer-executable instructions, and when the software is executed (e.g., by one or more processors), it is operable to perform the operations described in the file generation method provided in the above-mentioned embodiments.

[0138] The processor 401 implements any one of the file generation methods in the above embodiments by reading and executing computer program instructions stored in the memory 402 .

[0139] In one example, the electronic device may further include a communication interface 403 and a bus 410. Figure 4 As shown, the processor 401, the memory 402, and the communication interface 403 are connected via a bus 410 and communicate with each other.

[0140] The communication interface 403 is mainly used to implement the communication between the modules, devices, units and / or devices in the embodiment of the present invention.

[0141] Bus 410 includes hardware, software or both, and the parts of electronic equipment are coupled to each other. For example, but not limitation, bus may include accelerated graphics port (AGP) or other graphics bus, enhanced industrial standard architecture (EISA) bus, front side bus (FSB), hypertransport (HT) interconnection, industrial standard architecture (ISA) bus, infinite bandwidth interconnection, low pin count (LPC) bus, memory bus, micro channel architecture (MCA) bus, peripheral component interconnection (PCI) bus, PCI-Express (PCI-X) bus, serial advanced technology attachment (SATA) bus, video electronics standard association local (VLB) bus or other suitable bus or two or more of these combinations. In appropriate cases, bus 410 may include one or more buses. Although the embodiment of the present invention describes and shows a specific bus, the present invention considers any suitable bus or interconnection.

[0142] The electronic device can execute the file generation method in the embodiment of the present invention, thereby realizing Figure 1-Figure 2 Any method of generating files described.

[0143] In addition, in combination with the file generation method in the above embodiment, the embodiment of the present invention can provide a readable storage medium for implementation. The readable storage medium stores program instructions; when the program instructions are executed by a processor, any one of the file generation methods in the above embodiment is implemented.

[0144] It should be clear that the present invention is not limited to the specific configuration and processing described above and shown in the figures. For the sake of simplicity, a detailed description of the known method is omitted here. In the above embodiments, several specific steps are described and shown as examples. However, the method process of the present invention is not limited to the specific steps described and shown, and those skilled in the art can make various changes, modifications and additions, or change the order between the steps after understanding the spirit of the present invention.

[0145] The functional blocks shown in the above-described block diagram can be implemented as hardware, software, firmware or a combination thereof. When implemented in hardware, it can be, for example, an electronic circuit, an application specific integrated circuit (ASIC), appropriate firmware, a plug-in, a function card, etc. When implemented in software, the elements of the present invention are programs or code segments that are used to perform the required tasks. The program or code segment can be stored in a machine-readable medium, or transmitted on a transmission medium or a communication link by a data signal carried in a carrier wave. "Machine-readable medium" can include any medium capable of storing or transmitting information. Examples of machine-readable media include electronic circuits, semiconductor memory devices, ROM, flash memory, erasable ROM (EROM), floppy disks, CD-ROMs, optical disks, hard disks, optical fiber media, radio frequency (RF) links, etc. The code segment can be downloaded via a computer network such as the Internet, an intranet, etc.

[0146] It should also be noted that the exemplary embodiments mentioned in the present invention describe some methods or systems based on a series of steps or devices. However, the present invention is not limited to the order of the above steps, that is, the steps can be performed in the order mentioned in the embodiments, or in a different order from the embodiments, or several steps can be performed simultaneously.

[0147] The above reference is according to the method of the embodiment of the present application, the flow chart of the device (system) and the computer program product and / or the block diagram described various aspects of the present application.It should be understood that each square box in the flow chart and / or the block diagram and the combination of each square box in the flow chart and / or the block diagram can be realized by computer program instructions.These computer program instructions can be provided to the processor of a general-purpose computer, a special-purpose computer or other programmable data processing device to produce a machine so that these instructions executed by the processor of the computer or other programmable data processing device enable the realization of the function / action specified in one or more square boxes of the flow chart and / or the block diagram.Such a processor can be but is not limited to a general-purpose processor, a special-purpose processor, a special application processor or a field programmable logic circuit.It can also be understood that each square box in the block diagram and / or the flow chart and the combination of the square boxes in the block diagram and / or the flow chart can also be realized by the dedicated hardware that performs the specified function or action, or can be realized by the combination of dedicated hardware and computer instructions.

[0148] The above is only a specific implementation of the present invention. Those skilled in the art can clearly understand that for the convenience and simplicity of description, the specific working process of the system, module and unit described above can refer to the corresponding process in the aforementioned method embodiment, and will not be repeated here. It should be understood that the protection scope of the present invention is not limited to this. Any technician familiar with the technical field can easily think of various equivalent modifications or replacements within the technical scope disclosed by the present invention, and these modifications or replacements should be covered within the protection scope of the present invention.

Claims

1. A file generation method, characterized in that: The method comprises: Reversely analyze the script file corresponding to the submitted data to obtain a reverse file corresponding to the script file; wherein the reverse file includes: a data processing flow table and at least one data source table; Based on the type of the information to be processed in the reverse file, storing different types of the information to be processed in different data source tables respectively; splicing the information to be processed in the data source table to obtain sentence information; Splicing the sentence information of different sentence ranges to generate a target relationship table corresponding to the reported data; wherein the target relationship table is used to describe the source corresponding to the reported data; The information to be processed includes at least: data corresponding to the data processing flow in the data source table, symbols corresponding to the data processing flow in the data source table, and short sentences corresponding to the data processing flow in the data source table; The information to be processed in the data source table is spliced ​​to obtain sentence information, including: The data, symbols and short sentences corresponding to the data processing flow in the data source table are spliced ​​according to a preset splicing rule to obtain sentence information; The step of splicing the sentence information of different sentence ranges to generate a target relationship table corresponding to the reported data includes: Splicing the sentence information of different sentence ranges to obtain a temporary relationship table corresponding to the reported data; The empty fields in the temporary relationship table are supplemented with data, and the temporary data in the temporary relationship table is deleted to generate a target relationship table corresponding to the reported data.

2. The method according to claim 1, characterized in that: Before the information to be processed in the data source table is spliced ​​to obtain sentence information, the method further includes: Cleaning the information to be processed in the data source table to obtain cleaned information to be processed; The information to be processed in the data source table is spliced ​​to obtain sentence information, including: The cleaned information to be processed in the data source table is spliced ​​to obtain sentence information.

3. The method according to claim 2, characterized in that The step of cleaning the data in the data source to obtain cleaned information to be processed includes: Deleting duplicate data from the data source table; For the short sentences starting with preset characters in the data source table, rewrite them into short sentences that conform to the format of the target relationship table to obtain the cleaned information to be processed.

4. The method according to any one of claims 1 to 3, characterized in that: Before splicing the sentence information of different sentence ranges to generate the target relationship table corresponding to the reported data, the method further includes: Detecting a sentence range identifier corresponding to the sentence information; In the case where it is determined that the sentence range identifier is detected, the sentence range of the sentence information is determined.

5. A file generating device, characterized in that: The device comprises: A parsing module, used for reverse parsing the script file corresponding to the submitted data to obtain a reverse file corresponding to the script file; wherein the reverse file includes: a data processing flow table and at least one data source table; A storage module, used for storing different types of the information to be processed in different data source tables respectively based on the types of the information to be processed in the reverse file; A first splicing module is used to splice the information to be processed in the data source table to obtain sentence information; A second splicing module is used to splice the sentence information of different sentence ranges to generate a target relationship table corresponding to the reported data; wherein the target relationship table is used to describe the source corresponding to the reported data; The information to be processed includes at least: data corresponding to the data processing flow in the data source table, symbols corresponding to the data processing flow in the data source table, and short sentences corresponding to the data processing flow in the data source table; The information to be processed in the data source table is spliced ​​to obtain sentence information, including: The data, symbols and short sentences corresponding to the data processing flow in the data source table are spliced ​​according to a preset splicing rule to obtain sentence information; The step of splicing the sentence information of different sentence ranges to generate a target relationship table corresponding to the reported data includes: Splicing the sentence information of different sentence ranges to obtain a temporary relationship table corresponding to the reported data; The empty fields in the temporary relationship table are supplemented with data, and the temporary data in the temporary relationship table is deleted to generate a target relationship table corresponding to the reported data.

6. An electronic device, characterized in that: The method comprises a processor, a memory, and a program or instruction stored in the memory and executable on the processor, wherein the program or instruction, when executed by the processor, implements the steps of the file generation method as described in any one of claims 1 to 4.

7. A readable storage medium, characterized in that: The readable storage medium stores a program or instruction, and when the program or instruction is executed by the processor, the steps of the file generation method according to any one of claims 1 to 4 are implemented.

8. A computer program product, characterized in that When the instructions in the computer program product are executed by a processor of an electronic device, the electronic device executes the file generation method as described in any one of claims 1 to 4.

Images