Hygiene monitoring method and system
By acquiring occupational health monitoring data in Excel format from multiple channels, identifying and storing fixed and dynamic columns, and generating visual reports, the problem of low efficiency in existing technologies is solved, the need for real-time dynamic monitoring is met, and monitoring efficiency and risk response capabilities are improved.
Patent Information
- Application Number
- CN202610123195.1
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2026-01-29
- Publication Date
- 2026-05-12
AI Technical Summary
Existing health monitoring methods are inefficient and cannot meet the needs of real-time, dynamic monitoring, making it difficult to detect and address potential problems in a timely manner.
By acquiring raw occupational health monitoring data in Excel format from multiple channels, the system parses and identifies fixed and dynamic columns, stores them in the main table and sub-table databases respectively, and generates visual reports based on user requests.
It enables efficient processing and storage of health monitoring data, improves operational efficiency, and allows for timely detection and response to potential health risks and problems.
Smart Images

Figure CN122021577A_ABST
Abstract
Description
Technical Field
[0001] This invention relates to the field of public health management technology, specifically a health monitoring method and system. Background Technology
[0002] Occupational health monitoring is an important means of comprehensively understanding the current status of occupational hazards in key industries and assessing occupational health risks.
[0003] However, existing health monitoring methods involve manually entering various data such as basic information on enterprises with occupational hazards, basic information on workers, on-site occupational health monitoring results, personnel physical examination data, and occupational disease cases into Excel spreadsheets for organization and storage. If data analysis is required, it needs to be imported into specialized statistical software for statistical analysis. Direct data statistical analysis is not possible. This method is inefficient, cannot meet the needs of real-time and dynamic monitoring, and makes it difficult to detect and respond to potential problems in a timely manner. Summary of the Invention
[0004] In view of the above-mentioned problems in the prior art, the present invention provides a health monitoring system, which aims to solve the problems of low operational efficiency, inability to meet the needs of real-time dynamic monitoring, and difficulty in timely detection and response to potential problems in existing health monitoring methods.
[0005] The specific technical solution of this application is: a health monitoring method, the method comprising:
[0006] Obtain raw occupational health monitoring data in Excel format from multiple channels;
[0007] Parse the original occupational health monitoring data in Excel format to identify the fixed and dynamic columns;
[0008] The fixed columns are stored in the main table database, and the dynamic columns are stored in the sub-table database;
[0009] In response to a user request, the data in the main table database and the sub-table database are integrated to generate a visual report.
[0010] Compared with the prior art, the beneficial effects of the present invention are as follows:
[0011] This invention acquires raw occupational health monitoring data in Excel format from multiple channels, parses it, and stores fixed and dynamic columns in a main database and a sub-database, respectively. Finally, it integrates the data according to user requests to generate visual reports, achieving efficient processing and storage of health monitoring data. This method avoids the cumbersome process of manually entering Excel data and importing it into specialized statistical software for analysis, greatly improving operational efficiency. Attached Figure Description
[0012] Figure 1 The method flowchart of this application;
[0013] Figure 2 The system architecture diagram of this application;
[0014] Figure 3 1. Data processing structure diagram of this application;
[0015] Figure 4 A visual report illustration of this application;
[0016] Figure 5 A schematic diagram of an embodiment of the visualization report of this application;
[0017] Figure 6 A structural diagram of an embodiment of the visualization report of this application. Detailed Implementation
[0018] To enable those skilled in the art to better understand the technical solutions in this specification, the technical solutions in the embodiments of this specification will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of this application, and not all embodiments.
[0019] To facilitate understanding of the methods and systems provided in the embodiments of this application, the background of the embodiments of this application will be introduced before introducing the embodiments of this application.
[0020] Occupational health monitoring is an important means of comprehensively understanding the current status of occupational hazards in key industries and assessing occupational health risks.
[0021] However, existing health monitoring methods involve manually entering various data such as basic information on enterprises with occupational hazards, basic information on workers, on-site occupational health monitoring results, personnel physical examination data, and occupational disease cases into Excel spreadsheets for organization and storage. If data analysis is required, it needs to be imported into specialized statistical software for statistical analysis. Direct data statistical analysis is not possible. This method is inefficient, cannot meet the needs of real-time and dynamic monitoring, and makes it difficult to detect and respond to potential problems in a timely manner.
[0022] To address the aforementioned problems in the prior art, in some embodiments, such as Figures 1-3 As shown, the present invention provides a health monitoring system, which aims to realize the automated collection, sorting, storage and analysis of various types of health monitoring data, improve monitoring efficiency, meet real-time and dynamic monitoring needs, and promptly detect and respond to potential problems.
[0023] The specific technical solution of this application is: a health monitoring method, the method comprising:
[0024] Obtain diverse and original occupational health monitoring data from multiple channels;
[0025] Specifically, raw data can be obtained from various channels such as government websites, medical institutions, and enterprise internal monitoring systems. This data covers multiple aspects, including basic information about enterprises with occupational hazards, workers' occupational health records, on-site occupational health monitoring data, personnel physical examination results, and occupational disease diagnosis reports, ensuring the comprehensiveness and diversity of the data.
[0026] Data can also be obtained through direct data entry. For example, for industries or enterprises, a dedicated data entry interface can be designed, where relevant personnel can fill in the required information to obtain the necessary raw data.
[0027] These data were acquired in Excel spreadsheet format. Excel, with its versatility and ease of use, has become an ideal format for data collection and storage. It can conveniently record various types of data and is easily exchanged between different systems and software. However, after obtaining the raw occupational health monitoring data in Excel format, due to the multiple sources involved, the acquired data may suffer from inconsistencies in format and varying data quality.
[0028] Therefore, these data need to be preprocessed to ensure their accuracy and consistency. The acquired raw occupational health monitoring data in Excel format is cleaned to remove duplicate, invalid, and erroneous data.
[0029] For example, for duplicate entries of company information or health check data, only the latest and most complete record is retained; obvious errors in the data, such as negative ages, are corrected or deleted. Then, the data is standardized, unifying its format and encoding. Data obtained from different channels may differ in date format, units, etc., and needs to be converted to a unified format for easier subsequent analysis and processing. For example, the date format is standardized to "year-month-day," and monitoring data expressed in different units is converted to standard units.
[0030] After data preprocessing, the raw occupational health monitoring data in Excel format is parsed to identify fixed and dynamic columns. Fixed columns typically refer to those with relatively stable meanings and content across different data sources, such as basic information columns like company names and addresses, or worker names and genders. The data in these fixed columns is relatively stable and changes infrequently. Dynamic columns, on the other hand, are those that change significantly over time or with monitoring conditions, such as occupational health field monitoring results and personnel physical examination data from different periods. After identifying the fixed and dynamic columns, the fixed columns are stored in the main table database. The main table database primarily stores relatively stable basic information, facilitating quick data retrieval and correlation. The dynamic columns are stored in a sub-table database, which stores frequently changing data, thus improving the flexibility and scalability of data storage.
[0031] like Figures 4-6 As shown, when the system responds to a user request, it integrates data from the main and sub-databases to generate a visual report. Users can select different query conditions and analysis dimensions according to their needs. The system will then extract relevant data from the main and sub-databases based on these conditions and integrate it. The integrated data is displayed using visualization tools such as bar charts, line charts, and pie charts to present the results and trends of occupational health monitoring in an intuitive way. For example, users can view the changing trends of occupational hazard factor monitoring data for different enterprises over different time periods, or compare the health status of workers in different industries. In this way, users can gain a clearer understanding of the overall situation of occupational health monitoring, promptly identify potential problems, and take corresponding intervention and management measures.
[0032] Specifically, based on user needs and analytical objectives, relevant formatted data is extracted from the database, and appropriate display components are selected to generate intuitive and easy-to-understand visual reports. These reports can be customized according to different analytical perspectives and needs, such as displaying the changing trends of monitoring data by time dimension, or showing the distribution of occupational hazards by enterprise type or industry classification. Through visual reports, users can quickly grasp the status of health monitoring and promptly identify potential health risks and problems.
[0033] In some embodiments, obtaining multiple types of original occupational health monitoring data from multiple channels includes: importing original occupational health monitoring data from external sources and collecting original occupational health monitoring data in real time through direct reporting.
[0034] The original occupational health monitoring data includes: workplace occupational disease risk factor monitoring data and worker occupational disease monitoring data;
[0035] The workplace occupational hazard monitoring data includes basic information about enterprises with occupational hazards, and the types and intensity of occupational hazard factors that workers are exposed to during work.
[0036] The occupational disease monitoring data for workers includes the workers' basic information, all occupational health examinations conducted before, during, and after employment, as well as during emergency health checkups, information on new and fatal cases of various occupational diseases, and basic information, severity, morbidity, and mortality of acute and chronic occupational poisoning.
[0037] These occupational health monitoring data are crucial for assessing the impact of the work environment on workers' health. To obtain this data comprehensively and accurately, the health monitoring system provided by this invention employs multiple channels and methods for data collection.
[0038] The system supports importing raw occupational health surveillance data from external sources, integrating existing data from various sources into the system, avoiding duplicate data entry and improving work efficiency. This external data includes occupational health surveillance data from the National Health China Disease Prevention and Control Information System platform and data from other external sources. Through standardized data interfaces, the system can automatically identify and import this data, ensuring its integrity and accuracy.
[0039] The method in this application also provides a direct data entry function, allowing users to collect and input new raw occupational health monitoring data in real time. This approach is particularly suitable for data that cannot be obtained directly through external channels or that requires regular updates. It allows relevant personnel to collect raw occupational health monitoring data in real time. This method ensures the timeliness and accuracy of the data, enabling updates to the system and reflecting the latest health monitoring situation. For example, enterprises can regularly report the latest occupational hazard factor monitoring results, and medical institutions can upload workers' physical examination data in real time.
[0040] In some embodiments, a method for identifying fixed columns and dynamic columns is provided, including setting a whitelist for fixed columns and a whitelist for dynamic columns;
[0041] The original occupational health monitoring data in Excel format is matched with the fixed column whitelist and the dynamic column whitelist;
[0042] For data that matches successfully, it is marked as a fixed column or a dynamic column according to the whitelist category;
[0043] Data that does not match either the fixed column whitelist or the dynamic column whitelist is marked as a column to be confirmed and will be manually reviewed to determine whether it belongs to a fixed column, a dynamic column, or an invalid column.
[0044] This method is suitable for dealing with occupational health monitoring data that is diverse in source and complex in structure, effectively and accurately distinguishing between fixed and dynamic columns. Setting up whitelists for fixed and dynamic columns establishes a clear rule system for data identification; the whitelists detail the characteristics and names of common fixed and dynamic columns. When matching the raw occupational health monitoring data in Excel format against the whitelists, the system compares each column of data according to the established rules.
[0045] For successfully matched data, marking it according to the whitelist is a crucial step. Data marked as fixed columns will be clearly categorized into the corresponding storage category in the main table database, allowing for quick location and retrieval when querying basic stability information of enterprises or workers later. Data marked as dynamic columns will be accurately allocated to the storage system of the sub-table database, facilitating flexible management and analysis of data that changes over time or under monitoring conditions.
[0046] For data that doesn't match either the fixed or dynamic column whitelist, marking it as a column awaiting confirmation is a rigorous approach. This is because such data might be newly emerging special data types or anomalies encountered during data collection. During manual review, professionals will carefully analyze the meaning and purpose of these columns in light of the actual business scenario and data context. If the review finds that the data falls under the category of fixed columns, it will be placed in the main table database; if it falls under dynamic columns, it will be placed in the sub-table database; and if it is determined to be an invalid column, it will be removed to avoid interfering with subsequent data processing and analysis.
[0047] This method of identifying fixed and dynamic columns not only improves the automation of data processing but also ensures the accuracy and reliability of data classification through manual review. It enables occupational health monitoring systems to manage and utilize occupational health monitoring data more efficiently, providing strong data support for comprehensively assessing occupational health risks and promptly identifying and addressing potential problems. Furthermore, this method is scalable; when new data types emerge or business needs change, the whitelist can be updated and review rules adjusted to adapt to new situations, ensuring the system can always accurately process and analyze occupational health monitoring data.
[0048] In some embodiments, identifying fixed and dynamic columns includes:
[0049] Based on historical occupational health monitoring data, the changes in the names of each column of data in different data sources or different time periods were evaluated;
[0050] If the name of a column of data remains relatively stable across multiple data sources or over a long period of time, the column is considered a fixed column.
[0051] If the column name of a certain column changes frequently, or if it presents different representations in different data sources, the column is considered a dynamic column.
[0052] This identification method is suitable for scenarios with complex data sources and dynamically changing data structures. In the field of occupational health monitoring, as monitoring work continues and business needs evolve, new monitoring indicators and data types may constantly emerge, and the data structures provided by different data sources may also differ. Evaluation based on historical occupational health monitoring data can fully utilize existing data resources and uncover patterns behind the data.
[0053] By meticulously analyzing the changes in the names of each column across different data sources or time periods, we can more accurately grasp the stability and dynamism of the data. Columns whose names remain relatively stable across multiple data sources or over extended periods indicate that the information they represent has high stability and universality. Examples include a company's registered address and an employee's ID number. This information typically does not change frequently during different data collection processes, making it reasonable and accurate to classify them as fixed columns.
[0054] Columns whose names frequently change or whose descriptions vary across different data sources often reflect a close relationship between the data and specific monitoring scenarios, time factors, or business needs. For example, monitoring indicators for occupational hazard factors may be adjusted at different times, or different regions may use different naming conventions for the same monitoring indicator. This type of data is highly dynamic, and classifying it as a dynamic column helps to manage and analyze the data more flexibly.
[0055] When new data sources are added or business rules change, historical data needs to be updated and re-evaluated. This allows for timely adjustments to the judgment results of fixed and dynamic columns, ensuring the system can accurately process and store various occupational health monitoring data. Simultaneously, this approach provides a solid foundation for subsequent data integration and visualization analysis, enabling the system to store and display data in appropriate ways based on different types of column data, thereby better meeting users' needs for analyzing and making decisions based on occupational health monitoring data.
[0056] In some embodiments, storing the fixed columns in the main table database and storing the dynamic columns in the sub-table database includes:
[0057] Preprocess the column headers, including removing extra spaces, standardizing characters and capitalization, removing special characters, or using a uniform delimiter;
[0058] Define the attribute type;
[0059] Iterate through all column headers and determine the attribute type of each column header;
[0060] Generate a table mapping project-attribute-column positions;
[0061] Based on the project-attribute-column position correspondence table, the data of fixed columns are stored in the main table database according to their corresponding attribute types and column positions, and the data of dynamic columns are stored in the sub-table database according to their corresponding attribute types and column positions.
[0062] In some embodiments, ETL (Extract, Transform, Load) technology is used to extract the various raw occupational health monitoring data, and the extraction timestamp is recorded. The occupational health monitoring data includes data in various formats; for example, workers' basic information is in an Excel file, and occupational hazard enterprise monitoring data is in a database table. These diverse data formats are inconvenient for unified processing and analysis. Therefore, in some embodiments of the present invention, ETL technology is used to extract, transform, and load these raw data.
[0063] The extracted raw occupational health monitoring data is cleaned according to business rules to remove duplicate, invalid, or abnormal data;
[0064] The cleaned data is converted into formatted occupational health monitoring data that meets the preset format requirements;
[0065] The converted, formatted occupational health monitoring data is stored in the business database according to preset classification rules.
[0066] All the above monitoring information must be categorized and stored according to dimensions such as region, enterprise economic type, industry, size, and worker age, gender, and length of service to facilitate subsequent data analysis and utilization. In this way, the system can quickly integrate and extract the required data, providing strong support for health monitoring.
[0067] During the data transformation process, the system cleans and verifies the data according to preset business rules to ensure its accuracy and completeness. For example, for missing data, the system will attempt to supplement it through other channels; for abnormal or erroneous data, the system will mark or remove it to avoid interfering with subsequent analysis.
[0068] In addition, the system supports regular updates and maintenance of stored data to ensure its timeliness and accuracy. For example, the system will promptly update the database with regularly reported occupational hazard factor monitoring results; for expired or invalid data, the system will clean up and delete it to avoid interfering with subsequent analysis.
[0069] Occupational health monitoring data contains multiple indicators, each reflecting a specific health monitoring status. To generate accurate and easy-to-understand visualizations, the system automatically selects appropriate display components based on the type of data chosen.
[0070] For example, for time series data, such as monitoring the trend of data changes over time, line charts or bar charts can be used to display the data so as to clearly see the fluctuations and changes in the data; for categorical data, such as the distribution of occupational hazards classified by enterprise type or industry, pie charts or bar charts can be used to display the data so as to intuitively compare the differences between different categories.
[0071] Through different display components, complex health monitoring data can be transformed into intuitive and easy-to-understand visual reports, helping users quickly grasp the health monitoring status and promptly identify and address potential health risks and problems.
[0072] In some embodiments, to match appropriate display components to different occupational health monitoring data, the step of selecting different formatted occupational health monitoring data from the database and generating various forms of visualization reports using different display components includes:
[0073] Select the occupational health monitoring data to be displayed, determine the type of the occupational health monitoring data, and select the appropriate display component from a variety of preset display components according to the type of occupational health monitoring data. When the occupational health monitoring data is numerical data, select display components such as bar chart, line chart or pie chart for display.
[0074] When the occupational health monitoring data is text-based, select display components such as tables, tag clouds, or text boxes for display.
[0075] When the occupational health monitoring data is mixed data, select the combined chart display component for comprehensive display;
[0076] The selected display components are linked to the occupational health monitoring data to generate corresponding visualization reports.
[0077] For example, when displaying monitoring data on occupational hazards of a company over a period of time, the system first identifies this data as time-series data, then selects a line graph as the display component to clearly present the trend of the monitoring data over time. As another example, when displaying the distribution of occupational hazards in different industries, the system identifies this data as categorical data, then selects a pie chart as the display component to intuitively show the distribution proportions and differences of occupational hazards in each industry. In this way, the system can match appropriate display components for different types of occupational health monitoring data, generating accurate and easy-to-understand visual reports.
[0078] Another aspect of this application provides a health monitoring system, which includes a data acquisition module, a data processing module, a data storage module, and a report generation module.
[0079] The data acquisition module is responsible for obtaining raw occupational health monitoring data from multiple channels, including importing data from external sources such as government websites, medical institutions, and enterprise internal monitoring systems, as well as collecting data in real time through direct data entry. This module ensures the comprehensiveness and timeliness of the data.
[0080] The data processing module cleans and transforms the acquired raw data, converting it into standardized occupational health monitoring data. This step includes operations such as removing duplicate data, filling in missing data, and correcting erroneous data, as well as standardization processes such as data encoding conversion, null value handling, and data validity verification, ensuring the accuracy and integrity of the data.
[0081] The data storage module stores the processed, formatted data in the business database according to preset classification rules, facilitating subsequent data analysis and utilization. Simultaneously, this module also supports regular updates and maintenance of the stored data, ensuring its timeliness and accuracy.
[0082] The report generation module selects different formatted occupational health monitoring data from the database and uses various display components to generate multiple forms of visual reports. This module can select appropriate display components to generate intuitive and easy-to-understand visual reports based on user needs and analysis objectives, helping users quickly grasp the status of health monitoring and promptly identify potential health risks and problems.
[0083] The system's overall architecture design follows a layered, grouped, and service-oriented design strategy. JavaEE technology is selected for the overall technical system, employing a three-tier B / S / D application architecture for development. JavaEE, a multi-layered distributed architecture, provides excellent flexibility in system operation and execution. Advanced Java computing solutions, such as object-oriented programming, platform independence, rapid integration, and code reuse, ensure good portability and scalability. JavaEE provides a robust mechanism for building scalable, flexible, and maintainable systems. The project development adopts a modular design, with each functional module exhibiting high cohesion and low coupling. Various service components, such as POI and ECharts, are used in the system to implement data display and file processing.
[0084] It adopts the Oracle relational database system, supports cloud architecture deployment, and utilizes technologies such as data read / write separation, data partitioning, parallel querying, memcached, and Redis caching to improve system performance and scalability.
[0085] The front-end uses the jQuery MiniUI framework, which provides a rich control library, enabling rapid development of enterprise-level web applications. It shortens development time, reduces code volume, and allows developers to focus more on business logic and server-side development, easily achieving UI development and delivering a superior user experience.
[0086] The report generation module utilizes ECharts to visualize data. ECharts is an open-source visualization library implemented in JavaScript, offering a rich variety of chart types, such as line charts, bar charts, pie charts, and scatter plots, to meet diverse data visualization needs. In the health monitoring system, the report generation module automatically selects the appropriate chart type and configuration based on the chosen data type and display requirements, generating intuitive and visually appealing reports using ECharts. These reports not only help users quickly understand health monitoring data but also serve as crucial support for decision-making.
[0087] In some embodiments, the health monitoring system also includes a briefing module that uses the XDocReport component. XDocReport is a Java library for generating Word, Excel, and PowerPoint documents. It supports various template engines such as Velocity, Freemarker, and Mustache. XDocReport can extract data from Java objects or XML data sources and insert it into templates to generate the final Office document. It supports multiple template engines, such as Velocity, Freemarker, and Mustache; complex layouts such as tables, charts, headers, and footers; inserting images into Word, Excel, and PowerPoint documents; creating pivot tables in Excel documents; creating tables of contents in Word documents; creating bookmarks and hyperlinks in Word documents; creating watermarks in Word documents; creating page numbers in Word documents; creating section breaks in Word documents; and creating page backgrounds in Word documents. XDocReport can be used in various scenarios, such as report generation, document automation, and data export. It can be used in conjunction with other Java libraries (such as Apache POI, docx4j, etc.) to achieve more complex functions.
[0088] The embodiments and functional operations of the subject matter described in this specification can be implemented in the following ways: digital electronic circuits, tangibly implemented computer software or firmware, computer hardware, including the structures disclosed in this specification and their equivalents, or combinations thereof. Embodiments of the subject matter described in this specification can be implemented as one or more computer programs, that is, one or more modules of computer program instructions encoded on one or more tangible non-transitory program carriers, for execution by a data processing device or to control the operation of the data processing device.
[0089] Alternatively or additionally, program instructions may be encoded on artificially generated propagation signals, such as machine-generated electrical, optical, or electromagnetic signals, which are then generated as coded information to be transmitted to an appropriate receiver device executed by data processing equipment. The computer storage medium may be a machine-readable storage device, a machine-readable storage substrate, a random or serial access memory device, or one or more combinations of the above.
[0090] Similarly, although operations are described in the accompanying drawings in a specific order, it should not be construed as requiring that such operations be performed in the specific order shown or in sequential order, or that all illustrated operations be performed, in order to achieve the desired result. In certain cases, multitasking and parallel processing may be advantageous. Furthermore, the separation of various system modules and components in the above embodiments should not be construed as requiring such separation in all embodiments, and it should be understood that program components and systems can generally be integrated into a single software product or packaged into multiple software products.
Claims
1. A method for health monitoring, characterized in that, The method includes: Obtain raw occupational health monitoring data in Excel format from multiple channels; Parse the original occupational health monitoring data in Excel format to identify the fixed and dynamic columns; The fixed columns are stored in the main table database, and the dynamic columns are stored in the sub-table database; In response to a user request, the data in the main table database and the sub-table database are integrated to generate a visual report.
2. The health monitoring method as described in claim 1, characterized in that, Parsing the original occupational health monitoring data in Excel format, identifying the fixed and dynamic columns includes: Set up fixed column whitelists and dynamic column whitelists; The original occupational health monitoring data in Excel format is matched with the fixed column whitelist and the dynamic column whitelist; For data that matches successfully, it is marked as a fixed column or a dynamic column according to the whitelist category; Data that does not match either the fixed column whitelist or the dynamic column whitelist is marked as a column to be confirmed and will be manually reviewed to determine whether it belongs to a fixed column, a dynamic column, or an invalid column.
3. The health monitoring method as described in claim 1, characterized in that, Parsing the original occupational health monitoring data in Excel format, identifying the fixed and dynamic columns includes: Based on historical occupational health monitoring data, the changes in the names of each column of data in different data sources or different time periods were evaluated; If the name of a column of data remains relatively stable across multiple data sources or over a long period of time, the column is considered a fixed column. If the column name of a certain column changes frequently, or if it presents different representations in different data sources, the column is considered a dynamic column.
4. The health monitoring method as described in claim 1, characterized in that, Storing the fixed columns in the main table database and the dynamic columns in the sub-table database includes: Preprocess the column headers, including removing extra spaces, standardizing characters and capitalization, removing special characters, or using a uniform delimiter; Define the attribute type; Iterate through all column headers and determine the attribute type of each column header; Generate a table mapping project-attribute-column positions; Based on the project-attribute-column position correspondence table, the data of fixed columns are stored in the main table database according to their corresponding attribute types and column positions, and the data of dynamic columns are stored in the sub-table database according to their corresponding attribute types and column positions.
5. The health monitoring method as described in claim 1, characterized in that, Raw occupational health monitoring data in Excel format were obtained from multiple channels, including: Importing raw occupational health monitoring data from external sources and collecting raw occupational health monitoring data in real time through direct reporting; The original occupational health monitoring data in Excel format includes: workplace occupational disease risk factor monitoring data and worker occupational disease monitoring data; The workplace occupational hazard monitoring data includes basic information about enterprises with occupational hazards, and the types and intensity of occupational hazard factors that workers are exposed to during work. The occupational disease monitoring data for workers includes the workers' basic information, all occupational health examinations conducted before, during, and after employment, as well as during emergency health checkups, information on new and fatal cases of various occupational diseases, and basic information, severity, morbidity, and mortality of acute and chronic occupational poisoning.
6. The health monitoring method as described in claim 1, characterized in that, The step of converting the various occupational health monitoring data into formatted occupational health monitoring data and storing it in the business database includes: The ETL technology was used to extract the various original occupational health monitoring data, and the extraction timestamp was recorded. The extracted raw occupational health monitoring data is cleaned according to business rules to remove duplicate, invalid, or abnormal data; The cleaned data is converted into formatted occupational health monitoring data that meets the preset format requirements; The converted, formatted occupational health monitoring data is stored in the business database according to preset classification rules.
7. The health monitoring method as described in claim 1, characterized in that, The process of selecting different formatted occupational health monitoring data from the database and generating various forms of visual reports using different display components includes: Select the occupational health monitoring data to be displayed, and determine the type of the occupational health monitoring data. Based on the type of occupational health monitoring data, select the appropriate display component from a variety of preset display components. When the occupational health monitoring data is numerical data, select display components such as bar charts, line charts, or pie charts for display. When the occupational health monitoring data is text-based, select display components such as tables, tag clouds, or text boxes for display. When the occupational health monitoring data is mixed data, select the combined chart display component for comprehensive display; The selected display components are linked to the occupational health monitoring data to generate corresponding visualization reports.
8. The health monitoring method as described in claim 6, characterized in that, The extracted raw occupational health monitoring data is cleaned according to business rules to remove duplicate, invalid, or abnormal data. This includes: for duplicate data, retaining the record with the latest timestamp in the duplicate data and merging duplicate data from different data sources; for invalid data, judging and removing it according to preset business rules.
9. The health monitoring method as described in claim 8, characterized in that, The preset business rules include: Determine whether the enterprise is within the monitoring scope. If the enterprise is not within the monitoring scope, the data is invalid. Determine whether the data falls within the normal range. If the intensity value of occupational hazard factors exceeds the reasonable range, the data is invalid. Determine whether the data conforms to logical relationships. For example, the time of an employee's on-the-job physical examination cannot be earlier than the time of starting work. If the time of an employee's on-the-job physical examination is earlier than the time of starting work, then the data is invalid. To determine if the data is complete, if the worker's basic information data lacks key information such as name or ID number, then the data is invalid.
10. A health monitoring system, characterized in that, The system includes at least one processor; and a memory storing instructions that, when executed by the at least one processor, perform the steps of the method according to any one of claims 1-9.
