CN118096036A - Inventory flow generation method, inventory system, medium and computing device - Google Patents
Inventory flow generation method, inventory system, medium and computing device Download PDFInfo
- Publication number
- CN118096036A CN118096036A CN202410325255.9A CN202410325255A CN118096036A CN 118096036 A CN118096036 A CN 118096036A CN 202410325255 A CN202410325255 A CN 202410325255A CN 118096036 A CN118096036 A CN 118096036A
- Authority
- CN
- China
- Prior art keywords
- inventory
- data
- log data
- flow
- module
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 45
- 230000008859 change Effects 0.000 claims abstract description 80
- 238000012508 change request Methods 0.000 claims abstract description 80
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 claims abstract description 65
- 230000008569 process Effects 0.000 claims abstract description 11
- 238000004590 computer program Methods 0.000 claims description 14
- 230000002776 aggregation Effects 0.000 claims description 13
- 238000004220 aggregation Methods 0.000 claims description 13
- 238000006116 polymerization reaction Methods 0.000 claims description 5
- 230000006870 function Effects 0.000 description 20
- 238000010586 diagram Methods 0.000 description 5
- 230000003287 optical effect Effects 0.000 description 3
- 230000002159 abnormal effect Effects 0.000 description 2
- 230000008901 benefit Effects 0.000 description 2
- 239000013307 optical fiber Substances 0.000 description 2
- 230000002085 persistent effect Effects 0.000 description 2
- 230000000644 propagated effect Effects 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 230000008878 coupling Effects 0.000 description 1
- 238000010168 coupling process Methods 0.000 description 1
- 238000005859 coupling reaction Methods 0.000 description 1
- 230000003247 decreasing effect Effects 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000001737 promoting effect Effects 0.000 description 1
- 238000011084 recovery Methods 0.000 description 1
- 230000009467 reduction Effects 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 238000011144 upstream manufacturing Methods 0.000 description 1
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
Embodiments of the present disclosure provide a method for generating an inventory flow, an inventory system, a medium, and a computing device, the method comprising: receiving at least one inventory change request, and generating a corresponding running water identifier for each inventory change request; the inventory change request comprises an inventory change object and inventory change data; updating the inventory data of the inventory change object in a database based on the inventory change data and the flow identification; the data table corresponding to the inventory data is preset with a stream identification field; acquiring at least one piece of log data generated by the database in the updating process, wherein each piece of log data comprises a running water identifier; and correlating the inventory change requests with the same stream identification with the log data to generate at least one piece of inventory stream data. The method does not need to change and correspondingly adjust the inventory change logic, thereby improving the expansibility.
Description
Technical Field
Embodiments of the present disclosure relate to the field of computer technology, and more particularly, to a method for generating an inventory flow, an inventory system, a medium, and a computing device.
Background
This section is intended to provide a background or context to the embodiments of the disclosure recited in the claims. The description herein is not admitted to be prior art by inclusion in this section.
Inventory pipelining is a record of changes to inventory that can be used to ensure the accuracy and traceability of inventory data.
In the related art, a corresponding inventory flow generation function is predefined, so that when an inventory change request is received, inventory flow data can be generated by calling the inventory flow generation function.
However, when the inventory change logic is changed, the inventory flow generating function needs to be correspondingly adjusted, and the expansibility is poor.
Disclosure of Invention
In view of the foregoing, the present disclosure provides a method, an inventory system, a medium and a computing device for generating an inventory flow, so as to solve the deficiencies in the related art.
In a first aspect of embodiments of the present disclosure, there is provided a method for generating an inventory flow, including:
Receiving at least one inventory change request, and generating a corresponding running water identifier for each inventory change request; the inventory change request comprises an inventory change object and inventory change data;
updating the inventory data of the inventory change object in a database based on the inventory change data and the flow identification; the data table corresponding to the inventory data is preset with a stream identification field;
acquiring at least one piece of log data generated by the database in the updating process, wherein each piece of log data comprises a running water identifier;
and correlating the inventory change requests with the same stream identification with the log data to generate at least one piece of inventory stream data.
Optionally, the log data associated with the inventory change request includes log data obtained by combining log data having the same unique identifier and the running water identifier according to a preset rule; the preset rule is used for defining a field corresponding to the unique identifier of the log data and an aggregation mode of values of the same field when the log data are combined.
Optionally, the inventory change request further includes an order identifier; after generating the at least one inventory pipeline data, the method further comprises:
combining the inventory flow data with the same order mark according to a preset rule to generate at least one order flow data;
wherein the preset rule is used for defining an aggregation mode of values of the same field when the inventory flow data are combined
Optionally, the log data further includes time information; the polymerization mode at least comprises any one of the following steps:
when the fields represent the stock quantity, summing the values of the same fields, and taking the obtained summed value as the value of the corresponding combined field; or alternatively, the first and second heat exchangers may be,
When the fields characterize the time information, the minimum value or the maximum value in the values of the same fields is used as the value of the corresponding fields after combination.
In a second aspect of embodiments of the present disclosure, an inventory system is provided that includes an inventory change module and an inventory flow module; the inventory change module comprises a running water identification generation sub-module and an inventory data updating sub-module, and the inventory running water module comprises a log data acquisition sub-module and an inventory running water generation sub-module;
The running water identification generation sub-module is used for receiving at least one inventory change request and generating a corresponding running water identification aiming at each inventory change request; the inventory change request comprises an inventory change object and inventory change data;
The inventory data updating sub-module is used for updating the inventory data of the inventory change object in a database based on the inventory change data and the flow identification; the data table corresponding to the inventory data is preset with a stream identification field;
The log data acquisition sub-module is used for acquiring at least one piece of log data generated by the database in the updating process, and each piece of log data comprises a running water identifier;
The inventory flow generation sub-module is used for associating the inventory change requests with the same flow identification with the log data to generate at least one piece of inventory flow data.
Optionally, the log data associated with the inventory change request includes log data obtained by combining log data having the same unique identifier and the running water identifier according to a preset rule; the preset rule is used for defining a field corresponding to the unique identifier of the log data and an aggregation mode of values of the same field when the log data are combined.
Optionally, the inventory change request further includes an order identifier; the inventory flow module further comprises an order inventory flow generation sub-module, which is used for combining inventory flow data with the same order identification according to preset rules to generate at least one order flow data;
wherein the preset rule is used for defining an aggregation mode of values of the same field when the inventory flow data are combined
Optionally, the log data further includes time information; the polymerization mode at least comprises any one of the following steps:
when the fields represent the stock quantity, summing the values of the same fields, and taking the obtained summed value as the value of the corresponding combined field; or alternatively, the first and second heat exchangers may be,
When the fields characterize the time information, the minimum value or the maximum value in the values of the same fields is used as the value of the corresponding fields after combination.
In a third aspect of embodiments of the present disclosure, a computer-readable storage medium is provided, on which a computer program is stored, which computer program, when being executed by a processor, implements a method as described in the first aspect above.
In a fourth aspect of embodiments of the present disclosure, there is provided a computing device comprising:
A processor;
a memory for storing a processor executable program;
Wherein the processor is configured to implement the method according to the first aspect by running the executable program.
In a fifth aspect of embodiments of the present disclosure, a computer program product is provided, comprising a computer program which, when executed by a processor, implements the method as described in the first aspect above.
According to the embodiment of the disclosure, the running water identification field is set in the data table which is related in the database in advance during inventory change, when an inventory change request (comprising an inventory change object and inventory change data) is received, a corresponding running water identification can be generated for the inventory change request, the inventory data of the inventory change object in the database is updated based on the inventory change data and the running water identification, the generated log data comprises the running water identification identical to the inventory change request, so that the inventory change request corresponding to the log data can be determined through the running water identification, the running water data can be generated by correlating the inventory change request with the log data, an inventory running water generation function is not required to be predefined to generate the running water data, corresponding adjustment is not required to be performed when inventory change logic is changed, expansibility is improved, the situation that the generated running water data is incorrect due to errors when the inventory running water generation function is adjusted can be avoided, and the accuracy of the running water data is ensured.
Drawings
The above, as well as additional purposes, features, and advantages of exemplary embodiments of the present disclosure will become readily apparent from the following detailed description when read in conjunction with the accompanying drawings. Several embodiments of the present disclosure are illustrated by way of example, and not by way of limitation, in the figures of the accompanying drawings, in which:
FIG. 1 schematically illustrates a flow chart of a method of generating an inventory flow according to an embodiment of the disclosure;
FIG. 2 schematically illustrates a schematic diagram of an inventory model according to an embodiment of the disclosure;
FIG. 3 schematically illustrates a schematic diagram of an inventory system according to an embodiment of the present disclosure;
FIG. 4 schematically illustrates a schematic diagram of a computer-readable storage medium according to an embodiment of the present disclosure;
Fig. 5 schematically illustrates a schematic diagram of a computing device according to an embodiment of the disclosure.
In the drawings, the same or corresponding reference numerals indicate the same or corresponding parts.
Detailed Description
The principles and spirit of the present disclosure will be described below with reference to several exemplary embodiments. It should be understood that these embodiments are presented merely to enable one skilled in the art to better understand and practice the present disclosure and are not intended to limit the scope of the present disclosure in any way. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.
Those skilled in the art will appreciate that embodiments of the present disclosure may be implemented as a system, apparatus, device, method, or computer program product. Accordingly, the present disclosure may be embodied in the following forms, namely: complete hardware, complete software (including firmware, resident software, micro-code, etc.), or a combination of hardware and software.
According to embodiments of the present disclosure, a method, an inventory system, a medium, and a computing device for generating an inventory flow are provided.
In this document, it should be understood that any number of elements in the drawings is for illustration and not limitation, and that any naming is used only for distinction and not for any limitation.
The principles and spirit of the present disclosure are explained in detail below with reference to several representative embodiments thereof.
Summary of The Invention
Inventory pipelining is a record of changes to inventory that can be used to ensure the accuracy and traceability of inventory data. In the related art, a corresponding inventory flow generation function is predefined, so that when an inventory change request is received, inventory flow data can be generated by calling the inventory flow generation function. For example, when a user places an order to purchase a commodity A, the available inventory corresponding to the commodity A in the database is changed from 100 to 99, and then, for an inventory change request generated by the user placing the order, the inventory flow generating function is called to generate inventory flow data representing 1 piece of available inventory reduction of the commodity A.
However, when the inventory change logic is changed, the inventory flow generating function needs to be correspondingly adjusted, and the expansibility is poor. For example, the original inventory change logic needs to modify the corresponding inventory flow generation function for inventory change requests generated by user orders, as long as the available inventory of the commodity is reduced, and the locked inventory of the commodity needs to be increased now.
The inventors have found that when modifying (e.g., inserting, updating, deleting, etc.) data tables in the database, the database automatically generates corresponding log data to record the modifying operations for data recovery, rollback, etc., such as binlog (binary log) data generated by MySQL database, WAL (Write-Ahead Logging, pre-learned log) data generated by PostgreSQL database, etc. For example, the value of field a of record a in data table a is changed from 100 to 99, and the database generates log data representing the change of the value of field a of record a from 100 to 99. The stock flow is a record of change conditions of the stock, the log data is a record of change conditions of the data table, and the functions of the two are similar. In the related art, the log data is generally used to determine whether the inventory is lower than a specified threshold or 0, so as to determine whether the commodity is close to or sold out, so that early warning or taking off the shelf and other operations can be performed in time, and inventory flow is not involved.
The inventors have further found that when an inventory change request is received to update inventory data stored in a database, log data may be obtained to determine the change of the corresponding data table, but it is not possible to determine which inventory change the log data generated due to which inventory change corresponds to which inventory change request.
Therefore, the inventor proposes a method for generating an inventory running water, which can set a running water identification field in a data table related to a database in the process of inventory change in advance, can generate a corresponding running water identification for an inventory change request (comprising an inventory change object and inventory change data) when the inventory change request is received, and update the inventory data of the inventory change object in the database based on the inventory change data and the running water identification, wherein the generated log data comprises the running water identification identical to the inventory change request, so that the inventory running water data can be generated by determining the inventory change request corresponding to the log data through the running water identification, and the inventory change request and the log data with the identical running water identification are related, thereby generating the running water data without predefining an inventory running water generation function, and further, correspondingly adjusting the inventory change logic, improving the expansibility, and avoiding the condition that the generated inventory running water data is incorrect due to errors when the inventory running water generation function is adjusted, and ensuring the accuracy of the inventory running water data.
The inventory system is a system for managing and tracking the inventory of commodities, and has the core function of accurately recording the information of the quantity, the position and the like of each commodity and ensuring the real-time property and the accuracy of inventory data. When the user ordering, user payment, commodity warehouse entry, commodity warehouse exit and other operations occur, the related upstream system can initiate an inventory change request to the inventory system, and an inventory change module in the inventory system can update inventory data stored in the database according to the received inventory change request.
In the related art, an inventory flow module is newly added in an inventory change module of the inventory system, and corresponding inventory flow generation functions are predefined for inventory change requests generated by different operations in the inventory flow module, so that when the inventory system receives the inventory change request, inventory flow data can be generated by calling the corresponding inventory flow generation functions in the inventory flow module.
However, the inventory flow module exists in the inventory change module, so that the coupling degree is higher, the inventory change module is easily influenced when the inventory flow module is modified, the risk of error in updating the inventory data is increased, and the accuracy of the inventory data and the stability of the inventory system are reduced. When the stock change logic is changed, the stock flow generating function in the stock flow module needs to be correspondingly adjusted, and the expansibility is poor.
Therefore, the inventor also provides an inventory system, which comprises an inventory change module and an inventory flow module, wherein the inventory change module generates a corresponding flow identification for a received inventory change request (comprising an inventory change object and inventory change data), updates inventory data of the inventory change object in a database based on the inventory change data and the flow identification, and the inventory flow module determines the inventory change request corresponding to log data through the flow identification to correlate the inventory change request with the same flow identification with the log data to generate inventory flow data, so that an inventory generation function is not required to be predefined in the inventory change module to generate the flow data, and the inventory change logic is not required to be changed to correspondingly adjust, thereby improving expansibility, avoiding the situation that the generated inventory flow data is incorrect due to errors when the inventory flow generation function is adjusted, ensuring the accuracy of the inventory flow data, decoupling the inventory change module and the inventory flow module, and improving the accuracy of the inventory data and the stability of the inventory system.
Having described the basic principles of the present disclosure, various non-limiting embodiments of the present disclosure are specifically described below.
Exemplary method
A method of generating inventory running water according to an exemplary embodiment of the present disclosure is described below with reference to fig. 1.
Fig. 1 schematically illustrates a method of generating inventory running water according to an embodiment of the disclosure, including:
Step S101, receiving at least one inventory change request, and generating a corresponding running water identifier for each inventory change request; the inventory change request includes an inventory change object and inventory change data.
In this embodiment, for different types of operations (e.g., user order, user payment, merchandise warehouse entry and merchandise warehouse exit, etc.), a corresponding inventory change request may be generated. The inventory change request may include an inventory change object that is a SKU (Stock Keeping Unit, minimum stock keeping unit) corresponding to the item for which the operation is directed, and the inventory change data may be an increased or decreased inventory amount. For example, the user orders 5 goods a, the generated stock change request includes a stock change object which may be SKU1 corresponding to the goods a, and the stock change data may be to reduce 5 pieces of stock; for example, 3 products B are put in stock, the stock change object included in the generated stock change request may be SKU2 corresponding to the product B, and the stock change data may be 3 more stock.
Step S102, based on the stock change data and the flow identification, updating the stock data of the stock change object in a database; the data table corresponding to the stock data is preset with a stream identification field.
Inventory models are models that are abstracted to deal with complex inventory management scenarios, and can be generally divided into 3 levels: a physical layer, a sales layer, and a warehouse layer, each of which can derive a more dimensional inventory model over the underlying inventory model. As shown in the inventory model of FIG. 2, at the physical layer, for each commodity, the information such as the SKU, the available inventory, the occupied inventory, the locked inventory and the update time can be known by adopting the basic physical inventory model, and the information such as the SKU, the belonging warehouse, the available inventory, the occupied inventory, the locked inventory and the update time can be known by adopting the warehouse dimension physical inventory model. Where available inventory may refer to the number of inventory actually available for sale, occupied inventory may refer to the number of inventory that has been allocated to a particular order, but not yet placed in stock, and locked inventory may refer to the number of inventory that is locked for promotional activity.
In this embodiment, a corresponding data table may be designed in the database for each inventory model in order to store and manage inventory information of the goods. For example, the base physical inventory model may correspond to the data tables shown in Table 1 and the warehouse dimension physical inventory model may correspond to the data tables shown in Table 2.
TABLE 1
TABLE 2
| SKU | Belonging to warehouse | Available inventory | Occupying inventory | Locking inventory |
| 001 | Warehouse A | 120 | 8 | 60 |
| 001 | Warehouse B | 80 | 2 | 40 |
| 002 | Warehouse A | 70 | 0 | 25 |
| 002 | Warehouse C | 30 | 0 | 25 |
In this embodiment, in order to correlate the log data with the inventory change request, a running water identification field may be set in advance for the data table corresponding to each inventory model, as shown in table 3, where the default value of the running water identification may be set to a null value.
TABLE 3 Table 3
| SKU | Available inventory | Occupying inventory | Locking inventory | Running water sign |
| 001 | 200 | 10 | 100 | |
| 002 | 100 | 0 | 50 |
Step S103, at least one piece of log data generated by the database in the updating process is obtained, and each piece of log data comprises a running water identifier.
In this embodiment, when the inventory data of the inventory change object in the database is updated based on the inventory change data and the running water identifier, the database generates corresponding log data, where each log data may include values before and after updating each field in the corresponding record, so as to obtain a change value of a field characterizing the inventory amount in each record and a value of a field characterizing the running water identifier after updating, for example, a data table as shown in table 4 is obtained after updating table 3, and log data as shown in table 5 may be obtained.
TABLE 4 Table 4
TABLE 5
| SKU | Available inventory | Occupying inventory | Locking inventory | Running water sign |
| 001 | 0 | -10 | -100 | 1001 |
| 002 | -10 | +10 | -50 | 1002 |
Step S104, the inventory change request with the same flow identification is associated with the log data, and at least one piece of inventory flow data is generated.
In this embodiment, the log data generated by updating the database with the inventory change request has the same flow identifier as the inventory change request, so that the inventory change request and the log data can be associated based on the flow identifier to generate inventory flow data.
In an embodiment, each inventory change request may update a plurality of data tables in a database and/or a plurality of records in one data table, the same inventory change request may update the same record a plurality of times, the corresponding database may generate a plurality of pieces of log data, and the log data having the same unique identifier and the same stream identifier may be combined and then associated with the inventory change request, so that the number of times of querying during association may be reduced, thereby reducing the load of the database and improving the efficiency of association.
In this embodiment, the log data associated with the inventory change request includes log data obtained by combining log data having the same unique identifier and the same running water identifier according to a preset rule; the preset rule is used for defining a field corresponding to the unique identifier of the log data and an aggregation mode of values of the same field when the log data are combined.
The unique identifier of the log data may refer to a primary key of a data table corresponding to the log data, each piece of data in the data table may be uniquely identified, for example, the primary key of the data table corresponding to the basic physical inventory model may be a SKU field, and a field corresponding to the unique identifier of the log data generated by updating the data table may be a SKU; for example, the primary key of the data table corresponding to the warehouse dimension real object inventory model may be a combination of SKU fields and affiliated warehouse fields, and the fields corresponding to the unique identifier of the log data generated by updating the data table may be SKUs and affiliated warehouses.
In this embodiment, the log data may further include time information; the polymerization mode at least comprises any one of the following steps:
When the fields represent the stock quantity, summing the values of the same fields, and taking the obtained summed value as the value of the corresponding combined field; wherein the inventory may include available inventory, occupied inventory, locked inventory, and the like, to which the present disclosure is not limited; or alternatively, the first and second heat exchangers may be,
When the fields characterize the time information, the minimum value or the maximum value in the values of the same fields is used as the value of the corresponding fields after combination. The time information may include a creation time and an update time, among others. Illustratively, the step may further include, when the fields characterize creation time, taking a minimum value of values of the same field as a value of the merged corresponding field; or alternatively, the first and second heat exchangers may be,
When the fields characterize the update time, the maximum value of the values of the same fields is taken as the value of the corresponding fields after combination.
Specifically, the log data generated by the data table corresponding to the basic real object inventory model may be combined with the log data shown in table 6 to generate the log data shown in table 7.
TABLE 6
TABLE 7
Specifically, the log data generated by the data table corresponding to the warehouse dimension physical inventory model may combine the log data shown in table 8 to generate the log data shown in table 9.
TABLE 8
TABLE 9
In an embodiment, the inventory change request may further include an order identifier, and after generating at least one piece of inventory flowing data, the method for generating the inventory flowing data may further include the following steps:
and merging the inventory flow data with the same order mark according to a preset rule to generate at least one order flow data.
The preset rule is used for defining an aggregation mode of values of the same field when the inventory flow data are combined.
In this embodiment, multiple inventory changes are generally required in the life cycle of an order, and multiple inventory change requests are correspondingly generated, for example, the order is created when a user performs an order placing operation, and the order is in a state to be distributed when a commodity is delivered, so that the same order corresponds to at least one inventory flow data, and the inventory flow data can be combined according to the order identification to generate inventory flow data of order dimension, so that the user can know and analyze inventory conditions. For example, when the commodity corresponding to the order is delivered and is in a state to be delivered, the occupied inventory in the corresponding order inventory flow data is 0, if the occupied inventory is not 0, the inventory change process aiming at the order can be considered to be abnormal, and the efficiency of locating abnormal inventory data is improved.
In this embodiment, the inventory change request may also include an operation type, which may characterize the lifecycle stage of the order; the aggregation manner of the values of the same fields in the merging of the inventory flow data can further comprise:
When the fields represent the running water identification or the operation type, the values of the same fields are spliced, and the values can be separated by separators; wherein the separator may include comma, pause number, blank symbol, etc., which is not limited by the present disclosure.
Specifically, inventory flow data as shown in Table 10 may be combined to generate order inventory flow data as shown in Table 11.
Table 10
TABLE 11
In an embodiment, at least one piece of log data obtained from the inventory change request and generated in the updating process of the database can be stored in other databases for persistent storage, so that data loss is avoided, the data can be processed in batches to generate inventory flow data, the overload of the database is avoided, and therefore the processing efficiency is improved, and the generated inventory flow data and/or order inventory flow data can be stored in the database.
In this embodiment, after generating the at least one order flow data, the method for generating the inventory flow may further include: and merging the order flow data with the historical order flow data stored in the database storing the stock change request and the log data according to the order identification to generate full order flow data.
Exemplary System
Having introduced the architecture of exemplary embodiments of the present disclosure, next, an inventory system . according to exemplary embodiments of the present disclosure is described with reference to fig. 3, fig. 3 schematically shows a schematic diagram of an inventory system according to an embodiment of the present disclosure, including: an inventory change module 31 and an inventory flow module 32;
The inventory change module 31 includes a running water identification generation sub-module 310 and an inventory data update sub-module 311, and the inventory running water module 32 includes a log data acquisition sub-module 320 and an inventory running water generation sub-module 321;
A running water identifier generating sub-module 310, configured to receive at least one inventory change request, and generate a corresponding running water identifier for each inventory change request; the inventory change request comprises an inventory change object and inventory change data;
An inventory data updating sub-module 311, configured to update inventory data of the inventory change object in a database based on the inventory change data and the running water identifier; the data table corresponding to the inventory data is preset with a stream identification field;
A log data obtaining sub-module 320, configured to obtain at least one piece of log data generated by the database in the update process, where each piece of log data includes a running water identifier;
The inventory flow generation sub-module 321 is configured to associate the inventory change request with the same flow identifier with the log data, and generate at least one piece of inventory flow data.
In an embodiment, the log data associated with the inventory change request includes log data obtained by combining log data having the same unique identifier and the same running water identifier according to a preset rule; the preset rule is used for defining a field corresponding to the unique identifier of the log data and an aggregation mode of values of the same field when the log data are combined.
In an embodiment, the inventory change request further includes an order identification; the inventory flow module 32 further includes an order inventory flow generation sub-module 322, configured to combine inventory flow data with the same order identifier according to a preset rule to generate at least one order flow data;
the preset rule is used for defining an aggregation mode of values of the same field when the inventory flow data are combined.
In an embodiment, the log data further includes time information; the polymerization mode at least comprises any one of the following steps:
when the fields represent the stock quantity, summing the values of the same fields, and taking the obtained summed value as the value of the corresponding combined field; or alternatively, the first and second heat exchangers may be,
When the fields characterize the time information, the minimum value or the maximum value in the values of the same fields is used as the value of the corresponding fields after combination.
In this embodiment, the inventory flow module 32 may be deployed on at least one node of a large data cluster (e.g. Spark cluster, hadoop cluster, etc.), and may further store the obtained inventory change request and log data generated by the database in the update process in a database (e.g. Hbase database) adapted to the large data cluster to implement persistent storage, so as to avoid data loss, and facilitate batch processing of the data by the large data cluster to generate inventory flow data, so as to avoid overload of the database, thereby improving processing efficiency, and the generated inventory flow data and/or order inventory flow data may also be stored in the database.
In this embodiment, the inventory flow module 32 may further include a full order flow generation sub-module 323, configured to combine, according to the order identifier, the order flow data with historical order flow data stored in a database storing inventory change requests and log data, and generate full order flow data.
In this embodiment, the generated inventory streamers and/or order inventory streamers may be written to an elastic search database for storage and retrieval of large-scale data.
Exemplary Medium
Having introduced the system of exemplary embodiments of the present disclosure, next, a computer-readable storage medium of exemplary embodiments of the present disclosure is described with reference to fig. 4.
In the present exemplary embodiment, the above-described method may be implemented by a program product, such as a portable compact disc read only memory (CD-ROM) and including program code, and may be run on a device, such as a personal computer. However, the program product of the present disclosure is not limited thereto, 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, apparatus, or device.
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.
The readable storage medium can be, for example, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or a combination of any of the foregoing. More specific examples (a non-exhaustive list) of the readable storage medium would include the following: an electrical connection having one or more wires, a portable disk, a hard disk, random Access Memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
The readable signal medium may include a data signal propagated in baseband or as part of a carrier wave with readable program code embodied therein. 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 of the foregoing. 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, apparatus, 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, RE, etc., or any suitable combination of the foregoing.
Program code for carrying out operations of the present disclosure 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 programming language or similar programming languages. The program code may execute entirely on the user's computing device, partly on a remote computing device, or entirely on the remote computing device or server. In the case of remote computing devices, the remote computing device may be connected to the user computing device through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computing device (e.g., connected via the Internet using an Internet service provider).
Exemplary computing device
Having introduced the methods, systems, and media of exemplary embodiments of the present disclosure, next, a computing device of exemplary embodiments of the present disclosure is described with reference to fig. 5.
The computing device 50 shown in fig. 5 is merely an example and should not be taken as limiting the functionality and scope of use of embodiments of the present disclosure.
As shown in fig. 5, computing device 50 is in the form of a general purpose computing device. Components of computing device 50 may include, but are not limited to: the at least one processing unit 501, the at least one memory unit 502, and a bus 503 connecting the various system components, including the processing unit 501 and the memory unit 502.
The bus 503 includes a data bus, a control bus, and an address bus.
The storage unit 502 may include readable media in the form of volatile memory, such as Random Access Memory (RAM) 5021 and/or cache memory 5022, and may further include readable media in the form of non-volatile memory, such as Read Only Memory (ROM) 5023.
The storage unit 502 may also include a program/utility 5025 having a set (at least one) of program modules 5024, such program modules 5024 including, but not limited to: an operating system, one or more application programs, other program modules, and program data, each or some combination of which may include an implementation of a network environment.
Computing device 50 may also communicate with one or more external devices 504 (e.g., keyboard, pointing device, etc.).
Such communication may occur through an input/output (I/O) interface 505. Moreover, computing device 50 may also communicate with one or more networks such as a Local Area Network (LAN), a Wide Area Network (WAN), and/or a public network, such as the Internet, through network adapter 506. As shown in fig. 5, network adapter 506 communicates with other modules of computing device 50 over bus 503. It should be appreciated that although not shown in the figures, other hardware and/or software modules may be used in connection with computing device 50, including, but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, data backup storage systems, and the like.
Exemplary computer program product
Based on the method of any of the above embodiments, the present disclosure further provides a computer program product, where the computer program product includes a computer program, and the computer program when executed by a processor is configured to perform the method for generating an inventory flow according to any of the above embodiments.
It should be noted that although several units/modules or sub-units/modules of the inventory system are mentioned in the above detailed description, such a division is merely exemplary and not mandatory. Indeed, the features and functionality of two or more units/modules described above may be embodied in one unit/module in accordance with embodiments of the present disclosure. Conversely, the features and functions of one unit/module described above may be further divided into ones that are embodied by a plurality of units/modules.
Furthermore, although the operations of the methods of the present disclosure are depicted in the drawings in a particular order, this is not required or suggested that these operations must be performed in this particular order or that all of the illustrated operations must be performed in order to achieve desirable results. Additionally or alternatively, certain steps may be omitted, multiple steps combined into one step to perform, and/or one step decomposed into multiple steps to perform.
While the spirit and principles of the present disclosure have been described with reference to several particular embodiments, it is to be understood that this disclosure is not limited to the particular embodiments disclosed nor does it imply that features in these aspects are not to be combined to benefit from this division, which is done for convenience of description only. The disclosure is intended to cover various modifications and equivalent arrangements included within the spirit and scope of the appended claims.
Claims (10)
1. A method for generating an inventory flow, comprising:
Receiving at least one inventory change request, and generating a corresponding running water identifier for each inventory change request; the inventory change request comprises an inventory change object and inventory change data;
updating the inventory data of the inventory change object in a database based on the inventory change data and the flow identification; the data table corresponding to the inventory data is preset with a stream identification field;
acquiring at least one piece of log data generated by the database in the updating process, wherein each piece of log data comprises a running water identifier;
and correlating the inventory change requests with the same stream identification with the log data to generate at least one piece of inventory stream data.
2. The method of claim 1, wherein the log data associated with the inventory change request comprises log data obtained by merging log data having the same unique identifier and a running water identifier according to a preset rule; the preset rule is used for defining a field corresponding to the unique identifier of the log data and an aggregation mode of values of the same field when the log data are combined.
3. The method of claim 1, wherein the inventory change request further comprises an order identification; after generating the at least one inventory pipeline data, the method further comprises:
combining the inventory flow data with the same order mark according to a preset rule to generate at least one order flow data;
the preset rule is used for defining an aggregation mode of values of the same field when the inventory flow data are combined.
4. A method according to claim 2 or 3, wherein the log data further comprises time information; the polymerization mode at least comprises any one of the following steps:
when the fields represent the stock quantity, summing the values of the same fields, and taking the obtained summed value as the value of the corresponding combined field; or alternatively, the first and second heat exchangers may be,
When the fields characterize the time information, the minimum value or the maximum value in the values of the same fields is used as the value of the corresponding fields after combination.
5. An inventory system is characterized by comprising an inventory changing module and an inventory running module; the inventory change module comprises a running water identification generation sub-module and an inventory data updating sub-module, and the inventory running water module comprises a log data acquisition sub-module and an inventory running water generation sub-module;
The running water identification generation sub-module is used for receiving at least one inventory change request and generating a corresponding running water identification aiming at each inventory change request; the inventory change request comprises an inventory change object and inventory change data;
The inventory data updating sub-module is used for updating the inventory data of the inventory change object in a database based on the inventory change data and the flow identification; the data table corresponding to the inventory data is preset with a stream identification field;
The log data acquisition sub-module is used for acquiring at least one piece of log data generated by the database in the updating process, and each piece of log data comprises a running water identifier;
The inventory flow generation sub-module is used for associating the inventory change requests with the same flow identification with the log data to generate at least one piece of inventory flow data.
6. The inventory system according to claim 5, wherein the log data associated with the inventory change request includes log data obtained by merging log data having the same unique identifier and a running identifier according to a preset rule; the preset rule is used for defining a field corresponding to the unique identifier of the log data and an aggregation mode of values of the same field when the log data are combined.
7. The inventory system of claim 5, in which the inventory change request further comprises an order identification; the inventory flow module further comprises an order inventory flow generation sub-module, which is used for combining inventory flow data with the same order identification according to preset rules to generate at least one order flow data;
the preset rule is used for defining an aggregation mode of values of the same field when the inventory flow data are combined.
8. A computer readable storage medium, characterized in that a computer program is stored thereon, which computer program, when being executed by a processor, implements the method of any of claims 1-4.
9. A computing device, comprising:
A processor;
a memory for storing a processor executable program;
wherein the processor is configured to implement the method of any of claims 1-4 by running the executable program.
10. A computer program product comprising a computer program which, when executed by a processor, implements the method of any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410325255.9A CN118096036A (en) | 2024-03-20 | 2024-03-20 | Inventory flow generation method, inventory system, medium and computing device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410325255.9A CN118096036A (en) | 2024-03-20 | 2024-03-20 | Inventory flow generation method, inventory system, medium and computing device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN118096036A true CN118096036A (en) | 2024-05-28 |
Family
ID=91151622
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202410325255.9A Pending CN118096036A (en) | 2024-03-20 | 2024-03-20 | Inventory flow generation method, inventory system, medium and computing device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN118096036A (en) |
-
2024
- 2024-03-20 CN CN202410325255.9A patent/CN118096036A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11334845B2 (en) | System and method for generating notification of an order delivery | |
| US8874455B2 (en) | Convergence of customer and internal assets | |
| US20110112973A1 (en) | Automation for Governance, Risk, and Compliance Management | |
| JP2011175422A (en) | Determination program, method and device | |
| KR102602483B1 (en) | Database search system and method | |
| CN104981770A (en) | Annotations of resources | |
| US20090030880A1 (en) | Model-Based Analysis | |
| US11366821B2 (en) | Epsilon-closure for frequent pattern analysis | |
| CN112348420A (en) | Storage position information acquisition method and system, storage medium and electronic equipment | |
| CN113780913B (en) | Method and device for generating safety stock information | |
| US8321305B2 (en) | Managing assemblies with uncertain demands containing common parts | |
| US8392892B2 (en) | Method and apparatus for analyzing application | |
| CN111861004B (en) | Automatic commission prediction method, system, device and storage medium for daily income output | |
| US10810548B1 (en) | Part chain management in an aftermarket services industry | |
| CN118096036A (en) | Inventory flow generation method, inventory system, medium and computing device | |
| CN115936585A (en) | Goods inventory management method, system, equipment and storage medium | |
| US11615054B2 (en) | Merchant table and associated processes | |
| Reniers et al. | Schema design support for semi-structured data: Finding the sweet spot between NF and De-NF | |
| CN114328524A (en) | Document processing method, query method, system, equipment and medium | |
| CN112256566B (en) | Fresh-keeping method and device for test cases | |
| CN110704488B (en) | Method for managing data and corresponding system, computer device and medium | |
| CN114564501A (en) | Database data storage and query methods, devices, equipment and medium | |
| US20210233129A1 (en) | Machine learning based intelligent parts catalog | |
| CN113419752A (en) | Data processing method and device, electronic equipment and storage medium | |
| JP2018028776A (en) | Software asset management device, software asset management method, and software asset management program |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |