Database management method, device and system and storage medium and device

A management method and database technology, applied in database design/maintenance, electronic digital data processing, special data processing applications, etc., can solve problems such as customer inconvenience, customers' inability to access databases and business terminals normally, and service quality of service providers. , to achieve the effect of quickly solving and guaranteeing business needs

Inactive Publication Date: 2017-10-13
UCLOUD TECH CO LTD
View PDF3 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, this method has obvious disadvantages
Specifically, during the restart of the database, customers will not be able to access the database and business terminals normally, which will cause a lot of inconvenience to customers and affect the service quality of service providers

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Database management method, device and system and storage medium and device
  • Database management method, device and system and storage medium and device
  • Database management method, device and system and storage medium and device

Examples

Experimental program
Comparison scheme
Effect test

no. 1 example

[0028] The following will combine figure 1 The database management method 100 according to the embodiment of the present invention is described in detail.

[0029] figure 1 is a flowchart of the database management method 100 according to the embodiment of the present invention. Such as figure 1 As shown, in step S101, the target data file stored in the target database is backed up to the temporary database to generate a temporary backup.

[0030]According to the embodiment of the present invention, the temporary database can be set on the physical machine of the target database or on other physical machines. Physical machines include, but are not limited to: microcomputers, minicomputers, mid-range computers, mainframes, supercomputers or other physical devices capable of running databases. When the temporary database and the target database are on the same physical machine, the user table that needs to be reset in the target database can be directly copied to the tempora...

no. 2 example

[0041] Although the execution speed of the database management method 100 of the present invention is relatively fast, and the probability of the user actively changing the user table is relatively low, but during the execution of the method 100, the user operates the user table, making the user table Situations where data has changed.

[0042] figure 2 is a flow chart of the database management method 200 according to the embodiment of the present invention.

[0043] Such as figure 2 As shown, in method 200, steps S202, S203, and S206 are respectively the same as steps S101, S102, and S103 of method 100, and for brevity, detailed descriptions are omitted here.

[0044] In step S201, a first check code is generated for the target data file.

[0045] As an example, an algorithm that can realize data integrity verification, such as a hash function, can be used to calculate the user table in the target database that needs to be reset, and correspondingly generate a check cod...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses a database management method, device and system and a storage medium and a device. The method includes the steps of backup generation, wherein a target data file stored in a target database is backed up to a temporary database to generate a temporary backup; resetting, wherein in the temporary database, a password and/or permissions of a user in the temporary backup are reset; replacement, wherein the target data file is replaced by the temporary backup in the temporary database. The method further comprises the steps of first generation before the backup generation, wherein a first check code is generated for the target data file; second generation after resetting and before the replacement, wherein a second check code is generated for the target data file; judgement, wherein whether or not the first check code is the same as the second check code is judged, and if not, the steps from first generation to judgement are performed again; if the first check code is the same as the second check code, the replacement step is performed.

Description

technical field [0001] The invention relates to a database management method, device, system, storage medium and equipment. Background technique [0002] In the cloud field or other database hosting fields, third-party maintenance users such as cloud service providers and hosting service providers (hereinafter referred to as "maintenance parties") are required to perform routine maintenance on the customer's database, such as backup and monitoring. Therefore, when the maintainer establishes a database for the client, an administrator user will be reserved in the database, so that the administrator user can be used to maintain the client's database later. [0003] During the use of the database, in some cases, when the customer operates the database or imports data, the password and / or authority of the administrator user reserved by the maintainer in the database user table will be changed, resulting in the maintainer being unable to log in to the database. Usually, for thos...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F11/14G06F17/30
CPCG06F11/1466G06F16/21G06F2201/80
Inventor 宋志强
Owner UCLOUD TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap