CN-122021577-A - Sanitary monitoring method and system

CN122021577ACN 122021577 ACN122021577 ACN 122021577ACN-122021577-A

Abstract

The application provides a hygiene monitoring method which comprises the steps of obtaining Excel format original occupational hygiene monitoring data from multiple channels, analyzing the Excel format original occupational hygiene monitoring data, identifying fixed columns and dynamic columns in the Excel format original occupational hygiene monitoring data, storing the fixed columns into a main table database, storing the dynamic columns into a sub-table database, and integrating the data in the main table database and the sub-table database to generate a visual report in response to a user request. According to the application, the Excel format original occupational health monitoring data is obtained from multiple channels, analyzed, the fixed columns and the dynamic columns are respectively stored in the main table database and the sub-table database, and finally the visual report is generated according to the user request integrated data, so that the efficient processing and storage of the health monitoring data are realized. The method avoids the complicated process of manually inputting an Excel table and importing special statistical software for analysis in the prior art, and greatly improves the operation efficiency.

Inventors

ZHAO YONGMEI
WANG LEI
SUN RAN
WU JING

Assignees

北京市朝阳区疾病预防控制中心

Dates

Publication Date: 20260512
Application Date: 20260129

Claims (10)

1. A method of hygiene monitoring, the method comprising: acquiring Excel format original occupational health monitoring data from multiple channels; Analyzing the Excel format original occupational health monitoring data, and identifying a fixed column and a dynamic column in the Excel format original occupational health monitoring data; storing the fixed columns into a main table database, and storing the dynamic columns into a sub-table database; And responding to the user request, integrating the data in the main table database and the sub-table database to generate a visual report.
2. The method of claim 1, wherein parsing the Excel format raw occupational health monitoring data, identifying fixed columns and dynamic columns therein comprises: Setting a fixed whitelist and a dynamic whitelist; Matching the excel format original occupational health monitoring data with the fixed whitelist and the dynamic whitelist; for successfully matched data, marking the data as a fixed column or a dynamic column according to the classification of the white list; And marking the data which are not matched with the fixed white list or the dynamic white list as the list to be confirmed, and determining the data belonging to the fixed list or the dynamic list or the invalid list after manual auditing.
3. The method of claim 1, wherein parsing the Excel format raw occupational health monitoring data, identifying fixed columns and dynamic columns therein comprises: Based on historical occupational health monitoring data, evaluating the change condition of names of all columns of data in different data sources or different time periods; if the name of a certain column of data is kept relatively stable in a plurality of data sources or a longer period of time, judging the column as a fixed column; if the column name of a column of data is changed frequently or a diversified expression is presented in different data sources, the column is judged to be a dynamic column.
4. The method of claim 1, wherein storing the fixed column in a master table database and the dynamic column in a sub-table database comprises: Preprocessing the column headers, including removing excess space, unicode and case, removing special symbols, or using uniform separators; Defining attribute types; Traversing all column titles, and judging attribute types of each column title; generating an item-attribute-column position corresponding table; And according to the item-attribute-column position corresponding table, storing the data of the fixed column into a main table database according to the corresponding attribute type and column position, and storing the data of the dynamic column into a sub-table database according to the corresponding attribute type and column position.
5. The method of claim 1, wherein obtaining raw occupational health monitoring data in excel format from multiple channels comprises: importing original occupational health monitoring data from an external way and collecting the original occupational health monitoring data in real time through direct filling; The excel format original occupational health monitoring data comprises workplace occupational disease risk factor monitoring data and worker occupational disease monitoring data; The workplace occupational disease risk factor monitoring data comprise basic conditions of enterprises with occupational hazards, and the types and the intensities of the occupational disease risk factors contacted by workers during working; The monitoring data of the occupational diseases of the laborers comprise basic conditions of the laborers, all occupational health examination conditions of the laborers before the laborers are on duty, during the period of the laborers are on duty, when the laborers leave the duty and the laborers are in emergency health examination, various occupational disease new cases and death cases of the laborers, and urgent and chronic occupational poisoning basic conditions, severity and morbidity/mortality of the laborers.
6. The method of claim 1, wherein the converting the plurality of occupational health monitoring data into formatted occupational health monitoring data and storing in a business database comprises: Extracting the plurality of original occupational health monitoring data by adopting etl technology, and recording an extraction time stamp; Cleaning the extracted original occupational health monitoring data according to the business rules to remove repeated, invalid or abnormal data; Converting the cleaned data into formatted occupational health monitoring data meeting the preset format requirements; And storing the converted formatted occupational health monitoring data in a business database according to a preset classification rule.
7. The method of claim 1, wherein selecting different formatted professional health monitoring data from the database to generate a plurality of forms of visual reports using different presentation components comprises: selecting occupational health monitoring data to be displayed, judging the type of the occupational health monitoring data, Selecting a corresponding display assembly from a plurality of preset display assemblies according to the type of the staff health monitoring data, wherein when the staff health monitoring data are numerical data, a bar graph, a line graph or a pie graph and other display assemblies are selected for display; when the staff health monitoring data are text data, selecting display components such as a form, a tag cloud or a text box for display; when the staff health monitoring data are mixed data, selecting a combined chart display component for comprehensive display; binding the selected display component with the job hygiene monitoring data to generate a corresponding visual report.
8. The method of claim 6, wherein the step of cleaning the extracted original occupational health monitoring data according to the service rule to remove duplicate, invalid or abnormal data includes reserving a record of a latest time stamp in the duplicate data for the duplicate data, merging the duplicate data in different data sources, and judging and rejecting invalid data according to a preset service rule.
9. The hygiene monitoring method of claim 8, wherein the preset business rules comprise: Judging whether the data belong to enterprises in the monitoring range, and if the enterprises are not in the monitoring range, judging that the data are invalid data; Judging whether the data accords with a normal value range, and if the intensity value of the occupational disease hazard factor exceeds a reasonable interval, judging that the data is invalid; Judging whether the data accords with a logic relation, for example, the on-duty physical examination time of the laborers cannot be earlier than the on-duty physical examination time, and if the on-duty physical examination time of the laborers is earlier than the on-duty time, the data is invalid; Judging whether the data is complete or not, and if the basic condition data of the laborers lacks key information such as names, identification card numbers and the like, the data is invalid.
10. A hygiene monitoring system, characterized in that the system comprises at least one processor and a memory storing instructions which, when executed by the at least one processor, implement the steps of the method according to any one of claims 1-9.

Description

Sanitary monitoring method and system Technical Field The invention relates to the technical field of public health management, in particular to a health monitoring method and system. Background Professional health monitoring is an important means for comprehensively grasping the current situation of occupational disease hazard in important industries and evaluating occupational health risks. However, the existing health monitoring means manually inputs various data such as basic conditions of occupational hazard enterprises, basic conditions of laborers, monitoring results of occupational health sites, physical examination data of personnel, occupational disease cases and the like into an Excel table for arrangement and storage, if data analysis is needed, the data analysis needs to be imported into special statistical software for statistics, and the data statistical analysis cannot be directly carried out. Disclosure of Invention Aiming at the problems existing in the prior art, the invention provides a health monitoring system, which aims to solve the problems that the operation efficiency of the existing health monitoring means is low, the real-time dynamic monitoring requirement cannot be met, the potential problems are difficult to discover and deal with in time, and the like. The specific technical scheme of the application is that the hygiene monitoring method comprises the following steps: acquiring excel format original occupational health monitoring data from multiple channels; analyzing the excel format original occupational health monitoring data, and identifying a fixed column and a dynamic column in the excel format original occupational health monitoring data; storing the fixed columns into a main table database, and storing the dynamic columns into a sub-table database; And responding to the user request, integrating the data in the main table database and the sub-table database to generate a visual report. Compared with the prior art, the invention has the beneficial effects that, According to the invention, the Excel format original occupational health monitoring data is obtained from multiple channels, analyzed, the fixed columns and the dynamic columns are respectively stored in the main table database and the sub-table database, and finally the visual report is generated according to the user request integrated data, so that the efficient processing and storage of the health monitoring data are realized. The method avoids the complicated process of manually inputting an Excel table and importing special statistical software for analysis in the prior art, and greatly improves the operation efficiency. Drawings FIG. 1, a flow chart of the method of the present application; FIG. 2 is a system block diagram of the present application; FIG. 3 is a data processing block diagram of the present application; FIG. 4 is a schematic diagram of a visual report of the present application; FIG. 5 is a schematic diagram of an embodiment of a visual report of the present application; FIG. 6 is a diagram illustrating a visual report according to an embodiment of the present application Detailed Description In order that those skilled in the art will better understand the technical solutions in the present specification, the technical solutions in the embodiments of the present specification will be clearly and completely described below with reference to the drawings in the embodiments of the present specification, and it is apparent that the described embodiments are only some embodiments of the present application, not all embodiments. In order to facilitate understanding of the method and system provided by the embodiments of the present application, a description of the background of the embodiments of the present application is provided before the description of the embodiments of the present application. Professional health monitoring is an important means for comprehensively grasping the current situation of occupational disease hazard in important industries and evaluating the risk of occupational health. However, the existing health monitoring means manually inputs various data such as basic conditions of occupational hazard enterprises, basic conditions of laborers, monitoring results of occupational health sites, physical examination data of personnel, occupational disease cases and the like into an Excel table for arrangement and storage, if data analysis is needed, the data analysis needs to be imported into special statistical software for statistics, and the data statistical analysis cannot be directly carried out. In view of the foregoing problems in the prior art, in some embodiments, as shown in fig. 1-3, the present invention provides a health monitoring system, which aims to realize automatic collection, arrangement, storage and analysis of various health monitoring data, improve monitoring efficiency, meet real-time and dynamic monitoring requirements, and timely discover and deal