Operation and maintenance method and device applied to database, server, medium and product

Abstract

The embodiment of the invention provides an operation and maintenance method and device applied to a database, a server side, a medium and a product, and the method comprises the steps: displaying a session interface associated with a database maintenance system, and obtaining a first session message input by a user in the session interface; retrieving in a database domain knowledge base based on the first session message to obtain a first response message, and displaying the first response message in a session interface; and when it is detected that a second session message input by the user is to confirm the structured task execution plan, performing operation and maintenance on the at least one database based on the structured task execution plan. According to the technical scheme, the complexity of database operation and maintenance operation is reduced, the efficiency and accuracy of database operation and maintenance are improved, and the controllability of operation is guaranteed.

Description

TECHNICAL FIELD

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

[0002] With the development of Internet technology, more and more data is stored and managed by databases. Therefore, operation and maintenance management of the database is essential. At present, operation and maintenance management of the database is mainly realized by relying on the operation of a database administrator, and the specific operation mode mainly includes two modes: one is that an operation and maintenance user completes a specific operation and maintenance task by performing a series of input operations in a graphical user interface; and the other is that an operation and maintenance operation is executed based on a structured query language (SQL) input by the operation and maintenance user.

[0003] The inventor found the following problems when performing database operation and maintenance based on the above modes:

[0004] For the above mode one, a complex operation and maintenance task requires the operation and maintenance user to perform multi-level jumping, form filling, writing and debugging in the graphical interface, and there is a problem of time and labor consumption in the operation and maintenance process. Further, in the process of complex manual multi-step operation, if there is an operation error, it may cause a serious operation and maintenance accident, thereby causing great loss. For the above mode two, database management involves a large number of professional concepts, such as instance, cluster, shard, index, slow query, etc. When processing based on the structured query language, the operation and maintenance user must first understand these underlying concepts and corresponding relationships to correctly operate, at which time the professional requirement for the operation and maintenance user is high, and there is a problem of high knowledge barrier. SUMMARY

[0005] The present application provides a database operation and maintenance method, device, server, medium and product to realize intelligent operation and maintenance management of the database.

[0006] In a first aspect, the present application provides a database operation and maintenance method, which comprises:

[0007] displaying a session interface associated with a database maintenance system, and obtaining a first session message input by a user in the session interface, wherein the first session message is related to operation and maintenance requirements of at least one database;

[0008] performing retrieval in a database domain knowledge base based on the first session message, obtaining a first response message, and displaying the first response message in the session interface, wherein the first response message at least includes a structured task execution plan corresponding to the first session message;

[0009] detecting that the second session message input by the user is a confirmation of the structured task execution plan;

[0010] The structured task execution plan is related to specific execution information when performing the operation and maintenance on the database.

[0011] Further, the method further comprises:

[0012] In response to the second session message being an event of adjusting the structured task execution plan, the structured task execution plan is re-determined based on the multiple rounds of session messages in the session interface;

[0013] The re-determined structured task execution plan is taken as a second response message of the second session message.

[0014] Further, the database domain knowledge base is related to one or more of the standard operation process, the standard operation specification, the tenant permission information, the security operation strategy, the interface calling document, and the interface calling parameter of the at least one database.

[0015] Further, when the second session message input by the user is detected as a confirmation of the structured task execution plan, the method further comprises:

[0016] According to a predetermined complexity determination manner, a plan complexity of the structured task execution plan is determined;

[0017] When the plan complexity meets a preset condition, a target execution workflow is generated based on the structured task execution plan;

[0018] The target execution workflow comprises at least one execution node, and attribute information of the execution node is used to represent a node execution function.

[0019] Further, the generating of the target execution workflow based on the structured task execution plan comprises:

[0020] Task decomposition is performed on the structured task execution plan, and a workflow is arranged for subtasks obtained by the decomposition;

[0021] The target execution workflow is determined based on the arranged workflow.

[0022] Further, the method further comprises:

[0023] The target execution workflow is displayed as a third response message in the session interface; and,

[0024] The executed execution nodes are displayed in a first form, and the unexecuted execution nodes are displayed in a second form;

[0025] The presentation form of the execution nodes is related to the execution progress of the structured task execution plan.

[0026] Further, the method further comprises:

[0027] In response to detecting an event that the structured task execution plan has an execution exception, generating an exception warning information, and displaying the exception warning information as a fourth response message in the conversation interface; or,

[0028] In response to detecting an event that the structured task execution plan is executed, generating an analysis report, and displaying the analysis report or a report link of the analysis report as a fourth response message in the conversation interface.

[0029] The analysis report is related to at least execution information of the structured task execution plan.

[0030] In a second aspect, the embodiments of the present application further provide an operation and maintenance device applied to a database, and the device comprises:

[0031] A conversation message acquisition module is configured to display a conversation interface associated with a database maintenance system, and acquire a first conversation message input by a user in the conversation interface, wherein the first conversation message is related to operation and maintenance requirements of at least one database.

[0032] A response message acquisition module is configured to search in a database field knowledge base based on the first conversation message, obtain a first response message, and display the first response message in the conversation interface, wherein the first response message at least includes a structured task execution plan corresponding to the first conversation message.

[0033] A database operation and maintenance module is configured to perform operation and maintenance on the at least one database based on the structured task execution plan when detecting that a second conversation message input by the user is to confirm the structured task execution plan.

[0034] The structured task execution plan is related to specific execution information when performing operation and maintenance on the database.

[0035] In a third aspect, the embodiments of the present application further provide a server, comprising:

[0036] One or more processors;

[0037] A memory is configured to store one or more programs;

[0038] When the one or more programs are executed by the one or more processors, the one or more processors are enabled to perform the operation and maintenance method applied to a database as provided in any embodiment of the present application.

[0039] In a fourth aspect, the embodiments of the present application further provide a computer readable storage medium, which stores a computer program, and the computer program is executed by a processor to implement the operation and maintenance method applied to a database as provided in any embodiment of the present application.

[0040] In a fifth aspect, the embodiments of the present application further provide a computer program product, which comprises a computer program, and the computer program is executed by a processor to implement the operation and maintenance method applied to a database as provided in any embodiment of the present application.

[0041] The technical solution provided by the embodiments of the present application can open an application program or a program interface corresponding to a database maintenance system to display a session interface related to the database maintenance system in the current terminal device when the user of operation and maintenance has a demand for database operation and maintenance. In the session interface, the user of operation and maintenance can input a first session message related to the content of database operation and maintenance. At this time, the background service or the database maintenance system can analyze and process the first session message, and the analysis and processing at this time not only includes semantic analysis and processing of large language, but also includes querying a knowledge graph constructed based on the content of the database, so that operation and maintenance feedback information, i.e., a first response message, which is adapted to the first session message, can be obtained. In the case that the intelligent operation and maintenance user confirms that the operation and maintenance plan in the first response message is available, the corresponding database can be intelligently maintained, thereby solving the problem of low efficiency in the prior art that the user of database operation and maintenance needs to input a series of operations on the database, and achieving the effect of operation and maintenance of the database based on the session.

[0042] It should be understood that the content described in this part is not intended to identify the key or important features of the embodiments of the present application, nor is it used to limit the scope of the present application. Other features of the present application will become apparent from the following description. BRIEF DESCRIPTION OF DRAWINGS

[0043] In order to more clearly illustrate the technical solutions of the example embodiments of the present application, the drawings needed in the description of the embodiments are briefly introduced as follows. Obviously, the drawings introduced are only a part of the drawings of the embodiments to be described by the present application, and not all the drawings. Those skilled in the art can also obtain other drawings from these drawings without creating any creative labor.

[0044] Figure 1 A flowchart of an operation and maintenance method applied to a database provided by the present application;

[0045] Figure 2 A schematic diagram of the session interface provided by the present invention;

[0046] Figure 3 A schematic diagram of the session interface provided by the present invention;

[0047] Figure 4 A schematic diagram of the session interface provided by the present invention;

[0048] Figure 5 A flowchart illustrating a database operation and maintenance method provided by this invention;

[0049] Figure 6 A schematic diagram of the session interface provided by the present invention;

[0050] Figure 7 A flowchart illustrating a database operation and maintenance method provided by this invention;

[0051] Figure 8 A schematic diagram of the session interface provided by the present invention;

[0052] Figure 9 An overall framework diagram of a database operation and maintenance method provided by the present invention;

[0053] Figure 10 A schematic diagram of a database operation and maintenance device provided by the present invention;

[0054] Figure 11 This is a schematic diagram of a server structure provided by the present invention. Detailed Implementation

[0055] The present invention will now be described in further detail with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and not intended to limit it. Furthermore, it should be noted that, for ease of description, the accompanying drawings show only the parts relevant to the present invention, and not all of the structures.

[0056] Before introducing the technical solutions provided in the embodiments of the present invention, the application scenarios can be illustrated by example. When users have maintenance needs for databases, intelligent maintenance of the database can be performed based on the solutions provided in the embodiments of the present invention. Alternatively, the methods provided in the embodiments of the present invention can be integrated as a functional module into an existing application. Alternatively, the methods provided in the embodiments of the present invention can be implemented as a web-based application.

[0057] It should be noted that the specific presentation of the technical solutions provided in the embodiments of the present invention will not be elaborated in this embodiment; only the functions that can be achieved will be described here.

[0058] Firstly, the terms related to the scheme provided by the embodiments of the present application are explained:

[0059] User: administrator user or database operation and maintenance user who has the demand for database management. The user can input a series of session messages related to the database operation and maintenance demand in the session interface.

[0060] Correspondingly, the session message is mainly the message input by the user.

[0061] Response message: feedback message output and displayed in the session interface by the database maintenance system after processing the session message input by the user.

[0062] Figure 1 A flowchart of the operation and maintenance method applied to the database provided by the present application can be applied to the scene of operating and maintaining the database. The method can be executed by an operation and maintenance device applied to the database. The device can be realized in the form of hardware and / or software. The operation and maintenance device applied to the database can be configured in a computing device. Optionally, the hardware can be an electronic device, a server, a mobile terminal, a PC terminal, etc.

[0063] As shown in Figure 1 The steps provided by the embodiments of the present application are as follows:

[0064] S110, a session interface associated with a database maintenance system is displayed, and a first session message input by a user in the session interface is obtained.

[0065] Among them, the database maintenance system is a system aiming at intelligently maintaining at least one database associated therewith. The corresponding database intelligent maintenance method in the database intelligent maintenance system is the scheme provided by the embodiments of the present application.

[0066] In actual application, if the user has the demand for database intelligent maintenance, the program interface corresponding to the database maintenance system can be triggered to display the session interface. The session interface is an interactive window for the user to dialogue with the database maintenance system. The database intelligent maintenance user can input the session message in the session interface. The database maintenance system can feed back the feedback message corresponding to the session message according to the session message input by the user, and display the feedback message in the session interface. In the embodiment, the advantage of the session interface is that the interaction between the user and the database maintenance system can be displayed in a visualized manner, realizing the visualized effect of the operation and maintenance process.

[0067] Further, the conversation interface can carry a plurality of conversation messages input by the user and feedback messages fed back by the system. The conversation messages are usually represented in the form of text, audio, video, etc. Optionally, in the case of text conversation messages, it can be a text or at least one keyword. It should be noted that the conversation messages are related to the operation and maintenance requirements of at least one database. The database operation and maintenance requirements of the user can be input in the input box in the conversation interface. After the input is completed, when the user triggers the confirmation button in the conversation interface, the requirement information is displayed as the first conversation message on the conversation interface.

[0068] For example, an application corresponding to the database maintenance system is taken as an example for illustration. Referring to FIG. 1, an application corresponding to the database maintenance system is taken as an example for illustration. FIG. 1 is a schematic diagram of an application corresponding to the database maintenance system according to an embodiment of the present application. Figure 2 When the user has a database operation and maintenance requirement, the application of the database operation and maintenance system can be triggered, at which time the conversation interface shown in FIG. 2(a) can be displayed. The user can input the operation and maintenance requirement description text in the input box 21. Optionally, the description text is: “add nodes to the order cluster”. After the input is completed and the confirmation button 22 is clicked, the operation and maintenance requirement description text input by the user can be displayed as the first conversation message 23 in the conversation interface, as shown in FIG. 2(b). Figure 2 Figure 2

[0069] S120, based on the first conversation message, searching in the database field knowledge base to obtain a first response message, and displaying the first response message in the conversation interface.

[0070] In the first response message, at least a structured task execution plan corresponding to the first conversation message is included.

[0071] In the present embodiment, the database field knowledge base is a search library generated from official documents, technical guidelines, historical fault reports and solutions related to database operation and maintenance knowledge. The first response message is a feedback message output by the system when the user inputs the first conversation message. The feedback message at least displays a structured task execution plan generated according to the first conversation message. That is, the first response message includes a structured task execution plan corresponding to the first conversation message.

[0072] ​​The structured task execution plan is an action plan that can be read by a machine and maintain the database. It should be noted that the first response message fed back by the database maintenance system contains the structured task execution plan when there is an explicit operation and maintenance requirement in the first session message. When there is no operation and maintenance requirement in the first session message input by the user, the first response message fed back by the database maintenance system does not contain the structured task execution plan. For example, when the first session message input by the user is "What is the weather today?", the database maintenance system does not parse an operation and maintenance requirement in the first session message. Therefore, the first response message fed back by the database maintenance system does not contain the structured task execution plan.

[0073] In this embodiment, the way of searching in the database field knowledge base can be to retrieve information from the database field knowledge base through a retrieval-augmented generation (RAG) technology. The retrievable information includes but is not limited to the standard process and specification of database operation, the permission requirement and security policy of each type of operation, the historical operation record and best practice case, and the application programming interface (API) and parameter description of the system application program.

[0074] Specifically, after the system obtains the first session message input by the user, the system searches in the database field knowledge base based on the content in the first session message. After the database operation and maintenance knowledge related to the content of the first session message is searched, the first response message can be generated according to the searched data. The first response message is displayed in the session interface for the user to view.

[0075] On the basis of the above examples, it can be seen from Figure 3 that the first response message 31 generated by the database maintenance system can be displayed in the session interface. At this time, the first response message can include an execution plan. Optionally, the execution plan is a database expansion plan confirmation. The execution plan is generated by the system according to the operation and maintenance requirement "add nodes to the order cluster" input by the user. The database maintenance system generates a structured task execution plan according to the first session message and the information searched from the database field knowledge base, which is described in detail in Figure 3 .

[0076] The first response message shows the benefits of: facilitate timely confirmation of structured task execution plan in the first response message. User based on the above text input next session message, confirm whether to execute the system generated structured task execution plan. If the user input second session message contains the meaning of the text "confirmation" and / or "execution", the user agrees to the system to execute the structured task execution plan in the first response message. At this time, the system immediately executes the structured task execution plan.

[0077] S130, when detecting that the second session message input by the user is to confirm the structured task execution plan, performing operation and maintenance on at least one database based on the structured task execution plan.

[0078] The structured task execution plan is related to specific execution information when performing operation and maintenance on the database.

[0079] In this embodiment, the second session message is feedback made by the user according to the first response message issued by the system, which is used to confirm whether to execute the structured task execution plan in the first response message. For example, the user can make three types of feedback: "execute immediately", "modify the plan" or "cancel the operation". The structured task execution plan involves specific execution information when the database is running. The specific execution information can be specific detail information related to the actual operation. The specific detail information includes but is not limited to target cluster, operation content, estimated impact, execution time, resource cost, risk assessment, etc.

[0080] Specifically, after the first response message is displayed in the session interface, the user feeds back according to the structured task execution plan displayed in the first response message. It can be understood that the second session message is input in the session interface to respond whether to approve the structured task execution plan given by the system. When the second session message input by the user is the text to confirm the execution of the structured task execution plan, the system performs operation and maintenance on at least one database according to the specific execution information contained in the structured task execution plan.

[0081] For example, continuing to refer to Figure 3 The database maintenance system displays the structured task execution plan as the first response message 31 in the session interface, and the user judges whether the structured task execution plan in the first response message is feasible. The confirmation content is input in the input box of the session interface. After clicking the confirmation button, the content in the input box is displayed as the second session message 32 in the session interface. If the user input second session message contains the meaning of the text "confirmation" and / or "execution", it means that the user agrees to the system to execute the structured task execution plan in the first response message.

[0082] The technical scheme provided by the embodiment of the application can open an application program or a program interface corresponding to the database maintenance system to display a session interface related to the database maintenance system in the current terminal device when the user of operation and maintenance management has a demand for database operation and maintenance. In the session interface, the user of operation and maintenance can input a first session message related to the content of database operation and maintenance. At this time, the background service or the database maintenance system can analyze and process the first session message. The analysis and processing at this time not only includes semantic analysis and processing of large language, but also includes querying a knowledge graph constructed based on database content, so that operation and maintenance feedback information, that is, a first response message, that is adapted to the first session message can be obtained. In the case that the user of operation and maintenance confirms that the operation and maintenance plan in the first response message is available, the corresponding database can be intelligently maintained, solving the problem that in the prior art, the user of database operation and maintenance needs to input a series of operations on the database, and the efficiency is low, and achieving the effect of intelligently operating and maintaining the database based on the session mode.

[0083] In actual application, there are cases that the first response message fed back by the database maintenance system meets the user demand. Meanwhile, there are also cases that the first response message fed back by the database maintenance system does not meet the user demand. In the case that the first response message does not meet the user demand, the user can input a second session message in the input box of the session interface. The meaning of the second session message is related to the regenerated structured task execution plan. Optionally, the method further includes:

[0084] In response to the second session message being an event of adjusting the structured task execution plan, the structured task execution plan is re-determined based on the multiple rounds of session messages in the session interface; and the re-determined structured task execution plan is taken as a second response message of the second session message.

[0085] It should be noted that the first and the second are only descriptions of the session messages, and do not limit the number of the session messages.

[0086] The second session message is a session message input by the user based on the first response message. The session message can be a session that does not meet the expectation of the structured task execution plan, or a session that specifically adjusts the structured task execution plan. The event of adjusting the structured task execution plan can be understood as the information represented in the second session message adjusting the structured task execution plan. The multi-round session information is a multi-round interactive dialogue between the user and the system in the session interface. The second response message is the adjusted structured task execution plan. Based on the above embodiment, it can be known that "first" and "second" are only descriptions distinguishing different session messages. In the session interface, a session message can be input by the user after multi-round session interaction. Further, the database maintenance system feeds back a response message according to the session message of the user, and a group of "session-response" message pairs is regarded as a round of session interaction. The structured task execution plan meeting the expectation is regenerated in combination with the multi-round session message in the session interface. The way of redetermining the structured task execution plan can be referred to the detailed description in the above embodiment, which will not be specifically described here. At this time, the redetermined structured task execution plan can be taken as the second response message in the session interface.

[0087] Specifically, when the user inputs the second session information, the database maintenance system parses the second session message content and detects that there is content related to adjusting the structured task execution plan in the second session message, and then the system performs the event of adjusting the structured task execution plan. The structured task execution plan is adjusted according to the multi-round session message in the session interface. Further, the adjusted structured task execution plan is displayed as the second response message on the session interface for the user to view. Through natural language dialogue, the structured task execution plan generated by the system can be automatically adjusted, a manual decision point is embedded in the automatic process, the complexity of database operation and maintenance is reduced, and real-time feedback after adjustment can be presented.

[0088] For example, referring to Figure 4 When the first response message fed back by the database maintenance system does not meet the expectation, the user can input a second session message in the input box of the session interface, and the second session message is related to the first response message in the session interface. After the user inputs and clicks the confirmation button, the session interface shown in Figure 4 (a) can be displayed. Optionally, the description text input by the user in the input box of the session interface is "change the storage to 1TB". The input description text can be displayed as the second session message 41 in the session interface. The database maintenance system parses the content in the second session message and adjusts the structured task execution plan. The structured task execution plan adjusted according to the second session message is displayed as the second response message 42 in the session interface, as shown in Figure 4 (b).

[0089] The system will retrieve information from the database domain knowledge base based on the user-input session information. Next, the construction of the database domain knowledge base will be introduced to generate an accurate structured task execution plan.

[0090] Optionally, the database domain knowledge base is related to one or more of the following: standard operating procedures, standard operating specifications, tenant permission information, security operating policies, API call documentation, and API call parameters of at least one database.

[0091] The standard operating procedure (SOP) outlines the steps for performing specific database tasks. The standard operating procedure specification (SOP) outlines the guidelines to be followed when operating the database. Tenant permission information is a list of users, roles, and their corresponding access permissions in a multi-tenant database environment. It is used for permission review, permission application guidance, and security compliance checks. The security operation policy outlines the security regulations and specific measures established to protect database data from unauthorized access, disclosure, and tampering. The interface call documentation describes the interaction with database-related automation platforms or operation and maintenance tools, defining available functions, access addresses, and communication protocols. Interface call parameters are the specific input information required when calling the interface.

[0092] Specifically, the construction of a database domain knowledge base is related to at least one database's standard operating procedures, standard operating specifications, tenant permission information, security operation policies, API call documentation, and API call parameters, among other things. To obtain structured task execution plans, the system builds a database domain knowledge base, which can be searched based on session messages. Operational maintenance must follow the standard operating procedures, standard operating specifications, and security operation policies embedded in the knowledge base. By integrating API call documentation and API call parameters into the database domain knowledge base, the system can retrieve relevant content and use this to structure task execution plans, achieving automated and intelligent operations, thus improving efficiency.

[0093] Figure 5 This is a flowchart illustrating a database operation and maintenance method provided by the present invention. Based on the foregoing embodiments, after confirming the feasibility of the structured task execution plan in the first response message and / or the second response message, a plan execution mode adapted to the structured task execution plan can be determined. Specific implementation methods can be found in the detailed description of this embodiment, wherein technical terms that are the same as or corresponding to those in the above embodiments are not repeated in this embodiment.

[0094] like Figure 5 As shown, the method provided in this embodiment of the invention is as follows:

[0095] S510. Determine the plan complexity of the structured task execution plan according to the predetermined complexity determination method.

[0096] The complexity determination manner is a check rule determined according to a preset rule. Generally, for a structured task execution plan, the complexity of a limited number of node execution is a simple task. When there are multiple nodes in the structured task execution plan and there is an interaction relationship between the nodes, the complexity of the structured task execution plan is determined as a complex task. The complexity determination manner can be determined according to the number of execution nodes and the interaction relationship between the nodes. The database maintenance system generates a corresponding workflow according to the structured task execution plan, reads the number of execution nodes and the interaction information between the nodes according to the workflow. Based on this, according to the determination manner of the plan complexity, the structured task execution plan is determined as a simple task or a complex task. The plan complexity is an index for evaluating the execution difficulty of the structured task execution plan.

[0097] Next, how the database maintenance system determines the plan complexity of the structured task execution plan is further described.

[0098] In this embodiment, the preset conditions for determining the plan complexity include but are not limited to the number of operation steps, the dependency relationship, the execution time, the risk value and the like. Optionally, the preset conditions are set as non-single step, the dependency relationship between steps, the need for state tracking and transaction guarantee, the execution time higher than a preset execution time threshold and high risk and the like. If at least one of the preset conditions is met, it is determined that the structured task execution plan is a complex task. The preset execution time threshold is the time for executing the structured task execution plan. If the preset execution time threshold is set as 30s, the execution of the structured task execution plan is a single step, there is no state dependency relationship between the steps, the execution time is less than 30s and it is determined as a low-risk operation, the execution of the structured task execution plan is determined as a simple task. The simple plan can be a plan for querying monitoring data, creating a database user and restarting an example. The complex plan can be a plan for cluster expansion, database version upgrade and data archiving.

[0099] S520, when the plan complexity meets the preset conditions, generating a target execution workflow based on the structured task execution plan.

[0100] The target execution workflow includes at least one execution node, and the attribute information of the execution node is used to represent the node execution function. In this embodiment, the preset condition is a complexity of one type. Optionally, the preset condition is set as a complex task with a calculation complexity of the structured task execution plan. The plan complexity of the structured task execution plan is compared with the preset condition, and when the preset condition is met, it is indicated that the structured task execution plan is a complex task. The target execution workflow is a data flow based on the structured task execution plan and executed according to at least one step or process. The target execution workflow includes a plurality of execution nodes, and the events executed by different execution nodes are different. The execution node is represented in a visual form and is an execution unit in the target execution workflow. Each execution node includes a corresponding execution function, and the execution function is stored in the attribute information of the execution node. The execution function corresponding to the execution node includes but is not limited to an executable execution program, an executable tool, an input parameter, an output result, and a state.

[0101] After the target execution workflow is generated, the system calls the work engine to execute the arranged target execution workflow. Further, the underlying service is called through a unified atomic API interface layer. The atomic API is an interface encapsulating a complete business function. The service is called through the atomic API interface, that is, the technical module executing a specific task is called through the encapsulated interface. The unified atomic API interface layer includes a management platform API, a performance monitoring API, a data archiving API, a query service API, and other platform APIs. The management platform API is responsible for the creation, configuration, and deletion of database instances, and other life cycle management. The performance monitoring API provides real-time monitoring data query and performance index analysis capabilities. The data archiving API processes historical data archiving, backup recovery, and other storage management. The query service API executes SQL query and slow log analysis, and other data operations. The other platform API includes permission verification, log service, and alarm notification, and other auxiliary functions.

[0102] For a complex structured task execution plan, there can be multiple execution nodes. Here, the target execution workflow generated based on the structured task execution plan is expanded and described.

[0103] The structured task execution plan can be task decomposed, and the decomposed subtasks can be workflow arranged; based on the arranged workflow, the target execution workflow is determined.

[0104] The task decomposition is a process of decomposing the structured task execution plan into multiple tasks. Each subtask can correspond to an execution node. The execution node can be understood as the smallest task unit in the structured task execution plan, and one execution node can correspond to a command, a call, or a database operation, etc. The workflow arrangement is a process of defining the execution order for all subtasks on the basis of task decomposition. The arranged workflow is a data flow after arrangement processing, which includes all subtasks and contains the execution order. The database maintenance system takes the arranged workflow that can be used for execution as a target execution workflow. The target execution workflow is represented by visual execution nodes, and the target execution workflow containing at least one visual execution node can be displayed in the session interface as a third response message.

[0105] Specifically, the structured task execution plan is obtained, and task decomposition is performed thereon. The structured task execution plan is decomposed into at least one subtask, and workflow arrangement is performed on all subtasks to determine the execution logic of all subtasks, and finally a target execution workflow that can be executed is determined. The target workflow is generated through task decomposition and workflow arrangement, an optimal execution path is constructed for a complex task, a clear logical running state is provided, and the efficiency of executing database operation and maintenance is improved.

[0106] To facilitate the user to know the execution progress in time, the target execution workflow is displayed as a third response message in the session interface, and the executed execution nodes are displayed in a first form and the unexecuted execution nodes are displayed in a second form. The presentation form of the execution node is related to the planned execution progress of the structured task execution plan.

[0107] In this embodiment, the third response message is a visual presentation of the target execution workflow generated by the system according to the structured task execution plan. The target execution workflow contains at least one execution node. The execution node can contain various forms, and different forms represent different completion progress of the event corresponding to the execution node. The different presentation forms of the execution node can be distinguished by the color, icon shape and icon style of the node. Optionally, the first form can include a check mark pattern, and the second form can be a white circular node form, etc. When the execution node is displayed in the first form, it indicates that the event corresponding to the execution node has been executed. When the execution node is displayed in the second form, it indicates that the event corresponding to the execution node has not been executed. The current planned execution progress is represented by changing the form of the execution node in the target execution workflow. The planned execution progress is the degree of completion of the structured task execution plan, and the presentation form of the execution node is modified according to the planned execution progress.

[0108] Specifically, the generated target execution workflow is acquired, and the target execution workflow is displayed in the session interface as a third response message for the user to view. The target execution workflow includes a plurality of execution nodes. According to the plan execution progress of the structured task execution plan, the form display of the execution nodes is set. The executed nodes are displayed in a first form, and the unexecuted nodes are displayed in a second form. By displaying the target execution workflow in the session interface and changing the form display of the execution nodes according to the plan execution progress, the progress is intuitively fed back to the user, and the task execution has transparency and observability.

[0109] For example, referring to Figure 6 The database maintenance system generates the target execution workflow in a visual form as the third response message 61 displayed in the session interface. The target execution workflow includes at least one execution node in different forms, and the interaction relationship between the execution nodes is represented in a straight line form. Optionally, according to the current plan execution progress, the first form of the execution node 62 corresponding to the completed event is set to a "check mark" style, and the second form of the execution node 63 corresponding to the uncompleted event is set to a "blank" style. It can be explained that, different from the forms of the executed nodes and the unexecuted nodes, the form of the execution node 64 corresponding to the abnormal event is set to a "red" style. The first form and the second form mentioned in the above example are only illustrative, and in actual application, the forms can be set according to specific needs.

[0110] The technical scheme provided by the embodiment of the application determines the complexity determination manner of the structured task execution plan in advance in the case where it is confirmed that the structured task execution plan in the first response message and / or the second response message is feasible. According to the complexity determination manner determined in advance, the database maintenance system judges the plan complexity of the current structured task execution plan. Further, one of the plan complexities is set as a preset condition in advance. When the plan complexity meets the preset condition, the database maintenance system generates a target execution workflow according to the structured task execution plan. The double-path execution mechanism is realized, the plan complexity is judged, the execution path is determined according to the plan complexity, the accuracy of database operation and maintenance under the condition of complex tasks is improved, and misoperation is prevented.

[0111] Figure 7 A flowchart of an operation and maintenance method applied to a database is provided in the embodiment. The specific operation steps of the database maintenance system when detecting that the structured task execution plan has an execution abnormal event are introduced on the basis of the optional embodiment, and the subsequent process after the completion of the structured task execution plan is further described. As shown in Figure 7 The method provided by the embodiment of the application is specifically as follows:

[0112] S710, determine whether the structured task execution plan has an execution exception; if yes, execute S720; if no, execute S730.

[0113] S720, in response to detecting an event that the structured task execution plan has an execution exception, generate an exception warning information, and display the exception warning information as a fourth response message in the conversation interface.

[0114] The execution exception can be understood as an error detected by the system during the process of executing the structured task execution plan to maintain the database. The exception warning information is structured information generated by the system for the execution exception event. The content in the structured information includes but is not limited to exception node position, exception type, and error details. The fourth response message is information fed back to the user based on the execution state during the completion or execution of the structured task execution plan. After detecting the event of execution exception and generating the exception warning information, the system generates the fourth response message based on the exception warning information, and displays the fourth response message in the conversation interface for the user to view.

[0115] Specifically, during the execution of the structured task execution plan, the system will monitor the data synchronization progress in real time, and collect the system resource usage. When detecting that the structured task execution plan has an exception, i.e., the data state deviates from the expected successful state, the system generates an exception warning information based on the exception node position, exception type, and other information. Further, the exception warning information is displayed as a fourth response message in the conversation interface for the user to view.

[0116] S730, in response to detecting an event that the structured task execution plan has an execution completion, generate an analysis report, and display the analysis report or a report link of the analysis report as a fourth response message in the conversation interface.

[0117] The analysis report is at least related to the execution information of the structured task execution plan.

[0118] In the embodiment, the execution completion can be understood as that the system detects that all steps in the structured task execution plan have been completely run. The analysis report is generated by the system based on the analysis of the database operation and maintenance situation after the execution of the structured task execution plan is completed. The analysis report is at least related to the structured task execution plan, and the report includes but is not limited to the newly added node information, the completion progress, the completion event, the node state situation, the load balancing, the monitoring index and the like. Since the content displayed in the session interface is limited, in order to realize the effect that all contents in the analysis report can be displayed to the user through one page, the analysis report can be stored in the cloud. The analysis report can be stored in the form of a hyperlink, and the hyperlink is taken as the report link of the analysis report. The report link is the hyperlink corresponding to the analysis report generated by the system. When the user triggers the report link, the intelligent analysis report can be called from the cloud, and the report can be displayed in full screen. Through one page, all contents in the analysis report can be completely displayed, and the user does not need to view the corresponding analysis report content by page scrolling. When it is detected that the structured task execution plan is completed, the fourth response message is the analysis report automatically generated by the system or the report link corresponding to the analysis report. The form of the fourth response message can be a document and / or a document link.

[0119] Specifically, after detecting that all events corresponding to the execution nodes in the target execution workflow have been completed, it is indicated that the structured task execution plan generated by the database maintenance system has been completely executed. Further, during the execution of the structured task execution plan, the database maintenance system synchronously collects data such as the data synchronization progress related data and the system resource usage situation. According to the information collected by the database maintenance system, the analysis report is generated. At the same time, the analysis report is displayed in the session interface in the form of text or report link as the fourth response message.

[0120] For example, Figure 8 After detecting that the database maintenance system has completed the execution of the structured task execution plan, the information related to the structured task execution plan collected by the database maintenance system during the execution is used to generate an analysis report. The analysis report is displayed in the session interface as the fourth response message 81. Optionally, the intelligent session report is displayed in the session interface in the form of text, and the description text can be: Order database expansion task has been completed New nodes: node-7, node-8 (8 cores 16 GB / 1 TB SSD) Data synchronization: 100% complete, time-consuming 38 minutes Cluster state: healthy, currently 6 nodes Load balancing: new nodes have joined the read-write pool Monitoring index: all service indexes are normal Detailed technical report has been generated, and can be clicked (view details) to obtain.

[0121] The technical solution provided in this invention determines whether an execution anomaly exists in the structured task execution plan. If an execution anomaly is detected, an anomaly warning is generated based on the status information in this event and displayed as a fourth response message in the session interface. If the structured task execution plan is detected as completed, an analysis report is generated based on the completion status. The analysis report and / or the corresponding report link are displayed as a fourth response message in the session interface. This enhances the observability of the operation and maintenance process, providing users with an intuitive database management and operation and maintenance experience. Real-time collection of status information during the operation and maintenance process establishes proactive risk warnings and timely pushes anomaly warning information, improving the efficiency of human-machine collaboration.

[0122] Figure 9 This invention provides an overall framework diagram for a database operation and maintenance method, combined with... Figure 9 Understand the technical solutions of the embodiments of the present invention.

[0123] like Figure 9 As shown, this embodiment explains the overall implementation of the solution based on the above optional implementation methods. Specifically, it includes:

[0124] First, when a user has a database operation and maintenance management need, they enter a natural language command in the input box of the session interface. This natural language command is related to the database operation and maintenance. After the user clicks the confirmation button, the natural language command entered by the user is received by the database maintenance system as the first session message and displayed on the session interface. After receiving the user's natural language command, the system performs intent recognition on the natural language command. Based on the natural language command, it retrieves information related to the natural language command from the domain knowledge base (database domain knowledge base). The related information includes, but is not limited to, standard procedures and specifications for database operations, permission requirements and security policies for various types of operations, historical operation records, and system application programming interface documents and parameter descriptions. The system generates a structured execution plan (structured task execution plan) based on the information retrieved from the domain knowledge base (database domain knowledge base).

[0125] For example, when a user enters the natural language command "Add a node to the order cluster" in the session interface, the system receives the command and retrieves relevant information from the domain knowledge base (database domain knowledge base). It then generates a structured execution plan based on the domain knowledge. The system recognizes "Add a node to the order cluster" in the user's natural language command as an expansion. The system retrieves hardware and configuration standards related to the order cluster business, as well as corresponding standard procedures, specifications, and strategies for database operations from the domain knowledge base.

[0126] Further, the generated structured task execution plan is displayed as the first session message on the session interface. The system converts the generated structured task execution plan into the first session message as “[Database Expansion Plan Confirmation] Target Cluster: Order Database Operation Content: Add 2 compute nodes Node Specification: 8-core 16-GB memory, 500-GB SSD storage Expected Impact: Read-write delay may increase by 10-20% during data synchronization Execution Duration: About 45 minutes Resource Cost: Daily increase of xxx Risk Assessment: Low risk, automatic rollback mechanism is ready Please confirm: [Execute immediately] [Modify the plan] [Cancel the operation]”.

[0127] After the user views the structured task execution plan presented by the system on the session interface, the user is requested to confirm whether the structured task execution plan is implemented. If the user chooses to cancel, the process is terminated and the user is informed. If the user inputs a second session message related to adjusting the structured task execution plan, the system parses the second session message and regenerates a second response message corresponding to the adjusted structured task execution plan. If the user chooses to execute immediately, the user needs to input "execute immediately" related session content in the input box on the session interface, indicating that the user has confirmed the structured task execution plan. After the user confirms, the system judges the complexity of the structured task execution plan. A preset condition is set, which includes but is not limited to operation steps, state dependency relationship execution time, and risk value. If at least one of the preset conditions in the structured task execution plan is met, it is judged as a complex task. Otherwise, it is judged as a simple task. When the structured task execution plan is a complex task, the system decomposes the structured task execution plan to obtain at least one subtask of the structured task execution plan, and arranges a completed workflow according to the logical dependency relationship of the obtained subtasks. Based on the arranged workflow, the workflow engine is called for sequential execution. Then the unified atomic API interface is called, and the system calls the underlying service through the unified atomic API interface layer. After the API gateway receives the call request, a series of underlying calls are performed, including management and control platform API, performance monitoring API, data archiving API, query service API, and other platform APIs. When the structured task execution plan is a simple task, the system directly calls the underlying service through the unified atomic API interface layer. According to the instructions of the atomic API, the specific underlying service is called to operate the database and external resources. That is, by executing SQL statements or database management commands, the database instance is directly operated for addition, deletion, modification, and query, and the underlying basic system relied on by the database is operated. Real-time state detection is performed during the execution of the database management and operation process, and the execution results, tracking system resource usage, and detection of whether there are execution exceptions are collected and detected. If an execution exception occurs, an alarm is triggered, an exception warning information is generated, and the exception warning information is converted into a fourth response information and displayed in the session interface as a fourth response message. If the structured task execution plan is completed, a natural language summary (analysis report) is generated, and the natural language summary is directly displayed in the session interface or the report link corresponding to the natural language summary is displayed in the session interface for the user to view.

[0128] The technical scheme provided by the embodiment of the application can open an application program or a program interface corresponding to a database maintenance system to display a session interface related to the database maintenance system in a current terminal device when a user of operation and maintenance has a demand for database operation and maintenance. In the session interface, the user of operation and maintenance can input a first session message related to the content of database operation and maintenance. At this time, the background service or the database maintenance system can analyze and process the first session message. The analysis and processing at this time not only includes semantic analysis and processing of large language, but also includes querying a knowledge graph constructed based on database content, so that operation and maintenance feedback information, that is, a first response message, that is adapted to the first session message can be obtained. In the case that the user of operation and maintenance confirms that the operation and maintenance plan in the first response message is available, the corresponding database can be intelligently maintained, thereby solving the problem that in the prior art, the user of database operation and maintenance needs to input a series of operations on the database, and the efficiency is low, and achieving the effect of operation and maintenance of the database based on the session mode.

[0129] Figure 10 A structural diagram of an operation and maintenance device for a database is provided. Figure 10 As shown in the figure, the device comprises a session message acquisition module 910, a response message acquisition module 920, and a database operation and maintenance module 930.

[0130] The session message acquisition module 910 is configured to display a session interface associated with a database maintenance system and acquire a first session message input by a user in the session interface, wherein the first session message is related to operation and maintenance requirements of at least one database. The response message acquisition module 920 is configured to search in a database field knowledge base based on the first session message to obtain a first response message and display the first response message in the session interface, wherein the first response message at least includes a structured task execution plan corresponding to the first session message. The database operation and maintenance module 930 is configured to perform operation and maintenance on at least one database based on the structured task execution plan when it is detected that a second session message input by the user is a confirmation of the structured task execution plan. The structured task execution plan is related to specific execution information when the operation and maintenance operation is performed on the database.

[0131] The technical solution provided by the embodiment of the application can open an application program or a program interface corresponding to a database maintenance system to display a session interface related to the database maintenance system in the current terminal device when a user of operation and maintenance has a demand for database operation and maintenance. In the session interface, the user of operation and maintenance can input a first session message related to the content of database operation and maintenance. At this time, the background service or the database maintenance system can analyze and process the first session message, and the analysis and processing at this time not only includes semantic analysis and processing of large language, but also includes querying a knowledge graph constructed based on database content, so that operation and maintenance feedback information, that is, a first response message, that is adapted to the first session message can be obtained. In the case that the user of operation and maintenance confirms that the operation and maintenance plan in the first response message is available, the corresponding database can be intelligently maintained, thereby solving the problem that in the prior art, the user of database operation and maintenance needs to input a series of operations on the database, and the efficiency is low, and achieving the effect of intelligently operating and maintaining the database based on the session.

[0132] On the basis of each of the above technical solutions, the device further comprises:

[0133] The plan determination module is configured to, in response to the second session message being an event of adjusting the structured task execution plan, determine the structured task execution plan again based on the multiple rounds of session messages in the session interface.

[0134] The response message determination module is configured to take the determined structured task execution plan again as a second response message of the second session message.

[0135] On the basis of each of the above technical solutions, the database domain knowledge base is related to one or more of a standard operation process, a standard operation specification, tenant permission information, a security operation strategy, an interface calling document, and an interface calling parameter of at least one database.

[0136] On the basis of each of the above technical solutions, the database operation and maintenance module comprises:

[0137] The plan complexity determination unit is configured to determine a plan complexity of the structured task execution plan according to a predetermined complexity determination manner.

[0138] The workflow generation unit is configured to generate a target execution workflow based on the structured task execution plan when the plan complexity meets a preset condition, and the target execution workflow comprises at least one execution node, and attribute information of the execution node is used to represent a node execution function.

[0139] On the basis of each of the above technical solutions, the device further comprises:

[0140] A workflow generation module is configured to perform task decomposition on the structured task execution plan, and to perform workflow arrangement on the decomposed subtasks.

[0141] On the basis of the above technical solutions, the device further comprises:

[0142] A response message display module is configured to display the target execution workflow as a third response message in the conversation interface, and to display the executed nodes in a first form and the unexecuted nodes in a second form; wherein the presentation form of the execution nodes is related to the plan execution progress of the structured task execution plan.

[0143] On the basis of the above technical solutions, the device further comprises: in response to detecting an event that the structured task execution plan has an execution exception, generating an exception early warning information, and displaying the exception early warning information as a fourth response message in the conversation interface; or, in response to detecting an event that the structured task execution plan has completed execution, generating an analysis report, and displaying the analysis report or a report link of the analysis report as a fourth response message in the conversation interface; wherein the analysis report is at least related to the execution information of the structured task execution plan.

[0144] The operation and maintenance device applied to a database provided in the embodiments of the present application can execute the operation and maintenance method applied to a database provided in any embodiment of the present application, and has the function modules and beneficial effects corresponding to the execution method.

[0145] Figure 11 A structural diagram of a server provided by the present application is provided. Figure 11 A block diagram of an exemplary server 12 suitable for use in implementing embodiments of the present application is shown. Figure 11 The server 12 shown is merely one example and should not be construed as limiting the functionality and scope of the embodiments of the present application.

[0146] As shown in Figure 11 The server 12 is shown as a general-purpose computing device. The components of the server 12 can include, but are not limited to, one or more processors or processing units 16, a system memory 28, and a bus 18 that connects the various system components, including the system memory 28 and the processing unit 16.

[0147] Bus 18 represents one or more of several types of bus structures, including a memory bus or memory controller, a peripheral bus, a graphics acceleration bus, a processor or local bus using any of a variety of bus architectures. By way of example, these architectures include Industry Standard Architecture (ISA) bus, Micro Channel Architecture (MCA) bus, Enhanced ISA (EISA) bus, Video Electronics Standards Association (VESA) local bus, and Peripheral Component Interconnect (PCI) bus.

[0148] Server 12 typically includes a variety of computer system readable media. These media can be any available media that is located either internally or externally to server 12, including both volatile and nonvolatile media, removable and non-removable media.

[0149] System memory 28 can include computer system readable media in the form of volatile memory, such as random access memory (RAM) 30 and / or cache memory 32. Server 12 can further include other removable / non-removable, volatile / non-volatile computer system storage media. By way of example only, storage system 34 can be provided for reading from and writing to a non-removable, non-volatile magnetic media (e.g., a "hard drive"). Figure 11 not shown in FIG. 1, can provide volatile memory for storage of information and / or instructions to be executed by processing unit 20. Although exemplary embodiments of the present application are described in the foregoing context of a server, those skilled in the art will appreciate that the acts and / or event description can be applied to any ancillary computing device, such as a desktop, laptop or notebook computer or any other device adapted to interact with a network environment. Figure 11 not shown in FIG. 1, can provide volatile memory for storage of information and / or instructions to be executed by processing unit 20. Although exemplary embodiments of the present application are described in the foregoing context of a server, those skilled in the art will appreciate that the acts and / or event description can be applied to any ancillary computing device, such as a desktop, laptop or notebook computer or any other device adapted to interact with a network environment.

[0150] Program / utility 40 having a set (at least one) of program modules 42 can be stored in, for example, system memory 28 by way of example, such program modules 42 include, but are not limited to, an operating system, one or more application programs, other program modules, and program data, each or some combination thereof, which can include implementation of a network environment. Program modules 42 generally carry out the functions and / or methodologies of embodiments of the present application as described herein.

[0151] The server 12 can also be in communication with one or more external devices 14 such as a keyboard, a pointing device, a display 24, etc.; can also be in communication with one or more devices that enable a user to interact with the server 12; and / or can be in communication with any devices (such as a network card, a modem, etc.) that enable the server 12 to communicate with one or more other computing devices. Such communication can be facilitated by an input / output (I / O) interface 22. Still yet, the server 12 can be in communication with one or more networks (such as a local area network (LAN), a wide area network (WAN), and / or the Internet) through a network adapter 20. As an example, the network adapter 20 can be capable of communicating with the other modules of the server 12 through the bus 18. It should be appreciated that the server 12 can be a part of a larger computer system, including a plurality of servers, each having its own respective bus 18, and a plurality of network adapters 20, each capable of communicating with a plurality of other servers. It should also be appreciated that the server 12 can be capable of executing a variety of applications, programs, and / or components, e.g., a database management system, a web server, a web browser, and the like.

[0152] The processing unit 16 performs various function applications and data processing by running programs stored in the system memory 28, such as implementing the application of the database operation and maintenance method provided in the first embodiment of the present application, which comprises:

[0153] Displaying a session interface associated with the database maintenance system, and obtaining a first session message input by a user in the session interface, wherein the first session message is related to the operation and maintenance requirement of at least one database;

[0154] Searching in the database field knowledge base based on the first session message to obtain a first response message, and displaying the first response message in the session interface, wherein the first response message at least includes a structured task execution plan corresponding to the first session message;

[0155] When it is detected that the second session message input by the user is to confirm the structured task execution plan, performing operation and maintenance on the at least one database based on the structured task execution plan;

[0156] Wherein the structured task execution plan is related to the specific execution information when performing operation and maintenance on the database.

[0157] Of course, those skilled in the art can understand that the processor can also implement the technical solutions of the application of the database operation and maintenance method provided in any embodiment of the present application.

[0158] The embodiment provides a computer readable storage medium, which stores a computer program, and the program is executed by a processor to implement the application of the database operation and maintenance method provided in the foregoing embodiments of the present application, which comprises:

[0159] A session interface associated with the database maintenance system is displayed, and a first session message input by a user in the session interface is obtained, wherein the first session message is related to operation and maintenance requirements of at least one database;

[0160] Based on the first session message, retrieval is performed in a database domain knowledge base to obtain a first response message, and the first response message is displayed in the session interface, wherein the first response message at least includes a structured task execution plan corresponding to the first session message;

[0161] When it is detected that the second session message input by the user is a confirmation of the structured task execution plan, operation and maintenance are performed on the at least one database based on the structured task execution plan;

[0162] The structured task execution plan is related to specific execution information when operation and maintenance is performed on the database.

[0163] The computer storage medium of the embodiment of the application can adopt any combination of one or more computer-readable media. The computer-readable medium can be a computer-readable signal medium or a computer-readable storage medium. The computer-readable storage medium may, for example, be but is not limited to an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or component, or any combination of the above. More specific examples (non-exhaustive list) of the computer-readable storage medium include an electrical connection having one or more wires, a portable computer diskette, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In this document, the computer-readable storage medium can be any tangible medium that contains or stores a program that can be used by or in conjunction with an instruction execution system, device or component.

[0164] The computer-readable signal medium can include a data signal propagated in a baseband or as a part of a carrier wave, in which a computer-readable program code is carried. Such a propagated data signal can take various forms, including but not limited to an electromagnetic signal, an optical signal, or any suitable combination of the above. The computer-readable signal medium can also be any computer-readable medium other than the computer-readable storage medium, which can send, propagate or transmit a program for use by or in conjunction with an instruction execution system, device or component.

[0165] The program code contained on the computer-readable medium can be transmitted by any suitable medium, including but not limited to wireless, wire, optical cable, RF, etc., or any suitable combination of the above.

[0166] Computer program code for carrying out operations of embodiments of the present application can be written in any combination of one or more programming languages, including an object oriented programming language such as Java, Smalltalk, C++ or the like, and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code can execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the latter scenario, the remote computer can be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or the connection can be made to an external computer (for example, through the Internet using an Internet Service Provider).

[0167] It is to be understood that the above description is merely a preferred embodiment of the application and the applied technical principles. Those skilled in the art will understand that the present application is not limited to the specific embodiments described herein, and that various obvious changes, modifications and substitutions can be made without departing from the scope of the present application. Therefore, although the present application has been described in detail through the above embodiments, the present application is not limited to the above embodiments, and can include more other equivalent embodiments without departing from the concept of the present application, and the scope of the present application is determined by the scope of the appended claims.

Claims

1. A database operation and maintenance method, characterized in that, include: Display a session interface associated with the database maintenance system and obtain a first session message entered by the user in the session interface, wherein the first session message is related to the operation and maintenance needs of at least one database; Based on the first session message, a search is performed in the domain knowledge base of the database to obtain a first response message, and the first response message is displayed in the session interface. The first response message includes at least a structured task execution plan corresponding to the first session message. When a second session message input by the user is detected as a confirmation of the structured task execution plan, the at least one database is operated and maintained based on the structured task execution plan; The structured task execution plan is related to the specific execution information when performing operation and maintenance on the database.

2. The method according to claim 1, characterized in that, The method further includes: In response to the second session message indicating an event that the structured task execution plan is to be adjusted, the structured task execution plan is redefined based on the multi-round session messages in the session interface. The redefined structured task execution plan is used as the second response message to the second session message.

3. The method according to claim 1, characterized in that, The database domain knowledge base is related to one or more of the following: the standard operating procedures, standard operating specifications, tenant permission information, security operating policies, interface call documents, and interface call parameters of the at least one database.

4. The method according to claim 1, characterized in that, When the detected second session message from user input confirms the structured task execution plan, the method further includes: The plan complexity of the structured task execution plan is determined according to a predetermined complexity determination method. When the plan complexity meets the preset conditions, the target execution workflow is generated based on the structured task execution plan; The target execution workflow includes at least one execution node, and the attribute information of the execution node is used to characterize the node's execution function.

5. The method according to claim 4, characterized in that, The generation of the target execution workflow based on the structured task execution plan includes: The structured task execution plan is decomposed into tasks, and the resulting subtasks are orchestrated into workflows. Based on the orchestrated workflow, the target execution workflow is determined.

6. The method according to claim 4, characterized in that, The method further includes: The target execution workflow is displayed as a third response message in the session interface; and... Executed nodes are displayed in the first format, and unexecuted nodes are displayed in the second format. The presentation format of the execution node is related to the execution progress of the structured task execution plan.

7. The method according to claim 1, characterized in that, The method further includes: In response to the detection of an execution anomaly in the structured task execution plan, an anomaly warning message is generated and displayed as a fourth response message in the session interface; or, In response to the detection of an event indicating the completion of the structured task execution plan, an analysis report is generated, and the analysis report or a link to the analysis report is displayed in the session interface as a fourth response message; The analysis report is at least related to the execution information of the structured task execution plan.

8. A database operation and maintenance device, characterized in that, include: The session message acquisition module is used to display a session interface associated with the database maintenance system and acquire a first session message entered by the user in the session interface, wherein the first session message is related to the operation and maintenance needs of at least one database. The response message acquisition module is used to retrieve the first response message from the database domain knowledge base based on the first session message, and display the first response message in the session interface. The first response message includes at least a structured task execution plan corresponding to the first session message. The database operation and maintenance module is used to perform operation and maintenance on the at least one database based on the structured task execution plan when the second session message input by the user is detected as a confirmation of the structured task execution plan. The structured task execution plan is related to the specific execution information when performing operation and maintenance on the database.

9. A server-side component, characterized in that, The server includes: One or more processors; Memory, used to store one or more programs; When the one or more programs are executed by the one or more processors, the one or more processors implement the operation and maintenance method for databases as described in any one of claims 1-7.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that, When executed by the processor, the program implements the database operation and maintenance method as described in any one of claims 1-7.

11. A computer program product, comprising a computer program, characterized in that, When the computer program is executed by the processor, it implements the database operation and maintenance method as described in any one of claims 1-7.

Images