Self-adaptive database encryption and backup recovery integrated method and system

By classifying and evaluating the database data, implementing encryption based on sensitivity levels, and dynamically adjusting the backup storage solution, the problem of lack of targetedness and disconnection between database encryption and backup recovery methods in the existing technology is solved, and efficient and flexible data management and recovery.

CN119026159AActive Publication Date: 2024-11-26COFCO INFORMATION TECH CO LTD
View PDF 9 Cites 0 Cited by

Patent Information

Application Number
CN202411507929.3
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-10-28
Publication Date
2024-11-26
Estimated Expiration
2044-10-28

AI Technical Summary

Technical Problem

The existing database encryption and backup recovery methods are not targeted and cannot be differentiated according to the sensitivity and importance of the data, resulting in inefficient encryption, unreasonable allocation of backup resources, and disconnection from the backup recovery process, affecting data recovery efficiency. and integrity.

Method used

By classifying and evaluating the database data, differentiated encryption based on sensitivity levels is implemented, and real-time monitoring of data update frequency is dynamically adjusted backup storage solutions to realize adaptive database encryption and backup recovery integration.

Benefits of technology

Improve database security and data integrity, improve the efficiency and flexibility of data backup and recovery, and ensure timely recovery and reasonable resource utilization of data when facing multiple risks.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119026159A_ABST
    Figure CN119026159A_ABST
Patent Text Reader

Abstract

The invention provides a self-adaptive database encryption and backup recovery integrated method and system. The self-adaptive database encryption and backup recovery integrated method comprises the following steps: classifying data in a database, and performing sensitivity evaluation on each type of data to determine a sensitivity level corresponding to each data type; performing encryption according to the sensitivity level corresponding to each data type to obtain various types of encrypted data information; and monitoring the data updating frequency corresponding to each data type in real time, determining the importance degree of each type according to the data updating frequency, and dynamically adjusting a data backup storage scheme according to the importance degree of each type. The system comprises modules corresponding to the steps of the method.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The invention proposes an adaptive database encryption and backup recovery integrated method and system, belonging to the technical field of database security control. Background Art

[0002] With the rapid development of information technology, databases have become the core components for modern enterprises, institutions and individuals to store, manage and process massive amounts of data. Databases not only contain a large amount of business data, but also often involve highly sensitive information such as user privacy and trade secrets. Therefore, the security of databases and the integrity of data have become major issues that cannot be ignored. Traditional database protection methods, such as simple access control and regular backup, can no longer meet the current complex and changing security needs. In particular, when facing multiple risks such as internal threats, external attacks and accidental data loss, an efficient, intelligent and adaptive database encryption and backup recovery method is needed. In the field of database security, data encryption is one of the key technologies to protect data from unauthorized access. However, early database encryption methods often adopted a unified encryption algorithm and key management strategy, ignoring the differences in the sensitivity and importance of the data itself, resulting in low encryption efficiency and possible impact on database performance due to over-encryption. In addition, these methods are usually separated from the data backup and recovery process and lack an effective integration mechanism, which may lead to decryption difficulties or data consistency issues during data recovery.

[0003] On the other hand, as an important means to ensure data availability and disaster recovery, the formulation of database backup strategies should also be based on the actual use and importance of data. Traditional backup strategies often use fixed time intervals or data volume thresholds to trigger backups, but fail to fully consider the frequency of data updates and changes in business needs, resulting in unreasonable allocation of backup resources, either wasting storage space or failing to restore the latest data in a timely manner at critical moments.

[0004] In summary, the existing technologies have the following major deficiencies in database encryption and backup and recovery: First, the encryption strategy lacks specificity and fails to perform differentiated processing based on the sensitivity and importance of the data; second, the encryption and backup and recovery processes are disconnected, affecting the recovery efficiency and integrity of the data; third, the backup strategy is not flexible enough and cannot adapt to the needs of dynamic changes in data.

[0005] In response to the above problems, the present invention proposes an adaptive integrated method for database encryption and backup and recovery. This method implements differentiated encryption based on sensitivity levels by carefully classifying and evaluating the data in the database; at the same time, by real-time monitoring of data update frequency and dynamically adjusting the backup storage solution, it ensures the effective use of backup resources and timely recovery of data. This innovative method not only improves the security of the database and the integrity of the data, but also significantly improves the efficiency and flexibility of data backup and recovery, providing a strong guarantee for the safe operation and maintenance of the database. Summary of the invention

[0006] The present invention provides an adaptive database encryption and backup recovery integrated method and system to solve the problem: An adaptive database encryption and backup recovery integrated method, the adaptive database encryption and backup recovery integrated method comprising: Classify the data in the database and conduct sensitivity assessment on each type of data to determine the sensitivity level corresponding to each type of data; Encrypting according to the sensitivity level corresponding to each data type to obtain encrypted data information of various types; The data update frequency corresponding to each data type is monitored in real time, and the importance of various types is determined according to the data update frequency, and the data backup storage plan is dynamically adjusted according to the importance of various types.

[0007] Furthermore, the data in the database is classified, and a sensitivity assessment is performed on each type of data to determine the sensitivity level corresponding to each data type, including: Classify the data in the database and obtain various types of data information; Scan each type of data information to obtain the frequency and duration of the interaction mode between each type of data information and the user within a unit time; wherein the interaction mode includes query interaction, modification interaction, analysis interaction, monitoring interaction and collaboration interaction; and the length of the unit time is 24h-72h; Obtaining comprehensive sensitive indicator parameters corresponding to each type of data information according to the frequency and duration of the interaction mode between each type of data information and the user within a unit time; Compare the comprehensive sensitive indicator parameter corresponding to each type of data information with a preset sensitive indicator parameter threshold; When the comprehensive sensitivity index parameter corresponding to each type of data information is lower than the preset sensitivity index parameter threshold, the sensitivity level is determined to be low; When the comprehensive sensitivity indicator parameter corresponding to each type of data information is not lower than a preset sensitivity indicator parameter threshold, the sensitivity level is determined to be high.

[0008] Furthermore, the comprehensive sensitive indicator parameters corresponding to each type of data information are obtained according to the frequency and duration of the interaction mode between each type of data information and the user within a unit time, including: The frequency and duration of the interaction mode between each data information and the user in a unit time are combined with the weight value corresponding to each interaction mode to generate an interaction matrix; wherein the structure of the interaction matrix is ​​as follows:

[0009] in, M represents the interaction matrix; M ij Indicates i The unit time corresponds to the j The weighted value corresponding to the interaction mode; and i The unit time corresponds to the j The weighted value corresponding to the interaction mode is obtained by the following formula:

[0010] in, M ij Indicates i The unit time of each data type corresponds to the j The weighted value corresponding to the interaction mode; W ij Indicates i The unit time of each data type corresponds to the j The weight value corresponding to the interaction mode; F ij Indicates i The unit time of each data type corresponds to the j The frequency of occurrence of the interaction mode; T ij Indicates i The unit time of each data type corresponds to the j The average duration of each interaction mode; n Indicates the number of types of interaction modes; T j Indicates the first j The total duration of the interaction mode; T z Indicates the unit time n The median total duration of the interaction modes; T p Indicates the unit time nThe average total duration of the interaction modes; D ij Indicates i The unit time of each data type corresponds to the j Dynamic regulators of the interaction patterns; The interactive matrix is ​​used to obtain the sensitive indicator parameters corresponding to each type of data information in each unit time; wherein the sensitive indicator parameters corresponding to each type of data information are obtained by the following formula:

[0011] in, S i Indicates the unit time i Sensitive indicator parameters corresponding to the data information of the data types; M ij Indicates i The unit time corresponds to the j The weighted value corresponding to the interaction mode; n Indicates the number of types of interaction modes; The comprehensive sensitive indicator parameters corresponding to each type of data information in each unit time are obtained by using the sensitive indicator parameters corresponding to each type of data information in the current n unit time; wherein the comprehensive sensitive indicator parameters are obtained by the following formula:

[0012] in, G i Indicates i Comprehensive sensitive indicator parameters of data types; x Indicates the number of time units that have passed; S ik Indicates i The data type k The sensitive indicator parameters corresponding to the unit time; l k Indicates k The time importance weight value corresponding to the unit time is obtained by the following formula:

[0013] in, l k Indicates k The time importance weight value corresponding to the unit time; y Indicates the preset attenuation factor; Z represents the normalization constant; A kIndicates the preset number of adjustment time period groups, which includes one or more unit times.

[0014] Furthermore, encryption is performed according to the sensitivity level corresponding to each data type to obtain encrypted data information of various types, including: When the sensitivity level of each type of data information is low, randomly selecting a first encryption type to encrypt the data information with a low sensitivity level; wherein the first encryption type includes AES-128, DES, Triple DES and Blowfish; When the sensitivity level of each type of data information is high, a second encryption type is randomly selected to encrypt the data information with a low sensitivity level; wherein the second encryption type includes AES-256, RSA-4096 and ECC.

[0015] Furthermore, the data update frequency corresponding to each data type is monitored in real time, and the importance of each type is determined according to the data update frequency, and the data backup storage scheme is dynamically adjusted according to the importance of each type, including: Real-time monitoring of the data update frequency corresponding to each data type; Retrieve the correlation value between each data type and other data types; Obtaining the importance evaluation parameter corresponding to each data type using the data update frequency corresponding to each data type and the correlation value between each data type and other data types; Comparing the importance evaluation parameter with a preset importance evaluation threshold; When the importance evaluation parameter is lower than a preset importance evaluation threshold, the data backup storage scheme is kept unchanged; when the importance evaluation parameter is not lower than the preset importance evaluation threshold, the data backup frequency in the data backup storage scheme is adjusted.

[0016] An adaptive database encryption and backup and recovery integrated system, the adaptive database encryption and backup and recovery integrated system comprising: A sensitivity level determination module is used to classify the data in the database and conduct sensitivity assessment on each type of data to determine the sensitivity level corresponding to each data type; An encryption module, used to encrypt data according to the sensitivity level corresponding to each data type to obtain encrypted data information of various types; The storage scheme adjustment module is used to monitor the data update frequency corresponding to each data type in real time, and determine the importance of various types based on the data update frequency, and dynamically adjust the data backup storage scheme based on the importance of various types.

[0017] Furthermore, the sensitivity level determination module includes: Data classification module, used to classify data in the database and obtain various types of data information; An interactive information acquisition module is used to scan each type of data information and acquire the frequency and duration of the interaction mode between each type of data information and the user within a unit time; wherein the interaction mode includes query interaction, modification interaction, analysis interaction, monitoring interaction and collaboration interaction; and the length of the unit time is 24h-72h; A comprehensive sensitive indicator parameter acquisition module, used to acquire the comprehensive sensitive indicator parameters corresponding to each type of data information according to the frequency and duration of the interaction mode between each type of data information and the user within a unit time; A first comparison module, used to compare the comprehensive sensitive indicator parameter corresponding to each type of data information with a preset sensitive indicator parameter threshold; A first sensitivity level determination module, configured to determine that the sensitivity level is low when the comprehensive sensitivity indicator parameter corresponding to each type of data information is lower than a preset sensitivity indicator parameter threshold; The second sensitivity level determination module is used to determine that the sensitivity level is high when the comprehensive sensitivity indicator parameter corresponding to each type of data information is not lower than a preset sensitivity indicator parameter threshold.

[0018] Furthermore, the comprehensive sensitive indicator parameter acquisition module includes: The interaction matrix generation module is used to generate an interaction matrix based on the frequency and duration of the interaction mode between each data information and the user in a unit time and the weight value corresponding to each interaction mode; wherein the structure of the interaction matrix is ​​as follows:

[0019] in, M represents the interaction matrix; M ij Indicates i The unit time corresponds to the j The weighted value corresponding to the interaction mode; and i The unit time corresponds to the j The weighted value corresponding to the interaction mode is obtained by the following formula:

[0020] in, M ij Indicates i The unit time of each data type corresponds to the j The weighted value corresponding to the interaction mode; Wij Indicates i The unit time of each data type corresponds to the j The weight value corresponding to the interaction mode; F ij Indicates i The unit time of each data type corresponds to the j The frequency of occurrence of the interaction mode; T ij Indicates i The unit time of each data type corresponds to the j The average duration of each interaction mode; n Indicates the number of types of interaction modes; T j Indicates the first j The total duration of the interaction mode; T z Indicates the unit time n The median total duration of the interaction modes; T p Indicates the unit time n The average total duration of the interaction modes; D ij Indicates i The unit time of each data type corresponds to the j Dynamic regulators of the interaction patterns; The sensitive indicator parameter acquisition module is used to use the interactive matrix to obtain the sensitive indicator parameters corresponding to each type of data information in each unit time; wherein the sensitive indicator parameters corresponding to each type of data information are obtained by the following formula:

[0021] in, S i Indicates the unit time i Sensitive indicator parameters corresponding to the data information of the data types; M ij Indicates i The unit time corresponds to the j The weighted value corresponding to the interaction mode; n Indicates the number of types of interaction modes; The comprehensive sensitive indicator parameter acquisition execution module is used to obtain the comprehensive sensitive indicator parameters corresponding to each type of data information in the current n unit times by using the sensitive indicator parameters corresponding to each type of data information in each unit time; wherein the comprehensive sensitive indicator parameters are obtained by the following formula:

[0022] in, G i Indicates i Comprehensive sensitive indicator parameters of data types; x Indicates the number of time units that have passed; S ik Indicates i The data type k The sensitive indicator parameters corresponding to the unit time; l k Indicates k The time importance weight value corresponding to the unit time is obtained by the following formula:

[0023] in, l k Indicates k The time importance weight value corresponding to the unit time; y Indicates the preset attenuation factor; Z represents the normalization constant; A k Indicates the preset number of adjustment time period groups, which includes one or more unit times.

[0024] Furthermore, the encryption module includes: A first encryption module, configured to randomly select a first encryption type to encrypt the data information with a low sensitivity level when the sensitivity level of each type of data information is low; wherein the first encryption type includes AES-128, DES, Triple DES and Blowfish; The second encryption module is used to randomly select a second encryption type to encrypt data information with a low sensitivity level when the sensitivity level of each type of data information is high; wherein the second encryption type includes AES-256, RSA-4096 and ECC.

[0025] Furthermore, the storage scheme adjustment module includes: Frequency monitoring module, used to monitor the data update frequency corresponding to each data type in real time; A correlation value retrieving module is used to retrieve the correlation value between each data type and other data types; An importance evaluation parameter acquisition module, used to acquire the importance evaluation parameter corresponding to each data type by using the data update frequency corresponding to each data type and the correlation value between each data type and other data types; A second comparison module, used for comparing the importance evaluation parameter with a preset importance evaluation threshold; The storage scheme adjustment module is used to keep the data backup storage scheme unchanged when the importance evaluation parameter is lower than the preset importance evaluation threshold; when the importance evaluation parameter is not lower than the preset importance evaluation threshold, adjust the data backup frequency in the data backup storage scheme.

[0026] Beneficial effects of the present invention: The present invention proposes an adaptive database encryption and backup recovery integrated method and system. By classifying and evaluating the sensitivity of the data in the database and implementing differentiated encryption strategies based on the evaluation results, the security of sensitive data is effectively improved. Even if the data is illegally obtained, the original data cannot be decrypted and read without the correct key. Dynamic adjustment of the data backup storage scheme can reasonably allocate backup resources according to the actual usage and importance of the data. This avoids the waste of resources while ensuring that critical data can be backed up in a timely and effective manner. In the event of data loss or damage, the business continuity and data integrity are guaranteed by quickly and accurately restoring the encrypted data to its original state. This is crucial for enterprises and institutions that rely on databases to operate. The automated and intelligent encryption and backup recovery integrated method reduces the possibility of human intervention and errors, and reduces operation and maintenance costs and time consumption. Administrators can focus on other key tasks without frequent manual intervention in the encryption and backup process of the database. BRIEF DESCRIPTION OF THE DRAWINGS

[0027] Figure 1 is a flow chart of the method of the present invention; Figure 2 The system block diagram of the system of the present invention. DETAILED DESCRIPTION

[0028] The preferred embodiments of the present invention are described below in conjunction with the accompanying drawings. It should be understood that the preferred embodiments described herein are only used to illustrate and explain the present invention, and are not used to limit the present invention.

[0029] The embodiment of the present invention proposes an adaptive database encryption and backup recovery integration method, such as Figure 1 As shown, the adaptive database encryption and backup recovery integrated method includes: S1. Classify the data in the database and conduct sensitivity assessment on each type of data to determine the sensitivity level corresponding to each data type; S2. Encrypt according to the sensitivity level corresponding to each data type to obtain encrypted data information of various types; S3. Monitor the data update frequency corresponding to each data type in real time, and determine the importance of each type according to the data update frequency, and dynamically adjust the data backup storage solution according to the importance of each type.

[0030] The working principle of the above technical solution is as follows: First, the system comprehensively classifies all data in the database. This is usually based on factors such as the nature, purpose and source of the data, such as personal information, transaction records, business reports, etc. Next, the system conducts a sensitivity assessment on each type of data. This process may consider multiple dimensions, including the legal compliance of the data (such as GDPR, HIPAA and other regulatory requirements), commercial value, leakage risk, etc. Through comprehensive evaluation, the system assigns a sensitivity level to each data type, such as "high" and "low".

[0031] The system formulates corresponding encryption strategies according to the sensitivity level corresponding to each data type. The more sensitive the data is, the more powerful the encryption algorithm and the more complex the key management strategy are. The system automatically performs encryption operations to convert the plaintext data in the database into ciphertext data. The encryption process may involve field-level encryption, record-level encryption, or more fine-grained encryption methods to ensure that only authorized users can access and decrypt the data.

[0032] The system monitors the data update frequency of each data type in real time. This is achieved by tracking changes in data, including operations such as addition, modification, and deletion. Based on the data update frequency, the system evaluates the importance of each type of data. Data with a high update frequency often means that it has a higher business value or a higher real-time requirement, and is therefore identified as more important data. Based on the importance of the data, the system dynamically adjusts the data backup storage plan. This includes selecting the appropriate backup frequency (such as real-time backup, regular backup, etc.), backup media (such as hard disk, cloud storage, etc.), and backup strategy (such as full backup, incremental backup, differential backup, etc.). For data with high importance, more frequent backups and more reliable storage media may be used to ensure data availability and recovery speed.

[0033] The effect of the above technical solution is: by classifying and evaluating the sensitivity of the data in the database, and implementing differentiated encryption strategies based on the evaluation results, the security of sensitive data is effectively improved. Even if the data is illegally obtained, the original data cannot be decrypted and read without the correct key. Dynamic adjustment of the data backup storage solution can reasonably allocate backup resources according to the actual usage and importance of the data. This avoids the waste of resources while ensuring that critical data can be backed up in a timely and effective manner. In the event of data loss or damage, business continuity and data integrity are guaranteed by quickly and accurately restoring the encrypted data to its original state. This is crucial for enterprises and institutions that rely on databases to operate. The automated and intelligent integrated encryption and backup recovery method reduces the possibility of human intervention and errors, and reduces operation and maintenance costs and time consumption. Administrators can focus on other critical tasks without frequent manual intervention in the encryption and backup process of the database.

[0034] In summary, the adaptive database encryption and backup recovery integrated method achieves efficient, secure and flexible management of database data through mechanisms such as fine data classification and sensitivity assessment, encryption based on sensitivity levels, and dynamic adjustment of data backup storage solutions.

[0035] In one embodiment of the present invention, data in a database is classified, and sensitivity assessment is performed on each type of data to determine the sensitivity level corresponding to each type of data, including: S101, classify the data in the database to obtain various types of data information; S102, scanning each type of data information to obtain the frequency and duration of the interaction mode between each type of data information and the user within a unit time; wherein the interaction mode includes query interaction, modification interaction, analysis interaction, monitoring interaction and collaboration interaction; and the length of the unit time is 24h-72h; S103, obtaining a comprehensive sensitive indicator parameter corresponding to each type of data information according to the frequency and duration of the interaction mode between each type of data information and the user within a unit time; S104, comparing the comprehensive sensitive indicator parameter corresponding to each type of data information with a preset sensitive indicator parameter threshold; S105: When the comprehensive sensitivity index parameter corresponding to each type of data information is lower than a preset sensitivity index parameter threshold, the sensitivity level is determined to be low; S106: When the comprehensive sensitivity indicator parameter corresponding to each type of data information is not lower than a preset sensitivity indicator parameter threshold, the sensitivity level is determined to be high.

[0036] Specifically, the contents corresponding to various interaction modes are as follows: Query-based interaction: Users mainly perform data query operations, including searching, retrieving, and viewing data. Common in reporting systems, information retrieval systems, and data analysis applications.

[0037] Modification interaction: Users frequently add, update, or delete data. Typical application scenarios include content management systems, online transaction systems, and customer relationship management systems.

[0038] Analytical interaction: Users conduct complex data analysis, such as statistical analysis, trend forecasting, data mining, etc. This is often seen in the fields of financial analysis, market research, and scientific research.

[0039] Monitoring interaction: Users mainly monitor data changes and system status, such as real-time data streams, alarm systems, etc. Commonly used in network security, equipment monitoring, and real-time data tracking applications.

[0040] Collaborative interaction: Users collaborate with other users on the data platform to share and edit data. Commonly seen in online office tools, project management software, and social media platforms.

[0041] The working principle of the above technical solution is: to carefully classify the massive data in the database to obtain various types of data information. This step is the basis for subsequent sensitivity assessment, ensuring that each type of data can be analyzed independently and accurately. A comprehensive scan is performed on each type of data information, focusing on the frequency and duration of the five interaction modes (query interaction, modification interaction, analysis interaction, monitoring interaction, and collaborative interaction) between data and users within a unit time (24 hours to 72 hours). This step aims to capture the dynamic characteristics of data use and provide a quantitative basis for subsequent sensitivity assessment. Based on the interaction mode data obtained by scanning, the comprehensive sensitivity index parameter corresponding to each type of data information is calculated. This parameter is intended to comprehensively reflect the sensitivity level of the data. The calculated comprehensive sensitivity index parameter is compared with the preset sensitivity index parameter threshold. If the parameter is lower than the threshold, the sensitivity level of this type of data is determined to be low; if the parameter is not lower than the threshold, it is determined to be high. This step realizes the sensitivity classification of data and provides a basis for the subsequent data encryption and backup strategy formulation.

[0042] The effect of the above technical solution is: through detailed data classification, various types of data information in the database can be more accurately identified, laying the foundation for subsequent data management and utilization. By introducing interactive mode scanning and quantitative analysis between users and data, the sensitivity level of data can be evaluated more scientifically. This evaluation method based on actual usage is more objective and accurate than traditional subjective judgment. Differentiated encryption and backup strategies are formulated according to the sensitivity level of data, which not only ensures the security of sensitive data, but also avoids unnecessary waste of resources. For example, for data with a higher sensitivity level, a more powerful encryption algorithm and a more frequent backup strategy can be adopted; while for data with a lower sensitivity level, the encryption and backup requirements can be appropriately reduced. Through automated data classification, sensitivity assessment and sensitivity level determination process, the possibility of manual intervention and errors is reduced, and the intelligence level and efficiency of data management are improved. This helps enterprises better cope with the challenges brought by data growth and ensure the security and availability of data. In the event of data loss or damage, important data can be quickly and accurately restored to ensure business continuity and compliance requirements. This technical solution is particularly important for enterprises involving highly sensitive information such as user privacy and trade secrets.

[0043] In one embodiment of the present invention, obtaining the comprehensive sensitive indicator parameters corresponding to each type of data information according to the frequency and duration of the interaction mode between each type of data information and the user within a unit time includes: S1031. Generate an interaction matrix based on the frequency and duration of the interaction mode between each data information and the user in a unit time and the weight value corresponding to each interaction mode; wherein the structure of the interaction matrix is ​​as follows:

[0044] in, M represents the interaction matrix; M ij Indicates i The unit time corresponds to the j The weighted value corresponding to the interaction mode; and i The unit time corresponds to the j The weighted value corresponding to the interaction mode is obtained by the following formula:

[0045] in, M ij Indicates i The unit time of each data type corresponds to the j The weighted value corresponding to the interaction mode; W ij Indicates iThe unit time of each data type corresponds to the j The weight value corresponding to the interaction mode; F ij Indicates i The unit time of each data type corresponds to the j The frequency of occurrence of the interaction mode; T ij Indicates i The unit time of each data type corresponds to the j The average duration of each interaction mode; n Indicates the number of types of interaction modes; T j Indicates the first j The total duration of the interaction mode; T z Indicates the unit time n The median total duration of the interaction modes; T p Indicates the unit time n The average total duration of the interaction modes; D ij Indicates i The unit time of each data type corresponds to the j Dynamic regulators of the interaction patterns; S1032. Using the interaction matrix, obtain the sensitive indicator parameter corresponding to each type of data information in each unit time; wherein the sensitive indicator parameter corresponding to each type of data information is obtained by the following formula:

[0046] in, S i Indicates the unit time i Sensitive indicator parameters corresponding to the data information of the data types; M ij Indicates i The unit time corresponds to the j The weighted value corresponding to the interaction mode; n Indicates the number of types of interaction modes; S1033. Obtain the comprehensive sensitive indicator parameter corresponding to each type of data information in the current n unit times by using the sensitive indicator parameter corresponding to each type of data information in each unit time; wherein the comprehensive sensitive indicator parameter is obtained by the following formula:

[0047] in, G i Indicates iComprehensive sensitive indicator parameters of data types; x Indicates the number of time units that have passed; S ik Indicates i The data type k The sensitive indicator parameters corresponding to the unit time; l k Indicates k The time importance weight value corresponding to the unit time is obtained by the following formula:

[0048] in, l k Indicates k The time importance weight value corresponding to the unit time; y Indicates the preset attenuation factor; Z represents the normalization constant; A k Indicates the preset number of adjustment time period groups, which includes one or more unit times.

[0049] The working principle of the above technical solution is as follows: This step generates an interaction matrix M by combining the frequency (Fij), average duration (Tij) of the interaction mode between each data information and the user in a unit time, and the preset weight value (Wij) corresponding to each interaction mode. Each element Mij in the interaction matrix represents the weighted value of the jth interaction mode corresponding to the unit time of the i-th data type. In this process, variables such as the dynamic adjustment factor (Dij) and the total duration of the interaction mode in a unit time (Tj, Tz, Tp) are also introduced to more comprehensively reflect the dynamic characteristics and importance of data use. Using the constructed interaction matrix, the sensitive indicator parameter Si corresponding to each type of data information in each unit time is calculated. This calculation process takes into account the weighted values ​​of all interaction modes to ensure the comprehensiveness and accuracy of the sensitive indicator parameters.

[0050] Furthermore, the comprehensive sensitive indicator parameter Gi corresponding to each type of data information in the current n unit time is obtained by calculation. In this process, the time importance weight value (λk) is introduced to reflect the impact of data usage at different time points on the comprehensive sensitive indicator parameters. The calculation of the time importance weight value takes into account the preset attenuation factor (y) and the number of adjustment time period groups (Ak), so that the recent data usage occupies a greater weight in the comprehensive sensitive indicator parameters.

[0051] The effect of the above technical solution is: by constructing an interactive matrix and comprehensively considering multiple factors (such as the frequency, duration, weight value, etc. of the interactive mode), the dynamic characteristics and importance of data use can be more comprehensively reflected, thereby improving the accuracy of sensitivity assessment. The introduction of concepts such as dynamic adjustment factors and time importance weight values ​​makes the assessment results more scientific and reasonable. The dynamic adjustment factor can fine-tune the assessment results according to actual conditions, while the time importance weight value can reflect the impact of data usage at different time points on the comprehensive sensitivity index parameters. Through the calculated comprehensive sensitivity index parameters, differentiated data encryption and backup strategies can be formulated for different types of data information. For data with higher sensitivity levels, more powerful encryption algorithms and more frequent backup strategies can be adopted; for data with lower sensitivity levels, encryption and backup requirements can be appropriately reduced, thereby optimizing resource utilization. This technical solution realizes automated and intelligent data classification, sensitivity assessment and sensitivity level determination processes, reducing the possibility of manual intervention and errors. At the same time, by real-time monitoring of data usage and dynamically adjusting the assessment results, changes in data sensitivity can be reflected more promptly, providing more powerful support for data management.

[0052] In summary, the above technical solution realizes the accurate classification and sensitivity assessment of data information in the database by constructing an interactive matrix, calculating sensitive indicator parameters and comprehensive sensitive indicator parameters, etc., which provides strong support for the formulation of differentiated data encryption and backup strategies, and improves the intelligence level of data management.

[0053] In one embodiment of the present invention, encryption is performed according to the sensitivity level corresponding to each data type to obtain encrypted data information of various types, including: S201. When the sensitivity level of each type of data information is low, randomly select a first encryption type to encrypt the data information with a low sensitivity level; wherein the first encryption type includes AES-128, DES, Triple DES and Blowfish; S202. When the sensitivity level of each type of data information is high, randomly select a second encryption type to encrypt the data information with a low sensitivity level; wherein the second encryption type includes AES-256, RSA-4096 and ECC.

[0054] The working principle of the above technical solution is: first, according to the previous steps (such as S101 to S106 in the problem description), the sensitivity level of each data type has been determined, which is the prerequisite for selecting the encryption type.

[0055] For data information with a low sensitivity level, the system randomly selects the first encryption type for encryption. The first encryption type includes AES-128, DES, Triple DES, and Blowfish. These encryption algorithms provide a good balance between security and computational efficiency and are suitable for data with relatively low sensitivity. For data information with a high sensitivity level, the system randomly selects the second encryption type for encryption. The second encryption type includes AES-256, RSA-4096, and ECC. These encryption algorithms provide higher security and can resist more powerful attack methods, and are suitable for data with extremely high sensitivity.

[0056] According to the selected encryption type, the system encrypts the corresponding data information. The encryption process may involve multiple steps such as key generation, initialization vector selection, data encryption, etc., depending on the characteristics of the selected encryption algorithm.

[0057] The effect of the above technical solution is: by selecting encryption algorithms of different strengths for data information of different sensitivity levels, the technical solution not only ensures sufficient security of sensitive data, but also avoids the waste of computing resources that may be caused by using uniform high-strength encryption for all data. For data information with lower sensitivity, the use of encryption algorithms with higher computational efficiency can reduce the occupation of system resources by the encryption process while ensuring a certain degree of security. For data with extremely high sensitivity, a higher-strength encryption algorithm is used to provide stronger security protection.

[0058] The design of this technical solution has certain adaptability and scalability. With the continuous development of encryption technology, the encryption type library can be easily updated and expanded to adapt to new security requirements and threat environments. In many industry fields, such as finance and medical care, there are strict compliance and legal requirements for data encryption. This technical solution helps enterprises meet these compliance and legal requirements through flexible encryption strategy selection.

[0059] To sum up, this technical solution achieves many technical effects, such as balancing flexibility and security, optimizing resource allocation, improving adaptability and scalability, and complying with regulations and laws, by selecting encryption types based on the sensitivity level of data types.

[0060] An embodiment of the present invention monitors the data update frequency corresponding to each data type in real time, determines the importance of each type according to the data update frequency, and dynamically adjusts the data backup storage scheme according to the importance of each type, including: S301, real-time monitoring of the data update frequency corresponding to each data type; S302, retrieve the correlation value between each data type and other data types; wherein the correlation value is obtained by the following formula:

[0061] in, R Indicates the numerical value of the correlation between each data type and various data types in other data types; g Indicates the number of data updates corresponding to each data type; F i Indicates the first i When data is updated for the first time, the number of linked updated data corresponding to each data type in the corresponding other data types; Z i Indicates the first i The total number of data updated when data is updated; F max Represents each data type n The maximum number of linked update data that occurs during data update; F b Indicates the standard deviation of the number of linkage update data of other data types corresponding to the maximum number of linkage update data; Z max Indicates the total number of data updated for each data type when the data corresponding to the maximum number of linked updated data is updated; S303, obtaining an importance evaluation parameter corresponding to each data type by using the data update frequency corresponding to each data type and the correlation value between each data type and other data types; The importance evaluation parameter is obtained by the following formula:

[0062] in, K represents the importance evaluation parameter; w f Indicates the weight coefficient corresponding to the data update frequency; w c Indicates the weight coefficient corresponding to the correlation degree; f Indicates the data update frequency corresponding to each data type; f max Indicates the data update frequency of other data types corresponding to the maximum value of the correlation degree of each data type; σ represents the nonlinear adjustment coefficient, and the value range of the nonlinear adjustment coefficient is 0.59-1.12; R z It represents the comprehensive coefficient of association corresponding to each data type, and the comprehensive coefficient of association is obtained by the following formula:

[0063] in, R z represents the comprehensive coefficient of correlation; m Indicates the number of other data types corresponding to each data type; R i Indicates i The corresponding correlation values ​​of other data types; R b Indicates the corresponding data type m The standard deviation of the correlation values ​​corresponding to other data types; R bmax express m The standard deviation of the correlation values ​​of other data types corresponding to the data type corresponding to the maximum correlation value of other data types; R bmin express m The standard deviation of the correlation values ​​of other data types corresponding to the data type corresponding to the minimum correlation value of other data types; S304, comparing the importance evaluation parameter with a preset importance evaluation threshold; S305. When the importance evaluation parameter is lower than a preset importance evaluation threshold, the data backup storage scheme is kept unchanged; when the importance evaluation parameter is not lower than the preset importance evaluation threshold, the data backup frequency in the data backup storage scheme is adjusted.

[0064] The working principle of the above technical solution is: the system continuously tracks and records the update frequency of each data type per unit time. This step is the basis for evaluating the importance of data types, because data types with high update frequencies often mean that the data changes quickly, and the requirements for data integrity and timeliness are also higher. In addition to the frequency of data updates, the system also considers the correlation between each data type and other data types. The correlation value reflects the degree of mutual dependence and influence between data types. This step helps to more comprehensively evaluate the importance of data types, because although some data types are not updated frequently, they may be highly correlated with other key data types, and therefore also need to be given sufficient attention.

[0065] Using the real-time monitored data update frequency and the retrieved data type association value, the system calculates the importance evaluation parameter of each data type through a certain algorithm. This parameter is a comprehensive indicator that takes into account both the update frequency of the data itself and the degree of association between the data and other data types. The system compares the calculated importance evaluation parameter with the preset importance evaluation threshold. The preset threshold is set in advance based on business needs, data importance and other factors, and is used to determine whether the data type needs to adjust the data backup storage solution.

[0066] According to the comparison results, the system dynamically adjusts the data backup storage plan. If the importance evaluation parameter is lower than the preset threshold, it means that the importance of the data type is relatively low, and the current data backup storage plan can be kept unchanged; if the importance evaluation parameter is not lower than the preset threshold, it means that the importance of the data type is high, and it is necessary to increase the frequency of data backup or adopt a higher level of backup storage plan to ensure the security and integrity of the data.

[0067] The effect of the above technical solution is: by real-time monitoring of data update frequency and evaluation of data type importance, the system can more accurately determine which data types require more frequent or higher-level backup. This avoids the problem of resource waste or insufficient backup of key data that may be caused by adopting a unified backup strategy for all data types, and improves the pertinence and efficiency of data backup. For data types with high update frequency or high correlation with other key data types, the system can automatically increase the backup frequency or adopt a higher-level backup storage solution. This helps to ensure that these key data can be restored in time in the event of an accident, thereby ensuring the security and integrity of the data. By dynamically adjusting the data backup storage solution, the system can respond to changes in the data environment more flexibly. Even in certain emergencies (such as system failures, human errors, etc.), the risk of data loss can be minimized to the greatest extent because the backup solution has been adjusted and optimized in time. The technical solution realizes an automated and intelligent data backup storage solution adjustment process, reducing the possibility of manual intervention and errors. Operation and maintenance personnel can devote more energy to other important IT management tasks, improving the intelligence level of operation and maintenance management.

[0068] On the other hand, by calculating the correlation value, the degree of mutual influence between different data types can be quantified. This helps to identify which data types have stronger correlation in the data ecosystem, so as to better understand the overall structure and relationship of the data. Obtaining correlation values ​​helps to optimize the data processing process. For data types with strong correlation, you can consider synchronous updates or joint analysis during the data processing process to improve the efficiency and accuracy of data processing. Understanding the correlation between data can also help identify potential data security risks. For example, if a key data type is highly correlated with multiple other data types, then special attention needs to be paid to the security of this data type to prevent data leakage or tampering from having a serious impact on the entire data ecosystem.

[0069] Notice that by calculating the importance evaluation parameters, a personalized value assessment can be performed for each data type. This helps to identify which data types have higher importance in the data ecosystem, so as to allocate more resources and attention to them. The acquisition of importance evaluation parameters helps to optimize data storage and backup strategies. For data types with higher importance, the frequency of storage and backup can be increased to ensure the security and reliability of the data. At the same time, for data types with lower importance, the frequency of storage and backup can be appropriately reduced to save storage resources. In terms of data governance and compliance, importance evaluation parameters can also provide valuable references. By understanding which data types have higher importance, corresponding data protection policies and measures can be formulated to ensure data compliance and privacy. Importance evaluation parameters can also provide support for data decision-making. When faced with decisions such as data use, sharing or deletion, more reasonable decision-making plans can be formulated based on the importance evaluation parameters of the data to improve the efficiency and accuracy of decision-making.

[0070] In summary, this technical solution achieves multiple technical effects such as improving the pertinence of data backup, ensuring data security and integrity, reducing the risk of data loss, and improving the level of intelligent operation and maintenance management by real-time monitoring of data update frequency, evaluating the importance of data types, and dynamically adjusting the data backup storage solution accordingly. The technical effects of using the above physical quantities to obtain correlation values ​​and importance evaluation parameters are mainly reflected in quantifying the mutual influence between data, optimizing data processing procedures, enhancing data security, personalized evaluation of data value, optimizing data storage and backup strategies, supporting data governance and compliance, and improving decision-making efficiency. These effects together provide strong support for data management and applications.

[0071] The embodiment of the present invention proposes an adaptive database encryption and backup recovery integrated system, such as Figure 2 As shown, the adaptive database encryption and backup recovery integrated system includes: A sensitivity level determination module is used to classify the data in the database and conduct sensitivity assessment on each type of data to determine the sensitivity level corresponding to each data type; An encryption module, used to encrypt data according to the sensitivity level corresponding to each data type to obtain encrypted data information of various types; The storage scheme adjustment module is used to monitor the data update frequency corresponding to each data type in real time, and determine the importance of various types based on the data update frequency, and dynamically adjust the data backup storage scheme based on the importance of various types.

[0072] The working principle of the above technical solution is as follows: First, the system comprehensively classifies all data in the database. This is usually based on factors such as the nature, purpose and source of the data, such as personal information, transaction records, business reports, etc. Next, the system conducts a sensitivity assessment on each type of data. This process may consider multiple dimensions, including the legal compliance of the data (such as GDPR, HIPAA and other regulatory requirements), commercial value, leakage risk, etc. Through comprehensive evaluation, the system assigns a sensitivity level to each data type, such as "high" and "low".

[0073] The system formulates corresponding encryption strategies according to the sensitivity level corresponding to each data type. The more sensitive the data is, the more powerful the encryption algorithm and the more complex the key management strategy are. The system automatically performs encryption operations to convert the plaintext data in the database into ciphertext data. The encryption process may involve field-level encryption, record-level encryption, or more fine-grained encryption methods to ensure that only authorized users can access and decrypt the data.

[0074] The system monitors the data update frequency of each data type in real time. This is achieved by tracking changes in data, including operations such as addition, modification, and deletion. Based on the data update frequency, the system evaluates the importance of each type of data. Data with a high update frequency often means that it has a higher business value or a higher real-time requirement, and is therefore identified as more important data. Based on the importance of the data, the system dynamically adjusts the data backup storage plan. This includes selecting the appropriate backup frequency (such as real-time backup, regular backup, etc.), backup media (such as hard disk, cloud storage, etc.), and backup strategy (such as full backup, incremental backup, differential backup, etc.). For data with high importance, more frequent backups and more reliable storage media may be used to ensure data availability and recovery speed.

[0075] The effect of the above technical solution is: by classifying and evaluating the sensitivity of the data in the database, and implementing differentiated encryption strategies based on the evaluation results, the security of sensitive data is effectively improved. Even if the data is illegally obtained, the original data cannot be decrypted and read without the correct key. Dynamic adjustment of the data backup storage solution can reasonably allocate backup resources according to the actual usage and importance of the data. This avoids the waste of resources while ensuring that critical data can be backed up in a timely and effective manner. In the event of data loss or damage, business continuity and data integrity are guaranteed by quickly and accurately restoring the encrypted data to its original state. This is crucial for enterprises and institutions that rely on databases to operate. The automated and intelligent integrated encryption and backup recovery method reduces the possibility of human intervention and errors, and reduces operation and maintenance costs and time consumption. Administrators can focus on other critical tasks without frequent manual intervention in the encryption and backup process of the database.

[0076] In summary, the adaptive database encryption and backup recovery integrated method achieves efficient, secure and flexible management of database data through mechanisms such as fine data classification and sensitivity assessment, encryption based on sensitivity levels, and dynamic adjustment of data backup storage solutions.

[0077] In one embodiment of the present invention, the sensitivity level determination module includes: Data classification module, used to classify data in the database and obtain various types of data information; An interactive information acquisition module is used to scan each type of data information and acquire the frequency and duration of the interaction mode between each type of data information and the user within a unit time; wherein the interaction mode includes query interaction, modification interaction, analysis interaction, monitoring interaction and collaboration interaction; and the length of the unit time is 24h-72h; A comprehensive sensitive indicator parameter acquisition module, used to acquire the comprehensive sensitive indicator parameters corresponding to each type of data information according to the frequency and duration of the interaction mode between each type of data information and the user within a unit time; A first comparison module, used to compare the comprehensive sensitive indicator parameter corresponding to each type of data information with a preset sensitive indicator parameter threshold; A first sensitivity level determination module, configured to determine that the sensitivity level is low when the comprehensive sensitivity indicator parameter corresponding to each type of data information is lower than a preset sensitivity indicator parameter threshold; The second sensitivity level determination module is used to determine that the sensitivity level is high when the comprehensive sensitivity indicator parameter corresponding to each type of data information is not lower than a preset sensitivity indicator parameter threshold.

[0078] Specifically, the contents corresponding to various interaction modes are as follows: Query-based interaction: Users mainly perform data query operations, including searching, retrieving, and viewing data. Common in reporting systems, information retrieval systems, and data analysis applications.

[0079] Modification interaction: Users frequently add, update, or delete data. Typical application scenarios include content management systems, online transaction systems, and customer relationship management systems.

[0080] Analytical interaction: Users conduct complex data analysis, such as statistical analysis, trend forecasting, data mining, etc. This is often seen in the fields of financial analysis, market research, and scientific research.

[0081] Monitoring interaction: Users mainly monitor data changes and system status, such as real-time data streams, alarm systems, etc. Commonly used in network security, equipment monitoring, and real-time data tracking applications.

[0082] Collaborative interaction: Users collaborate with other users on the data platform to share and edit data. Commonly seen in online office tools, project management software, and social media platforms.

[0083] The working principle of the above technical solution is: to carefully classify the massive data in the database to obtain various types of data information. This step is the basis for subsequent sensitivity assessment, ensuring that each type of data can be analyzed independently and accurately. A comprehensive scan is performed on each type of data information, focusing on the frequency and duration of the five interaction modes (query interaction, modification interaction, analysis interaction, monitoring interaction, and collaborative interaction) between data and users within a unit time (24 hours to 72 hours). This step aims to capture the dynamic characteristics of data use and provide a quantitative basis for subsequent sensitivity assessment. Based on the interaction mode data obtained by scanning, the comprehensive sensitivity index parameter corresponding to each type of data information is calculated. This parameter is intended to comprehensively reflect the sensitivity level of the data. The calculated comprehensive sensitivity index parameter is compared with the preset sensitivity index parameter threshold. If the parameter is lower than the threshold, the sensitivity level of this type of data is determined to be low; if the parameter is not lower than the threshold, it is determined to be high. This step realizes the sensitivity classification of data and provides a basis for the subsequent data encryption and backup strategy formulation.

[0084] The effect of the above technical solution is: through detailed data classification, various types of data information in the database can be more accurately identified, laying the foundation for subsequent data management and utilization. By introducing interactive mode scanning and quantitative analysis between users and data, the sensitivity level of data can be evaluated more scientifically. This evaluation method based on actual usage is more objective and accurate than traditional subjective judgment. Differentiated encryption and backup strategies are formulated according to the sensitivity level of data, which not only ensures the security of sensitive data, but also avoids unnecessary waste of resources. For example, for data with a higher sensitivity level, a more powerful encryption algorithm and a more frequent backup strategy can be adopted; while for data with a lower sensitivity level, the encryption and backup requirements can be appropriately reduced. Through automated data classification, sensitivity assessment and sensitivity level determination process, the possibility of manual intervention and errors is reduced, and the intelligence level and efficiency of data management are improved. This helps enterprises better cope with the challenges brought by data growth and ensure the security and availability of data. In the event of data loss or damage, important data can be quickly and accurately restored to ensure business continuity and compliance requirements. This technical solution is particularly important for enterprises involving highly sensitive information such as user privacy and trade secrets.

[0085] In one embodiment of the present invention, the comprehensive sensitive indicator parameter acquisition module includes: The interaction matrix generation module is used to generate an interaction matrix based on the frequency and duration of the interaction mode between each data information and the user in a unit time and the weight value corresponding to each interaction mode; wherein the structure of the interaction matrix is ​​as follows:

[0086] in, M represents the interaction matrix; M ij Indicates i The unit time corresponds to the j The weighted value corresponding to the interaction mode; and i The unit time corresponds to the j The weighted value corresponding to the interaction mode is obtained by the following formula:

[0087] in, M ij Indicates i The unit time of each data type corresponds to the j The weighted value corresponding to the interaction mode; W ij Indicates i The unit time of each data type corresponds to the j The weight value corresponding to the interaction mode; F ij Indicates i The unit time of each data type corresponds to the j The frequency of occurrence of the interaction mode; T ij Indicates i The unit time of each data type corresponds to the j The average duration of each interaction mode; n Indicates the number of types of interaction modes; T j Indicates the first j The total duration of the interaction mode; T z Indicates the unit time n The median total duration of the interaction modes; T p Indicates the unit time n The average total duration of the interaction modes; D ij Indicates i The unit time of each data type corresponds to the j Dynamic regulators of the interaction patterns; The sensitive indicator parameter acquisition module is used to use the interactive matrix to obtain the sensitive indicator parameters corresponding to each type of data information in each unit time; wherein the sensitive indicator parameters corresponding to each type of data information are obtained by the following formula:

[0088] in, S i Indicates the unit time i Sensitive indicator parameters corresponding to the data information of the data types; M ij Indicates i The unit time corresponds to the j The weighted value corresponding to the interaction mode; n Indicates the number of types of interaction modes; The comprehensive sensitive indicator parameter acquisition execution module is used to obtain the comprehensive sensitive indicator parameters corresponding to each type of data information in the current n unit times by using the sensitive indicator parameters corresponding to each type of data information in each unit time; wherein the comprehensive sensitive indicator parameters are obtained by the following formula:

[0089] in, G i Indicates i Comprehensive sensitive indicator parameters of data types; x Indicates the number of time units that have passed; S ik Indicates i The data type k The sensitive indicator parameters corresponding to the unit time; l k Indicates k The time importance weight value corresponding to the unit time is obtained by the following formula:

[0090] in, l k Indicates k The time importance weight value corresponding to the unit time; y Indicates the preset attenuation factor; Z represents the normalization constant; A k Indicates the preset number of adjustment time period groups, which includes one or more unit times.

[0091] The working principle of the above technical solution is as follows: This step generates an interaction matrix M by combining the frequency (Fij), average duration (Tij) of the interaction mode between each data information and the user in a unit time, and the preset weight value (Wij) corresponding to each interaction mode. Each element Mij in the interaction matrix represents the weighted value of the jth interaction mode corresponding to the unit time of the i-th data type. In this process, variables such as the dynamic adjustment factor (Dij) and the total duration of the interaction mode in a unit time (Tj, Tz, Tp) are also introduced to more comprehensively reflect the dynamic characteristics and importance of data use. Using the constructed interaction matrix, the sensitive indicator parameter Si corresponding to each type of data information in each unit time is calculated. This calculation process takes into account the weighted values ​​of all interaction modes to ensure the comprehensiveness and accuracy of the sensitive indicator parameters.

[0092] Furthermore, the comprehensive sensitive indicator parameter Gi corresponding to each type of data information in the current n unit time is obtained by calculation. In this process, the time importance weight value (λk) is introduced to reflect the impact of data usage at different time points on the comprehensive sensitive indicator parameters. The calculation of the time importance weight value takes into account the preset attenuation factor (y) and the number of adjustment time period groups (Ak), so that the recent data usage occupies a greater weight in the comprehensive sensitive indicator parameters.

[0093] The effect of the above technical solution is: by constructing an interactive matrix and comprehensively considering multiple factors (such as the frequency, duration, weight value, etc. of the interactive mode), the dynamic characteristics and importance of data use can be more comprehensively reflected, thereby improving the accuracy of sensitivity assessment. The introduction of concepts such as dynamic adjustment factors and time importance weight values ​​makes the assessment results more scientific and reasonable. The dynamic adjustment factor can fine-tune the assessment results according to actual conditions, while the time importance weight value can reflect the impact of data usage at different time points on the comprehensive sensitivity index parameters. Through the calculated comprehensive sensitivity index parameters, differentiated data encryption and backup strategies can be formulated for different types of data information. For data with higher sensitivity levels, more powerful encryption algorithms and more frequent backup strategies can be adopted; for data with lower sensitivity levels, encryption and backup requirements can be appropriately reduced, thereby optimizing resource utilization. This technical solution realizes automated and intelligent data classification, sensitivity assessment and sensitivity level determination processes, reducing the possibility of manual intervention and errors. At the same time, by real-time monitoring of data usage and dynamically adjusting the assessment results, changes in data sensitivity can be reflected more promptly, providing more powerful support for data management.

[0094] In summary, the above technical solution realizes the accurate classification and sensitivity assessment of data information in the database by constructing an interactive matrix, calculating sensitive indicator parameters and comprehensive sensitive indicator parameters, etc., which provides strong support for the formulation of differentiated data encryption and backup strategies, and improves the intelligence level of data management.

[0095] In one embodiment of the present invention, the encryption module comprises: A first encryption module, configured to randomly select a first encryption type to encrypt the data information with a low sensitivity level when the sensitivity level of each type of data information is low; wherein the first encryption type includes AES-128, DES, Triple DES and Blowfish; The second encryption module is used to randomly select a second encryption type to encrypt data information with a low sensitivity level when the sensitivity level of each type of data information is high; wherein the second encryption type includes AES-256, RSA-4096 and ECC.

[0096] The working principle of the above technical solution is: first, according to the previous steps (such as S101 to S106 in the problem description), the sensitivity level of each data type has been determined, which is the prerequisite for selecting the encryption type.

[0097] For data information with a low sensitivity level, the system randomly selects the first encryption type for encryption. The first encryption type includes AES-128, DES, Triple DES, and Blowfish. These encryption algorithms provide a good balance between security and computational efficiency and are suitable for data with relatively low sensitivity. For data information with a high sensitivity level, the system randomly selects the second encryption type for encryption. The second encryption type includes AES-256, RSA-4096, and ECC. These encryption algorithms provide higher security and can resist more powerful attack methods, and are suitable for data with extremely high sensitivity.

[0098] According to the selected encryption type, the system encrypts the corresponding data information. The encryption process may involve multiple steps such as key generation, initialization vector selection, data encryption, etc., depending on the characteristics of the selected encryption algorithm.

[0099] The effect of the above technical solution is: by selecting encryption algorithms of different strengths for data information of different sensitivity levels, the technical solution not only ensures sufficient security of sensitive data, but also avoids the waste of computing resources that may be caused by using uniform high-strength encryption for all data. For data information with lower sensitivity, the use of encryption algorithms with higher computational efficiency can reduce the occupation of system resources by the encryption process while ensuring a certain degree of security. For data with extremely high sensitivity, a higher-strength encryption algorithm is used to provide stronger security protection.

[0100] The design of this technical solution has certain adaptability and scalability. With the continuous development of encryption technology, the encryption type library can be easily updated and expanded to adapt to new security requirements and threat environments. In many industry fields, such as finance and medical care, there are strict compliance and legal requirements for data encryption. This technical solution helps enterprises meet these compliance and legal requirements through flexible encryption strategy selection.

[0101] To sum up, this technical solution achieves many technical effects, such as balancing flexibility and security, optimizing resource allocation, improving adaptability and scalability, and complying with regulations and laws, by selecting encryption types based on the sensitivity level of data types.

[0102] In one embodiment of the present invention, the storage scheme adjustment module includes: Frequency monitoring module, used to monitor the data update frequency corresponding to each data type in real time; A correlation value retrieving module is used to retrieve the correlation value between each data type and other data types; An importance evaluation parameter acquisition module, used to acquire the importance evaluation parameter corresponding to each data type by using the data update frequency corresponding to each data type and the correlation value between each data type and other data types; A second comparison module, used for comparing the importance evaluation parameter with a preset importance evaluation threshold; The storage scheme adjustment module is used to keep the data backup storage scheme unchanged when the importance evaluation parameter is lower than the preset importance evaluation threshold; when the importance evaluation parameter is not lower than the preset importance evaluation threshold, adjust the data backup frequency in the data backup storage scheme.

[0103] The working principle of the above technical solution is: the system continuously tracks and records the update frequency of each data type per unit time. This step is the basis for evaluating the importance of data types, because data types with high update frequencies often mean that the data changes quickly, and the requirements for data integrity and timeliness are also higher. In addition to the frequency of data updates, the system also considers the correlation between each data type and other data types. The correlation value reflects the degree of mutual dependence and influence between data types. This step helps to more comprehensively evaluate the importance of data types, because although some data types are not updated frequently, they may be highly correlated with other key data types, and therefore also need to be given sufficient attention.

[0104] Using the real-time monitored data update frequency and the retrieved data type association value, the system calculates the importance evaluation parameter of each data type through a certain algorithm. This parameter is a comprehensive indicator that takes into account both the update frequency of the data itself and the degree of association between the data and other data types. The system compares the calculated importance evaluation parameter with the preset importance evaluation threshold. The preset threshold is set in advance based on business needs, data importance and other factors, and is used to determine whether the data type needs to adjust the data backup storage solution.

[0105] According to the comparison results, the system dynamically adjusts the data backup storage plan. If the importance evaluation parameter is lower than the preset threshold, it means that the importance of the data type is relatively low, and the current data backup storage plan can be kept unchanged; if the importance evaluation parameter is not lower than the preset threshold, it means that the importance of the data type is high, and it is necessary to increase the frequency of data backup or adopt a higher level of backup storage plan to ensure the security and integrity of the data.

[0106] The effect of the above technical solution is: by real-time monitoring of data update frequency and evaluation of data type importance, the system can more accurately determine which data types require more frequent or higher-level backup. This avoids the problem of resource waste or insufficient backup of key data that may result from the use of a unified backup strategy for all data types, and improves the pertinence and efficiency of data backup. For data types with high update frequency or high correlation with other key data types, the system can automatically increase the backup frequency or adopt a higher-level backup storage solution. This helps ensure that these key data can be restored in a timely manner in the event of an unexpected situation, thereby ensuring the security and integrity of the data.

[0107] By dynamically adjusting the data backup storage solution, the system can respond to changes in the data environment more flexibly. Even in some unexpected situations (such as system failures, human errors, etc.), the risk of data loss can be minimized because the backup solution is adjusted and optimized in a timely manner. This technical solution realizes the automation and intelligent adjustment process of the data backup storage solution, reducing the possibility of manual intervention and errors. Operation and maintenance personnel can devote more energy to other important IT management tasks, improving the intelligence level of operation and maintenance management.

[0108] To summarize, this technical solution achieves multiple technical effects such as improving the targetedness of data backup, ensuring data security and integrity, reducing the risk of data loss, and improving the level of intelligent operation and maintenance management by real-time monitoring of data update frequency, evaluating the importance of data types, and dynamically adjusting the data backup storage solution accordingly.

[0109] Obviously, those skilled in the art can make various changes and modifications to the present invention without departing from the spirit and scope of the present invention. Thus, if these modifications and variations of the present invention fall within the scope of the claims of the present invention and their equivalents, the present invention is also intended to include these modifications and variations.

Claims

1. An adaptive database encryption and backup recovery integrated method, characterized in that: The adaptive database encryption and backup recovery integrated method includes: Classify the data in the database and conduct sensitivity assessment on each type of data to determine the sensitivity level corresponding to each type of data; Encrypting according to the sensitivity level corresponding to each data type to obtain encrypted data information of various types; Monitor the data update frequency corresponding to each data type in real time, determine the importance of each type according to the data update frequency, and dynamically adjust the data backup storage plan according to the importance of each type; The data in the database is classified, and each type of data is evaluated for sensitivity to determine the sensitivity level corresponding to each data type, including: Classify the data in the database and obtain various types of data information; Scan each type of data information to obtain the frequency and duration of the interaction mode between each type of data information and the user within a unit time; wherein the interaction mode includes query interaction, modification interaction, analysis interaction, monitoring interaction and collaboration interaction; and the length of the unit time is 24h-72h; Obtaining comprehensive sensitive indicator parameters corresponding to each type of data information according to the frequency and duration of the interaction mode between each type of data information and the user within a unit time; Compare the comprehensive sensitive indicator parameter corresponding to each type of data information with a preset sensitive indicator parameter threshold; When the comprehensive sensitivity index parameter corresponding to each type of data information is lower than the preset sensitivity index parameter threshold, the sensitivity level is determined to be low; When the comprehensive sensitivity indicator parameter corresponding to each type of data information is not lower than a preset sensitivity indicator parameter threshold, the sensitivity level is determined to be high.

2. The adaptive database encryption and backup recovery integrated method according to claim 1 is characterized in that: The comprehensive sensitive indicator parameters corresponding to each type of data information are obtained according to the frequency and duration of the interaction mode between each type of data information and the user within a unit time, including: The frequency and duration of the interaction mode between each data information and the user in a unit time are combined with the weight value corresponding to each interaction mode to generate an interaction matrix; wherein the structure of the interaction matrix is ​​as follows: in, M represents the interaction matrix; M ij Indicates i The unit time corresponds to the j The weighted value corresponding to the interaction mode; and i The unit time corresponds to the j The weighted value corresponding to the interaction mode is obtained by the following formula: in, M ij Indicates i The unit time of each data type corresponds to the j The weighted value corresponding to the interaction mode; W ij Indicates i The unit time of each data type corresponds to the j The weight value corresponding to the interaction mode; F ij Indicates i The unit time of each data type corresponds to the j The frequency of occurrence of the interaction mode; T ij Indicates i The unit time of each data type corresponds to the j The average duration of each interaction mode; n Indicates the number of types of interaction modes; T j Indicates the first j The total duration of the interaction mode; T z Indicates the unit time n The median total duration of the interaction modes; T p Indicates the unit time n The average total duration of the interaction modes; D ij Indicates i The unit time of each data type corresponds to the j Dynamic regulators of the interaction patterns; The interactive matrix is ​​used to obtain the sensitive indicator parameters corresponding to each type of data information in each unit time; wherein the sensitive indicator parameters corresponding to each type of data information are obtained by the following formula: in, S i Indicates the unit time i Sensitive indicator parameters corresponding to the data information of the data types; M ij Indicates i The unit time corresponds to the j The weighted value corresponding to the interaction mode; n Indicates the number of types of interaction modes; The comprehensive sensitive indicator parameters corresponding to each type of data information in each unit time are obtained by using the sensitive indicator parameters corresponding to each type of data information in the current n unit time; wherein the comprehensive sensitive indicator parameters are obtained by the following formula: in, G i Indicates i Comprehensive sensitive indicator parameters of various data types; x Indicates the number of time units that have passed; S ik Indicates i The data type k The sensitive indicator parameters corresponding to the unit time; λ k Indicates k The time importance weight value corresponding to the unit time is obtained by the following formula: in, λ k Indicates k The time importance weight value corresponding to the unit time; y Indicates the preset attenuation factor; Z represents the normalization constant; A k Indicates the preset number of adjustment time period groups, which includes one or more unit times.

3. The adaptive database encryption and backup recovery integrated method according to claim 1 is characterized in that: Encryption is performed according to the sensitivity level corresponding to each data type to obtain encrypted data information of various types, including: When the sensitivity level of each type of data information is low, randomly selecting a first encryption type to encrypt the data information with a low sensitivity level; wherein the first encryption type includes AES-128, DES, Triple DES and Blowfish; When the sensitivity level of each type of data information is high, a second encryption type is randomly selected to encrypt the data information with a low sensitivity level; wherein the second encryption type includes AES-256, RSA-4096 and ECC.

4. The adaptive database encryption and backup recovery integrated method according to claim 1 is characterized in that: Monitor the data update frequency corresponding to each data type in real time, and determine the importance of each type according to the data update frequency, and dynamically adjust the data backup storage plan according to the importance of each type, including: Real-time monitoring of the data update frequency corresponding to each data type; Retrieve the correlation value between each data type and other data types; Obtaining the importance evaluation parameter corresponding to each data type using the data update frequency corresponding to each data type and the correlation value between each data type and other data types; Comparing the importance evaluation parameter with a preset importance evaluation threshold; When the importance evaluation parameter is lower than a preset importance evaluation threshold, the data backup storage scheme is kept unchanged; when the importance evaluation parameter is not lower than the preset importance evaluation threshold, the data backup frequency in the data backup storage scheme is adjusted.

5. An adaptive database encryption and backup recovery integrated system, characterized in that: The adaptive database encryption and backup recovery integrated system includes: A sensitivity level determination module is used to classify the data in the database and conduct sensitivity assessment on each type of data to determine the sensitivity level corresponding to each data type; An encryption module, used to encrypt data according to the sensitivity level corresponding to each data type to obtain encrypted data information of various types; A storage scheme adjustment module is used to monitor the data update frequency corresponding to each data type in real time, and determine the importance of each type according to the data update frequency, and dynamically adjust the data backup storage scheme according to the importance of each type; Wherein, the sensitivity level determination module includes: Data classification module, used to classify data in the database and obtain various types of data information; An interactive information acquisition module is used to scan each type of data information and acquire the frequency and duration of the interaction mode between each type of data information and the user within a unit time; wherein the interaction mode includes query interaction, modification interaction, analysis interaction, monitoring interaction and collaboration interaction; and the length of the unit time is 24h-72h; A comprehensive sensitive indicator parameter acquisition module, used to acquire the comprehensive sensitive indicator parameters corresponding to each type of data information according to the frequency and duration of the interaction mode between each type of data information and the user within a unit time; A first comparison module, used to compare the comprehensive sensitive indicator parameter corresponding to each type of data information with a preset sensitive indicator parameter threshold; A first sensitivity level determination module, configured to determine that the sensitivity level is low when the comprehensive sensitivity indicator parameter corresponding to each type of data information is lower than a preset sensitivity indicator parameter threshold; The second sensitivity level determination module is used to determine that the sensitivity level is high when the comprehensive sensitivity indicator parameter corresponding to each type of data information is not lower than a preset sensitivity indicator parameter threshold.

6. The adaptive database encryption and backup recovery integrated system according to claim 5 is characterized in that: The comprehensive sensitive indicator parameter acquisition module includes: The interaction matrix generation module is used to generate an interaction matrix based on the frequency and duration of the interaction mode between each data information and the user in a unit time and the weight value corresponding to each interaction mode; wherein the structure of the interaction matrix is ​​as follows: in, M represents the interaction matrix; M ij Indicates i The unit time corresponds to the j The weighted value corresponding to the interaction mode; and i The unit time corresponds to the j The weighted value corresponding to the interaction mode is obtained by the following formula: in, M ij Indicates i The unit time of each data type corresponds to the j The weighted value corresponding to the interaction mode; W ij Indicates i The unit time of each data type corresponds to the j The weight value corresponding to the interaction mode; F ij Indicates i The unit time of each data type corresponds to the j The frequency of occurrence of the interaction mode; T ij Indicates i The unit time of each data type corresponds to the j The average duration of each interaction mode; n Indicates the number of types of interaction modes; T j Indicates the first j The total duration of the interaction mode; T z Indicates the unit time n The median total duration of the interaction modes; T p Indicates the unit time n The average total duration of the interaction modes; D ij Indicates i The unit time of each data type corresponds to the j Dynamic regulators of the interaction patterns; The sensitive indicator parameter acquisition module is used to use the interactive matrix to obtain the sensitive indicator parameters corresponding to each type of data information in each unit time; wherein the sensitive indicator parameters corresponding to each type of data information are obtained by the following formula: in, S i Indicates the unit time i Sensitive indicator parameters corresponding to the data information of the data types; M ij Indicates i The unit time corresponds to the j The weighted value corresponding to the interaction mode; n Indicates the number of types of interaction modes; The comprehensive sensitive indicator parameter acquisition execution module is used to obtain the comprehensive sensitive indicator parameters corresponding to each type of data information in the current n unit times by using the sensitive indicator parameters corresponding to each type of data information in each unit time; wherein the comprehensive sensitive indicator parameters are obtained by the following formula: in, G i Indicates i Comprehensive sensitive indicator parameters of various data types; x Indicates the number of time units that have passed; S ik Indicates i The data type k The sensitive indicator parameters corresponding to the unit time; λ k Indicates k The time importance weight value corresponding to the unit time is obtained by the following formula: in, λ k Indicates k The time importance weight value corresponding to the unit time; y Indicates the preset attenuation factor; Z represents the normalization constant; A k Indicates the preset number of adjustment time period groups, which includes one or more unit times.

7. The adaptive database encryption and backup recovery integrated system according to claim 5 is characterized in that: The encryption module comprises: A first encryption module, configured to randomly select a first encryption type to encrypt the data information with a low sensitivity level when the sensitivity level of each type of data information is low; wherein the first encryption type includes AES-128, DES, Triple DES and Blowfish; The second encryption module is used to randomly select a second encryption type to encrypt data information with a low sensitivity level when the sensitivity level of each type of data information is high; wherein the second encryption type includes AES-256, RSA-4096 and ECC.

8. The adaptive database encryption and backup recovery integrated system according to claim 5 is characterized in that: The storage scheme adjustment module includes: Frequency monitoring module, used to monitor the data update frequency corresponding to each data type in real time; A correlation value retrieving module is used to retrieve the correlation value between each data type and other data types; An importance evaluation parameter acquisition module, used to acquire the importance evaluation parameter corresponding to each data type by using the data update frequency corresponding to each data type and the correlation value between each data type and other data types; A second comparison module, used for comparing the importance evaluation parameter with a preset importance evaluation threshold; The storage scheme adjustment module is used to keep the data backup storage scheme unchanged when the importance evaluation parameter is lower than the preset importance evaluation threshold; when the importance evaluation parameter is not lower than the preset importance evaluation threshold, adjust the data backup frequency in the data backup storage scheme.

Citation Information

Patent Citations

  • Database backup encryption method and system

    CN114254338A

  • Power business evaluation method based on data fusion and edge calculation

    CN117195292A

  • File encryption method and device, computer equipment and storage medium

    CN118013557A

  • Teaching satisfaction sensitivity comprehensive identification method based on orthogonal theory

    CN118154038A

  • Internet-of-things data caching processing method

    CN118227673A