CN109271387B - Rule issuing method and device for database - Google Patents
Rule issuing method and device for database Download PDFInfo
- Publication number
- CN109271387B CN109271387B CN201811141683.7A CN201811141683A CN109271387B CN 109271387 B CN109271387 B CN 109271387B CN 201811141683 A CN201811141683 A CN 201811141683A CN 109271387 B CN109271387 B CN 109271387B
- Authority
- CN
- China
- Prior art keywords
- rule
- check item
- issued
- issuing
- database
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Abstract
The embodiment of the specification provides a method and a device for issuing rules of a database, which adopt the technical scheme that whether the current gray release of the rules to be issued passes through the preset check item is checked by using the preset check item corresponding to the current gray release, and the release progress of the rules to be issued is changed according to the check result, so that the gray release process of the rules to be issued is effectively checked, the stability of the rules in the release process is ensured, meanwhile, the defect that a large amount of manpower and material resources are needed to monitor the state of the rules in the release process is avoided, the manpower and material resources are saved, and the efficiency of issuing the rules is also improved.
Description
Technical Field
The embodiment of the specification relates to the technical field of internet, in particular to a method and a device for rule issuing of a database.
Background
A database is a warehouse that organizes, stores and manages data according to a data structure, and as the society develops, data management is no longer just storing and managing data, but is converted into various data management ways required by users.
Where a rule is data in the database that describes a business, and in particular, the specification and restrictions in the database on the values stored in the columns of the table or in the user-defined data types. When a rule is issued by a large database, a gray level issuing mode is generally adopted, namely issuing is performed on a small part of users instead of issuing to all users, and even if the database rolls back due to an error, only the small part of users are affected, so that the influence on all users due to the error of the rule is avoided. However, as services increase and adjustment to services increase, more rules need to be published, and thus a scheme for more reliably publishing rules needs to be provided.
Disclosure of Invention
The embodiment of the specification provides a method and a device for issuing rules of a database.
In a first aspect, an embodiment of the present specification provides a method for issuing a rule of a database, including:
acquiring a rule to be issued;
when the rule to be issued enters gray level issuing, checking whether the current gray level issuing of the rule to be issued passes through a preset check item according to the preset check item corresponding to the current gray level issuing;
and changing the release progress of the rule to be released according to the check result.
In a second aspect, an embodiment of the present specification provides a rule issuing apparatus for a database, including:
the acquisition unit is used for acquiring the rule to be issued;
the checking unit is used for checking whether the current gray release of the rule to be released passes the preset check item according to the preset check item corresponding to the current gray release when the rule to be released enters the gray release;
and the changing unit is used for changing the issuing progress of the rule to be issued according to the checking result.
In a third aspect, an embodiment of the present specification provides a database, including a memory, a processor, and a computer program stored in the memory and executable on the processor, where the processor implements the steps of the rule issuing method of any one of the databases when executing the program.
In a fourth aspect, the present specification provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the steps of the rule issuing method for the database described in any one of the above.
The embodiment of the specification has the following beneficial effects:
in the embodiment of the specification, the technical scheme that the preset check item corresponding to the gray scale publishing at this time is used for checking whether the gray scale publishing of the rule to be published passes the preset check item or not and changing the publishing progress of the rule to be published according to the check result is adopted, the gray scale publishing process of the rule to be published is effectively checked, the stability of the rule in the publishing process is ensured, the defect that a large amount of manpower and material resources are needed to monitor the state of the rule in the publishing process is avoided, the manpower and material resources are saved, and the rule publishing efficiency is improved.
Drawings
Fig. 1 is a flowchart of a rule issuing method of a database according to an embodiment of the present specification;
FIG. 2 is a block diagram of a rule issuing device of a database according to an embodiment of the present disclosure;
fig. 3 is a schematic structural diagram of a database provided in an embodiment of the present specification.
Detailed Description
In order to better understand the technical solutions, the technical solutions of the embodiments of the present specification are described in detail below with reference to the drawings and specific embodiments, and it should be understood that the specific features of the embodiments and embodiments of the present specification are detailed descriptions of the technical solutions of the embodiments of the present specification, and are not limitations of the technical solutions of the present specification, and the technical features of the embodiments and embodiments of the present specification may be combined with each other without conflict.
Referring to fig. 1, fig. 1 is a flowchart of a rule issuing method of a database according to an embodiment of the present disclosure, and as shown in fig. 1, the method includes:
s102: acquiring a rule to be issued; specifically, the rule to be released input by the user is obtained, and in practical application, the rule to be released input by the user can be obtained in a keyboard, mouse, touch screen or other modes, and is not limited herein;
s104: when the rule to be issued enters gray level issuing, checking whether the current gray level issuing of the rule to be issued passes through a preset check item according to the preset check item corresponding to the current gray level issuing; specifically, the rules to be issued can correspond to different preset check items at different gray scale issuing schedules, so that when the rules to be issued enter gray scale issuing, whether the gray scale issuing of the rules to be issued passes through the preset check items or not can be checked by calling each background check interface according to the preset check items corresponding to the gray scale issuing of this time, namely, whether the rules are issued correctly or not can be checked;
s106: according to the check result, the release progress of the rule to be released is changed; specifically, if the check result shows that the rule to be issued passes through the preset check item, the issuing progress of the rule to be issued can be changed to enter the next gray level; if the check result shows that the rule to be issued is still in the monitoring state, the issuing progress of the rule to be issued can be changed to continue the gray level issuing; and if the check result shows that the rule to be issued fails to pass any check item, changing the issuing progress of the rule to be issued into gray level issuing failure.
The technical scheme that whether the gray scale release of the rule to be released passes the preset check item or not is checked by using the preset check item corresponding to the gray scale release, and the release progress of the rule to be released is changed according to the check result is adopted, so that the gray scale release process of the rule to be released is effectively checked, the stability of the rule in the release process is ensured, the defect that a large amount of manpower and material resources are needed to monitor the state of the rule in the release process is avoided, the manpower and material resources are saved, and the rule release efficiency is improved.
In the following section, the above-described technical solutions will be described in detail.
It should be noted that the rule issuing method for the database provided in the embodiment of the present disclosure may be applied to any type of database, and the database may be disposed in one or more physical servers, which is not limited herein.
In S102, a user may input a rule to be published to a database through a keyboard, a mouse, or a touch screen, and the rule to be published may be set as a component for communicating with the database, or may be input through an input unit provided in the database, so that the database may obtain the rule to be published input by the user.
After the rule to be issued is obtained in S102, the rule issuing method of the database provided in the embodiment of the present specification proceeds to S104, that is: when the rule to be issued enters gray level issuing, whether the current gray level issuing of the rule to be issued passes through the preset check item is checked according to the preset check item corresponding to the current gray level issuing.
Specifically, when gray-scale publishing is performed on the rule to be published, whether the rule is published correctly can be determined by checking the background check interface corresponding to the publication rule, for example, by obtaining the check interface.
In a specific implementation process, the preset check items may include a disposable check item and a non-disposable check item, and in a process of performing gray scale publishing on the rule to be published, whether the rule to be published passes through the disposable check item or the non-disposable check item may be separately checked, or whether the rule to be published passes through the disposable check item and the non-disposable check item may be simultaneously checked, and of course, a person skilled in the art may select an appropriate check mode according to an actual situation, which is not limited herein.
In practical applications, the one-time check item includes at least one of a database check and a cache check, and the non-one-time check includes at least one of a system monitor and a service monitor. For the one-time check item, if the value returned by the interface corresponding to the one-time check item indicates normal, determining that the to-be-issued rule is issued through the one-time check item; for the non-disposable check item, if the fluctuation trend of the value returned by the interface corresponding to the non-disposable check item does not exceed the threshold, it is determined that the to-be-issued rule is issued through the non-disposable check item. As described in the foregoing section, for the present tone distribution, any one of the above-described items may be performed alone, or both of the items of examination may be performed simultaneously, which is not limited herein.
After checking whether the current gray scale distribution of the rule to be distributed passes the preset check item through S104, the rule distribution method of the database provided in the embodiment of the present specification proceeds to S106, that is: and according to the checking result, changing the publishing progress of the rule to be published.
Specifically, the following two cases may be included:
the first method comprises the following steps: when the rule to be issued passes through the one-time check item and/or the non-one-time check item, the issuing progress of the rule to be issued is changed into entering the next gray level switching flow, and the method can be applied again in the next gray level switching flow; it should be noted that the release schedule in the present embodiment of the specification is a record of the current gray release status of the rule, and the change to the release schedule in this and the following sections only relates to the change to the record, and does not relate to the change to the gray release status of the rule;
certainly, when the rule to be issued passes through the one-time check item and does not pass through the non-one-time check item, no change is made at this time, the issuing progress of the rule to be issued is kept as the gray level issuing until the rule to be issued can be confirmed to pass through or not pass through the non-one-time check item, and if the rule to be issued passes through the non-one-time check item, the issuing progress of the rule to be issued can be changed into entering the next switching flow as introduced in the first case;
and the second method comprises the following steps: and when the rule to be issued fails to pass any check item, performing rollback operation on the database, and changing the issuing progress of the rule to be issued into gray level issuing failure.
In practical application, whether the gray level of the rule to be issued passes through the corresponding preset check item or not is checked, so that the issuing progress of the rule to be issued can be changed correspondingly according to the corresponding check result, and details are not repeated here.
In a specific implementation process, after the publication progress of the rule to be published is changed, the method provided in the embodiment of the present specification further includes: and displaying the publishing progress of the rule to be published.
Specifically, the publishing progress of the rule to be published may be shown through visualization or the like. Therefore, the publishing progress of the rules to be published can be seen by required persons, such as an operator and a technical provider of the database, and the like, and meanwhile, the publishing process of the rules to be published does not need to be monitored by spending much time and energy of the operator and the technical provider of the database, and the degree of order of the rules to be published in the gray-scale publishing process is also improved.
Based on the same inventive concept, another aspect of the present specification further provides a rule issuing device of a database, please refer to fig. 2, fig. 2 is the rule issuing device of the database provided in the present specification, as shown in fig. 2, the rule issuing device of the database includes:
an obtaining unit 201, configured to obtain a rule to be issued;
the checking unit 202 is configured to check whether the current gray scale release of the rule to be released passes a preset check item according to the preset check item corresponding to the current gray scale release when the rule to be released enters gray scale release;
and the changing unit 203 changes the publishing progress of the rule to be published according to the checking result.
In an optional manner, the check unit is specifically configured to, when the preset check item is a one-time check item, determine that the rule to be issued passes through the one-time check item if a value returned by the interface corresponding to the one-time check item indicates normal, and/or when the preset check item is a non-one-time check item, determine that the rule to be issued passes through the non-one-time check item if a fluctuation trend of the value returned by the interface corresponding to the non-one-time check item does not exceed a threshold.
In an alternative, the one-time check item includes at least one of a database check and a cache check, and the non-one-time check includes at least one of a system monitor and a traffic monitor.
In an optional manner, the changing unit is specifically configured to change the issuing progress of the rule to be issued into a next gray level switching flow when the rule to be issued passes through the one-time check item and/or the non-one-time check item, or perform a rollback operation on the database when the rule to be issued fails to pass through any one of the check items, and change the issuing progress of the rule to be issued into unpublished.
In an optional manner, the apparatus further includes a presentation unit 204, where the presentation unit 204 is configured to present a distribution progress of the rule to be distributed.
In a third aspect, based on the same inventive concept as the rule issuing method of the database in the foregoing embodiment, an embodiment of the present specification further provides a database, and fig. 3 is a schematic structural diagram of the database provided in the embodiment of the present specification, as shown in fig. 3, the database includes a memory 504, a processor 502, and a computer program stored on the memory 504 and operable on the processor 502, and when the processor 502 executes the program, the steps of any one of the foregoing rule issuing methods of the database are implemented.
Where in fig. 3 a bus architecture (represented by bus 500) is shown, bus 500 may include any number of interconnected buses and bridges, and bus 500 links together various circuits including one or more processors, represented by processor 502, and memory, represented by memory 504. The bus 500 may also link together various other circuits such as peripherals, voltage regulators, power management circuits, and the like, which are well known in the art, and therefore, will not be described any further herein. A bus interface 506 provides an interface between the bus 500 and the receiver 501 and transmitter 503. The receiver 501 and the transmitter 503 may be the same element, i.e. a transceiver, providing a means for communicating with various other apparatus over a transmission medium. The processor 502 is responsible for managing the bus 500 and general processing, and the memory 504 may be used for storing data used by the processor 502 in performing operations.
In a fourth aspect, based on the inventive concept of the rule issuing method of the database in the foregoing embodiments, the present specification embodiment further provides a computer-readable storage medium on which a computer program is stored, which when executed by a processor implements the steps of any one of the foregoing rule issuing methods of the database.
The description has been presented with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the description. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
While preferred embodiments of the present specification have been described, additional variations and modifications in those embodiments may occur to those skilled in the art once they learn of the basic inventive concepts. Therefore, it is intended that the appended claims be interpreted as including preferred embodiments and all changes and modifications that fall within the scope of the specification.
It will be apparent to those skilled in the art that various changes and modifications may be made in the present specification without departing from the spirit and scope of the specification. Thus, if such modifications and variations of the present specification fall within the scope of the claims of the present specification and their equivalents, the specification is intended to include such modifications and variations.
Claims (12)
1. A rule issuing method of a database comprises the following steps:
acquiring a rule to be issued, wherein the rule is the regulation and limitation of values stored in a list or a user-defined data type in a database;
when the rule to be issued enters gray level issuing, checking whether the current gray level issuing of the rule to be issued passes through a preset check item according to the preset check item corresponding to the current gray level issuing, wherein the gray level issuing refers to issuing the rule aiming at part of users;
and changing the release progress of the rule to be released according to the check result.
2. The method according to claim 1, wherein the checking whether the current gray scale release of the rule to be released passes through a preset check item according to the preset check item corresponding to the current gray scale release includes:
when the preset check item is a one-time check item, if a value returned by an interface corresponding to the one-time check item indicates normal, determining that the rule to be issued passes through the one-time check item; and/or
When the preset check item is a non-disposable check item, if the fluctuation trend of the value returned by the interface corresponding to the non-disposable check item does not exceed a threshold value, determining that the to-be-issued rule is issued by the non-disposable check item.
3. The method of claim 2, the one-time check items comprising at least one of database checks and cache checks, the non-one-time checks comprising at least one of system monitoring and traffic monitoring.
4. The method according to claim 2, wherein the changing the publishing progress of the rule to be published according to the checking result comprises:
when the rule to be issued passes through the one-time check item and/or the non-one-time check item, changing the issuing progress of the rule to be issued into the next gray level tangential flow; or
And when the rule to be issued fails to pass any check item, performing rollback operation on the database, and changing the issuing progress of the rule to be issued into gray level issuing failure.
5. The method according to any one of claims 1 to 4, after the change of the publication progress of the rule to be published, the method further comprising:
and displaying the publishing progress of the rule to be published.
6. A rule issuing apparatus of a database, comprising:
the system comprises an acquisition unit, a processing unit and a processing unit, wherein the acquisition unit is used for acquiring a rule to be issued, and the rule is the regulation and the limitation of a value stored in a column of a table or a user-defined data type in a database;
the checking unit is used for checking whether the current gray release of the rule to be released passes a preset check item according to the preset check item corresponding to the current gray release when the rule to be released enters gray release, wherein the gray release refers to the release of the rule aiming at part of users;
and the changing unit is used for changing the issuing progress of the rule to be issued according to the checking result.
7. The apparatus according to claim 6, wherein the checking unit is specifically configured to, when the preset check item is a one-time check item, determine that the issuance of the rule to be issued passes through the one-time check item if a value returned by an interface corresponding to the one-time check item indicates normal, and/or when the preset check item is a non-one-time check item, determine that the issuance of the rule to be issued passes through the non-one-time check item if a fluctuation trend of a value returned by an interface corresponding to the non-one-time check item does not exceed a threshold.
8. The apparatus of claim 7, the one-time check entry comprising at least one of a database check and a cache check, the non-one-time check comprising at least one of a system monitor and a traffic monitor.
9. The apparatus according to claim 7, wherein the changing unit is specifically configured to, when the rule to be issued passes through the one-time check item and/or the non-one-time check item, change the issuing progress of the rule to be issued into a next gray level tangential flow, change the issuing progress of the rule to be issued into a continuous gray level of this time, or when the rule to be issued fails to pass through any check item, perform a rollback operation on the database, and change the issuing progress of the rule to be issued into unpublished.
10. The device according to any one of claims 6 to 9, further comprising a display unit for displaying the publishing progress of the rule to be published.
11. A database comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the steps of the method of any one of claims 1 to 5 when executing the program.
12. A data storage medium, a computer-readable storage medium, having stored thereon a computer program which, when executed by a processor, carries out the steps of the method of any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811141683.7A CN109271387B (en) | 2018-09-28 | 2018-09-28 | Rule issuing method and device for database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811141683.7A CN109271387B (en) | 2018-09-28 | 2018-09-28 | Rule issuing method and device for database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109271387A CN109271387A (en) | 2019-01-25 |
| CN109271387B true CN109271387B (en) | 2021-10-15 |
Family
ID=65198721
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811141683.7A Active CN109271387B (en) | 2018-09-28 | 2018-09-28 | Rule issuing method and device for database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109271387B (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103207878A (en) * | 2012-01-17 | 2013-07-17 | 阿里巴巴集团控股有限公司 | Inspection method and device of published information |
| CN103279339A (en) * | 2013-04-22 | 2013-09-04 | 新浪网技术(中国)有限公司 | Code on-line system and method |
| CN105335204A (en) * | 2014-07-29 | 2016-02-17 | 株式会社日立制作所 | Grey level distribution control method and grey level distribution control device of software program |
| CN106354621A (en) * | 2015-07-14 | 2017-01-25 | 北京国双科技有限公司 | Webpage test putting method and device |
| CN107104970A (en) * | 2017-04-27 | 2017-08-29 | 努比亚技术有限公司 | A kind of regular and synchronized processing method, system, rule server and gray scale server |
| CN108388512A (en) * | 2018-02-13 | 2018-08-10 | 阿里巴巴集团控股有限公司 | Data processing method and server |
-
2018
- 2018-09-28 CN CN201811141683.7A patent/CN109271387B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103207878A (en) * | 2012-01-17 | 2013-07-17 | 阿里巴巴集团控股有限公司 | Inspection method and device of published information |
| CN103279339A (en) * | 2013-04-22 | 2013-09-04 | 新浪网技术(中国)有限公司 | Code on-line system and method |
| CN105335204A (en) * | 2014-07-29 | 2016-02-17 | 株式会社日立制作所 | Grey level distribution control method and grey level distribution control device of software program |
| CN106354621A (en) * | 2015-07-14 | 2017-01-25 | 北京国双科技有限公司 | Webpage test putting method and device |
| CN107104970A (en) * | 2017-04-27 | 2017-08-29 | 努比亚技术有限公司 | A kind of regular and synchronized processing method, system, rule server and gray scale server |
| CN108388512A (en) * | 2018-02-13 | 2018-08-10 | 阿里巴巴集团控股有限公司 | Data processing method and server |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109271387A (en) | 2019-01-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111049705B (en) | Method and device for monitoring distributed storage system | |
| US10706120B1 (en) | System and method for website experimentation | |
| US20210240721A1 (en) | Application Recommending Method and System, and Server | |
| CN109117141B (en) | Method, device, electronic equipment and computer readable storage medium for simplifying programming | |
| CN105528135A (en) | Information presenting method and device and electronic apparatus | |
| CN108829321A (en) | The quick editor's method, apparatus and electronic equipment of the page | |
| CN111708682B (en) | Data prediction method, device, equipment and storage medium | |
| CN105095263A (en) | Generation method for card number and apparatus thereof | |
| WO2014093232A1 (en) | System for transform generation | |
| CN113312341A (en) | Data quality monitoring method and system and computer equipment | |
| CN109271387B (en) | Rule issuing method and device for database | |
| US20140379411A1 (en) | System and method for information technology resource planning | |
| WO2008050323A2 (en) | Method for measuring health status of complex systems | |
| CN105490835A (en) | Information monitoring method and device | |
| Hu et al. | Determination of optimal MR&R policies for retaining life-cycle connectivity of bridge networks | |
| CN108268474A (en) | A kind of method and device of stock control | |
| CN107562461B (en) | Feature calculation system, feature calculation method, storage medium, and electronic device | |
| CN109656964A (en) | The method, apparatus and storage medium of comparing | |
| CN111260375B (en) | Service processing method and device | |
| US9329805B1 (en) | Host oriented automatic verification of best practices | |
| Kim et al. | Effects of subsystem mission time on reliability allocation | |
| EP3082085A1 (en) | Methods and systems for adaptive and contextual collaboraiton in a network | |
| CN111985828A (en) | Control method, device and equipment for fund payment budget and computer storage medium | |
| CN113297053A (en) | Method and device for determining test coverage rate and storage medium | |
| CN107070742B (en) | Service server health state checking method and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20201010 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Applicant after: Innovative advanced technology Co.,Ltd. Address before: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Applicant before: Advanced innovation technology Co.,Ltd. Effective date of registration: 20201010 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Applicant after: Advanced innovation technology Co.,Ltd. Address before: A four-storey 847 mailbox in Grand Cayman Capital Building, British Cayman Islands Applicant before: Alibaba Group Holding Ltd. |
|
| TA01 | Transfer of patent application right | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |