CN116881367A

CN116881367A - Gray scale issuing method, device, equipment, medium and program product for storage process

Info

Publication number: CN116881367A
Application number: CN202310898517.6A
Authority: CN
Inventors: 孙迪; 董勇明; 何思阳; 刘梦坷
Original assignee: Industrial and Commercial Bank of China Ltd ICBC
Current assignee: Industrial and Commercial Bank of China Ltd ICBC
Priority date: 2023-07-20
Filing date: 2023-07-20
Publication date: 2023-10-13

Abstract

The present disclosure provides a gray scale publishing method, apparatus, electronic device, medium and computer program product for a database storage process. The method and the device can be used in the technical fields of big data and finance. The gray level publishing method of the database storage process comprises the following steps: creating a gray pattern which is mirror image with the original pattern in a database, wherein the original pattern and the gray pattern are logically isolated; a new version database storage process is released on the gray mode; configuring a searching path for an account determined to be a gray user to obtain a gray searching path, wherein the searching priority of the gray searching path is that a gray mode is higher than an original mode; responding to the test of the gray level user according to the configured search path, and obtaining a test result, wherein the test result is fed back through test or test error reporting information; and adopting a release strategy according to the test result.

Description

Gray scale issuing method, device, equipment, medium and program product for storage process

Technical Field

The present disclosure relates to the field of big data technology, and more particularly, to a gray level distribution method, apparatus, electronic device, medium, and computer program product for a database storage process.

Background

The existing database production environment often adopts a shutdown or gray level cluster mode to release the storage process.

The shutdown scheme at least needs a shutdown window of 1 hour, the service is terminated during the shutdown window, the compiling of the production storage process is carried out, and the service is restarted after the test is successful. Therefore, the shutdown scheme for gray scale release in the storage process needs to be shutdown for a long time during release of the version and deployment of the program, and can not provide services to the outside during the release of the version, if the verification test fails or the application is used for error after release of the version, the shutdown scheme needs to be shutdown for a long time again after returning to the old version, and the system availability and stability are reduced, so that the online service is seriously influenced.

The gray scale cluster scheme needs to be a physical cluster consistent with the specification of the original database server, and the data and the objects of the original database server are required to be synchronized, the storage process is issued to the gray scale cluster during production, and after full test, an application side is notified to switch connection to the gray scale cluster to complete production. Therefore, the gray level cluster scheme for gray level release in the storage process needs additional physical resources, including networks, server equipment, machine room space and the like, and has higher cost and higher investment; meanwhile, the scheme needs to ensure that the data and the objects of the gray scale clusters are consistent with the original clusters, otherwise, the error is reported when the storage process is executed after the switching connection is applied; after the gray level release is finished, the application side needs to reset the connection configuration to the gray level cluster after the production, the application side needs to be matched with release change, the application invasiveness is high, the production operation and maintenance support difficulty is increased, and the production risk is increased.

Disclosure of Invention

In view of this, the present disclosure provides a gray level distribution method, apparatus, electronic device, computer-readable storage medium, and computer program product for a database storage process with low application invasiveness, low production operation and maintenance difficulty, low production risk, low input cost, and good database system availability and stability.

One aspect of the present disclosure provides a gray scale publishing method of a database storage process, including: creating a gray pattern which is mirror image with the original pattern in a database, wherein the original pattern and the gray pattern are logically isolated; a new version database storage process is released on the gray mode; configuring a searching path for an account determined to be a gray user to obtain a gray searching path, wherein the searching priority of the gray searching path is that a gray mode is higher than an original mode; responding to the test of the gray level user according to the configured search path, and obtaining a test result, wherein the test result is fed back through test or test error reporting information; and adopting a release strategy according to the test result.

According to the gray level release method of the database storage process, a gray level mode which is mirror image with the original mode is created in the database; a new version database storage process is issued on the gray mode; configuring a searching path for an account determined to be a gray user to obtain a gray searching path, wherein the searching priority of the gray searching path is that a gray mode is higher than an original mode; and responding to the test performed by the gray level user according to the configured search path, and obtaining a test result, so that a release strategy can be adopted according to the test result. The method and the device have the advantages that the shutdown is not needed when the new version of storage process is released, the service can be provided for the outside, and the shutdown is not needed when the test fails, so that the availability and the stability of the database system are improved. In addition, the method and the device do not need to be matched with release change at the application side, have low application invasiveness, simplify the production steps, reduce the difficulty of supporting production operation and maintenance, and reduce the production risk. In addition, the method and the device do not need to newly build a cluster, a gray pattern is newly added in the database of the original application, meanwhile, the data of the original pattern is not required to be copied, a storage process is only needed to be created in the logic of the gray pattern, the first order of the search path is set to be the gray pattern, and the second order is set to be the original pattern, so that the application can be ensured to normally access the data and the objects in the original pattern, resources are saved, and the input cost is low.

In some embodiments, after the creating of the grayscale pattern in the database that mirrors the original pattern, the method further comprises: and setting the user authority of the gray mode to be consistent with the user authority of the original mode.

In some embodiments, the testing comprises: directly executing test on the inquired storage process; the manner in which the addition, deletion and modification of stored procedures uses transaction rollback is tested.

In some embodiments, the step of adopting a release strategy according to the test result comprises the following steps: and when the test result is that the test is passed, the adopted release strategy is to configure the search paths of all users into the search paths with higher search priority than the search paths with higher gray mode.

In some embodiments, the step of adopting a release strategy according to the test result comprises the following steps: when the test result is the feedback of the test error reporting information, the adopted release strategy is as follows: correcting the storage process according to the test error reporting information feedback; and reissuing the corrected storage process on the gray pattern, and repeatedly executing the configuration search path for the account determined to be the gray user to obtain a gray search path until the test result is passing the test.

In some embodiments, the configuring the search path for the account determined to be the gray user is implemented using structured query language instructions.

Another aspect of the present disclosure provides a gray scale distribution device for a database storage process, including: the creation module is used for executing creation of a gray pattern which is mirror image with the original pattern in the database, wherein the original pattern is logically isolated from the gray pattern; the release module is used for executing a database storage process of releasing a new version on the gray mode; the configuration module is used for executing the configuration of the searching path for the account determined to be the gray user to obtain a gray searching path, wherein the searching priority of the gray searching path is that the gray mode is higher than the original mode; the acquisition module is used for executing a test performed by responding to the gray level user according to the configured search path to acquire a test result, wherein the test result is fed back through test or test error reporting information; and the strategy module is used for executing the issuing strategy according to the test result.

Another aspect of the present disclosure provides an electronic device comprising one or more processors and one or more memories, wherein the memories are configured to store executable instructions that, when executed by the processors, implement the method as described above.

Another aspect of the present disclosure provides a computer-readable storage medium storing computer-executable instructions that, when executed, are configured to implement a method as described above.

Another aspect of the present disclosure provides a computer program product comprising a computer program comprising computer executable instructions which, when executed, are for implementing a method as described above.

Drawings

The above and other objects, features and advantages of the present disclosure will become more apparent from the following description of embodiments thereof with reference to the accompanying drawings in which:

FIG. 1 schematically illustrates an exemplary system architecture to which methods, apparatuses may be applied according to embodiments of the present disclosure;

FIG. 2 schematically illustrates a flow chart of a grayscale distribution method of a database storage process according to an embodiment of the present disclosure;

FIG. 3 schematically illustrates a flow chart for taking a publication policy based on test results, according to some embodiments of the present disclosure;

FIG. 4 schematically illustrates a flow chart for taking a publication policy based on test results, according to further embodiments of the present disclosure;

fig. 5 schematically shows a block diagram of a gradation issuing apparatus of a database storage process according to an embodiment of the present disclosure;

fig. 6 schematically illustrates a block diagram of an electronic device according to an embodiment of the disclosure.

Detailed Description

Hereinafter, embodiments of the present disclosure will be described with reference to the accompanying drawings. It should be understood that the description is only exemplary and is not intended to limit the scope of the present disclosure. In the following detailed description, for purposes of explanation, numerous specific details are set forth in order to provide a thorough understanding of the embodiments of the present disclosure. It may be evident, however, that one or more embodiments may be practiced without these specific details. In addition, in the following description, descriptions of well-known structures and techniques are omitted so as not to unnecessarily obscure the concepts of the present disclosure.

In the technical scheme of the disclosure, the acquisition, storage, application and the like of the related personal information of the user all conform to the regulations of related laws and regulations, necessary security measures are taken, and the public order harmony is not violated. In the technical scheme of the disclosure, the processes of acquiring, collecting, storing, using, processing, transmitting, providing, disclosing, applying and the like of the data all conform to the regulations of related laws and regulations, necessary security measures are adopted, and the public order harmony is not violated.

The terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the disclosure. The terms "comprises," "comprising," and/or the like, as used herein, specify the presence of stated features, steps, operations, and/or components, but do not preclude the presence or addition of one or more other features, steps, operations, or components.

Where a formulation similar to at least one of "A, B or C, etc." is used, in general such a formulation should be interpreted in accordance with the ordinary understanding of one skilled in the art (e.g. "a system with at least one of A, B or C" would include but not be limited to systems with a alone, B alone, C alone, a and B together, a and C together, B and C together, and/or A, B, C together, etc.). The terms "first," "second," and the like, are used for descriptive purposes only and are not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defining "a first" or "a second" may explicitly or implicitly include one or more of the described features.

The following is a noun explanation of the nouns appearing in the present disclosure.

Stored Procedure (Stored Procedure): a database executable object. The method consists of a structured query language (SQL language) set according to the corresponding language, can realize specific functions, stores the stored procedure in a database, is permanently effective after one-time compiling, and is called by a user to execute the stored procedure by specifying the name, parameters (if the stored procedure has parameters) and the like. Corresponding to an application written in the SQL language in a database.

Gray level release: a release method capable of smooth transition. One of the release modes is to isolate the new version from the old version, when releasing the new version, a part of users use the new version first, if no problem exists, the range is gradually expanded, and all users are migrated to the new version. The gray level release can ensure the stability of the whole system, and the problems can be found and adjusted during the initial gray level release so as to ensure the influence degree.

Gray level user: users classified as greyscale users can verify the new version in a small flow manner, and experience the new version function.

Mode (Schema): is a collection of database objects that may be organized into easily manageable logical groups including tables, views, sequences, indexes, stored procedures and functions, and the like. The database may include one or more schemas and the same database object name may be in different schemas of the same database without conflict, and a user with the desired rights may access objects in multiple schemas of the database.

Search Path (Search Path): in a database that allows a user to have multiple modes, creating or viewing an object is performed first in a first mode listed in a search path, and when searching for an object, if the first mode does not exist, searching for objects in other modes in the search path is performed sequentially.

Transaction: a transaction is a logical set of operations that either execute or do not execute. The characteristics of a transaction are atomicity, consistency, isolation, and durability.

Transaction rollback: refers to the undoing of the operation of the database that has been completed by the transaction. The update operation performed by the one or more partially completed transactions is deleted to ensure that the integrity of the database is restored after a database system error.

Embodiments of the present disclosure provide a gray scale publishing method, apparatus, electronic device, computer readable storage medium and computer program product for database storage process. The gray level publishing method of the database storage process comprises the following steps: creating a gray pattern which is mirror image with the original pattern in the database, wherein the original pattern and the gray pattern are logically isolated; a new version database storage process is issued on the gray mode; configuring a searching path for an account determined to be a gray user to obtain a gray searching path, wherein the searching priority of the gray searching path is that a gray mode is higher than an original mode; responding to a test performed by a gray level user according to a configured search path, and obtaining a test result, wherein the test result is through test or test error information feedback; and adopting a release strategy according to the test result.

It should be noted that the gray level distribution method, apparatus, electronic device, computer readable storage medium and computer program product of the database storage process of the present disclosure may be used in the big data technical field, and may also be used in any field other than the big data technical field, for example, the financial field, and the field of the present disclosure is not limited herein.

Fig. 1 schematically illustrates an exemplary system architecture 100 of a gray scale publishing method, apparatus, electronic device, computer-readable storage medium and computer program product to which a database storage process may be applied, according to an embodiment of the disclosure. It should be noted that fig. 1 is only an example of a system architecture to which embodiments of the present disclosure may be applied to assist those skilled in the art in understanding the technical content of the present disclosure, but does not mean that embodiments of the present disclosure may not be used in other devices, systems, environments, or scenarios.

As shown in fig. 1, a system architecture 100 according to this embodiment may include terminal devices 101, 102, 103, a network 104, and a server 105. The network 104 is used as a medium to provide communication links between the terminal devices 101, 102, 103 and the server 105. The network 104 may include various connection types, such as wired, wireless communication links, or fiber optic cables, among others.

The user may interact with the server 105 via the network 104 using the terminal devices 101, 102, 103 to receive or send messages or the like. Various communication client applications, such as shopping class applications, web browser applications, search class applications, instant messaging tools, mailbox clients, social platform software, etc. (by way of example only) may be installed on the terminal devices 101, 102, 103.

The terminal devices 101, 102, 103 may be a variety of electronic devices having a display screen and supporting web browsing, including but not limited to smartphones, tablets, laptop and desktop computers, and the like.

The server 105 may be a server providing various services, such as a background management server (by way of example only) providing support for websites browsed by users using the terminal devices 101, 102, 103. The background management server may analyze and process the received data such as the user request, and feed back the processing result (e.g., the web page, information, or data obtained or generated according to the user request) to the terminal device.

It should be noted that, the gray level distribution method of the database storage procedure provided in the embodiments of the present disclosure may be generally executed by the server 105. Accordingly, the gray scale distribution device for storing a procedure in a database provided by the embodiments of the present disclosure may be generally provided in the server 105. The gray scale distribution method of the database storage procedure provided by the embodiments of the present disclosure may also be performed by a server or a server cluster that is different from the server 105 and is capable of communicating with the terminal devices 101, 102, 103 and/or the server 105. Accordingly, the gray scale distribution device of the database storage procedure provided by the embodiments of the present disclosure may also be provided in a server or a server cluster different from the server 105 and capable of communicating with the terminal devices 101, 102, 103 and/or the server 105.

It should be understood that the number of terminal devices, networks and servers in fig. 1 is merely illustrative. There may be any number of terminal devices, networks, and servers, as desired for implementation.

The gray scale distribution method of the database storage process according to the embodiment of the present disclosure will be described in detail below with reference to fig. 2 to 4 based on the scenario described in fig. 1.

Fig. 2 schematically illustrates a flowchart of a grayscale distribution method of a database storage process according to an embodiment of the present disclosure.

As shown in fig. 2, the gradation release method of the database storage process of this embodiment includes operations S11 to S15.

In operation S11, a gray pattern that mirrors the original pattern is created in the database, wherein the original pattern is logically isolated from the gray pattern.

As an implementation manner, after the operation S11 creates the gray pattern that mirrors the original pattern in the database, the method further includes operation S001.

In operation S001, the user authority of the gray mode is set to coincide with the user authority of the original mode.

It should be noted that, the database administrator user may create a gray pattern in the database of the application, where the gray pattern and the original pattern are mirror images, logically isolated and not affected by each other, and meanwhile, the owner of the gray pattern may be changed to the owner of the original pattern, so as to ensure that the rights of the gray pattern and the original pattern are consistent, and assign rights related to the gray pattern to related application users. The application user is a common owner of the gray mode and the original mode, thereby facilitating the normal access of the application user to the two modes.

In operation S12, a new version of the database storage process is released on the grayscale mode. The method comprises the steps of storing a new version of database on a gray mode, wherein the step of storing the new version of database on the gray mode can be understood as the step of creating, compiling and executing the new version of database on the gray mode by a gray user, wherein the original mode is not involved in the process, and the original business is not affected. It will be appreciated that one or a portion of the application users may be selected as greyscale users.

In operation S13, a search path is configured for an account determined to be a gray user, and a gray search path is obtained, wherein a search priority of the gray search path is that a gray mode is higher than an original mode.

In some examples, configuring a search path for an account determined to be a gray user may be implemented using structured query language instructions. The searching path of the gray level user is set to be higher than the gray level mode by using the SQL command, so that the gray level user can preferentially create, compile and execute the storage process on the gray level mode, and meanwhile, the storage process can be ensured to normally call the storage process, data, objects and the like in the original mode when the storage process is tested.

In operation S14, a test result is obtained in response to the test performed by the gray level user according to the configured search path, where the test result is a pass test or a test error message feedback.

As some implementable embodiments, the test may include operation S141 and operation S142.

In operation S141, a test is directly performed on the queried storage process.

In operation S142, the manner in which the added, deleted, and modified storage processes use the transaction rollback is tested.

It will be appreciated that the test can be directly performed on the storage process involving table, data and object query through operations S141 and S142, and the verification is performed by using a transaction rollback method on the storage process involving table, data and object addition and deletion, which ensures that the test storage process can be verified and that no change is made to the data and object in the original mode, thereby having no influence on the service in the original mode during the verification.

In operation S15, a release policy is adopted according to the test result.

In some examples, as shown in fig. 3, operation S15 takes a release policy according to the test result, including operation S151.

. Through operation S151, when the test passes, it is convenient to implement that the release policy is adopted according to the test result.

In some examples, as shown in fig. 4, operation S15 takes a release policy according to the test result, including operation S152 and operation S153.

In operation S152, when the test result is the feedback of the test error reporting information, the adopted release policy is: and feeding back and correcting the storage process according to the test error reporting information.

In operation S153, the corrected storage procedure is reissued on the gradation mode, and operation S13 is repeatedly performed until the test result is a pass test.

It can be understood that when the test result is feedback of the test error reporting information, the failure cause can be analyzed, the related setting or storing process is revised according to the test error reporting information, and the revised new version storing process is released on the gray mode until the test error reporting information is not available. And the gray mode can be set as the current first-order application mode, and the application can normally use a new version storage process in the gray mode and can normally call data and objects in the original mode.

The disclosure also provides a gray level publishing device in the database storage process based on the gray level publishing method in the database storage process. The gray scale distribution device of the database storage process will be described in detail with reference to fig. 5.

Fig. 5 schematically shows a block diagram of the gradation issuing apparatus 10 of the database storage process according to the embodiment of the present disclosure.

The gradation issuing apparatus 10 of the database storage process includes a creation module 1, an issuing module 2, a configuration module 3, an acquisition module 4, and a policy module 5.

Creation module 1, creation module 1 is used to perform operation S11: creating a gray pattern in the database that mirrors the original pattern, wherein the original pattern is logically isolated from the gray pattern.

The publishing module 2, the publishing module 2 is configured to perform operation S12: and a new version database storage process is released on the gray scale mode.

A configuration module 3, the configuration module 3 being configured to perform operation S13: and configuring a searching path for the account determined to be the gray user to obtain a gray searching path, wherein the searching priority of the gray searching path is that the gray mode is higher than the original mode.

The obtaining module 4, the obtaining module 4 is configured to perform operation S14: and responding to the test performed by the gray level user according to the configured search path, and obtaining a test result, wherein the test result is through test or test error information feedback.

Policy module 5, policy module 5 is configured to perform operation S15: and according to the test result, adopting a release strategy.

According to some embodiments of the present disclosure, the gray scale publishing device of the database storage process further includes a setting module.

The setting module is used for setting the user authority of the gray mode to be consistent with the original mode.

According to some embodiments of the present disclosure, the policy module includes a fully configured unit.

And the full configuration unit is used for configuring the search paths of all users into search paths with higher search priority than that of the original mode by adopting the issuing strategy when the test result is passing the test.

According to some embodiments of the present disclosure, the policy module further comprises a correction unit and a reissue unit.

The correction unit is used for adopting a release strategy when the test result is the feedback of the test error reporting information, wherein the release strategy is as follows: and feeding back and correcting the storage process according to the test error reporting information.

And a reissuing unit for reissuing the corrected storage procedure on the gradation mode, and repeatedly performing operations S13 to S15.

According to the gradation release device 10 of the database storing process of the embodiment of the present disclosure, by creating a gradation pattern in the database that is a mirror image of the original pattern; a new version database storage process is issued on the gray mode; configuring a searching path for an account determined to be a gray user to obtain a gray searching path, wherein the searching priority of the gray searching path is that a gray mode is higher than an original mode; and responding to the test performed by the gray level user according to the configured search path, and obtaining a test result, so that a release strategy can be adopted according to the test result. The method and the device have the advantages that the shutdown is not needed when the new version of storage process is released, the service can be provided for the outside, and the shutdown is not needed when the test fails, so that the availability and the stability of the database system are improved. In addition, the method disclosed by the invention does not need additional physical resources when being implemented, and has lower cost and lower investment; in addition, the application side does not need to be matched with release change, the corresponding application invasiveness is low, the production steps are simplified, the difficulty in supporting production operation and maintenance is reduced, and meanwhile, the production risk is reduced.

In addition, according to an embodiment of the present disclosure, any of the plurality of modules of the creation module 1, the distribution module 2, the configuration module 3, the acquisition module 4, and the policy module 5 may be incorporated in one module to be implemented, or any of the plurality of modules may be split into a plurality of modules. Alternatively, at least some of the functionality of one or more of the modules may be combined with at least some of the functionality of other modules and implemented in one module.

According to embodiments of the present disclosure, at least one of the creation module 1, the distribution module 2, the configuration module 3, the acquisition module 4, and the policy module 5 may be implemented at least in part as hardware circuitry, such as a Field Programmable Gate Array (FPGA), a Programmable Logic Array (PLA), a system on a chip, a system on a substrate, a system on a package, an Application Specific Integrated Circuit (ASIC), or may be implemented in hardware or firmware in any other reasonable way of integrating or packaging the circuitry, or in any one of or a suitable combination of three of software, hardware, and firmware.

Alternatively, at least one of the creation module 1, the distribution module 2, the configuration module 3, the acquisition module 4 and the policy module 5 may be at least partially implemented as computer program modules which, when run, may perform the respective functions.

The gray scale distribution device of the database storage process according to the embodiment of the present disclosure is described in detail below. It is to be understood that the following description is exemplary only and is not intended to limit the disclosure in any way.

The disclosure provides a gray level release device for a database storage process, which can overcome the defect that the prior art scheme cannot provide services to the outside during release of the storage process or can realize that additional resources are needed to provide services to the outside during release, and simultaneously, the purposes that the application connection configuration is not required to be changed when the gray level mode is switched are realized by using a mode of creating a gray level mode and controlling a search path in the database. The stability and service continuity of the database system are ensured, the operation and maintenance difficulty is reduced, the input cost is reduced, and the production risk is reduced.

When the production system business operates, the gray level release device of the database storage process creates a gray level mode in the application database using number manager users, and gives the application users the right of the owner and all rights of the mode, wherein the gray level mode belongs to the application users, but the mutual logic isolation does not affect each other; then selecting part of users as gray users, setting a search path of the gray users (the gray mode is in a first order and the original mode is in a second order), enabling the gray users to directly establish a storage process on the gray mode, calling a table and data in the original mode, using the gray users to put the content of the storage process to be released on a newly built gray mode to compile and execute after the setting is finished, using the gray users to use a mode of transaction rollback in the gray mode to test the storage process successfully executed in the last step after the execution is successful, and if the verification is not passed, correcting the storage process to be put into production, and repeatedly compiling and executing on the gray mode until the verification is passed. After the production verification is passed, the searching path gray level of all application users can be set (the gray level mode is in the first order and the original mode is in the second order), and the whole process of safely and seamlessly switching the application users to the gray level mode to use the new version storage process is completed.

The gradation release means of the database storage process may include a create gradation pattern unit, a change gradation user search path unit, a gradation release storage process unit, a test error processing unit, and a change all application user search path unit.

The gray pattern creating unit is mainly responsible for creating a gray pattern in the application database by a database manager user, wherein the gray pattern and the original pattern are mirror images and are logically isolated and do not affect each other, and meanwhile, the owner of the gray pattern is changed into the owner of the original pattern, so that the authority of the gray pattern is consistent with that of the original pattern, and the related authority of the gray pattern is entitled to the related application user. The application user is a common owner of the gray mode and the original mode, so that the application user can normally access the two modes. And after the weighting, transmitting the flow to a user searching path unit for changing the gray level.

The gray user search path changing unit selects one or a part of application users as gray users, and uses SQL commands to set the search paths of the gray users as follows: gray mode, primary mode. So that the gray level user can create, compile and execute the storage process on the gray level mode preferentially, and meanwhile, when the storage process is tested, the storage process can be ensured to normally call the storage process, data, objects and the like in the original mode. And after the search path is set, the process is handed to a gray level release storage process unit.

The gray level release storage process unit is mainly responsible for creating, compiling and executing a storage process of a new version on a gray level mode by using a gray level user, and does not relate to an original mode during the storage process, and has no influence on original business. And after all the new version storage processes are successfully executed, the new version storage processes are run to the test storage process unit.

The test storage process unit is mainly responsible for verifying the storage process of successful production of the test gray level release storage process unit by using a related gray level test user, can directly execute test on the storage process related to table, data and object inquiry, and verifies the storage process related to table, data and object addition and deletion by using a transaction rollback and rollback mode, thereby ensuring that the test storage process can be verified and ensuring that the original mode data and objects are not changed. No effect on the traffic of the primary mode during authentication. If the service verification is passed, the process is submitted to a unit for changing the search path of all application users, and if the service verification is not passed, the process is submitted to a test error processing unit.

And the test error processing unit. The method is mainly responsible for acquiring test error reporting information of a storage process, analyzing failure reasons, correcting related settings or storage processes according to the error reporting information, and submitting the corrected new version storage process to a gray level release storage process unit until no error reporting information exists.

All application user search path elements are changed. Responsible for altering the search path of all application users: gray mode, primary mode. The gray mode is set as the current first-order application mode, and the application can normally use the new version storage process in the gray mode and can normally call the data and the object in the original mode.

The gray level distribution method of the database storage process of one embodiment of the present disclosure is as follows.

In the process S201, a gray pattern is created in an application database by creating a gray pattern unit by a database administrator user, and the gray pattern and the original pattern are ensured to be mirror images by changing a pattern owner and a weighting mode, so that the application authority is consistent.

Flow S202, by changing the gray user search path unit, setting the search path of the gray user to be: gray mode, primary mode.

And S203, creating, compiling and executing a new version of storage process on the gray pattern by using the gray user through the gray release storage process unit, and giving the process to S204 after the search path is set.

Flow S204, through testing the storage process unit, the storage process related to table, data and object inquiry can be directly tested, the storage process related to table, data and object addition and deletion is tested by using the mode of transaction rollback, if the test is not passed, the flow S205 is performed, otherwise the flow S206 is performed

And S205, acquiring test error reporting information of the storage process through a test error reporting processing unit, correcting the related setting or storage process according to the error reporting information, and submitting the corrected new version storage process to a gray level release storage process unit until no error reporting information exists.

Flow S206, the change all application user search path unit changes all application user search paths: gray mode, primary mode. The gray mode is set as the current first-order application mode, and the application can normally use the new version storage process in the gray mode and can normally call the data and the object in the original mode.

Fig. 6 schematically shows a block diagram of an electronic device adapted to implement the above-described method according to an embodiment of the present disclosure.

As shown in fig. 6, an electronic device 900 according to an embodiment of the present disclosure includes a processor 901 that can perform various appropriate actions and processes according to a program stored in a Read Only Memory (ROM) 902 or a program loaded from a storage portion 908 into a Random Access Memory (RAM) 903. The processor 901 may include, for example, a general purpose microprocessor (e.g., a CPU), an instruction set processor and/or an associated chipset and/or a special purpose microprocessor (e.g., an Application Specific Integrated Circuit (ASIC)), or the like. Processor 901 may also include on-board memory for caching purposes. Processor 901 may include a single processing unit or multiple processing units for performing the different actions of the method flows according to embodiments of the present disclosure.

In the RAM 903, various programs and data necessary for the operation of the electronic device 900 are stored. The processor 901, the ROM 902, and the RAM 903 are connected to each other by a bus 904. The processor 901 performs various operations of the method flow according to the embodiments of the present disclosure by executing programs in the ROM 902 and/or the RAM 903. Note that the program may be stored in one or more memories other than the ROM 902 and the RAM 903. The processor 901 may also perform various operations of the method flow according to embodiments of the present disclosure by executing programs stored in the one or more memories.

According to an embodiment of the disclosure, the electronic device 900 may also include an input/output (I/O) interface 905, the input/output (I/O) interface 905 also being connected to the bus 904. The electronic device 900 may also include one or more of the following components connected to the I/O interface 905: an input section 906 including a keyboard, a mouse, and the like; an output portion 907 including a display such as a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and a speaker; a storage portion 908 including a hard disk or the like; and a communication section 909 including a network interface card such as a LAN card, a modem, or the like. The communication section 909 performs communication processing via a network such as the internet. The drive 910 is also connected to an input/output (I/O) interface 905 as needed. A removable medium 911 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is installed as needed on the drive 910 so that a computer program read out therefrom is installed into the storage section 908 as needed.

The present disclosure also provides a computer-readable storage medium that may be embodied in the apparatus/device/system described in the above embodiments; or may exist alone without being assembled into the apparatus/device/system. The computer-readable storage medium carries one or more programs which, when executed, implement methods in accordance with embodiments of the present disclosure.

According to embodiments of the present disclosure, the computer-readable storage medium may be a non-volatile computer-readable storage medium, which may include, for example, but is not limited to: 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), a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this disclosure, a computer-readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. For example, according to embodiments of the present disclosure, the computer-readable storage medium may include ROM 902 and/or RAM 903 and/or one or more memories other than ROM 902 and RAM 903 described above.

Embodiments of the present disclosure also include a computer program product comprising a computer program containing program code for performing the methods shown in the flowcharts. The program code, when executed in a computer system, causes the computer system to perform the methods of embodiments of the present disclosure.

The above-described functions defined in the system/apparatus of the embodiments of the present disclosure are performed when the computer program is executed by the processor 901. The systems, apparatus, modules, units, etc. described above may be implemented by computer program modules according to embodiments of the disclosure.

In one embodiment, the computer program may be based on a tangible storage medium such as an optical storage device, a magnetic storage device, or the like. In another embodiment, the computer program may also be transmitted, distributed, and downloaded and installed in the form of a signal on a network medium, via communication portion 909, and/or installed from removable medium 911. The computer program may include program code that may be transmitted using any appropriate network medium, including but not limited to: wireless, wired, etc., or any suitable combination of the foregoing.

In such an embodiment, the computer program may be downloaded and installed from the network via the communication portion 909 and/or installed from the removable medium 911. The above-described functions defined in the system of the embodiments of the present disclosure are performed when the computer program is executed by the processor 901. The systems, devices, apparatus, modules, units, etc. described above may be implemented by computer program modules according to embodiments of the disclosure.

According to embodiments of the present disclosure, program code for performing computer programs provided by embodiments of the present disclosure may be written in any combination of one or more programming languages, and in particular, such computer programs may be implemented in high-level procedural and/or object-oriented programming languages, and/or assembly/machine languages. Programming languages include, but are not limited to, such as Java, c++, python, "C" or similar programming languages. The program code may execute entirely on the user's computing device, partly on the user's device, partly on a remote computing device, or entirely on the remote computing device or server. In the case of remote computing devices, the remote computing device may be connected to the user computing device through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computing device (e.g., connected via the Internet using an Internet service provider).

The flowcharts and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.

Those skilled in the art will appreciate that the features recited in the various embodiments of the disclosure and/or in the claims may be combined in various combinations and/or combinations, even if such combinations or combinations are not explicitly recited in the disclosure. In particular, the features recited in the various embodiments of the present disclosure and/or the claims may be variously combined and/or combined without departing from the spirit and teachings of the present disclosure. All such combinations and/or combinations fall within the scope of the present disclosure.

The embodiments of the present disclosure are described above. However, these examples are for illustrative purposes only and are not intended to limit the scope of the present disclosure. Although the embodiments are described above separately, this does not mean that the measures in the embodiments cannot be used advantageously in combination. The scope of the disclosure is defined by the appended claims and equivalents thereof. Various alternatives and modifications can be made by those skilled in the art without departing from the scope of the disclosure, and such alternatives and modifications are intended to fall within the scope of the disclosure.

Claims

1. A gray level distribution method of a database storage process, comprising:

creating a gray pattern which is mirror image with the original pattern in a database, wherein the original pattern and the gray pattern are logically isolated;

A new version database storage process is released on the gray mode;

configuring a searching path for an account determined to be a gray user to obtain a gray searching path, wherein the searching priority of the gray searching path is that a gray mode is higher than an original mode;

responding to the test of the gray level user according to the configured search path, and obtaining a test result, wherein the test result is fed back through test or test error reporting information; and

and according to the test result, adopting a release strategy.

2. The method of claim 1, wherein after creating the grayscale pattern in the database that mirrors the original pattern, the method further comprises:

and setting the user authority of the gray mode to be consistent with the user authority of the original mode.

3. The method of claim 1, wherein the testing comprises:

directly executing test on the inquired storage process;

the manner in which the addition, deletion and modification of stored procedures uses transaction rollback is tested.

4. The method of claim 1, wherein said taking a publication policy based on said test results comprises:

And when the test result is that the test is passed, the adopted release strategy is to configure the search paths of all users into the search paths with higher search priority than the search paths with higher gray mode.

5. The method of claim 1, wherein said taking a publication policy based on said test results comprises:

when the test result is the feedback of the test error reporting information, the adopted release strategy is as follows: correcting the storage process according to the test error reporting information feedback; and

and reissuing the corrected storage process on the gray pattern, and repeatedly executing the configuration search path for the account determined to be the gray user to obtain a gray search path until the test result is passing the test.

6. The method of claim 1, wherein configuring a search path for an account determined to be a gray user is implemented using structured query language instructions.

7. A gradation issuing apparatus of a database storing process, comprising:

the creation module is used for executing creation of a gray pattern which is mirror image with the original pattern in the database, wherein the original pattern is logically isolated from the gray pattern;

The release module is used for executing a database storage process of releasing a new version on the gray mode;

the configuration module is used for executing the configuration of the searching path for the account determined to be the gray user to obtain a gray searching path, wherein the searching priority of the gray searching path is that the gray mode is higher than the original mode;

the acquisition module is used for executing a test performed by responding to the gray level user according to the configured search path to acquire a test result, wherein the test result is fed back through test or test error reporting information; and

and the strategy module is used for executing the issuing strategy according to the test result.

8. An electronic device, comprising:

one or more processors;

one or more memories for storing executable instructions which, when executed by the processor, implement the method of any of claims 1-6.

9. A computer readable storage medium, characterized in that the storage medium has stored thereon executable instructions which, when executed by a processor, implement the method according to any of claims 1-6.

10. A computer program product comprising a computer program comprising one or more executable instructions which when executed by a processor implement the method according to any one of claims 1 to 6.