Classification management system and method for cloud database
By using the login authentication module, permission management module and other combinations in the classification management system of the cloud database, combined with the ID3 algorithm and linear regression algorithm, the system stuck problem caused by only one classification standard in the existing technology is solved, and multiple levels are achieved Classification management improves the stability of the system and query efficiency.
Patent Information
- Application Number
- CN202411162720.8
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-23
- Publication Date
- 2024-11-15
AI Technical Summary
The classification management system of the existing cloud database only has one classification standard, which leads to the problem of system stuck when the classification volume is too large.
The combination of login authentication module, permission management module, data collection module, data analysis module, storage and search module, synchronization backup module and monitoring and diversion module is adopted, and multiple classification management is carried out through the ID3 algorithm and linear regression algorithm to monitor and process the classification workload. Prevent the system from getting stuck.
It effectively improves the system's query efficiency and stability, and avoids the system from being stuck due to excessive classification through multiple classification standards, which enhances the system's security and query efficiency.
Smart Images

Figure CN118965077A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of cloud database classification management system and method, and specifically to a cloud database classification management system and method. Background Art
[0002] With the development of information technology and the influence of computer popularization, digital data storage technology has long replaced the traditional paper recording method, and with the rapid development of network technology, the speed of network upload and download has been significantly improved. Therefore, the cloud technology developed accordingly can provide users with the ability to place the required backup file data in a database on the network space through a network platform, namely a cloud database, and manage the internal data through a classification management system. After searching, it is found that the classification management system in the prior art is typically such as a computer data classification management system and method disclosed in Publication No. CN1725210A, which includes: a structure module, a cluster module, a storage device, a management module and a user interface. It is mainly to generate a destination structure in the computer system with a structure module; and to generate a cluster sequence for the contained data corresponding to the node in the destination structure with a cluster module; and to perform a cluster action on the cluster sequence with a management module; and finally to store the data structure corresponding to the cluster sequence in a cluster sequence file; and the user interface responds to the user action and displays the processing result. Its main feature is that it allows clusters to be directly and arbitrarily merged or separated with each other or with parts of clusters within a cluster, and can classify and manage any type of computer data more quickly and flexibly.
[0003] In summary, the existing classification management system only has one classification standard, that is, classifying the data content, and it is easy for the system to get stuck when the classification amount is too large. In view of the above problems, the existing equipment needs to be improved. Summary of the invention
[0004] The purpose of the present invention is to provide a classification management system and method for a cloud database to solve the problem that the existing classification management system proposed in the above background technology has only one classification standard, that is, classifying the data content, and is prone to system jamming when the classification amount is too large.
[0005] To achieve the above object, the present invention provides the following technical solution: a classification management system for a cloud database, comprising:
[0006] A login authentication module, which is used to identify the user's identity, that is, to set a threshold for accessing the data in the cloud database;
[0007] A rights management module, which is used to classify the scope of users' access within the system;
[0008] A data collection module, in which a user collects data loaded into a cloud database, and the collected data is uploaded to the system after being tested by a self-checking and stamping module;
[0009] A data analysis module, which is used to analyze the data uploaded by the data acquisition module, classify and save the data to the storage and search module, and the data stored in the storage and search module are synchronously updated to the synchronization backup module;
[0010] The monitoring and diversion module is used to monitor the classification processing volume inside the storage search module, and select whether to trigger the synchronous backup module to perform classification processing according to the detection result.
[0011] Preferably, the authority management module also includes a super-authority application function, that is, an auxiliary function when a user queries information that is not within the user's authority.
[0012] Preferably, the data analysis module classifies data by a classification algorithm, and the classification algorithm includes an ID3 algorithm and a linear regression algorithm, and the ID3 algorithm formula is:
[0013]
[0014] Among them, S is the current data set used to calculate entropy, X is the set of classes, and p(x) is the ratio of the number of elements in the class to the total number of elements in the set.
[0015] Preferably, in the ID3 algorithm, when H(S)=0, the set is a completely separable set, that is, all elements of the set S are of the same class, and in the ID3 algorithm, the entropy of each remaining attribute is calculated.
[0016] Preferably, the data classified by the ID3 algorithm is stored inside the storage search module, and the data classified by the linear regression algorithm is stored inside the synchronization backup module. At the same time, a corresponding number of storage areas are set inside the synchronization backup module and the storage search module.
[0017] Preferably, the triggering of the linear regression algorithm is based on the detection results of the monitoring diversion module, and the linear regression algorithm is always performed at the same time as the ID3 algorithm.
[0018] Preferably, the calculation formula of the linear regression algorithm is:
[0019] y=b0+b1x
[0020] Where y is the dependent variable whose value we want to predict, x is the independent variable whose value is used to predict the dependent variable, b0 and b1 are constants, while b0 is the Y-intercept and b1 is the slope.
[0021] Preferably, the understanding logic of the linear regression algorithm y=b0+b1x is: by finding the values of b0 and b1, to find the best fitting line that will cover or be closest to most data points, and thereby select the preference and the optimal understanding result.
[0022] Preferably, the self-checking and stamping module is used to detect whether the information collected by the data collection module contains viruses, and stops its uploading behavior when a virus is detected. Otherwise, it uploads and stamps the uploaded data with a timestamp, which includes the uploader, upload time and upload location.
[0023] Preferably, a classification management method for a cloud database, which is applied to the classification management system of the above-mentioned cloud database, comprises the following steps:
[0024] S1. The user logs into the system through the login authentication module, and then uploads the data to be classified through the data collection module. At the same time, the self-checking and stamping module performs a security check on the uploaded data. After the check result is safe, the data is uploaded and the uploaded data is stamped with a timestamp. Otherwise, the uploading behavior is terminated;
[0025] S2, the data analysis module analyzes the uploaded data and classifies it through the ID3 algorithm. The processed data is classified and stored in different storage areas inside the storage search module, and the classified data is automatically updated to the synchronization backup module;
[0026] S3, the monitoring and diversion module monitors the classification workload of the ID3 algorithm. When it exceeds the set value, the monitoring and diversion module synchronously classifies the data through the linear regression algorithm, and stores the classified data in different storage areas inside the synchronization backup module, and similarly backs up the data to the storage search module;
[0027] S4. The user searches for information in the system through the storage search module. When the information exceeds the authority of the login identity in the login authentication module, the user applies for authority to the system management through the authority management module. After the application is approved, additional access authority can be obtained.
[0028] Compared with the prior art, the beneficial effects of the present invention are: the classification management system and method of the cloud database,
[0029] The present invention can effectively solve the problem that the existing classification management system has only one classification standard, that is, classifying the data content, and is prone to system jamming when the classification amount is too large, through the coordinated use of the authority management module, the data analysis module, the storage search module, the synchronous backup module and the monitoring and diversion module. The scope that users can consult is classified through the authority management module, thereby improving the security of the system. The data is classified and managed through the data analysis module, thereby improving the query efficiency of the system. At the same time, two classification algorithms and classification storage spaces are set in the data analysis module. The data analysis module analyzes the uploaded data and classifies it through the ID3 algorithm. The processed data is classified and stored in different storage areas inside the storage search module, and the classified data is automatically updated to the synchronous backup module. When the monitoring and diversion module monitors the classification workload of the ID3 algorithm, when it exceeds the set value, the monitoring and diversion module synchronously classifies the data through the linear regression algorithm, and stores the classified data in different storage areas inside the synchronous backup module. Similarly, it is backed up inside the storage search module, thereby preventing the system from being jammed due to excessive classification volume, thereby improving the stability of the system. BRIEF DESCRIPTION OF THE DRAWINGS
[0030] Figure 1 It is a schematic diagram of the system structure of the present invention;
[0031] Figure 2 This is a schematic diagram of the internal structure of the data analysis module of the present invention;
[0032] Figure 3 It is a schematic diagram of the internal control flow of the self-checking and stamping module of the present invention;
[0033] Figure 4 Schematic diagram of the workflow of the monitoring diversion module of the present invention.
[0034] In the figure: 1. Login authentication module; 2. Authority management module; 3. Data collection module; 4. Data analysis module; 5. Storage search module; 6. Synchronous backup module; 7. Monitoring and diversion module; 8. Self-checking and stamping module. DETAILED DESCRIPTION
[0035] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.
[0036] See also Figure 1-4 The present invention provides a technical solution: a classification management system for a cloud database, comprising:
[0037] Login authentication module 1, which is used to identify the user's identity, that is, to set a threshold for accessing the data in the cloud database;
[0038] The authority management module 2 is used to classify the scope of users' access within the system;
[0039] Data collection module 3, the user of data collection module 3 collects the data loaded into the cloud database, and the collected data is uploaded to the system after being tested by the self-checking and stamping module 8;
[0040] The self-checking and stamping module 8 detects virus algorithms in the following ways: characteristic code method, checksum method, behavior monitoring method and software simulation method.
[0041] In a further embodiment, the self-checking and stamping module 8 is used to detect whether there is a virus in the information collected by the data collection module 3, and stop its uploading behavior when a virus is detected. Otherwise, it will upload and stamp a timestamp on the uploaded data. The timestamp includes the uploader, upload time and upload location. When the authenticity of the data needs to be checked, its source can be checked through the timestamp, that is, the data can be traced back through the timestamp to ensure the authenticity of the data.
[0042] The data analysis module 4 is used to analyze the data uploaded by the data collection module 3, and save the data into the storage and search module 5 according to the classification. The data stored in the storage and search module 5 are synchronously updated to the synchronization backup module 6.
[0043] In a further embodiment, the data analysis module 4 classifies data using a classification algorithm, and the classification algorithm includes an ID3 algorithm and a linear regression algorithm. The formula of the ID3 algorithm is:
[0044]
[0045] Among them, S is the current data set used to calculate entropy, X is the set of classes, and p(x) is the ratio of the number of elements in the class to the total number of elements in the set.
[0046] In a further embodiment, in the ID3 algorithm, when H(S)=0, the set is a completely separable set, that is, all elements of the set S are of the same class, and in the ID3 algorithm, the entropy of each remaining attribute is calculated.
[0047] In a further embodiment, the data classified by the ID3 algorithm is stored inside the storage search module 5, and the data classified by the linear regression algorithm is stored inside the synchronization backup module 6. At the same time, a corresponding number of storage areas are set inside the synchronization backup module 6 and the storage search module 5.
[0048] In a further embodiment, the triggering of the linear regression algorithm is based on the detection result of the monitoring and diversion module 7, and the linear regression algorithm is always performed at the same time as the ID3 algorithm.
[0049] In a further embodiment, the calculation formula of the linear regression algorithm is:
[0050] y=b0+b1x
[0051] Where y is the dependent variable whose value we want to predict, x is the independent variable whose value is used to predict the dependent variable, b0 and b1 are constants, while b0 is the Y-intercept and b1 is the slope.
[0052] In a further embodiment, the understanding logic of the linear regression algorithm y=b0+b1x is: by finding the values of b0 and b1 to find the best fit line that will cover or be closest to most data points, and thereby select the preference and the optimal understanding result.
[0053] The monitoring and diversion module 7 is used to monitor the classification processing volume inside the storage search module 5, and select whether to trigger the synchronous backup module 6 to perform classification processing according to the detection result.
[0054] The authority management module 2 also includes a super-authority application function, that is, an auxiliary function when a user searches for information that is not within the user's authority.
[0055] Embodiment 2
[0056] This embodiment is a further description of the above embodiment. It should be understood that this embodiment includes all the aforementioned technical features and is further described in detail.
[0057] In a further embodiment, a classification management method for a cloud database, which is applied to the classification management system of the above-mentioned cloud database, comprises the following steps:
[0058] S1. The user logs into the system through the login authentication module 1, and then uploads the data to be classified through the data collection module 3. At the same time, the self-checking and stamping module 8 performs a security check on the uploaded data. After the check result is safe, the data is uploaded and a timestamp is added to the uploaded data. Otherwise, the uploading behavior is terminated;
[0059] S2, the data analysis module 4 analyzes the uploaded data and classifies it through the ID3 algorithm. The processed data is classified and stored in different storage areas inside the storage search module 5, and the classified data is automatically updated to the synchronization backup module 6;
[0060] S3, the monitoring and diversion module 7 monitors the classification workload of the ID3 algorithm. When it exceeds the set value, the monitoring and diversion module 7 synchronously classifies the data through the linear regression algorithm, and stores the classified data in different storage areas inside the synchronization backup module 6, and similarly backs up the data to the storage search module 5;
[0061] S4. The user searches for information in the system through the storage search module 5. When the information exceeds the authority of the login identity of the login authentication module 1, the user applies for authority to the system management through the authority management module 2. After the application is approved, the user can obtain additional access authority.
[0062] Although the present invention has been described in detail with reference to the aforementioned embodiments, it is still possible for those skilled in the art to modify the technical solutions described in the aforementioned embodiments, or to make equivalent substitutions for some of the technical features therein. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the present invention should be included in the protection scope of the present invention.
Claims
1. A classification management system for a cloud database, characterized in that: include: A login authentication module (1), the login authentication module (1) is used to identify the identity of the user, that is, to set a threshold for accessing the data in the cloud database; A rights management module (2), the rights management module (2) being used to classify the scope of a user's access within the system; A data collection module (3), wherein the user of the data collection module (3) collects data loaded into the cloud database, and the collected data is uploaded to the system after being checked by the self-checking and stamping module (8); A data analysis module (4), the data analysis module (4) is used to analyze the data uploaded by the data acquisition module (3), classify and save the data to the storage and search module (5), and the data stored in the storage and search module (5) is synchronously updated to the synchronous backup module (6); A monitoring and diversion module (7) is used to monitor the classification processing volume inside the storage search module (5), and to select whether to trigger the synchronous backup module (6) to perform classification processing according to the detection result.
2. A classification management system for a cloud database according to claim 1, characterized in that: The authority management module (2) also includes a super-authority application function, that is, an auxiliary function when a user queries information that is not within the user's authority.
3. The classification management system of a cloud database according to claim 1, characterized in that: The data analysis module (4) classifies data using a classification algorithm, and the classification algorithm includes an ID3 algorithm and a linear regression algorithm. The formula of the ID3 algorithm is: Among them, S is the current data set used to calculate entropy, X is the set of classes, and p(x) is the ratio of the number of elements in the class to the total number of elements in the set.
4. The classification management system of a cloud database according to claim 1, characterized in that: In the ID3 algorithm, when H(S)=0, the set is a completely separable set, that is, all elements of the set S are of the same class. In the ID3 algorithm, the entropy of each remaining attribute is calculated.
5. The classification management system of a cloud database according to claim 1, characterized in that: The data classified by the ID3 algorithm is stored in the storage search module (5), while the data classified by the linear regression algorithm is stored in the synchronization backup module (6). Meanwhile, a corresponding number of storage areas are provided in the synchronization backup module (6) and the storage search module (5).
6. The classification management system of a cloud database according to claim 3, characterized in that: The triggering of the linear regression algorithm is based on the detection result of the monitoring diversion module (7), and the linear regression algorithm is always performed at the same time as the ID3 algorithm.
7. The classification management system of a cloud database according to claim 3, characterized in that: The calculation formula of the linear regression algorithm is: y=b0+b1x Where y is the dependent variable whose value we want to predict, x is the independent variable whose value is used to predict the dependent variable, b0 and b1 are constants, while b0 is the Y-intercept and b1 is the slope.
8. The classification management system of a cloud database according to claim 3, characterized in that: The understanding logic of the linear regression algorithm y=b0+b1x is: by finding the values of b0 and b1, the best fitting line that will cover or be closest to most data points is found, and the preference and optimal understanding result are selected accordingly.
9. The classification management system of a cloud database according to claim 1, characterized in that: The self-checking and stamping module (8) is used to detect whether the information collected by the data collection module (3) contains viruses, and stops uploading when a virus is detected. Otherwise, it uploads and stamps the uploaded data with a timestamp, which includes the uploader, upload time and upload location.
10. A classification management method for a cloud database, applied to a classification management system for a cloud database according to any one of claims 1 to 9, characterized in that: The following steps are involved: S1. The user logs into the system through the login authentication module (1), and then uploads the data to be classified through the data collection module (3). At the same time, the self-checking and stamping module (8) performs a security check on the uploaded data. After the check result is safe, the data is uploaded and a timestamp is added to the uploaded data. Otherwise, the uploading behavior is terminated; S2, the data analysis module (4) analyzes the uploaded data and classifies it using the ID3 algorithm. The processed data is classified and stored in different storage areas inside the storage search module (5), and the classified data is automatically updated to the synchronization backup module (6); S3, the monitoring and diversion module (7) monitors the classification workload of the ID3 algorithm. When the workload exceeds the set value, the monitoring and diversion module (7) synchronously classifies the data through the linear regression algorithm, and stores the classified data in different storage areas inside the synchronous backup module (6), and similarly backs up the data to the storage search module (5); S4. The user searches for information in the system through the storage search module (5). When the information exceeds the authority of the login identity of the login authentication module (1), the user applies for authority to the system management through the authority management module (2). After the application is approved, the user can obtain additional access authority.
