Database operation and maintenance method, equipment, medium and product

Abstract

The embodiment of the invention provides a database operation and maintenance method and device, a medium and a product. The method comprises the steps that a current operation and maintenance request generated by a user for a database is obtained; then, operation and maintenance auxiliary information corresponding to the current operation and maintenance request is determined from an operation and maintenance knowledge base by means of a retrieval model; and then, inputting the current operation and maintenance request and the operation and maintenance auxiliary information into an operation and maintenance model, so that the operation and maintenance model outputs a current operation and maintenance strategy for solving the current operation and maintenance request. Therefore, the operation and maintenance platform can generate the operation and maintenance strategy directly according to the current operation and maintenance request generated by the user without obtaining the database operation log, so as to solve the current operation and maintenance request. In addition, in the process of generating the operation and maintenance strategy, the scheme also combines the operation and maintenance auxiliary information screened from the operation and maintenance knowledge base, and the operation and maintenance auxiliary information can be used as reference information to assist the operation and maintenance model to output a more accurate operation and maintenance strategy, so that the operation and maintenance request can be better solved.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of database, and in particular to a database operation and maintenance method, device, medium and product. BACKGROUND

[0002] With the rapid development of the information age, the rapid growth of data volume and the continuous improvement of use demand will affect the performance of the database. The change of the performance of the database will affect the user experience, and the user usually generates an operation and maintenance request in the case of change of the performance of the database. Commonly, the operation and maintenance platform can solve the operation and maintenance request by adjusting the parameters of the database to ensure the performance of the database.

[0003] However, in practice, considering the privacy of the user, the operation and maintenance platform cannot directly obtain the running log and performance indicators of the database, so that the parameters of the database can not be accurately adjusted, and ultimately the operation and maintenance request cannot be solved.

[0004] Based on the above, in the case of being unable to obtain the running log of the database, how to accurately adjust the parameters of the database to solve the operation and maintenance request has become a problem to be solved. SUMMARY

[0005] Therefore, the embodiments of the present application provide a database operation and maintenance method, device, medium and product to solve the operation and maintenance request in the case of being unable to obtain the running log of the database.

[0006] In a first aspect, the embodiments of the present application provide a database operation and maintenance method, comprising:

[0007] obtaining a current operation and maintenance request generated by a user to a database;

[0008] determining operation and maintenance auxiliary information corresponding to the current operation and maintenance request from an operation and maintenance knowledge base through a retrieval model, the operation and maintenance knowledge base comprising historical operation and maintenance information and / or database documents, the historical operation and maintenance information comprising historical operation and maintenance requests and historical operation and maintenance strategies corresponding to the historical operation and maintenance requests;

[0009] inputting the current operation and maintenance request and the operation and maintenance auxiliary information into an operation and maintenance model to output a current operation and maintenance strategy from the operation and maintenance model, the current operation and maintenance strategy comprising database parameters and corresponding database parameter recommended values.

[0010] In a second aspect, the embodiments of the present application provide an electronic device comprising a processor and a memory, wherein the memory is used to store one or more computer instructions, wherein the one or more computer instructions are executed by the processor to implement the database operation and maintenance method in the first aspect. The electronic device can further comprise a communication interface for communicating with other devices or communication systems.

[0011] In a third aspect, an embodiment of the present application provides a non-transitory machine readable storage medium, which has stored thereon executable code that, when executed by a processor of an electronic device, causes the processor to at least implement the database operation and maintenance method according to the first aspect.

[0012] In a fourth aspect, an embodiment of the present application provides a computer program product, which includes a computer program or instructions, when the computer program or instructions are executed by a processor, cause the processor to implement the database operation and maintenance method according to the first aspect.

[0013] In the database operation and maintenance method provided by the embodiment of the present application, the operation and maintenance platform can obtain a current operation and maintenance request generated by a user on a database. Then, the operation and maintenance platform can determine operation and maintenance auxiliary information corresponding to the current operation and maintenance request from an operation and maintenance knowledge base by means of a retrieval model. The operation and maintenance knowledge base includes historical operation and maintenance information and / or a database document, and the historical operation and maintenance information includes historical operation and maintenance requests and historical operation and maintenance strategies corresponding to the historical operation and maintenance requests. After that, the operation and maintenance platform can input the current operation and maintenance request and the operation and maintenance auxiliary information into an operation and maintenance model, so as to output a current operation and maintenance strategy from the operation and maintenance model, and the current operation and maintenance strategy includes database parameters and corresponding database parameter recommended values.

[0014] It can be seen that, in the above method, the operation and maintenance platform does not need to obtain database running logs, but can directly generate an operation and maintenance strategy according to a current operation and maintenance request generated by a user, so as to solve the current operation and maintenance request. Moreover, in the process of generating the operation and maintenance strategy, the operation and maintenance auxiliary information related to the current operation and maintenance request and selected from the operation and maintenance knowledge base is combined, and the operation and maintenance auxiliary information can be used as reference information to assist the operation and maintenance model to output a more accurate operation and maintenance strategy, so as to better solve the operation and maintenance request. BRIEF DESCRIPTION OF DRAWINGS

[0015] In order to more clearly illustrate the technical solutions in the embodiments of the present application or the prior art, the following will briefly introduce the drawings needed to be used in the embodiments or the prior art description. Obviously, the drawings in the following description are some embodiments of the present application, and other drawings can also be obtained by those skilled in the art without any creative effort on the basis of these drawings.

[0016] Figure 1 A flowchart of a database operation and maintenance method provided by an embodiment of the present application is shown in FIG. 1;

[0017] Figure 2 A flowchart of another database operation and maintenance method provided by an embodiment of the present application is shown in FIG. 2;

[0018] Figure 3A schematic diagram of an input template in a non-dialog form provided for an embodiment of the present application;

[0019] Figure 4 A structural schematic diagram of an input template in a dialog form provided for an embodiment of the present application;

[0020] Figure 5a A schematic diagram of a use interface of a database provided for an embodiment of the present application;

[0021] Figure 5b A schematic diagram of a customer service interface of a database provided for an embodiment of the present application;

[0022] Figure 6 A flowchart of a model training method provided for an embodiment of the present application;

[0023] Figure 7 An inventive idea architecture diagram of the present application;

[0024] Figure 8 A structural schematic diagram of a database operation and maintenance device provided for an embodiment of the present application;

[0025] Figure 9 A structural schematic diagram of an electronic device provided for an embodiment of the present application. DETAILED DESCRIPTION

[0026] In order to make the purpose, technical scheme and advantages of the embodiments of the present application clearer, the technical scheme in the embodiments of the present application will be described clearly and completely below with reference to the drawings in the embodiments of the present application. Obviously, the described embodiments are some embodiments of the present application, but not all the embodiments of the present application. Based on the embodiments in the present application, all other embodiments obtained by those skilled in the art without creative labor fall within the scope of protection of the present application.

[0027] The terms used in the embodiments of the present application are merely for the purpose of describing specific embodiments, and are not intended to limit the present application. The singular forms "a", "an" and "the" used in the embodiments of the present application and the appended claims are also intended to include the plural forms, unless the context clearly indicates otherwise. "Plural" generally includes at least two, but does not exclude the case of including at least one.

[0028] It should be understood that the term "and / or" used herein is merely to describe the association relationship of the associated objects, which means that there can be three relationships, for example, A and / or B, which can represent the three cases of A alone, A and B together, and B alone. In addition, the character " / " herein generally represents an "or" relationship between the front and rear associated objects.

[0029] Depending on the context, the word "if" as used herein can be interpreted to mean "upon determining," or "in response to determining" or "when it is determined" or "upon identifying" or "in response to identifying." Similarly, the phrase "if it is determined" or "if an identified (statement of a condition or event) can be interpreted to mean "upon determining" or "in response to determining" or "when it is determined" or "upon identifying" or "in response to identifying" (statement of a condition or event).

[0030] It should be noted that the user information (including but not limited to user equipment information, user personal information, etc.) and data (including but not limited to data for analysis, stored data, displayed data, etc.) involved in the present application are all information and data authorized by the user or authorized by all parties, and the collection, use and processing of related data need to comply with relevant laws, regulations and standards of relevant countries and regions, and corresponding operation portals are provided for users to choose authorization or refusal.

[0031] It should also be noted that the terms "comprising", "including", or any other variant thereof are intended to cover non-exclusive inclusions, so that the products or systems including a series of elements not only include those elements, but also include other elements not explicitly listed, or include elements inherent to such products or systems. Without more limitations, the element defined by the sentence "including a" does not exclude the presence of other identical elements in the product or system including the element.

[0032] Before the embodiments provided by the present application are described in detail, a common use scenario of a database can also be described:

[0033] Based on the description of the background technology, with the rise of cloud computing, the deployment mode of the database has undergone fundamental changes, and more and more users choose to deploy their databases on the cloud to form a cloud database. This allows users to easily obtain computing and storage resources without having to build and maintain a large infrastructure, that is, the building and operation and maintenance of the cloud database can be realized by the cloud service provider. For example, the cloud service provider can act as a database builder to deploy the database to the cloud by means of its own building platform, and can also act as a database operator to operate and maintain the database by means of its own operation and maintenance platform, thereby solving the user's operation and maintenance request for the database.

[0034] However, when the database is deployed on the cloud, considering the user's privacy problem, the operation and maintenance platform often cannot obtain the specific running log of the database. At this time, the problems in the background technology will occur. In order to better solve the operation and maintenance request of the database on the cloud, the methods provided by the embodiments of the present application can be used.

[0035] In addition, it should be noted that the embodiments of the present application do not limit the deployment position of the database. When the user of the database and the operation and maintenance party of the database are relatively independent, so that the operation and maintenance party cannot obtain the running log of the database, the method provided by the embodiments of the present application can be used to solve the operation and maintenance request raised by the user.

[0036] Based on the above description, some embodiments of the present application can be described in detail below in combination with the drawings. The embodiments and the features and steps in the embodiments described below can be combined with each other without conflict. In addition, the step sequence in each method embodiment described below is only an example, and is not strictly limited.

[0037] Figure 1 A flowchart of a database operation and maintenance method provided by an embodiment of the present application. The database operation and maintenance method provided by the embodiment of the present application can be executed by an operation and maintenance platform. Optionally, the operation and maintenance platform can be deployed on the cloud, or can be deployed together with the database locally on the user. As shown in the figure, the method can include the following steps: Figure 1

[0038] S101, obtaining a current operation and maintenance request raised by a user to a database.

[0039] As mentioned in the background, the performance change of the database will affect the user experience, so when the performance of the database changes, the user can raise an operation and maintenance request to the database.

[0040] Optionally, a customer service button can be provided on the use interface of the database, and the user can click the button to further jump to the customer service interface provided by the database during use of the database. In the customer service interface, the user can trigger an input operation to input the current operation and maintenance request. At this time, the operation and maintenance platform can obtain the current operation and maintenance request raised by the user to the database.

[0041] Optionally, the current operation and maintenance request can be in the form of natural language, which can specifically include at least one of the problems encountered by the user during current use of the database, the current use scenario of the database, the current parameter value of the database, and the effect to be achieved by the user.

[0042] ​For example, the current operation and maintenance request generated by the user can be "I am using a database to query inventory data of goods, but the current inventory data query speed is slow, how to improve the query speed. There is one more information: the current buffer size of the database is 128MB". Wherein, MB is megabyte, which is the abbreviation of MByte. "The current inventory data query is slow" describes the problem encountered by the user. "I am using a database to query inventory data of goods" describes the use scenario of the user. "The current buffer size of the database is 128MB" describes the current parameter value of the database. "How to improve the query speed" describes the effect that the user wants to achieve.

[0043] It is easy to understand that the more content items contained in the current operation and maintenance request, the more helpful it is for the operation and maintenance model to give more accurate operation and maintenance strategies.

[0044] In S102, the operation and maintenance assistance information corresponding to the current operation and maintenance request is determined from the operation and maintenance knowledge base by searching the model.

[0045] In S103, the current operation and maintenance request and the operation and maintenance assistance information are input into the operation and maintenance model, so as to output the current operation and maintenance strategy by the operation and maintenance model. The current operation and maintenance strategy includes database parameters and corresponding database parameter recommended values.

[0046] Based on the current operation and maintenance request generated by the user, the operation and maintenance platform can retrieve the information related to the current operation and maintenance request from the pre-stored operation and maintenance knowledge base by means of the searching model. Finally, the operation and maintenance platform can input the current operation and maintenance request and the retrieved information into the operation and maintenance model, so as to output the current operation and maintenance strategy by the operation and maintenance model. And according to the description in the background art, it is known that the operation and maintenance request can usually be solved by adjusting the database parameters, therefore, the operation and maintenance strategy can specifically include the database parameters and the database parameter recommended values corresponding to the database parameters, that is, the current operation and maintenance strategy can include the parameter items and the parameter values corresponding to the parameter items.

[0047] Optionally, the parameter item is also the parameter in the database that can be adjusted, which can be a variable or setting used for configuring and adjusting the system behavior in the database management system. The database parameters can specifically include variables such as maximum parallelism, buffer size, thread number, and settings such as query optimizer. The parameter value is used to specifically reflect the performance indicators of the database.

[0048] Optionally, the operation and maintenance knowledge base can include historical operation and maintenance information and / or database documents. The database documents are documents that record and describe the structure, function, use and maintenance method of the database in detail. For example, the documents can be used to describe the function of any parameter in the database and the effect of adjusting the any parameter. For example, the size of the buffer can affect the query performance of the database, and the larger the buffer, the faster the query speed. The historical operation and maintenance information can include information pairs formed by historical operation and maintenance requests and historical operation and maintenance strategies corresponding to the historical operation and maintenance requests. For example, the historical operation and maintenance information can be in the form of question and answer pairs, such as the historical operation and maintenance information can include a historical operation and maintenance request of "the current inventory data query speed is very slow, how can I solve it?" and a historical operation and maintenance strategy of "increase the buffer size to 256MB". And the historical operation and maintenance request is obviously generated before the current operation and maintenance request.

[0049] In addition, it should be noted that according to the above introduction of the operation and maintenance knowledge base, the operation and maintenance knowledge base contains information that can solve operation and maintenance requests, therefore, the information related to the current operation and maintenance request retrieved by the operation and maintenance platform from the operation and maintenance knowledge base can assist the operation and maintenance model in outputting operation and maintenance strategies, so the retrieved information can also be called operation and maintenance auxiliary information corresponding to the current operation and maintenance request.

[0050] Optionally, the current operation and maintenance request and the operation and maintenance knowledge base can be input into a retrieval model to calculate the similarity between each text in the current operation and maintenance request and the operation and maintenance knowledge base by the retrieval model, and output operation and maintenance auxiliary information with a similarity meeting a preset threshold. Optionally, the similarity between texts can include literal similarity and / or semantic similarity. Optionally, the retrieval model can be deployed locally on the operation and maintenance platform, or deployed remotely. The retrieval model can include any one of discriminative models such as convolutional neural network (CNN) model, long short-term memory (LSTM) model and decision tree model.

[0051] Optionally, the operation and maintenance model can be deployed locally on the operation and maintenance platform or remotely. The operation and maintenance model can specifically include any one of generative pre-trained transformer (GPT) models and bidirectional encoder representations from transformers (Bert) models in generative models. Since the operation and maintenance model is essentially a generative model, the current operation and maintenance request and operation and maintenance auxiliary information input into the operation and maintenance model can be considered as prompt information, which can ensure that the operation and maintenance model outputs accurate results.

[0052] In this embodiment, the operation and maintenance platform can obtain a current operation and maintenance request generated by a user on a database. Then, the operation and maintenance platform can determine operation and maintenance auxiliary information corresponding to the current operation and maintenance request from the operation and maintenance knowledge base by means of the retrieval model. Subsequently, the operation and maintenance platform can input the current operation and maintenance request and the operation and maintenance auxiliary information into the operation and maintenance model to output a current operation and maintenance strategy for solving the current operation and maintenance request by the operation and maintenance model, wherein the current operation and maintenance strategy can include database parameters and recommended values of the database parameters.

[0053] As can be seen, in the above method, the operation and maintenance platform does not need to obtain database running logs, but can directly generate an operation and maintenance strategy according to a current operation and maintenance request generated by a user to solve the current operation and maintenance request. Moreover, in the process of generating the operation and maintenance strategy, the scheme also combines operation and maintenance auxiliary information related to the current operation and maintenance request selected from the operation and maintenance knowledge base, which can be used as reference information to assist the operation and maintenance model to output more accurate operation and maintenance strategies, thereby better solving operation and maintenance requests.

[0054] In addition, the technical effects that can be achieved by the method provided in each embodiment of the present application can also be understood from the following aspects:

[0055] The operation and maintenance knowledge learned by the operation and maintenance model in the training stage is limited, so the accuracy of the operation and maintenance strategy output by the model is also limited. However, in the scheme in each embodiment of the present application, operation and maintenance auxiliary information obtained from the external operation and maintenance knowledge base is also input into the operation and maintenance model, and the simultaneous use of this operation and maintenance auxiliary information and the knowledge learned by the operation and maintenance model itself can improve the accuracy of the operation and maintenance strategy output by the operation and maintenance model.

[0056] At the same time, since the operation and maintenance knowledge base includes historical operation and maintenance information and database documents, both of which describe the operation and maintenance knowledge of the database from different angles and in different forms, that is, there is complementarity between the two, the operation and maintenance auxiliary information retrieved from the operation and maintenance knowledge base plays a better auxiliary role in outputting the operation and maintenance strategy by the operation and maintenance model, thereby improving the accuracy of the operation and maintenance strategy output by the operation and maintenance model.

[0057] Figure 1 It has been mentioned in the illustrated embodiments that the operation and maintenance platform can determine an operation and maintenance strategy according to a current operation and maintenance request and operation and maintenance auxiliary information. The specific determination manner of the operation and maintenance strategy can be referred to the following Figure 2 the related description in the illustrated embodiments. Figure 2 The flowchart of another database operation and maintenance method provided by the embodiments of the present application. As Figure 2 shown, the method can include the following steps:

[0058] S201, obtaining a current operation and maintenance request generated by a user to a database.

[0059] S202, determining operation and maintenance auxiliary information corresponding to the current operation and maintenance request from the operation and maintenance knowledge base through a retrieval model.

[0060] The specific implementation process of the above steps S201-S202 can be referred to the specific description of the related steps in the Figure 1 embodiments, which will not be repeated here.

[0061] S203, inputting the current operation and maintenance request and the operation and maintenance auxiliary information into an operation and maintenance model, so as to output a database parameter in the current operation and maintenance strategy by the operation and maintenance model.

[0062] Since Figure 1 it has been mentioned in the illustrated embodiments that any kind of database parameter can be composed of a parameter item and a parameter value, and the operation and maintenance strategy is specifically an adjustment to the database parameter, therefore, optionally, the process of determining the operation and maintenance strategy can include two stages: the first stage is to determine the database parameter in the current operation and maintenance strategy, and the second stage is to determine the recommended value of the database parameter corresponding to the parameter. And both stages can be implemented by the operation and maintenance model.

[0063] For the first stage, the operation and maintenance platform can input the current operation and maintenance request and the operation and maintenance auxiliary information as prompt information into the operation and maintenance model, so as to output the database parameter by the operation and maintenance model. Wherein, the database parameter is related to the current operation and maintenance request generated by the user. For example, assuming that the current operation and maintenance request of the user is "current inventory data query is very slow, how to solve", the database parameter determined by the operation and maintenance model can include the buffer size affecting the query speed.

[0064] Since the operation and maintenance model is essentially a generative model with multiple capabilities, in order to make the operation and maintenance model output the database parameter to be adjusted, optionally, the prompt information can include the current operation and maintenance request, the operation and maintenance auxiliary information, and the role setting statement of the operation and maintenance model.

[0065] For example, the role setting statement in the prompt information can be "you are an experienced operation and maintenance expert", which can be used to prompt the role currently played by the operation and maintenance model. The current operation and maintenance request in the prompt information can be "the current inventory data query is slow, how to solve". The operation and maintenance assistance information in the prompt information can be the content related to the query speed in the database document.

[0066] For the input process of the operation and maintenance model, optionally, prompt information conforming to the input template of the operation and maintenance model can be generated according to the input template of the operation and maintenance model. The input template of the operation and maintenance model can be in the form of dialogue or non-dialogue.

[0067] Optionally, the order of the statements in the prompt information can be pre-set to form the input template in the form of non-dialogue. At this time, the user can directly input the statements in the prompt information in the order on the customer service interface. For example, the prompt information conforming to the input template in the form of non-dialogue can be as follows: "you are an experienced operation and maintenance expert, the current inventory database query is slow, how to solve". At the same time, the operation and maintenance assistance information, that is, the content related to the query speed in the database document retrieved from the operation and maintenance knowledge base, can also be displayed on the customer service interface. The above process can also be combined with Figure 3 understanding.

[0068] Optionally, the dialogue statements can also be pre-set to obtain the input template in the form of dialogue. At this time, the user can input the statements corresponding to the pre-set dialogue statements on the customer service interface. For example, the user can input the role setting statement "you are an experienced operation and maintenance expert, please help me solve the following problem" on the customer service interface. Then, the operation and maintenance model can output the pre-set dialogue statement "OK, please give your current problem". At this time, the user can answer "I am using the database to query the inventory data of goods, but the query speed of the current inventory data is slow, how to improve the query speed". Then, the operation and maintenance model can output the pre-set dialogue statement "do you have any additional content". After that, the operation and maintenance assistance information retrieved by the operation and maintenance platform according to the current operation and maintenance request input by the user, that is, the content related to the database query speed in the database document, can be displayed on the customer service interface. The above process can also be combined with Figure 4 understanding.

[0069] S204, inputting the current operation and maintenance request, the operation and maintenance assistance information and the database parameters into the operation and maintenance model to output the recommended value of the database parameter in the current operation and maintenance strategy by the operation and maintenance model.

[0070] Based on the above first stage, the database parameters are determined, and the second stage can also be entered: the database parameters, the current operation and maintenance request and the operation and maintenance auxiliary information can be input into the operation and maintenance model as prompt information again, so that the operation and maintenance model outputs the recommended value of the database parameters. Taking the above example, the current operation and maintenance strategy output by the operation and maintenance model can be: "the buffer size should be set to 256MB".

[0071] In addition, in order to make the subsequent description simple, the prompt information input into the operation and maintenance model in step S203 can be referred to as first prompt information, and the prompt information input into the operation and maintenance model in step S204 can be referred to as second prompt information. Similar to the first prompt information, the second prompt information can also be input into the operation and maintenance model in the form of dialogue or non-dialogue.

[0072] Taking the example in the above step S203, the second prompt information in the form of non-dialogue can include the user input on the customer service interface: "You are an experienced operation and maintenance expert, the current inventory database query is slow, how to solve it". The auxiliary operation and maintenance information displayed on the customer service interface and retrieved from the operation and maintenance knowledge base, that is, the content related to query speed in the retrieved database document, and the operation and maintenance model output database parameters, that is, the buffer size.

[0073] The second prompt information in the form of dialogue can include: user: "You are an experienced operation and maintenance expert, please help me solve the following problem". Operation and maintenance model: "OK, please give your problem". User: "I am using the database to query the inventory data of goods, but the current inventory data query speed is very slow, how to improve the query speed". Operation and maintenance model: "Do you have any additional information". At the same time, the operation and maintenance platform can display the operation and maintenance auxiliary information retrieved according to the current operation and maintenance request input by the user on the customer service interface. Operation and maintenance model: "Adjust the buffer size to 256MB". Wherein, the specific format of the second prompt information in the form of dialogue or non-dialogue is similar to the first prompt information, which can be referred to the style shown in Figure 3 and Figure 4 .

[0074] In this embodiment, in the process of solving the current operation and maintenance request, the operation and maintenance model can be used to output the database parameters and the recommended value of the parameters in sequence, so as to obtain the current operation and maintenance strategy. And inputting the role setting statement, the current operation and maintenance request and the operation and maintenance auxiliary information into the operation and maintenance model as the prompt information of the generative model, that is, the operation and maintenance model, can make the operation and maintenance model more clearly understand its own identity and the problem to be solved, so as to improve the accuracy of the operation and maintenance model output operation and maintenance strategy.

[0075] In addition, the contents not described in detail in this embodiment and the technical effects that can be achieved can be referred to the related description in the above embodiments, which will not be described here.

[0076] For ease of understanding, the specific implementation process of the database operation and maintenance method provided by each of the above embodiments can be exemplarily described below from a specific application scenario of a cloud database.

[0077] The cloud database can store attribute information of various goods provided by an e-commerce platform, and the attribute information can include inventory data of the goods, specifications of the goods, brands, and the like. A user can query the inventory data of the goods in a use interface provided by the cloud database, but a problem of slow query speed occurs in the query process. At this time, the user can trigger a click operation on a customer service button on the use interface provided by the database, such as the use interface shown in Figure 5a to jump to a customer service interface provided by the database, such as the customer service interface shown in Figure 5b In the customer service interface, the user can further input a current operation and maintenance request, that is, "the current inventory data query is very slow, how to solve it". After the retrieval model retrieves the auxiliary operation and maintenance information corresponding to the current operation and maintenance request from the operation and maintenance knowledge base, the first prompt information shown in Figure 3 or Figure 4 can be further generated. The first prompt information can be input into the operation and maintenance model, so that the operation and maintenance model outputs the parameter item to be adjusted, that is, the buffer size of the database.

[0078] Finally, the second prompt information in the form of dialogue or non-dialogue can also be input into the operation and maintenance model, so that the operation and maintenance model outputs the operation and maintenance strategy, that is, the buffer size output by the operation and maintenance model should be set to 256 MB. The first prompt information and the second prompt information have the same form. It should be noted that the above only exemplarily describes one use scenario of the cloud database, and the embodiments of the present application do not limit the use scenario of the database.

[0079] According to the use process of the operation and maintenance platform described in the above Figures 1 to 5b embodiment, it can be known that the retrieval model and the operation and maintenance model are used in sequence in the process of generating the operation and maintenance strategy. The training processes of the retrieval model and the operation and maintenance model are described below. Each of the following embodiments can be executed by a training device. The training device can be the operation and maintenance platform mentioned in the above embodiments, or can be another device other than the operation and maintenance platform. The other device can be deployed in the cloud.

[0080] Optionally, the training device can train the operation and maintenance model and / or the retrieval model according to historical operation and maintenance information. Specifically, the training device can take a historical operation and maintenance request in the historical operation and maintenance information as a training sample, take a historical operation and maintenance strategy corresponding to the historical operation and maintenance request as supervision information, and train the operation and maintenance model. The training process can be specifically as follows: the training device can perform loss calculation on a predicted operation and maintenance strategy corresponding to a historical operation and maintenance request output by the operation and maintenance model and the historical operation and maintenance strategy, and train the operation and maintenance model according to the obtained loss calculation result.

[0081] Similar to the training process of the operation and maintenance model, the training device can take a historical operation and maintenance request as a training sample, take a historical operation and maintenance strategy corresponding to the historical operation and maintenance request as supervision information, and train the retrieval model.

[0082] In this embodiment, the operation and maintenance model and / or the retrieval model can be trained in a supervised training manner, so that the training effect of the operation and maintenance model and / or the retrieval model is better, and the result output by the operation and maintenance model and / or the retrieval model in the model use stage is also more accurate.

[0083] In addition, according to the description in each of the above embodiments, the input and output contents of the operation and maintenance model in the use stage and the training stage are different. For example, the input of the operation and maintenance model in the use stage can include a current operation and maintenance request and auxiliary operation and maintenance information; can also include a role setting statement, a current operation and maintenance request, and auxiliary operation and maintenance information; can also include a role setting statement, a current operation and maintenance request, auxiliary operation and maintenance information, and a to-be-adjusted parameter item. The operation and maintenance model can output an operation and maintenance strategy, a to-be-adjusted parameter item, and a parameter value in the use stage. The input used in the training stage can include a historical operation and maintenance request. The content output in the training stage can include a historical operation and maintenance strategy.

[0084] However, it should be noted that the contents input into the operation and maintenance model in the training stage and the use stage are essentially prompt information of the operation and maintenance model as a generative model; the contents output by the operation and maintenance model in the training stage and the use stage are essentially results related to the input prompt information, so the difference in input and output contents in different stages does not affect the training effect of the operation and maintenance model.

[0085] In order to further improve the training effect of the operation and maintenance model and / or the retrieval model, data augmentation can be performed optionally, and the training process of the model using the data augmentation result will be described in detail below. Figure 6 A flowchart of a model training method provided by an embodiment of the present application. The embodiment can also be executed by the training device described above. As shown in the figure, the method can include the following steps: Figure 6

[0086] S301, any parameter that can be adjusted in the database is determined as an enhanced operation and maintenance strategy.​

[0087] S302, input the enhanced operation and maintenance policy as a terminal node in the logical chain into the operation and maintenance model to output an intermediate node of the logical chain by the operation and maintenance model.

[0088] S303, input the intermediate node into the operation and maintenance model to output an enhanced operation and maintenance request as a starting node in the logical chain by the operation and maintenance model.

[0089] S304, determine the enhanced operation and maintenance policy and the enhanced operation and maintenance request as enhanced operation and maintenance information.

[0090] In practice, there is a logical relationship between the operation and maintenance request and the operation and maintenance policy, which can be represented as: operation and maintenance request (reflecting the current performance defect of the database) → database parameters and database performance affected by the parameters → operation and maintenance policy (parameter adjustment strategy to solve the current database performance defect). Optionally, the logical relationship between the two can also be represented by a logical chain. The logical chain can include a starting node, an intermediate node and a terminal node. The starting node can correspond to the operation and maintenance request, the terminal node can correspond to the operation and maintenance policy corresponding to the operation and maintenance request, and the intermediate node can correspond to the database parameters and the database performance affected by the parameters.

[0091] Based on the above description of the logical chain, optionally, the operation and maintenance model can implement data enhancement in a reverse deduction manner according to the logical relationship between the nodes in the logical chain.

[0092] Specifically, any adjustable parameter in the database can be determined as an enhanced operation and maintenance policy. The adjustable parameter in the database can include the buffer size, the number of threads and the like mentioned in the above examples. Then, the enhanced operation and maintenance policy as a terminal node in the logical chain can be input into the operation and maintenance model to deduce the intermediate node of the logical chain by the operation and maintenance model. Then, the intermediate node can be input into the operation and maintenance model to deduce the enhanced operation and maintenance request as a starting node in the logical chain by the operation and maintenance model. Finally, the enhanced operation and maintenance policy and the enhanced operation and maintenance request can be determined as enhanced operation and maintenance information.

[0093] S305, train the operation and maintenance model and / or the retrieval model according to the historical operation and maintenance information and the enhanced operation and maintenance information.

[0094] The training device can train the operation and maintenance model and / or the retrieval model by taking the historical operation and maintenance information and the enhanced operation and maintenance information as training samples.

[0095] Specifically, the historical operation and maintenance request and the enhanced operation and maintenance request can be taken as training samples, the historical operation and maintenance strategy corresponding to the historical operation and maintenance request and the enhanced operation and maintenance strategy corresponding to the enhanced operation and maintenance request can be taken as supervision information, and the operation and maintenance model can be trained. Specifically, the loss calculation can be performed on the predicted operation and maintenance strategy corresponding to the historical operation and maintenance request output by the operation and maintenance model and the historical operation and maintenance strategy, and the operation and maintenance model can be trained according to the loss result. Meanwhile, the loss calculation can also be performed on the predicted operation and maintenance strategy corresponding to the enhanced operation and maintenance request output by the operation and maintenance model and the enhanced operation and maintenance strategy, and the operation and maintenance model can be trained according to the loss result.

[0096] In the embodiment, before the model training, the operation and maintenance request can be obtained by reverse deduction in the case that a preset operation and maintenance strategy is used based on the logical relationship between the operation and maintenance request and the operation and maintenance strategy, so as to realize data enhancement. In addition, the number of training samples is increased through the supplement of the enhanced operation and maintenance information, so as to improve the training effect of the model, that is, to ensure the diversity and correctness of the output result of the operation and maintenance model.

[0097] It can be known from the description in the above embodiments that the overall concept of the present application includes two stages, that is, an online stage and an offline stage.

[0098] The online stage means that after the current operation and maintenance request is provided by a database user, the current operation and maintenance request can be solved by combining the search model and the operation and maintenance model even if the database operation and maintenance party cannot obtain the database log, and another solution idea of the operation and maintenance request is given.

[0099] The offline stage means the training process of the search model and the operation and maintenance model. In the training process, the logical relationship between the historical operation and maintenance request and the historical operation and maintenance strategy can be used for data enhancement, and the model training is performed by means of the data enhancement result, so as to ensure the effect of the model training.

[0100] The above concept can also be combined with Figure 7 understanding.

[0101] The database operation and maintenance device of one or more embodiments of the present application will be described in detail below. Those skilled in the art can understand that these database operation and maintenance devices can be configured by using commercially available hardware components through the steps taught by the present application.

[0102] Figure 8 A structural schematic diagram of a database operation and maintenance device provided by an embodiment of the present application is shown in Figure 8 The device includes:

[0103] The acquisition module 11 is configured to acquire a current operation and maintenance request generated by a user to a database.

[0104] The determining module 12 is configured to determine the operation and maintenance auxiliary information corresponding to the current operation and maintenance request from an operation and maintenance knowledge base by searching a model, the operation and maintenance knowledge base including historical operation and maintenance information and / or database documents, the historical operation and maintenance information including historical operation and maintenance requests and historical operation and maintenance strategies corresponding to the historical operation and maintenance requests.

[0105] The input module 13 is configured to input the current operation and maintenance request and the operation and maintenance auxiliary information into the operation and maintenance model to output a current operation and maintenance strategy by the operation and maintenance model, the current operation and maintenance strategy including database parameters and corresponding database parameter recommended values.

[0106] Optionally, the determining module 12 is configured to input the current operation and maintenance request and the operation and maintenance knowledge base into the searching model to output the operation and maintenance auxiliary information by the searching model.

[0107] Optionally, the input module 13 is configured to input the current operation and maintenance request and the operation and maintenance auxiliary information into the operation and maintenance model to output the database parameters in the current operation and maintenance strategy by the operation and maintenance model; and input the current operation and maintenance request, the operation and maintenance auxiliary information and the database parameters into the operation and maintenance model to output the database parameter recommended values in the current operation and maintenance strategy by the operation and maintenance model.

[0108] Optionally, the apparatus further includes a prompt information generation module 14 configured to generate prompt information including role setting statements of the operation and maintenance model, the current operation and maintenance request and the operation and maintenance auxiliary information.

[0109] The input module 13 is further configured to input the prompt information into the operation and maintenance model.

[0110] Optionally, the prompt information generation module 14 is configured to generate the prompt information conforming to an operation and maintenance model input template in response to an input operation of the user, the input operation being triggered on a customer service interface provided by the database.

[0111] Optionally, the apparatus further includes an enhanced operation and maintenance information generation module 15 and a training module 16.

[0112] The enhanced operation and maintenance information generation module 15 is configured to generate enhanced operation and maintenance information including enhanced operation and maintenance requests and enhanced operation and maintenance strategies.

[0113] The training module 16 is configured to train the operation and maintenance model and / or the searching model according to the historical operation and maintenance information and the enhanced operation and maintenance information.

[0114] The logical relationship between the operation and maintenance request and the operation and maintenance strategy is represented by a logical chain, the operation and maintenance strategy being a terminal node of the logical chain, and the operation and maintenance request being a starting node of the logical chain.

[0115] Optionally, the enhanced operation and maintenance information generation module 15 is configured to determine any parameter in the database that can be adjusted as an enhanced operation and maintenance policy; input the enhanced operation and maintenance policy as a terminal node in a logic chain into the operation and maintenance model to obtain an enhanced operation and maintenance request as a starting node in the logic chain from the operation and maintenance model; and determine the enhanced operation and maintenance policy and the enhanced operation and maintenance requirement as the enhanced operation and maintenance information.

[0116] Optionally, the enhanced operation and maintenance information generation module 15 is configured to input the enhanced operation and maintenance policy as a terminal node in a logic chain into the operation and maintenance model to obtain an intermediate node in the logic chain from the operation and maintenance model; and input the intermediate node into the operation and maintenance model to obtain an enhanced operation and maintenance request as a starting node in the logic chain from the operation and maintenance model.

[0117] Figure 8 The apparatus can perform the method of the embodiments described above. Figures 1 to 7 The method of the embodiments described above can be implemented by means of a computer program product, of which a computer storage medium has stored thereon computer readable program code comprising program code means. Figures 1 to 7 The computer program product can comprise one or more computer programs. Figures 1 to 7 The computer program product can be stored in the memory 22 of the electronic device.

[0118] In one possible design, the database operation and maintenance method provided by the embodiments described above can be applied in an electronic device. Figure 9 The electronic device can include a processor 21 and a memory 22. Figures 1 to 7 The memory 22 is configured to store a program supporting the electronic device to perform the database operation and maintenance method provided by the embodiments described above.

[0119] The program includes one or more computer instructions.

[0120] Obtain a current operation and maintenance request generated by a user on a database;

[0121] Determine operation and maintenance auxiliary information corresponding to the current operation and maintenance request from an operation and maintenance knowledge base by searching the operation and maintenance knowledge base, the operation and maintenance knowledge base including historical operation and maintenance information and / or database documents, the historical operation and maintenance information including historical operation and maintenance requests and historical operation and maintenance policies corresponding to the historical operation and maintenance requests;

[0122] Input the current operation and maintenance request and the operation and maintenance auxiliary information into an operation and maintenance model to obtain a current operation and maintenance policy from the operation and maintenance model, the current operation and maintenance policy including database parameters and corresponding database parameter recommended values.

[0123] Optionally, the processor 21 is further configured to perform the foregoing Figures 1 to 7All or part of the steps in the illustrated embodiments.

[0124] In the structure of the electronic device, a communication interface 23 can also be included, for the electronic device to communicate with other devices or communication systems.

[0125] In addition, the embodiment of the present application provides a computer storage medium for storing computer software instructions for the electronic device, which includes computer programs or instructions for executing the above-mentioned Figures 1 to 7 The program involved in the database operation and maintenance method shown.

[0126] In addition, the embodiment of the present application provides a computer program product. The computer program product includes computer programs or instructions. When the computer programs or instructions are executed by the processor, the processor can implement the steps or functions of the above-mentioned Figures 1 to 7 The method shown.

[0127] Finally, it should be noted that: the above embodiments are only used to illustrate the technical solutions of the present application, and not to limit them; although the present application has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that: it can still modify the technical solutions recorded in the foregoing embodiments, or make equivalent replacement for part of the technical features; and these modifications or replacements do not make the essence of the corresponding technical solutions deviate from the spirit and scope of the technical solutions of the embodiments of the present application.

Claims

1. A database operation and maintenance method, characterized in that, include: Retrieve the current operational and maintenance requests generated by users for the database; The operation and maintenance auxiliary information corresponding to the current operation and maintenance request is determined from the operation and maintenance knowledge base by the retrieval model. The operation and maintenance knowledge base includes historical operation and maintenance information and / or database documents. The historical operation and maintenance information includes historical operation and maintenance requests and historical operation and maintenance strategies corresponding to the historical operation and maintenance requests. The current operation and maintenance request and the operation and maintenance auxiliary information are input into the operation and maintenance model so that the operation and maintenance model can output the current operation and maintenance strategy, which includes database parameters and corresponding recommended values ​​for the database parameters.

2. The method according to claim 1, characterized in that, The step of determining the operation and maintenance auxiliary information corresponding to the current operation and maintenance request from the operation and maintenance knowledge base through a retrieval model includes: The current operation and maintenance request and the operation and maintenance knowledge base are input into the retrieval model, so that the retrieval model outputs the operation and maintenance auxiliary information.

3. The method according to claim 1, characterized in that, The step of inputting the current operation and maintenance request and the operation and maintenance auxiliary information into the operation and maintenance model, so that the operation and maintenance model outputs the current operation and maintenance strategy, includes: The current operation and maintenance request and the operation and maintenance auxiliary information are input into the operation and maintenance model so that the operation and maintenance model can output the database parameters in the current operation and maintenance strategy. The current operation and maintenance request, the operation and maintenance assistance information, and the database parameters are input into the operation and maintenance model, so that the operation and maintenance model outputs the recommended values ​​of the database parameters in the current operation and maintenance strategy.

4. The method according to claim 3, characterized in that, The step of inputting the current operation and maintenance request and the operation and maintenance auxiliary information into the operation and maintenance model includes: Generate a prompt message containing the role setting statement of the operation and maintenance model, the current operation and maintenance request, and the operation and maintenance auxiliary information; Input the prompt information into the operation and maintenance model.

5. The method according to claim 4, characterized in that, The generation of prompt information containing the role setting statement of the operation and maintenance model, the current operation and maintenance request, and the operation and maintenance assistance information includes: In response to the user's input operation, a prompt message conforming to the operation and maintenance model input template is generated, and the input operation is triggered on the customer service interface provided by the database.

6. The method according to claim 1, characterized in that, The method further includes: Generate enhanced operation and maintenance information, including enhanced operation and maintenance requests and enhanced operation and maintenance policies; The operation and maintenance model and / or retrieval model are trained based on the historical operation and maintenance information and the enhanced operation and maintenance information.

7. The method according to claim 6, characterized in that, The logical relationship between operation and maintenance requests and operation and maintenance policies is represented by a logical chain, with the operation and maintenance policy being the terminal node of the logical chain and the operation and maintenance request being the starting node of the logical chain. The generation of enhanced operation and maintenance information, including enhanced operation and maintenance requests and enhanced operation and maintenance policies, includes: Determine any adjustable parameter in the database as an enhanced operation and maintenance strategy; The enhanced operation and maintenance strategy, which serves as the terminating node in the logical chain, is input into the operation and maintenance model, so that the enhanced operation and maintenance request, which serves as the starting node, is obtained from the operation and maintenance model. The enhanced operation and maintenance strategy and the enhanced operation and maintenance request are identified as the enhanced operation and maintenance information.

8. The method according to claim 7, characterized in that, The step of inputting the enhanced operation and maintenance strategy, which serves as the terminating node in the logical chain, into the operation and maintenance model, so that the operation and maintenance model can obtain an enhanced operation and maintenance request, which serves as the starting node, includes: The enhanced operation and maintenance strategy, which serves as the terminal node in the logical chain, is input into the operation and maintenance model so that the operation and maintenance model outputs the intermediate nodes of the logical chain. The intermediate node is input into the operation and maintenance model, so that the operation and maintenance model outputs an enhanced operation and maintenance request that serves as the starting node in the logical chain.

9. An electronic device, characterized in that, include: A memory and a processor; wherein the memory stores executable code, and when the executable code is executed by the processor, the processor performs the database operation and maintenance method as described in any one of claims 1 to 8.

10. A non-transitory machine-readable storage medium, characterized in that, The non-transitory machine-readable storage medium stores executable code, which, when executed by a processor of an electronic device, causes the processor to perform the database operation and maintenance method as described in any one of claims 1 to 8.

11. A computer program product, characterized in that, The computer program product includes a computer program or instructions that enable the computer program or instructions to implement the database operation and maintenance method according to any one of claims 1 to 8.

Images