CN111639984A - Method for real-time refund of database products - Google Patents
Method for real-time refund of database products Download PDFInfo
- Publication number
- CN111639984A CN111639984A CN202010394289.5A CN202010394289A CN111639984A CN 111639984 A CN111639984 A CN 111639984A CN 202010394289 A CN202010394289 A CN 202010394289A CN 111639984 A CN111639984 A CN 111639984A
- Authority
- CN
- China
- Prior art keywords
- order
- state
- instance
- data table
- states
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 22
- 238000012216 screening Methods 0.000 claims abstract description 8
- 238000012545 processing Methods 0.000 claims abstract description 5
- 238000012549 training Methods 0.000 claims description 10
- 230000009286 beneficial effect Effects 0.000 abstract 1
- 238000001514 detection method Methods 0.000 description 3
- 238000011161 development Methods 0.000 description 2
- 238000012544 monitoring process Methods 0.000 description 2
- 230000001360 synchronised effect Effects 0.000 description 2
- 238000013461 design Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/06—Buying, selling or leasing transactions
- G06Q30/0601—Electronic shopping [e-shopping]
- G06Q30/0633—Lists, e.g. purchase orders, compilation or processing
- G06Q30/0635—Processing of requisition or of purchase orders
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- Economics (AREA)
- General Business, Economics & Management (AREA)
- Strategic Management (AREA)
- Marketing (AREA)
- Development Economics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a method for real-time refund of database products, which comprises the following steps: A. screening available zone IDs from a tb1_ broker data table; B. screening out all instance IDs in order states as creation according to the available region IDs and the product specifications; C. calling an interface of the UCA to acquire the state of the instance; D. updating the instance status in the tb1_ scheduler data table; E. detecting whether the states of all instance IDs corresponding to the same order exist in the created state or not; if so, entering step F; if not, ending; F. whether the corresponding instance placed by the same order has a creation failure state or not; if yes, updating all the order state fields corresponding to the order in the tb1_ scheduler data table to be in a fee refunding state, and performing fee refunding processing on all the instances placed by the order; and if not, updating all the order state fields corresponding to the orders in the data table to be in the running state. The invention has the beneficial effects that: the problem that the real-time refund cannot be realized due to the fact that the instance states in different environments are asynchronous is well solved.
Description
Technical Field
The invention belongs to the technical field of database product refund, and particularly relates to a method for refunding a database product in real time.
Background
Under two different system architectures, the service in the system A needs to call the service in the system B to acquire the state of the corresponding cloud product instance. In the system A, when one order is placed with a plurality of instances, the state management detection needs to be carried out on the instances in the same order in batches, and when one instance is failed to be created, the order needs to be refueled in real time. At present, the problem that the real-time refund cannot be realized due to the fact that the instance states are not synchronous easily exists among different environments.
Disclosure of Invention
In view of the above, the present invention is directed to a method for real-time refunding of database products to solve the above-mentioned problems.
In order to achieve the purpose, the technical scheme of the invention is realized as follows:
a method of real-time refund for database products, comprising the steps of:
A. screening available zone IDs from a tb1_ broker data table;
B. screening out all instance IDs in order states as creation according to the available region IDs and the product specifications;
C. calling an interface of the UCA to acquire the state of the instance;
D. updating the instance status in the tb1_ scheduler data table;
E. detecting whether the states of all instance IDs corresponding to the same order exist in the created state or not; if so, entering step F; if not, ending;
F. whether the corresponding instance placed by the same order has a creation failure state or not; if yes, entering step G; if not, entering step I;
G. updating all the order state fields corresponding to the order in the tb1_ scheduler data table to be in a fee refunding state, and entering a step H;
H. carrying out fee refunding processing on all the examples placed by the order;
I. and updating all the order state fields corresponding to the orders in the data table into the running state.
Further, if it is detected in the step E that the states of all the instance IDs corresponding to the same order placement do not exist in the creating state, the training proceeds to the step B.
Further, the step H performs a fee refunding process and then turns to the step B.
Further, after all the order status fields corresponding to the order in the data table are updated to the running status in the step I, the training is performed in turn to enter the step B.
Further, the time of the round is set to 15 seconds or 30 seconds.
Compared with the prior art, the method for the real-time refund of the database product has the following advantages:
the method for real-time fee refund of database products supports simultaneous detection of multiple regions and multiple products, supports detection of multiple instances in the same order, well solves the problem that real-time fee refund cannot be carried out due to asynchronous instance states in different environments, and can save development cost and time for users to a great extent.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate an embodiment of the invention and, together with the description, serve to explain the invention and not to limit the invention. In the drawings:
fig. 1 is a flowchart of a method for real-time refund of database products according to an embodiment of the present invention.
Detailed Description
It should be noted that the embodiments and features of the embodiments may be combined with each other without conflict.
The present invention will be described in detail below with reference to the embodiments with reference to the attached drawings.
As shown in fig. 1, a method for real-time refund of database products includes the following steps:
A. screening available zone IDs from a tb1_ broker data table;
B. screening out an order state opt _ status as all instance IDs of creating according to the available region ID and the product specification;
C. calling an interface of the UCA to acquire the state of the instance;
D. updating the instance status in the tb1_ scheduler data table;
E. detecting whether the states of all instance IDs corresponding to the same order exist in the created state or not; if so, entering step F; if not, ending;
F. whether the corresponding instance placed by the same order has a creation failure state or not; if yes, entering step G; if not, entering step I;
G. updating all the order state fields corresponding to the order in the tb1_ scheduler data table to be in a fee refunding state, and entering a step H;
H. carrying out fee refunding processing on all the examples placed by the order;
I. and updating all the order state fields corresponding to the orders in the data table into running states.
And E, if detecting that the states of all the instance IDs corresponding to the same order do not have the states in the establishment, then the training is carried out in turn to step B.
And step H, carrying out fee refunding treatment and then entering step B.
And step I, after all the order state fields corresponding to the orders in the data table are updated to be in the running state, the training is carried out in turn and step B is carried out.
The time of the round is set to 15 seconds or 30 seconds.
The working process of the embodiment is as follows:
the method is designed through a simple database table, and the real-time monitoring of the instance state is carried out through a timing task center, and the related processing is carried out on different states. The timing task for acquiring the example can set the training time at will, for example, one training time of 15 seconds, one training time of 30 seconds and the like can be set, and the scheme supports multi-region and multi-product type synchronous and asynchronous monitoring in a cloud product line. For example, a data table tbl _ schedule is added in the corresponding mysql library, wherein the data table tbl _ schedule corresponds to the order id, the instance status and the order status field opt _ status, and each round of training selects an instance meeting the conditions according to the order status opt _ status, so as to asynchronously obtain the instance status of the region and the product type. And updating the state field in the table to the acquired instance state, judging that if the number of all instances under the same order is not equal to the number of the instances successfully created, knowing that the instances failed to be created exist, acquiring the order id, and refunding. The design of the method well solves the problem that the real-time refund cannot be realized due to the fact that the instance states in different environments are asynchronous, and can greatly save development cost and time for users.
The above description is only for the purpose of illustrating the preferred embodiments of the present invention and is not to be construed as limiting the invention, and any modifications, equivalents, improvements and the like that fall within the spirit and principle of the present invention are intended to be included therein.
Claims (5)
1. A method for real-time refund of database products, comprising the steps of:
A. screening available zone IDs from a tb1_ broker data table;
B. screening out all instance IDs in order states as creation according to the available region IDs and the product specifications;
C. calling an interface of the UCA to acquire the state of the instance;
D. updating the instance status in the tb1_ scheduler data table;
E. detecting whether the states of all instance IDs corresponding to the same order exist in the created state or not; if so, entering step F; if not, ending;
F. whether the corresponding instance placed by the same order has a creation failure state or not; if yes, entering step G; if not, entering step I;
G. updating all the order state fields corresponding to the order in the tb1_ scheduler data table to be in a fee refunding state, and entering a step H;
H. carrying out fee refunding processing on all the examples placed by the order;
I. and updating all the order state fields corresponding to the orders in the data table into the running state.
2. The method of claim 1, wherein the method comprises the steps of: and E, if detecting that the states of all the instance IDs corresponding to the same order do not have the states in the establishment, then the training is carried out in turn to step B.
3. The method of claim 1, wherein the method comprises the steps of: and step H, carrying out fee refunding treatment and then entering step B.
4. The method of claim 1, wherein the method comprises the steps of: and step I, after all the order state fields corresponding to the orders in the data table are updated to be in the running state, the training is carried out in turn and step B is carried out.
5. A method of real-time refund for database products according to any of claims 2 to 4, characterized in that: the time of the round is set to 15 seconds or 30 seconds.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010394289.5A CN111639984A (en) | 2020-05-11 | 2020-05-11 | Method for real-time refund of database products |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010394289.5A CN111639984A (en) | 2020-05-11 | 2020-05-11 | Method for real-time refund of database products |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111639984A true CN111639984A (en) | 2020-09-08 |
Family
ID=72332717
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010394289.5A Pending CN111639984A (en) | 2020-05-11 | 2020-05-11 | Method for real-time refund of database products |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111639984A (en) |
Citations (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110295645A1 (en) * | 2010-05-26 | 2011-12-01 | Sap Ag | Service delivery management for brokered service delivery |
| CN106447456A (en) * | 2016-10-11 | 2017-02-22 | 广东国汇旅游信息有限公司 | Tourism system |
| CN106600291A (en) * | 2016-12-07 | 2017-04-26 | 国云科技股份有限公司 | Multi-level agent-based public cloud order delivery method |
| CN107194628A (en) * | 2016-03-15 | 2017-09-22 | 阿里巴巴集团控股有限公司 | The method and device of request is alloted in processing |
| CN107730367A (en) * | 2017-11-01 | 2018-02-23 | 高辉 | One kind spells single system and method |
| CN107862575A (en) * | 2017-11-09 | 2018-03-30 | 深圳市幸福商城科技股份有限公司 | A kind of order management method and device |
| CN107886391A (en) * | 2017-10-23 | 2018-04-06 | 兰世德 | A kind of cross-border vertical electric business management method |
| CN109067610A (en) * | 2018-07-12 | 2018-12-21 | 北京京东金融科技控股有限公司 | A kind of monitoring method and device |
| CN109978554A (en) * | 2017-12-14 | 2019-07-05 | 阿里巴巴集团控股有限公司 | Order processing method, server device and computer readable storage medium |
| CN110119426A (en) * | 2019-03-27 | 2019-08-13 | 携程计算机技术（上海）有限公司 | The synchronous method and system of hotel's order report data |
| CN110648209A (en) * | 2019-10-09 | 2020-01-03 | 成都途风国际旅行社有限公司 | Tourism order processing method |
| CN110674153A (en) * | 2019-09-25 | 2020-01-10 | 北京金山云网络技术有限公司 | Data consistency detection method and device and electronic equipment |
| CN110807654A (en) * | 2019-10-12 | 2020-02-18 | 苏宁云计算有限公司 | Commodity supply and sale price difference calculation method and system |
| CN110858380A (en) * | 2018-08-24 | 2020-03-03 | 堆糖信息科技(上海)有限公司 | Order management system |
-
2020
- 2020-05-11 CN CN202010394289.5A patent/CN111639984A/en active Pending
Patent Citations (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110295645A1 (en) * | 2010-05-26 | 2011-12-01 | Sap Ag | Service delivery management for brokered service delivery |
| CN107194628A (en) * | 2016-03-15 | 2017-09-22 | 阿里巴巴集团控股有限公司 | The method and device of request is alloted in processing |
| CN106447456A (en) * | 2016-10-11 | 2017-02-22 | 广东国汇旅游信息有限公司 | Tourism system |
| CN106600291A (en) * | 2016-12-07 | 2017-04-26 | 国云科技股份有限公司 | Multi-level agent-based public cloud order delivery method |
| CN107886391A (en) * | 2017-10-23 | 2018-04-06 | 兰世德 | A kind of cross-border vertical electric business management method |
| CN107730367A (en) * | 2017-11-01 | 2018-02-23 | 高辉 | One kind spells single system and method |
| CN107862575A (en) * | 2017-11-09 | 2018-03-30 | 深圳市幸福商城科技股份有限公司 | A kind of order management method and device |
| CN109978554A (en) * | 2017-12-14 | 2019-07-05 | 阿里巴巴集团控股有限公司 | Order processing method, server device and computer readable storage medium |
| CN109067610A (en) * | 2018-07-12 | 2018-12-21 | 北京京东金融科技控股有限公司 | A kind of monitoring method and device |
| CN110858380A (en) * | 2018-08-24 | 2020-03-03 | 堆糖信息科技(上海)有限公司 | Order management system |
| CN110119426A (en) * | 2019-03-27 | 2019-08-13 | 携程计算机技术（上海）有限公司 | The synchronous method and system of hotel's order report data |
| CN110674153A (en) * | 2019-09-25 | 2020-01-10 | 北京金山云网络技术有限公司 | Data consistency detection method and device and electronic equipment |
| CN110648209A (en) * | 2019-10-09 | 2020-01-03 | 成都途风国际旅行社有限公司 | Tourism order processing method |
| CN110807654A (en) * | 2019-10-12 | 2020-02-18 | 苏宁云计算有限公司 | Commodity supply and sale price difference calculation method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103544760B (en) | A kind of queuing system based on mobile terminal and method | |
| CN110825535B (en) | Job scheduling method and system | |
| CN105068865A (en) | Task scheduling method and apparatus | |
| CN105677465B (en) | The data processing method and device of batch processing are run applied to bank | |
| CN106161644B (en) | Distributed system for data processing and data processing method thereof | |
| CN110175165A (en) | Transaction account checking method, device, computer equipment and storage medium | |
| CN111510468B (en) | Scheduling method and device of computing task, server and computing system | |
| CN110321252A (en) | A kind of method and apparatus of craft services scheduling of resource | |
| CN106777265B (en) | Service data processing method and device | |
| CN111818131A (en) | Message pushing and scheduling system and method | |
| CN109840725A (en) | Cargo picking method, device, electronic device and computer readable storage medium | |
| CN112887355B (en) | Service processing method and device for abnormal server | |
| CN113515369B (en) | Data processing method, system, terminal and storage medium | |
| CN110796341A (en) | Distributed batch processing method and device for collection cases and electronic equipment | |
| CN111639984A (en) | Method for real-time refund of database products | |
| CN107862040B (en) | Method and device for updating data in cache of application instance and cluster | |
| CN109189575A (en) | A kind of Explore of Unified Management Ideas and device of more OpenStack clusters | |
| CN112633850A (en) | Method for realizing service flow automation by managing, calling and monitoring RPA robot | |
| CN108255704A (en) | A kind of script calls the exception response method and its terminal of event | |
| CN115410580A (en) | Voice recognition method, device, equipment and medium for command scheduling system | |
| CN113630368B (en) | Communication method, system, terminal and medium of automatic cloud meter | |
| CN106991017B (en) | Event processing method and device | |
| CN107402752B (en) | Timing triggering method and device for application | |
| CN113656239A (en) | Monitoring method and device for middleware and computer program product | |
| CN111324472B (en) | Method and device for judging garbage items of information to be detected |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200908 |
|
| RJ01 | Rejection of invention patent application after publication |