One-key database opening method, device, equipment and medium for cloud platform database

Abstract

The present invention provides a one-key database opening method, device, equipment and medium for a cloud platform database, the method comprising: selecting a corresponding database; obtaining the necessary parameters for database opening, filling in the corresponding input box of a graphical interface and submitting a one-key database opening application; calling a template script according to the one-key database opening application, passing the parameters to the template script by means of parameter transmission, and obtaining a complete database opening script file; pushing the database opening script file to a database server through an automated program; and executing the corresponding template script; after the database server executes the database opening script file, the one-key database opening action is completed. The present invention can realize the database opening operation with one key, only after obtaining the relevant information of the user, without having to implement the database opening code by typing a command, with high efficiency and low error rate.

Description

Technical Field

[0001] The present invention relates to the field of cloud platform database management, and in particular to a one-key database opening method, device, equipment and medium for a cloud platform database. Background Art

[0002] The shift to cloud computing is a major change that the industry will face. The emergence of various cloud platforms is one of the most important parts of this transformation. As the name suggests, this platform allows developers to either run written programs in the "cloud", or use the services provided in the "cloud", or both.

[0003] How application platforms are used. When a development team creates an on-premises application (an application that runs within an organization), much of the infrastructure required for the application already exists: the operating system provides basic support for executing applications and accessing storage, and other computers in the organization provide services such as remote storage.

[0004] Currently, more and more units need to rent cloud platforms to complete the automatic deployment of their applications on the cloud, or overflow computing tasks to the cloud to supplement computing power during peak computing demand periods. When renting a database on a cloud platform, the cloud platform's operation and maintenance personnel need to open the database. Currently, the cloud platform's database is opened by the operation and maintenance personnel logging into the corresponding database, obtaining the user's relevant information, and then typing commands to implement the database opening code. The database is opened after the database opening code is executed. Since the user's relevant information and the database opening code are all entered manually, it is bound to be inefficient and prone to errors. Summary of the invention

[0005] The technical problem to be solved by the present invention is to provide a one-key database opening method, device, equipment and medium for a cloud platform database. After obtaining the relevant information of the user, the database opening operation can be realized with one key without having to implement the database opening code by typing a command, which has high efficiency and low error rate.

[0006] In a first aspect, the present invention provides a one-key database opening method for a cloud platform database, comprising the following steps:

[0007] S1. Select the corresponding database;

[0008] S2. Obtain the necessary parameters for opening the database, fill in the corresponding input box in the graphical interface, and submit the one-click database opening application; the parameters include instance name, character set, deployment node, table space, user name, user password, and disk group information;

[0009] S3. Call the template script according to the one-key database opening application, pass the parameters to the template script by means of parameter passing, and obtain a complete database opening script file; the content of the template script includes creating a database name, creating an instance name, creating character set information, creating a deployment node, creating a table space, creating a database user name and password, creating a disk group, creating a user role, and a commonly used basic reinforcement script;

[0010] S4, pushing the database opening script file to the database server through an automated program; and executing the corresponding template script;

[0011] S5. After the database server executes the database opening script file, a one-key database opening action is completed.

[0012] In a second aspect, the present invention provides a one-key database opening device for a cloud platform database, comprising:

[0013] Selection module, used to select the corresponding database;

[0014] The parameter acquisition module is used to obtain the parameters necessary for opening the database, fill in the corresponding input box of the graphical interface, and submit the one-click database opening application; the parameters include instance name, character set, deployment node, table space, user name, user password, and disk group information;

[0015] A calling module is used to call a template script according to the one-key database opening application, pass the parameters to the template script by means of parameter passing, and obtain a complete database opening script file; the content of the template script includes creating a database name, creating an instance name, creating character set information, creating a deployment node, creating a table space, creating a database user name and password, creating a disk group, creating a user role, and a commonly used basic reinforcement script;

[0016] A push module, used to push the database opening script file to the database server through an automated program;

[0017] The execution module executes the database opening script file through the database server to complete the one-key database opening action.

[0018] In a third aspect, the present invention provides an electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the method described in the first aspect when executing the program.

[0019] In a fourth aspect, the present invention provides a computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the method described in the first aspect.

[0020] One or more technical solutions provided in the embodiments of the present invention have at least the following technical effects or advantages: a template script is pre-set, and after obtaining the necessary parameters for opening a library, the template script can be called according to the one-key library opening application, and the necessary parameters are passed to the template script by means of parameter transmission to obtain a complete library opening script file and push it to the database server; the database server can execute the library opening script file to complete the one-key library opening action. Therefore, after obtaining the relevant information of the user, without having to implement the library opening code by typing a command, the library opening operation can be realized by applying for it with one key, which is efficient and has a low error rate.

[0021] The above description is only an overview of the technical solution of the present invention. In order to more clearly understand the technical means of the present invention, it can be implemented according to the contents of the specification. In order to make the above and other purposes, features and advantages of the present invention more obvious and easy to understand, the specific implementation methods of the present invention are listed below. BRIEF DESCRIPTION OF THE DRAWINGS

[0022] The present invention will be further described below in conjunction with embodiments with reference to the accompanying drawings.

[0023] Figure 1 is a flow chart of the method in Embodiment 1 of the present invention;

[0024] Figure 2 A schematic diagram of a graphical interface of the system of the present invention;

[0025] Figure 3 It is a structural schematic diagram of the device in the second embodiment of the present invention;

[0026] Figure 4 This is a schematic diagram of the structure of an electronic device in Embodiment 3 of the present invention;

[0027] Figure 5 Schematic diagram of the structure of the medium in the fourth embodiment of the present invention. DETAILED DESCRIPTION

[0028] The embodiments of the present application provide a one-click database opening method, device, equipment and medium for a cloud platform database. After obtaining relevant information of the user, the database opening operation can be realized with one click without typing a command to realize the database opening code, which has high efficiency and low error rate.

[0029] The technical solution in the embodiment of the present application has the following general idea: a template script is pre-set, and after obtaining the necessary parameters for opening the library, the template script can be called according to the one-key library opening application, and the necessary parameters are passed to the template script by means of parameter transmission to obtain a complete library opening script file and push it to the database server; the database server can execute the library opening script file to complete the one-key library opening action. Therefore, after obtaining the relevant information of the user, without having to implement the library opening code by typing a command, the library opening operation can be realized by applying for it with one click.

[0030] Embodiment 1

[0031] like Figure 1 As shown, this embodiment provides a one-key database opening method for a cloud platform database, comprising the following steps:

[0032] S1. Select the corresponding database;

[0033] S2. Obtain the necessary parameters for opening the database, fill in the corresponding input box in the graphical interface, and submit the one-click database opening application; the parameters include instance name, character set, deployment node, table space, user name, user password, and disk group information;

[0034] S3. Call the template script according to the one-key database opening application, pass the parameters to the template script by means of parameter passing, and obtain a complete database opening script file; the content of the template script includes creating a database name, creating an instance name, creating character set information, creating a deployment node, creating a table space, creating a database user name and password, creating a disk group, creating a user role, and a commonly used basic reinforcement script;

[0035] S4, pushing the database opening script file to the database server through an automated program; and executing the corresponding template script;

[0036] S5. After the database server executes the database opening script file, a one-key database opening action is completed.

[0037] Furthermore, in S2, obtaining the necessary parameters for opening the warehouse includes:

[0038] Automatic filling method, that is, obtaining the parameter files necessary for opening the database, parsing them according to the preset parsing rules and automatically filling them into the corresponding input boxes in the graphical interface;

[0039] Manual filling method, such as Figure 2 As shown, a graphical interface is provided, and the operator directly fills in the necessary parameters for opening the library into the corresponding input box.

[0040] Based on the same inventive concept, the present application also provides a device corresponding to the method in Example 1, see Example 2 for details.

[0041] Embodiment 2

[0042] like Figure 3 As shown, in this embodiment, a one-key database opening device for a cloud platform database is provided, including:

[0043] Selection module, used to select the corresponding database;

[0044] The parameter acquisition module is used to obtain the parameters necessary for opening the database, fill in the corresponding input box of the graphical interface, and submit the one-click database opening application; the parameters include instance name, character set, deployment node, table space, user name, user password, and disk group information;

[0045] A calling module is used to call a template script according to the one-key database opening application, pass the parameters to the template script by means of parameter passing, and obtain a complete database opening script file; the content of the template script includes creating a database name, creating an instance name, creating character set information, creating a deployment node, creating a table space, creating a database user name and password, creating a disk group, creating a user role, and a commonly used basic reinforcement script;

[0046] A push module, used to push the database opening script file to the database server through an automated program;

[0047] The execution module executes the database opening script file through the database server to complete the one-key database opening action.

[0048] Furthermore, this embodiment may also include:

[0049] The automatic filling module is used to obtain the parameter files necessary for opening the database, and automatically fill them into the corresponding input boxes of the graphical interface after parsing according to the preset parsing rules.

[0050] Since the device introduced in the second embodiment of the present invention is a device used to implement the method of the first embodiment of the present invention, those skilled in the art can understand the specific structure and deformation of the device based on the method introduced in the first embodiment of the present invention, so it is not described here in detail. All devices used in the method of the first embodiment of the present invention belong to the scope of protection of the present invention.

[0051] Based on the same inventive concept, the present application provides an electronic device embodiment corresponding to the first embodiment, see the third embodiment for details.

[0052] Embodiment 3

[0053] This embodiment provides an electronic device, such as Figure 4 As shown, it includes a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, any implementation method in the first embodiment can be implemented.

[0054] Since the electronic device introduced in this embodiment is a device used to implement the method in the first embodiment of the present application, based on the method introduced in the first embodiment of the present application, a person skilled in the art can understand the specific implementation of the electronic device of the present embodiment and its various variations, so how the electronic device implements the method in the embodiment of the present application is not described in detail here. As long as a person skilled in the art implements the device used by the method in the embodiment of the present application, it belongs to the scope of protection of the present application.

[0055] Based on the same inventive concept, the present application provides a storage medium corresponding to the first embodiment, see the fourth embodiment for details.

[0056] Embodiment 4

[0057] This embodiment provides a computer-readable storage medium, such as Figure 5 As shown, a computer program is stored thereon, and when the computer program is executed by a processor, any implementation method in Example 1 can be implemented.

[0058] The technical solutions provided in the embodiments of the present application have at least the following technical effects or advantages: the methods, devices, systems, equipment and media provided in the embodiments of the present application,

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

[0060] The present invention is described with reference to flowcharts and / or block diagrams of methods, devices (systems), and computer program products according to embodiments of the present invention. It should be understood that each process and / or block in the flowchart and / or block diagram, as well as the combination of processes and / or blocks in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0061] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.

[0062] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.

[0063] Although the specific implementation modes of the present invention are described above, those skilled in the art should understand that the specific implementation modes described are only illustrative and are not intended to limit the scope of the present invention. Equivalent modifications and changes made by those skilled in the art in accordance with the spirit of the present invention should be included in the scope of protection of the claims of the present invention.

Claims

1. A one-key database opening method for a cloud platform database, characterized in that: The steps include: S1. Select the corresponding database; S2. Obtain the necessary parameters for opening the database, fill in the corresponding input box in the graphical interface, and submit the one-click database opening application; the parameters include instance name, character set, deployment node, table space, user name, user password, and disk group information; The necessary parameters for opening a database include: Automatic filling method, that is, obtaining the parameter files necessary for opening the database, parsing them according to the preset parsing rules and automatically filling them into the corresponding input boxes in the graphical interface; Manual filling method provides a graphical interface, and the operator directly fills in the necessary parameters for opening the library into the corresponding input box; S3. Call the template script according to the one-key database opening application, pass the parameters to the template script by means of parameter passing, and obtain a complete database opening script file; the content of the template script includes creating a database name, creating an instance name, creating character set information, creating a deployment node, creating a table space, creating a database user name and password, creating a disk group, creating a user role, and a commonly used basic reinforcement script; S4, pushing the database opening script file to the database server through an automated program; and executing the corresponding template script; S5. After the database server executes the database opening script file, a one-key database opening action is completed.

2. A one-key database opening device for a cloud platform database, characterized in that: include: Selection module, used to select the corresponding database; The parameter acquisition module is used to obtain the parameters necessary for opening the database, fill in the corresponding input box of the graphical interface, and submit the one-click database opening application; the parameters include instance name, character set, deployment node, table space, user name, user password, and disk group information; The automatic filling module is used to obtain the parameter files necessary for opening the database, and automatically fill them into the corresponding input boxes of the graphical interface after parsing according to the preset parsing rules; A calling module is used to call a template script according to the one-key database opening application, pass the parameters to the template script by means of parameter passing, and obtain a complete database opening script file; the content of the template script includes creating a database name, creating an instance name, creating character set information, creating a deployment node, creating a table space, creating a database user name and password, creating a disk group, creating a user role, and a commonly used basic reinforcement script; A push module, used to push the database opening script file to the database server through an automated program; The execution module executes the database opening script file through the database server to complete the one-key database opening action.

3. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the program, the method according to claim 1 is implemented.

4. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the program is executed by a processor, the method according to claim 1 is implemented.

Images