CN110333968B - Data management method, device and computer equipment applied to database - Google Patents

Abstract

The present invention provides a data management method, device and computer equipment applied to a database, wherein the data management method applied to the database comprises: obtaining a data backup request for the data to be backed up in the main database; based on the data backup request, Obtain backup feature information; determine the backup quantity and backup time of the data to be backed up according to the backup feature information; when it is detected that the current time reaches the backup time, back up the data to be backed up according to the backup quantity , and stored in the backup database. Through the technical scheme of the present invention, the data in the database can be effectively managed, and the data security can be improved.

Description

Data management method, device and computer equipment applied to database

technical field

The present invention relates to the field of computer technology, and in particular, to a data management method applied to a database, a data management device applied to a database, and a computer device.

Background technique

With the rise of network and mobile applications, the amount of data has increased geometrically compared to the past, and more and more data needs to be stored, followed by the rapid development of database technology. A database is a warehouse built on a computer storage device based on database technology, and organizes, stores and manages data according to the data structure. Due to the large amount of data stored in the database, once the data is abnormal, it will bring all kinds of troubles, so the security of the data is also getting more and more attention, which makes it an urgent need to effectively manage the data in the database to improve the security of the data technical problems solved.

SUMMARY OF THE INVENTION

Based on at least one of the above technical problems, the present invention proposes a new data management scheme applied to the database, which can effectively manage the data in the database and improve data security.

In view of this, the present invention proposes a new data management method applied to a database, including: obtaining a data backup request for the data to be backed up in the main database; obtaining backup feature information based on the data backup request; Backup feature information to determine the backup quantity and backup time of the data to be backed up; when it is detected that the current time reaches the backup time, the data to be backed up is backed up according to the backup quantity and stored in a backup database.

In this technical solution, data security is ensured by timely and effective backup of the data in the main database. Specifically, the backup feature information is obtained according to the data backup request of the data to be backed up, and the required data is determined according to the backup feature information. The number of backups and the backup time are stored in the backup database according to the backup time and the number of backups, so that when the data in the main database is abnormal, the backup data can be called in time for recovery, thus forming an effective management of the data in the database and improving data security. sex.

In the above technical solution, preferably, the step of obtaining backup feature information based on the data backup request specifically includes: extracting keywords from the data backup request; obtaining the data backup request within a predetermined time period The number of times of sending; the keyword and the number of times of sending are used as the backup feature information.

In any of the above technical solutions, preferably, the step of determining the backup quantity and backup time of the data to be backed up according to the backup feature information specifically includes: determining the data to be backed up according to the keyword. The importance level of the data; according to the relationship between the pre-stored importance level and the backup quantity, determine the backup quantity corresponding to the importance level of the data to be backed up, and use it as the backup quantity of the data to be backed up; obtain the data backup request the first sending time; according to the first sending time and the sending times, determine the backup demand level of the data to be backed up; according to the association between the pre-stored backup demand level and the backup time, determine the The backup time corresponding to the backup demand level of the data is taken as the backup time of the data to be backed up.

In any of the above technical solutions, preferably, before the step of backing up the data to be backed up according to the number of backups, the method further includes: counting whether the number of times the target backup data in the backup database is accessed is less than equal to the threshold, wherein the target backup data is backup data with a backup quantity greater than 1; when it is determined that the number of times the target backup data is accessed is less than or equal to the threshold, the backup quantity of the target backup data is cleaned up to 1 copy.

In this technical solution, when the number of times the target backup data is accessed is less than or equal to the threshold, it means that the probability of the target backup data being called is small, and there is no need to continue to store multiple copies, and the number of backups is cleaned up to 1 copy in time to ensure that the demand can be met. At the same time, the rational use of database storage resources is maximized.

According to a second aspect of the present invention, a data management device applied to a database is proposed, comprising: a first acquisition unit for acquiring a data backup request for data to be backed up in the main database; a second acquisition unit for The data backup request is to obtain backup feature information; the determination unit is used to determine the backup quantity and backup time of the data to be backed up according to the backup feature information; the backup unit is used to detect that the current time reaches the backup When the time is up, the data to be backed up is backed up according to the backup quantity, and stored in the backup database.

In this technical solution, data security is ensured by timely and effective backup of the data in the main database. Specifically, the backup feature information is obtained according to the data backup request of the data to be backed up, and the required data is determined according to the backup feature information. The number of backups and the backup time are stored in the backup database according to the backup time and the number of backups, so that when the data in the main database is abnormal, the backup data can be called in time for recovery, thus forming an effective management of the data in the database and improving data security. sex.

In the above technical solution, preferably, the second obtaining unit is specifically configured to: extract keywords from the data backup request; obtain the number of times the data backup request is sent within a predetermined time period; and the number of times of sending as the backup feature information.

In any of the above technical solutions, preferably, the determining unit is specifically configured to: determine the importance level of the data to be backed up according to the keyword; The backup quantity corresponding to the importance level of the data to be backed up is taken as the backup quantity of the data to be backed up; the first sending time of the data backup request is obtained; according to the first sending time and the sending times, determine the Describe the backup demand level of the data to be backed up; determine the backup time corresponding to the backup demand level of the data to be backed up according to the association between the pre-stored backup demand level and the backup time, and use it as the data to be backed up backup time.

In any of the above technical solutions, preferably, it further includes: a statistical unit, configured to count whether the number of times the target backup data in the backup database is accessed is less than or equal to a threshold, wherein the target backup data is that the number of backups is greater than 1 The cleaning unit is configured to, before the backup unit backs up the data to be backed up according to the number of backups, when it is determined that the number of times the target backup data is accessed is less than or equal to a threshold, the target backup data The number of backups is cleared to 1.

In this technical solution, when the number of times the target backup data is accessed is less than or equal to the threshold, it means that the probability of the target backup data being called is small, and there is no need to continue to store multiple copies, and the number of backups is cleaned up to 1 copy in time to ensure that the demand can be met. At the same time, the rational use of database storage resources is maximized.

According to a third aspect of the present invention, a computer device is provided, comprising: a processor; and a memory communicatively connected to the processor; wherein the memory stores readable instructions, the readable instructions being The processor implements the method described in any one of the foregoing technical solutions when executed.

According to a fourth aspect of the present invention, a computer-readable storage medium is provided, on which a computer program is stored, and when the computer program is executed, the method according to any one of the above technical solutions is implemented.

Through the above technical solutions, the data in the database can be effectively managed, and the data security can be improved.

Description of drawings

1 shows a schematic flowchart of a data management method applied to a database according to an embodiment of the present invention;

2 shows a schematic block diagram of a data management apparatus applied to a database according to an embodiment of the present invention;

Figure 3 shows a schematic block diagram of a computer device according to an embodiment of the present invention.

Detailed ways

In order to understand the above objects, features and advantages of the present invention more clearly, the present invention will be further described in detail below with reference to the accompanying drawings and specific embodiments. It should be noted that the embodiments of the present application and the features in the embodiments may be combined with each other in the case of no conflict.

Many specific details are set forth in the following description to facilitate a full understanding of the present invention. However, the present invention can also be implemented in other ways different from those described herein. Therefore, the protection scope of the present invention is not limited by the specific details disclosed below. Example limitations.

As shown in FIG. 1 , the data management method applied to a database according to an embodiment of the present invention specifically includes the following steps:

Step S102: Obtain a data backup request for the data to be backed up in the main database.

Step S104, based on the data backup request, obtain backup feature information.

Specifically, keywords are extracted from the data backup request and the number of times of sending the data backup request within a predetermined time period is obtained, and the keywords and the number of times of sending are used as backup feature information.

Step S106: Determine the backup quantity and backup time of the data to be backed up according to the backup feature information.

Specifically, according to the keywords, determine the importance level of the data to be backed up; according to the correlation between the pre-stored importance level and the number of backups, determine the number of backups corresponding to the importance level of the data to be backed up, and use it as the backup of the data to be backed up Obtain the first sending time of the data backup request; determine the backup demand level of the data to be backed up according to the first sending time and the number of sending times; The backup time corresponding to the backup demand level is used as the backup time of the data to be backed up.

Step S108, when it is detected that the current time reaches the backup time, the data to be backed up is backed up according to the number of backups, and stored in the backup database.

Further, before the step of backing up the backup data according to the number of backups, it also includes: whether the number of times the target backup data in the statistical backup database is accessed is less than or equal to a threshold, wherein the target backup data is the backup data whose backup quantity is greater than 1; When it is determined that the number of times the target backup data is accessed is less than or equal to the threshold, the number of backups of the target backup data is cleared to 1.

The data security is ensured by timely and effective backup of the data in the main database. Specifically, the backup feature information is obtained according to the data backup request of the data to be backed up, and the required backup quantity and backup time are determined according to the backup feature information. And it is stored in the backup database according to the backup time and backup quantity, so that when the data in the main database is abnormal, the backup data can be called in time for recovery, thus forming an effective management of the data in the database and improving the data security.

As shown in FIG. 2 , a data management apparatus 200 applied to a database according to an embodiment of the present invention includes a first obtaining unit 202 , a second obtaining unit 204 , a determining unit 206 and a backup unit 208 .

The first obtaining unit 202 is used to obtain a data backup request for the data to be backed up in the main database; the second obtaining unit 204 is used to obtain backup feature information based on the data backup request; the determining unit 206 is configured to determine the backup feature information according to the backup feature information. The backup quantity and backup time of the data to be backed up; the backup unit 208 is configured to back up the data to be backed up according to the backup quantity when it is detected that the current time reaches the backup time, and store it in the backup database.

Further, the second obtaining unit 204 is specifically configured to: extract keywords from the data backup request; obtain the number of times of sending the data backup request within a predetermined time period; and use the keywords and the times of sending as backup feature information.

Further, the determining unit 206 is specifically configured to: determine the importance level of the data to be backed up according to the keyword; determine the backup quantity corresponding to the importance level of the data to be backed up according to the pre-stored relationship between the importance level and the backup quantity, and set the data to be backed up. It serves as the backup quantity of the data to be backed up; obtains the first sending time of the data backup request; determines the backup demand level of the data to be backed up according to the first sending time and the number of sending times; according to the correlation between the pre-stored backup demand level and the backup time , determine the backup time corresponding to the backup demand level of the data to be backed up, and use it as the backup time of the data to be backed up.

Further, it also includes: a statistical unit 210, used to count whether the number of times the target backup data in the backup database is accessed is less than or equal to a threshold, wherein the target backup data is the backup data whose backup quantity is greater than 1; the cleaning unit 212 is used for Before the unit 208 backs up the data to be backed up according to the number of backups, if it is determined that the number of times the target backup data has been accessed is less than or equal to the threshold, the unit 208 cleans up the number of backups of the target backup data to 1 copy.

As shown in FIG. 3 , a computer device 300 according to an embodiment of the present invention includes: a memory 302 , a processor 304 and a communication bus 306 . Wherein, the memory 302 is configured to store executable instructions; the processor 304 is configured to execute the stored instructions to implement the steps of the method described in any of the above embodiments, and thus has all the technical effects of the data analysis method, which is not repeated here. Repeat.

Specifically, the memory 302 described above may include mass storage for data or instructions. By way of example and not limitation, memory 302 may include a Hard Disk Drive (HDD), a floppy disk drive, flash memory, optical disk, magneto-optical disk, magnetic tape, or Universal Serial Bus (USB) drive or two or more A combination of more than one of the above. Memory 302 may include removable or non-removable (or fixed) media, where appropriate. Storage 302 may be internal or external to the integrated gateway disaster recovery device, where appropriate. In certain embodiments, memory 302 is non-volatile solid state memory. In particular embodiments, memory 302 includes read only memory (ROM). Where appropriate, the ROM may be a mask programmed ROM, programmable ROM (PROM), erasable PROM (EPROM), electrically erasable PROM (EEPROM), electrically rewritable ROM (EAROM) or flash memory or A combination of two or more of the above. The processor 304 may include a central processing unit (CPU), or a specific integrated circuit (Application Specific Integrated Circuit, ASIC), or may be configured as one or more integrated circuits implementing embodiments of the present invention. The communication bus 306 is used to implement the connection communication between the signal processor 304 and the memory 302 . The communication bus 306 may be an Industry Standard Architecture (ISA) bus, a Peripheral Component Interconnect (PCI) bus, or an Extended Industry Standard Architecture (EISA) bus or the like. The bus can be divided into address bus, data bus, control bus and so on.

Embodiments of the fourth aspect of the present invention provide a computer-readable storage medium on which a computer program is stored, and when the computer program is executed by a processor, implements the steps of the method described in any of the above technical solutions, and thus has the data analysis method. All technical effects of the method will not be repeated here. Computer-readable storage media can include any medium that can store or transmit information. Examples of computer-readable storage media include electronic circuits, semiconductor memory devices, ROM, flash memory, erasable ROM (EROM), floppy disks, CD-ROMs, optical disks, hard disks, fiber optic media, radio frequency (RF) links, and the like. The code segments may be downloaded via a computer network such as the Internet, an intranet, or the like.

The technical solution of the present invention is described in detail above with reference to the accompanying drawings. The technical solution of the present invention proposes a new data management solution applied to a database, which can effectively manage data in the database and improve data security.

The above descriptions are only preferred embodiments of the present invention, and are not intended to limit the present invention. For those skilled in the art, the present invention may have various modifications and changes. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention shall be included within the protection scope of the present invention.

Claims (6)

1. A data management method applied to a database is characterized by comprising the following steps:

acquiring a data backup request for data to be backed up in a main database;

acquiring backup characteristic information based on the data backup request;

determining the backup quantity and the backup time of the data to be backed up according to the backup characteristic information;

when the current time reaches the backup time, backing up the data to be backed up according to the backup quantity and storing the data to be backed up in a backup database; the step of obtaining backup characteristic information based on the data backup request specifically includes:

extracting key words from the data backup request;

acquiring the sending times of the data backup request in a preset time period;

taking the keywords and the sending times as the backup characteristic information;

the step of determining the backup quantity and the backup time of the data to be backed up specifically includes:

determining the importance level of the data to be backed up according to the keywords;

determining the backup quantity corresponding to the importance level of the data to be backed up according to the incidence relation between the pre-stored importance level and the backup quantity, and taking the backup quantity as the backup quantity of the data to be backed up;

acquiring the first sending time of the data backup request;

determining the backup requirement level of the data to be backed up according to the first sending time and the sending times;

and determining the backup time corresponding to the backup demand level of the data to be backed up according to the association relation between the pre-stored backup demand level and the backup time, and taking the backup time as the backup time of the data to be backed up.

2. The data management method applied to a database according to claim 1, wherein before the step of backing up the data to be backed up according to the backup number, the method further comprises:

counting whether the number of times of accessing target backup data in the backup database is less than or equal to a threshold value, wherein the target backup data is backup data with the backup number greater than 1;

and cleaning the backup number of the target backup data to 1 when the number of times of accessing the target backup data is determined to be less than or equal to a threshold value.

3. A data management apparatus applied to a database, comprising:

the first acquisition unit is used for acquiring a data backup request for data to be backed up in the main database;

a second obtaining unit, configured to obtain backup feature information based on the data backup request;

the determining unit is used for determining the backup quantity and the backup time of the data to be backed up according to the backup characteristic information;

the backup unit is used for backing up the data to be backed up according to the backup quantity and storing the data to be backed up into a backup database when the current time is detected to reach the backup time; the second obtaining unit is specifically configured to:

extracting key words from the data backup request;

acquiring the sending times of the data backup request in a preset time period;

taking the keywords and the sending times as the backup characteristic information;

the determining unit is specifically configured to:

determining the importance level of the data to be backed up according to the keywords;

determining the backup quantity corresponding to the importance level of the data to be backed up according to the incidence relation between the pre-stored importance level and the backup quantity, and taking the backup quantity as the backup quantity of the data to be backed up;

acquiring the first sending time of the data backup request;

determining the backup requirement level of the data to be backed up according to the first sending time and the sending times;

and determining the backup time corresponding to the backup demand level of the data to be backed up according to the association relation between the pre-stored backup demand level and the backup time, and taking the backup time as the backup time of the data to be backed up.

4. The data management device applied to the database according to claim 3, further comprising:

the statistical unit is used for counting whether the number of times of accessing target backup data in the backup database is less than or equal to a threshold value, wherein the target backup data is backup data with the backup quantity greater than 1;

and the cleaning unit is used for cleaning the backup number of the target backup data to 1 part if the number of times of accessing the target backup data is determined to be less than or equal to a threshold value before the backup unit backs up the data to be backed up according to the backup number.

5. A computer device, comprising:

a processor; and

a memory communicatively coupled to the processor;

wherein the memory stores readable instructions which, when executed by the processor, implement the method of claim 1 or 2.

6. A computer-readable storage medium, on which a computer program is stored, which, when being executed, carries out the method according to claim 1 or 2.

Images