Information maintenance method, system, device and computer equipment

By receiving information change notifications, determining the target link and updating the database link, the problem of inefficient maintenance of DBlink is solved, and more efficient and reasonable database link management is achieved.

CN115048357BActive Publication Date: 2025-07-18INDUSTRIAL AND COMMERCIAL BANK OF CHINA
View PDF 2 Cites 0 Cited by

Patent Information

Application Number
CN202210695960.9
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2022-06-20
Publication Date
2025-07-18
Estimated Expiration
2042-06-20

AI Technical Summary

Technical Problem

DBlink's maintenance efficiency and rationality are low, especially when remote database device migration or password replacement, resulting in call failure and business impact.

Method used

By receiving notifications from the information changing nodes, determining the target link, forwarding the updated node information to each node, and updating the database link based on the access results, ensuring that the information changes are valid before maintaining the database link.

Benefits of technology

It improves the maintenance efficiency and rationality of database links, and reduces the impact of call failures on the business.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN115048357B_ABST
    Figure CN115048357B_ABST
Patent Text Reader

Abstract

The present application relates to an information maintenance method, system, device and computer equipment, belonging to the field of computer technology, and can be used in the field of fintech or other related fields. The method includes: receiving an information change notice sent by an information change node; determining a target link from a link information library according to the information change node; for any target link, forwarding the information change notice to each node in the target link, so that a calling node responds to the information change notice and accesses a called node according to the updated node information and a database link for accessing the called node; determining an update result for the information change node according to the access results of the called nodes fed back by the calling nodes in each target link, and updating the database link corresponding to each target link according to the update result and the updated node information. By adopting this method, the maintenance efficiency and usage rationality of the database link can be improved.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] This application relates to the field of computer technologies, and in particular, to an information maintenance method, system, device, and computer equipment. Background Art

[0002] DBlink (Database Link) is an object of the Oracle database, which provides support for cross-database information interaction for SQL (Structured Query Language), stored procedures, and application programs involved in the Oracle database. After creating a DBlink of a remote database in the local database, through the DBlink, objects such as tables and views in the remote database table can be accessed just like accessing the local database. Therefore, in a project system with Oracle as the data source, creating a DBlink to access the remote database is a very common cross-system data access method.

[0003] When the remote database undergoes equipment migration, cloud migration, and needs to migrate to a new IP (Internet Protocol), or when the password needs to be changed regularly due to security specification requirements, the local database cannot synchronously adjust the DBlink. The failure of the DBlink to call the remote database will repeatedly reconnect to the remote database until the remote database user is locked, which not only affects all DBlinks depending on the remote database, but also affects the services involving the remote database.

[0004] Therefore, the current maintenance efficiency and usage rationality of DBlink are low. Summary of the Invention

[0005] Based on this, in view of the above technical problems, it is necessary to provide an information maintenance method, system, device, computer equipment, computer-readable storage medium, and computer program product to improve the maintenance efficiency and usage rationality of DBlink.

[0006] In a first aspect, this application provides an information maintenance method, and the method includes:

[0007] Receiving an information change notice sent by an information change node, where the information change notice includes updated node information;

[0008] Determining a target link from a link information library according to the information change node, where the target link includes a calling node and a called node, and the information change node is any node in the target link;

[0009] For any of the target links, forward the information change notice to each node in the target link, so that the calling node responds to the information change notice and accesses the called node according to the updated node information and the database link used to access the called node;

[0010] Determine the update result for the information change node according to the access results of the called node fed back by the calling nodes in each target link, and update the database link corresponding to each target link according to the update result and the updated node information.

[0011] In one embodiment, the forwarding the information change notice to each node in the target link includes:

[0012] When the information change node is the calling node, forward the information change notice to each node in the target link in the order from the calling node to the called node;

[0013] Or, when the information change node is the called node, forward the information change notice to each node in the target link in the order from the called node to the calling node.

[0014] In one embodiment, the determining the update result for the information change node according to the access results of the called node fed back by the calling nodes in each target link includes:

[0015] If there is at least one first access result among the access results of the called node fed back by the calling nodes in each target link, generate a first update result indicating that the change of the information change node is invalid, where the first access result is used to indicate that the calling node in the target link fails to access the called node;

[0016] Or, if the access results of the called node fed back by the calling nodes in each target link are all second access results, generate a second update result indicating that the change of the information change node is valid, where the second access result is used to indicate that the calling node in the target link successfully accesses the called node.

[0017] In one embodiment, the updating the database link corresponding to each target link according to the update result and the updated node information includes:

[0018] When the update result is the second update result, update the information of the information change nodes in the database links corresponding to the target links according to the updated node information.

[0019] In one embodiment, the method further includes: when the update result is the second update result, update the information of the information change nodes in the link information library and the database links corresponding to the target links according to the updated node information.

[0020] In one embodiment, the method further includes: when the update result is the first update result, perform information reset processing on the information change nodes to reset the node information of the information change nodes from the updated node information to the node information before the update.

[0021] In a second aspect, the present application provides an information maintenance system, and the system includes:

[0022] A control system and multiple database nodes, where the multiple database nodes include a calling node and a called node, and the information change node is any one of the database nodes;

[0023] Among them, the control system is configured to receive an information change notification sent by the information change node, determine a target link including the information change node from the link information library, and forward the information change notification to each node in the target link for any one of the target links. Among them, the target link includes the calling node and the called node, the information change node is any one of the target links, and the information change notification includes updated node information;

[0024] The calling node is configured to respond to the information change notification and access the called node according to the updated node information and the database link for accessing the called node;

[0025] The control system is further configured to determine an update result for the information change node according to the access result of the calling node in each target link for the called node, and update the database links corresponding to the target links according to the update result and the updated node information.

[0026] In a third aspect, the present application provides an information maintenance device, and the device includes:

[0027] An information receiving module, configured to receive an information change notification sent by an information change node, where the information change notification includes updated node information;

[0028] A link determination module, configured to determine a target link from a link information library according to the information change node, where the target link includes a calling node and a called node, and the information change node is any node in the target link;

[0029] An information notification module, configured to forward the information change notification to each node in the target link for any one of the target links, so that the calling node responds to the information change notification and accesses the called node according to the updated node information and the database link used to access the called node;

[0030] An information update module, configured to determine an update result for the information change node according to the access results of the called node feedback by the calling node in each target link, and update the database link corresponding to each target link according to the update result and the updated node information.

[0031] In one embodiment, the information notification module is further configured to, when the information change node is the calling node, forward the information change notification to each node in the target link in the order from the calling node to the called node; or, when the information change node is the called node, forward the information change notification to each node in the target link in the order from the called node to the calling node.

[0032] In one embodiment, the information update module is further configured to, if there is at least one first access result in the access results of the called node feedback by the calling node in each target link, generate a first update result for indicating that the change of the information change node is invalid, where the first access result is used to indicate that the calling node in the target link fails to access the called node; or, if the access results of the called node feedback by the calling node in each target link are all second access results, generate a second update result for indicating that the change of the information change node is valid, where the second access result is used to indicate that the calling node in the target link successfully accesses the called node.

[0033] In one embodiment, the information update module is further configured to, when the update result is the second update result, update the information of the information change node in the database link corresponding to each target link according to the updated node information.

[0034] In one of the embodiments, the device further includes an information storage module, which is configured to update the information of the information change node in the link information library and the database links corresponding to each of the target links according to the updated node information when the update result is the second update result.

[0035] In one of the embodiments, the device further includes an information reset module, which is configured to perform an information reset process on the information change node when the update result is the first update result, so as to reset the node information of the information change node from the updated node information to the node information before the update.

[0036] Fourthly, the present application further provides a computer device, which includes a memory and a processor. The memory stores a computer program, and when the processor executes the computer program, the following steps are implemented:

[0037] Receiving an information change notice sent by an information change node, where the information change notice includes updated node information;

[0038] Determining a target link from a link information library according to the information change node, where the target link includes a calling node and a called node, and the information change node is any node in the target link;

[0039] For any one of the target links, forwarding the information change notice to each node in the target link, so that the calling node, in response to the information change notice, accesses the called node according to the updated node information and the database link for accessing the called node;

[0040] Determining an update result for the information change node according to the access results of the calling nodes in each of the target links for the called node, and updating the database links corresponding to each of the target links according to the update result and the updated node information.

[0041] Fifthly, the present application further provides a computer-readable storage medium, on which a computer program is stored. When the computer program is executed by a processor, the following steps are implemented:

[0042] Receiving an information change notice sent by an information change node, where the information change notice includes updated node information;

[0043] Determining a target link from a link information library according to the information change node, where the target link includes a calling node and a called node, and the information change node is any node in the target link;

[0044] For any of the target links, forward the information change notice to each node in the target link, so that the calling node, in response to the information change notice, accesses the called node according to the updated node information and the database link used to access the called node;

[0045] Determine the update result for the information change node according to the access results of the called node feedback by the calling nodes in each target link, and update the database link corresponding to each target link according to the update result and the updated node information.

[0046] In a sixth aspect, the present application also provides a computer program product, which includes a computer program. When the computer program is executed by a processor, the following steps are implemented:

[0047] Receive an information change notice sent by an information change node, where the information change notice includes updated node information;

[0048] Determine a target link from the link information library according to the information change node. The target link includes a calling node and a called node, and the information change node is any node in the target link;

[0049] For any of the target links, forward the information change notice to each node in the target link, so that the calling node, in response to the information change notice, accesses the called node according to the updated node information and the database link used to access the called node;

[0050] Determine the update result for the information change node according to the access results of the called node feedback by the calling nodes in each target link, and update the database link corresponding to each target link according to the update result and the updated node information.

[0051] The above information maintenance method, system, device, computer equipment, computer-readable storage medium and computer program product can receive an information change notice including updated node information sent by an information change node, and determine a target link including the information change node from a link information library according to the information change node. The target link may include a calling node and a called node. Further, for any target link, forward the information change notice to each node in the target link, so that the calling node in the target link responds to the information change notice, accesses the called node according to the updated node information and the database link used to access the called node, and determines the update result for the information change node according to the access result feedback by the calling node in each target link for the called node, and updates the database link corresponding to each target link according to the update result and the updated node information. The information maintenance method, system, device, computer equipment, computer-readable storage medium and computer program product provided by this application can, when information changes in any node in the target link, forward the information change notice to each node in the target link including the information change node, and then trigger the calling node in the target link to use the updated node information and the database link used to access the called node to access the called node, so as to verify the validity of the updated node information in the information change node, obtain the corresponding update result, and then perform database link maintenance in real time based on the update result and the updated node information, which can improve the maintenance efficiency and usage rationality of the database link. BRIEF DESCRIPTION OF THE DRAWINGS

[0052] Figure 1 It is a schematic flowchart of the information maintenance method in an embodiment;

[0053] Figure 2 It is a schematic diagram of the link information library in an embodiment;

[0054] Figure 3 It is a schematic diagram of information change notice forwarding in an embodiment;

[0055] Figure 4 It is a schematic diagram of information change notice forwarding in an embodiment;

[0056] Figure 5 It is a block diagram of the structure of the information maintenance device in an embodiment;

[0057] Figure 6 It is an internal structure diagram of the computer equipment in an embodiment. DETAILED DESCRIPTION OF THE EMBODIMENTS

[0058] In order to make the objectives, technical solutions and advantages of the present application more clear and understandable, the present application will be further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.

[0059] In the actual use and maintenance of DBlink, the following practical problems exist: The creation of DBlink is unidirectional and is created locally by the calling database. The specific information is only stored in the local database. Suppose the local calling database is A and the called database is B. The syntax for creating DBlink is executed locally in database A:

[0060] create database link DBlinkName1

[0061] connect to user of Database B identified by the password of Database B

[0062] Using the IP:port of Database B;

[0063] For the maintenance personnel of the calling database A, the specific IP, port and user password are all stored in the calling database A. For the maintenance personnel of the called database B, as the called party, they do not know which calling databases have created access links to it through DBlink. Due to the opacity and asymmetry of information, when the called database B undergoes equipment migration or cloud migration, it is necessary to migrate the new IP but it is impossible to know which calling databases need to be notified. After the old called database B goes offline, the external calling database A that depends on DBlink fails to call the called database B, affecting normal business. When the called database B needs to change the database password regularly due to security regulations, it is also impossible to know which calling databases need to be notified to synchronously adjust DBlink. The calling database A will repeatedly reconnect due to the failure of DBlink to call, until the user of the called database B is locked, which not only affects all DBlinks that depend on the database B of the called party, but also affects the business involving remote databases.

[0064] Based on this, the embodiments of the present application provide an information maintenance method to solve the above problems, so as to ensure that when any node in each node of the target link changes, the rest of the nodes can receive notifications, and also make the information in the database link updated only after successful access, improving the maintenance efficiency and usage rationality of the database link.

[0065] In one embodiment, as Figure 1As shown, an information maintenance method is provided. In this embodiment, the method is exemplified by being applied to a terminal. It can be understood that the method can also be applied to a server, and can also be applied to a system including a terminal and a server, and is implemented through the interaction between the terminal and the server. In this embodiment, the method includes the following steps:

[0066] Step 102, receive an information change notice sent by an information change node, where the information change notice includes the updated node information.

[0067] In the embodiment of the present application, the information change node is a node whose information has changed. Once the information in a certain node changes, the node will be used as an information change node to send an information change notice, and the information change notice may include the updated node information.

[0068] For example, when the IP information of a node is updated, the updated node information may be the updated IP information of the node; when information such as the password of the node is updated, the updated node information may be the updated password and other information of the node.

[0069] Step 104, determine a target link from the link information library according to the information change node. The target link includes a calling node and a called node, and the information change node is any node in the target link.

[0070] In the embodiment of the present application, as Figure 2 shown, when each calling node, each database link, and each called node are created, the link information library records and stores the node information of each calling node, each database link, and each called node, as well as the link information between each node. A link can represent the connection relationship between each calling node and each called node through different database links. If a calling node is connected to a called node through a database link, then the calling node, the database link, and the called node form a link.

[0071] The target link is the link where the information change node is located, that is, the target link includes the information change node. An information change node can correspond to multiple target links, that is, the information change node can be used as a calling node or a called node in multiple links. After receiving the information change notice, multiple target links corresponding to the information change node can be obtained from the link information library according to the information change node.

[0072] Among them, the calling node is a local database, the called node is a remote database that the calling node needs to access, the calling node can access and call the called node through the database link, and the database link is created on the side of the calling node.

[0073] The node information of the calling node may include the id (name, Identity document), IP, and password of the calling node. The node information of the called node may include the id, IP, and password of the called node. The information of the database link may include the database link name, the IP and password of the called node, and the IP of the calling node. Exemplarily, the information change node is database B. The target link 1 of database B is obtained from the link information library: database A, DBl ink1, database B, and the target link 2: database B, DBl ink2, database C. In the target link 1, database A is the calling node, DBl ink1 is the database link, and database B is the called node. In the target link 2, database B is the calling node, DBl ink2 is the database link, and database C is the called node.

[0074] Step 106, for any target link, forward the information change notice to each node in the target link, so that the calling node, in response to the information change notice, accesses the called node according to the updated node information and the database link used to access the called node.

[0075] In the embodiment of the present application, after determining the multiple target links where the information change node is located, for any target link, the information change notice can be forwarded to the calling node and the called node in the target link. After receiving the information change notice, the calling node in the target link can initiate an access to the called node through the database link in the target link using the updated node information in the information change notice.

[0076] Taking the information change node as database B, and the target link 1 corresponding to database B: database A, DBl ink1, database B as an example, if the password in database B changes, the updated node information in the information change notice is the new password of database B. The information change notice containing the new password of database B can be forwarded to database B and database A in the target link 1. After receiving the information change notice, database A requests to access database B through DBl ink1 using the new password of database B in the information change notice.

[0077] In another embodiment, the information change node can also be a database link in the target link, and the database connection can be exited, that is, the link relationship between the calling node and the called node is disconnected. Taking the exit of DBlink1 in the target link 1 as an example, DBlink1 is an information change node, and the exit of DBlink1 means that the link relationship of the target link 1 is terminated. The information change notification containing the DBlink1 exit information can be forwarded to the database B and database A in the target link 1. After receiving the information change notification, database A wants to initiate access to database B through DBlink1, but the link relationship between DBlink1 and database A and database B has been terminated, and the access fails. At this time, the link relationship in the link information library can be updated to delete the target link 1.

[0078] Step 108, determining the update result for the information change node according to the access result for the called node fed back by the calling node in each target link, and updating the database link corresponding to each target link according to the update result and the updated node information.

[0079] In an embodiment of the present application, the access result can be used to characterize whether the access request of the calling node to the called node in the target link is successful. After determining the access result for the called node fed back by the calling node in each target link, the update result for the information change node can be determined based on the above access results. The update result for the information change node can be used to characterize whether the updated node information of the information change node is effective. If the update result characterizes that the updated node information of the information change node is effective, then each target link can be successfully accessed, and the information related to the information change node in the database link corresponding to each target link is updated to the updated node information, and then the real-time maintenance of the database link can be completed based on the update result and the updated node information.

[0080] The information maintenance method provided in the embodiment of the present application can, when information changes occur at any node in the target link, forward the information change notification to each node in the target link including the information change node, thereby triggering the calling node in the target link to access the called node using the updated node information and the database link for accessing the called node to verify the validity of the updated node information in the information change node, obtain the corresponding update result, and then perform database link maintenance in real time based on the update result and the updated node information, which can improve the maintenance efficiency and rationality of the database link.

[0081] In one embodiment, in step 106, forwarding the information change notification to each node in the target link may include:

[0082] When the information change node is a calling node, forward the information change notice to each node in the target link in the order from the calling node to the called node;

[0083] Alternatively, when the information change node is a called node, forward the information change notice to each node in the target link in the order from the called node to the calling node.

[0084] In the embodiments of the present application, if the information change node is a calling node, after determining the target link where the calling node is located, the information change notice can be forwarded to the calling node and the called node in order in the order from the calling node through the database link to the called node. It can be understood that in the actual application process, the database link is created at the calling node, and the database link can also receive the information change notice. Taking the information change node as database A as an example, the target link 1 where database A is located is: database A, DBl ink1, database B. Then when the node information in database A changes, the information change notice is forwarded to database A and database B in turn in the order of database A, DBl ink1, database B.

[0085] Alternatively, if the information change node is a called node, after determining the target link where the called node is located, the information change notice can be forwarded to the called node and the calling node in order in the order from the called node through the database link to the calling node. Taking the information change node as database B as an example, the target link 1 where database B is located is: database A, DBl ink1, database B. Then when the node information in database B changes, the information change notice can be forwarded to database B and database A in turn in the order of database B, DBl ink1, database A. Figure 3 and Figure 4 gives the forwarding process of the information change notice in two cases where the IP or password of database B changes.

[0086] Alternatively, the information change node can also be a database link, and the information change notice is forwarded to the calling node and the called node simultaneously in the target link. If the information change node is a database link, after determining the target link where the database link is located, the information change notice can be forwarded to the calling node and the called node simultaneously starting from the database link. Taking the information change node as DBl ink1 as an example, the target link 1 where DBl ink1 is located is: database A, DBl ink1, database B. Then when DBl ink1 exits, the information change notice can be forwarded to database A and database B simultaneously starting from DBl ink1, so that database A and database B know that the link between them is disconnected.

[0087] In the embodiments of the present disclosure, based on different information change nodes, information change notifications can be forwarded to each node in the target link in different orders, which can avoid the access failure caused by the time disorder when each node in the target link receives the information change simultaneously, that is, the effectiveness of database link maintenance can be improved.

[0088] In one embodiment, in step 108, determining the update result for the information change node according to the access results of the called nodes feedback by the calling nodes in each target link may include:

[0089] If there is at least one first access result among the access results of the called nodes feedback by the calling nodes in each target link, a first update result is generated to indicate that the change of the information change node is invalid, where the first access result is used to indicate that the calling node in the target link fails to access the called node;

[0090] Alternatively, if the access results of the called nodes feedback by the calling nodes in each target link are all second access results, a second update result is generated to indicate that the change of the information change node is valid, where the second access result is used to indicate that the calling node in the target link successfully accesses the called node.

[0091] In the embodiments of the present application, after the calling node in the target link receives the information change notification, it uses the updated node information carried in the information change notification to perform an access to the called node through the database link. If the calling node fails to access the called node, the calling node will feedback a first access result for the called node, and the first access result indicates the access failure.

[0092] And so on, each calling node in each target link where the information change node is located will feedback an access result for the called node. In the case where there is at least one first access result among the access results, a first update result can be generated, and the first update result is used to indicate that the change of the information change node is invalid, that is, after the information change node changes, there is at least one calling node in the target link that cannot access the called node.

[0093] If the calling node successfully accesses the called node, the calling node will feedback a second access result for the called node, and the second access result indicates the access success. And so on, each calling node in each target link where the information change node is located will feedback an access result for the called node. In the case where all the access results are second access results, a second update result can be generated, and the second update result is used to indicate that the change of the information change node is valid, that is, after the information change node changes, each calling node in each target link can successfully access the called node.

[0094] Embodiments of the present disclosure can generate different update results for information change nodes based on different access results, and determine whether to update the database link of the target link through the update results, so that the information in the database link is updated only after each target link attempts to access successfully, improving the maintenance efficiency and usage rationality of the database link.

[0095] In one embodiment, in step 108, updating the database link corresponding to each target link according to the update result and the updated node information may include:

[0096] In the case where the update result is the second update result, according to the updated node information, update the information of the information change node in the database link corresponding to each target link.

[0097] In the embodiments of the present application, after obtaining the second update result, it can be determined that the information change of the information change node is effective based on the second update result. Therefore, according to the updated node information, the information related to the information change node in the database link of each target link where the information change node is located can be updated to the updated node information.

[0098] Still taking the information change node as database B as an example, obtain the target link 1 of database B from the link information library: database A, DBlink1, database B, and target link 3: database C, DBlink3, database B. The password of database B is changed. In target link 1, database A requests to access database B using the new password of database B through DBlink1. If database A successfully calls out the data in database B, then database A feeds back a second access result indicating successful access. In target link 3, database C requests to access database B using the new password of database B through DBlink1. If database C successfully calls out the data in database B, then database C feeds back a second access result indicating successful access. According to the second access result fed back by database A and the second access result fed back by database C, a second update result indicating that the password change of database B is effective can be generated. At this time, replace the old password of database B in DBlink1 and the old password of database B in DBlink3 with the new password of database B.

[0099] Exemplarily, in the case where the update result is the first update result, the maintainers of the nodes in each relevant target link can be notified and reminded to perform manual processing within a specified time. If the new IP or new password of the called node is not effective, the maintainer of the called node is responsible for re-implementing the enabling of the new IP database or modifying the new password, and forwarding the information change notice including the new IP or new password to each node in the target link again. After receiving the information change notice, the calling node makes a new access request to the called node through the database link. If the calling node changes the IP and the firewall from the calling node to the called node is not accessible, the maintainer of the calling node is responsible for implementing the network firewall. After confirming that the firewall is opened, the information change notice including the new IP is forwarded to each node in the target link again.

[0100] Embodiments of the present disclosure can determine whether to update the database link of the target link based on different update results, so that the information in the database link is updated only after successful access, improving the maintenance efficiency and usage rationality of the database link.

[0101] In one embodiment, the information maintenance method further includes: in the case where the update result is the second update result, updating the information of the information change node in the link information library and the database link corresponding to each target link according to the updated node information.

[0102] In the embodiments of the present application, after obtaining the second update result, it can be determined based on the second update result that the information change of the information change node is effective. According to the updated node information, the information of the information change node in the link information library can be updated to the updated node information, and the information related to the information change node in the database link of each target link where the information change node is located in the link information library can be updated to the updated node information.

[0103] By updating the link information library after obtaining the second update result, embodiments of the present disclosure can make the information in the link information library synchronize with the information in the database link in real time, that is, the target link in the link information library is consistent with the actual situation, so as to obtain the correct target link every time the database link is maintained, improving the effectiveness of database link maintenance.

[0104] In one embodiment, the information maintenance method further includes: in the case where the update result is the first update result, performing an information reset process on the information change node to reset the node information of the information change node from the updated node information to the pre-updated node information.

[0105] In the embodiment of the present application, after obtaining the first update result, it can be determined based on the first update result that the information change of the information change node is invalid, and there is at least one target link in the target link where the information change node is located, and the calling node fails to access the called node. At this time, the information change node can be processed to reset the information, that is, the updated node information in the information change node is reset to the node information before the update. For example: when the information change node changes the password, the updated node information is the new password. After obtaining the first update result, the new password in the information change node is reset to the old password. When the information change node changes the IP, a database corresponding to the same information change node is established with the new IP, and the old IP database is retained. After obtaining the first update result, the new IP database is deleted and reset to the old IP database.

[0106] In the embodiment of the present disclosure, by resetting the information change node after obtaining the second update result, it is possible to prevent a target link where the calling node cannot access the called node through the updated node information, avoid affecting the services involved in the target link, and improve service stability.

[0107] It should be understood that although the steps in the flowcharts involved in the above-described embodiments are shown in sequence according to the arrows, these steps are not necessarily executed in the order indicated by the arrows. Unless there is a clear description in this article, the execution of these steps has no strict order limit, and these steps can be executed in other orders. Moreover, at least a part of the steps in the flowcharts involved in the above-described embodiments may include multiple steps or multiple stages. These steps or stages are not necessarily executed at the same time, but can be executed at different times. The execution order of these steps or stages is not necessarily sequential, but can be executed alternately or alternately with at least a part of other steps or steps or stages in other steps.

[0108] The embodiment of the present application also provides a maintenance system for a database link for implementing the information maintenance method involved above. The system includes: a control system, and a plurality of database nodes. The plurality of database nodes include a calling node and a called node, and the information change node is any one of the database nodes.

[0109] Among them, the control system is used to receive the information change notice sent by the information change node, determine the target link including the information change node from the link information library, and for any target link, forward the information change notice to each node in the target link. Among them, the target link includes a calling node, a database link node, and a called node, the information change node is any node in the target link, and the information change notice includes the updated node information. The calling node is used to respond to the information change notice, and access the called node according to the updated node information and the database link used to access the called node. The control system is also used to determine the update result for the information change node according to the access results of the called node fed back by the calling nodes in each target link, and update the database links corresponding to each target link according to the update result and the updated node information.

[0110] The control system may further include: a link information library and a change broadcast module. The link information library is used to record and store the node information of multiple database nodes and the information of database links. The change broadcast module is used to receive the information change notice sent by the information change node, determine the target link from the link information library according to the information change node, and forward the information change notice to each node in the target link.

[0111] The control system may further include: a consensus module and an automatic update module. The consensus module is used to receive the access results of the called node fed back by the calling nodes in each target link, and determine the update result for the information change node. When the update result indicates that the change of the information change node is valid, the consensus module may call the automatic update module, or when the update result indicates that the change of the information change node is invalid, notify the information change node to perform manual processing. The automatic update module is used to update the database link according to the updated node information.

[0112] It should be noted that for the process of the information maintenance system maintaining the database link in the embodiments of the present application, reference may be made to the relevant descriptions in the foregoing embodiments, and details are not described herein again.

[0113] The information maintenance system provided by the embodiments of the present application can, when any node in the target link undergoes information change, forward the information change notice to each node in the target link including the information change node, thereby triggering the calling node in the target link to use the updated node information and the database link used to access the called node to access the called node, so as to verify the validity of the updated node information in the information change node, obtain the corresponding update result, and then perform real-time database link maintenance based on the update result and the updated node information, which can improve the maintenance efficiency and usage rationality of the database link.

[0114] Based on the same inventive concept, an embodiment of the present application further provides an information maintenance device for implementing the information maintenance method involved above. The solution provided by this device for solving problems is similar to the solution described in the above method. Therefore, the specific limitations in one or more embodiments of the information maintenance device provided below can refer to the limitations on the information maintenance method in the above text, and will not be repeated here.

[0115] In one embodiment, referring to Figure 5 , an information maintenance device 500 is provided. The information maintenance device 500 includes:

[0116] An information receiving module 502, configured to receive an information change notice sent by an information change node, where the information change notice includes updated node information;

[0117] A link determination module 504, configured to determine a target link from a link information library according to the information change node, where the target link includes a calling node and a called node, and the information change node is any node in the target link;

[0118] An information notification module 506, configured to forward the information change notice to each node in the target link for any target link, so that the calling node, in response to the information change notice, accesses the called node according to the updated node information and the database link for accessing the called node;

[0119] An information update module 508, configured to determine an update result for the information change node according to the access result of the calling node to the called node in each target link, and update the database link corresponding to each target link according to the update result and the updated node information.

[0120] The information maintenance device provided by the embodiment of the present application can, when information changes in any node in the target link, forward the information change notice to each node in the target link including the information change node, thereby triggering the calling node in the target link to use the updated node information and the database link for accessing the called node to access the called node, so as to verify the validity of the updated node information in the information change node, obtain the corresponding update result, and then perform real-time database link maintenance based on the update result and the updated node information, which can improve the maintenance efficiency and usage rationality of the database link.

[0121] In one embodiment, the information notification module 506 is further configured to, when the information change node is the calling node, forward the information change notice to each node in the target link in the order from the calling node to the called node; or, when the information change node is the called node, forward the information change notice to each node in the target link in the order from the called node to the calling node.

[0122] In one embodiment, the information update module 508 is further configured to generate a first update result for indicating that the information change node change is invalid if there is at least one first access result in the access results for the called node feedback by the calling nodes in each target link, where the first access result is used to indicate that the calling node in the target link fails to access the called node; or, if the access results for the called node feedback by the calling nodes in each target link are all second access results, generate a second update result for indicating that the information change node change is valid, where the second access result is used to indicate that the calling node in the target link successfully accesses the called node.

[0123] In one embodiment, the information update module 508 is further configured to, when the update result is the second update result, update the information of the information change node in the database link corresponding to each target link according to the updated node information.

[0124] In one embodiment, the information maintenance device 500 further includes: an information storage module. The information storage module is configured to, when the update result is the second update result, update the information of the information change node in the link information library and the database link corresponding to each target link according to the updated node information.

[0125] In one embodiment, the information maintenance device 500 further includes: an information reset module. The information reset module is configured to, when the update result is the first update result, perform an information reset process on the information change node to reset the node information of the information change node from the updated node information to the node information before the update.

[0126] Each module in the above information maintenance device can be implemented in whole or in part by software, hardware, and their combination. The above modules can be embedded in or independent of the processor in the computer device in the form of hardware, or stored in the memory of the computer device in the form of software, so that the processor can call and execute the operations corresponding to the above modules.

[0127] In one embodiment, a computer device is provided. The computer device may be a server, and its internal structure diagram may be as Figure 6As shown. The computer device includes a processor, a memory, and a network interface connected via a system bus. Among them, the processor of the computer device is used 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, a computer program, and a database. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The database of the computer device is used to store target link information. The network interface of the computer device is used to communicate with an external terminal via a network connection. When the computer program is executed by the processor, it implements an information maintenance method.

[0128] Those skilled in the art can understand that Figure 6 the structure shown in is only a block diagram of some structures related to the solution of this application, and does not constitute a limitation on the computer device to which the solution of this application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine certain components, or have different component arrangements.

[0129] In one embodiment, a computer device is provided, including a memory and a processor. A computer program is stored in the memory. When the processor executes the computer program, the steps in the above method embodiments are implemented.

[0130] In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored. When the computer program is executed by the processor, the steps in the above method embodiments are implemented.

[0131] In one embodiment, a computer program product is provided, including a computer program. When the computer program is executed by the processor, the steps in the above method embodiments are implemented.

[0132] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data for analysis, stored data, displayed data, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties.

[0133] Those of ordinary skill in the art can understand that all or part of the processes in the methods of the above embodiments can be completed by instructing relevant hardware through a computer program. The computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above methods. Among them, any reference to a memory, database, or other medium used in the embodiments provided in the present application can include at least one of non-volatile and volatile memories. Non-volatile memory can include Read-Only Memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetoresistive random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. By way of illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM), etc. The databases involved in the embodiments provided in the present application can include at least one of relational databases and non-relational databases. Non-relational databases can include distributed databases based on blockchain, etc., without limitation. The processors involved in the embodiments provided in the present application can be general-purpose processors, central processing units, graphics processing units, digital signal processors, programmable logic devices, data processing logics based on quantum computing, etc., without limitation.

[0134] The technical features of the above embodiments can be combined arbitrarily. For the sake of concise description, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, it should be considered as the scope recorded in this specification.

[0135] The above-described embodiments only represent several implementation manners of the present application. The description is relatively specific and detailed, but it should not be construed as a limitation on the patent scope of the present application. It should be noted that for those of ordinary skill in the art, without departing from the concept of the present application, several modifications and improvements can still be made, and these all belong to the protection scope of the present application. Therefore, the protection scope of the present application should be subject to the appended claims.

Claims

1. An information maintenance method, characterized in that, The method includes: Receiving an information change notice sent by an information change node, where the information change notice includes updated node information; Determining a target link from a link information library according to the information change node, where the target link includes a calling node and a called node, and the information change node is any node in the target link; For any of the target links, forwarding the information change notice to each node in the target link, so that the calling node responds to the information change notice and accesses the called node according to the updated node information and a database link for accessing the called node; Determining an update result for the information change node according to the access results of the calling nodes in each target link for the called node, and updating the database links corresponding to each target link according to the update result and the updated node information, including: If there is at least one first access result among the access results of the calling nodes in each target link for the called node, generating a first update result for indicating that the change of the information change node is invalid, where the first access result is used to indicate that the calling node in the target link fails to access the called node; Or, if the access results of the calling nodes in each target link for the called node are all second access results, generating a second update result for indicating that the change of the information change node is valid, where the second access result is used to indicate that the calling node in the target link successfully accesses the called node; In the case where the update result is the second update result, performing an update process on the information of the information change node in the database links corresponding to each target link according to the updated node information; In the case where the update result is the second update result, updating the information of the information change node in the link information library and the database links corresponding to each target link according to the updated node information; In the case where the update result is the first update result, performing an information reset process on the information change node to reset the node information of the information change node from the updated node information to the node information before the update; 2. The information maintenance method according to claim 1, characterized in that The forwarding the information change notice to each node in the target link includes: In the case where the information change node is the calling node, forwarding the information change notice to each node in the target link in the order from the calling node to the called node; Or, in the case where the information change node is the called node, forwarding the information change notice to each node in the target link in the order from the called node to the calling node.

3. An information maintenance system, characterized in that, The system includes: a control system, and multiple database nodes, where the multiple database nodes include a calling node and a called node, and the information change node is any node in the database nodes; Among them, the control system is used to receive the information change notice sent by the information change node, determine the target link including the information change node from the link information library, and forward the information change notice to each node in the target link for any one of the target links. Among them, the target link includes the calling node and the called node, the information change node is any node in the target link, and the information change notice includes the updated node information; The calling node is used to respond to the information change notice, and access the called node according to the updated node information and the database link used to access the called node; The control system is further used to determine the update result for the information change node according to the access results of the calling nodes in each target link for the called node, and update the database links corresponding to each target link according to the update result and the updated node information; The control system is further used to generate a first update result for characterizing that the information change of the information change node is invalid if there is at least one first access result in the access results of the calling nodes in each target link for the called node, where the first access result is used to characterize that the calling node in the target link fails to access the called node; or, if the access results of the calling nodes in each target link for the called node are all second access results, generate a second update result for characterizing that the information change of the information change node is effective, where the second access result is used to characterize that the calling node in the target link successfully accesses the called node; The control system is further used to, when the update result is the second update result, update the information of the information change node in the database links corresponding to each target link according to the updated node information; when the update result is the second update result, update the information of the information change node in the link information library and the database links corresponding to each target link according to the updated node information; when the update result is the first update result, perform an information reset process on the information change node to reset the node information of the information change node from the updated node information to the node information before the update.

4. An information maintenance device, characterized in that, The device includes: An information receiving module, configured to receive an information change notice sent by an information change node, where the information change notice includes updated node information; A link determination module, configured to determine a target link from the link information library according to the information change node, where the target link includes a calling node and a called node, and the information change node is any node in the target link; An information notification module, which is configured to forward the information change notification to each node in the target link for any of the target links, so that the calling node accesses the called node in response to the information change notification according to the updated node information and the database link used to access the called node; An information update module, which is configured to determine the update result for the information change node according to the access results of the called node fed back by the calling nodes in each of the target links, and update the database links corresponding to each of the target links according to the update result and the updated node information; The information update module is further configured to generate a first update result for characterizing that the information change node change is invalid if there is at least one first access result among the access results of the called node fed back by the calling nodes in each of the target links, where the first access result is used to characterize that the calling node in the target link fails to access the called node; or, if the access results of the called node fed back by the calling nodes in each of the target links are all second access results, generate a second update result for characterizing that the information change node change is valid, where the second access result is used to characterize that the calling node in the target link successfully accesses the called node; The information update module is further configured to, when the update result is the second update result, update the information of the information change node in the database links corresponding to each of the target links according to the updated node information; The device further includes: an information storage module, and the information storage module is configured to, when the update result is the second update result, update the information of the information change node in the link information library and the database links corresponding to each of the target links according to the updated node information; The device further includes: an information reset module, and the information reset module is configured to perform an information reset process on the information change node when the update result is the first update result, so as to reset the node information of the information change node from the updated node information to the node information before the update.

5. A computer device, comprising a memory and a processor, the memory storing a computer program, characterized in that, When the processor executes the computer program, the steps of the method according to claim 1 or 2 are implemented.

6. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by the processor, the steps of the method according to claim 1 or 2 are implemented.

7. A computer program product, comprising a computer program, characterized in that, When the computer program is executed by the processor, the steps of the method according to claim 1 or 2 are implemented.

Citation Information

Patent Citations

  • Method and device for updating and maintaining database

    CN106126531A

  • Configuration information processing method, system, computer device and storage medium

    CN108599971A