Processing method for database configuration parameters of heterogeneous database and related products

Abstract

The invention provides a processing method for database configuration parameters of a heterogeneous database and a related product. The processing method comprises the following steps: in response to a database initialization instruction, obtaining each database configuration parameter in the heterogeneous database; the parameter attributes of the database configuration parameters at least comprise an expected mode, and the expected mode is used for representing instance types which can be matched with the database configuration parameters; according to the obtained instance type instruction and the expected mode of each database configuration parameter, judging whether each database configuration parameter is matched with the instance type instruction; and if not, performing isolation marking or isolation on each database configuration parameter which is not matched with the instance type instruction. The processing method can prevent the user from improperly using the database configuration parameters, reduce the learning cost of the user and improve the use experience of the user.

Description

Technical Field

[0001] The present invention relates to the technical field of databases, and in particular to a method for processing database configuration parameters of heterogeneous databases, a computer-readable storage medium, and a computer program product. Background Art

[0002] Currently, relational databases have multiple architecture systems, such as the Oracle architecture system, the MySQL architecture system, the PostgreSQL architecture system, and the SQL Server architecture system, etc. The database configuration parameters (Grand Unified Configuration, abbreviated as GUC), syntax, stored procedures, functions, and basic data types may be different between different architecture systems. Among them, the database configuration parameters are mainly used to control the behavior logic of the database and are important parameters of the database. The number of database configuration parameters is large, and many database configuration parameters of databases with different architecture systems are incompatible.

[0003] In the related art, database products need to be functionally compatible with database instances based on different architecture systems. This requires all database configuration parameters of different architecture systems to be built into the database products so that users can use and set all database configuration parameters. On the one hand, except for the database configuration parameters of the architecture system corresponding to the database instance currently in use by the user, the database configuration parameters of other architecture systems are likely to be misused, thereby affecting the normal execution of database services. On the other hand, when users set architecture system parameters, they will inevitably face a large number of database configuration parameters, which will increase the learning cost of users and affect the user experience. Summary of the Invention

[0004] An object of the present invention is to provide a method for processing database configuration parameters of heterogeneous databases, a computer-readable storage medium, and a computer program product, so as to prevent users from using and setting database configuration parameters that are irrelevant to the currently used database instance, thereby reducing the learning cost of users and improving the user experience.

[0005] Specifically, according to one aspect of the present invention, the present invention provides a method for processing database configuration parameters of heterogeneous databases, including:

[0006] In response to a database initialization instruction, obtain each database configuration parameter in the heterogeneous database; the parameter attributes of the database configuration parameter at least include an expected mode, and the expected mode is used to characterize the instance type that the database configuration parameter can match;

[0007] According to the obtained instance type instruction and the expected mode of each database configuration parameter, determine whether each database configuration parameter matches the instance type instruction;

[0008] If there is no match, isolate and mark or isolate the database configuration parameters that do not match the instance type instruction.

[0009] Optionally, the heterogeneous database can use at least a first instance type and a second instance type; the first instance type and the second instance type are built based on different database architecture systems;

[0010] The expected modes include at least a first mode, a second mode, a general mode, or a default mode; the first mode matches the first instance type, the second mode matches the second instance type, and the general mode and the default mode match the first instance type and the second instance type.

[0011] Optionally, determining whether each of the database configuration parameters matches the instance type instruction according to the obtained instance type instruction and the expected modes of the database configuration parameters includes:

[0012] Determine whether the expected mode of the database configuration parameter is the default mode;

[0013] If it is not the default mode, mark the database configuration parameter as a parameter to be checked;

[0014] In response to obtaining the instance type instruction, compare and match the expected mode of the database configuration parameter marked as the parameter to be checked with the instance type corresponding to the instance type instruction.

[0015] Optionally, determining whether each of the database configuration parameters matches the instance type instruction according to the obtained instance type instruction and the expected modes of the database configuration parameters includes:

[0016] Determine whether the expected mode of the database configuration parameter is the default mode;

[0017] If it is not the default mode, include the database configuration parameter in the group of parameters to be checked;

[0018] In response to obtaining the instance type instruction, compare and match the expected mode of the database configuration parameter within the group of parameters to be checked with the instance type corresponding to the instance type instruction.

[0019] Optionally, comparing and matching the expected mode of the database configuration parameter within the group of parameters to be checked with the instance type corresponding to the instance type instruction includes:

[0020] Perform pattern matching checks on each of the database configuration parameters within the parameter group to be checked; the pattern matching checks include:

[0021] Determine whether the expected pattern of the database configuration parameter is the general pattern;

[0022] If it is not the general pattern, then determine whether the instance type corresponding to the expected pattern of the database configuration parameter is the same as the instance type corresponding to the instance type instruction;

[0023] If they are not the same, then determine that the database configuration parameter does not match the instance type instruction.

[0024] Optionally, in response to a database initialization instruction, obtaining each database configuration parameter in the heterogeneous database includes:

[0025] Read and initialize the parameter values of each of the database configuration parameters to default values; and

[0026] After obtaining the parameter attributes of all database configuration parameters in response to the database initialization instruction, the processing method further includes:

[0027] Read a preset parameter configuration file and set the parameter values of each of the database configuration parameters; the parameter configuration file sets the parameter levels, parameter types, and preset parameter values of each of the database configuration parameters.

[0028] Optionally, setting the parameter values of each of the database configuration parameters according to the parameter configuration file includes:

[0029] Perform a parameter setting operation on each of the database configuration parameters; the parameter setting operation includes:

[0030] Determine the parameter level corresponding to the database configuration parameter according to the parameter configuration file;

[0031] Determine the settable attribute of the database configuration parameter according to the parameter level; the settable attribute includes a settable parameter or a non-settable parameter;

[0032] In response to the database configuration parameter being the settable parameter, determine the parameter type corresponding to the database configuration parameter according to the parameter configuration file;

[0033] Set the parameter value of the database configuration parameter according to the parameter type corresponding to the database configuration parameter and the preset parameter value corresponding to the parameter configuration file.

[0034] Optionally, in the case of isolating and marking all the database configuration parameters that do not match the instance type instruction, the processing method further includes:

[0035] In response to an operation instruction issued by a client to view or set database configuration parameters, determine whether there is a database configuration parameter with the isolation mark among the database configuration parameters corresponding to the operation instruction;

[0036] If so, isolate the database configuration parameter with the isolation mark.

[0037] According to another aspect of the present invention, there is also provided a computer-readable storage medium, on which a computer program is stored, and when the computer program is executed by a processor, the steps of the processing method for database configuration parameters of any of the above heterogeneous databases are implemented.

[0038] According to still another aspect of the present invention, there is also provided a computer program product, which includes a computer program, and when the computer program is executed by a processor, the steps of the processing method for database configuration parameters of any of the above heterogeneous databases are implemented.

[0039] The processing method for database configuration parameters of the heterogeneous database of the present invention, by presetting the expected mode parameter attributes of the database configuration parameters, matching and judging the expected modes of the database configuration parameters during database initialization, and isolating and marking or isolating the database configuration parameters that do not match the instance type instruction, achieves the effects of preventing users from misusing incompatible database configuration parameters, reducing the learning cost of users, and improving the user experience.

[0040] According to the following detailed description of specific embodiments of the present invention in conjunction with the accompanying drawings, those skilled in the art will become more clear about the above and other objects, advantages and features of the present invention. Description of the Drawings

[0041] Hereinafter, some specific embodiments of the present invention will be described in detail with reference to the accompanying drawings in an exemplary and non-limiting manner. The same reference numerals in the drawings denote the same or similar components or parts. Those skilled in the art should understand that these drawings are not necessarily drawn to scale. In the drawings:

[0042] Figure 1 is a schematic flowchart of a processing method according to an embodiment of the present invention;

[0043] Figure 2 is a schematic flowchart of loading each database configuration parameter of a processing method according to an embodiment of the present invention;

[0044] Figure 3It is a schematic flowchart of setting parameter values for database configuration parameters in a processing method according to an embodiment of the present invention;

[0045] Figure 4 It is a schematic flowchart of determining parameters to be checked in a processing method according to an embodiment of the present invention;

[0046] Figure 5 It is a schematic flowchart of setting a group of parameters to be checked in a processing method according to an embodiment of the present invention;

[0047] Figure 6 It is a schematic flowchart of determining non - matching with instance type instructions in a processing method according to an embodiment of the present invention;

[0048] Figure 7 It is a schematic flowchart of isolating incompatible database configuration parameters on the client side in a processing method according to an embodiment of the present invention;

[0049] Figure 8 It is a schematic flowchart of a processing method according to another embodiment of the present invention;

[0050] Figure 9 It is a schematic flowchart of setting parameter values for database configuration parameters in a processing method according to another embodiment of the present invention;

[0051] Figure 10 It is a schematic diagram of a computer - readable storage medium according to an embodiment of the present invention; and

[0052] Figure 11 It is a schematic diagram of a computer program product according to an embodiment of the present invention. Detailed implementation manners

[0053] The purpose of the processing method for database configuration parameters of the heterogeneous database in this embodiment is to prevent users from using and setting database configuration parameters that are irrelevant to the currently used database instance, thereby reducing the user's learning cost and improving the user experience.

[0054] Figure 1 It is a schematic flowchart of a processing method according to an embodiment of the present invention, and the method generally may include:

[0055] S100, in response to a database initialization instruction, obtain each database configuration parameter in the heterogeneous database; the parameter attributes of the database configuration parameters at least include an expected mode, and the expected mode is used to characterize the instance types that the database configuration parameters can match;

[0056] S200, according to the obtained instance type instruction and the expected modes of each database configuration parameter, determine whether each database configuration parameter matches the instance type instruction;

[0057] For S300, if there is no match, isolate and mark or isolate the database configuration parameters that do not match the instance type instruction.

[0058] Currently, relational databases have multiple architecture systems, such as the Oracle architecture system, the MySQL architecture system, the PostgreSQL architecture system, and the SQL Server architecture system, etc. Database instances built based on the above-mentioned architecture systems correspondingly include instance types such as Oracle instances, MySQL instances, PostgreSQL instances, and SQL Server instances. Each architecture system sets multiple database configuration parameters (Grand Unified Configuration, abbreviated as GUC). Database configuration parameters are usually globally unified configuration parameters, which are used to centrally and uniformly manage various configurations of the database system (such as the performance of the database, resource usage, etc.), and are used to control the behavioral logic of the database. On the other hand, database configuration parameters provide a flexible and customizable configuration method, allowing administrators to adjust the behavior of the database system according to actual needs. This centralized configuration management method can ensure that the database shows consistency when running in various environments, and at the same time can handle different loads and requirements.

[0059] A heterogeneous database is a database that is functionally compatible with at least two database instances based on different architecture systems. A heterogeneous database needs to build all database configuration parameters of different architecture systems into the database product, so that users can freely choose the instance types they need and use and set the database through the corresponding database configuration parameters. Since each architecture system sets multiple database configuration parameters, this results in a large number of database configuration parameters in the heterogeneous database, even up to hundreds or thousands. In the prior art, when users use a heterogeneous database, they can use and set all database configuration parameters. This may cause users to misuse other database configuration parameters except those corresponding to the architecture system of the currently used database instance, which may cause compatibility problems and thus affect the normal execution of the database service. On the other hand, when users set architecture system parameters, they will inevitably face a large number of database configuration parameters, which will increase the learning cost of users and affect the user experience.

[0060] The parameter attributes of database configuration parameters usually include parameter names and parameter values. In this embodiment, an expected mode is added to the parameter attributes of database configuration parameters in heterogeneous databases. The expected mode is used to characterize the instance types that database configuration parameters can match. As shown in Table 1, Table 1 illustrates a parameter attribute table of database configuration parameters in a heterogeneous database. Each database configuration parameter serial number in the table corresponds to a database configuration parameter, and three parameter attributes are preset for each database configuration parameter, namely parameter name, parameter value, and expected mode. This table can be set in, for example, the config_generic file.

[0061]

[0062] Table 1

[0063] As shown in Table 2, Table 2 illustrates several expected modes in some embodiments of the present invention. Each expected mode can match one or more instance types.

[0064] Expected mode Description GUC_DBMODE_PG The marked GUC parameter can match PG GUC_DBMODE_ORACLE The marked GUC parameter can match ORACLE GUC_DBMODE_MYSQL The marked GUC parameter can match MYSQL GUC_DBMODE_SQLSERVER The marked GUC parameter can match SQLSERVER GUC_NO_EXPECT_DBMODE The marked GUC parameter's expected mode is the general mode

[0065] Table 2

[0066] In this embodiment, when the database main process receives a database initialization instruction and performs an initialization instance operation, it can first load all database configuration parameters into memory. After the main process receives an instance type instruction (for example, by reading the sys_control file), it matches and verifies the expected mode of each database configuration parameter in memory with the instance type corresponding to the instance type instruction. If they match, it indicates that the database configuration parameter is compatible with the current instance type. If they do not match, it indicates that the database configuration parameter is not compatible with the current instance type, and then it performs an isolation marking or isolation on it. Among them, the isolation marking operation can lock the database configuration parameter to prevent improper use or setting by the user. The isolation operation can make the database configuration parameter invisible to the user to prevent improper use or setting by the user. Through isolation marking or isolation, the user cannot use or set database configuration parameters that are not compatible with the current instance type, preventing the user's improper use from affecting the normal execution of the database service. It can also reduce the number of database configuration parameters that can be used or set, thereby reducing the user's learning cost and improving the user experience.

[0067] In some embodiments of the processing method of the present invention, a heterogeneous database can use at least a first instance type and a second instance type. The first instance type and the second instance type are constructed based on different database architecture systems.

[0068] The expected mode includes at least a first mode, a second mode, a general mode, or a default mode. The first mode matches the first instance type, the second mode matches the second instance type, and the general mode and the default mode match the first instance type and the second instance type.

[0069] The first instance type and the second embodiment type may each correspond to a different one of the instance types such as Oracle instance, MySQL instance, PostgreSQL instance, and SQL Server instance. The first mode and the second mode may each correspond to a different one of GUC_DBMODE_PG, GUC_DBMODE_ORACLE, GUC_DBMODE_MYSQL, and GUC_DBMODE_SQLSERVER.

[0070] In this embodiment, the expected mode of some database configuration parameters may be empty, that is, the default mode. The database configuration parameters in the default mode are generally compatible with any embodiment type.

[0071] It should be understood that, in addition to the first instance type and the second embodiment type, the heterogeneous database may also use other types of instances. The expected mode may also set more corresponding modes, which will not be described here.

[0072] In some embodiments of the processing method of the present invention, Figure 2 As shown, the step of obtaining the configuration parameters of each database in the heterogeneous database in response to the database initialization instruction includes:

[0073] Read and initialize the parameter values ​​of each database configuration parameter to the default values.

[0074] Exemplarily, the above steps may specifically include:

[0075] S111, obtaining a database configuration parameter in a database configuration parameter list;

[0076] S113, setting the parameter type of the database configuration parameter and initializing the parameter value;

[0077] S115, load the database configuration parameters, add them to the GUC_VARIABLE array, and return to execute step S111;

[0078] S117, in response to all database configuration parameters being added to the GUC_VARIABLE array, applying for memory corresponding to the capacity of the GUC_VARIABLE array, and storing the GUC_VARIABLE array;

[0079] S119, sorting the parameters in the GUC_VARIABLE array.

[0080] The GUC_VARIABLE array is the database configuration parameter variable array. By loading the GUC_VARIABLE array into the memory and sorting the database configuration parameters, it is convenient to search and set the parameter values ​​of the database configuration parameters in order in subsequent operations, thereby improving the initialization efficiency.

[0081] After obtaining the parameter attributes of all database configuration parameters in response to the database initialization instruction, the processing method further includes:

[0082] Read the preset parameter configuration file and set the parameter value of each database configuration parameter; the parameter configuration file sets the parameter level, parameter type and preset parameter value of each database configuration parameter.

[0083] The parameter configuration file may be a sys_control file, etc. The parameter level is used to determine whether the parameter value can be modified by the user. The parameter level may include, for example, internal, postmaster, sighup, backend, superuser, user, etc., where internal type parameters cannot be modified by the user, superuser type parameters can be modified by superusers, and user type parameters can be modified by ordinary users. Parameter types may generally include bool, enum, integer, real, string, etc., and parameter values ​​are only allowed to be modified within the parameter type range. Preset parameter values ​​may be preset in, for example, a sys_control file.

[0084] In some embodiments of the processing method of the present invention, Figure 3 As shown, the setting of the parameter value of each database configuration parameter includes:

[0085] Perform parameter setting operations for each database configuration parameter; parameter setting operations include:

[0086] S121, determining a parameter level corresponding to a database configuration parameter according to a parameter configuration file;

[0087] S123, determining a settable attribute of the database configuration parameter according to the parameter level; the settable attribute includes a settable parameter or a non-settable parameter;

[0088] S125, in response to the database configuration parameter being a configurable parameter, determining a parameter type corresponding to the database configuration parameter according to the parameter configuration file;

[0089] S127, setting the parameter value of the database configuration parameter according to the parameter type corresponding to the database configuration parameter and the preset parameter value corresponding to the parameter configuration file.

[0090] In this embodiment, the configurable attributes of the database configuration parameters are first determined according to the parameter level, and then the parameter values ​​of the configurable parameters are set according to the parameter type and the preset parameter value. In this way, the parameter values ​​of the database configuration parameters can be prevented from being improperly set.

[0091] In some embodiments of the processing method of the present invention, Figure 4 As shown, judging whether each database configuration parameter matches the instance type instruction according to the acquired instance type instruction and the expected mode of each database configuration parameter includes:

[0092] S211, determining whether the expected mode of the database configuration parameter is the default mode;

[0093] S213, if it is not the default mode, marking the database configuration parameter as a parameter to be checked;

[0094] S215 , in response to obtaining the instance type instruction, comparing and matching the expected pattern of each database configuration parameter marked as the parameter to be checked with the instance type corresponding to the instance type instruction.

[0095] In this embodiment, by first determining whether the expected mode of the database configuration parameter is the default mode, and marking the database configuration parameter that is not the default mode as a parameter to be checked, the workload of subsequent comparison and matching operations can be reduced. In particular, when the number of database configuration parameters is as many as hundreds or thousands, the initialization efficiency can be effectively improved and the user waiting time can be reduced.

[0096] In some embodiments of the processing method of the present invention, Figure 5 As shown, judging whether each database configuration parameter matches the instance type instruction according to the acquired instance type instruction and the expected mode of each database configuration parameter includes:

[0097] S221, determining whether the expected mode of the database configuration parameter is the default mode;

[0098] S223, if it is not the default mode, then add the database configuration parameter to the parameter group to be checked;

[0099] S225 , in response to obtaining the instance type instruction, comparing and matching the expected pattern of each database configuration parameter in the parameter group to be checked with the instance type corresponding to the instance type instruction.

[0100] In this embodiment, all database configuration parameters that are not in the default mode are directly included in the parameter group to be checked. During subsequent comparison and matching, the parameter group to be checked can be directly called, which further optimizes the operation process, improves initialization efficiency, and reduces user waiting time.

[0101] In some embodiments of the processing method of the present invention,Figure 6 As shown, the step of comparing and matching the expected pattern of each database configuration parameter in the parameter group to be checked with the instance type corresponding to the instance type instruction includes:

[0102] Perform a pattern matching check on each database configuration parameter in the parameter group to be checked; the pattern matching check includes:

[0103] S231, determining whether the expected mode of the database configuration parameter is a common mode;

[0104] S233, if it is not the general mode, determining whether the instance type corresponding to the expected mode of the database configuration parameter is the same as the instance type corresponding to the instance type instruction;

[0105] S235: If they are not the same, it is determined that the database configuration parameter does not match the instance type instruction.

[0106] In this embodiment, by performing a pattern matching check on each database configuration parameter in the parameter group to be checked, all database configuration parameters that are different from the instance type corresponding to the instance type instruction and are not a common pattern can be determined to be mismatched with the instance type instruction, thereby providing a basis for subsequent isolation marking or isolation operations.

[0107] In some embodiments of the processing method of the present invention, Figure 9 As shown, after obtaining the parameter attributes of all database configuration parameters in response to the database initialization instruction, the processing method further includes:

[0108] S611, searching in the parameter configuration file according to the parameter name of the database configuration parameter;

[0109] S613, determining whether the expected mode of the database configuration parameter is empty;

[0110] S615, if not, then put the database configuration parameters into the array to be checked;

[0111] S617: If yes, set the parameter value according to the parameter level and parameter type of the database configuration parameter in the parameter configuration file.

[0112] In this embodiment, before the database main process obtains the instance type instruction, in the step of setting the parameter value of each database configuration parameter one by one, the corresponding database configuration parameter is put into the array to be checked according to the expected mode. In this way, the process steps can be simplified, the initialization efficiency can be effectively improved, and the user waiting time can be reduced.

[0113] In some embodiments of the processing method of the present invention, Figure 7As shown, in the case where all database configuration parameters that do not match the instance type instruction are marked for isolation, the processing method further includes:

[0114] S411, in response to an operation instruction issued by a client to view or set a database configuration parameter, determining whether there is a database configuration parameter with an isolation mark among the database configuration parameters corresponding to the operation instruction;

[0115] S413: If yes, isolate the database configuration parameters with the isolation mark.

[0116] After the database main process completes initializing the database instance, the client can provide a service process. The client service process mainly handles SQL command interactions. Among them, users can use operation instructions related to database configuration parameters. For example, use the show guc_name instruction to view the parameter value of the database configuration parameter, and for example, use the set guc_name tovalues ​​instruction to set the parameter value of the database configuration parameter. In this embodiment, by matching and verifying the operation instructions related to the database configuration parameters, the database configuration parameters with isolation marks are isolated, so that the database configuration parameters that are incompatible with the current instance type are hidden from the user to prevent improper operation by the user.

[0117] In some embodiments of the processing method of the present invention, Figure 8 As shown, the processing methods include:

[0118] S511, initialize GUC options and create GUC_VARIABLE array;

[0119] S513, parsing command line parameters and parameter configuration file information, and setting parameter values ​​of GUC;

[0120] S515, obtaining an instance type instruction, checking and matching the GUC according to the instance type, and marking or isolating the unmatched GUC.

[0121] Before step S511, the processing method further includes necessary preparation operations, such as setting initial environment variables for the database main process, applying for process memory context, setting process signal processing functions, etc. After step S515, the processing method further includes loading plug-ins, registering backend processes, etc., to complete the main process operation and start the client service process.

[0122] The flow chart provided by the present embodiment is not intended to indicate that the operation of the method will be performed in any particular order, or that all operations of the method are included in all every case. In addition, the method may include additional operations. Within the scope of the technical thinking provided by the present embodiment method, additional changes may be made to the above method.

[0123] It should be understood that in some embodiments, each part can be implemented by hardware, software, firmware or a combination thereof. In the above embodiments, multiple steps or methods can be implemented by software or firmware stored in a memory and executed by a suitable instruction execution system.

[0124] This embodiment also provides a computer program product 10 and a computer readable storage medium 20 . Figure 11 is a schematic diagram of a computer program product 10 according to an embodiment of the present invention, Figure 10 is a schematic diagram of a computer-readable storage medium 20 according to an embodiment of the present invention. The computer program product 10 includes a computer program 11, which implements the steps of any of the above-mentioned processing methods when the computer program 11 is executed by the processor 32. The computer-readable storage medium 20 stores the above-mentioned computer program 11 thereon, and the computer program 11 implements the steps of the processing method of any of the above-mentioned embodiments when the computer program 11 is executed by the processor 32.

[0125] The computer program 11 for performing the operation of the present invention may be an assembly instruction, an instruction set architecture (ISA) instruction, a machine instruction, a machine-related instruction, a microcode, a firmware instruction, a state setting data, a configuration data of an integrated circuit, or a source code or an object code written in any combination of one or more programming languages ​​and process programming languages. The computer program 11 may be executed entirely on the user's computer, partially on the user's computer, as an independent software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In the latter case, the remote computer may be connected to the user's computer via any type of network (including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (e.g., using an Internet service provider via the Internet). In some embodiments, in order to perform various aspects of the present invention, an electronic circuit including, for example, a programmable logic circuit, a field programmable gate array (FPGA) or a programmable logic array (PLA) may execute computer-readable program instructions by utilizing the state information of the computer-readable program instructions to personalize the electronic circuit.

[0126] In the description of this embodiment, the computer program product 10 is a related product including the computer program 11 .

[0127] For the purposes of the description of this embodiment, the computer-readable storage medium 20 is a tangible device capable of retaining and storing the computer program 11, which can be any device that can contain, store, communicate, propagate, or transport the computer program 11 for use by or in connection with an instruction execution system, apparatus, or device. More specific examples (non-exhaustive list) of the computer-readable storage medium 20 include the following: portable computer disks, hard disks, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), static random access memory (SRAM), portable compact disc read-only memory (CD-ROM), digital versatile disc (DVD), memory stick, floppy disk, mechanically encoded device, and any suitable combination of the above.

[0128] The computer program product 10 can run on a computer device. The computer device can include a memory, a processor 32, and the computer program 11 stored on the memory and running on the processor 32. The computer device can be, for example, a server, a desktop computer, a laptop computer, a tablet computer, or a smartphone. In some examples, the computer device can be a cloud computing node. The computer device can be described in the general context of computer system-executable instructions, such as program modules, executed by a computer system. Generally, program modules can include routines, programs, object programs, components, logic, data structures, etc. that perform specific tasks or implement specific abstract data types. The computer device can be implemented in a distributed cloud computing environment where tasks are executed by remote processing devices linked through a communication network. In a distributed cloud computing environment, program modules can be located on local or remote computing system storage media including storage devices.

[0129] The computer device can include a processor 32 adapted to execute stored instructions and a memory that provides temporary storage space for the operation of the instructions during operation. The processor 32 can be a single-core processor, a multi-core processor, a computing cluster, or any number of other configurations. The memory can include random access memory (RAM), read-only memory, flash memory, or any other suitable storage system.

[0130] The computer device can also include a network adapter / interface and an input / output (I / O) interface. The I / O interface allows data to be input and output with external devices that can be connected to the computer device. The network adapter / interface can provide communication between the computer device and a network, which is typically shown as a communication network.

[0131] At this point, those skilled in the art should recognize that although numerous exemplary embodiments of the present invention have been shown and described in detail herein, many other variations or modifications that conform to the principles of the present invention can still be directly determined or derived from the disclosed content of the present invention without departing from the spirit and scope of the present invention. Therefore, the scope of the present invention should be understood and recognized to cover all such other variations or modifications.

Claims

1. A method for processing database configuration parameters of a heterogeneous database, characterized in that: include: In response to a database initialization instruction, obtaining configuration parameters of each database in the heterogeneous database; the parameter attributes of the database configuration parameters at least include an expected mode, and the expected mode is used to characterize the instance type that the database configuration parameters can match; According to the acquired instance type instruction and the expected mode of each of the database configuration parameters, determining whether each of the database configuration parameters matches the instance type instruction; If there is no match, the database configuration parameters that do not match the instance type instruction are marked for isolation or isolated.

2. The processing method according to claim 1, characterized in that: The heterogeneous database may use at least a first instance type and a second instance type; the first instance type and the second instance type are constructed based on different database architecture systems; The expected mode includes at least a first mode, a second mode, a general mode or a default mode; the first mode matches the first instance type, the second mode matches the second instance type, and the general mode and the default mode match the first instance type and the second instance type.

3. The processing method according to claim 2, characterized in that: The step of determining whether each of the database configuration parameters matches the instance type instruction according to the acquired instance type instruction and the expected mode of each of the database configuration parameters includes: Determining whether the expected mode of the database configuration parameter is the default mode; If it is not the default mode, marking the database configuration parameter as a parameter to be checked; In response to obtaining the instance type instruction, the expected pattern of the database configuration parameter marked as the parameter to be checked is compared and matched with the instance type corresponding to the instance type instruction.

4. The processing method according to claim 2, characterized in that: The step of determining whether each of the database configuration parameters matches the instance type instruction according to the acquired instance type instruction and the expected mode of each of the database configuration parameters includes: Determining whether the expected mode of the database configuration parameter is the default mode; If it is not the default mode, the database configuration parameter is included in the parameter group to be checked; In response to obtaining the instance type instruction, the expected pattern of the database configuration parameters in the parameter group to be checked is compared and matched with the instance type corresponding to the instance type instruction.

5. The processing method according to claim 4, characterized in that: The step of comparing and matching the expected pattern of the database configuration parameters in the parameter group to be checked with the instance type corresponding to the instance type instruction includes: Performing a pattern matching check on each of the database configuration parameters in the parameter group to be checked; the pattern matching check includes: Determining whether the expected mode of the database configuration parameter is the common mode; If it is not the general mode, determining whether the instance type corresponding to the expected mode of the database configuration parameter is the same as the instance type corresponding to the instance type instruction; If they are not the same, it is determined that the database configuration parameter does not match the instance type instruction.

6. The processing method according to claim 1, characterized in that: The step of obtaining configuration parameters of each database in the heterogeneous database in response to the database initialization instruction includes: Read and initialize the parameter value of each of the database configuration parameters to a default value; and After obtaining the parameter attributes of all database configuration parameters in response to the database initialization instruction, the processing method further includes: A preset parameter configuration file is read, and the parameter value of each of the database configuration parameters is set; the parameter configuration file sets the parameter level, parameter type and preset parameter value of each of the database configuration parameters.

7. The processing method according to claim 6, characterized in that: The setting of the parameter value of each database configuration parameter includes: Performing a parameter setting operation on each of the database configuration parameters; the parameter setting operation includes: Determine the parameter level corresponding to the database configuration parameter according to the parameter configuration file; Determine the configurable attributes of the database configuration parameters according to the parameter level; the configurable attributes include configurable parameters or non-configurable parameters; In response to the database configuration parameter being the configurable parameter, determining a parameter type corresponding to the database configuration parameter according to the parameter configuration file; The parameter value of the database configuration parameter is set according to the parameter type corresponding to the database configuration parameter and the preset parameter value corresponding to the parameter configuration file.

8. The processing method according to claim 1, characterized in that: In the case where all the database configuration parameters that do not match the instance type instruction are marked for isolation, the processing method further includes: In response to an operation instruction issued by a client to view or set a database configuration parameter, determining whether there is a database configuration parameter with the isolation mark among the database configuration parameters corresponding to the operation instruction; If so, the database configuration parameter with the isolation mark is isolated.

9. A computer-readable storage medium, characterized in that: A computer program is stored thereon, and when the computer program is executed by a processor, the steps of the method for processing database configuration parameters of a heterogeneous database as described in any one of claims 1 to 8 are implemented.

10. A computer program product, comprising a computer program, characterized in that When the computer program is executed by a processor, the steps of the method for processing database configuration parameters of a heterogeneous database as claimed in any one of claims 1 to 8 are implemented.

Images