CN112037074A - Visualization-based data file analysis method and device - Google Patents

Visualization-based data file analysis method and device Download PDF

Info

Publication number
CN112037074A
CN112037074A CN202010955589.6A CN202010955589A CN112037074A CN 112037074 A CN112037074 A CN 112037074A CN 202010955589 A CN202010955589 A CN 202010955589A CN 112037074 A CN112037074 A CN 112037074A
Authority
CN
China
Prior art keywords
data
file
data file
analyzed
dictionary
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.)
Granted
Application number
CN202010955589.6A
Other languages
Chinese (zh)
Other versions
CN112037074B (en
Inventor
朱鹏
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Bank of China Ltd
Original Assignee
Bank of China Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Bank of China Ltd filed Critical Bank of China Ltd
Priority to CN202010955589.6A priority Critical patent/CN112037074B/en
Publication of CN112037074A publication Critical patent/CN112037074A/en
Application granted granted Critical
Publication of CN112037074B publication Critical patent/CN112037074B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/06—Asset management; Financial planning or analysis
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/245—Query processing
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/248—Presentation of query results
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/20—Natural language analysis
    • G06F40/237—Lexical tools
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00—Arrangements for program control, e.g. control units
    • G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/44—Arrangements for executing specific programs
    • G06F9/451—Execution arrangements for user interfaces

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • Software Systems (AREA)
  • Computational Linguistics (AREA)
  • Business, Economics & Management (AREA)
  • Finance (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Accounting & Taxation (AREA)
  • Development Economics (AREA)
  • Marketing (AREA)
  • Strategic Management (AREA)
  • Game Theory and Decision Science (AREA)
  • Human Resources & Organizations (AREA)
  • Operations Research (AREA)
  • Economics (AREA)
  • Human Computer Interaction (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Technology Law (AREA)
  • General Business, Economics & Management (AREA)
  • Health & Medical Sciences (AREA)
  • Artificial Intelligence (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • General Health & Medical Sciences (AREA)
  • Stored Programmes (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses a method and a device for analyzing a data file based on visualization, wherein the method comprises the following steps: importing a data file to be analyzed based on a visual interface; acquiring a version identifier of a data file to be analyzed and each data field contained in the data file to be analyzed; inquiring a data dictionary for analyzing the data file to be analyzed from a plurality of data dictionaries configured in advance according to the version identification of the data file to be analyzed; and performing field conversion processing on each data field contained in the data file to be analyzed based on the data dictionary for analyzing the data file to be analyzed to obtain the analyzed data file. According to the invention, by integrating a plurality of data dictionaries of different versions, the analysis of data files of different versions can be realized; the analysis of the data file is realized based on the visual interface, and the direct analysis or query of business personnel or development personnel on the data file can be supported.

Description

Visualization-based data file analysis method and device
Technical Field
The invention relates to the technical field of software, in particular to a data file analysis method and device based on visualization.
Background
This section is intended to provide a background or context to the embodiments of the invention that are recited in the claims. The description herein is not admitted to be prior art by inclusion in this section.
The open fund service data exchange protocol is one kind of protocol for data exchange between fund agency and product managing company. The open fund service data exchange protocol file specifies the data format, data definition and data content adopted when data exchange is carried out between mechanisms in relevant services such as off-site open fund, stock company large set products and the like.
At present, an open fund registration Agent (TA) system and a commission system which are butted by an open fund service data exchange protocol both analyze an open fund service data exchange protocol file based on a background, and do not support direct analysis or query of service personnel or developers on the open fund service data exchange protocol file.
Disclosure of Invention
The embodiment of the invention provides a visual data file analysis method, which is used for solving the technical problem that the existing system for the butt joint of an open fund service data exchange protocol does not support business personnel or developers to directly analyze or inquire the open fund service data exchange protocol file, and comprises the following steps: importing a data file to be analyzed based on a visual interface; acquiring a version identifier of a data file to be analyzed and each data field contained in the data file to be analyzed; according to the version identification of the data file to be analyzed, inquiring a data dictionary for analyzing the data file to be analyzed from a plurality of data dictionaries configured in advance, wherein each data dictionary is used for analyzing the data file with one version identification; and performing field conversion processing on each data field contained in the data file to be analyzed based on the data dictionary for analyzing the data file to be analyzed to obtain the analyzed data file.
The embodiment of the invention also provides a device for analyzing the data file based on visualization, which is used for solving the technical problem that the existing system for butting the open fund service data exchange protocol does not support the direct analysis or query of the open fund service data exchange protocol file by the service personnel or the development personnel, and the device comprises: the data file importing module is used for importing a data file to be analyzed based on a visual interface; the file information acquisition module is used for acquiring the version identification of the data file to be analyzed and each data field contained in the data file to be analyzed; the data dictionary query module is used for querying a data dictionary for analyzing the data file to be analyzed from a plurality of pre-configured data dictionaries according to the version identification of the data file to be analyzed, wherein each data dictionary is used for analyzing the data file with one version identification; and the data file analysis module is used for carrying out field conversion processing on each data field contained in the data file to be analyzed based on the data dictionary for analyzing the data file to be analyzed to obtain the analyzed data file.
The embodiment of the invention also provides computer equipment for solving the technical problem that the existing system for butting the open fund service data exchange protocol does not support business personnel or developers to directly analyze or query the open fund service data exchange protocol file.
The embodiment of the invention also provides a computer readable storage medium, which is used for solving the technical problem that the existing system for the butt joint of the open fund service data exchange protocol does not support the direct analysis or query of the open fund service data exchange protocol file by service personnel or developers.
In the embodiment of the invention, after a data file to be analyzed is imported based on a visual interface, the version identification of the data file to be analyzed and each data field contained in the data file to be analyzed are obtained, and then the data dictionary for analyzing the data file to be analyzed is inquired from a plurality of data dictionaries configured in advance according to the version identification of the data file to be analyzed, and the data fields contained in the data file to be analyzed are subjected to field conversion processing based on the data dictionary for analyzing the data file to be analyzed to obtain the analyzed data file, compared with the technical scheme for realizing the file analysis of a data exchange protocol based on a background in the prior art, the embodiment of the invention integrates a plurality of data dictionaries with different versions to realize the analysis of the data files with different versions, and further realizes the analysis of the data file based on the visual interface, direct parsing or query of the data file by business personnel or developers can be supported.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts. In the drawings:
fig. 1 is a flowchart of a data file parsing method based on visualization according to an embodiment of the present invention;
fig. 2 is a schematic diagram of a main interface of a data file parsing tool provided in an embodiment of the present invention;
fig. 3 is a flowchart of an alternative visualization-based data file parsing method provided in an embodiment of the present invention;
FIG. 4 is a schematic diagram of a file window interface provided in an embodiment of the present invention;
fig. 5 is a schematic diagram of a file message information display interface provided in an embodiment of the present invention;
fig. 6 is a schematic diagram of a data dictionary visualization display interface provided in an embodiment of the present invention;
fig. 7 is a schematic diagram of a data file parsing apparatus based on visualization according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the embodiments of the present invention are further described in detail below with reference to the accompanying drawings. The exemplary embodiments and descriptions of the present invention are provided to explain the present invention, but not to limit the present invention.
The embodiment of the present invention provides a data file parsing method based on visualization, fig. 1 is a flowchart of a data file parsing method based on visualization provided in the embodiment of the present invention, and as shown in fig. 1, the method includes the following steps:
and S101, importing a data file to be analyzed based on a visual interface.
It should be noted that, in the embodiment of the present invention, the data file to be analyzed may be, but is not limited to, an open fund service data exchange protocol file, that is, a file for performing data analysis based on an open fund service data exchange protocol. In the embodiments of the present invention, an open fund service data exchange protocol file is taken as an example for description. In fact, the data file parsing method based on visualization provided in the embodiment of the present invention may be applied to any data file that is parsed based on data dictionaries of different versions.
Fig. 2 is a schematic diagram of a main interface of a data file parsing tool provided in an embodiment of the present invention, as shown in fig. 2, in a specific implementation, in the embodiment of the present invention, a text box may be set in a visual interface to input file path information of a data file to be parsed, and the data file to be parsed is imported into a system; a file import button can also be arranged in the visual interface, so that a user can conveniently import the file into the system, and the data file to be analyzed can be imported into the system.
It should be noted that, at present, the certificate and custody provides three versions of ZD20, ZD21, and ZD22, each version provides a different data dictionary, and the data interfaces of each version are about 30, and different interface files of different versions bring complexity of file parsing. In the embodiment of the invention, the aim of one-stop file analysis can be fulfilled by integrating a plurality of data dictionaries with different versions.
S102, acquiring the version identification of the data file to be analyzed and each data field contained in the data file to be analyzed.
Due to the data files of different versions, the data dictionaries of different versions are required to be used for analysis. In the embodiment of the invention, the data dictionaries with different versions are configured in the system in advance, so that the system can acquire the corresponding data dictionary for analysis according to the version identification of the current data file to be analyzed. It should be noted that, in the embodiment of the present invention, the data dictionary is used for converting data fields, so that types and lengths of data fields in data files from different data sources can be unified.
S103, inquiring a data dictionary for analyzing the data file to be analyzed from a plurality of pre-configured data dictionaries according to the version identification of the data file to be analyzed, wherein each data dictionary is used for analyzing the data file with one version identification.
In specific implementation, the system is pre-configured with the association relationship between each data dictionary and the version identifier, and after the version identifier of the data file to be analyzed is obtained, the data dictionary of the corresponding version is queried from the pre-configured multiple data dictionaries according to the version identifier of the data file to be analyzed, so as to analyze the data file to be analyzed.
And S104, performing field conversion processing on each data field contained in the data file to be analyzed based on the data dictionary for analyzing the data file to be analyzed to obtain the analyzed data file.
In specific implementation, for each data field included in the data file to be analyzed, conversion processing may be performed on each field based on the queried data dictionary, so as to obtain the analyzed data file.
As can be seen from the above, in the method for analyzing a data file based on visualization provided in the embodiments of the present invention, after a data file to be analyzed is imported based on a visualization interface, the version identifier of the data file to be analyzed and each data field included in the data file to be analyzed are obtained, and then according to the version identifier of the data file to be analyzed, a data dictionary for analyzing the data file to be analyzed is queried from a plurality of pre-configured data dictionaries, and based on the data dictionary for analyzing the data file to be analyzed, each data field included in the data file to be analyzed is subjected to field conversion processing, so as to obtain the analyzed data file. According to the data file analysis method based on visualization provided by the embodiment of the invention, the data files of different versions can be analyzed by integrating the data dictionaries of the different versions, the data files are analyzed based on the visualization interface, and direct analysis or query of business personnel or developers on the data files can be supported.
In an embodiment, as shown in fig. 3, after performing the above S104, the method for analyzing a data file based on a visualization provided in an embodiment of the present invention may further include the following steps:
and S105, outputting the analyzed data file based on the visualization mode.
Optionally, the S105 is further configured to output the parsed data file in a file window or an Excel file.
Through the embodiment, the analyzed data file is output in a visual mode, and related personnel can conveniently check the data file.
After outputting the data file in a visualized manner, in an embodiment, as shown in fig. 3, the method for analyzing the data file based on the visualization provided in the embodiment of the present invention may further include the following steps:
s106, receiving a data viewing instruction of target data in the visual data file;
and S107, outputting the data detail information of the target data according to the data viewing instruction of the target data.
Fig. 4 is a schematic view of a file window interface provided in an embodiment of the present invention, and as shown in fig. 4, a file body is analyzed and output by reading an interface identifier and a field name in a file. Double clicking on a row of data in fig. 4 may reveal data details as shown in fig. 5.
Optionally, the data file parsing method based on visualization provided in the embodiment of the present invention. In an embodiment, as shown in fig. 3, after executing the above S104, the method for analyzing a data file based on visualization provided in the embodiment of the present invention may further include the following steps:
s108, receiving a file generation instruction;
and S109, outputting the analyzed data file into a TXT format file according to the file generation instruction.
As shown in fig. 2, the message parsing area may export a message to generate a TXT format file.
In the embodiment of the present invention, when a data dictionary under the interfaces ZD21 and ZD22 is built in, and a dictionary configuration file is not found in an installation directory, the data dictionary may be automatically initialized through an initialization button in the interface shown in fig. 2.
In an embodiment, as shown in fig. 3, the method for analyzing a data file based on visualization provided in an embodiment of the present invention may further include the following steps:
s110, outputting each pre-configured data dictionary based on a visualization mode;
s111, receiving an operation instruction for executing at least one of the following operations on each data field in the visual data dictionary: adding, deleting, modifying and inquiring;
and S112, executing corresponding operation on each data field in the visual data dictionary according to the received operation instruction.
In the embodiment of the invention, the data dictionary is visually displayed, the free modification of the configuration file of the data dictionary is supported, the characteristic interface analysis can be realized, and more personalized service requirements are met.
As an optional implementation manner, when the preconfigured data dictionaries are output in a visualized manner, the preconfigured data dictionaries may be output in the form of an XML file or an Excel file.
After the built-in data dictionary is exported in the form of XML or EXCEL, the method can also support expanding a data dictionary window, and as shown in FIG. 6, can support business personnel or developers to perform operations such as adding, deleting, modifying, checking and the like on related fields.
Further, when the operation performed on each data field in the visualization data dictionary is addition, deletion, or modification, the visualization-based data file parsing method provided in the embodiment of the present invention may further include the following steps: acquiring each updated data dictionary; and outputting each updated data dictionary in the form of an XML file or an Excel file. When some fields are added, deleted or modified, the updated data dictionary can be output in the form of an XML file or an Excel file.
Optionally, in the embodiment of the present invention, the WPF is used to complete data transmission between windows, so as to achieve a function of analyzing each angle of the data file.
According to the data file analysis method based on visualization provided by the embodiment of the invention, a file analysis tool can be developed, a standard ZD21 and ZD22 version data dictionary is built in the tool, and file analysis is carried out based on the standard ZD21 and ZD22 version data dictionary; because of the file interface of the fund exchange protocol, the packet header comprises all field names related to the file, the sequence and the interface version identification of the file, and the type and the length of the field can be obtained by searching the field names in the packet header in a data dictionary; and forming a window view for the data dictionary, providing functions of adding, deleting, modifying and checking fields, outputting the data dictionary as an XML file, and realizing the persistence of the data dictionary. The tool can be realized based on WPF, the file content is read into the data table, and meanwhile, the data table and the window are used for realizing data binding.
Based on the same inventive concept, an embodiment of the present invention further provides a data file parsing apparatus based on visualization, as described in the following embodiments. Because the principle of the device for solving the problems is similar to the method for analyzing the data file based on the visualization, the implementation of the device can refer to the implementation of the method for analyzing the data file based on the visualization, and repeated parts are not repeated.
Fig. 7 is a schematic diagram of a data file parsing apparatus based on visualization provided in an embodiment of the present invention, as shown in fig. 7, the apparatus includes: a data file import module 71, a file information acquisition module 72, a data dictionary lookup module 73 and a data file parsing module 74.
The data file importing module 71 is configured to import a data file to be analyzed based on a visual interface; a file information obtaining module 72, configured to obtain a version identifier of the data file to be analyzed and each data field included in the data file to be analyzed; the data dictionary query module 73 is configured to query, according to the version identifier of the data file to be analyzed, a data dictionary for analyzing the data file to be analyzed from a plurality of pre-configured data dictionaries, where each data dictionary is used to analyze the data file with one version identifier; and the data file analyzing module 74 is configured to perform field conversion processing on each data field included in the data file to be analyzed based on the data dictionary used for analyzing the data file to be analyzed, so as to obtain an analyzed data file.
As can be seen from the above, the data file analyzing device based on visualization provided in the embodiment of the present invention imports the data file to be analyzed based on the visualization interface through the data file importing module 71; acquiring the version identifier of the data file to be analyzed and each data field contained in the data file to be analyzed through the file information acquisition module 72; inquiring a data dictionary for analyzing the data file to be analyzed from a plurality of pre-configured data dictionaries through a data dictionary inquiring module 73 according to the version identification of the data file to be analyzed; the data dictionary query module 73 performs field conversion processing on each data field included in the data file to be analyzed based on the data dictionary for analyzing the data file to be analyzed, so as to obtain the analyzed data file. The data file analyzing device based on visualization provided by the embodiment of the invention can realize the analysis of data files with different versions by integrating a plurality of data dictionaries with different versions, realize the analysis of the data files based on a visualization interface, and support business personnel or developers to directly analyze or query the data files.
In an embodiment, as shown in fig. 7, the data file parsing apparatus based on visualization provided in an embodiment of the present invention may further include: and a data file export module 75, configured to output the parsed data file based on a visualization manner.
Optionally, the data file export module 75 is further configured to export the parsed data file in a file window or an Excel file.
Optionally, the data file export module 75 is further configured to: receiving a file generation instruction; and outputting the analyzed data file into a TXT format file according to the file generation instruction.
In an embodiment, as shown in fig. 7, the data file parsing apparatus based on visualization provided in an embodiment of the present invention may further include: and the data query module 76 is used for receiving a data viewing instruction of the target data in the visualized data file and outputting data detail information of the target data according to the data viewing instruction of the target data.
In an embodiment, as shown in fig. 7, the data file parsing apparatus based on visualization provided in an embodiment of the present invention may further include: a data dictionary configuration module 77, configured to output each preconfigured data dictionary based on a visualization manner, and receive an operation instruction for performing at least one of the following operations on each data field in the visualization data dictionary: adding, deleting, modifying and inquiring; and executing corresponding operation on each data field in the visual data dictionary according to the received operation instruction.
In an embodiment, as shown in fig. 7, the data file parsing apparatus based on visualization provided in an embodiment of the present invention may further include: and the data dictionary export module 78 is used for outputting each data dictionary in the form of an XML file or an Excel file.
Optionally, the data dictionary export module 78 is further configured to export each preconfigured data dictionary in the form of an XML file or an Excel file.
The data dictionary export module 78 is further configured to obtain each updated data dictionary when the operation performed on each data field in the visualized data dictionary is addition, deletion or modification; and outputting each updated data dictionary in the form of an XML file or an Excel file.
Based on the same inventive concept, the embodiment of the present invention further provides a computer device, which is used to solve the technical problem that the existing system for interfacing the open fund service data exchange protocol does not support direct parsing or query of open fund service data exchange protocol files by service personnel or developers.
Based on the same inventive concept, the embodiment of the present invention further provides a computer readable storage medium, which is used to solve the technical problem that the existing system for interfacing the open fund service data exchange protocol does not support direct parsing or query of the open fund service data exchange protocol file by the service personnel or the developers, and the computer readable storage medium stores a computer program for executing the visualized data file parsing method.
In summary, embodiments of the present invention provide a method, an apparatus, a computer device and a computer-readable storage medium for analyzing a data file based on visualization, by entering different versions of the open fund data exchange protocol data dictionary provided by the witness, analyzing the data file based on the above-mentioned standard, automatically selecting correspondent dictionary version by means of version identification of file to implement analysis of file, compared with the technical scheme of realizing the analysis of the data exchange protocol file based on the background in the prior art, the method and the device for realizing the analysis of the data file in the data exchange protocol file based on the visual interface have the advantages that the analysis of the data file in different versions can be realized by integrating a plurality of data dictionaries in different versions, further, the analysis of the data file is realized based on the visual interface, and direct analysis or query of business personnel or developers on the data file can be supported.
By the embodiment of the invention, the following technical effects can be realized but not limited: firstly, supporting a plurality of interface versions of a plurality of versions, and realizing one-stop file analysis; supporting free modification of a data dictionary configuration file, and realizing characteristic interface analysis; and thirdly, the WPF is used for realizing an analysis tool, so that the system is light in weight, can be conveniently used for a WINDOWS system, and can be used for off-line analysis.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
The above-mentioned embodiments are intended to illustrate the objects, technical solutions and advantages of the present invention in further detail, and it should be understood that the above-mentioned embodiments are only exemplary embodiments of the present invention, and are not intended to limit the scope of the present invention, and any modifications, equivalent substitutions, improvements and the like made within the spirit and principle of the present invention should be included in the scope of the present invention.

Claims (15)

1. A visualization-based data file parsing method is characterized by comprising the following steps:
importing a data file to be analyzed based on a visual interface;
acquiring a version identifier of a data file to be analyzed and each data field contained in the data file to be analyzed;
according to the version identification of the data file to be analyzed, inquiring a data dictionary for analyzing the data file to be analyzed from a plurality of data dictionaries configured in advance, wherein each data dictionary is used for analyzing the data file with one version identification;
and performing field conversion processing on each data field contained in the data file to be analyzed based on the data dictionary for analyzing the data file to be analyzed to obtain the analyzed data file.
2. The method of claim 1, wherein after performing field conversion processing on each data field included in the data file to be parsed based on the data dictionary that parses the data file to be parsed, and obtaining the parsed data file, the method further comprises:
and outputting the analyzed data file based on a visualization mode.
3. The method of claim 2, wherein outputting the parsed data file based on a visualization comprises:
and outputting the analyzed data file in a file window or Excel file form.
4. The method of claim 2, wherein after outputting the parsed data file based on the visualization, the method further comprises:
receiving a data viewing instruction of target data in a visual data file;
and outputting the data detail information of the target data according to the data viewing instruction of the target data.
5. The method of claim 1, wherein after performing field conversion processing on each data field included in the data file to be parsed based on the data dictionary that parses the data file to be parsed, and obtaining the parsed data file, the method further comprises:
receiving a file generation instruction;
and outputting the analyzed data file into a TXT format file according to the file generation instruction.
6. The method of any of claims 1 to 5, further comprising:
outputting each pre-configured data dictionary based on a visualization mode;
receiving an operation instruction for executing at least one of the following operations on each data field in the visual data dictionary: adding, deleting, modifying and inquiring;
and executing corresponding operation on each data field in the visual data dictionary according to the received operation instruction.
7. The method of claim 6, wherein outputting the pre-configured data dictionaries based on a visualization comprises:
and outputting each pre-configured data dictionary in the form of an XML file or an Excel file.
8. The method of claim 6, wherein in the event that the operation performed on the respective data field in the visual data dictionary is an addition, deletion or modification, the method further comprises:
acquiring each updated data dictionary;
and outputting each updated data dictionary in the form of an XML file or an Excel file.
9. A visualization-based data file parsing apparatus, comprising:
the data file importing module is used for importing a data file to be analyzed based on a visual interface;
the file information acquisition module is used for acquiring the version identification of the data file to be analyzed and each data field contained in the data file to be analyzed;
the data dictionary query module is used for querying a data dictionary for analyzing the data file to be analyzed from a plurality of pre-configured data dictionaries according to the version identification of the data file to be analyzed, wherein each data dictionary is used for analyzing the data file with one version identification;
and the data file analysis module is used for carrying out field conversion processing on each data field contained in the data file to be analyzed based on the data dictionary for analyzing the data file to be analyzed to obtain the analyzed data file.
10. The apparatus of claim 9, wherein the apparatus further comprises:
and the data file export module is used for outputting the analyzed data file based on a visualization mode.
11. The apparatus of claim 9, wherein the apparatus further comprises:
and the data query module is used for receiving a data viewing instruction of the target data in the visual data file and outputting data detail information of the target data according to the data viewing instruction of the target data.
12. The apparatus of any of claims 9 to 11, further comprising:
the data dictionary configuration module is used for outputting each pre-configured data dictionary based on a visualization mode, and receiving an operation instruction for executing at least one of the following operations on each data field in the visualization data dictionary: adding, deleting, modifying and inquiring; and executing corresponding operation on each data field in the visual data dictionary according to the received operation instruction.
13. The apparatus of claim 12, wherein the apparatus further comprises:
and the data dictionary export module is used for outputting each data dictionary in the form of an XML file or an Excel file.
14. 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 visualization-based data file parsing method of any one of claims 1 to 8 when executing the computer program.
15. A computer-readable storage medium, wherein the computer-readable storage medium stores a computer program for executing the visualization-based data file parsing method according to any one of claims 1 to 8.
CN202010955589.6A 2020-09-11 2020-09-11 Visualization-based data file analysis method and device Active CN112037074B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010955589.6A CN112037074B (en) 2020-09-11 2020-09-11 Visualization-based data file analysis method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010955589.6A CN112037074B (en) 2020-09-11 2020-09-11 Visualization-based data file analysis method and device

Publications (2)

Publication Number Publication Date
CN112037074A true CN112037074A (en) 2020-12-04
CN112037074B CN112037074B (en) 2024-04-19

Family

ID=73588851

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010955589.6A Active CN112037074B (en) 2020-09-11 2020-09-11 Visualization-based data file analysis method and device

Country Status (1)

Country Link
CN (1) CN112037074B (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112965740A (en) * 2021-02-08 2021-06-15 中国工商银行股份有限公司 Method and device for exporting asset information
CN115334177A (en) * 2022-07-07 2022-11-11 浙江众合科技股份有限公司 Binary data message analysis method based on xml configuration file recursion

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107391500A (en) * 2017-08-21 2017-11-24 阿里巴巴集团控股有限公司 Text interpretation method, device and equipment
CN109542875A (en) * 2018-11-20 2019-03-29 中国银行股份有限公司 A kind of generation method and device of configuration file
CN110008266A (en) * 2019-03-13 2019-07-12 平安信托有限责任公司 Data interchange file analysis method and device
CN110263316A (en) * 2019-06-27 2019-09-20 深圳前海微众银行股份有限公司 A kind of document handling method, device and computer equipment
CN111176882A (en) * 2019-12-23 2020-05-19 平安信托有限责任公司 Specific data processing method, specific data processing device, computer equipment and storage medium

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107391500A (en) * 2017-08-21 2017-11-24 阿里巴巴集团控股有限公司 Text interpretation method, device and equipment
CN109542875A (en) * 2018-11-20 2019-03-29 中国银行股份有限公司 A kind of generation method and device of configuration file
CN110008266A (en) * 2019-03-13 2019-07-12 平安信托有限责任公司 Data interchange file analysis method and device
CN110263316A (en) * 2019-06-27 2019-09-20 深圳前海微众银行股份有限公司 A kind of document handling method, device and computer equipment
CN111176882A (en) * 2019-12-23 2020-05-19 平安信托有限责任公司 Specific data processing method, specific data processing device, computer equipment and storage medium

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112965740A (en) * 2021-02-08 2021-06-15 中国工商银行股份有限公司 Method and device for exporting asset information
CN112965740B (en) * 2021-02-08 2024-02-09 中国工商银行股份有限公司 Asset information export method and device
CN115334177A (en) * 2022-07-07 2022-11-11 浙江众合科技股份有限公司 Binary data message analysis method based on xml configuration file recursion
CN115334177B (en) * 2022-07-07 2023-12-05 浙江众合科技股份有限公司 Binary data message analysis method based on xml configuration file recursion realization

Also Published As

Publication number Publication date
CN112037074B (en) 2024-04-19

Similar Documents

Publication Publication Date Title
JP5302374B2 (en) Actionable email document
CN109495392B (en) Message conversion processing method and device, electronic equipment and storage medium
CN101739390B (en) Data transformation based on a technical design document
US20050114394A1 (en) Mapping XML schema components to qualified Java components
WO2008131028A2 (en) Enterprise integrated business proces schema
CN101529416A (en) Messaging model and architecture
CN112037074A (en) Visualization-based data file analysis method and device
CN110688830B (en) Credit investigation template conversion method and device
CN113360519B (en) Data processing method, device, equipment and storage medium
CN113449236A (en) Method and device for generating and storing electronic protocol of bank system
CN111198772A (en) Method and system for generating application program interface API
CN110351131B (en) Monitoring method and device for distributed link and electronic equipment
CN116450890A (en) Graph data processing method, device and system, electronic equipment and storage medium
CN110308907B (en) Data conversion method and device, storage medium and electronic equipment
US7765188B2 (en) Taxonomy editor
CN112818070A (en) Data query method and device based on global data dictionary and electronic equipment
CN117112510A (en) Report template configuration method, device, equipment and storage medium
CN113010208A (en) Version information generation method, version information generation device, version information generation equipment and storage medium
CN112783482A (en) Visual form generation method, device, equipment and storage medium
CN111311461A (en) B-S based editor and generation method for structured dynamic medical record form
CN115454956A (en) Log generation method and device, electronic equipment and storage medium
CN110737636B (en) Data import method, device and equipment
CN114296696A (en) Business function operation method and device, storage medium and electronic equipment
CN111046020B (en) Information processing method and device, storage medium and electronic equipment
CN109062797B (en) Method and device for generating information

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