CN117290333A - Method and device for remotely maintaining database through client - Google Patents
Method and device for remotely maintaining database through client Download PDFInfo
- Publication number
- CN117290333A CN117290333A CN202311244346.1A CN202311244346A CN117290333A CN 117290333 A CN117290333 A CN 117290333A CN 202311244346 A CN202311244346 A CN 202311244346A CN 117290333 A CN117290333 A CN 117290333A
- Authority
- CN
- China
- Prior art keywords
- database
- intermediate node
- maintenance
- node
- client
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 53
- 238000012423 maintenance Methods 0.000 claims abstract description 305
- 238000012545 processing Methods 0.000 claims abstract description 50
- 238000004590 computer program Methods 0.000 claims description 19
- 238000000605 extraction Methods 0.000 claims description 16
- 238000007726 management method Methods 0.000 description 9
- 230000008569 process Effects 0.000 description 8
- 230000000007 visual effect Effects 0.000 description 7
- 238000013459 approach Methods 0.000 description 5
- 238000004891 communication Methods 0.000 description 5
- 238000010586 diagram Methods 0.000 description 5
- 238000004458 analytical method Methods 0.000 description 4
- 238000005516 engineering process Methods 0.000 description 3
- 230000004044 response Effects 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 2
- 230000008859 change Effects 0.000 description 2
- 238000013500 data storage Methods 0.000 description 2
- 238000012544 monitoring process Methods 0.000 description 2
- 238000013515 script Methods 0.000 description 2
- 230000003068 static effect Effects 0.000 description 2
- 238000012546 transfer Methods 0.000 description 2
- OKTJSMMVPCPJKN-UHFFFAOYSA-N Carbon Chemical compound [C] OKTJSMMVPCPJKN-UHFFFAOYSA-N 0.000 description 1
- 230000001413 cellular effect Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 229910021389 graphene Inorganic materials 0.000 description 1
- 238000003384 imaging method Methods 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 230000008439 repair process Effects 0.000 description 1
- 238000012216 screening Methods 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
- G06F21/6218—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/46—Multiprogramming arrangements
- G06F9/54—Interprogram communication
- G06F9/547—Remote procedure calls [RPC]; Web services
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Health & Medical Sciences (AREA)
- Bioethics (AREA)
- General Health & Medical Sciences (AREA)
- Computer Hardware Design (AREA)
- Computer Security & Cryptography (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The application relates to the technical field of databases, and relates to a method and a device for remotely maintaining a database through a client. The method comprises the following steps: acquiring database maintenance items to be uploaded, and analyzing processing nodes for acquiring the database maintenance items, wherein the processing nodes comprise a first administrator node and a first intermediate node; if the database maintenance item is in the first intermediate node, acquiring relevant historical data of uploading the database maintenance item to the first manager node through the first intermediate node; acquiring the historical uploading efficiency of the first intermediate node according to the related historical data; and if the historical uploading efficiency is lower than a preset efficiency threshold, distributing maintenance authority to the client of the first intermediate node, wherein the maintenance authority is used for allowing the database to be maintained remotely through the client of the first intermediate node. By adopting the method, related personnel of the central node can directly carry out maintenance operation on the client, thereby improving the efficiency of maintaining the database.
Description
Technical Field
The present disclosure relates to the field of database technologies, and in particular, to a method and an apparatus for remotely maintaining a database through a client.
Background
Database maintenance is an important work for ensuring the normal operation of a database, but most of the current database maintenance work is operated by a designated database manager node through a central server, and when related personnel of the central node need to maintain the database, the planned maintenance items need to be uploaded to the database manager node, and the database manager uniformly maintains the database through the central server according to the maintenance items. However, in this process, it is easy for the database administrator to quickly and accurately understand the key content of the maintenance items uploaded by the related personnel of the central node, resulting in a case of low efficiency.
Therefore, a method and apparatus for remotely maintaining a database through a client are needed to solve the problem that the database manager cannot quickly and accurately understand the key content of the maintenance items uploaded by the related personnel of the central node, resulting in low efficiency.
Disclosure of Invention
Based on the foregoing, it is necessary to provide a method and a device for remotely maintaining a database through a client, which can solve the problem that a database manager cannot quickly and accurately understand the key content of maintenance items uploaded by related personnel of a central node, resulting in low efficiency.
In a first aspect, the present application provides a method for remotely maintaining a database by a client. The method comprises the following steps:
acquiring database maintenance items to be uploaded, and analyzing processing nodes for acquiring the database maintenance items, wherein the processing nodes comprise a first administrator node and a first intermediate node;
if the database maintenance item is in a first intermediate node, acquiring relevant historical data of uploading the database maintenance item to the first manager node through the first intermediate node;
acquiring the historical uploading efficiency of the first intermediate node according to the related historical data;
and if the historical uploading efficiency is lower than a preset efficiency threshold, distributing maintenance authority to the client of the first intermediate node, wherein the maintenance authority is used for allowing the database to be maintained remotely through the client of the first intermediate node.
In one embodiment, the assigning maintenance rights to the client of the first intermediate node includes:
acquiring address information of all intermediate nodes in the area, and inquiring and acquiring serial numbers corresponding to the address information of all intermediate nodes in a preset control association table;
if the serial number corresponding to the address information of the intermediate node is not the end serial number, sending an instruction for distributing maintenance permission to the intermediate node positioned at the end serial number;
And forwarding the maintenance authority allocation instruction to an adjacent intermediate node by the intermediate node positioned at the end sequence number, so that the adjacent intermediate node continuously forwards the maintenance authority allocation instruction backwards according to the sequence number sequence until the maintenance authority allocation instruction is sent to the client side of the first intermediate node.
In one embodiment, the method further comprises:
acquiring historical maintenance times of remotely maintaining a database through a client of the first intermediate node;
and if the maintenance times are greater than a preset times threshold, and the difference value between the serial number of the first intermediate node and the serial number of the end part is smaller than a preset difference value threshold, the first intermediate node is used as a second manager node, wherein the second manager node and the first manager node are used for jointly acquiring database maintenance matters uploaded by other intermediate nodes except the first intermediate node.
In one embodiment, after the first intermediate node is used as the second manager node, the method includes:
acquiring database maintenance items uploaded by other intermediate nodes forwarded by the second manager node, and acquiring identity data of the other intermediate nodes;
Judging whether the identity data is legal data or not according to the identity data of the other intermediate nodes;
and if the identity data is legal data, sending a first execution instruction to the second manager node, wherein the first execution instruction is used for reminding the second manager node to execute the database maintenance items uploaded by the other intermediate nodes so as to maintain the database.
In one embodiment, after the obtaining the database maintenance items uploaded by the other intermediate nodes forwarded by the second administrator node and obtaining the identity data of the other intermediate nodes, the method further includes:
uploading database maintenance items uploaded by other intermediate nodes forwarded by the second manager node, and identity data of the other intermediate nodes to a blockchain network;
acquiring the extraction application information of the identity data and/or the extraction application information of the database maintenance items sent by the client of any one of the other intermediate nodes;
judging whether the client of any intermediate node is a target client or not according to the extraction application information of the identity data and/or the extraction application information of the database maintenance items;
If yes, dispatching the identity data and/or database maintenance items to the client of any intermediate node;
and acquiring the scheduling record of the identity data and/or the database maintenance matters, and uploading the scheduling record to a blockchain network.
In one embodiment, after the assigning of the maintenance authority to the client of the first intermediate node, the method further includes:
acquiring database maintenance items uploaded by a client of the first intermediate node, and listing the database maintenance items in a sharing operation folder, wherein the sharing operation folder is used for the first manager node to operate;
traversing each database maintenance item in the shared operation folder according to a preset distributed timing task, and acquiring the file content of each database maintenance item;
and sending a second execution instruction to the client of the first intermediate node according to the file content of each database maintenance item, wherein the first execution instruction is used for reminding the client of the first intermediate node of executing the database maintenance item so as to maintain the database.
In one embodiment, after the sending the second execution instruction to the client of the first intermediate node, the method includes:
And acquiring relevant historical data of each database maintenance item executed by the first intermediate node, and visually displaying the relevant historical data.
In a second aspect, the present application also provides an apparatus for remotely maintaining a database through a client. The device comprises:
the acquisition module is used for acquiring database maintenance items to be uploaded;
the processing module is used for analyzing and obtaining processing nodes of the database maintenance items, and the processing nodes comprise a first manager node and a first intermediate node;
the acquisition module is further used for acquiring relevant historical data of the database maintenance items uploaded to the first manager node through the first intermediate node if the database maintenance items are in the first intermediate node;
the processing module is further used for acquiring the history uploading efficiency of the first intermediate node according to the related history data;
and the permission distribution module is used for distributing maintenance permission to the client of the first intermediate node if the historical uploading efficiency is lower than a preset efficiency threshold, wherein the maintenance permission is used for allowing the remote maintenance of the database through the client of the first intermediate node.
In a third aspect, the present application also provides a computer device. The computer device comprises a memory storing a computer program and a processor which when executing the computer program performs the steps of:
Acquiring database maintenance items to be uploaded, and analyzing processing nodes for acquiring the database maintenance items, wherein the processing nodes comprise a first administrator node and a first intermediate node;
if the database maintenance item is in a first intermediate node, acquiring relevant historical data of uploading the database maintenance item to the first manager node through the first intermediate node;
acquiring the historical uploading efficiency of the first intermediate node according to the related historical data;
and if the historical uploading efficiency is lower than a preset efficiency threshold, distributing maintenance authority to the client of the first intermediate node, wherein the maintenance authority is used for allowing the database to be maintained remotely through the client of the first intermediate node.
In a fourth aspect, the present application also provides a computer-readable storage medium. The computer readable storage medium having stored thereon a computer program which when executed by a processor performs the steps of:
acquiring database maintenance items to be uploaded, and analyzing processing nodes for acquiring the database maintenance items, wherein the processing nodes comprise a first administrator node and a first intermediate node;
If the database maintenance item is in a first intermediate node, acquiring relevant historical data of uploading the database maintenance item to the first manager node through the first intermediate node;
acquiring the historical uploading efficiency of the first intermediate node according to the related historical data;
and if the historical uploading efficiency is lower than a preset efficiency threshold, distributing maintenance authority to the client of the first intermediate node, wherein the maintenance authority is used for allowing the database to be maintained remotely through the client of the first intermediate node.
In a fifth aspect, the present application also provides a computer program product. The computer program product comprises a computer program which, when executed by a processor, implements the steps of:
acquiring database maintenance items to be uploaded, and analyzing processing nodes for acquiring the database maintenance items, wherein the processing nodes comprise a first administrator node and a first intermediate node;
if the database maintenance item is in a first intermediate node, acquiring relevant historical data of uploading the database maintenance item to the first manager node through the first intermediate node;
acquiring the historical uploading efficiency of the first intermediate node according to the related historical data;
And if the historical uploading efficiency is lower than a preset efficiency threshold, distributing maintenance authority to the client of the first intermediate node, wherein the maintenance authority is used for allowing the database to be maintained remotely through the client of the first intermediate node.
The method and the device for remotely maintaining the database through the client end comprise a first manager node and a first intermediate node through processing nodes for analyzing database maintenance matters. If the database maintenance event is at the first intermediate node, relevant history data uploaded to the first administrator node by the first intermediate node may be obtained. From the relevant history data, the history upload efficiency of the first intermediate node may be calculated. If the historical uploading efficiency is lower than a preset efficiency threshold, maintenance authority can be allocated to the client side of the first intermediate node, and the database is allowed to be maintained remotely through the client side. The problem that a database manager cannot quickly and accurately understand the key content of maintenance matters uploaded by related personnel of a central node, so that efficiency is low is solved. And judging whether the uploading efficiency of the first intermediate node is lower than a preset efficiency threshold value or not by analyzing the historical data, and if so, distributing the maintenance authority to the client of the first intermediate node so that the client can remotely maintain the database. In this way, the related personnel of the central node can directly carry out maintenance operation on the client, thereby avoiding the process of uploading maintenance items to a database manager and improving the maintenance efficiency.
Drawings
FIG. 1 is an application environment diagram of a method for remotely maintaining a database by a client in one embodiment;
FIG. 2 is a flow diagram of a method for remotely maintaining a database by a client in one embodiment;
FIG. 3 is a flow chart of a method for remotely maintaining a database by a client in another embodiment;
FIG. 4 is a block diagram of an apparatus for remotely maintaining a database by a client in one embodiment;
fig. 5 is an internal structural diagram of a computer device in one embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application will be further described in detail with reference to the accompanying drawings and examples. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the present application.
The method for remotely maintaining the database through the client provided by the embodiment of the application can be applied to an application environment shown in fig. 1. Wherein the terminal 102 communicates with the server 104 via a network. The data storage system may store data that the server 104 needs to process. The data storage system may be integrated on the server 104 or may be located on a cloud or other network server. The terminal 102 may be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers, internet of things devices, and portable wearable devices, where the internet of things devices may be smart speakers, smart televisions, smart air conditioners, smart vehicle devices, and the like. The portable wearable device may be a smart watch, smart bracelet, headset, or the like. The server 104 may be implemented as a stand-alone server or as a server cluster of multiple servers.
In one embodiment, as shown in fig. 2, a method for remotely maintaining a database through a client is provided, and the method is applied to the server in fig. 1 for illustration, and includes the following steps:
step S202, obtaining database maintenance items to be uploaded, and analyzing processing nodes for obtaining the database maintenance items, wherein the processing nodes comprise a first administrator node and a first intermediate node.
Specifically, the database maintenance item to be uploaded refers to an item that is required to be maintained by a person associated with the central node. The processing nodes are nodes through which these maintenance items need to pass when performing maintenance operations. In this design, the processing nodes include a first administrator node and a first intermediate node. The first manager node is a designated database manager node and is responsible for unified maintenance and management of the database. The first intermediate node refers to an intermediate node of the central node, which may be designated by a database administrator or selected automatically by the system. By taking database maintenance items to be uploaded and analyzing the processing nodes of those items, it is possible to determine which nodes the maintenance items need to be processed through. In this way, preparation can be made for subsequent maintenance operations, for example, to determine whether maintenance rights need to be assigned to the client of the first intermediate node, so as to improve maintenance efficiency.
In step S204, if the database maintenance item is at the first intermediate node, relevant history data of uploading the database maintenance item to the first administrator node through the first intermediate node is obtained.
Specifically, if the database maintenance items are at the first intermediate node, it means that these maintenance items need to be uploaded to the first administrator node through the first intermediate node. In this case, relevant history data, i.e. a record of database maintenance items that have been uploaded to the first administrator node through the first intermediate node in the past, may be obtained. By acquiring these history data, it is possible to analyze the uploading efficiency of the first intermediate node, and to know whether or not the uploading of the maintenance items of the first intermediate node is inefficient in the past maintenance operation. Therefore, the method can be used as a basis for judging whether the maintenance authority is required to be allocated to the client of the first intermediate node, and if the historical uploading efficiency is lower than a preset efficiency threshold, the maintenance authority can be allocated to the client of the first intermediate node so as to improve the maintenance efficiency.
Step S206, according to the related history data, the history uploading efficiency of the first intermediate node is obtained.
Specifically, according to the relevant historical data, the historical uploading efficiency of the first intermediate node is obtained, and the efficiency condition of the first intermediate node when uploading the database maintenance matters is known through analyzing the past data records. This may help us evaluate the maintenance transaction handling capabilities of the first intermediate node, thereby deciding whether to transfer the maintenance rights to the client of the first intermediate node. Collecting historical data: records of past database maintenance events, including upload time, upload content, uploader, etc., are collected, ensuring that these records contain maintenance events uploaded to the first administrator node via the first intermediate node. Analysis of upload time: the upload time for each maintenance item is analyzed and the time taken to upload to the first manager node is calculated. This may measure the efficiency of the uploading of the first intermediate node, i.e. the transmission speed of maintenance items from the first intermediate node to the first manager node. Comparing the efficiency threshold: and comparing the historical uploading efficiency of the first intermediate node with a preset efficiency threshold. If the historical upload efficiency is below the threshold, indicating that the processing power of the first intermediate node is low, it may be necessary to consider assigning maintenance rights to the client of the first intermediate node.
Step S208, if the historical uploading efficiency is lower than the preset efficiency threshold, assigning maintenance authority to the client of the first intermediate node, wherein the maintenance authority is used for allowing the remote maintenance of the database through the client of the first intermediate node.
Specifically, if the historical uploading efficiency is lower than the preset efficiency threshold, it means that the first intermediate node has low efficiency of processing the uploading database maintenance event in the past maintenance operation. In order to increase the maintenance efficiency, it may be considered to assign maintenance rights to the clients of the first intermediate node, allowing them to perform maintenance operations on the database remotely.
In particular, assigning maintenance rights to clients of the first intermediate node means that they will gain certain control and rights to perform database maintenance operations, including but not limited to backup, restore, optimize, repair, and monitor tasks. By allowing the client of the first intermediate node to perform remote maintenance, the burden on the first administrator node can be reduced, and the efficiency and response speed of maintenance operation can be improved. In addition, distributed maintenance can be realized, so that a plurality of nodes can simultaneously perform maintenance operation, and the overall maintenance capability is improved.
In this embodiment, by analyzing the processing node of the database maintenance event, the maintenance task may be distributed to an appropriate node for processing, so as to avoid that excessive load is concentrated on the first manager node. Meanwhile, the capability of the first intermediate node for processing maintenance items can be judged by analyzing the historical uploading efficiency of the first intermediate node, so that maintenance tasks are reasonably arranged, and the overall maintenance efficiency is improved. After the maintenance authority is distributed to the client of the first intermediate node, distributed maintenance can be realized, and a plurality of nodes can simultaneously perform maintenance operation, so that the overall maintenance capability is improved. Thus, the burden on the first manager node can be reduced, and the concurrency and response speed of maintenance are improved. After the maintenance authority is distributed to the client side of the first intermediate node, the database can be maintained in a remote mode. In this way, the transmission time and delay of maintenance tasks can be reduced, and the response speed of maintenance operations can be improved.
In one embodiment, referring to fig. 3, assigning maintenance rights to a client of a first intermediate node includes:
step S302, address information of all intermediate nodes in the area is obtained, and sequence numbers corresponding to the address information of all the intermediate nodes are inquired and obtained in a preset control association table.
Step S304, if the serial number corresponding to the address information of the intermediate node is not in the end serial number, an instruction for distributing maintenance authority is sent to the intermediate node positioned in the end serial number.
Step S306, the intermediate node at the end sequence number forwards the instruction for distributing the maintenance authority to the adjacent intermediate node, so that the adjacent intermediate node forwards the instruction for distributing the maintenance authority backwards continuously according to the sequence number sequence until the instruction for distributing the maintenance authority is sent to the client of the first intermediate node.
Specifically, firstly, address information of all intermediate nodes in an area is obtained, and the sequence numbers corresponding to the address information of the intermediate nodes are obtained by inquiring in a preset control association table. These sequence numbers may be used to represent the order of the locations of the intermediate nodes. For each intermediate node, judging whether the serial number corresponding to the address information of the intermediate node is at the end serial number. If not, the intermediate node is indicated as having a neighboring intermediate node. For an intermediate node at an end sequence number, an instruction to assign maintenance rights is sent to the intermediate node. The instruction of distributing maintenance authority is forwarded to the adjacent intermediate nodes by the intermediate nodes located at the end serial numbers. And the adjacent intermediate nodes continue to forward the instruction for distributing the maintenance authority backwards according to the sequence number sequence until the instruction for distributing the maintenance authority is sent to the client of the first intermediate node.
Illustratively, assume that there are four intermediate nodes within the region whose address information and corresponding sequence numbers are as follows:
intermediate node A-address 192.168.1.100, sequence number 1
Intermediate node B-address 192.168.1.101, sequence number 2
Intermediate node C-Address 192.168.1.102, sequence number 3
Intermediate node D-Address 192.168.1.103, sequence number 4
The maintenance authority distribution process is carried out according to the steps: and acquiring address information of all intermediate nodes in the area, and inquiring to acquire corresponding serial numbers. For intermediate node a, its sequence number is 1, at the end sequence number, thus sending an instruction to intermediate node a to assign maintenance rights. Intermediate node a forwards the instruction to allocate maintenance rights to the neighboring intermediate node B. The intermediate node B forwards the instruction to allocate maintenance rights to the neighboring intermediate node C. The intermediate node C forwards the instruction to allocate the maintenance authority to the neighboring intermediate node D. The intermediate node D is the last node and therefore no longer forwards, sending an instruction to the client of the first intermediate node to allocate maintenance rights. Through this procedure, the maintenance authority is sequentially forwarded from the intermediate node a to the intermediate node B, the intermediate node C and the intermediate node D in the order of the serial numbers, and finally reaches the client of the first intermediate node. This ensures the order of allocation of the maintenance rights and the correctness of the transfer path.
In this embodiment, the sequence of allocation of the maintenance rights is determined by the sequence number and address information of the intermediate nodes, and the maintenance rights instruction is transferred to the client of the first intermediate node by forwarding between the intermediate nodes. In this way, the maintenance authority can be ensured to be distributed to each intermediate node according to the sequence number order, and the sequential execution of maintenance tasks can be realized.
In one embodiment, the method further comprises: acquiring historical maintenance times of remotely maintaining a database through a client of a first intermediate node; and if the maintenance times are greater than a preset times threshold, and the difference value between the serial number of the first intermediate node and the serial number of the end part is smaller than the preset difference value threshold, the first intermediate node is used as a second manager node, wherein the second manager node and the first manager node are used for jointly acquiring database maintenance matters uploaded by other intermediate nodes except the first intermediate node.
Specifically, first, the number of times of history maintenance of the database may be obtained by the client of the first intermediate node. And if the historical maintenance times are larger than a preset times threshold, and the difference value between the serial number of the first intermediate node and the serial number of the end part is smaller than the preset difference value threshold, taking the first intermediate node as a second manager node. The first manager node and the second manager node cooperate together to obtain database maintenance matters uploaded by other intermediate nodes except the first intermediate node. In general, this process is to decide whether to take the first intermediate node as the second manager node by judging the condition, and the first manager node and the second manager node cooperate together to acquire database maintenance matters uploaded by other intermediate nodes. Thus, corresponding operation and allocation authorities can be made according to the maintenance times and the serial numbers of the intermediate nodes.
In this embodiment, the serial number and address information of the intermediate node ensure that the maintenance authority is sequentially transferred from the first intermediate node to other intermediate nodes in order, so as to implement sequential execution of maintenance tasks. Judging whether the condition is met or not according to the historical maintenance times of the database and the difference value between the serial numbers of the intermediate nodes and the end serial numbers, and taking the first intermediate node as a second manager node to realize condition screening and operation distribution. The first manager node and the second manager node cooperate together to acquire database maintenance items uploaded by other intermediate nodes except the first intermediate node, so that cooperative work among multiple nodes is realized.
In one embodiment, after having the first intermediate node as the second manager node, comprising:
step S402, obtaining database maintenance items uploaded by other intermediate nodes forwarded by the second administrator node, and obtaining identity data of the other intermediate nodes.
Step S404, judging whether the identity data is legal data or not according to the identity data of other intermediate nodes.
In step S406, if the identity data is legal data, a first execution instruction is sent to the second manager node, where the first execution instruction is used to remind the second manager node to execute the database maintenance items uploaded by other intermediate nodes, so as to maintain the database.
Specifically, the first administrator node needs to obtain database maintenance items uploaded by other intermediate nodes forwarded by the second administrator node, and obtain identity data of the other intermediate nodes. And judging whether the identity data is legal data or not according to the acquired identity data of other intermediate nodes. If the identity data is legal, the first manager node sends a first execution instruction to the second manager node. The purpose of the first execution instruction is to prompt the second manager node to execute the database maintenance event uploaded by other intermediate nodes, so as to maintain the database.
In this embodiment, by determining validity of the identity data, if the identity data is legal, an instruction is sent to the second administrator node to execute the database maintenance items uploaded by other intermediate nodes, so as to implement maintenance of the database. By legal judgment of the identity data uploaded by other intermediate nodes, malicious users can be prevented from tampering with the data or illegal operations by impersonating legal users. The legal judgment of the identity data can prevent the malicious user from illegally accessing or attacking by utilizing the security hole of the system, and protect the system from attack. The legal judgment can ensure that only database maintenance matters uploaded by the authenticated intermediate node can be executed, thereby ensuring the integrity and the reliability of data. The legal judgment can prevent an unauthorized intermediate node from acquiring sensitive user identity data, thereby protecting the privacy of the user.
In one embodiment, after obtaining the database maintenance items uploaded by the other intermediate nodes forwarded by the second administrator node and obtaining the identity data of the other intermediate nodes, the method further includes:
step S502, uploading database maintenance items uploaded by other intermediate nodes forwarded by the second administrator node and identity data of other intermediate nodes to the blockchain network.
Step S504, obtain the extraction application information of the identity data and/or the extraction application information of the database maintenance item sent by the client of any intermediate node in the other intermediate nodes.
Step S506, judging whether the client of any intermediate node is a target client according to the extraction application information of the identity data and/or the extraction application information of the database maintenance item.
Step S508, if yes, scheduling identity data and/or database maintenance items to the client of any intermediate node;
step S510, a scheduling record of the identity data and/or the database maintenance items is obtained, and the scheduling record is uploaded to the blockchain network.
Specifically, the second administrator node uploads database maintenance matters and identity data uploaded by other intermediate nodes to the blockchain network. This means that the second manager node creates a relevant data record on the blockchain. The client of any intermediate node may send the withdrawal request information of the identity data and/or the withdrawal request information of the database maintenance item. Such application information may include a detailed description of the request for specific identity data or database maintenance items. According to the request information, the system determines whether the client of the intermediate node is a target client. This may involve verification and matching of the application information to ensure rights and accuracy. If the client of the intermediate node is identified as the target client, the system will schedule corresponding identity data and/or database maintenance items to that client. This means that the target client will obtain the requested data or transaction. During the scheduling process, the system will record details of the schedule, including what data or transactions were requested by the clients of which intermediate nodes, and upload these schedule records to the blockchain network. This helps to ensure transparency and traceability of the scheduling process.
In the embodiment, the safety, the credibility and the traceability of the data scheduling are realized by using the blockchain technology. By storing the data and scheduling records on the blockchain, security of the data can be ensured and auditable scheduling processes can be provided. In addition, the decentralization feature of the blockchain network also helps to improve the reliability and robustness of the system.
In one embodiment, after assigning the maintenance rights to the client of the first intermediate node, further comprising:
step S602, obtaining a database maintenance item uploaded by a client of the first intermediate node, and listing the database maintenance item in a sharing operation folder, wherein the sharing operation folder is used for the first administrator node to operate.
Step S604, traversing each database maintenance item in the shared operation folder according to the preset distributed timing task, and obtaining the file content of each database maintenance item.
Step S606, according to the file content of each database maintenance item, a second execution instruction is sent to the client of the first intermediate node, where the first execution instruction is used to remind the client of the first intermediate node to execute the database maintenance item, so as to maintain the database.
Specifically, the client of the first intermediate node has uploaded database maintenance items and has listed these items in the shared operations folder. This means that the client of the first intermediate node stores information about database maintenance matters in a shared folder for access and operation by other nodes. According to the preset distributed timing tasks, the system traverses each database maintenance item in the shared operations folder. This means that the system will automatically check each item in the shared folder at predetermined time intervals or rules. For each database maintenance event, the system will obtain its file contents. This means that the system will read the details of each item in the shared folder, possibly some script, instruction or description of other maintenance operations. Based on the file content of each database maintenance transaction, the system sends a second execution instruction to the client of the first intermediate node. This means that the system will send an instruction to the client of the first intermediate node reminding it to perform the database maintenance transaction. This instruction may include information about the specific maintenance operation, execution time, etc. And after receiving the second execution instruction, the client side of the first intermediate node executes corresponding database maintenance items. This means that the client of the first intermediate node performs a corresponding maintenance operation on the database according to the description in the instruction.
In the embodiment, the automatic and distributed execution of the database maintenance is realized by using a distributed timing task and a mode of sharing the operation folder. By traversing the shared folder and sending the execution instruction at regular time, the system can realize timely processing and execution of the database maintenance items. This approach may improve the efficiency and accuracy of database maintenance and reduce the need for human intervention.
In one embodiment, after sending the second execution instruction to the client of the first intermediate node, the method includes: and acquiring relevant historical data of each database maintenance item executed by the first intermediate node, and visually displaying the relevant historical data.
Specifically, relevant historical data for each database maintenance event performed by the first intermediate node is obtained. This means that the system records information and data about each database maintenance event performed by the first intermediate node, such as execution time, execution result, execution duration, etc. These historical data can be used for subsequent analysis and presentation. And visually displaying the relevant historical data. This means that the system will present the acquired historical data in a visual manner, such as generating a chart, report, or other form of graphical presentation. Through visual display, a user can more intuitively know the execution condition and trend of the database maintenance matters.
In this embodiment, the purpose of the visual presentation of the historical data is to provide a comprehensive understanding and analysis of the performance of database maintenance events. By observing the visual presentation of the historical data, the user can discover potential problems, optimize the execution strategy, and make corresponding adjustments. At the same time, the visual display is also helpful for evaluating the execution effect of the database maintenance items, such as whether the execution time meets the requirement, whether the execution result meets the expectations, and the like. In a word, through the visual display of the historical data, the monitoring and management capacity of the execution condition of the database maintenance items can be improved.
In other embodiments, the method further comprises:
remote login: remote login tools (e.g., SSH, RDP, etc.) are used to connect to the database server remotely through the client and perform maintenance operations. This approach requires the remote login function to be initiated on the database server and a corresponding security configuration to be performed.
Remote command execution: the commands or scripts are sent by the client to the database server and then executed on the server. Remote command execution may be performed using SSH, telnet, or the like protocols.
Database management tool: database maintenance operations are performed using database management tools (e.g., mySQL Workbench, SQL Server Management Studio, etc.) to remotely connect to a database server through a client. This approach provides for more convenient operation and management through a graphical interface.
API call: and remotely calling a maintenance interface of the database through the client by using an API interface provided by the database, and executing corresponding maintenance operation. This approach applies to databases that provide open-to-the-outside API interfaces and that are accessible to clients.
Web console: and accessing the Web console of the database by the client through the Web browser, and performing remote database maintenance operation. This approach is typically a Web-based management interface provided by the database vendor, which users can manage and maintain the database through a browser.
The technical means can select a proper mode to carry out remote maintenance of the database according to specific requirements and scenes. Through the technical means of remote maintenance of the database by the client, the management and maintenance efficiency can be improved, the fault checking and monitoring capability is enhanced, the cost and the manpower investment are reduced, and the flexibility and the operability of database management are improved.
It should be understood that, although the steps in the flowcharts related to the embodiments described above are sequentially shown as indicated by arrows, these steps are not necessarily sequentially performed in the order indicated by the arrows. The steps are not strictly limited to the order of execution unless explicitly recited herein, and the steps may be executed in other orders. Moreover, at least some of the steps in the flowcharts described in the above embodiments may include a plurality of steps or a plurality of stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of the steps or stages is not necessarily performed sequentially, but may be performed alternately or alternately with at least some of the other steps or stages.
Based on the same inventive concept, the embodiments of the present application also provide an apparatus for remotely maintaining a database by a client for implementing the above-mentioned method for remotely maintaining a database by a client. The implementation of the solution provided by the apparatus is similar to the implementation described in the above method, so specific limitations in the embodiments of the apparatus for remotely maintaining a database through a client provided below may be referred to above as limitations on a method for remotely maintaining a database through a client, and will not be repeated herein.
In one embodiment, as shown in fig. 4, there is provided an apparatus for remotely maintaining a database by a client, comprising:
an obtaining module 402, configured to obtain a database maintenance item to be uploaded;
a processing module 404 for analyzing processing nodes that obtain database maintenance items, the processing nodes including a first administrator node and a first intermediate node;
the obtaining module 402 is further configured to obtain, if the database maintenance item is at the first intermediate node, relevant historical data of uploading the database maintenance item to the first administrator node through the first intermediate node;
the processing module 404 is further configured to obtain a history uploading efficiency of the first intermediate node according to the relevant history data;
And the permission allocation module 406 is configured to allocate maintenance permission to the client of the first intermediate node if the historical uploading efficiency is lower than a preset efficiency threshold, where the maintenance permission is used to allow remote maintenance of the database through the client of the first intermediate node.
In one embodiment, the apparatus comprises:
the obtaining module 402 is further configured to obtain address information of all intermediate nodes in the area, and query and obtain serial numbers corresponding to the address information of all intermediate nodes in a preset control association table;
the sending module is used for sending an instruction for distributing maintenance permission to the intermediate node positioned at the end sequence number if the sequence number corresponding to the address information of the intermediate node is not positioned at the end sequence number;
and the sending module is also used for forwarding the instruction for distributing the maintenance authority to the adjacent intermediate nodes by the intermediate nodes positioned at the end sequence numbers, so that the adjacent intermediate nodes continue to forward the instruction for distributing the maintenance authority backwards according to the sequence numbers until the instruction for distributing the maintenance authority is sent to the client side of the first intermediate node.
In one embodiment, the apparatus further comprises:
the obtaining module 402 is further configured to obtain a historical maintenance number of times of remotely maintaining the database through the client of the first intermediate node;
The processing module 404 is further configured to, if the number of maintenance times is greater than a preset number of times threshold, and a difference between the serial number of the first intermediate node and the serial number of the end is less than a preset difference threshold, take the first intermediate node as a second manager node, where the second manager node and the first manager node are configured to jointly obtain database maintenance items uploaded by other intermediate nodes except the first intermediate node.
In one embodiment, the apparatus further comprises:
the obtaining module 402 is further configured to obtain database maintenance items uploaded by other intermediate nodes forwarded by the second administrator node, and obtain identity data of the other intermediate nodes;
the processing module 404 is further configured to determine whether the identity data is legal data according to the identity data of other intermediate nodes;
the sending module is further configured to send a first execution instruction to the second manager node if the identity data is legal, where the first execution instruction is used to remind the second manager node to execute the database maintenance items uploaded by other intermediate nodes, so as to maintain the database.
In one embodiment, the apparatus further comprises:
the uploading module is used for uploading database maintenance items uploaded by other intermediate nodes forwarded by the second manager node and identity data of the other intermediate nodes to the blockchain network;
The obtaining module 402 is further configured to obtain extraction application information of identity data and/or extraction application information of database maintenance items sent by a client of any intermediate node of other intermediate nodes;
the processing module 404 is further configured to determine whether the client of any intermediate node is a target client according to the extraction application information of the identity data and/or the extraction application information of the database maintenance item;
the scheduling module is further used for scheduling the identity data and/or the database maintenance items to the client of any intermediate node if the client of any intermediate node is the target client;
the obtaining module 402 is further configured to obtain the scheduling record of the identity data and/or the database maintenance item, and the uploading module is further configured to upload the scheduling record to the blockchain network.
In one embodiment, the apparatus further comprises:
the obtaining module 402 is further configured to obtain a database maintenance item uploaded by the client of the first intermediate node, and the processing module 404 is further configured to list the database maintenance item in a shared operation folder, where the shared operation folder is used for the first administrator node to operate;
the processing module 404 is further configured to traverse each database maintenance item in the shared operation folder according to a preset distributed timing task, and obtain a file content of each database maintenance item;
The sending module is further configured to send a second execution instruction to the client of the first intermediate node according to the file content of each database maintenance item, where the first execution instruction is used to remind the client of the first intermediate node to execute the database maintenance item, so as to maintain the database.
In one embodiment, the apparatus further comprises:
the acquiring module 402 is further configured to acquire relevant historical data of each database maintenance item executed by the first intermediate node, and the displaying module is configured to visually display the relevant historical data.
The various modules in the apparatus for remotely maintaining a database through a client may be implemented in whole or in part by software, hardware, and combinations thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may call and execute operations corresponding to the above modules.
In one embodiment, a computer device is provided, which may be a terminal, and the internal structure of which may be as shown in fig. 5. The computer device includes a processor, a memory, an input/output interface, a communication interface, a display unit, and an input means. The processor, the memory and the input/output interface are connected through a system bus, and the communication interface, the display unit and the input device are connected to the system bus through the input/output interface. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The input/output interface of the computer device is used to exchange information between the processor and the external device. The communication interface of the computer device is used for carrying out wired or wireless communication with an external terminal, and the wireless mode can be realized through WIFI, a mobile cellular network, NFC (near field communication) or other technologies. The computer program is executed by a processor to implement a method of remotely maintaining a database by a client. The display unit of the computer device is used for forming a visual picture, and can be a display screen, a projection device or a virtual reality imaging device. The display screen can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, can also be a key, a track ball or a touch pad arranged on the shell of the computer equipment, and can also be an external keyboard, a touch pad or a mouse and the like.
It will be appreciated by those skilled in the art that the structure shown in fig. 5 is merely a block diagram of some of the structures associated with the present application and is not limiting of the computer device to which the present application may be applied, and that a particular computer device may include more or fewer components than shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, a computer device is provided comprising a memory and a processor, the memory having stored therein a computer program, the processor when executing the computer program performing the steps of:
step S202, acquiring database maintenance items to be uploaded, and analyzing processing nodes for acquiring the database maintenance items, wherein the processing nodes comprise a first administrator node and a first intermediate node;
step S204, if the database maintenance item is in the first intermediate node, acquiring relevant historical data of uploading the database maintenance item to the first manager node through the first intermediate node;
step S206, acquiring the history uploading efficiency of the first intermediate node according to the related history data;
step S208, if the historical uploading efficiency is lower than the preset efficiency threshold, assigning maintenance authority to the client of the first intermediate node, wherein the maintenance authority is used for allowing the remote maintenance of the database through the client of the first intermediate node.
In one embodiment, a computer readable storage medium is provided having a computer program stored thereon, which when executed by a processor, performs the steps of:
step S202, acquiring database maintenance items to be uploaded, and analyzing processing nodes for acquiring the database maintenance items, wherein the processing nodes comprise a first administrator node and a first intermediate node;
step S204, if the database maintenance item is in the first intermediate node, acquiring relevant historical data of uploading the database maintenance item to the first manager node through the first intermediate node;
step S206, acquiring the history uploading efficiency of the first intermediate node according to the related history data;
step S208, if the historical uploading efficiency is lower than the preset efficiency threshold, assigning maintenance authority to the client of the first intermediate node, wherein the maintenance authority is used for allowing the remote maintenance of the database through the client of the first intermediate node.
In one embodiment, a computer program product is provided comprising a computer program which, when executed by a processor, performs the steps of:
step S202, acquiring database maintenance items to be uploaded, and analyzing processing nodes for acquiring the database maintenance items, wherein the processing nodes comprise a first administrator node and a first intermediate node;
Step S204, if the database maintenance item is in the first intermediate node, acquiring relevant historical data of uploading the database maintenance item to the first manager node through the first intermediate node;
step S206, acquiring the history uploading efficiency of the first intermediate node according to the related history data;
step S208, if the historical uploading efficiency is lower than the preset efficiency threshold, assigning maintenance authority to the client of the first intermediate node, wherein the maintenance authority is used for allowing the remote maintenance of the database through the client of the first intermediate node.
It should be noted that, the user information (including, but not limited to, user equipment information, user personal information, etc.) and the data (including, but not limited to, data for analysis, stored data, presented data, etc.) referred to in the present application are information and data authorized by the user or sufficiently authorized by each party, and the collection, use and processing of the related data are required to comply with the related laws and regulations and standards of the related countries and regions.
Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed, may comprise the steps of the embodiments of the methods described above. Any reference to memory, database, or other medium used in the various embodiments provided herein may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, high density embedded nonvolatile Memory, resistive random access Memory (ReRAM), magnetic random access Memory (Magnetoresistive Random Access Memory, MRAM), ferroelectric Memory (Ferroelectric Random Access Memory, FRAM), phase change Memory (Phase Change Memory, PCM), graphene Memory, and the like. Volatile memory can include random access memory (Random Access Memory, RAM) or external cache memory, and the like. By way of illustration, and not limitation, RAM can be in the form of a variety of forms, such as static random access memory (Static Random Access Memory, SRAM) or dynamic random access memory (Dynamic Random Access Memory, DRAM), and the like. The databases referred to in the various embodiments provided herein may include at least one of relational databases and non-relational databases. The non-relational database may include, but is not limited to, a blockchain-based distributed database, and the like. The processors referred to in the embodiments provided herein may be general purpose processors, central processing units, graphics processors, digital signal processors, programmable logic units, quantum computing-based data processing logic units, etc., without being limited thereto.
The technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.
The above examples only represent a few embodiments of the present application, which are described in more detail and are not to be construed as limiting the scope of the present application. It should be noted that it would be apparent to those skilled in the art that various modifications and improvements could be made without departing from the spirit of the present application, which would be within the scope of the present application. Accordingly, the scope of protection of the present application shall be subject to the appended claims.
Claims (10)
1. A method for remotely maintaining a database by a client, the method comprising:
acquiring database maintenance items to be uploaded, and analyzing processing nodes for acquiring the database maintenance items, wherein the processing nodes comprise a first administrator node and a first intermediate node;
if the database maintenance item is in a first intermediate node, acquiring relevant historical data of uploading the database maintenance item to the first manager node through the first intermediate node;
Acquiring the historical uploading efficiency of the first intermediate node according to the related historical data;
and if the historical uploading efficiency is lower than a preset efficiency threshold, distributing maintenance authority to the client of the first intermediate node, wherein the maintenance authority is used for allowing the database to be maintained remotely through the client of the first intermediate node.
2. The method of claim 1, wherein the assigning maintenance rights to the client of the first intermediate node comprises:
acquiring address information of all intermediate nodes in the area, and inquiring and acquiring serial numbers corresponding to the address information of all intermediate nodes in a preset control association table;
if the serial number corresponding to the address information of the intermediate node is not the end serial number, sending an instruction for distributing maintenance permission to the intermediate node positioned at the end serial number;
and forwarding the maintenance authority allocation instruction to an adjacent intermediate node by the intermediate node positioned at the end sequence number, so that the adjacent intermediate node continuously forwards the maintenance authority allocation instruction backwards according to the sequence number sequence until the maintenance authority allocation instruction is sent to the client side of the first intermediate node.
3. The method according to claim 1, characterized in that the method further comprises:
acquiring historical maintenance times of remotely maintaining a database through a client of the first intermediate node;
and if the maintenance times are greater than a preset times threshold, and the difference value between the serial number of the first intermediate node and the serial number of the end part is smaller than a preset difference value threshold, the first intermediate node is used as a second manager node, wherein the second manager node and the first manager node are used for jointly acquiring database maintenance matters uploaded by other intermediate nodes except the first intermediate node.
4. A method according to claim 3, wherein said taking said first intermediate node as a second manager node, comprises:
acquiring database maintenance items uploaded by other intermediate nodes forwarded by the second manager node, and acquiring identity data of the other intermediate nodes;
judging whether the identity data is legal data or not according to the identity data of the other intermediate nodes;
and if the identity data is legal data, sending a first execution instruction to the second manager node, wherein the first execution instruction is used for reminding the second manager node to execute the database maintenance items uploaded by the other intermediate nodes so as to maintain the database.
5. The method of claim 4, wherein the obtaining database maintenance items uploaded by other intermediate nodes forwarded by the second manager node, and the obtaining identity data of the other intermediate nodes, further comprises:
uploading database maintenance items uploaded by other intermediate nodes forwarded by the second manager node, and identity data of the other intermediate nodes to a blockchain network;
acquiring the extraction application information of the identity data and/or the extraction application information of the database maintenance items sent by the client of any one of the other intermediate nodes;
judging whether the client of any intermediate node is a target client or not according to the extraction application information of the identity data and/or the extraction application information of the database maintenance items;
if yes, dispatching the identity data and/or database maintenance items to the client of any intermediate node;
and acquiring the scheduling record of the identity data and/or the database maintenance matters, and uploading the scheduling record to a blockchain network.
6. The method of claim 1, wherein after the assigning of maintenance rights to the client of the first intermediate node, further comprising:
Acquiring database maintenance items uploaded by a client of the first intermediate node, and listing the database maintenance items in a sharing operation folder, wherein the sharing operation folder is used for the first manager node to operate;
traversing each database maintenance item in the shared operation folder according to a preset distributed timing task, and acquiring the file content of each database maintenance item;
and sending a second execution instruction to the client of the first intermediate node according to the file content of each database maintenance item, wherein the first execution instruction is used for reminding the client of the first intermediate node of executing the database maintenance item so as to maintain the database.
7. The method of claim 6, wherein after sending the second execution instruction to the client of the first intermediate node, comprising:
and acquiring relevant historical data of each database maintenance item executed by the first intermediate node, and visually displaying the relevant historical data.
8. An apparatus for remotely maintaining a database by a client, the apparatus comprising:
the acquisition module is used for acquiring database maintenance items to be uploaded;
The processing module is used for analyzing and obtaining processing nodes of the database maintenance items, and the processing nodes comprise a first manager node and a first intermediate node;
the acquisition module is further used for acquiring relevant historical data of the database maintenance items uploaded to the first manager node through the first intermediate node if the database maintenance items are in the first intermediate node;
the processing module is further used for acquiring the history uploading efficiency of the first intermediate node according to the related history data;
and the permission distribution module is used for distributing maintenance permission to the client of the first intermediate node if the historical uploading efficiency is lower than a preset efficiency threshold, wherein the maintenance permission is used for allowing the remote maintenance of the database through the client of the first intermediate node.
9. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor implements the steps of the method of any of claims 1 to 7 when the computer program is executed.
10. A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311244346.1A CN117290333A (en) | 2023-09-26 | 2023-09-26 | Method and device for remotely maintaining database through client |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311244346.1A CN117290333A (en) | 2023-09-26 | 2023-09-26 | Method and device for remotely maintaining database through client |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117290333A true CN117290333A (en) | 2023-12-26 |
Family
ID=89240341
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311244346.1A Pending CN117290333A (en) | 2023-09-26 | 2023-09-26 | Method and device for remotely maintaining database through client |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117290333A (en) |
-
2023
- 2023-09-26 CN CN202311244346.1A patent/CN117290333A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9742794B2 (en) | Method and apparatus for automating threat model generation and pattern identification | |
| JP6101874B2 (en) | Method and system for deleting requested information | |
| US9917853B2 (en) | Correlating event logs to identify a potential security breach | |
| US9043872B2 (en) | Selective management controller authenticated access control to host mapped resources | |
| CN106686104B (en) | Method and equipment for operation and maintenance of target server | |
| EP3065077A1 (en) | Gap analysis of security requirements against deployed security capabilities | |
| US20190166159A1 (en) | Generating false data for suspicious users | |
| US20090234902A1 (en) | System, method and apparatus for making content available over multiple devices | |
| CN114207614A (en) | Safety investigation platform | |
| CN113836237A (en) | Method and device for auditing data operation of database | |
| TWI682281B (en) | Information processing device, information processing method and computer readable recording medium | |
| US11630684B2 (en) | Secure incident investigation workspace generation and investigation control | |
| CN117290333A (en) | Method and device for remotely maintaining database through client | |
| CN115658794A (en) | Data query method and device, computer equipment and storage medium | |
| CN115756255A (en) | Method, device and equipment for processing equipment parameters of parking lot equipment and storage medium | |
| CN114268481A (en) | Method, device, equipment and medium for processing illegal external connection information of intranet terminal | |
| JP6972735B2 (en) | Display control program, display control method and display control device | |
| CN117333134A (en) | Flow notifying method, apparatus, computer device, storage medium and program product | |
| KR102393183B1 (en) | Method, device and system for managing and processing log data of corporate server | |
| CN105939374A (en) | Online user offline processing method and device | |
| CN105897707A (en) | Password-less access method to cluster system and master control server | |
| CN116993536A (en) | Power data monitoring method, device, equipment, storage medium and computer product | |
| CN116566720A (en) | Firewall policy translation method, device, computer equipment and storage medium | |
| CN118193326A (en) | Database management method, device, computer equipment and storage medium | |
| CN116432229A (en) | Browser screen capture prevention method, device, computer equipment, medium and program product |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |