CN112632074A

CN112632074A - Inventory allocation method and device for database, electronic equipment and medium

Info

Publication number: CN112632074A
Application number: CN202011555368.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: 2020-12-24
Filing date: 2020-12-24
Publication date: 2021-04-09

Abstract

The present disclosure provides an inventory allocation method for a database, comprising: the method comprises the steps of obtaining real-time inventory supply quantity of a specified object in a centralized database, wherein the real-time inventory supply quantity is the sum of initial inventory supply quantity minus real-time inventory consumption of m node databases, m is a positive integer and is larger than or equal to 2, scanning the m node databases based on a preset scanning strategy to monitor whether n target node databases exist in the m node databases, the current inventory surplus of the specified object in the target node databases is lower than a first preset inventory threshold value, n is a positive integer and is larger than or equal to n, and distributing the real-time inventory supply quantity to the n target node databases to adjust the current inventory surplus of the specified object in the n target node databases under the condition that the n target node databases exist. An inventory distribution device, an electronic device, and a medium for a database are also provided. The method and apparatus of the present disclosure may be applied, for example, to the financial field or other fields.

Description

Inventory allocation method and device for database, electronic equipment and medium

Technical Field

The present disclosure relates to the field of databases, and in particular, to a method and an apparatus for allocating an inventory of a database, an electronic device, and a medium.

Background

This section is intended to provide a background or context to the embodiments of the invention that are recited in the claims. The description herein is not admitted to be prior art by inclusion in this section.

For a database system with hundred million user quantities, in order to solve the problem of performance reduction of a database caused by overlarge data quantity, data is divided into databases and tables according to user information numbers, an original independent database is divided into a plurality of scattered databases, a large data table is divided into a plurality of data tables, so that the data quantity of a single database and a single data table is reduced, the data quantity of the single database is reduced by dispersing the data in different databases, the performance problem of the single database is relieved, and the purpose of improving the performance of the database is achieved.

For transaction scenes similar to operation activities, there are often second-class activities for marketing according to regions and user groups, and in what way, inventory data of the transactions are maintained, and related technologies also provide solutions.

Disclosure of Invention

Because the maintenance method of the inventory data provided by the related technology cannot simultaneously meet high concurrency requirements, real-time inventory deduction and complex query requirements of operation services, the maintenance of the services is inconvenient, and complaints are easily caused by insufficient customer experience. In view of the above, in order to at least partially overcome the above technical problems in the related art, and achieve the purposes of simultaneously meeting high concurrency requirements, real-time inventory deduction, and complex query requirements of operation-type services, facilitating service maintenance, and improving customer experience to avoid complaints, the present disclosure provides an inventory allocation method, apparatus, electronic device, and medium for a database.

To achieve the above object, an aspect of the embodiments of the present disclosure provides an inventory allocation method for a database, including: and acquiring the real-time inventory supply quantity of the specified object in the centralized database, wherein the real-time inventory supply quantity is the sum of the initial inventory supply quantity minus the real-time inventory consumption quantities of the m node databases, m is a positive integer and is more than or equal to 2. And scanning the m node databases based on a preset scanning strategy to monitor whether n target node databases exist in the m node databases, wherein the current inventory surplus of the specified object in the target node databases is lower than a first preset inventory threshold, n is a positive integer, m is larger than or equal to n, and in the case that the n target node databases exist, distributing the real-time inventory supply quantity to the n target node databases to adjust the current inventory surplus of the specified object in the n target node databases.

According to an embodiment of the present disclosure, the scanning the m node databases based on a preset scanning policy includes: and scanning the m node databases based on a preset scanning strategy of a dynamic interval to monitor whether n target node databases exist in the m node databases.

According to an embodiment of the present disclosure, the scanning the m node databases based on the preset scanning policy based on the dynamic interval includes: and aiming at the m node databases, acquiring a first historical inventory adjustment interval corresponding to the adjustment of the current inventory allowance of each node database. And determining a dynamic interval based on the first historical inventory adjustment interval, and scanning the m node databases based on a preset scanning strategy of the dynamic interval.

According to an embodiment of the present disclosure, the scanning the m node databases based on the preset scanning policy based on the dynamic interval includes: and acquiring a second historical inventory adjustment interval corresponding to the designated object when the designated object is adjusted in each node database aiming at the m node databases. And determining a dynamic interval based on the second historical inventory adjustment interval, and scanning the m node databases based on a preset scanning strategy of the dynamic interval.

According to an embodiment of the present disclosure, the scanning the m node databases based on a preset scanning policy includes: and scanning the m node databases based on a preset scanning strategy at fixed intervals to monitor whether n target node databases exist in the m node databases.

According to an embodiment of the present disclosure, the allocating the real-time inventory supply amount to the n target node databases includes: and distributing the real-time inventory supply amount to the n target node databases based on a preset distribution strategy.

According to an embodiment of the present disclosure, the allocating the real-time inventory supply amount to the n target node databases based on a preset allocation policy includes: and distributing the real-time inventory supply amount to the n target node databases based on a preset distribution strategy of the dynamic distribution amount.

According to an embodiment of the present disclosure, the allocating the real-time inventory supply amount to the n target node databases based on the preset allocation policy of the dynamic allocation amount includes: and aiming at the n target node databases, obtaining a preset initial inventory of the specified object in each target node database. And determining a dynamic allocation amount based on the preset initial inventory amount and the current inventory surplus, and allocating the real-time inventory supply amount to the n target node databases based on a preset allocation strategy of the dynamic allocation amount.

According to an embodiment of the present disclosure, the allocating the real-time inventory supply amount to the n target node databases based on the preset allocation policy of the dynamic allocation amount includes: and aiming at the n target node databases, obtaining a first historical inventory adjustment amount of each target node database. And determining a dynamic allocation amount based on the first historical inventory adjustment amount, and allocating the real-time inventory supply amount to the n target node databases based on a preset allocation strategy of the dynamic allocation amount.

According to an embodiment of the present disclosure, the allocating the real-time inventory supply amount to the n target node databases based on the preset allocation policy of the dynamic allocation amount includes: and aiming at the n target node databases, obtaining a second historical inventory adjustment amount of the specified object in each target node database. And determining a dynamic allocation amount based on the second historical inventory adjustment amount, and allocating the real-time inventory supply amount to the n target node databases based on a preset allocation strategy of the dynamic allocation amount.

According to an embodiment of the present disclosure, the allocating the real-time inventory supply amount to the n target node databases based on a preset allocation policy includes: and distributing the real-time inventory supply amount to the n target node databases based on a preset distribution strategy of fixed distribution amount.

According to any one of the embodiments of the present disclosure, the allocating the real-time inventory supply amount to the n target node databases includes: and distributing the real-time inventory supply amount to the n target node databases within a first preset time period.

According to an embodiment of the present disclosure, the method further includes: and monitoring whether p proposed node databases exist in the m node databases, wherein the current inventory allowance of the specified object in the proposed node databases is lower than a second preset inventory threshold, the second preset inventory threshold is smaller than the first preset inventory threshold, p is a positive integer, and m is larger than or equal to p. If there are p proposed node databases, obtaining an inventory recovery amount of the designated object based on a current inventory margin of the m node databases excluding the p proposed node databases, and supplementing the inventory recovery amount to the centralized database.

According to an embodiment of the present disclosure, the obtaining the inventory recovery amount of the specified object includes: and obtaining the inventory recovery amount of the specified object based on a preset recovery strategy.

According to an embodiment of the present disclosure, the obtaining the inventory recycling amount of the designated object based on a preset recycling policy includes: and obtaining the inventory recovery amount of the specified object based on a preset recovery strategy of the dynamic inventory recovery amount.

According to an embodiment of the present disclosure, the obtaining the inventory recycling amount of the designated object based on a preset recycling policy includes: and obtaining the inventory recovery amount of the specified object based on a preset recovery strategy with a fixed proportion.

According to any one of the embodiments of the present disclosure, the monitoring whether p proposed node databases exist in the m node databases includes: and monitoring whether p proposed node databases exist in the m node databases or not within a second preset time period.

To achieve the above object, another aspect of the embodiments of the present disclosure provides an inventory allocation apparatus for a database, including: and the real-time inventory supply quantity obtaining module is used for obtaining the real-time inventory supply quantity of the specified object in the centralized database, wherein the real-time inventory supply quantity is the sum of the initial inventory supply quantity minus the real-time inventory consumption quantities of the m node databases, m is a positive integer and is more than or equal to 2. A target node database monitoring module, configured to scan the m node databases based on a preset scanning policy to monitor whether n target node databases exist in the m node databases, where a current inventory balance of the designated object in the target node database is lower than a first preset inventory threshold, n is a positive integer, and m is greater than or equal to n, and a real-time inventory supply amount distribution module, configured to distribute the real-time inventory supply amount to the n target node databases in the case that the n target node databases exist, so as to adjust the current inventory balance of the designated object in the n target node databases.

According to an embodiment of the present disclosure, the target node database monitoring module is configured to: and scanning the m node databases based on a preset scanning strategy of a dynamic interval to monitor whether n target node databases exist in the m node databases.

According to an embodiment of the present disclosure, the target node database monitoring module includes: and the first historical inventory adjustment interval acquisition submodule is used for acquiring a corresponding first historical inventory adjustment interval when the current inventory allowance of each node database is adjusted aiming at the m node databases. A first dynamic interval determining submodule for determining a dynamic interval based on the first historical inventory adjustment interval, and a first node database scanning submodule for scanning the m node databases based on a preset scanning strategy of the dynamic interval.

According to an embodiment of the present disclosure, the target node database monitoring module includes: and a second historical inventory adjustment interval acquisition submodule, configured to acquire, for the m node databases, a second historical inventory adjustment interval corresponding to the designated object when the designated object is adjusted in each node database. A second dynamic interval determining submodule for determining a dynamic interval based on the second historical inventory adjustment interval, and a second node database scanning submodule for scanning the m node databases based on a preset scanning strategy of the dynamic interval.

According to an embodiment of the present disclosure, the target node database monitoring module is configured to: and scanning the m node databases based on a preset scanning strategy at fixed intervals to monitor whether n target node databases exist in the m node databases.

According to an embodiment of the present disclosure, the real-time inventory supply amount distribution module is configured to: and distributing the real-time inventory supply amount to the n target node databases based on a preset distribution strategy.

According to an embodiment of the present disclosure, the real-time inventory supply amount distribution module is configured to: and distributing the real-time inventory supply amount to the n target node databases based on a preset distribution strategy of the dynamic distribution amount.

According to an embodiment of the present disclosure, the real-time inventory supply amount distribution module includes: and the preset initial inventory obtaining submodule is used for obtaining the preset initial inventory of the specified object in each target node database aiming at the n target node databases. A first dynamic allocation amount determining submodule for determining a dynamic allocation amount based on the preset initial inventory amount and the current inventory surplus, and a first real-time inventory supply amount allocating submodule for allocating the real-time inventory supply amount to the n target node databases based on a preset allocation strategy of the dynamic allocation amount.

According to an embodiment of the present disclosure, the real-time inventory supply amount distribution module includes: and the first historical inventory adjustment quantity obtaining submodule is used for obtaining the first historical inventory adjustment quantity of each target node database aiming at the n target node databases. A second dynamic distribution quantity determining submodule for determining a dynamic distribution quantity based on the first historical inventory adjustment quantity, and a second real-time inventory supply quantity distributing submodule for distributing the real-time inventory supply quantity to the n target node databases based on a preset distribution strategy of the dynamic distribution quantity.

According to an embodiment of the present disclosure, the real-time inventory supply amount distribution module includes: and a second historical inventory adjustment quantity obtaining submodule, configured to obtain, for the n target node databases, a second historical inventory adjustment quantity of the designated object in each target node database. A third dynamic allocation amount determining submodule for determining a dynamic allocation amount based on the second historical inventory adjustment amount, and a third real-time inventory supply amount allocating submodule for allocating the real-time inventory supply amount to the n target node databases based on a preset allocation policy of the dynamic allocation amount.

According to an embodiment of the present disclosure, the allocating the real-time inventory supply amount to the n target node databases based on a preset allocation policy is performed: and distributing the real-time inventory supply amount to the n target node databases based on a preset distribution strategy of fixed distribution amount.

According to any of the above embodiments of the present disclosure, the real-time inventory supply amount distribution module is configured to: and distributing the real-time inventory supply amount to the n target node databases within a first preset time period.

According to an embodiment of the present disclosure, the inventory dispensing device further includes: and the proposed node database monitoring module is used for monitoring whether p proposed node databases exist in the m node databases, wherein the current inventory allowance of the specified object in the proposed node databases is lower than a second preset inventory threshold value, the second preset inventory threshold value is smaller than the first preset inventory threshold value, p is a positive integer, and m is larger than or equal to p. An inventory recovery amount obtaining module for obtaining the inventory recovery amount of the specified object based on the current inventory surplus of the p proposed node databases excluding the p proposed node databases in the m node databases if the p proposed node databases exist, and an inventory recovery amount supplementing module for supplementing the inventory recovery amount to the centralized database.

According to an embodiment of the present disclosure, the inventory recovery amount obtaining module is configured to: and obtaining the inventory recovery amount of the specified object based on a preset recovery strategy.

According to an embodiment of the present disclosure, the inventory recovery amount obtaining module is configured to: and obtaining the inventory recovery amount of the specified object based on a preset recovery strategy of the dynamic inventory recovery amount.

According to an embodiment of the present disclosure, the inventory recovery amount obtaining module is configured to: and obtaining the inventory recovery amount of the specified object based on a preset recovery strategy with a fixed proportion.

According to any one of the above embodiments of the present disclosure, the proposed node database monitoring module is configured to: and monitoring whether p proposed node databases exist in the m node databases or not within a second preset time period.

To achieve the above object, another aspect of the embodiments of the present disclosure provides an electronic device, including: one or more processors, a memory for storing one or more programs, wherein the one or more programs, when executed by the one or more processors, cause the one or more processors to implement the inventory allocation method for a database as described above.

To achieve the above object, another aspect of the embodiments of the present disclosure provides a computer-readable storage medium storing computer-executable instructions for implementing the inventory allocation method for a database as described above when the instructions are executed.

To achieve the above object, another aspect of the embodiments of the present disclosure provides a computer program including computer executable instructions for implementing the inventory allocation method for a database as described above when executed.

Compared with the prior art, the inventory allocation method for the database, provided by the disclosure, obtains the real-time inventory supply quantity of the designated object in the centralized database, and allocates the real-time inventory supply quantity to the target node database in response to the monitored existence of the target node database with the current inventory surplus lower than the first preset inventory threshold value, so as to adjust the current inventory surplus of the designated object in the target node database, thereby not only meeting high concurrency requirements, but also realizing real-time deduction of the real-time inventory supply quantity, and also meeting the complex query requirements of operation services and improving user experience.

Drawings

For a more complete understanding of the present disclosure and the advantages thereof, reference is now made to the following descriptions taken in conjunction with the accompanying drawings, in which:

FIG. 1 schematically illustrates an application scenario of an inventory allocation method suitable for use in embodiments of the present disclosure;

FIG. 2 schematically illustrates a system architecture suitable for the inventory allocation method of an embodiment of the present disclosure;

FIG. 3 schematically illustrates a flow diagram of an inventory allocation method according to an embodiment of the disclosure;

FIG. 4 schematically illustrates a flow diagram of an inventory allocation method according to another embodiment of the present disclosure;

FIG. 5 schematically illustrates a block diagram of an inventory distribution device, according to an embodiment of the present disclosure;

FIG. 6 schematically illustrates a block diagram of an inventory distribution device according to another embodiment of the present disclosure;

FIG. 7 schematically illustrates a schematic diagram of a computer-readable storage medium product suitable for implementing the inventory allocation method described above, in accordance with an embodiment of the present disclosure; and

fig. 8 schematically illustrates a block diagram of an electronic device adapted to implement the inventory allocation method described above, in accordance with an embodiment of the present disclosure.

In the drawings, the same or corresponding reference numerals indicate the same or corresponding parts.

It should be noted that the figures are not drawn to scale and that elements of similar structure or function are generally represented by like reference numerals throughout the figures for illustrative purposes.

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 illustrative only 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 disclosure. It may be evident, however, that one or more embodiments may be practiced without these specific details. Moreover, in the following description, descriptions of well-known structures and techniques are omitted so as to not unnecessarily obscure the concepts of the present disclosure.

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 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. All terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art unless otherwise defined. It is noted that the terms used herein should be interpreted as having a meaning that is consistent with the context of this specification and should not be interpreted in an idealized or overly formal sense.

Where a convention analogous to "at least one of A, B and C, etc." is used, in general such a construction is intended in the sense one having skill in the art would understand the convention (e.g., "a system having at least one of A, B and C" would include but not be limited to systems that have 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.). Where a convention analogous to "A, B or at least one of C, etc." is used, in general such a construction is intended in the sense one having skill in the art would understand the convention (e.g., "a system having at least one of A, B or C" would include but not be limited to systems that have 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.).

Some block diagrams and/or flow diagrams are shown in the figures. It will be understood that some blocks of the block diagrams and/or flowchart illustrations, or combinations thereof, 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, or other programmable inventory allocation method and apparatus for a database, such that the instructions, which execute via the processor, create means for implementing the functions/acts specified in the block diagrams and/or flowchart block or blocks. The techniques of this disclosure may be implemented in hardware and/or software (including firmware, microcode, etc.). In addition, the techniques of this disclosure may take the form of a computer program product on a computer-readable storage medium having instructions stored thereon for use by or in connection with an instruction execution system.

It should be noted that the inventory allocation method and apparatus for database provided by the present disclosure may be used in the financial field, and may also be used in any field other than the financial field. Therefore, the application field of the inventory allocation method and device for the database provided by the present disclosure is not limited.

According to an embodiment of the present invention, an inventory allocation method for a database, an apparatus, a medium, and an electronic device for performing the inventory allocation method are provided. The inventory distribution method comprises the following steps: the method comprises the steps of obtaining real-time inventory supply quantity of a specified object in a centralized database, wherein the real-time inventory supply quantity is the sum of initial inventory supply quantity minus real-time inventory consumption of m node databases, m is a positive integer and is larger than or equal to 2, scanning the m node databases based on a preset scanning strategy to monitor whether n target node databases exist in the m node databases, the current inventory surplus of the specified object in the target node databases is lower than a first preset inventory threshold value, n is a positive integer and is larger than or equal to n, and distributing the real-time inventory supply quantity to the n target node databases to adjust the current inventory surplus of the specified object in the n target node databases under the condition that the n target node databases exist. By the embodiment of the disclosure, high concurrency requirements, real-time deduction of inventory and complex query requirements of operation services can be met simultaneously, service maintenance is facilitated, and customer experience is improved to avoid complaints.

Fig. 1 schematically illustrates an application scenario 100 in which an inventory allocation method may be applied, suitable for use in embodiments of the present disclosure. It should be noted that fig. 1 is only an example of an application scenario to which the embodiment of the present disclosure may be applied to help those skilled in the art understand the technical content of the present disclosure, but does not mean that the embodiment of the present disclosure may not be applied to other application scenarios.

As shown in fig. 1, the application scenario 100 according to this embodiment may include

terminal devices

101, 102, 103, a network 104 and a server 105. The network 104 serves as a medium for providing communication links between the

terminal devices

101, 102, 103 and the server 105. Network 104 may include various connection types, such as wired, wireless communication links, or fiber optic cables, to name a few.

The user may use the

terminal devices

101, 102, 103 to interact with the server 105 via the network 104 to receive or send messages or the like. The

terminal devices

101, 102, 103 may have installed thereon various communication client applications, such as shopping-like applications, web browser applications, search-like applications, instant messaging tools, mailbox clients, social platform software, etc. (by way of example only).

The

terminal devices

101, 102, 103 may be various electronic devices having a display screen and supporting web browsing, including but not limited to smart phones, tablet computers, laptop portable computers, desktop computers, and the like.

The server 105 may be a server providing various services, such as a background management server (for example only) providing support for websites browsed by users using the

terminal devices

101, 102, 103. The background management server may analyze and perform other processing on the received data such as the user request, and feed back a processing result (e.g., a webpage, information, or data obtained or generated according to the user request) to the terminal device.

It should be understood that the number of terminal devices, networks, and servers of fig. 1 are merely illustrative. There may be any number of terminal devices, networks, and servers, as desired by the application scenario.

For a database system with hundred million user quantities, in order to solve the problem of database performance reduction caused by excessive data quantity, data is usually sorted and tabulated according to user information numbers. During specific implementation, an original independent database can be split into a plurality of scattered databases, a large data table is split into a plurality of data tables, so that the data volume of a single database and a single data table is reduced, the data volume of the single database is reduced by dispersing data in different databases, the performance problem of the single database is relieved, and the aim of improving the performance of the databases is fulfilled. For example, the e-commerce database can be split into a plurality of independent databases, and for a large table, the e-commerce database can also be split into a plurality of small tables, and the performance problem of the database is solved by the database splitting method. The following takes an operation scenario of killing activity in seconds as an example to illustrate the system architecture of the present disclosure.

Fig. 2 schematically illustrates a system architecture suitable for the inventory allocation method of the disclosed embodiment.

As shown in fig. 2, the system architecture 200 may include a cluster of management-side servers 210, a centralized database 220, an inventory scheduling server 230, a second-deactivated application server 250, and a node database 240 that provides database services for the second-deactivated application server 250, respectively.

The management server cluster 210 is configured to configure a total inventory for the centralized database 220, which is a second killing inventory, such as the total number of second killing coupons.

The centralized database 220 may be a relational database, which is originally a stand-alone database in which the total inventory is managed uniformly.

The inventory scheduling server 230 may be a server providing inventory scheduling services, deployed between the centralized database 220 and the lower level node database 240. The inventory scheduling server 230 is configured to execute a background thread, and execute the inventory allocation method provided in the present disclosure according to a certain policy, so as to allocate incremental inventory from the centralized database 220 to each node database 240 in time-sharing and batch manner, or scan inventory balance of each node database 240 through a timing job at night, and perform proportional recycling and inventory reallocation on the inventory in the node database 240 that is not consumed. It should be noted that, from a technical implementation, the inventory scheduling server 230 may be a cluster for implementing distributed batch or thread services. During specific implementation, an open source component under a spring cloud framework can be adopted to realize the spring batch open source component for scheduling the batch jobs of the distributed system, and an open source project of an OpenSymphony open source organization can also be adopted to realize job scheduling. And the open source components such as an open source distributed transaction manager Atomikos and the like are utilized to realize the distributed transaction across the database, and the transaction consistency of total inventory deduction, sub-inventory supplement and back-supplement actions is ensured.

It should be noted that the distributed inventory scheduling method for a database provided by the present disclosure may be generally performed by the inventory scheduling server 230. Accordingly, the inventory allocation device for databases provided by the present disclosure may be generally disposed in the inventory scheduling server 230. The inventory allocation method for databases provided by the present disclosure may also be performed by other servers than the inventory scheduling server 230 and capable of communicating with the inventory scheduling server 230 and/or the centralized database 220. Accordingly, the inventory allocation device for databases provided by the present disclosure may also be disposed in other servers different from the inventory scheduling server 230 and capable of communicating with the inventory scheduling server 230 and/or the centralized database 220.

The node databases 240 are a plurality of scattered databases, and are used for respectively storing the total inventory originally stored in the centralized database 220, each node database corresponds to a sub-inventory and is used for splitting the large data table into a plurality of data tables, so that the data volume of a single database and a single data table is reduced, and the performance problem of the single database is relieved by dispersing the data in different databases so that the data volume of the single database is reduced.

The second killer application server 250 may be a server that provides various second killer services, such as a background management server (for example only) that provides second killer support for websites browsed by users using the

terminal devices

101, 102, 103. The backend management server may analyze and perform other processing on the received data such as the user request, and feed back a processing result (e.g., a web page, information, or data obtained or generated according to the user request) to the

terminal devices

101, 102, and 103.

For database systems with hundred million user quantities, a consistent hash algorithm is generally adopted to perform database division and table division according to client information numbers. For transaction scenes similar to operation activities, there are often second-class activities for marketing according to regions and user groups, and in what way, inventory data of the transactions are maintained, and the prior art also provides some solutions. For example, the inventory is centrally set in a relational database, asynchronous reduction of the inventory is realized by using a message queue mechanism, or the inventory is centrally set in a non-relational memory database (for example, Redis) to realize real-time reduction of the inventory, or the inventory is respectively set for a node database to realize real-time reduction of the inventory.

However, if the convenience of service maintenance is considered, the setting of the inventory data should be decoupled from the technical implementation mode, and a total amount can be set in the centralized database to be most appropriate, but the requirement of high concurrency cannot be met; if the centralized inventory configuration is required to be met and the high concurrency pressure is also required to be met, the asynchronous inventory deduction can be realized by using a message queue mechanism, but the real-time inventory deduction cannot be realized, and the result cannot be returned in real time, so that the customer experience is insufficient; if the centralized configuration of the inventory and the high concurrency requirements are met, and the real-time customer experience is needed, the inventory can be set in a non-relational memory database in a centralized manner, so that the real-time reduction of the inventory is realized, but some complex query requirements of operation services are difficult to support; if high concurrency needs to be met simultaneously, real-time reduction of inventory is achieved, complex query needs are supported, inventory data cannot be arranged in a centralized database, inventory is respectively arranged for each node database, service maintenance is inconvenient, accurate estimation cannot be carried out on inventory of each node database, inventory of some node databases is cleared easily, and other node databases still have inventory, so that part of users cannot rob under the condition that total inventory is nonzero, and complaints are caused due to insufficient customer experience.

The principles and spirit of the present invention are explained in detail below with reference to several representative embodiments of the invention. Moreover, any number of elements in the drawings are by way of example and not by way of limitation, and any nomenclature is used solely for differentiation and not by way of limitation.

FIG. 3 schematically illustrates a flow chart of an inventory allocation method according to an embodiment of the disclosure. As shown in fig. 3, the inventory allocation method 300 may include operations S310 through S330.

In operation S310, a real-time inventory supply amount of a designated object in a centralized database is obtained.

According to the embodiment of the present disclosure, the designated object is related to a specific operation service, and may be credential information stored in a database for identifying the operation service, and the corresponding stock is deducted if a certain rule is satisfied. Taking the second kill activity as an example, the designated object is one or more items that can be killed in seconds. The centralized database can be a relational database and is used for performing database division and table division on the data of the specified object according to the user information number. The real-time inventory supply amount is the sum of the initial inventory supply amount minus the real-time inventory consumption amount of the m node databases, m is a positive integer and is more than or equal to 2. The initial inventory supply may be the total inventory of the operations configuration.

In the present disclosure, the real-time inventory supply amount is changed in real time, and is used for representing incremental data of the inventory, and the incremental data can be changed correspondingly according to the consumption condition of the inventory by the node database. In specific implementation, the real-time inventory supply amount in the centralized database is correspondingly reduced under the condition that inventory deduction exists in the node database, and the real-time inventory supply amount in the centralized database is correspondingly increased under the condition that inventory refilling exists in the node database.

In operation S320, the m node databases are scanned based on a preset scanning policy to monitor whether n target node databases exist in the m node databases. In the disclosure, the current inventory margin of the designated object in the target node database is lower than a first preset inventory threshold, n is a positive integer, and m is greater than or equal to n. In specific implementation, the inventory consumption speed of each node database in the m node databases may be the same, may be different, and even the difference is large, so that the inventory surplus in the m node databases also has a difference. In order to more specifically allocate the inventory of the node databases, a preset inventory threshold, that is, a first preset inventory threshold, may be set for each node database, where the preset inventory threshold represents an inventory lower limit value of a sub-inventory corresponding to the node database, and meanwhile, the inventory balance of each node database is monitored, and once it is monitored that there is a node database whose current inventory balance is lower than the preset inventory threshold, the node database is determined as a target node database.

It should be noted that the preset inventory threshold of each node database may be the same or different. The first preset inventory threshold value may be set according to the inventory provided by the specific marketing service and the number of the node databases, and may be a specific inventory value or a specific inventory proportion value. For example, the first preset inventory threshold is 1000.

In operation S330, in the case that n target node databases exist, a real-time inventory supply amount is allocated to the n target node databases to adjust a current inventory balance of the designated object in the n target node databases.

According to the embodiment of the disclosure, the real-time inventory supply amount can be distributed to the n target node databases according to the current inventory surplus amount of each node database in the n target node databases. In specific implementation, the allocation priority may be determined according to the current inventory margin of each node database, where the smaller the current inventory margin is, the higher the allocation priority is, and correspondingly, the more the current inventory margin is, the lower the allocation priority is. Meanwhile, the real-time inventory supply amount can be distributed to the n target node databases by combining the real-time inventory supply amount in the centralized database. As an alternative embodiment, the time of each target node database supplement increment can be recorded in the centralized database.

According to the embodiment of the disclosure, if the target node database does not exist, it is indicated that the current inventory balance in each node database is greater than the first preset inventory threshold, and no adjustment is required.

According to the embodiment of the disclosure, the total inventory in the centralized database is distributed to the node database in a scattered manner by using a database-dividing and table-dividing manner, and the inventory increment is distributed to the node database under the condition that the current inventory allowance of the node database is lower than the preset threshold value, so that the flexible adjustment of the current inventory allowance in the node database can be realized.

In the present disclosure, the dynamic scheduling of the real-time inventory supply amount may be flexibly distributed according to preset policies, and the preset policies may include a preset scanning policy for representing a scanning time interval and a preset distribution policy for representing an inventory distribution increment. The preset scanning strategy may be a fixed time interval or a dynamic time interval, and the preset allocation strategy may be a fixed allocation amount or a dynamic allocation amount. Based on the preset scanning strategy and the preset distribution strategy, four preset strategies provided by the disclosure can be obtained.

The first preset strategy is as follows: a fixed time interval and a fixed increment.

The second preset strategy is as follows: dynamic time intervals and fixed increments.

A third preset strategy: fixed time intervals, and dynamic increments.

A fourth preset strategy: dynamic time intervals, and dynamic increments.

The above operation S330 (allocating real-time inventory supply amount to the n target node databases to adjust the current inventory balance of the designated object in the n target node databases) will be described in detail below with reference to the above four preset policies, respectively. The inventory allocation method provided by the disclosure can adapt to operation activities of various dimensional scenes, and supports flexible scheduling of the current inventory allowance of the node database, so that accurate allocation and demand allocation of the sub-inventory of the node database and the real-time inventory supply of the centralized database are realized, and overall allocation of inventory allocation is improved.

In order to implement the distribution of the incremental inventory from the centralized database to the node databases in time and batch according to a certain strategy, the node databases may be scanned based on a preset scanning strategy to monitor whether the target node database exists.

As an alternative embodiment, scanning the m node databases based on the preset scanning policy includes: and scanning the m node databases based on a preset scanning strategy of the dynamic interval to monitor whether n target node databases exist in the m node databases.

According to the embodiment of the disclosure, the dynamic time interval can flexibly adjust the scanning interval time according to the consumption rate of the sub-inventory in the node database.

As an alternative embodiment, scanning m node databases based on a preset scanning strategy at a dynamic interval includes: and aiming at the m node databases, acquiring a first historical inventory adjustment interval corresponding to the adjustment of the current inventory allowance of each node database. Determining a dynamic interval based on the first historical inventory adjustment interval, and scanning the m node databases based on a preset scanning strategy of the dynamic interval.

According to the embodiment of the disclosure, the next scanning time can be estimated according to the time corresponding to the triggering of the inventory balance supplementing action when the inventory balance of the node database is lower than the first preset inventory threshold value in the previous two times, namely the first historical inventory adjustment interval. In particular, scheduling intervals_T+1(scheduling interval)_T-1+ scheduling Interval_T) And/2, if T is less than 2, adopting an initial preset interval.

According to the embodiment of the disclosure, the dynamic interval is determined based on the corresponding first historical inventory adjustment interval when the current inventory allowance of each node database is adjusted, so that the dynamic scanning of the inventory allowance of the node database is realized, and the inventory allocation efficiency is improved.

As an alternative embodiment, scanning m node databases based on a preset scanning strategy at a dynamic interval includes: and aiming at the m node databases, acquiring a second historical inventory adjustment interval corresponding to the specified object when the specified object is adjusted in each node database. Determining a dynamic interval based on the second historical inventory adjustment interval, and scanning the m node databases based on a preset scanning strategy of the dynamic interval.

According to the embodiment of the disclosure, based on the marketing activity, the node database establishes a linear regression model for predicting the scanning interval in the past all stock supplementing time, and also can realize dynamic scanning of the stock balance of the node database, thereby improving the efficiency of stock allocation.

As an alternative embodiment, scanning the m node databases based on the preset scanning policy includes: and scanning the m node databases based on a preset scanning strategy at fixed intervals to monitor whether n target node databases exist in the m node databases.

According to embodiments of the present disclosure, the sub-inventory of each node database may be scanned at regular intervals. For example, the current inventory balance, i.e., subload, of the node database is fixedly scanned every 5 minutes. By the embodiment of the disclosure, the current inventory allowance of each node database is scanned according to a fixed time interval, so that scanning resources can be saved, and especially, under the condition that the sub-inventory consumption speed of the node database is low, the consumption of the resources is effectively saved.

As an alternative embodiment, allocating real-time inventory supplies to the n target node databases comprises: and distributing the real-time inventory supply amount to the n target node databases based on a preset distribution strategy. In order to realize the distribution of the incremental inventory to the node database from the centralized database in time-sharing and batch according to a certain distribution strategy, the flexible distribution of the real-time inventory supply amount can be realized based on a preset distribution strategy.

As an alternative embodiment, allocating real-time inventory supply to the n target node databases based on the preset allocation policy includes: and distributing the real-time inventory supply amount to the n target node databases based on the preset distribution strategy of the dynamic distribution amount.

According to an embodiment of the present disclosure, the preset allocation policy may be based on a preset inventory, may also be based on a static function, and may also be based on a dynamic function.

As an alternative embodiment, allocating the real-time inventory supply amount to the n target node databases based on the preset allocation policy of the dynamic allocation amount includes: and aiming at the n target node databases, obtaining a preset initial inventory of the specified object in each target node database. And determining a dynamic distribution amount based on the preset initial inventory amount and the current inventory surplus, and distributing real-time inventory supply amount to the n target node databases based on a preset distribution strategy of the dynamic distribution amount.

According to the embodiment of the disclosure, when the current inventory surplus of the node database is lower than the first preset inventory threshold, the dynamic incremental inventory can be deducted from the real-time inventory supply amount and supplemented to the sub-inventory, so that the sub-inventory of the node database reaches the preset initial inventory.

Through the embodiment of the disclosure, the inventory allowance of the node database is supplemented according to the preset initial inventory, so that the inventory allowance of the node database is kept in the initial state as far as possible, the problem that the total inventory cannot be robbed under the condition that the total inventory is nonzero can be avoided due to too low inventory allowance in the node database, and the customer experience is improved.

As an alternative embodiment, allocating the real-time inventory supply amount to the n target node databases based on the preset allocation policy of the dynamic allocation amount includes: and aiming at the n target node databases, obtaining a first historical inventory adjustment amount of each target node database. And determining a dynamic allocation amount based on the first historical inventory adjustment amount, and allocating real-time inventory supply amount to the n target node databases based on a preset allocation strategy of the dynamic allocation amount.

According to the embodiment of the disclosure, the stock value can be statically estimated for each increment based on a preset function. The next increment to replenish inventory may be calculated, for example, using a fibonacci reverse order sequence.

In specific implementation, Fi and Fi-1(i > 1) can be obtained according to a fibonacci term formula F (i) ═ F (i-1) + F (i-2) (i > 1, i is a fibonacci factor) with a recurrence relation, then a value of the fibonacci factor i can be obtained according to the total inventory being smaller than the sum of Fi and Fi-1, and finally the dynamic allocation amount T can be obtained according to a formula T ═ Fi/number of node databases.

When the distribution policy is applied to the cases where the consumption rates of the sub-inventories of the node databases are substantially the same, the incremental replenishment of each node database is satisfied, and as time goes up, the stock quantity of replenishment tends to be 0, so that the final stock remaining quantity of the node database also approaches 0, and the probability of redistribution of the stock replenishment back can be reduced.

As an alternative embodiment, allocating the real-time inventory supply amount to the n target node databases based on the preset allocation policy of the dynamic allocation amount includes: and aiming at the n target node databases, obtaining a second historical inventory adjustment amount of the specified object in each target node database. And determining a dynamic allocation amount based on the second historical inventory adjustment amount, and allocating real-time inventory supply amount to the n target node databases based on a preset allocation strategy of the dynamic allocation amount.

According to the embodiment of the disclosure, a linear regression model can be established for dynamic estimation of subsequent incremental inventory values based on the incremental value of the node database in each previous inventory replenishment of the node database in the activity. And subsequently, a logistic regression model with a plurality of characteristics can be established by combining the inventory adjustment rhythm of the previous similar activities, and the inventory increment can be dynamically estimated. By the embodiment of the disclosure, dynamic adjustment of the node database can be realized, so that inventory adjustment conforms to the consumption capacity of each node database to the sub-databases, and the probability of inventory refilling in redistribution can be reduced.

As an alternative embodiment, allocating real-time inventory supply to the n target node databases based on the preset allocation policy includes: and distributing the real-time inventory supply amount to the n target node databases based on a preset distribution strategy of the fixed distribution amount.

According to an embodiment of the present disclosure, when the sub-inventory is below a preset inventory threshold, the preset incremental inventory is subtracted from the total inventory and replenished to the sub-inventory. For example, the current inventory balance of each node database may be fixed and scanned every 5 minutes, and once there is a target node database with current inventory balance < 1000, the real-time inventory supply may be subtracted by 100 and supplemented into the target node database. The inventory is distributed to the node database by using the fixed distribution amount, so that the calculation resource consumed by determining the dynamic distribution amount can be saved, and the inventory adjustment of the current inventory allowance of the node database in a high concurrency scene can also be realized.

As an alternative embodiment, allocating real-time inventory supplies to the n target node databases comprises: and distributing the real-time inventory supply amount to the n target node databases within a first preset time period. In the present disclosure, the first preset time period may cover an active time period of an operation activity, which may be day time or night time. The first preset time period may also be set according to a specific time period in the operation activity. For example, for a twenty-one second kill, the first preset time period may be set from 11 months 11 days zero of 2020 to 11 months 11 days 2 of 2020. The specific time of the first preset time period is not limited, and can be set according to the actual situation. By distributing the real-time inventory supply amount to the n target node databases within the first preset time period, the distribution of the real-time inventory supply amount can be made to accord with the active time period of operation activities, which is beneficial to the centralized distribution of inventory and saves the resource consumption at the same time.

The inventory allocation method provided by the disclosure not only comprises the step of allocating the real-time inventory supply amount to the target node database in the first preset time period, but also comprises the step of compensating the real-time inventory supply amount in the centralized database by utilizing the inventory allowance in the drawn node database in the second time period. By supplementing the real-time inventory supply amount in the centralized database in the second preset time period, the inventory allocation and the inventory supplementation are carried out in different time periods, so that the effective supplementation of the inventory can be realized, the resource contention caused by the inventory allocation during the inventory supplementation can be avoided, the reasonable use of the resource can be realized, and the inventory allocation efficiency is improved.

FIG. 4 schematically illustrates a flow diagram of an inventory allocation method according to another embodiment of the disclosure. As shown in fig. 4, the inventory allocation method 400 may include operations S410 to S430, in addition to the aforementioned operations S310 to S330.

In operation S410, it is monitored whether p proposed node databases exist among the m node databases. In the disclosure, the current inventory allowance of the designated object in the proposed node database is lower than a second preset inventory threshold, the second preset inventory threshold is smaller than the first preset inventory threshold, p is a positive integer, and m is greater than or equal to p.

In this disclosure, the second preset inventory threshold is zero, that is, the triggering condition for replenishing the inventory recovery amount is that one or more proposed node databases with zero inventory allowance currently appear in the m node databases.

In operation S420, in the case that there are p proposed node databases, an inventory recycling amount of the designated object is obtained based on the current inventory margins of the m node databases excluding the p proposed node databases.

In operation S430, the inventory recovery amount is replenished into the centralized database.

In the disclosure, under the condition that the proposed node database exists, the current inventory allowance in other node databases except the proposed node database is recovered, and inventory refilling provided by the embodiment of the disclosure can avoid that inventory distribution is uneven due to part of the node databases, which affects inventory balance among the node databases.

According to an embodiment of the present disclosure, an inventory backoff policy is provided, which includes a dynamic backoff policy and a static backoff policy, and the reallocation policy refers to the allocation policy. And allocating the incremental inventory to the node databases from the centralized database in time-sharing and batch mode, scanning inventory balance of each node database through timing operation at night, and performing proportion recovery on the inventory of the node databases which are not consumed.

As an alternative embodiment, obtaining the inventory recovery amount of the specified object includes: and obtaining the inventory recovery amount of the specified object based on a preset recovery strategy.

As an alternative embodiment, obtaining the inventory recycling amount of the specified object based on the preset recycling policy includes: and obtaining the inventory recycling amount of the specified object based on the preset recycling strategy of the dynamic inventory recycling amount. According to the embodiment of the disclosure, the non-zero inventory in other node databases except the proposed node database can be deducted to the lower threshold, and the non-zero inventory is supplemented to the real-time inventory supply in the centralized database. The lower threshold may be the same as the first preset inventory threshold, or may be the same as the lower threshold, which is not limited in this disclosure.

As an alternative embodiment, obtaining the inventory recycling amount of the specified object based on the preset recycling policy includes: and obtaining the inventory recovery amount of the specified object based on a preset recovery strategy with a fixed proportion. According to the embodiment of the disclosure, the fixed proportion of non-zero inventory in other node databases except the proposed node database can be deducted and supplemented back to the real-time inventory supply in the centralized database. The fixed ratio may be 10%, which is not limited by the present disclosure.

As an alternative embodiment, the step of monitoring whether p proposed node databases exist in the m node databases comprises: and monitoring whether p proposed node databases exist in the m node databases or not within a second preset time period. According to an embodiment of the present disclosure, the second preset time period may be an inactive time period of the activity, unlike the active time period. For example, the first time period is day, and the second time period is night.

By the peak staggering processing of the inventory distribution time and the inventory recycling time in the embodiment of the disclosure, the recycling of the inventory is in a time period with relatively stable inventory change, and the recycling effect is not poor due to frequent change of the inventory allowance. While also avoiding frequent recycling of the dispensing stock. And allocating the incremental inventory to the node databases in batches in time from the centralized database, scanning inventory balance of each node database through timing operation at night, and performing proportion recovery and redistribution on the inventory of the node databases which are not consumed. In order to avoid the extreme case that the inventory of part of the node databases is available for purchase and the inventory of part of the node databases is not available for purchase as the last incremental inventory of the node databases is not reduced, the checking and the back-up operation of the inventory balance of the node databases can be triggered at night every day.

When it needs to be described, the present disclosure further provides an inventory reallocation policy, where the reallocation policy may include a preset scanning policy used for representing a scanning time interval, and a preset allocation policy used for representing an inventory reallocation time increment, the reallocation policy is the same as the foregoing allocation policy, and the reallocation method is the same as the foregoing allocation method, which is not described herein again.

Fig. 5 schematically illustrates a block diagram of an inventory distribution device according to an embodiment of the disclosure. As shown in fig. 5, the inventory allocation device 500 may include a real-time inventory supply quantity acquisition module 510, a target node database monitoring module 520, and a real-time inventory supply quantity allocation module 530.

A real-time inventory supply quantity obtaining module 510 for obtaining a real-time inventory supply quantity of the specified object in the centralized database. In the present disclosure, the real-time inventory supply amount is the sum of the initial inventory supply amount minus the real-time inventory consumption amounts of the m node databases, m is a positive integer, and m is greater than or equal to 2. Optionally, the real-time inventory supply quantity obtaining module 510 may be configured to perform operation S310 described in fig. 3, for example, and will not be described herein again.

And a target node database monitoring module 520, configured to scan the m node databases based on a preset scanning policy, so as to monitor whether n target node databases exist in the m node databases. In the disclosure, the current inventory margin of the designated object in the target node database is lower than a first preset inventory threshold, n is a positive integer, and m is greater than or equal to n. Optionally, the target node database monitoring module 520 may be configured to perform operation S320 described in fig. 3, for example, and will not be described herein again.

A real-time inventory supply amount distribution module 530, configured to, in a case where there are n target node databases, distribute a real-time inventory supply amount to the n target node databases to adjust a current inventory balance of the specified object in the n target node databases. Alternatively, the real-time inventory supply quantity allocation module 530 may be used to perform operation S330 described in fig. 3, for example, and will not be described herein again.

As an alternative embodiment, the target node database monitoring module is configured to: and scanning the m node databases based on a preset scanning strategy to monitor whether n target node databases exist in the m node databases.

As an alternative embodiment, the target node database monitoring module is configured to: and scanning the m node databases based on a preset scanning strategy of the dynamic interval to monitor whether n target node databases exist in the m node databases.

As an alternative embodiment, the target node database monitoring module includes: and the first historical inventory adjustment interval acquisition submodule is used for acquiring a corresponding first historical inventory adjustment interval when the current inventory allowance of each node database is adjusted aiming at the m node databases. The system comprises a first dynamic interval determining submodule and a first node database scanning submodule, wherein the first dynamic interval determining submodule is used for determining a dynamic interval based on a first historical inventory adjusting interval, and the first node database scanning submodule is used for scanning m node databases based on a preset scanning strategy of the dynamic interval.

As an alternative embodiment, the target node database monitoring module includes: and the second historical inventory adjustment interval acquisition submodule is used for acquiring a corresponding second historical inventory adjustment interval when the designated object is adjusted in each node database aiming at the m node databases. A second dynamic interval determining submodule for determining the dynamic interval based on a second historical inventory adjustment interval, and a second node database scanning submodule for scanning the m node databases based on a preset scanning strategy of the dynamic interval.

As an alternative embodiment, the target node database monitoring module is configured to: and scanning the m node databases based on a preset scanning strategy at fixed intervals to monitor whether n target node databases exist in the m node databases.

As an alternative embodiment, the real-time inventory supply allocation module is configured to: and distributing the real-time inventory supply amount to the n target node databases based on a preset distribution strategy.

As an alternative embodiment, the real-time inventory supply amount distribution module is configured to distribute the real-time inventory supply amount to the n target node databases based on a preset distribution policy of the dynamic distribution amount.

As an alternative embodiment, the real-time inventory supply allocation module includes: and the preset initial inventory obtaining submodule is used for obtaining the preset initial inventory of the specified object in each target node database aiming at the n target node databases. The system comprises a first dynamic distribution quantity determining submodule and a first real-time inventory supply quantity distributing submodule, wherein the first dynamic distribution quantity determining submodule is used for determining a dynamic distribution quantity based on a preset initial inventory quantity and a current inventory surplus, and the first real-time inventory supply quantity distributing submodule is used for distributing the real-time inventory supply quantity to n target node databases based on a preset distribution strategy of the dynamic distribution quantity.

As an alternative embodiment, the real-time inventory supply allocation module includes: and the first historical inventory adjustment quantity obtaining submodule is used for obtaining the first historical inventory adjustment quantity of each target node database aiming at the n target node databases. And the second real-time inventory supply quantity distribution submodule is used for distributing the real-time inventory supply quantity to the n target node databases based on a preset distribution strategy of the dynamic distribution quantity.

As an alternative embodiment, the real-time inventory supply allocation module includes: and the second historical inventory adjustment quantity obtaining submodule is used for obtaining a second historical inventory adjustment quantity of the specified object in each target node database aiming at the n target node databases. A third dynamic allocation amount determining submodule for determining a dynamic allocation amount based on the second historical inventory adjustment amount, and a third real-time inventory supply amount allocating submodule for allocating a real-time inventory supply amount to the n target node databases based on a preset allocation policy of the dynamic allocation amount.

As an alternative embodiment, the real-time inventory supply allocation module is configured to: and distributing the real-time inventory supply amount to the n target node databases within a first preset time period.

Fig. 6 schematically illustrates a block diagram of an inventory distribution device according to another embodiment of the present disclosure. As shown in fig. 6, the inventory allocation device 600 may further include a proposed node database monitoring module 610, an inventory recovery amount obtaining module 620, and an inventory recovery amount supplementing module 630, in addition to the real-time inventory supply amount obtaining module 510, the target node database monitoring module 520, and the real-time inventory supply amount allocating module 530.

The proposed node database monitoring module 610 is configured to monitor whether p proposed node databases exist in the m node databases, where a current inventory margin of the designated object in the proposed node databases is lower than a second preset inventory threshold, the second preset inventory threshold is smaller than the first preset inventory threshold, p is a positive integer, and m is greater than or equal to p. Optionally, the proposed node database monitoring module 610 may be configured to perform operation S410 described in fig. 4, for example, and will not be described herein again.

An inventory recovery quantity obtaining module 620, configured to, in the case that p proposed node databases exist, obtain an inventory recovery quantity of the specified object based on the current inventory surplus of the p proposed node databases excluding the m node databases. Optionally, the inventory recovery amount obtaining module 620 may be configured to perform operation S420 described in fig. 4, for example, and will not be described herein again.

And an inventory recovery quantity supplementing module 630 for supplementing the inventory recovery quantity to the centralized database. Optionally, the inventory recovery amount supplementing module 630 may be configured to perform operation S430 described in fig. 4, for example, and will not be described herein again.

As an alternative embodiment, the inventory recovery obtaining module is configured to: and obtaining the inventory recovery amount of the specified object based on a preset recovery strategy.

As an alternative embodiment, the inventory recovery obtaining module is configured to: and obtaining the inventory recycling amount of the specified object based on the preset recycling strategy of the dynamic inventory recycling amount.

As an alternative embodiment, the inventory recovery obtaining module includes: and obtaining the inventory recovery amount of the specified object based on a preset recovery strategy with a fixed proportion.

As an alternative embodiment, the proposed node database monitoring module is configured to: and monitoring whether p proposed node databases exist in the m node databases or not within a second preset time period.

It should be noted that the implementation, solved technical problems, implemented functions, and achieved technical effects of each module in the embodiment of the inventory allocation apparatus are respectively the same as or similar to the implementation, solved technical problems, implemented functions, and achieved technical effects of each corresponding step in the embodiment of the inventory allocation method, and are not described herein again.

Any number of modules, sub-modules, or at least part of the functionality of any number thereof according to embodiments of the present disclosure may be implemented in one module. Any one or more of the modules and sub-modules according to the embodiments of the present disclosure may be implemented by being split into a plurality of modules. Any one or more of the modules, sub-modules according to embodiments of the present disclosure may be implemented at least in part as a hardware circuit, such as a field programmable gate array (FNGA), a programmable logic array (NLA), 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 any other reasonable manner of hardware or firmware by integrating or packaging the circuit, or in any one of three implementations, or in any suitable combination of any of the software, hardware and firmware. Alternatively, one or more of the modules, sub-modules according to embodiments of the disclosure may be implemented at least partly as computer program modules, which when executed may perform corresponding functions.

For example, the real-time inventory supply quantity obtaining module, the target node database monitoring module, the real-time inventory supply quantity distribution module, the first historical inventory adjustment interval obtaining submodule, the first dynamic interval determining submodule, the first node database scanning submodule, the second historical inventory adjustment interval obtaining submodule, the second dynamic interval determining submodule, the second node database scanning submodule, the preset initial inventory quantity obtaining submodule, the first dynamic distribution quantity determining submodule, the first real-time inventory supply quantity distribution submodule, the first historical inventory adjustment quantity obtaining submodule, the second dynamic distribution quantity determining submodule, the second real-time inventory supply quantity distribution submodule, the second historical inventory adjustment quantity obtaining submodule, the third dynamic distribution quantity determining submodule, the third real-time inventory supply quantity distribution submodule, the proposed node database monitoring module, the third real-time inventory supply quantity distribution submodule, the second dynamic distribution quantity distribution submodule, the third real-time inventory distribution quantity distribution submodule, the proposed, The inventory recovery amount obtaining module and the inventory recovery amount supplementing module may be combined and implemented in one module, or any one of the modules may be split into a plurality of modules. Alternatively, at least part of the functionality of one or more of these modules may be combined with at least part of the functionality of the other modules and implemented in one module. According to the embodiment of the disclosure, a real-time inventory supply quantity obtaining module, a target node database monitoring module, a real-time inventory supply quantity distribution module, a first historical inventory adjustment interval obtaining submodule, a first dynamic interval determining submodule, a first node database scanning submodule, a second historical inventory adjustment interval obtaining submodule, a second dynamic interval determining submodule, a second node database scanning submodule, a preset initial inventory quantity obtaining submodule, a first dynamic distribution quantity determining submodule, a first real-time inventory supply quantity distribution submodule, a first historical inventory adjustment quantity obtaining submodule, a second dynamic distribution quantity determining submodule, a second real-time inventory supply quantity distribution submodule, a second historical inventory adjustment quantity obtaining submodule, a third dynamic distribution quantity determining submodule, a third real-time inventory supply quantity distribution submodule, a proposed node database monitoring module, At least one of the inventory recovery obtaining module and the inventory recovery supplementing module may be implemented at least in part as a hardware circuit, such as a hardware or firmware circuit, e.g., a field programmable gate array (FNGA), a programmable logic array (NLA), a system on a chip, a system on a substrate, a system on a package, an Application Specific Integrated Circuit (ASIC), or any other reasonable manner in which a circuit may be integrated or packaged, or in any one of three implementations, or in any suitable combination of any of these. Or, the real-time inventory supply quantity obtaining module, the target node database monitoring module, the real-time inventory supply quantity distribution module, the first historical inventory adjustment interval obtaining submodule, the first dynamic interval determining submodule, the first node database scanning submodule, the second historical inventory adjustment interval obtaining submodule, the second dynamic interval determining submodule, the second node database scanning submodule, the preset initial inventory quantity obtaining submodule, the first dynamic distribution quantity determining submodule, the first real-time inventory supply quantity distribution submodule, the first historical inventory adjustment quantity obtaining submodule, the second dynamic distribution quantity determining submodule, the second real-time inventory supply quantity distribution submodule, the second historical inventory adjustment quantity obtaining submodule, the third dynamic distribution quantity determining submodule, the third real-time inventory supply quantity distribution submodule, the proposed node database monitoring module, At least one of the inventory recovery quantity obtaining module and the inventory recovery quantity replenishment module may be at least partially implemented as a computer program module which, when executed, may perform a corresponding function.

FIG. 7 schematically illustrates a schematic diagram of a computer-readable storage medium product suitable for implementing the inventory allocation method described above, according to an embodiment of the disclosure.

In some possible embodiments, aspects of the present invention may also be implemented in the form of a program product including program code for causing a device to perform the aforementioned operations (or steps) in the inventory allocation method for a database according to various exemplary embodiments of the present invention described in the above-mentioned "exemplary method" section of this specification when the program product is run on the device, for example, the electronic device may perform operations S310 to S330 as shown in fig. 3, or the electronic device may perform operations S310 to S330 and operations S410 to S430 as shown in fig. 4.

The program product may employ any combination of one or more readable media. The readable medium may be a readable signal medium or a readable storage medium. A readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, or device, or any combination of the foregoing. More specific examples (a non-exhaustive list) of the readable storage medium include: an electrical connection having one or more wires, a portable disk, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (ENROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

As shown in fig. 7, a program product 700 for inventory allocation of a database is depicted, which may employ a portable compact disc read only memory (CD-ROM) and include program code, and may be run on a device, such as a personal computer, in accordance with an embodiment of the present invention. However, the program product of the present invention is not limited in this respect, and in this document, a 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, or device.

A readable signal medium may include a propagated data signal with readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A readable signal medium may also be any readable medium that is not a readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, or device. Program code embodied on a readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.

Program code for carrying out operations for aspects of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, C + + or the like and conventional procedural programming languages, such as the "C", or similar programming languages. The program code may execute entirely on the user computing device, partly on a remote computing device, or entirely on the remote computing device or server. In the case of a remote computing device, the remote computing device may be connected to the user computing device through any kind of network, including a local area network (LAA) or a wide area network (WAA), or may be connected to an external computing device (e.g., through the internet using an internet service provider).

Fig. 8 schematically illustrates a block diagram of an electronic device adapted to implement the inventory allocation method described above, in accordance with an embodiment of the present disclosure. The electronic device shown in fig. 8 is only an example and should not bring any limitation to the functions and the scope of use of the embodiments of the present disclosure.

An electronic device 800 according to an embodiment of the present disclosure, as shown in fig. 8, includes a processor 801 that can perform various appropriate actions and processes according to a program stored in a Read Only Memory (ROM)802 or a program loaded from a storage section 808 into a Random Access Memory (RAM) 803. The processor 801 may include, for example, a general purpose microprocessor (e.g., CNU), an instruction set processor and/or associated chipset(s) and/or a special purpose microprocessor (e.g., Application Specific Integrated Circuit (ASIC)), and so forth. The processor 801 may also include onboard memory for caching purposes. The processor 801 may include a single processing unit or multiple processing units for performing different actions of the method flows according to embodiments of the present disclosure.

In the RAM 803, various programs and data necessary for the operation of the electronic apparatus 800 are stored. The processor 801, the ROM 802, and the RAM 803 are connected to each other by a bus 804. The processor 801 performs various operations of the method flows according to the embodiments of the present disclosure by executing programs in the ROM 802 and/or RAM 803. Note that the programs may also be stored in one or more memories other than ROM 802 and RAM 803. The processor 801 may also perform operations S310 through S330 illustrated in fig. 3 according to the embodiments of the present disclosure by executing the programs stored in the one or more memories, or the electronic device may perform operations S310 through S330 and operations S410 through S430 as illustrated in fig. 4.

Electronic device 800 may also include input/output (I/O) interface 805, input/output (I/O) interface 805 also connected to bus 804, according to an embodiment of the present disclosure. The system 800 may also include one or more of the following components connected to the I/O interface 805: an input portion 806 including a keyboard, a mouse, and the like; an output section 807 including a signal such as a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and the like, and a speaker; a storage portion 808 including a hard disk and the like; and a communication section 809 including a network interface card such as an LAA card, modem, or the like. The communication section 809 performs communication processing via a network such as the internet. A drive 810 is also connected to the I/O interface 805 as necessary. A removable medium 811 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is installed on the drive 810 as necessary to facilitate the computer program read out therefrom into the storage section 808 as necessary.

Method flows according to embodiments of the present disclosure may be implemented as computer software programs, according to embodiments of the present disclosure. For example, embodiments of the present disclosure include a computer program product comprising a computer program carried on a computer readable storage medium, the computer program containing program code for performing the method illustrated by the flow chart. In such an embodiment, the computer program may be downloaded and installed from a network through the communication section 809 and/or installed from the removable medium 811. The computer program performs the above-described functions defined in the system of the embodiment of the present disclosure when executed by the processor 801. Embodiments according to the present disclosure, the above-described systems, devices, apparatuses, modules, units, etc. may be implemented by computer program modules.

The present disclosure also provides a computer-readable storage medium, which may be contained in the device/apparatus/system described in the above embodiments; or may exist separately and not be incorporated into the apparatus/device/system. The above-mentioned computer-readable storage medium carries one or more programs, which when executed, implement the inventory allocation method for a database according to an embodiment of the present disclosure, including operations S310 to S330 shown in fig. 3, or the electronic device may perform operations S310 to S330 and operations S410 to S430 shown in fig. 4.

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 (ENROM 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 present 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, a computer-readable storage medium may include the ROM 802 and/or RAM 803 described above and/or one or more memories other than the ROM 802 and RAM 803 in accordance with embodiments of the present disclosure.

The flowchart 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.

It will be understood by those skilled in the art that various embodiments of the present disclosure and/or features recited in the claims may be variously combined and/or coupled even if such combinations or couplings are not explicitly recited in the present disclosure. In particular, various combinations and/or combinations of the features recited in the various embodiments of the present disclosure and/or claims may be made without departing from the spirit and teachings of the present disclosure. All such combinations and/or associations are within the scope of the present disclosure.

The embodiments of the present disclosure have been 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 separately above, this does not mean that the measures in the embodiments cannot be used in advantageous combination. The scope of the disclosure is defined by the appended claims and equivalents thereof. Various alternatives and modifications can be devised by those skilled in the art without departing from the scope of the present disclosure, and such alternatives and modifications are intended to be within the scope of the present disclosure.

Claims

1. An inventory allocation method for a database, comprising:

obtaining real-time inventory supply of a designated object in a centralized database, wherein the real-time inventory supply is the sum of the initial inventory supply minus the real-time inventory consumption of m node databases, m is a positive integer and is more than or equal to 2;

scanning the m node databases based on a preset scanning strategy to monitor whether n target node databases exist in the m node databases, wherein the current inventory allowance of the specified object in the target node databases is lower than a first preset inventory threshold value, n is a positive integer, and m is larger than or equal to n;

and when the n target node databases exist, distributing the real-time inventory supply amount to the n target node databases to adjust the current inventory surplus of the specified object in the n target node databases.

2. The method of claim 1, wherein said scanning the m node databases based on a preset scanning policy comprises:

and scanning the m node databases based on a preset scanning strategy of a dynamic interval to monitor whether n target node databases exist in the m node databases.

3. The method of claim 2, wherein the scanning the m node databases based on the dynamically spaced preset scanning policy comprises:

aiming at the m node databases, acquiring a first historical inventory adjustment interval corresponding to the adjustment of the current inventory allowance of each node database;

determining a dynamic interval based on the first historical inventory adjustment interval;

and scanning the m node databases based on the preset scanning strategy of the dynamic interval.

4. The method of claim 2, wherein the scanning the m node databases based on the dynamically spaced preset scanning policy comprises:

aiming at the m node databases, acquiring a second historical inventory adjustment interval corresponding to the designated object when the designated object is adjusted in each node database;

determining a dynamic interval based on the second historical inventory adjustment interval;

5. The method of claim 1, wherein said scanning the m node databases based on a preset scanning policy comprises:

and scanning the m node databases based on a preset scanning strategy at fixed intervals to monitor whether n target node databases exist in the m node databases.

6. The method of claim 1, wherein said allocating said real-time inventory supply to said n target node databases comprises:

and distributing the real-time inventory supply amount to the n target node databases based on a preset distribution strategy.

7. The method of claim 6, wherein said allocating the real-time inventory supply volume to the n target node databases based on a preset allocation policy comprises:

and distributing the real-time inventory supply amount to the n target node databases based on a preset distribution strategy of the dynamic distribution amount.

8. The method of claim 7, wherein the allocating the real-time inventory supply volume to the n target node databases based on the preset allocation policy for dynamic allocation volumes comprises:

aiming at the n target node databases, acquiring a preset initial inventory of the specified object in each target node database;

determining a dynamic distribution amount based on the preset initial inventory amount and the current inventory allowance;

9. The method of claim 7, wherein the allocating the real-time inventory supply volume to the n target node databases based on the preset allocation policy for dynamic allocation volumes comprises:

aiming at the n target node databases, obtaining a first historical inventory adjustment amount of each target node database;

determining a dynamic allocation amount based on the first historical inventory adjustment amount;

10. The method of claim 7, wherein the allocating the real-time inventory supply volume to the n target node databases based on the preset allocation policy for dynamic allocation volumes comprises:

aiming at the n target node databases, obtaining a second historical inventory adjustment amount of the specified object in each target node database;

determining a dynamic allocation amount based on the second historical inventory adjustment amount;

11. The method of claim 6, wherein said allocating the real-time inventory supply volume to the n target node databases based on a preset allocation policy comprises:

and distributing the real-time inventory supply amount to the n target node databases based on a preset distribution strategy of fixed distribution amount.

12. The method of any of claims 1 to 11, wherein said allocating said real-time inventory supply to said n target node databases comprises:

and distributing the real-time inventory supply amount to the n target node databases within a first preset time period.

13. The method of claim 1, wherein the method further comprises:

monitoring whether p proposed node databases exist in the m node databases, wherein the current inventory allowance of the specified object in the proposed node databases is lower than a second preset inventory threshold value, the second preset inventory threshold value is smaller than the first preset inventory threshold value, p is a positive integer, and m is larger than or equal to p;

when the p proposed node databases exist, obtaining the inventory recovery amount of the specified object based on the current inventory allowance of the p proposed node databases except the m node databases;

supplementing the inventory recovery amount into the centralized database.

14. The method of claim 13, wherein the obtaining an inventory recovery amount for the specified object comprises:

and obtaining the inventory recovery amount of the specified object based on a preset recovery strategy.

15. The method of claim 14, wherein the obtaining the inventory recovery amount for the specified object based on a preset recovery policy comprises:

and obtaining the inventory recovery amount of the specified object based on a preset recovery strategy of the dynamic inventory recovery amount.

16. The method of claim 14, wherein the obtaining the inventory recovery amount for the specified object based on a preset recovery policy comprises:

and obtaining the inventory recovery amount of the specified object based on a preset recovery strategy with a fixed proportion.

17. The method of any one of claims 13 to 16, wherein said monitoring whether there are p proposed node databases among said m node databases comprises:

and monitoring whether p proposed node databases exist in the m node databases within a second preset time period.

18. An inventory distribution device for a database, comprising:

the real-time inventory supply quantity obtaining module is used for obtaining the real-time inventory supply quantity of the specified object in the centralized database, wherein the real-time inventory supply quantity is the sum of the initial inventory supply quantity minus the real-time inventory consumption quantities of the m node databases, m is a positive integer and is more than or equal to 2;

a target node database monitoring module, configured to scan the m node databases based on a preset scanning policy to monitor whether n target node databases exist in the m node databases, where a current inventory allowance of the designated object in the target node databases is lower than a first preset inventory threshold, n is a positive integer, and m is greater than or equal to n;

and the real-time inventory supply quantity distribution module is used for distributing the real-time inventory supply quantity to the n target node databases to adjust the current inventory surplus quantity of the specified object in the n target node databases under the condition that the n target node databases exist.

19. The apparatus of claim 18, wherein the apparatus further comprises:

the proposed node database monitoring module is used for monitoring whether p proposed node databases exist in the m node databases, wherein the current inventory allowance of the specified object in the proposed node databases is lower than a second preset inventory threshold value, the second preset inventory threshold value is smaller than the first preset inventory threshold value, p is a positive integer, and m is larger than or equal to p;

an inventory recovery quantity obtaining module, configured to, when the p proposed node databases exist, obtain an inventory recovery quantity of the designated object based on current inventory margins of the m node databases excluding the p proposed node databases;

and the inventory recovery quantity supplementing module is used for supplementing the inventory recovery quantity to the centralized database.

20. An electronic device, comprising:

one or more processors;

a memory for storing one or more programs,

wherein the one or more programs, when executed by the one or more processors, cause the one or more processors to implement the method of any of claims 1-17.

21. A computer-readable storage medium storing computer-executable instructions for implementing the method of any one of claims 1 to 17 when executed.