Method and system for simplifying filling in data collection process

Abstract

The invention relates to the technical field of computers, in particular to a method and system for simplifying filling in the data collection process, and the method comprises the following steps: establishing a data summarization process, developing a unified data collection interface, receiving data from different filling persons, and defining data formats and field requirements; constructing a main data table and a filling person information table in a database, ensuring one-to-one correspondence between data and filling person information through an association relationship, ensuring data consistency and integrity by adopting transactional processing, and establishing a data monitoring mechanism; the method and the system for simplifying filling in the data collection process have the beneficial effects that when a data filling task is issued and filling is completed by a person in charge, information of filled data is combed, a data summarization process is established, a data structure is optimized, and existing data is summarized into a data table, so that the data collection efficiency is improved. And matching the filled data with related information corresponding to the filling person in the summarizing process.

Description

Technical Field

[0001] The present invention relates to the field of computer technology, and in particular to a method and system for simplifying filling in data during data collection. Background Art

[0002] When using the data reporting platform, when various departments are implementing the data collection process, users often encounter the problem of repeatedly filling in the same or similar data in different tasks. This operation is not only very time-consuming, but also very prone to errors during the filling process.

[0003] In order to solve the problem of such repetitive operations, the present invention provides a method for simplifying filling in the data collection process, which can store records of historical filled-in data and support automatic filling and reuse of data through intelligent recognition and matching in new filling tasks. Summary of the invention

[0004] The purpose of the present invention is to provide a method and system for simplifying filling in data during the data collection process to solve the problems raised in the above-mentioned background technology.

[0005] To achieve the above object, the present invention provides the following technical solution: a method for simplifying filling in data during data collection, the method comprising the following steps:

[0006] Establish a data aggregation process, develop a unified data collection interface, receive data from different informants, and clarify data formats and field requirements;

[0007] Construct a master data table and a filler information table in the database, ensure one-to-one correspondence between data and filler information through association relationships, use transactional processing to ensure data consistency and integrity, and establish a data monitoring mechanism;

[0008] A "reuse data" function area is added to the front-end data reporting page for quick retrieval and display of historical data.

[0009] Preferably, the data aggregation process further includes the following steps:

[0010] When designing the interface, include a field for identifying the person filling out the form, and store the reported data and the information of the person filling out the form together in the database;

[0011] The data monitoring mechanism records in detail the time consumed and operation result information of each link of data submission, processing and storage, so as to facilitate subsequent problem tracking and troubleshooting.

[0012] Preferably, the multiplexing data function area of ​​the front-end data filling page also includes the following steps:

[0013] Provide multiplexed table data and multiplexed reporting task data for the reporter to choose;

[0014] Introduce a front-end cache mechanism to temporarily store the data tables or data reporting tasks that have been recently selected or reused by the reporting personnel, so that they can be quickly selected next time.

[0015] Preferably, in the multiplexing data function area, the following steps are also included:

[0016] Select the task name that has been filled in, call the background interface to obtain the corresponding field information of the task, associate and map the field information, and form data reuse rules;

[0017] Select whether to append data, and select the data filling method, including overwrite filling and supplementary filling.

[0018] Preferably, when the data reuse operation is triggered, the back-end API interface receives the reused data acquisition request, retrieves the reported data from the database, and returns the retrieved data to the front end in JSON format; at the same time, a rule engine is developed on the front end to process the logic of reused data echo, ensure that the data is displayed according to established rules, and provide a loading progress bar during the data acquisition and echo process.

[0019] A system for simplifying filling in data during data collection is applied to a method for simplifying filling in data during data collection, and the system comprises:

[0020] The data aggregation module is used to develop a unified data collection interface to receive data from different informants, and to build a relational database containing a master data table and an informant information table in the database, ensuring that the data corresponds to the informant information one by one through the association relationship;

[0021] The transaction processing module is used to perform transaction processing on the interface to ensure the consistency and integrity of data when it is written into the database;

[0022] The data monitoring module is used to monitor the data entry process, record key indicators and information of each link, so as to facilitate subsequent problem tracking and troubleshooting.

[0023] Preferably, the data aggregation module further includes:

[0024] Data format and field requirement design unit, used to specify the data format and field requirements required by the interface;

[0025] The reporting person identification unit is used to design a field to identify the reporting person during the data transmission process, and store the reported data and the reporting person information together in the database.

[0026] Preferably, it also includes a front-end data filling page, including:

[0027] The reused data function area is used to provide reused table data and reused reporting task data for the reporter to choose, and quickly retrieve historical data for echo reporting;

[0028] The front-end cache mechanism is used to temporarily store the data tables or data reporting tasks that have been recently selected or reused by the reporting personnel, so that they can be quickly selected next time.

[0029] Preferably, the multiplexed data function area also includes:

[0030] A task selection unit is used to select a task name that has been filled in;

[0031] The field mapping unit is used to call the background interface to obtain the field information corresponding to the task according to the selected reported task, and associate and map the field information with the model field information in the current data reporting task to form a data reuse rule;

[0032] A data append selection unit, used to select whether to append data;

[0033] The data filling mode selection unit is used to select overlay filling or supplementary filling as the data filling mode.

[0034] Preferably, it also includes:

[0035] The data reuse execution module is used to trigger the data reuse operation in the function interface of the reused data, perform data acquisition and echo operations, and provide a loading progress bar to inform the user that the operation is in progress;

[0036] The back-end API interface is used to receive the reused data acquisition request from the front-end, retrieve the reported data from the database, and return the retrieved data to the front-end in JSON format;

[0037] The rule engine development module is used to develop the rule engine on the front end, process the logic of multiplexing data echo, and ensure that the data is displayed according to the established rules;

[0038] Access control module is used to ensure that only authorized users can access the reported data.

[0039] Compared with the prior art, the present invention has the following beneficial effects:

[0040] The method and system for simplifying filling in the data collection process proposed by the present invention, when a data reporting task is issued and the person in charge completes the filling, sorts out the information of the reported data, establishes a data summary process, optimizes the data structure, summarizes the existing data into a data table, and matches the reported data with the relevant information corresponding to the reporter during the summary process. When there is a new assigned task to fill in, the reporter can selectively reuse the previous data to achieve simplified filling of the data. By reusing the reporting data of the reporting task in the data reporting platform, the work flow of the reporting staff is simplified, while the efficiency of the reporting is improved, and the intelligent matching of the reported data is achieved. BRIEF DESCRIPTION OF THE DRAWINGS

[0041] Figure 1 The figure is a flow chart of the method of the present invention. DETAILED DESCRIPTION

[0042] In order to make the purpose and technical solution of the present invention clearly and completely described, and the advantages more clearly understood, the embodiments of the present invention are further described in detail with reference to the accompanying drawings. It should be understood that the specific embodiments described herein are part of the embodiments of the present invention, rather than all of the embodiments, and are only used to explain the embodiments of the present invention, and are not used to limit the embodiments of the present invention. All other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0043] For example, see Figure 1 The present invention provides a technical solution: a method for simplifying filling in data during data collection, the method comprising the following steps:

[0044] (1) Establishing a data aggregation process

[0045] First, a unified data collection interface is developed to receive data submitted by different informants. When designing the interface, the required data format and field requirements are clearly specified. During the data transmission process, a field is designed to identify the informant, and the reported data and informant information are stored in the database together. In terms of database selection, a relational database is used to construct the data table, which includes a master data table and an informant information table. By establishing an association between the two tables, it is ensured that the reported data corresponds to the actual informant's information.

[0046] In addition, in order to improve the reliability of the reported data, the transactional interface is used to process the interface to ensure that the reported data and the information of the reporter are completely successful when writing to the database, or completely rolled back when an error occurs, so as to maintain the consistency and integrity of the reported data. In addition, a data monitoring mechanism is established during the data aggregation process to promptly follow up on the warehousing process of the reported data, including key indicators such as the amount of data received and the success rate of data reporting. At the same time, the time spent on each link of the submission, processing, and warehousing of the reported data, as well as the operation results, are recorded in detail to facilitate subsequent problem tracking and troubleshooting.

[0047] (2) Add reuse process to the filling page

[0048] First, a "Reuse Data" function area is added to the front-end data reporting page. The reuse data area contains reuse table data and reuse reporting task data for the reporter to choose. It can help the reporter to quickly retrieve the previously reported historical data according to actual needs (such as date, person name, person ID number, etc.) for data echo reporting.

[0049] In order to improve the user experience of the front-end reporting page, a front-end caching mechanism is introduced on the front-end reporting page to temporarily store the data tables or data reporting tasks that have been recently selected or reused by the reporter on the front end so that they can be quickly selected the next time they are used.

[0050] (3) Select data reuse tasks and reuse rules

[0051] a) Select the task name:

[0052] In the reuse data function area, select the task name that has been filled in. The task selected at this time is the task name that has been successfully stored in the database.

[0053] b) Matching field mapping

[0054] A new interface is added to obtain the reported tasks based on the login information. According to the selected reported tasks, the background interface for obtaining the corresponding field information of the task is called to obtain the corresponding model field information in the reported tasks, and the field information is displayed on the left side of the task field mapping in the functional area. The corresponding model field information in the current data reporting task is displayed in a selection box on the right side of the functional area. The model field information corresponding to the two reporting tasks is associated and mapped. This mapping rule is the data reuse rule, and then the data will be reused according to the reuse rule.

[0055] c) Choose whether to append data

[0056] Add a selection box for whether to append data, which is used for adding data when data is reused. Whether to append data: If you select Yes, if the current person filling in the form has already filled in part of the data, if you continue to append data, the reused data will be appended below the data that has been filled in. The front-end page needs to adjust the subsequent data reuse logic accordingly; if you select No, all the reused data will be added from the beginning of the filling page.

[0057] d) Select data filling method

[0058] When filling the reused data into the current reporting page, it supports querying the data that has been successfully reported in the previous task according to the currently filled content (such as date, personnel name, personnel ID number, medical insurance account number, etc.). When the backend receives a request for reused data, it first retrieves the corresponding data from the database according to the filled content for data reuse. It also supports the reuse of the entire reporting task data. Add a data filling method selection box, and the data filling methods are divided into overwrite filling and supplementary filling. If you choose overwrite filling, when the reused data is echoed, regardless of whether there is some data that has been filled in the current reporting page, all of it will be reused and the filled data will be overwritten; if you choose supplementary filling, if there is some data that has been filled in the current reporting page, the filled data will not be overwritten, and the unfilled field content will be filled with the previous data.

[0059] (4) Intelligent data filling

[0060] In the function interface of reused data, select the task name, match the task field mapping rules, select "whether to append data", and select the data filling method. After all operations are completed, the data reuse operation is triggered to perform data acquisition and echo operations. During the data acquisition and echo process, a loading progress bar is provided to inform the user that the operation is in progress. The back-end API interface receives the reused data acquisition request from the front-end, and then retrieves the reported data from the database according to the selected condition information. This usually involves querying the data table of the reported task. At this time, it is necessary to ensure that the data table of the reported task has appropriate indexes to speed up the query speed, and optimize the SQL query statement for fast retrieval. At the same time, ensure that only authorized users can access the reported data. Return the retrieved data in JSON format to the front-end. At the same time, a rule engine is developed on the front-end to process the logic of the reused data echo to ensure that the data is displayed according to the established rules.

[0061] Embodiment 2, based on Embodiment 1, proposes a system for simplifying filling in data during data collection, which is applied to a method for simplifying filling in data during data collection. The system includes:

[0062] The data aggregation module is used to develop a unified data collection interface to receive data from different informants, and to build a relational database in the database that includes a master data table and an informant information table, ensuring a one-to-one correspondence between the data and the informant information through association relationships; it also includes: a data format and field requirement design unit, which is used to clarify the data format and field requirements required by the interface; a informant identification unit, which is used to design a field to identify the informant during the data transmission process, and store the reported data and the informant information together in the database.

[0063] The transaction processing module is used to perform transaction processing on the interface to ensure the consistency and integrity of data when it is written into the database;

[0064] The data monitoring module is used to monitor the data entry process, record key indicators and information of each link, so as to facilitate subsequent problem tracking and troubleshooting.

[0065] It also includes a front-end data reporting page, including: a reused data function area, which is used to provide reused table data and reused reporting task data for the reporter to choose, and quickly retrieve historical data for echo reporting; a front-end cache mechanism, which is used to temporarily store the data tables or data reporting tasks that the reporter has recently selected or reused, so that they can be quickly selected next time.

[0066] The data reuse function area also includes: a task selection unit, which is used to select the name of a task that has been reported; a field mapping unit, which is used to call the background interface to obtain the corresponding field information of the task according to the selected reported task, and associate the field information with the model field information in the current data reporting task to form data reuse rules; a data append selection unit, which is used to select whether to append data; a data filling method selection unit, which is used to select overwrite filling or supplementary filling as the data filling method.

[0067] It also includes: a data reuse execution module, which is used to trigger data reuse operations in the functional interface of reused data, perform data acquisition and echo operations, and provide a loading progress bar to inform users that the operation is in progress; a back-end API interface, which is used to receive reused data acquisition requests from the front-end, retrieve the reported data from the database, and return the retrieved data to the front-end in JSON format; a rule engine development module, which is used to develop a rule engine on the front-end, process the logic of reused data echo, and ensure that the data is displayed according to established rules; an access control module, which is used to ensure that only authorized users can access the reported data.

[0068] Although embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that various changes, modifications, substitutions and variations may be made to the embodiments without departing from the principles and spirit of the present invention, and that the scope of the present invention is defined by the appended claims and their equivalents.

Claims

1. A method for simplifying filling in data during data collection, characterized in that: The method comprises the following steps: Establish a data aggregation process, develop a unified data collection interface, receive data from different informants, and clarify data formats and field requirements; Construct the master data table and the informant information table in the database, ensure the one-to-one correspondence between the data and the informant information through association relationships, use transactional processing to ensure data consistency and integrity, and establish a data monitoring mechanism; A "reuse data" function area is added to the front-end data reporting page for quick retrieval and display of historical data.

2. The method for simplifying filling in data during data collection according to claim 1, characterized in that: The data aggregation process also includes the following steps: When designing the interface, include a field for identifying the person filling out the form, and store the reported data and the information of the person filling out the form together in the database; The data monitoring mechanism records in detail the time consumed and operation result information of each link of data submission, processing and storage, so as to facilitate subsequent problem tracking and troubleshooting.

3. The method for simplifying filling in data during data collection according to claim 1, characterized in that: The reuse data function area of ​​the front-end data filling page also includes the following steps: Provide multiplexed table data and multiplexed reporting task data for the reporter to choose; Introduce a front-end cache mechanism to temporarily store the data tables or data reporting tasks that have been recently selected or reused by the reporting personnel, so that they can be quickly selected next time.

4. The method for simplifying filling in data during data collection according to claim 1, characterized in that: In the multiplexing data function area, the following steps are also included: Select the task name that has been filled in, call the background interface to obtain the corresponding field information of the task, associate and map the field information, and form data reuse rules; Select whether to append data, and select the data filling method, including overwrite filling and supplementary filling.

5. The method for simplifying filling in data during data collection according to claim 1, characterized in that: When the data reuse operation is triggered, the back-end API interface receives the reused data acquisition request, retrieves the reported data from the database, and returns the retrieved data to the front-end in JSON format; at the same time, a rule engine is developed on the front-end to process the logic of reused data echo, ensure that the data is displayed according to the established rules, and provide a loading progress bar during the data acquisition and echo process.

6. A system for simplifying filling in data during data collection, applied to a method for simplifying filling in data during data collection as claimed in any one of claims 1 to 5, characterized in that: The system comprises: The data aggregation module is used to develop a unified data collection interface to receive data from different informants, and to build a relational database containing a master data table and an informant information table in the database, ensuring that the data corresponds to the informant information one by one through the association relationship; The transaction processing module is used to perform transaction processing on the interface to ensure the consistency and integrity of data when it is written into the database; The data monitoring module is used to monitor the data entry process, record key indicators and information of each link, so as to facilitate subsequent problem tracking and troubleshooting.

7. A system for simplifying filling in data collection process according to claim 6, characterized in that: The data aggregation module also includes: Data format and field requirement design unit, used to specify the data format and field requirements required by the interface; The reporting person identification unit is used to design a field to identify the reporting person during the data transmission process, and store the reported data and the reporting person information together in the database.

8. A system for simplifying filling in data collection process according to claim 6, characterized in that: It also includes the front-end data reporting page, including: The reused data function area is used to provide reused table data and reused reporting task data for the reporter to choose, and quickly retrieve historical data for echo reporting; The front-end cache mechanism is used to temporarily store the data tables or data reporting tasks that have been recently selected or reused by the reporting personnel, so that they can be quickly selected next time.

9. A system for simplifying filling in data during data collection according to claim 8, characterized in that: The multiplexed data functional area also includes: A task selection unit is used to select a task name that has been filled in; The field mapping unit is used to call the background interface to obtain the field information corresponding to the task according to the selected reported task, and associate and map the field information with the model field information in the current data reporting task to form a data reuse rule; A data append selection unit, used to select whether to append data; The data filling mode selection unit is used to select overlay filling or supplementary filling as the data filling mode.

10. A system for simplifying filling in data collection process according to claim 6, characterized in that: Also includes: The data reuse execution module is used to trigger the data reuse operation in the function interface of the reused data, perform data acquisition and echo operations, and provide a loading progress bar to inform the user that the operation is in progress; The back-end API interface is used to receive the reused data acquisition request from the front-end, retrieve the reported data from the database, and return the retrieved data to the front-end in JSON format; The rule engine development module is used to develop the rule engine on the front end, process the logic of multiplexing data echo, and ensure that the data is displayed according to the established rules; Access control module is used to ensure that only authorized users can access the reported data.

Images