Quasi-real-time database backup method and system

Abstract

The invention relates to the technical field of database management, in particular to a quasi-real-time database backup method and system which comprises a real-time monitoring module, an analysis module, a backup strategy making module, a backup model building module, a backup execution module, a storage module, an encryption unit, a data recovery module, a processor and a client. The analysis module is connected with the real-time monitoring module, the backup model building module is connected with the analysis module through the backup strategy making module, the backup execution module is connected with the backup strategy making module through the backup strategy making module, the encryption unit is connected with the storage module and the data recovery module, and the processor is connected with the backup execution module and the data recovery module. And the client is connected with the processor. In this way, the technical problems that in the prior art, a backup strategy of a medical information database backup system is static and inflexible, and safety protection measures are insufficient are solved.

Description

Technical Field

[0001] The present invention relates to the technical field of database management, and in particular to a quasi-real-time database backup method and system. Background Art

[0002] In the current process of medical informatization, the management and use of medical data have become key factors in improving the quality and efficiency of medical services. With the rapid development of technologies such as electronic medical record systems, telemedicine, and big data analysis, the sharing and use of medical data are becoming more and more extensive, providing strong support for clinical decision-making, disease prevention, and medical resource allocation. As the core component of medical information storage and processing, databases play a vital role in medical informatization.

[0003] However, despite the increasing importance of medical data, existing medical information database backup systems still have some problems and shortcomings. Among them, the most prominent is the static and inflexible nature of the backup strategy. Existing medical information database backup systems usually rely on fixed time intervals for backup, such as daily, weekly or monthly. This static backup strategy cannot respond to the dynamic changes of the database in a timely manner, especially during periods of frequent data updates or high system load, which may increase the time difference between the backup data and the actual data, thereby increasing the risk of data loss or damage.

[0004] In addition, the existing medical information database backup system also has deficiencies in security. Since the backup data lacks sufficient security protection measures, once the backup data is illegally accessed or tampered with, it will have a serious impact on the integrity and security of the medical information.

[0005] In summary, the existing medical information database backup system mainly has the problems of static and inflexible backup strategy and insufficient security protection measures. Summary of the invention

[0006] The purpose of the present invention is to provide a quasi-real-time database backup method and system, aiming to solve the technical problems of the medical information database backup system in the prior art, namely, static and inflexible backup strategy and insufficient security protection measures.

[0007] To achieve the above-mentioned purpose, the present invention adopts a quasi-real-time database backup method and system, including a real-time monitoring module, an analysis module, a backup strategy formulation module, a backup model construction module, a backup execution module, a storage module, an encryption unit, a data recovery module, a processor and a client, wherein the analysis module is connected to the real-time monitoring module, the backup model construction module is connected to the analysis module through the backup strategy formulation module, the backup execution module is connected to the backup strategy formulation module, the encryption unit is connected to the storage module and the data recovery module, the processor is connected to the backup execution module and the data recovery module, and the client is connected to the processor;

[0008] The real-time monitoring and analysis module is used to continuously monitor the status of the database;

[0009] The analysis module receives data from the real-time monitoring module, performs analysis and processing, and identifies dynamic changes in the database;

[0010] The backup strategy formulation module intelligently formulates or adjusts the backup strategy according to the results of the analysis module;

[0011] The backup model building module builds a backup model based on the requirements of the backup strategy formulation module;

[0012] The backup execution module executes specific backup operations according to the backup strategy and the backup model;

[0013] The storage module stores backup data to ensure data reliability and durability;

[0014] The encryption unit encrypts the data in the storage module and the data in the data recovery process to enhance the security of the data and prevent illegal access or tampering;

[0015] A user recovers the data in the storage module from the data recovery module through the client and the processor.

[0016] Wherein, the quasi-real-time database backup system further includes a verification module, and the verification module is connected to the data recovery module.

[0017] Wherein, the quasi-real-time database backup system further includes a compression module, and the compression module is connected to the storage module.

[0018] The encryption unit includes a key management module, a key generation module, an encryption module and a decryption module, the encryption module and the decryption module are connected to the storage module and the data recovery module respectively, the key management module is connected to the encryption module and the decryption module, and the key generation module is connected to the key management module;

[0019] The encryption module requests the key management module when a key is needed, and the key management module requests the key generation module to generate an encryption key and a corresponding decryption key, and distributes the keys to the encryption module and the decryption module according to the authority and policy;

[0020] The encryption module uses an encryption key to encrypt the data in the storage module and generates ciphertext for storage;

[0021] When recovering data, the data recovery module obtains the ciphertext in the storage module, the decryption module decrypts the encrypted data received by the data recovery module, and then presents the decrypted data to the client.

[0022] The quasi-real-time database backup system further includes a recording module and an auditing module. The recording module is connected to the processor module, and the auditing module is connected to the recording module.

[0023] The quasi-real-time database backup system further includes a login module and a rights management module. The login module is connected to the client, and the rights management module is connected to the login module.

[0024] The present invention also provides a quasi-real-time database backup method, which is applied to the quasi-real-time database backup system as described above.

[0025] The steps include:

[0026] First, the real-time monitoring and analysis module continuously monitors the status of the database; and transmits it to the analysis module for analysis and processing to identify dynamic changes in the database;

[0027] Afterwards, the backup strategy formulation module intelligently formulates or adjusts the backup strategy according to the results of the analysis module; the backup model construction module constructs the backup model based on the requirements of the backup strategy formulation module;

[0028] Then the backup execution module executes specific backup operations according to the backup strategy and backup model, and stores the backup data through the storage module to ensure the reliability and persistence of the data;

[0029] At the same time, the encryption unit encrypts the data in the storage module and the data in the data recovery process to enhance the security of the data and prevent illegal access or tampering.

[0030] A quasi-real-time database backup method and system of the present invention, when used specifically, first, the real-time monitoring and analysis module continuously monitors the status of the database; and transmits the data to the analysis module for analysis and processing to identify dynamic changes in the database; then, the backup strategy formulation module intelligently formulates or adjusts the backup strategy based on the results of the analysis module; the backup model construction module constructs the backup model based on the requirements of the backup strategy formulation module; then, the backup execution module performs specific backup operations according to the backup strategy and the backup model, and stores the backup data through the storage module to ensure the reliability and durability of the data; at the same time, the encryption unit encrypts the data in the storage module and the data in the data recovery process to enhance the security of the data and prevent illegal access or tampering. When it is necessary to obtain data, the user restores the data in the storage module from the data recovery module through the client and the processor. In this way, the technical problems of the medical information database backup system in the prior art, namely, static and inflexible backup strategies and insufficient security protection measures, are solved. BRIEF DESCRIPTION OF THE DRAWINGS

[0031] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0032] Figure 1 It is a principle block diagram of the first embodiment of the present invention.

[0033] Figure 2 It is a principle block diagram of the second embodiment of the present invention.

[0034] Figure 3 It is a principle block diagram of the third embodiment of the present invention.

[0035] 101-real-time monitoring module, 102-analysis module, 103-backup strategy formulation module, 104-backup model construction module, 105-backup execution module, 106-storage module, 107-encryption unit, 108-data recovery module, 109-processor, 110-client, 111-verification module, 112-compression module, 113-key management module, 114-key generation module, 115-encryption module, 116-decryption module, 201-recording module, 202-audit module, 203-login module, 204-authorization management module, 301-sensing module, 302-self-adjustment module, 303-error reporting module. DETAILED DESCRIPTION

[0036] Embodiments of the present invention are described in detail below. Examples of the embodiments are shown in the accompanying drawings. The embodiments described below with reference to the accompanying drawings are exemplary and are intended to be used to explain the present invention, but should not be construed as limiting the present invention.

[0037] The first embodiment of the present application is:

[0038] See also Figure 1 , Figure 1 It is a principle block diagram of the first embodiment of the present invention.

[0039] The present invention provides a quasi-real-time database backup system, including a real-time monitoring module 101, an analysis module 102, a backup strategy formulation module 103, a backup model construction module 104, a backup execution module 105, a storage module 106, an encryption unit 107, a data recovery module 108, a processor 109, a client 110, a verification module 111 and a compression module 112. The encryption unit 107 includes a key management module 113, a key generation module 114, an encryption module 115 and a decryption module 116. The above-mentioned scheme solves the technical problems of the medical information database backup system in the prior art, that is, the backup strategy is static and inflexible, and the security protection measures are insufficient.

[0040] For this specific implementation, the real-time monitoring and analysis module 102 is used to continuously monitor the status of the database;

[0041] The analysis module 102 receives data from the real-time monitoring module 101, performs analysis and processing, and identifies dynamic changes in the database;

[0042] The backup strategy formulation module 103 intelligently formulates or adjusts the backup strategy according to the result of the analysis module 102;

[0043] The backup model building module 104 builds a backup model based on the requirements of the backup strategy formulation module 103;

[0044] The backup execution module 105 executes specific backup operations according to the backup strategy and the backup model;

[0045] The storage module 106 stores backup data to ensure data reliability and durability;

[0046] The encryption unit 107 encrypts the data in the storage module 106 and the data in the data recovery process to enhance the security of the data and prevent illegal access or tampering;

[0047] The user recovers the data in the storage module 106 from the data recovery module 108 through the client 110 and the processor 109 .

[0048] The real-time monitoring and analysis module 102 uses a monitoring mechanism based on event triggering or time intervals, combined with a monitoring interface or log analysis function provided by a database management system (DBMS), to capture database status information in real time;

[0049] The analysis module 102 uses data mining, machine learning or statistical analysis methods to perform in-depth analysis and pattern recognition on database status information;

[0050] The backup strategy formulation module 103 intelligently decides the optimal backup strategy based on a predefined rule set or a machine learning model according to the dynamic changes of the database and historical backup data;

[0051] The backup model building module 104 uses database modeling technology, combined with specific DBMS characteristics and backup strategy requirements, to build an efficient and reliable backup model;

[0052] The backup execution module 105 uses the backup command or API provided by the DBMS, combined with the file transfer protocol (such as FTP, SFTP) or database replication technology (such as Oracle Data Pump, MySQL Dump) to implement data backup;

[0053] The storage module 106 uses RAID technology, distributed storage system or cloud storage service, combined with data redundancy and verification mechanism to improve storage reliability and fault tolerance;

[0054] The use of symmetric encryption algorithms (such as AES), asymmetric encryption algorithms (such as RSA) or hybrid encryption technologies, combined with key management and security policies, ensures the confidentiality and integrity of data;

[0055] The data recovery module 108 uses the recovery command or API provided by the DBMS, combined with data verification and recovery strategies, to ensure the accuracy and completeness of data recovery.

[0056] Among them, the analysis module 102 is connected to the real-time monitoring module 101, the backup model construction module 104 is connected to the analysis module 102 through the backup strategy formulation module 103, the backup execution module 105 is connected to the backup strategy formulation module 103, the encryption unit 107 is connected to the storage module 106 and the data recovery module 108, the processor 109 is connected to the backup execution module 105 and the data recovery module 108, and the client 110 is connected to the processor 109. When used specifically, first, the real-time monitoring and analysis module 102 continuously monitors the status of the database; and transmits it to the analysis module 102 for analysis and processing to identify dynamic changes in the database; then the backup strategy formulation module 103 intelligently formulates or adjusts the backup strategy according to the results of the analysis module 102. Omitted; the backup model construction module 104 constructs a backup model based on the requirements of the backup strategy formulation module 103; then the backup execution module 105 performs specific backup operations according to the backup strategy and the backup model, and stores the backup data through the storage module 106 to ensure the reliability and durability of the data; at the same time, the encryption unit 107 encrypts the data in the storage module 106 and the data in the data recovery process to enhance the security of the data and prevent illegal access or tampering. When it is necessary to obtain data, the user restores the data in the storage module 106 from the data recovery module 108 through the client 110 and the processor 109. In this way, the technical problems of the medical information database backup system in the prior art, namely, the static and inflexible backup strategy and the insufficient security protection measures, are solved.

[0057] Secondly, the verification module 111 is connected to the data recovery module 108, and the verification module 111 is used to ensure the integrity and availability of the backup data.

[0058] At the same time, the compression module 112 is connected to the storage module 106, and the compression module 112 compresses the backup data to significantly reduce the use of storage space.

[0059] The compression module 112 may use a 7Z compression algorithm or a BZIP2 compression algorithm;

[0060] The 7Z compression algorithm uses advanced compression technology to provide a higher compression ratio than ZIP and RAR, while performing well in compression and decompression speeds. It is suitable for scenarios that require efficient data backup and recovery, especially when storage space is limited.

[0061] BZIP2 compression algorithm is based on block sorting compression algorithm, with high compression ratio and stable compression performance. It is particularly suitable for processing large text files. It is suitable for scenarios where large amounts of text data need to be backed up, such as log files and source code.

[0062] In addition, the encryption unit 107 includes a key management module 113, a key generation module 114, an encryption module 115 and a decryption module 116, the encryption module 115 and the decryption module 116 are connected to the storage module 106 and the data recovery module 108 respectively, the key management module 113 is connected to the encryption module 115 and the decryption module 116, and the key generation module 114 is connected to the key management module 113;

[0063] The encryption module 115 requests the key management module 113 when a key is needed, and the key management module 113 requests the key generation module 114 to generate an encryption key and a corresponding decryption key, and distributes the keys to the encryption module 115 and the decryption module 116 according to the authority and policy;

[0064] The encryption module 115 uses an encryption key to encrypt the data of the storage module 106 to generate a ciphertext for storage;

[0065] When recovering data, the data recovery module 108 obtains the ciphertext in the storage module 106 , and the decryption module 116 decrypts the encrypted data received by the data recovery module 108 , and then presents the decrypted data to the client 110 .

[0066] A quasi-real-time database backup system of the present embodiment is used. When it is used specifically, first, the real-time monitoring and analysis module 102 continuously monitors the status of the database; and transmits the data to the analysis module 102 for analysis and processing to identify dynamic changes in the database; then the backup strategy formulation module 103 intelligently formulates or adjusts the backup strategy based on the results of the analysis module 102; the backup model construction module 104 constructs a backup model based on the requirements of the backup strategy formulation module 103; then the backup execution module 105 performs specific backup operations according to the backup strategy and the backup model, and stores the backup data through the storage module 106 to ensure the reliability and durability of the data; at the same time, the encryption unit 107 encrypts the data in the storage module 106 and the data in the data recovery process to enhance the security of the data and prevent illegal access or tampering. When it is necessary to obtain data, the user restores the data in the storage module 106 from the data recovery module 108 through the client 110 and the processor 109. In this way, the technical problems of the medical information database backup system in the prior art, namely, static and inflexible backup strategies and insufficient security protection measures, are solved.

[0067] The second embodiment of the present application is:

[0068] Based on the first embodiment, please refer to Figure 2 , Figure 2 It is a principle block diagram of the second embodiment of the present invention.

[0069] The present invention provides a quasi-real-time database backup system, which also includes a recording module 201 , an auditing module 202 , a login module 203 and a rights management module 204 .

[0070] For this specific implementation, the recording module 201 is connected to the processor 109 module, and the audit module 202 is connected to the recording module 201. The recording module 201 is responsible for recording all key operations in the database backup process, such as the start, execution, completion of the backup task, and any error or warning information; the audit module 202 ensures that the backup process complies with the enterprise's security policies and compliance requirements by analyzing and auditing the log files generated by the recording module 201. The audit module 202 adopts a rule-based audit algorithm, which matches and analyzes events in the log files according to preset rules and patterns.

[0071] The login module 203 is connected to the client 110, and the authority management module 204 is connected to the login module 203. The login module 203 is the entry point for users to access the database backup system, and is responsible for verifying the identity and authority of the user. The authority management module 204 is responsible for determining the role and responsibility of the login personnel and assigning different access rights according to the login account received by the login module 203;

[0072] The permission management module 204 is a role-based access control (RBAC) algorithm that assigns permissions based on the user's role;

[0073] The RBAC algorithm achieves flexible management and control of user access rights by defining roles, permissions, and the mapping relationship between roles and permissions.

[0074] In a quasi-real-time database backup system of this embodiment, the recording module 201 is responsible for recording all key operations in the database backup process, such as the start, execution, completion, and any error or warning information of the backup task; the audit module 202 ensures that the backup process complies with the security policy and compliance requirements of the enterprise by analyzing and auditing the log file generated by the recording module 201. The audit module 202 adopts a rule-based audit algorithm, which matches and analyzes events in the log file according to preset rules and patterns;

[0075] The permission management module 204 is a role-based access control (RBAC) algorithm that assigns permissions based on the user's role;

[0076] The RBAC algorithm achieves flexible management and control of user access rights by defining roles, permissions, and the mapping relationship between roles and permissions.

[0077] The third embodiment of the present application is:

[0078] Based on the second embodiment, please refer to Figure 3 , Figure 3 It is a principle block diagram of the third embodiment of the present invention.

[0079] The present invention provides a quasi-real-time database backup system, which also includes a sensing module 301 , a self-adjusting module 302 and an error reporting module 303 .

[0080] According to this specific implementation, the sensing module 301 is connected to the client 110 , and the self-adjusting module 302 is connected to both the sensing module 301 and the client 110 . The sensing module 301 senses whether the client 110 is in use, and automatically adjusts the brightness through the self-adjusting module 302 .

[0081] The error reporting module 303 is connected to the login module 203 , and when the login personnel information is wrong, an error will be reported through the error reporting module 303 .

[0082] Using a quasi-real-time database backup system of this embodiment, the sensing module 301 senses whether the client 110 is used, and automatically adjusts the brightness through the self-adjusting module 302. When the login person information is wrong, an error will be reported through the error reporting module 303.

[0083] The present invention also provides a quasi-real-time database backup method, which is applied to the quasi-real-time database backup system as described above.

[0084] The steps include:

[0085] First, the real-time monitoring and analysis module 102 continuously monitors the status of the database; and transmits it to the analysis module 102 for analysis and processing to identify dynamic changes in the database;

[0086] Afterwards, the backup strategy formulation module 103 intelligently formulates or adjusts the backup strategy according to the result of the analysis module 102; the backup model construction module 104 constructs the backup model based on the requirements of the backup strategy formulation module 103;

[0087] Then the backup execution module 105 executes specific backup operations according to the backup strategy and backup model, and stores the backup data through the storage module 106 to ensure the reliability and persistence of the data;

[0088] At the same time, the encryption unit 107 encrypts the data in the storage module 106 and the data in the data recovery process to enhance the security of the data and prevent illegal access or tampering.

[0089] What is disclosed above is only a preferred embodiment of the present invention, and it certainly cannot be used to limit the scope of rights of the present invention. Ordinary technicians in this field can understand that all or part of the processes of the above embodiment and equivalent changes made according to the claims of the present invention still fall within the scope of the invention.

Claims

1. A quasi-real-time database backup method and system, characterized in that: It includes a real-time monitoring module, an analysis module, a backup strategy formulation module, a backup model construction module, a backup execution module, a storage module, an encryption unit, a data recovery module, a processor and a client, wherein the analysis module is connected to the real-time monitoring module, the backup model construction module is connected to the analysis module through the backup strategy formulation module, the backup execution module is connected to the backup strategy formulation module, the encryption units are connected to the storage module and the data recovery module, the processors are connected to the backup execution module and the data recovery module, and the client is connected to the processor; The real-time monitoring and analysis module is used to continuously monitor the status of the database; The analysis module receives data from the real-time monitoring module, performs analysis and processing, and identifies dynamic changes in the database; The backup strategy formulation module intelligently formulates or adjusts the backup strategy according to the results of the analysis module; The backup model building module builds a backup model based on the requirements of the backup strategy formulation module; The backup execution module executes specific backup operations according to the backup strategy and the backup model; The storage module stores backup data to ensure data reliability and durability; The encryption unit encrypts the data in the storage module and the data in the data recovery process to enhance the security of the data and prevent illegal access or tampering; A user recovers the data in the storage module from the data recovery module through the client and the processor.

2. The quasi-real-time database backup system according to claim 1, characterized in that: The quasi-real-time database backup system also includes a verification module, and the verification module is connected to the data recovery module.

3. The quasi-real-time database backup method and system as claimed in claim 2, characterized in that: The quasi-real-time database backup system also includes a compression module, which is connected to the storage module.

4. The quasi-real-time database backup method and system as claimed in claim 3, characterized in that: The encryption unit includes a key management module, a key generation module, an encryption module and a decryption module. The encryption module and the decryption module are connected to the storage module and the data recovery module respectively, the key management module is connected to the encryption module and the decryption module, and the key generation module is connected to the key management module.

5. The quasi-real-time database backup method and system as claimed in claim 4, characterized in that: The quasi-real-time database backup system further includes a recording module and an auditing module. The recording module is connected to the processor module, and the auditing module is connected to the recording module.

6. The quasi-real-time database backup method and system as claimed in claim 5, characterized in that: The quasi-real-time database backup system further comprises a login module and a rights management module. The login module is connected to the client, and the rights management module is connected to the login module.

7. A quasi-real-time database backup method, applied to the quasi-real-time database backup system as claimed in claim 6, characterized in that: The steps include: First, the real-time monitoring and analysis module continuously monitors the status of the database; and transmits it to the analysis module for analysis and processing to identify dynamic changes in the database; Afterwards, the backup strategy formulation module intelligently formulates or adjusts the backup strategy according to the results of the analysis module; The backup model building module builds a backup model based on the requirements of the backup strategy formulation module; Then the backup execution module executes specific backup operations according to the backup strategy and backup model, and stores the backup data through the storage module to ensure the reliability and persistence of the data; At the same time, the encryption unit encrypts the data in the storage module and the data in the data recovery process to enhance the security of the data and prevent illegal access or tampering.

Images