Remote management method and device for battery swap station database and medium

Abstract

The invention discloses a remote management method and device for a battery swap station database, and a medium, and is used for solving the problem that the workload of operation and maintenance personnel is increased when the database is manually managed in the prior art due to distance limitation and large business volume. The method comprises the following steps of: auditing a database management work order submitted by a user and determining a battery swap station database requested by the database management work order under the condition that the auditing is passed; obtaining mapping information of the battery swap station database, and determining a corresponding database extranet address and a port number; according to the database extranet address and the port number corresponding to the battery swap station database, access to the battery swap station database is achieved, and according to the database management work order, remote management of the battery swap station database is achieved. According to the invention, remote management of the battery swap station database can be realized, field processing is not needed, the operation and maintenance efficiency is improved, the workload of operation and maintenance personnel is reduced, and normal operation of database service is ensured.

Description

[0001] This application claims priority based on the invention patent application titled "A Remote Management Method, Device, and Medium for a Battery Swap Station Database" with the application number 202311869803.6, which was filed with the China National Intellectual Property Administration on December 29, 2023. This application incorporates the entire text of the above-mentioned Chinese patent application by reference. Technical Field

[0002] This application relates to the technical field of database management, and particularly to a remote management method, device, and medium for a battery swap station database. Background Art

[0003] Currently, with the popularization of electric vehicles and the rapid construction of battery swap stations, the business volume of battery swap stations is increasing rapidly. This growth has brought a large number of data exchange and storage requirements, increasing the load on the database. At the same time, due to the wide distribution of battery swap stations across different regions, the failure rate of the database has also increased.

[0004] The traditional operation and maintenance method is for operation and maintenance personnel to handle problems on-site. However, due to geographical distance limitations, this method cannot respond to and handle all problems in a timely manner. In addition, with the increasing business volume of battery swap stations across the country, the load on the database is getting higher and higher, the risks are increasing, and the workload of operation and maintenance personnel is also constantly increasing, making it impossible to ensure the normal operation of the service. Summary of the Invention

[0005] Embodiments of this application provide a remote management method, device, and medium for a battery swap station database to solve the technical problems that the existing database operation and maintenance method, which generally relies on manual on-site processing, is not only limited by distance but also increases the workload of operation and maintenance personnel in the case of large business volume, making it impossible to ensure the normal operation of the service.

[0006] On the one hand, embodiments of this application provide a remote management method for a battery swap station database, including:

[0007] Review the database management work order submitted by the user, and determine the battery swap station database requested by the database management work order when the review is passed;

[0008] Obtain the mapping information of the battery swap station database to determine the corresponding database external network address and port number;

[0009] Access the battery swap station database according to the database external network address and port number corresponding to the battery swap station database, and perform remote management of the battery swap station database according to the database management work order.

[0010] A remote management method for a swap station database provided by an embodiment of the present application can accurately determine the corresponding external network address and port number of the database based on the obtained mapping information of the swap station database, ensuring that the system can accurately find and access the target database and avoiding access failures caused by incorrect addresses or ports. Through the system, operation and maintenance personnel can remotely manage the swap station database without on-site processing, improving operation and maintenance efficiency, reducing the workload of operation and maintenance personnel, and ensuring the normal operation of the database service at the same time. The entire process is almost completely automated, and no manual intervention is required from user login verification to database management work order review, and then to database access and remote management, reducing the work pressure of operation and maintenance personnel and also reducing the possibility of human errors.

[0011] In one implementation manner of the present application, the obtaining the mapping information of the swap station database to determine the corresponding external network address and port number of the database specifically includes:

[0012] Determine whether the swap station database corresponding to the database management work order exists on the archery database management tool;

[0013] If so, obtain the mapping information of the swap station database on the archery database management tool to determine the corresponding external network address and port number.

[0014] In one implementation manner of the present application, before obtaining the mapping information of the swap station database on the archery database management tool, the method further includes:

[0015] Based on the archery database management tool, receive a login request initiated by a user, and determine the account password in the login request, so as to query the preset access control list in the archery database management tool according to the account password to perform identity verification on the user;

[0016] For a user whose identity verification is successful, obtain the corresponding IP address and determine whether the IP address belongs to the permitted access range of the archery database management tool;

[0017] When the user's IP address belongs to the permitted access range, encrypt the user's login request and the response data transmission process corresponding to the login request based on a preset encryption method, and allow the user to log in to the archery database management tool.

[0018] In the embodiments of the present application, a specially designed database management tool is used to obtain and verify the login request initiated by the user, query the preset access control list according to the account password, and perform identity verification on the user, which can ensure that only authorized users can access the system, enhance the security of the system, and prevent unauthorized access. For users who pass the identity verification, the system will obtain the corresponding IP address, and only the IP addresses belonging to the allowed access range can access the system, further protecting the security of user data. When the user's IP address belongs to the allowed access range, the system will encrypt the user's login request and the transmission process of the response data corresponding to the login request, which ensures the security of the data during the transmission process and prevents the data from being stolen or tampered with. Encrypting the user's login request and response data through the preset encryption method can reduce the concerns and worries of users when using the system. At the same time, it also improves the trust of the system and the satisfaction of users. By verifying the user's identity and restricting the IP address, the risk of the system being maliciously attacked or accessed without authorization can be reduced, enhancing the reliability and stability of the system, and ensuring that the system can run continuously and stably.

[0019] In one implementation manner of the present application, the method for reviewing the database management work order submitted by the user and determining the swap station database requested by the database management work order when the review is passed specifically includes:

[0020] Based on the archery database management tool, receive the database management work order submitted by the user and determine the work order type corresponding to the database management work order; the work order type includes a business work order and an optimization work order;

[0021] According to the corresponding work order type, determine the review procedure corresponding to the database management work order, and review the database management work order sequentially according to the review procedure;

[0022] Send the review notice to the corresponding management personnel in a preset manner, and record the review process of the database management work order to generate a review report corresponding to the database management work order;

[0023] When the review report is a passed review, execute the database management work order with a passed review for testing, and when the test is successful, determine the swap station database requested by the database management work order.

[0024] The embodiments of the present application can automatically receive database management work orders submitted by users and determine corresponding review procedures according to the work order types, making the work order processing more efficient, reducing manual intervention and the possibility of errors; determining corresponding review procedures according to the work order types and reviewing the work orders according to the procedures can ensure the accuracy and integrity of the work orders, improving the accuracy and credibility of the review; sending review notifications to the corresponding management personnel in a preset manner enables the management personnel to timely understand the review situation of the work orders, improving work efficiency and response speed; recording the review process of the database management work orders to generate corresponding review reports enables the processing process of the work orders to be documented, facilitating subsequent traceability and auditing; in the case of successful testing, the swap station database requested by the database management work order can be determined, making the management of the database more accurate and efficient, and reducing the time and cost for searching and locating the database.

[0025] In an implementation manner of the present application, determining whether the swap station database corresponding to the database management work order exists on the archery database management tool specifically includes:

[0026] Determining the preset accessible database list in the archery database management tool and querying the swap station database corresponding to the database management work order based on the preset accessible database list;

[0027] In the case that the swap station database corresponding to the database management work order does not exist in the accessible database list, determining that there is a data error in the database management work order and downloading the backup script corresponding to the database management work order;

[0028] Performing data rollback according to the backup script until the swap station database corresponding to the database management work order exists in the preset accessible database list, and sending the database management work order to the corresponding swap station database.

[0029] In the embodiment of the present application, by querying the substation database corresponding to the database management work order through a preset list of accessible databases, it is ensured that the database requested by the work order is accurate and reliable, avoiding potential problems caused by data errors; in the case where the substation database corresponding to the work order does not exist in the list of accessible databases, the system will download a backup script and perform a data rollback operation, ensuring the integrity and consistency of the data, and avoiding potential risks caused by data loss or damage; it can handle data error situations, ensure the normal operation of the system by downloading a backup script and performing a data rollback operation, improve the fault tolerance and stability of the system, and reduce system failures caused by data errors; it can perform a data rollback according to the backup script until the substation database corresponding to the work order exists in the preset list of accessible databases, enabling users to quickly and accurately access the required database, improving the user experience and satisfaction.

[0030] In one implementation manner of the present application, if so, based on the mapping information on the archery database management tool, the corresponding database external network address and port number are determined, specifically including:

[0031] In the case where the substation database exists in the preset list of accessible databases, it is continued to determine whether there is mapping information corresponding to the substation database on the archery database management tool;

[0032] If so, the database external network address and port number corresponding to the substation database are determined based on the mapping information, and the database external network address and port number are verified to determine that the database external network address and port number match the substation database.

[0033] In the embodiment of the present application, in the case where the substation database exists in the preset list of accessible databases, the system will continue to determine whether there is corresponding mapping information, ensuring the accuracy and reliability of data access, and avoiding access failures caused by incorrect mapping information; by determining the database external network address and port number based on the mapping information and verifying this information, it can be ensured that the database accessed by the system matches the expected database, enhancing the stability and reliability of the system, and avoiding access anomalies caused by incorrect addresses or ports; by verifying the database external network address and port number, potential security threats and attacks can be prevented, ensuring the security of system access, protecting the security of user data and the system; by accurately determining and verifying the database external network address and port number, users can access the required database more smoothly, improving the user experience and satisfaction.

[0034] In one implementation manner of the present application, the access to the substation database is realized according to the database external network address and port number corresponding to the substation database, specifically including:

[0035] Find the corresponding swap station database based on the external network address of the swap station database, and establish a data connection with the swap station database based on the port number corresponding to the swap station database;

[0036] Encrypt the database management work order, and send the encrypted database management work order to the swap station database based on the established data connection;

[0037] Receive the encrypted database management work order through the swap station database, and perform a decryption operation on the database management work order to access the swap station database in response to the decrypted database management work order.

[0038] In the embodiment of the present application, by finding the corresponding swap station database and establishing a data connection with the database, remote access to the swap station database is realized, enabling users and managers to conveniently manage and operate the database, improving work efficiency and flexibility; by encrypting the database management work order, the security of data during transmission can be protected, preventing data from being stolen or tampered with. At the same time, decrypting the database management work order at the receiving end ensures the integrity and accuracy of the data; through encryption and decryption operations, the integrity and consistency of the data can be ensured, avoiding potential problems caused by data errors or damage, enhancing the reliability and stability of the system, and ensuring the normal operation of the system; through remote access and encryption and decryption operations on the database management work order, users can access and manage the database more conveniently and securely, improving user experience and satisfaction, and enhancing users' trust in the system.

[0039] In an implementation manner of the present application, the remote management of the swap station database according to the database management work order specifically includes:

[0040] Determine the database change script corresponding to the database management work order, and determine whether the user has the change permission corresponding to the database change script;

[0041] If the user has the change permission, trigger the execution of the database change script based on the access to the swap station database to realize the remote management of the swap station database.

[0042] In the embodiment of the present application, the database change script corresponding to the database management work order is first determined, and it is checked whether the user has the corresponding change permission, ensuring that only users with permissions can perform change operations on the database, enhancing the security of the system; when the user has the change permission, the system will automatically execute the database change script triggered by the access to the swap station database, simplifying the change management process of the database, improving work efficiency, and reducing the possibility of human errors; by automatically executing the database change script, it can be ensured that the data change operations are accurate and error-free, avoiding errors or inconsistencies caused by manual operations, and ensuring the data consistency and integrity of the database; by automatically executing the database change script, users can manage the database more conveniently without manually performing complex change operations, improving the user experience and satisfaction, and enhancing the user's trust in the system.

[0043] In one implementation manner of the present application, after implementing remote management of the swap station database according to the database management work order, the method further includes:

[0044] Obtain the data change result corresponding to the database management work order, and return the data change result to the archery database management tool through the external network port corresponding to the swap station database;

[0045] Through the archery database management tool, determine whether the swap station database has completed the change corresponding to the database management work order according to the data change result, and send the change situation of the swap station database to the corresponding user in response to the user.

[0046] The embodiment of the present application will obtain the data change result corresponding to the database management work order and return the data change result to the archery database management tool in real time through the external network port corresponding to the swap station database, enabling users to timely understand the result of the database change, improving the transparency and response speed of the system; it can send the change situation of the swap station database to the corresponding user, enabling the user to timely understand the change situation of the database and make corresponding operations, enhancing the user experience and satisfaction, and enabling the user to better interact and cooperate with the system; by real-time feedback of the data change result and sending the change situation of the swap station database to the user, the system can better monitor and manage the database change operations, improving the reliability and stability of the system, reducing potential problems and errors, and providing a more efficient, transparent, and reliable database management experience for users and managers by real-time feedback of the change result, improving work efficiency, enhancing the user experience, and improving the system reliability.

[0047] On the other hand, the embodiment of the present application further provides a remote management device for a swap station database, and the device includes:

[0048] An auditing module, configured to audit a database management work order submitted by a user, and determine a swap station database requested by the database management work order in the case of passing the audit;

[0049] A mapping module, configured to obtain mapping information of the swap station database to determine a corresponding external network address and port number of the database;

[0050] A management module, configured to access the swap station database according to the external network address and port number of the swap station database, and perform remote management of the swap station database according to the database management work order.

[0051] On the other hand, an embodiment of the present application further provides an electronic device, including:

[0052] At least one processor;

[0053] And a memory communicatively connected to the at least one processor;

[0054] Wherein, the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor to enable the at least one processor to execute the remote management method of the swap station database as described in any one of the above.

[0055] On the other hand, an embodiment of the present application further provides a non-volatile computer storage medium, storing computer-executable instructions, and the computer implements the remote management method of the swap station database as described in any one of the above when executing the executable instructions. BRIEF DESCRIPTION OF THE DRAWINGS

[0056] The drawings described herein are used to provide a further understanding of the present application, and constitute a part of the present application. The illustrative embodiments and descriptions thereof of the present application are used to explain the present application, and do not constitute an improper limitation of the present application. In the drawings:

[0057] Figure 1 It is a schematic flowchart of a remote management method of a swap station database provided by an embodiment of the present application;

[0058] Figure 2 It is a schematic internal structure diagram of a remote management device of a swap station database provided by an embodiment of the present application;

[0059] Figure 3 It is a schematic internal structure diagram of an electronic device provided by an embodiment of the present application. DETAILED DESCRIPTION

[0060] To make the objectives, technical solutions, and advantages of this application more clear, the technical solutions of this application will be clearly and completely described below in conjunction with specific embodiments of this application and the corresponding drawings. Obviously, the described embodiments are only a part of the embodiments of this application, rather than all the embodiments. All other embodiments obtained by those of ordinary skill in the art based on the embodiments in this application without creative efforts shall fall within the scope of protection of this application.

[0061] The embodiments of this application provide a method, device, and medium for remote management of a swap station database, aiming to solve the technical problem that the existing database operation and maintenance method generally using on-site manual processing is not only limited by distance, but also increases the workload of operation and maintenance personnel in the case of large business volume, and cannot ensure the normal operation of services.

[0062] The following will, in conjunction with the drawings, elaborate on the technical solutions provided by each embodiment of this application.

[0063] Figure 1 It is a schematic flowchart of a method for remote management of a swap station database provided by an embodiment of this application.

[0064] The implementation of the analysis method involved in the embodiments of this application can be a terminal device or a server, and this application does not make special restrictions on this. For the convenience of understanding and description, the following embodiments will be described in detail using a server as an example.

[0065] It should be noted that this server can be a single device or a system composed of multiple devices, that is, a distributed server, and this application does not make specific limitations on this.

[0066] As Figure 1 shown, a method for remote management of a swap station database provided by an embodiment of this application includes:

[0067] 101. Review the database management work order submitted by the user, and determine the swap station database requested by the database management work order in the case of passing the review.

[0068] After the user logs in, a database management work order is submitted. After receiving the work order, it is necessary to review the work order. The review process can include checking the integrity, accuracy, and compliance with corresponding regulations of the work order, etc. If the review passes, determine the swap station database requested by the database management work order.

[0069] In an embodiment of the present application, the user submits a database management work order through a database management tool, and after receiving the work order, starts to determine the work order type. Specifically, according to the content and nature of the work order, the work order type is determined, and the work order types include business work orders and optimization work orders. Business work orders mainly involve business operations and data changes, while optimization work orders may involve database performance optimization, data structure adjustment, etc.

[0070] When reviewing the content of the work order, it is necessary to carefully examine the information provided in the work order, including the operations to be performed, the content of the swap station database involved, etc., to ensure that the work order content complies with the regulations and meets the permission requirements.

[0071] Then, according to the determined work order type, the corresponding review procedure is determined, and the database management work order is reviewed step by step according to the review procedure. At the same time, during the review process, the server will record the review process and generate a review report. Furthermore, the review notice is sent to the corresponding management personnel through a preset method (such as email, text message, etc.).

[0072] And, if further verification is needed, the superior supervisor or relevant department can also be contacted for confirmation to ensure the accuracy of the review result. After the review is completed, it is necessary to record the review result and conclusion, and notify the user of the corresponding review result.

[0073] After receiving the notice, the management personnel will further review or approve the database management work order, and thus generate a review report according to the review result, recording the review process and result. If the review report is passed, the server starts to execute the database management work order that has passed the review for testing. During the testing process, the server ensures the correctness of the work order and its impact on the database, ensuring that there are no errors or side effects. If the test is successful, the server determines the swap station database requested by the database management work order and prepares for subsequent remote management operations.

[0074] It can be understood that through the above embodiments, the accuracy and security of the database management work order can be ensured, and errors and risks can be reduced. At the same time, through strict review and testing processes, the stability and reliability of the server can be ensured, and work efficiency and quality can be improved.

[0075] 102. Obtain the mapping information of the swap station database to determine the corresponding database external network address and port number.

[0076] The server obtains the mapping information corresponding to the swap station database and determines the corresponding database external network address and port number according to the preset mapping information.

[0077] In an embodiment of the present application, the server determines whether there is a swapping station database corresponding to the work order on the database management tool by means of querying or matching. If there is a corresponding swapping station database, the mapping information of the swapping station database is obtained on the archery database management tool to determine the corresponding external network address and port number of the database.

[0078] It should be noted that the swapping station database is configured by the archery database management tool, so the mapping information corresponding to the swapping station database can be obtained from the archery database management tool.

[0079] In an embodiment of the present application, in order to avoid the risk of malicious attacks on remote management, before obtaining the mapping information of the swapping station database on the archery database management tool, the user identity verification is started. First, the server receives the login request initiated by the user based on the archery database management tool, and queries the preset access control list in the database management tool according to the account password in the login request. The access control list may contain the account password and the corresponding identity information. If it exists, the user is verified based on this information. If the identity verification is successful, it means that the user is legal and the next operation can be carried out.

[0080] For the user whose identity verification is successful, continue to obtain the IP address corresponding to the user and determine whether the IP address belongs to the allowed access range of the database management tool. If the IP address is within the allowed access range, it means that the user can access the database management tool. After confirming that the user's IP address belongs to the allowed access range, a preset encryption method is used to encrypt the user's login request and the data transmission process corresponding to the login request response. Through encryption, the security of the data during transmission can be ensured, preventing the data from being stolen or tampered with. After the encryption process, the user is allowed to log in to the database management tool and provided with corresponding permissions and functions.

[0081] It should be noted that the preset encryption method in the embodiments of the present application can be to establish a secure channel by using the SSL / TLS protocol to ensure encryption during the communication process between the client and the server, thereby preventing data from being stolen or tampered with during transmission. In the SSL / TLS protocol, digital certificates are used to authenticate both communication parties to ensure that the identities of both parties are legal and trustworthy, preventing man-in-the-middle attacks. After establishing a secure channel, a symmetric encryption algorithm (such as AES) can be used to encrypt the data to ensure the confidentiality of the data during transmission. This can ensure that only authorized users can access the database remote management system, restrict user permissions through authentication and authorization mechanisms, and prevent unauthorized user access. At the same time, regular audits and inspections of the security measures of the remote management system are also required to promptly discover and repair possible security vulnerabilities.

[0082] It can be understood that through the above embodiments, the security of the database management tool can be enhanced, ensuring that only legitimate users can access the server corresponding to the archery database management tool and protecting the security of data during transmission. At the same time, through a strict identity verification and IP address verification mechanism, the stability and reliability of the server corresponding to the archery database management tool are ensured.

[0083] In an embodiment of the present application, the server first determines the preset accessible database list in the database management tool. The accessible database list may include information such as the names, addresses, and ports of multiple databases. The server queries whether there is a corresponding swap station database in the accessible database list according to the content and requirements of the database management work order, and prepares for subsequent operations when the corresponding swap station database is found in the accessible database list.

[0084] If the corresponding swap station database is not found in the accessible database list, the server will determine that there is a data error in the database management work order. To solve this data error, it is necessary to start downloading the backup script corresponding to the database management work order. Then, according to the backup script, a data rollback operation is started. The goal of the data rollback is to ensure that there is a corresponding swap station database in the accessible database list. During the data rollback process, the server may perform a series of data repair and adjustment operations to ensure the integrity and consistency of the data.

[0085] After there is a corresponding swap station database in the accessible database list, the server sends the database management work order to the corresponding swap station database. The sending process may include transmitting the work order data to the swap station database and ensuring the correct execution of the work order in the database.

[0086] Moreover, when there is a swapping station database in the preset list of accessible databases, the server will continue to determine whether there is mapping information corresponding to the swapping station database on the database management tool. It should be noted that the mapping information in the embodiments of the present application may include connection information such as the IP address, port number, username, password, etc. of the database.

[0087] If there is corresponding mapping information on the database management tool, the server will determine the external network address and port number of the database corresponding to the swapping station database based on this mapping information, and these addresses and port numbers are used for subsequent database access and remote management operations. To ensure the accuracy of the external network address and port number of the database, the server also needs to verify them. The verification process may include ways such as confirming with the database administrator and querying the database configuration file to ensure that the provided addresses and port numbers match the actual database configuration. After passing the verification, the server determines that the external network address and port number match the swapping station database. If the address and port number do not match the database, the server may prompt an error or perform further adjustment operations.

[0088] It can be understood that through the above embodiments, it can be ensured that the external network address and port number of the database used match the actual database configuration, reducing errors and potential security risks. At the same time, through the mapping information and verification steps, the stability and reliability of the server can be improved, ensuring the smooth progress of remote management operations.

[0089] 103. Implement access to the swapping station database according to the external network address and port number of the database corresponding to the swapping station database, and implement remote management of the swapping station database according to the database management work order.

[0090] According to the determined external network address and port number of the database, the server can implement access to the swapping station database. Through the access, the server implements remote management of the swapping station database according to the database management work order, including operations such as data query, modification, and update, so that users can monitor and manage the status and data of the swapping station database in real time through the database management tool.

[0091] Specifically, in an embodiment of the present application, the server can find the corresponding battery swapping station database according to the external network address and port number of the battery swapping station database, and based on the found battery swapping station database, the server establishes a data connection with the database. After establishing a good data connection with the battery swapping station database, the server encrypts the database management work order. The encryption process may use a preset encryption algorithm or key to ensure the security of the database management work order during the transmission process. Based on the established data connection, the server sends the encrypted database management work order to the battery swapping station database. The sending process may include sending the encrypted data packet to the database and ensuring the integrity of the data packet during the transmission process.

[0092] The battery swapping station database receives the encrypted database management work order, and after receiving the data, the battery swapping station database decrypts the encrypted database management work order. The decryption process uses a decryption algorithm or key corresponding to the encryption algorithm to ensure the integrity and readability of the data. Furthermore, after the battery swapping station database decrypts, it responds to the decrypted database management work order, and according to the content of the responded work order, the battery swapping station database performs corresponding operations to achieve access and remote management of the database.

[0093] It can be understood that through the above embodiments, the security of the database management work order during the transmission process can be ensured, preventing data from being stolen or tampered with. At the same time, through the encryption and decryption operations, the confidentiality and integrity of the data can be protected, improving the security of the server. In addition, through the response and access operations, the remote management function can be realized to meet the needs of users.

[0094] In an embodiment of the present application, the server determines the corresponding database change script according to the content and requirements of the database management work order. The database change script may include operation instructions such as adding, deleting, modifying, and querying the database. After determining the database change script, it is necessary to check whether the user has the corresponding change permission. The user permission may be determined based on roles, role groups, or other permission management mechanisms.

[0095] If the user has the change permission, then based on the trigger of accessing the battery swapping station database, the database change script is executed. The execution process may include sending the change script to the battery swapping station database and executing the corresponding operation instructions in the database. By executing the database change script, the remote management of the battery swapping station database can be realized. The remote management operations may include data update, data query, data deletion, etc. operations to meet the needs of users.

[0096] It can be understood that through the above embodiments, it can be ensured that only users with corresponding permissions can perform remote management operations on the swap station database, ensuring the security and stability of the server. At the same time, through the execution of the database change script, precise control and operation of the swap station database can be achieved, improving work efficiency and quality.

[0097] In an embodiment of the present application, after the server remotely manages the swap station database according to the database management work order, it obtains the data change result corresponding to the database management work order from the swap station database. The data change result may include information such as whether the change operation is successful and the content of the changed data, and returns the data change result to the database management tool through the external network port corresponding to the swap station database. The return process may include sending the data change result to the database management tool and displaying it to the user in the tool.

[0098] After receiving the data change result, the database management tool determines whether the swap station database has completed the change corresponding to the database management work order based on these results. If the change is successful, the database management work order will be marked as the completed state. The database management tool sends the change situation of the swap station database to the corresponding user. The sending method may include email notification, SMS notification, or the notification function within the tool. After receiving the notification, the user can understand the change situation of the database and perform subsequent operations or confirmations.

[0099] It can be understood that through the above embodiments, the server can timely feedback the change situation of the database to the user, enabling the user to understand and confirm the change status of the database. At the same time, through the response function of the tool, the interactivity of the server and the user experience can be improved.

[0100] The above is the method embodiment proposed by the present application. Based on the same inventive concept, the embodiments of the present application also provide a remote management device for a swap station database, the structure of which is as Figure 2 shown.

[0101] Figure 2 is the internal structure schematic diagram of a remote management device for a swap station database provided by an embodiment of the present application. As Figure 2 shown, the device includes:

[0102] An audit module 201, configured to audit the database management work order submitted by the user, and determine the swap station database requested by the database management work order when the audit is passed;

[0103] A mapping module 202, configured to obtain the mapping information of the swap station database to determine the corresponding database external network address and port number;

[0104] The management module 203 is used to access the swap station database according to the external network address and port number corresponding to the swap station database, and to remotely manage the swap station database according to the database management work order.

[0105] Figure 3 The following is a schematic internal structure diagram of an electronic device provided by an embodiment of the present application. As Figure 3 shown, the device includes:

[0106] At least one processor;

[0107] And a memory communicatively connected to the at least one processor;

[0108] Wherein, the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor so that the at least one processor can execute the remote management method of the swap station database described in any of the above embodiments.

[0109] In an embodiment of the present application, the above-mentioned processor can execute: review the database management work order submitted by the user, and determine the swap station database requested by the database management work order when the review is passed;

[0110] Obtain the mapping information of the swap station database to determine the corresponding external network address and port number of the database;

[0111] Access the swap station database according to the external network address and port number corresponding to the swap station database, and remotely manage the swap station database according to the database management work order.

[0112] An embodiment of the present application also provides a non-volatile computer storage medium storing computer-executable instructions, and the computer can execute the remote management method of the swap station database described in any of the above embodiments when executing the executable instructions.

[0113] In an embodiment of the present application, the above-mentioned computer can execute: review the database management work order submitted by the user, and determine the swap station database requested by the database management work order when the review is passed;

[0114] Obtain the mapping information of the swap station database to determine the corresponding external network address and port number of the database;

[0115] Access the swap station database according to the external network address and port number corresponding to the swap station database, and remotely manage the swap station database according to the database management work order.

[0116] Each embodiment in this application is described in a progressive manner. For the same or similar parts among the embodiments, reference can be made to each other. Each embodiment focuses on the differences from other embodiments. In particular, for the device and medium embodiments, since they are basically similar to the method embodiments, the description is relatively simple. For the relevant parts, reference can be made to the partial description of the method embodiments.

[0117] The above describes specific embodiments of this application. Other embodiments are within the scope of the appended claims. In some cases, the actions or steps recited in the claims can be executed in a different order than in the embodiments and still achieve the desired result. Additionally, the processes depicted in the figures do not necessarily require the specific order or sequential order shown to achieve the desired result. In certain embodiments, multitasking and parallel processing are also possible or may be advantageous.

[0118] The devices and media provided in the embodiments of this application correspond one-to-one with the methods. Therefore, the devices and media also have beneficial technical effects similar to those of their corresponding methods. Since the beneficial technical effects of the methods have been described in detail above, the beneficial technical effects of the devices and media will not be elaborated here.

[0119] Those skilled in the art should understand that the embodiments of this application can be provided as methods, systems, or computer program products. Therefore, this application can take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware aspects. Moreover, this application can take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0120] This application is described with reference to the flowcharts and / or block diagrams of methods, devices (systems), and computer program products according to the embodiments of this application. It should be understood that each flow and / or block in the flowcharts and / or block diagrams, as well as the combination of flows and / or blocks in the flowcharts and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to the processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to generate a machine, such that the instructions executed by the processor of the computer or other programmable data processing device produce means for implementing the functions specified in Figure 1 one or more of the flows or multiple flows and / or blocks Figure 1 one or more of the blocks or multiple blocks.

[0121] These computer program instructions can also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to operate in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including an instruction means that implements the functions specified in one or more of the flows Figure 1 one or more flows and / or blocks Figure 1 specified in one or more of the blocks or blocks.

[0122] These computer program instructions can also be loaded onto a computer or other programmable data processing apparatus, such that a series of operational steps are performed on the computer or other programmable apparatus to produce a computer-implemented process, whereby the instructions executed on the computer or other programmable apparatus provide steps for implementing the functions specified in one or more of the flows Figure 1 one or more flows and / or blocks Figure 1 specified in one or more of the blocks or blocks.

[0123] In a typical configuration, a computing device includes one or more processors (CPUs), an input / output interface, a network interface, and memory.

[0124] The memory may include non-permanent memory in the computer-readable medium, in the form of random access memory (RAM) and / or non-volatile memory such as read-only memory (ROM) or flash memory (flash RAM). Memory is an example of a computer-readable medium.

[0125] Computer-readable media includes permanent and non-permanent, removable and non-removable media that can be implemented by any method or technology for storing information. The information can be computer-readable instructions, data structures, program modules, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technologies, compact disc read-only memory (CD-ROM), digital versatile disc (DVD) or other optical storage, magnetic cassette tapes, magnetic disk storage or other magnetic storage devices, or any other non-transmission media that can be used to store information that can be accessed by a computing device. As defined herein, computer-readable media does not include transitory computer-readable media such as modulated data signals and carrier waves.

[0126] It should also be noted that the term "including", "comprising" or any other variant thereof is intended to cover non-exclusive inclusion, so that a process, method, commodity or device including a series of elements not only includes those elements, but also includes other elements not expressly listed, or further includes elements inherent to such process, method, commodity or device. Without further limitation, an element defined by the statement "including one..." does not exclude the existence of additional identical elements in the process, method, commodity or device including said element.

[0127] The above are only embodiments of the present application and are not used to limit the present application. For those skilled in the art, various changes and modifications can be made to the present application. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application shall be included within the scope of the claims of the present application.

Claims

1. A remote management method for a battery swapping station database, characterized in that, The method includes: Review the database management work order submitted by the user, and if the review is passed, determine the swap station database requested by the database management work order; Obtain the mapping information of the swap station database to determine the corresponding database external network address and port number; Based on the database external network address and port number corresponding to the swap station database, access the swap station database, and based on the database management work order, remotely manage the swap station database.

2. The remote management method of a swap station database according to claim 1, characterized in that, The obtaining the mapping information of the swap station database to determine the corresponding database external network address and port number specifically includes: Determine whether the swap station database corresponding to the database management work order exists on the archery database management tool; If so, obtain the mapping information of the swap station database on the archery database management tool to determine the corresponding database external network address and port number.

3. The remote management method of a swapping station database according to claim 2, characterized in that, Before obtaining the mapping information of the swap station database on the archery database management tool, the method further includes: Based on the archery database management tool, receive the login request initiated by the user, and determine the account password in the login request, and query the preset access control list in the archery database management tool according to the account password to authenticate the user; For a user whose identity verification is successful, obtain the corresponding IP address, and determine whether the IP address belongs to the allowed access range of the archery database management tool; If the user's IP address belongs to the allowed access range, encrypt the user's login request and the response data transmission process corresponding to the login request based on a preset encryption method, and allow the user to log in to the archery database management tool.

4. A remote management method for a swap station database according to claim 1, characterized in that, The reviewing the database management work order submitted by the user, and if the review is passed, determining the swap station database requested by the database management work order specifically includes: Receive the database management work order submitted by the user, and determine the work order type corresponding to the database management work order; the work order type includes business work orders and optimization work orders; According to the corresponding work order type, determine the review procedure corresponding to the database management work order, and review the database management work order in sequence according to the review procedure; Send the review notice to the corresponding management personnel through a preset method, and record the review process of the database management work order to generate a review report corresponding to the database management work order; If the review report is a passed review, execute the database management work order that has passed the review for testing, and if the test is successful, determine the swap station database requested by the database management work order.

5. The remote management method of a battery swapping station database according to claim 2, characterized in that, The determining whether the swap station database corresponding to the database management work order exists on the archery database management tool specifically includes: Determine the preset list of accessible databases in the archery database management tool, and query the swap station database corresponding to the database management work order based on the preset list of accessible databases; In the case where the swap station database corresponding to the database management work order does not exist in the list of accessible databases, determine that there is a data error in the database management work order, and download the backup script corresponding to the database management work order; Perform data rollback according to the backup script until the swap station database corresponding to the database management work order exists in the preset list of accessible databases, and send the database management work order to the corresponding swap station database.

6. The remote management method of a swapping station database according to claim 2, characterized in that, If so, based on the mapping information on the archery database management tool, determine the corresponding database external network address and port number, specifically including: In the case where the swap station database exists in the preset list of accessible databases, continue to determine whether there is mapping information corresponding to the swap station database on the archery database management tool; If so, determine the database external network address and port number corresponding to the swap station database based on the mapping information, and verify the database external network address and port number to determine that the database external network address and port number match the swap station database.

7. A remote management method for a swapping station database according to claim 1, characterized in that The access to the swap station database is realized according to the database external network address and port number corresponding to the swap station database, specifically including: Find the corresponding swap station database based on the database external network address corresponding to the swap station database, and establish a data connection with the swap station database based on the port number corresponding to the swap station database; Encrypt the database management work order, and send the encrypted database management work order to the swap station database based on the established data connection; Receive the encrypted database management work order through the swap station database, and perform a decryption operation on the database management work order to realize the access to the swap station database in response to the decrypted database management work order.

8. The remote management method of a battery swapping station database according to claim 7, wherein, The remote management of the swap station database is realized according to the database management work order, specifically including: Determine the database change script corresponding to the database management work order, and determine whether the user has the change permission corresponding to the database change script; In the case where the user has the change permission, trigger the execution of the database change script based on the access to the swap station database to realize the remote management of the swap station database.

9. The remote management method of a swapping station database according to claim 2, wherein, After the remote management of the swap station database is realized according to the database management work order, the method further includes: Obtain the data change result corresponding to the database management work order, and return the data change result to the archery database management tool through the external network port corresponding to the swap station database; Through the archery database management tool, determine whether the swap station database has completed the change corresponding to the database management work order according to the data change result, and send the change situation of the swap station database to the corresponding user in response to the user.

10. A remote management device for a battery swapping station database, characterized in that, The device includes: An audit module, configured to audit the database management work order submitted by the user, and determine the swap station database requested by the database management work order when the audit is passed; A mapping module, configured to obtain the mapping information of the swap station database to determine the corresponding database external network address and port number; A management module, configured to access the swap station database according to the database external network address and port number corresponding to the swap station database, and remotely manage the swap station database according to the database management work order.

11. An electronic device, characterized in that, The device includes: At least one processor; And a memory communicatively connected to the at least one processor; Wherein, the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor so that the at least one processor can execute a remote management method for a swap station database according to any one of claims 1-9.

12. A non-volatile computer storage medium stores computer-executable instructions, characterized in that, The computer implements a remote management method for a swap station database according to any one of claims 1-9 when executing the executable instructions.

Images