Intelligent Processing System and Method for Grassroots Government Affairs Form Data

Abstract

The present invention relates to the technical field of government affairs data collection and processing, and discloses an intelligent processing system and method for grass-roots government affairs form data, including a processor module, and a data collection module, a form processing module, a data processing module, and a display module respectively connected to the processor module. By customizing an intelligent form and embedding the form into a web page, intelligent office with form linkage is realized. Then, the intelligent form is used to filter and process the big data of different services collected, achieving the effect of streamlining data. Subsequently, value analysis is performed on the data, and finally, the data analysis results are displayed in real time. The present invention has the beneficial effects of small data repeated calculation amount, reducing the workload of users, and improving work efficiency.

Description

Technical Field

[0001] The present invention relates to the technical field of government affairs data collection and processing, and particularly relates to an intelligent processing system and method for grass-roots government affairs form data. Background Art

[0002] With the popularization of digital office work, the traditional work mode has gradually changed into a digital online office mode. In the process of digital office work, the most important thing is the integrated processing of forms and data based on a big data platform. However, there are many problems in the existing online office technologies, such as a large number of forms, great randomness, repeated intersections, and data non-sharing.

[0003] To solve this problem, there is a method for processing information data of an e-government platform in the prior art, which includes the following steps: S1, a user sends instruction information through a computer terminal in a local area network subnet, and the instruction information is sent to a management terminal through a switch, and the management terminal calls instruction data in a data server; S2, after the management terminal calls the instruction data in the data server, if it is the instruction information called by the user, user permission judgment is performed; S3, through signature attributes and verification codes, if it is a user with permission, data display and modification are performed, and the modified data is uploaded to a computer terminal in the local area network subnet, and the computer terminal in the local area network subnet stores the data in the data server; S4, the management terminal is connected to the computer terminal in the local area network subnet, and according to the instruction of the computer terminal in the local area network subnet, each data reading goes through encrypted data filtering and security protection.

[0004] Although this solution can build an integrated management platform by integrating workflow technology, WEB form technology, and data access engine, it still has deficiencies in the intelligence of built-in forms and data optimization. Therefore, there is an urgent need to develop a government affairs processing system with a complex data intelligent integrated analysis and form integrated working mode to improve the work efficiency of form processing. Summary of the Invention

[0005] The present invention aims to provide an intelligent processing system and method for grass-roots government affairs form data to solve the technical problem of unsatisfactory intelligence in the joint processing of complex data and forms.

[0006] To achieve the above object, the present invention adopts the following technical scheme: An intelligent processing system for grass-roots government affairs form data includes a processor module, and a data collection module, a form processing module, a data processing module, and a display module that are respectively connected to the processor module;

[0007] The data collection module is used to collect data of different services to form a first data set and send the first data set to the data processing module;

[0008] A form processing module for performing customized and targeted editing and development operations on an embedded table to obtain an intelligent form and integrating the intelligent form into a web page;

[0009] A data processing module for performing streamlining processing on a first data set, accessing the first data set into a BI system in a fixed form, extracting data keywords to a management interface, and then setting visualization graphs according to the data keywords;

[0010] A processor module includes a data storage unit and a data analysis unit. The data storage unit is used to store the first data set collected by the data collection module; the data analysis unit is used to perform data value analysis on the collected first data set;

[0011] A display module for displaying the data value analysis results in real time.

[0012] The principle and advantages of this solution are: In practical applications, by customizing the form and integrating it into the web page, it is convenient for users to process data. At the same time, in the data processing process, different-dimensional dimensionality reduction methods are used to penetrate and structurally manage complex data with different data structures to achieve the effect of streamlining data, and then perform value analysis on the data, and use visualization graphs to display the analysis results in real time, enabling users to more intuitively understand the analysis results. Compared with the prior art, the advantages of the present invention are that it can make the form more intelligent and have richer functions through personalized customization of the form, which is convenient for data processing and improves work efficiency. At the same time, in the subsequent processing of big data and complex data, stream processing and key-value pairs are used to streamline and screen the data, which can effectively improve the data processing efficiency, and the form of using visualization graphs to display data can also enable users to have a more comprehensive understanding of the data information.

[0013] Preferably, as an improvement, the customized and targeted editing and development operations include built-in Js custom events, data column association with database fields, upper-level unit definition of table templates, recording filling history, and built-in common table data segments.

[0014] By customizing events in the form to enrich the form functions, thereby improving the data processing efficiency and the user work efficiency, better reflecting the work intelligence level of the form, reducing the cumbersome operations in the conventional mode, and improving the user experience.

[0015] Preferably, as an improvement, the custom events include quick search, display of multi-project target data column headers, row and column positions, quick jump, deletion of the current row, one-key insertion of index columns, insertion of characters at the unified position of existing data rows and columns, quick modification of the heads and tails of row and column data, editing cell operation permissions, vertical and horizontal merging of numerical columns, and intelligent prompt selection for filling specific multiple data.

[0016] Adding the above-mentioned multiple functional events makes the form more functional and also greatly improves the intelligence of the form. It can not only realize multi-level reporting of the reporting system and intelligent association of data, but also the forms can be linked to realize intelligent office and improve office efficiency.

[0017] Preferably, as an improvement, the simplification process of the first data set includes the following contents:

[0018] Classifying the first data set according to data form;

[0019] Adopt different data processing methods according to the current data volume;

[0020] Perform hierarchical dimension reduction on the data and finally extract the simplified valid data;

[0021] By simplifying the collected data in this step, not only can useless data be effectively filtered out, but also the huge amount of data can be simplified for statistics, thereby improving work efficiency and data accuracy.

[0022] Preferably, as an improvement, the data form includes structured data and unstructured data.

[0023] The collected data is divided into structured data and unstructured data, and distinguished based on the nature of the data so that targeted data processing methods can be adopted later, thereby ensuring that the data processing effect and processing efficiency are optimal, improving work efficiency and reducing the user's workload.

[0024] Preferably, as an improvement, when processing structured data, big data is converted into stream processing, and data in the form of key-value pairs is obtained by adopting a step-by-step dimension reduction processing method.

[0025] When processing structured data, if you encounter a huge amount of data, stream processing is used, and for data in the form of key-value pairs, dimensionality reduction is performed step by step. This can not only effectively streamline the data, but also improve the efficiency of the data, thereby speeding up data processing and improving office efficiency.

[0026] Preferably, as an improvement, when processing non-structured data, corresponding data is collected and organized, a matching template library is established, and matching rules of relevant data are retrieved from the template library to perform data extraction.

[0027] When the collected data is unstructured data, a matching template library is established, and the matching rules in the library are used to extract data, thereby filtering the data to achieve the purpose of streamlining statistical data.

[0028] Preferably, as an improvement, the visualization graphics include pie charts, bar charts and line charts.

[0029] Using pie charts, bar charts, and line charts, these three different forms of graphics to display data can not only make the changes in the data more vivid, but also adopt different graphics for different types of data to improve the data display effect.

[0030] The present invention also provides an intelligent processing method for grass-roots government affairs form data, including the following steps:

[0031] Step S1, perform customized and targeted editing and development operations on the embedded form to obtain an intelligent form, and integrate the intelligent form into the web page;

[0032] Step S2, after collecting data from different services, use the intelligent form to perform refined processing on the data, and adopt distributed computing to perform data value analysis on the processed data;

[0033] Step S3, extract data keywords as graphic content and use visual graphics to display the data value analysis results in real time.

[0034] Through this method, complex big data can be processed using forms, and different types of data can be classified and statistically analyzed and then displayed using graphics, making the data characteristics more obvious and vivid, facilitating users to view. At the same time, through the collaborative office of the intelligent form, the work efficiency can also be greatly improved.

[0035] Preferably, as an improvement, the graphic color, size, and the data corresponding to the graphic of the visual graphic can be dynamically adjusted.

[0036] By changing the color, size, and the data corresponding to the graphic, it can be dynamically adjusted, which can not only make the display effect of the image better, but also adjust the data corresponding to the graphic, improving the display accuracy of the graphic data. BRIEF DESCRIPTION OF THE DRAWINGS

[0037] Figure 1 It is a system schematic diagram of the first embodiment of the intelligent processing system for grass-roots government affairs form data of the present invention.

[0038] Figure 2 It is a flow schematic diagram of the first embodiment of the intelligent processing method for grass-roots government affairs form data of the present invention. DETAILED DESCRIPTION OF THE EMBODIMENTS

[0039] The following is a further detailed description through specific embodiments:

[0040] The marks in the attached drawings of the specification include: processor module 1, data acquisition module 2, form processing module 3, data processing module 4, display module 5, data storage unit 6, data analysis unit 7.

[0041] Embodiment 1:

[0042] This embodiment is basically as shown in the appendix Figure 1 : A grass-roots government affairs form data intelligent processing system, including a processor module 1, and a data acquisition module 2, a form processing module 3, a data processing module 4, and a display module 5 that are respectively connected to the processor module 1;

[0043] The data acquisition module 2 is used to collect data of different services to form a first data set, and send the first data set to the data processing module 4;

[0044] The form processing module 3 is used to perform customized and directional editing and development operations on the embedded form to obtain an intelligent form, and integrate the intelligent form into the web page;

[0045] The data processing module 4 is used to perform refined processing on the first data set, and connect the first data set to the BI system in a fixed form (prior art, not elaborated here), extract data keywords to the management interface, and then set visualization graphs according to the data keywords;

[0046] The processor module 1 includes a data storage unit 6 and a data analysis unit 7. The data storage unit 6 is used to store the first data set collected by the data acquisition module 2; the data analysis unit 7 is used to perform data value analysis on the collected first data set;

[0047] The display module 5 is used to display the data value analysis results in real time.

[0048] Performing customized operations on the form, including built-in Js custom events, data column association with database fields, upper-level unit definition of form templates, recording filling history, and built-in common form data segments;

[0049] Among them, the custom events include quick search, display of multi-project target data column headers, row and column positions, quick jump, deletion of the current row, one-key insertion of index columns, insertion of characters at the same position in existing data rows and columns, quick modification of the head and tail of row and column data, editing cell operation permissions, vertical and horizontal merging of numerical columns, and intelligent prompt selection for filling specific multiple data.

[0050] The data column is associated with the database field. The table column binds to the data source to automatically obtain data, and synchronizes to the database after modification and saving. The cell data binds to custom metrics and is updated automatically in real time.

[0051] The upper-level unit defines the form template, customizes the data column format in combination with filling indicators, and builds in data verification to ensure accurate and effective filling.

[0052] Record the filling history, generate filling instrument data with one key, monitor the filling process, and locate problems in a timely manner.

[0053] When performing streamlining processing on the first data set, first classify the first data set according to the data form, then adopt different data processing methods according to the current data volume, and then perform hierarchical dimensionality reduction processing on the data. Specifically, for the complex data structure of form upload and filling data, the outermost structure of the data is information such as table name, version, and multiple sheet arrays. The second layer is the sheet layer, which contains information such as sheet name, header, merged cell description, and data. The third layer of data contains multiple cell information. The fourth layer of cell contains height and width information, data type, font information, content information, etc. The fifth layer of content is the data of the current cell. Finally, extract the effective streamlined data.

[0054] The collected data includes structured data and unstructured data. When processing structured data, it is determined according to the current data volume. Big data is converted into stream processing, and the key-value pair form data is processed by hierarchical determination and dimensionality reduction to obtain data. When processing unstructured data, because of its numerous matching rules, large matching quantity, and wide range, relevant data is collected and sorted out, a matching template library is established, and the matching rules of relevant data are retrieved from the template library for data extraction. For example, when extracting data from a work order system, since the data is irregular and there is no fixed format for data with different work contents, when extracting information such as the username of the dispatched task and the required completion time of the task, pre-judgment is made according to the content before and after the data to be extracted, multiple regular rules are written, and the matching degree of the rules in a data statistics is recorded for preferential use next time.

[0055] Visualization graphs include pie charts, bar charts, and line charts, which can more clearly and vividly display data analysis content externally, and the graph colors, sizes, and data corresponding to the graphs of the visualization graphs can be dynamically adjusted.

[0056] As attached Figure 2 shown, the present invention also provides an intelligent processing method for grass-roots government affairs form data applied to the above system, including the following steps:

[0057] Step S1, perform customized and targeted editing and development operations on the embedded form to obtain an intelligent form, and integrate the intelligent form into the web page;

[0058] Step S2, after collecting data from different services, use the intelligent form to perform refined processing on the data, and perform data value analysis on the processed data by adopting distributed computing;

[0059] Step S3, extract data keywords as graphic content and use visualization graphs to display the data value analysis results in real time.

[0060] This solution integrates the personalized customized form into the web page, thereby improving the data processing efficiency. While using different dimensionality reduction methods to integrate and structurally manage complex data with different data structures, it will specifically and accurately identify the unstructured data or the content of non-statistical items. And for the preservation of useful information and the regular deletion of temporary information, etc., unified and standardized management operations are carried out. For the deleted conflicting data and useless data, secondary judgment will be carried out to avoid accidental situations such as misdeletion, which may lead to the loss of useful data. Finally, the refined analysis of big data is realized, the data processing efficiency is improved, and at the same time, visual graphs are used to comprehensively display the data, improving the user's understanding and clarity of the data.

[0061] The specific implementation process of this embodiment is as follows:

[0062] In the first step, the embedded table is subjected to customized and directional editing and development operations through the form processing module 3. Operations such as building in Js custom events for the table, associating data columns with database fields, defining the table template for the upper-level unit, recording the filling history, and building in common table data segments are carried out on the table. After obtaining the intelligent form, the intelligent form is integrated into the web page.

[0063] In the second step, after using the data collection module 2 to collect data from different services, the intelligent form is used to refine the data. First, the collected first data set is classified according to the data forms of structured data and unstructured data. When processing structured data, it is determined according to the current data volume. For big data, it is converted into a stream for processing, and for key-value pair data, a step-by-step determination and dimensionality reduction processing method is adopted to obtain the data. When processing unstructured data, because of its numerous matching rules, large number of matches, and wide range, relevant data is collected and sorted out, a matching template library is established, and the matching rules of relevant data are retrieved from the template library for data extraction.

[0064] In the third step, the data is subjected to hierarchical dimensionality reduction processing to simplify the data. Finally, the effective data after simplification is extracted. Then, the data value analysis of the processed data is carried out in a distributed computing manner, entering the data pool market, building a user portrait, extracting each attribute of the portrait in the warehouse as the model data structure, using technologies such as caching and cloud computing, and combining analysis algorithms to respond to the collation of model data. With a single server as a node support, a microservice architecture is deployed: service registration, service configuration sharing, gateways, fuses, load balancing, etc. are adopted to ensure high concurrency and high throughput of the system to achieve second-level response.

[0065] In the fourth step, during the data analysis and processing, targeted and accurate identification will be carried out for the content of unstructured data or non-statistical items, and unified and standardized management operations will be carried out for the preservation of useful information and the regular deletion of temporary information. A secondary judgment will be made for the deleted conflicting data and useless data. After the analysis is completed, data keywords will be extracted as graphic content, and then visual graphics, including pie charts, bar charts and line charts, will be used to display the data value analysis results in real time.

[0066] There are many problems in traditional office work, such as the inability of forms to link with office work, the inability of data to communicate with each other, or in a small number of systems that can achieve linked office work, there are problems of conflicts after data linkage, and forms cannot be applied on web pages, resulting in low office efficiency. With the development and application of intelligent office technology, in order to improve work efficiency, save time and intermediate process costs, more and more companies have turned their attention to the field of intelligent office. In the government office processing technology in the existing technology, such as the information data processing method of the e-government platform, an integrated platform is built by adopting web technology, integrating workflow technology, and WEB form technology, which promotes the standardization and scientificization of business management and improves the efficiency of business management.

[0067] In this solution, the form is first customized, and built-in Js custom events, database fields associated with data columns, upper-level unit definition form templates, record filling history and built-in public form data fragments are added to the form, making the form a more intelligent form, and integrating the form with the web page. Different forms can also be linked. At the same time, in order to avoid data conflicts during linkage operations, the data will be classified and sub-itemed when the form is linked. At the same time, the data with strong confidentiality is internally encrypted and stored. Based on this, this solution can greatly improve the daily office efficiency of the staff. When processing data, the form can divide the collected data into structured data and unstructured data and perform targeted filtering and streamlining. Then, the streamlined data is analyzed for value, and the data is connected to the BI system. The data keywords are extracted as the content of the graphic and the analysis results are then displayed in a concrete way with visual graphics. It can not only effectively improve the efficiency of the traditional working mode, but also achieve more accurate calculation and analysis results through intelligent forms combined with data simplification.

[0068] Embodiment 2:

[0069] This embodiment is basically the same as the first embodiment, except that when the data value analysis results are displayed in real time, the color, size and corresponding data of the visualization graphics can be dynamically adjusted.

[0070] The specific implementation process of this embodiment is the same as that of the first embodiment, except that:

[0071] In the fourth step, during the data analysis and processing, targeted and precise identification will be carried out for unstructured data or content of non-statistical items. Unified and standardized management operations will be carried out for the preservation of useful information and the regular deletion of temporary information. Secondary judgment will also be carried out on the deleted conflicting data and useless data. After the analysis is completed, data keywords will be extracted as graphic content, and then visual graphs, including pie charts, bar charts, and line charts, will be used to display the data value analysis results in real time. When displaying the graphs, the data to be highlighted and its corresponding graph will be highlighted in red, the data involving the change rate and its corresponding graph will be marked in yellow, and the regular data and its corresponding graph will be marked in black.

[0072] By highlighting key data and graphs with different colors, users can find key targets more quickly when viewing the analysis results, which is convenient for users to view, can also highlight the key content of this data analysis result, reduce intermediate links, and improve office efficiency.

[0073] Embodiment 3:

[0074] This embodiment is basically the same as Embodiment 1, except that: the data source of the table can be associated with common databases such as Oracle, Mysql, and SQLServer, and the table content is synchronously mapped with the data. Combining the built-in API of the plugin makes the data slicing operation more convenient.

[0075] The specific implementation process of this embodiment is the same as that of Embodiment 1, except that:

[0076] In the first step, through the form processing module 3, customized and directional editing and development operations are carried out on the embedded table. Operations such as built-in Js custom events for the table, associating database fields with data columns, defining the table template by the upper-level unit, recording the filling history, and built-in common table data fragments are carried out. At the same time, the data source of the table can be associated with common databases such as Oracle, Mysql, and SQLServer, and the table content is synchronously mapped with the data. After obtaining the intelligent form, the intelligent form is integrated into the web page. Combining the built-in API of the plugin makes the data slicing operation more convenient.

[0077] By increasing the data source of the table and synchronously mapping the table content with the data, during the subsequent data analysis and processing and graph display processes, the form combines the built-in API of the plugin, making the data slicing operation more convenient, thereby effectively improving the data processing efficiency of the form and further improving the overall office efficiency.

[0078] The above are only embodiments of the present invention, and common general technical solutions and / or characteristics in the solutions are not described in detail herein. It should be noted that for those skilled in the art, without departing from the technical solution of the present invention, several modifications and improvements can be made, which should also be regarded as the protection scope of the present invention, and these will not affect the implementation effect of the present invention and the practicality of the patent. The protection scope claimed in this application shall be subject to the content of its claims, and the specific implementation manners and the like recorded in the specification can be used to interpret the content of the claims.

Claims

1. An intelligent processing system for grass-roots government form data, characterized in that: It includes a processor module, as well as a data acquisition module, a form processing module, a data processing module, and a display module that are respectively connected to the processor module; The data acquisition module is used to collect data of different services to form a first data set and send the first data set to the data processing module; The form processing module is used to perform customized and directed editing and development operations on the embedded table to obtain an intelligent form and integrate the intelligent form into the web page; The data processing module is used to perform streamlined processing on the first data set, access the first data set into the BI system in a fixed form, extract data keywords to the management interface, and then set visualization graphs according to the data keywords; The processor module includes a data storage unit and a data analysis unit. The data storage unit is used to store the first data set collected by the data acquisition module; The data analysis unit is used to perform data value analysis on the collected first data set; The display module is used to display the data value analysis results in real time; The customized and directed editing and development operations include built-in Js custom events, data column association with database fields, upper-level unit definition of table templates, record filling history, and built-in common table data segments; The data column association with database fields binds the data source for the table column to automatically obtain data, and synchronizes it to the database after modification and saving. The cell data is bound to custom metrics and is automatically calculated and updated in real time; The custom events include quick search, display of multi-project target data column headers, row and column positions, quick jump, deletion of the current row, one-key insertion of index columns, insertion of characters at the unified position of existing data rows and columns, quick modification of the head and tail of row and column data, editing cell operation permissions, vertical and horizontal merging of numeric columns, and intelligent prompt selection for filling multiple data; The streamlined processing of the first data set includes: Classifying the first data set according to the data form; the data form includes structured data and unstructured data; Adopting different data processing methods according to the size of the current data volume; when processing structured data, big data is converted into stream processing, and key-value pair form data adopts a step-by-step judgment and dimensionality reduction processing method to obtain data; when processing unstructured data, relevant data is collected and sorted, a matching template library is established, and the matching rules of relevant data are retrieved from the template library for data extraction; Performing hierarchical dimensionality reduction processing on the data, and finally extracting the streamlined effective data; The hierarchical dimensionality reduction processing includes: the complex data structure of the form upload and filling data, the outermost structure of the data is the table name, version, and multiple sheet array information, the second layer is the sheet layer, including sheet name, header, merged cell description, and data information, the third layer data contains multiple cell cell information, the fourth layer cell contains height and width information, data type, font information, and content content information, and the fifth layer content is the current cell data; When performing hierarchical dimensionality reduction processing, targeted and precise identification is carried out for unstructured data or content of non-statistical items. For the preservation of useful information and the regular deletion of temporary information, unified and standardized management operations are carried out. For the deleted conflicting data and useless data, secondary judgment is carried out.

2. The intelligent processing system for grass-roots government affairs form data according to claim 1, characterized in that: The visualization graphs include pie charts, bar charts, and line charts.

Images