Medical internet of things ecological integration method based on interface fusion technology and dynamic database switching
Through interface fusion technology and dynamic database switching, the problem of inconsistent multi-vendor device protocols and single databases in medical IoT systems is solved, and data interoperability between devices and flexible database switching is realized, which improves system scalability and data reliability and adapts Domestic information innovation needs.
Patent Information
- Application Number
- CN202411088527.4
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-09
- Publication Date
- 2024-11-12
AI Technical Summary
Due to the inconsistent multi-vendor equipment protocol and limited data storage, the existing medical IoT ecosystem has complicated system integration, difficulty in data interoperability, and the single database cannot support the domestic demand, which increases maintenance costs and failure risks.
Using the method based on interface fusion technology and dynamic database switching, the interface fusion technology module unifies multiple devices and communication protocols, the data processing module performs data standardization and abnormal detection, and the dynamic database switching module realizes flexible switching and monitoring of the database to ensure data Consistency and efficient system operation.
It realizes data interoperability between multiple devices, improves system scalability and adaptability, ensures data reliability and integrity, reduces maintenance costs, supports domestic databases, and adapts to different scenarios and information innovation needs.
Smart Images

Figure CN118942666A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of medical Internet of Things, and in particular to a medical Internet of Things ecological integration method based on interface fusion technology and dynamic database switching. Background Art
[0002] The existing medical IoT ecosystem faces the problems of inconsistent device protocols and limited data storage. Devices from different manufacturers use their own communication protocols and data formats, which makes system integration difficult. At the same time, due to the requirements of hospital information innovation, the traditional database connection method cannot flexibly support the hot switching of multiple domestic databases, which increases the system maintenance cost and failure risk, which is mainly reflected in the following points:
[0003] 1. Poor protocol compatibility: In the existing solutions, the communication protocols and data formats of devices from different manufacturers are not unified, resulting in data incompatibility between devices and complex system integration;
[0004] 2. Difficulty in data format standardization: Due to the lack of unified interface fusion technology, it is difficult to standardize data formats, and it is difficult to ensure data consistency and integrity;
[0005] 3. Single database: Most systems only support a single database type and cannot be flexibly switched according to the needs of domestic information innovation, which limits the scalability and adaptability of the system;
[0006] Based on the above, we propose a medical Internet of Things ecological integration method based on interface fusion technology and dynamic database switching. Summary of the invention
[0007] Based on the technical problems existing in the background technology, the present invention proposes a medical Internet of Things ecological integration method based on interface fusion technology and dynamic database switching.
[0008] The present invention proposes a medical Internet of Things ecological integration method based on interface fusion technology and dynamic database switching, comprising the following steps:
[0009] S1: First, the interface fusion technology module uses the interface fusion technology to perform unified access and data standardization processing of various devices and communication protocols in the medical Internet of Things system. The device access module communicates and collects data with various connected medical devices. The collected data is received through the communication adapter and uniformly transmitted to the data processing module of the system;
[0010] S2: The data processing module introduces a protocol library, pre-configures the communication protocol information of various devices, introduces a protocol identification engine, and configures the protocol library. When the device access module collects data, the protocol identification engine analyzes and identifies the collected data, quickly determines the protocol type used by the data through protocol feature matching, and calls the corresponding parser to parse the data according to the identification result, and extracts the required data information;
[0011] S3: Convert the parsed data in S2 into a unified standard format through a standardized interface, and perform integrity and accuracy checks on the converted data to check whether the data is missing or incomplete to ensure the rationality of the data. At the same time, check the consistency of the data to ensure that data from different sources can be correctly integrated.
[0012] S4: Introduce an abnormal data detection algorithm to identify abnormal data on the verified data, identify the abnormal data, mark the identified abnormal data, and filter it out from the data stream, detect missing points in the data sequence, identify missing data, and perform data completion operations;
[0013] S5: Uses an efficient batch writing method through the database connection pool to write the standardized data in S4 to the database, and automatically backs up the data regularly.
[0014] S6: The dynamic database switching module in the system uses the configuration file YAML to manage the connection pool configuration of each database in S5. For example, HikariCP or Druid connection pool library is used to manage MySQL connections, and C3P0 or DBCP connection pool library is used to manage OpenGauss, Renda Jincang and DAMO connections. A connection pool monitoring tool is introduced to monitor the key indicators of the connection pool and set an alarm mechanism. When certain indicators of the connection pool exceed the preset threshold, the system can automatically alarm and take corresponding measures.
[0015] S7: Use the data replication component Debezium and incremental data replication technology to replicate data in real time, only copy the changed data, reduce replication delay and system burden, and introduce the distributed transaction manager Seata to manage cross-database transaction consistency during data replication, record the log of each transaction, and prevent data loss or duplication;
[0016] S8: Monitor system load in real time, set switching thresholds and policies, write automated scripts, trigger database switching based on monitoring data, and automatically switch to a database with better performance;
[0017] S9: Provides an administrator operation interface to display the current database status and provide a switch button. The administrator manually triggers the database switch operation through the interface.
[0018] Preferably, in S1, the various medical devices connected include a sphygmomanometer, an electrocardiograph and a blood glucose meter. These devices may come from different manufacturers and use their own communication protocols and data formats. The communication protocols used include HTTP, MQTT and CoAP. Each communication protocol has a different transmission mechanism and data format, which requires the system to be compatible and processed;
[0019] The device access module needs to integrate the ability to support multiple protocols and be compatible with devices from different manufacturers. The communication adapter includes an HTTP adapter and an MQTT adapter. Corresponding communication adapters are designed for different protocols. The HTTP adapter is responsible for obtaining data from the device via the HTTP protocol, and the MQTT adapter is responsible for processing data transmitted via the MQTT protocol.
[0020] Preferably, in S2, the protocol library includes features and identification methods of different protocols, and the configured protocol library includes feature information of HTTP, MQTT and CoAP protocols. Each protocol has a corresponding parser, for example, HTTP parser, MQTT parser and CoAP parser, wherein the HTTP parser parses HTTP protocol data to extract information such as blood pressure data and timestamp; the MQTT parser parses MQTT protocol data to extract information such as electrocardiogram data and device ID; the CoAP parser parses CoAP protocol data to extract information such as blood sugar data and measurement time.
[0021] Preferably, in said S3, the standardized interface defines the structure, field type and value range of the data.
[0022] Preferably, in S4, when completing the data, an appropriate completion method is selected according to the actual situation, such as interpolation method, averaging method, etc. For time series data, linear interpolation method can be used to complete the missing data points.
[0023] Preferably, in S5, a reasonable data table structure is designed for the database to ensure efficient data storage and query, for example, a separate table is designed for each type of data, including fields such as device ID, measurement value, and timestamp, etc. When writing data in batches, the function used is redis cache;
[0024] When backing up data, you need to develop a reasonable backup strategy, including backup frequency, backup location, and backup data volume, and use scripts or scheduled task tools to achieve automated data backup.
[0025] Preferably, in S6, the connection pool configuration includes connection URL, user name, password and maximum number of connections, etc., and the connection pool monitoring tools introduced include Prometheus and Grafana, and their key indicators include the number of active connections, the number of idle connections and waiting time, etc.
[0026] Preferably, in S8, the load of the real-time monitoring system includes CPU usage, memory usage, and response time, and the switching threshold and strategy set therein may be to automatically switch the database when the CPU usage exceeds 80%.
[0027] Compared with the prior art, the present invention has the following beneficial effects:
[0028] 1. Adopt interface fusion technology to support multiple medical devices and communication protocols of different manufacturers, achieve unified access, improve system scalability, achieve protocol compatibility, enable data intercommunication between various devices, and ensure data consistency and integrity during database switching through real-time data replication and transaction management;
[0029] 2. Improve data reliability and accuracy through data cleaning and abnormal data filtering, prevent data loss and enhance system data security through regular data backup and automated backup scripts;
[0030] 3. By monitoring the system load in real time and automatically switching the database according to the load conditions, the system can still run efficiently under high load. The dynamic database switching technology enables the system to flexibly switch between multiple databases according to needs to adapt to different scenarios and requirements;
[0031] 4. By accessing the connection pool, it can support domestic databases such as OpenGauss, Renmin University of China Jincang, and DAMO, respond to the national information innovation policy, and ensure that the system meets the information innovation requirements;
[0032] The present invention supports multiple medical devices and communication protocols of different manufacturers by adopting interface fusion technology, thereby achieving protocol compatibility and enabling data intercommunication between various devices. It improves data reliability and accuracy and prevents data loss by performing data cleaning, abnormal data filtering and regular automatic backup. It also supports domestic databases by accessing the connection pool to ensure that the system meets the requirements of information technology innovation. It monitors the system load in real time and uses dynamic database switching technology to achieve flexible switching between multiple databases. Manual switching and automatic switching can flexibly switch operations to adapt to different scenarios and requirements. BRIEF DESCRIPTION OF THE DRAWINGS
[0033] Figure 1 This is a flow chart of a medical Internet of Things ecological integration method based on interface fusion technology and dynamic database switching proposed by the present invention;
[0034] Figure 2 A specific flow chart of the interface fusion technology module in a medical Internet of Things ecological integration method based on interface fusion technology and dynamic database switching proposed by the present invention;
[0035] Figure 3 A specific flow chart of a data processing module in a medical Internet of Things ecological integration method based on interface fusion technology and dynamic database switching proposed by the present invention;
[0036] Figure 4 This is a specific flow chart of the dynamic database switching module in the medical Internet of Things ecological integration method based on interface fusion technology and dynamic database switching proposed by the present invention. DETAILED DESCRIPTION
[0037] The present invention will be further explained below in conjunction with specific embodiments.
[0038] Example
[0039] Reference Figure 1-4 , this embodiment proposes a medical Internet of Things ecological integration method based on interface fusion technology and dynamic database switching, including the following steps:
[0040] S1: First, the interface fusion technology module uses interface fusion technology to uniformly access and standardize data of various devices and communication protocols in the medical Internet of Things system. The device access module communicates and collects data with various connected medical devices. The collected data is received through the communication adapter and uniformly transmitted to the data processing module of the system. In order to ensure the reliability of data transmission, the device access module needs to have error handling and retransmission mechanisms;
[0041] The various medical devices connected include blood pressure monitors, electrocardiographs, and blood glucose meters. These devices may come from different manufacturers and use their own communication protocols and data formats. The communication protocols used include HTTP, MQTT, and CoAP. Each communication protocol has a different transmission mechanism and data format, which requires the system to be compatible and processed; the device access module needs to integrate the ability to support multiple protocols and be compatible with devices from different manufacturers. The communication adapters include HTTP adapters and MQTT adapters. Corresponding communication adapters are designed for different protocols. The HTTP adapter is responsible for obtaining data from the device through the HTTP protocol, and the MQTT adapter is responsible for processing data transmitted through the MQTT protocol;
[0042] In addition, the device access module is responsible for communicating with the various devices mentioned above. For the blood pressure monitor of manufacturer A, the HTTP protocol is used for data transmission; for the electrocardiograph of manufacturer B, the MQTT protocol is used; for the blood glucose meter of manufacturer C, the CoAP protocol is used;
[0043] S2: The data processing module introduces a protocol library and pre-configures the communication protocol information of various devices. The protocol library includes the characteristics and identification methods of different protocols, and introduces a protocol identification engine to configure the protocol library. When the device access module collects data, the protocol identification engine analyzes and identifies the collected data, quickly determines the protocol type used by the data through protocol feature matching, and calls the corresponding parser to parse the data according to the identification result, and extracts the required data information;
[0044] The configured protocol library includes the characteristic information of HTTP, MQTT and CoAP protocols. Each protocol has a corresponding parser, for example, HTTP parser, MQTT parser and CoAP parser. The HTTP parser parses HTTP protocol data and extracts information such as blood pressure data and timestamp; the MQTT parser parses MQTT protocol data and extracts information such as electrocardiogram data and device ID; the CoAP parser parses CoAP protocol data and extracts information such as blood sugar data and measurement time.
[0045] S3: Convert the parsed data in S2 into a unified standard format through a standardized interface, and perform integrity and accuracy checks on the converted data to check whether the data is missing or incomplete, and ensure the rationality of the data, for example, whether all required fields have values, whether the numeric data is within a reasonable range, and whether the timestamp is valid. At the same time, check the consistency of the data to ensure that data from different sources can be correctly integrated, for example, the processing of duplicate data and the guarantee of data uniqueness. The standardized interface defines the structure, field type, and value range of the data;
[0046] S4: Introduce abnormal data detection algorithm to identify abnormal data after verification. For example, for a sphygmomanometer, set a reasonable range of systolic and diastolic pressures. Data outside this range is considered abnormal. The identified abnormal data is marked and filtered out from the data stream to ensure that the data processed subsequently is reliable. Detect missing points in the data sequence, identify missing data, and perform data completion operations. For example, if data at a certain time point in the time series data is missing, the system can automatically identify it.
[0047] When completing data, select an appropriate completion method, such as interpolation method, averaging method, etc., according to the actual situation. For time series data, linear interpolation method can be used to complete missing data points.
[0048] S5: Through the database connection pool, use an efficient batch writing method to write the standardized data in S4 to the database. When writing data in batches, use the redis cache function to improve writing efficiency and automatically back up data regularly. When backing up data, you need to formulate a reasonable backup strategy, including backup frequency, backup location, and backup data volume. For example, set a full backup at midnight every day and save the backup file to cloud storage. Use scripts or scheduled task tools to realize automatic data backup. For example, write a Python script to export the data in the database regularly every day and upload it to cloud storage.
[0049] The database is designed with a reasonable data table structure to ensure efficient data storage and query. For example, a separate table is designed for each type of data, including fields such as device ID, measurement value, and timestamp.
[0050] S6: The dynamic database switching module in the system uses the configuration file YAML to manage the connection pool configuration of each database in S5, and manages the corresponding connection pool for each database type. The connection pool configuration includes the connection URL, user name, password, and maximum number of connections, etc. For example, HikariCP or Druid connection pool library is used to manage MySQL connections, and C3P0 or DBCP connection pool library is used to manage OpenGauss, Renda Jincang and DAMO connections, etc., and connection pool monitoring tools are introduced. The connection pool monitoring tools introduced include Prometheus and Grafana, which monitor the key indicators of the connection pool, including the number of active connections, the number of idle connections, and the waiting time, etc., and an alarm mechanism is set. When certain indicators of the connection pool exceed the preset threshold, the system can automatically alarm and take corresponding measures;
[0051] S7: Use the data replication component Debezium and incremental data replication technology to replicate data in real time, only copy the changed data, reduce replication delay and system burden, and introduce the distributed transaction manager Seata to manage cross-database transaction consistency during data replication, record the log of each transaction, ensure that the transaction status can be restored during the switching process, and prevent data loss or duplication;
[0052] S8: Real-time monitoring of system load, including CPU usage, memory usage, response time, setting switching thresholds and policies. The switching thresholds and policies set can automatically switch databases when CPU usage exceeds 80%. Write automated scripts to trigger database switching based on monitoring data and automatically switch to a database with better performance.
[0053] S9: Provides an administrator operation interface to display the current database status and provide a switch button. The administrator manually triggers the database switch operation through the interface. The manual switch method is suitable for special situations.
[0054] The interface fusion technology module, data processing module and dynamic database switching module constitute a medical Internet of Things ecological integration system;
[0055] This embodiment supports multiple medical devices and communication protocols of different manufacturers by adopting interface fusion technology, which can achieve protocol compatibility and enable data intercommunication between various devices. It improves data reliability and accuracy and prevents data loss by performing data cleaning, abnormal data filtering and regular automatic backup. It also supports domestic databases by accessing the connection pool to ensure that the system meets the requirements of information technology innovation. It monitors the system load in real time and uses dynamic database switching technology to achieve flexible switching between multiple databases. Manual switching and automatic switching can flexibly switch operations to adapt to different scenarios and requirements.
[0056] The above description is only a preferred specific implementation manner of the present invention, but the protection scope of the present invention is not limited thereto. Any technician familiar with the technical field can make equivalent replacements or changes according to the technical scheme and inventive concept of the present invention within the technical scope disclosed by the present invention, which should be covered by the protection scope of the present invention.
Claims
1. A medical Internet of Things ecological integration method based on interface fusion technology and dynamic database switching, It is characterized in that The following steps are involved: S1: First, the interface fusion technology module uses the interface fusion technology to uniformly access various devices and communication protocols in the medical Internet of Things system and perform data standardization processing. The device access module communicates with various connected medical devices and collects data. The collected data is received through the communication adapter and uniformly transmitted to the data processing module of the system; S2: The data processing module introduces a protocol library, pre-configures the communication protocol information of various devices, introduces a protocol identification engine, and configures the protocol library. When the device access module collects data, the protocol identification engine analyzes and identifies the collected data, quickly determines the protocol type used by the data through protocol feature matching, and calls the corresponding parser to parse the data according to the identification result, and extracts the required data information; S3: Convert the parsed data in S2 into a unified standard format through a standardized interface, and perform integrity and accuracy checks on the converted data to check whether the data is missing or incomplete to ensure the rationality of the data. At the same time, check the consistency of the data to ensure that data from different sources can be correctly integrated. S4: Introduce an abnormal data detection algorithm to identify abnormal data on the verified data, identify the abnormal data, mark the identified abnormal data, and filter it out from the data stream, detect missing points in the data sequence, identify missing data, and perform data completion operations; S5: Uses an efficient batch writing method through the database connection pool to write the standardized data in S4 to the database, and automatically backs up the data regularly. S6: The dynamic database switching module in the system uses the configuration file YAML to manage the connection pool configuration of each database in S5, and introduces a connection pool monitoring tool to monitor the key indicators of the connection pool and set an alarm mechanism. When certain indicators of the connection pool exceed the preset threshold, the system can automatically alarm and take corresponding measures; S7: Use the data replication component Debezium and incremental data replication technology to replicate data in real time, only copy the changed data, reduce replication delay and system burden, and introduce the distributed transaction manager Seata to manage cross-database transaction consistency during data replication, record the log of each transaction, and prevent data loss or duplication; S8: Monitor system load in real time, set switching thresholds and policies, write automated scripts, trigger database switching based on monitoring data, and automatically switch to a database with better performance; S9: Provides an administrator operation interface to display the current database status and provide a switch button. The administrator manually triggers the database switch operation through the interface.
2. According to claim 1, a medical Internet of Things ecological integration method based on interface fusion technology and dynamic database switching, It is characterized in that In S1, various medical devices connected include blood pressure monitors, electrocardiographs, and blood glucose meters. These devices may come from different manufacturers and use their own communication protocols and data formats. The communication protocols used include HTTP, MQTT, and CoAP. Each communication protocol has a different transmission mechanism and data format, which requires the system to be compatible and processed; The device access module needs to integrate the ability to support multiple protocols and be compatible with devices from different manufacturers. The communication adapter includes an HTTP adapter and an MQTT adapter. Corresponding communication adapters are designed for different protocols. The HTTP adapter is responsible for obtaining data from the device via the HTTP protocol, and the MQTT adapter is responsible for processing data transmitted via the MQTT protocol.
3. According to claim 1, a medical Internet of Things ecological integration method based on interface fusion technology and dynamic database switching, It is characterized in that In S2, the protocol library includes the characteristics and identification methods of different protocols. The configured protocol library includes the characteristic information of HTTP, MQTT and CoAP protocols, and each protocol has a corresponding parser.
4. According to claim 1, a medical Internet of Things ecological integration method based on interface fusion technology and dynamic database switching, It is characterized in that In the S3, the standardized interface defines the structure, field type and value range of the data.
5. According to claim 1, a medical Internet of Things ecological integration method based on interface fusion technology and dynamic database switching, It is characterized in that In S4, when completing the data, an appropriate completion method is selected according to the actual situation. For time series data, linear interpolation can be used to complete the missing data points.
6. According to claim 1, a medical Internet of Things ecological integration method based on interface fusion technology and dynamic database switching, It is characterized in that In S5, a reasonable data table structure is designed for the database to ensure efficient data storage and query. When writing data in batches, the function used is redis cache; When backing up data, you need to develop a reasonable backup strategy, including backup frequency, backup location, and backup data volume, and use scripts or scheduled task tools to achieve automated data backup.
7. According to claim 1, a medical Internet of Things ecological integration method based on interface fusion technology and dynamic database switching, It is characterized in that In the S6, the connection pool configuration includes the connection URL, user name, password and maximum number of connections. The connection pool monitoring tools introduced include Prometheus and Grafana, and the key indicators include the number of active connections, the number of idle connections and the waiting time.
8. According to claim 1, a medical Internet of Things ecological integration method based on interface fusion technology and dynamic database switching, It is characterized in that In S8, the load of the real-time monitoring system includes CPU usage, memory usage, and response time, and the switching threshold and strategy set therein can automatically switch the database when the CPU usage exceeds 80%.
Citation Information
Cited By
NeuroX multi-source heterogeneous experimental psychology data synchronous access device and method
CN119496835A
Intelligent building Internet of Things equipment data acquisition method, system, equipment and storage medium
CN119854363A
