CN-121996500-A - Database management method and device and electronic equipment

CN121996500ACN 121996500 ACN121996500 ACN 121996500ACN-121996500-A

Abstract

The invention provides a method and a device for managing a database and electronic equipment, wherein the method and the device acquire to-be-processed management information aiming at a target database, the to-be-processed management information comprises at least one of interaction information generated by a user account aiming at the target database, alarm information corresponding to a monitoring system corresponding to the target database and appointed data generated by the target database, version update parameters are determined based on historical version data, local version data, update version data and configuration information, the version update parameters comprise file update information and/or to-be-processed difference data, target description information is input into a target model, a target processing scheme aiming at target description information output by the target model is acquired, management operation is performed on the target database based on the target processing scheme, and the target model is realized based on a large language model. The method improves the management efficiency of the database and reduces the labor cost.

Inventors

ZHAO RONGSHENG
CHENG BO
JIN YANG
WANG LEI
XIAO LONG
WEI JIAJUN
JIANG WENWEI
Fu Xingnan
Pei Zhonglv
ZHENG LEI

Assignees

杭州网易云音乐科技有限公司

Dates

Publication Date: 20260508
Application Date: 20251212

Claims (10)

1. A method of managing a database, the method comprising: The method comprises the steps of obtaining to-be-processed management information aiming at a target database, wherein the to-be-processed management information comprises at least one of interaction information generated by a user account aiming at the target database, alarm information corresponding to a monitoring system corresponding to the target database and appointed data generated by the target database; Determining target description information based on the to-be-processed management information and a preset knowledge base, wherein the knowledge base is established based on history management information, management operation aiming at the history management information and metadata of the target database; the target description information is input into a target model, a target processing scheme of the target model for the target description information is obtained, management operation is conducted on the target database based on the target processing scheme, and the target model is achieved based on a large language model.
2. The method of claim 1, wherein the knowledge base includes vector data generated based on history management information, a processing scheme for the history management information, and metadata of the target database; Based on the to-be-processed management information and a preset knowledge base, determining target description information comprises the following steps: Generating a target vector corresponding to the to-be-processed management information; Obtaining matching vector data corresponding to the target vector in the knowledge base; And determining target description information based on the target vector and the matching vector data.
3. The method of claim 2, wherein the step of determining target description information based on the target vector and the matching vector data comprises: Acquiring a prompt word template through a model context protocol corresponding to the target model; And generating target description information based on the target vector, the matching vector data and the prompt word template.
4. The method of claim 1, wherein after performing the management operation on the target database based on the target processing scheme, the method further comprises: and acquiring log data corresponding to the management operation, and updating the knowledge base based on the log data.
5. The method of claim 1, wherein the step of managing the target database based on the target processing scheme comprises: analyzing the target processing scheme to determine target management operation; Judging whether the risk level of the target management operation is higher than a preset level threshold value; if yes, generating a work task list corresponding to the target management operation, and generating approval information corresponding to the work task list; And sending the approval information to the appointed user account, and executing the target management operation on the target database if a confirmation instruction corresponding to the approval information is received.
6. The method of claim 1, wherein the step of obtaining the pending management information for the target database comprises: and if alarm information generated by the monitoring system aiming at the target database is received, carrying out standardization processing on the alarm information to generate to-be-processed management information aiming at the target database, wherein the standardization processing at least comprises priority judging processing and cluster judging processing.
7. The method of claim 1, wherein the step of obtaining the pending management information for the target database comprises: If the interaction information generated by the user account aiming at the target database is received, judging whether the interaction information corresponds to one management operation in a plurality of preset management operations or not; And if not, determining the interaction information as the management information to be processed.
8. A database management apparatus, the apparatus comprising: The information acquisition module is used for acquiring to-be-processed management information aiming at a target database, wherein the to-be-processed management information comprises at least one of interaction information generated by a user account aiming at the target database, alarm information corresponding to a monitoring system corresponding to the target database and appointed data generated by the target database; The target description information determining module is used for determining target description information based on the to-be-processed management information and a preset knowledge base, wherein the knowledge base is established based on history management information, management operation aiming at the history management information and metadata of the target database; The management processing module is used for inputting the target description information into a target model, acquiring a target processing scheme of the target model for outputting the target description information, and performing management operation on the target database based on the target processing scheme, wherein the target model is realized based on a large language model.
9. An electronic device comprising a processor and a memory, the memory storing machine executable instructions executable by the processor, the processor executing the machine executable instructions to implement the method of managing a database according to any one of claims 1-7.
10. A machine-readable storage medium storing machine-executable instructions which, when invoked and executed by a processor, cause the processor to implement the method of managing a database according to any one of claims 1 to 7.

Description

Database management method and device and electronic equipment Technical Field The present invention relates to the field of data processing technologies, and in particular, to a method and an apparatus for managing a database, and an electronic device. Background The management matters of the database mainly comprise a use operation, an operation and maintenance operation and an operation. The operation is used for supporting operations of adding, deleting, modifying and adding users to the database data, and the like, the operation and maintenance operation is used for monitoring alarm configuration and optimization, alarm processing, capacity expansion and contraction, hardware fault processing and the like of the database, and the operation is used for carrying out management, read-write management and the like of database management, blood margin analysis, audit log analysis, user management, connection number/transaction number and the like. However, most of the above-mentioned works require the intervention of related staff to deal with various situations, and have high labor cost and low efficiency. Disclosure of Invention Accordingly, the present invention is directed to a method and apparatus for managing a database, and an electronic device, so as to improve the management efficiency of the database and reduce the labor cost. The embodiment of the invention provides a management method of a database, which comprises the steps of obtaining to-be-processed management information aiming at a target database, wherein the to-be-processed management information comprises at least one of interaction information generated by a user account aiming at the target database, alarm information corresponding to a monitoring system corresponding to the target database and appointed data generated by the target database, determining target description information based on the to-be-processed management information and a preset knowledge base, establishing the knowledge base based on history management information, management operation aiming at the history management information and metadata of the target database, inputting the target description information into a target model, obtaining a target processing scheme output by the target model aiming at the target description information, and performing management operation on the target database based on the target processing scheme, wherein the target model is realized based on a large language model. The embodiment of the invention provides a management device of a database, which is arranged on a server, and comprises an information acquisition module, a management processing module and a target description information determining module, wherein the information acquisition module is used for acquiring to-be-processed management information aiming at a target database, the to-be-processed management information comprises at least one of interaction information generated by a user account aiming at the target database, alarm information corresponding to a monitoring system corresponding to the target database and appointed data generated by the target database, the target description information determining module is used for determining target description information based on the to-be-processed management information and a preset knowledge base, the knowledge base is established based on history management information, management operation aiming at the history management information and metadata of the target database, the management processing module is used for inputting the target description information into a target model, acquiring a target processing scheme output by the target model aiming at the target description information, and managing the target database based on the target processing scheme, and the target model is realized based on a large language model. In a third aspect, an embodiment of the present invention provides an electronic device, including a processor and a memory, where the memory stores machine executable instructions that can be executed by the processor, and the processor executes the machine executable instructions to implement the method for managing a database as described above. In a fourth aspect, embodiments of the present invention provide a machine-readable storage medium storing machine-executable instructions that, when invoked and executed by a processor, cause the processor to implement the method of managing a database described above. The embodiment of the invention has the following beneficial effects: The method, the device and the electronic equipment for managing the database acquire to-be-processed management information aiming at the target database, wherein the to-be-processed management information comprises at least one of interaction information generated by a user account aiming at the target database, alarm information corresponding to a monitoring system corresponding to the target database and appo