CN110956301B - Library position recommendation test method based on mirror image - Google Patents
Library position recommendation test method based on mirror image Download PDFInfo
- Publication number
- CN110956301B CN110956301B CN201910398626.5A CN201910398626A CN110956301B CN 110956301 B CN110956301 B CN 110956301B CN 201910398626 A CN201910398626 A CN 201910398626A CN 110956301 B CN110956301 B CN 110956301B
- Authority
- CN
- China
- Prior art keywords
- warehouse
- inventory
- compliance
- data
- result
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/04—Forecasting or optimisation specially adapted for administrative or management purposes, e.g. linear programming or "cutting stock problem"
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2358—Change logging, detection, and notification
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Economics (AREA)
- Databases & Information Systems (AREA)
- Human Resources & Organizations (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Strategic Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Development Economics (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Game Theory and Decision Science (AREA)
- Computational Linguistics (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Warehouses Or Storage Devices (AREA)
Abstract
The invention provides a library position recommendation testing method based on a mirror image, and belongs to the field of intelligent warehouse management. The invention stores the state of the warehouse at the beginning of the test by means of mirroring, and effectively tests whether the result of the recommended warehouse location module to be tested is optimal or not by matching with the request data captured during the test and the actual condition change condition of the warehouse. By using the test method, the warehouse data support is provided for each coming test flow, and the result test of the recommended library position algorithm program can be repeated. In addition, because the request of each warehouse location operation and the corresponding warehouse location operation record of each warehouse location request are recorded, the tester is allowed to evaluate the single warehouse location operation, and the warehouse situation at that time can be reproduced by backtracking with the operation records, so that the effect of increasing the using satisfaction degree of the tester is achieved.
Description
Technical Field
The invention belongs to the field of intelligent warehouse management, and particularly relates to a library position recommendation testing method based on a mirror image.
Background
In the modern freight logistics industry, informatization has become a mainstream means for improving work efficiency. The construction of the intelligent warehouse is an indispensable ring in the informatization of freight logistics. The recommended warehouse location program in the intelligent warehouse can calculate the optimal operation cargo position, the located warehouse location, the loading parking space, the optimal moving path from the warehouse location to the loading location and the like by means of AI, artificial intelligence and the like according to the freight order data, and helps a human or a robot to plan the related operation instructions in and out of the warehouse, so that the purposes of saving working time and cost, enabling the cargo in the warehouse to be placed more orderly and the like are achieved.
However, due to the fact that the conditions of the warehouse are different, and under the combined action of factors such as different weather environments, traffic conditions, rules and policies, the conditions of the goods, the warehouse locations, the paths and the warehouse doors in the warehouse are different, and therefore, in the face of different warehouses, completely different warehouse location recommendation methods are often required to be provided so as to meet the requirements of warehouse efficiency and cost. Just as such, the library position recommending system of the intelligent warehouse needs to be tested for many times before being on line, and finally, a recommended library position algorithm suitable for a specific warehouse can be found.
However, in the process of testing the library position recommendation system, a set of complete test system needs to be established to serve as a basis for judging whether the system obtains the optimal solution of the recommendation library position.
Disclosure of Invention
The invention aims to provide a library bit recommendation test method based on mirror images, which utilizes mirror images to generate two groups for comparison tests. The method can test and evaluate the performance of the new warehouse location recommendation algorithm on the premise of not interfering the normal work of the original warehouse entry and exit, and the like.
A library bit recommendation test method based on mirror images comprises the following steps:
s1, initializing, adding a library position recommending module to be detected to a warehouse management system in a plug-in mode, synchronizing warehouse data, acquiring a detected configuration file, and setting detection starting time, duration and termination time;
s2, when the time point reaches the detection starting time, creating a mirror image, generating a library position recommendation result by the library position recommendation module according to an in-out request, and detecting the compliance of the library position recommendation result to obtain a stock log comprising the compliance detection result and stock data;
and S3, calculating and storing inventory index data and total operation time cost according to the inventory log.
Further, the step S1 includes:
s11, adding a library position recommending module to be detected to a warehouse management system in a plug-in mode;
s12, synchronizing data in the warehouse with data stored in a database;
and S13, acquiring a detected configuration file, and setting detection starting time and duration.
Further, the step S2 includes:
s21, creating a mirror image when the time point reaches the detection starting time;
s22, establishing a simulation group data source according to the mirror image;
s23, judging whether the current time exceeds the test termination time or not, and if not, entering a step S24; if the current time exceeds the test termination time, the step S28 is entered;
s24, receiving a request, and judging whether the request is an in-out request; if the request is an in-out request, simultaneously entering step S25 and step S26; if the request is not an in-out request, returning to the step S23;
s25, the storage position recommending module generates a storage position recommending result according to the input warehouse entry and exit request and a simulation group data source, detects the compliance of the storage position recommending result to obtain a simulation group stock log, and enters the step S27;
the warehouse location recommendation result comprises the warehouse location of the goods in and out of the warehouse and the increase and decrease condition of the goods in each warehouse location; the simulation group inventory log comprises a compliance detection result of the inventory position recommendation result and inventory data after the inventory position recommendation result is executed;
s26, the comparison group carries out warehouse entry and exit operation according to the warehouse entry and exit request to obtain a comparison group inventory log, and the step S27 is entered;
s27, submitting the stock logs of the simulation group and the comparison group, and returning to the step S23;
and S28, ending the test.
Further, the step S21 includes:
s211, determining a database table of the mirror image;
s212, determining the table name of each created mirror image table;
s213, selecting a column of the database, selecting a filtering rule, determining the range of the selected database, and setting a database query rule;
s214, executing query operation to the database;
s215, compressing and storing the inquired data as a read-only mirror image.
Further, the step S22 includes:
and restoring the data into a table according to the stored system mirror image, and creating the table in a database to serve as a simulation group data source.
Further, the step S25 includes:
s251, the storage position recommending module generates a storage position recommending result according to the input warehouse entry and exit request and the analog group data source, wherein the storage position recommending result comprises the storage positions of warehouse entry and exit goods and the increase and decrease conditions of the goods in each storage position;
s252, judging whether the library position recommendation result meets the preset compliance requirement or not; if yes, go to step S253; if not, go to step S254;
s253, modifying the inventory data according to the inventory recommendation result to obtain a simulation group inventory log containing the inventory data and the inventory recommendation result compliance, and entering the step S27;
and S254, detecting the reason of non-compliance, reporting the result of non-compliance and the reason of non-compliance, obtaining a simulation group inventory log containing the inventory data failed to be modified and the library position recommendation result of non-compliance, and entering the step S27.
Further, the compliance requirement in the step S252 includes:
an order quantity compliance entry, a stock quantity compliance entry, an empty pallet quantity compliance entry, an attribute matching compliance entry, and a production date matching compliance entry.
Further, the step S3 includes:
s31, according to the inventory log, calculating inventory index data, wherein the index data comprises a channel arrangement order index, a dispersion index and a storage position channel utilization rate;
s32, calculating the total operation time cost of all the storage positions according to the inventory log;
and S33, storing the inventory index data and the total operation time cost.
The invention has the beneficial effects that: the invention provides a library position recommending and testing method based on a mirror image, which aims to store the state of a warehouse at the beginning of testing by means of the mirror image, and effectively test whether the result of a recommended library position module to be tested is optimal or not by matching with the request data captured during testing and the actual condition change condition of the warehouse. By using the test method, the support of warehouse data is provided for each coming test flow, and the result test of the recommended library position algorithm program can be repeated. In addition, because the request of each storage position operation and the storage position operation record corresponding to each storage position request are recorded, the testing personnel is allowed to evaluate the single storage position operation, and the warehouse condition at that time can be reproduced by backtracking with the operation record, so that the effect of increasing the using satisfaction degree of the testing personnel is achieved.
Drawings
FIG. 1 is a flow chart of an embodiment of the present invention.
Fig. 2 is a flowchart of S2 in fig. 1.
Fig. 3 is a flowchart of S21 in fig. 2.
Detailed Description
The embodiments of the present invention will be further described with reference to the accompanying drawings.
Referring to fig. 1, the present invention provides a library position recommendation testing method based on mirror images, which is implemented by the following steps:
s1, initializing, adding a library position recommending module to be detected to a warehouse management system in a plug-in mode, synchronizing warehouse data, acquiring a detected configuration file, and setting detection starting time, duration and termination time.
Referring to fig. 2, step 1 is implemented by the following sub-steps:
s11, adding the library position recommending module to be detected to the warehouse management system in a plug-in mode.
In this embodiment, the library position recommending module to be tested is added to the simulation group as a plug-in, and works in cooperation with the warehouse management system, so that the system is allowed to perform testing without interfering with normal operation of the warehouse.
And S12, synchronizing the data in the warehouse with the data stored in the database.
In this embodiment, the synchronization of the data in the warehouse including the goods, the shelves, and the inventory is completed, so that the information in the warehouse corresponds to the information stored in the database.
And S13, acquiring a detected configuration file, and setting detection starting time and duration.
In this embodiment, a configuration file related to a test is obtained, and the real time and duration of the set test are read. Using the start time and the duration, the end time can be calculated. The system then stores these three metrics as constants.
In this embodiment, the length of the set test time interval needs to be combined with the actual condition of the warehouse, and a certain period of time is searched to obtain a better setting. The purpose of setting is to enable enough warehouse in and out requests in the test time period, so that the inventory difference between the comparison group and the simulation group can be found out quickly and clearly, the shortage of warehouse position recommendation can be effectively positioned, and convenience is provided for the optimization of a subsequent recommended warehouse position module. The testing time is too long, so that the stock difference is huge, and the record of failed stock position recommendation is difficult to locate; too short a test time may result in too small inventory variation, and insufficient library position recommendation algorithm programs cannot be fully embodied.
And S2, when the time point reaches the detection starting time, creating a mirror image, generating a library position recommendation result by the library position recommendation module according to the in-out request, and detecting the compliance of the library position recommendation result to obtain a stock log comprising the compliance detection result and stock data.
Referring to fig. 2, step 2 includes the following sub-steps:
and S21, when the time point reaches the detection starting time, creating a mirror image.
Referring to fig. 3, the steps of creating the mirror image are as follows:
and S211, determining a database table of the mirror image.
In this embodiment, the database table of the mirror image is determined, and the default is the database table of the warehouse, the warehouse location, and the goods information.
S212, determining the table name of each created mirror image table.
S213, selecting the column of the database, selecting the filtering rule, determining the range of the selected database, and setting the database query rule.
And S214, executing query operation to the database.
In this embodiment, the query function of the database is used to obtain corresponding warehouse, goods, and inventory data.
S215, compressing and storing the inquired data as a read-only mirror image.
In the embodiment, the invention adopts a mirror image means to make the test more convenient and effective. And generating a data block reflecting the state of the whole warehouse by using a mirroring function.
In this embodiment, the mirroring operation is performed at the starting time point of the test, and the filtering field is usually the time point for each item, shelf, and inventory status in the warehouse, such as the number of lots, batches, numbers, categories, and other attributes of the item, the layout of the entire warehouse, the distribution of the doors and firewalls, the number of layers of the shelf where the item is located, and whether the attribute of the location of the warehouse is a flat warehouse or a stereo warehouse, and so on. And after determining the fields needing to be queried, filtering the extracted data according to the selected warehouse as a range, finally generating a query method, and performing query operation from the database. And compressing and storing the extracted and filtered data at a specified position according to the mirror image backup storage position. The result of the mirroring operation is the generation of readable data that is stored on the hard disk.
In this embodiment, after the test period has elapsed, the data required by the simulation group can still be generated again by the retained mirror image data, so as to fully utilize the reusable characteristic of the mirror image, and reuse the description about the order and the library location modification signal in the log recorded in the last test.
And S22, establishing an analog group data source according to the mirror image.
In this embodiment, data is restored to a table according to a stored system mirror image, and is created in a new database as a simulation group data source. Data required for the simulated group was generated, allowing control tests to be performed.
S23, judging whether the current time exceeds the test termination time, and if not, entering a step S24; if the current time exceeds the test termination time, the process proceeds to step S28.
S24, receiving a request, and judging whether the request is an in-out request; if the request is an in-out request, simultaneously entering step S25 and step S26; if not, the process returns to step S23.
In this embodiment, a system request is received, the request type is determined, only the warehouse entry and exit request is reserved, and other requests, such as warehouse inventory, are ignored. When the request for accessing the warehouse is received, the processes of the simulation group and the comparison group are executed simultaneously.
S25, the storage position recommending module generates a storage position recommending result according to the input warehouse entering and exiting request and the simulation group data source, detects the compliance of the storage position recommending result to obtain a simulation group inventory log, and then the step S27 is carried out. The warehouse location recommendation result comprises warehouse locations of goods in and out of the warehouse and increase and decrease conditions of the goods in each warehouse location; and simulating the compliance detection result of the library position recommendation result of the group inventory log and the inventory data after the library position recommendation result is executed.
Step S25 includes:
and S251, the storage position recommending module generates a storage position recommending result according to the input warehouse entry and exit request and the analog group data source, wherein the storage position recommending result comprises the storage positions of warehouse entry and exit goods and the increase and decrease conditions of the goods in all the storage positions.
In this embodiment, the library location recommending module obtains specified mirror image backup data according to the received warehouse entry and exit request, creates database tables of goods, shelves, inventory and the like according to the position of the simulation group required to be created in the predetermined database and the naming rule, and inserts corresponding records according to the tables. In addition, the stock log is supplemented, and the goods and stock information which are changed by the warehouse entry and warehouse moving request at each time and the compliance condition of each operation are stored. Initially the table is empty.
In this embodiment, the actual goods and quantity in or out of the warehouse are acquired, and the warehouse location recommendation module generates a warehouse location recommendation result according to the warehouse data of the simulation group, that is, the warehouse location of the goods in or out of the warehouse and the increase and decrease conditions of the goods after the goods in or out of the warehouse.
S252, judging whether the library position recommendation result meets the preset compliance requirement or not; if yes, go to step S253; if not, the process proceeds to step S254.
In this embodiment, compliance requirements include, but are not limited to:
r1: order quantity compliance entry
That is, the total quantity of each type of goods in and out of the warehouse needs to be equal to the quantity of the goods in and out of the warehouse in the order.
If the quantity of the goods A needing to be delivered from the warehouse in the order is T, the actual operation warehouses are m, and the ith warehouse is operated n i Each warehouse location, the quantity of the goods A actually delivered from the jth operation warehouse location in the warehouse i is x ij Satisfy x ij Is more than or equal to 0. If the following conditions are met:
then the compliance of the order quantity entry is deemed to be up to standard for item a of the order.
R2: inventory quantity compliance entry
That is, during the warehouse-out operation, the quantity of each type of goods warehouse-out from a certain warehouse location needs to be no more than the stock of the type of goods in the warehouse location before the warehouse location operation.
If the quantity of the goods A needing to be delivered from the warehouse in the order is T, the number of the actual operation warehouses is m, the number of the ith warehouse is n i The quantity of the goods A actually taken out from the jth operation position in the warehouse i is x ij Whereas the jth bank bit of the ith bank has stored y prior to the bank bit operation ij Quantity of cargo a. Then for any 1 ≦ i ≦ m,1 ≦ j ≦ n i If the following conditions are met:
x ij ≤y ij
the compliance of the quantity inventory item is deemed to be up to standard for cargo a of the order.
R3: empty tray number compliance entry
That is, during warehousing operation, the number of pallets occupied by all goods stored in a certain warehouse position needs to be not more than the number of empty pallets in the warehouse before warehouse position operation.
If m actual operation warehouses and n ith warehouse occupy n for a certain order i Empty bin position, and prior to bin position operation, p is common to the ith bin i And (6) an empty storage position. Then for any 1 ≦ i ≦ a, if:
the compliance of the empty pallet quantity entry is deemed to be up to standard for the order.
R4: attribute matching rule entries
That is, if the attribute standard blacklist of the goods is explicitly given in the order, the goods delivered from the warehouse cannot have the attribute in the attribute standard blacklist. For example, the order is clearly required to be not broken, the goods taken out of the warehouse need to be checked one by one, and the broken goods cannot be found. The attributes of the cargo include a quality attribute, a specification attribute, and a flow attribute, the quality attribute including whether damaged, whether spoiled, etc., the specification attribute being whether bulked or not, the flow attribute including whether returned, frozen, etc.
If the quantity of the goods A needing to be delivered from the order is T, assuming that the attribute set of the ith goods is C i And if all the i is more than or equal to 1 and less than or equal to T, the attribute set explicitly forbidden in the order is D, and the following attributes are provided:
the attribute match is deemed to be within compliance standards for the item a of the order.
R5: production date matching rule item
Namely, the production date of the goods delivered from the warehouse is the earliest production date among all the goods meeting the R4 compliance in the warehouse for operation.
Suppose the quantity of goods A needing to be delivered from the warehouse in the order is T, the ith goods is a i Set C = { a = i I is more than or equal to 1 and less than or equal to T }; before delivery, in all operation warehouses, the cargos meeting the R4 compliance requirement are U-shaped, and the jth cargo is b j Set D = { b = j J is more than or equal to 1 and less than or equal to U. Defining the function f (x) as the production date of the goods x, if x is earlier than y, representing f (x)<f (y), then b is absent j (j is more than or equal to 1 and less than or equal to U) and simultaneously satisfies the following conditions:
if the two rules above cannot be satisfied simultaneously for all j, the compliance of the production date matching is considered to be up to standard.
If all the compliance requirements are met, namely all the compliance requirements reach the standard, judging that the library position recommendation result meets the preset compliance requirement; otherwise, as long as any one of the compliance requirements is not met, the library position recommendation result is judged not to meet the compliance requirement.
And S253, modifying the inventory data according to the inventory recommendation result to obtain a simulation group inventory log containing the inventory data and the inventory recommendation result compliance, and entering the step S27.
In this embodiment, if the group inventory is in compliance, the inventory data after the warehousing operation is modified, and the modified position, number and compliance condition are recorded in the simulation group inventory log.
And S254, detecting the reason of the non-compliance, reporting the result of the non-compliance and the reason of the non-compliance, obtaining a simulation group inventory log containing the failed attempt to modify inventory data and the non-compliance of the inventory position recommendation result, and entering the step S27.
In this embodiment, if the inventory is not compliant, the results of the non-compliance and the reasons of the non-compliance are reported, and the results of the non-compliance and the error report indicating that the attempt to modify the inventory data failed are recorded in the simulation group inventory log.
In this embodiment, each time a warehouse entry and exit request is received, the warehouse location recommending module performs warehouse location recommendation once, performs detection on a recommendation result once, and records warehouse location recommendation, warehouse location modification, and record modification each time.
S26, the comparison group carries out warehouse entry and exit operation according to the warehouse entry and exit request to obtain a comparison group inventory log, and the step S27 is entered.
In this embodiment, the comparison group performs corresponding warehouse entry and exit operations according to the warehouse entry and exit request, and records the warehouse location and the change of goods to the inventory data before and after the warehouse entry and exit operations, so as to obtain the inventory log of the comparison group.
Particularly, the comparison group adopts data of warehouse entry and exit operations of workers in the warehouse.
And S27, submitting the stock logs of the simulation group and the comparison group, and returning to the step S23.
In this embodiment, the inventory logs of the two groups are submitted.
And S28, ending the test.
In this embodiment, the problem is found according to the test of one time, and the algorithm program in the library position recommending module is continuously optimized according to the result.
In the embodiment, the warehouse location operation in any warehouse-in and warehouse-out request can be taken, and each operation is evaluated; meanwhile, rollback operation can be performed on the data, and corresponding inverse operation can be performed because the change of the data before and after each operation is stored in the inventory log and the inventory data, so that problems can be better found, and the inventory recommendation module can be optimized.
And S3, calculating and storing inventory index data and total operation time cost according to the inventory log.
The step S3 comprises the following steps:
and S31, calculating inventory index data according to the inventory log, wherein the index data comprises a channel arrangement order index, a dispersion index and a storage position channel utilization rate.
In this embodiment, each set index data related to the state, such as a channel placement order index, a discrete index, a library position channel utilization rate, and the like, is calculated according to the stock states after the two groups of tests are finished.
And S32, calculating the total operation time cost of all the storage positions according to the inventory log.
In this embodiment, let the height of the ith bin be h i Actual horizontal distance x of movement of the bin to the designated door i Time t of handling goods of one pallet i Is of the formula:
t i ＝(a[h i ]+bx i +c)
wherein b and c are constants, a is according to h i Looking up the table to obtain a [ h ] i ]The value of (c).
The operation time of a certain cargo is the sum of the time of all pallets needing to be operated. The number of the trays which are required to move in the ith warehouse is y i And n is the total number of the library bits needing to be operated in the test time period, and the total T of the operation time of the secondary cargo is:
and S33, storing the inventory index data and the total operation time cost.
It will be appreciated by those of ordinary skill in the art that the examples provided herein are intended to assist the reader in understanding the principles of the invention and are to be construed as being without limitation to such specifically recited examples and embodiments. Those skilled in the art, having the benefit of this disclosure, may effect numerous modifications thereto and changes may be made without departing from the scope of the invention in its aspects.
Claims (7)
1. A library position recommendation test method based on mirror images is characterized by comprising the following steps:
s1, initializing, adding a library position recommending module to be detected to a warehouse management system in a plug-in mode, synchronizing warehouse data, acquiring a detected configuration file, and setting detection starting time, duration and termination time;
s2, when the time point reaches the detection starting time, creating a mirror image, generating a library position recommendation result by the library position recommendation module according to an in-out request, and detecting the compliance of the library position recommendation result to obtain a simulation group inventory log comprising the compliance detection result and inventory data;
the method specifically comprises the following steps:
s21, creating a mirror image when the time point reaches the detection starting time;
s22, establishing a simulation group data source according to the mirror image;
s23, judging whether the current time exceeds the test termination time or not, and if not, entering a step S24; if the current time exceeds the test termination time, the step S28 is entered;
s24, receiving a request, and judging whether the request is an in-out request; if the request is an in-out request, simultaneously entering step S25 and step S26; if not, returning to the step S23;
s25, the storage position recommending module generates a storage position recommending result according to the input warehouse entering and exiting request and a simulation group data source, detects the compliance of the storage position recommending result to obtain a simulation group inventory log, and enters the step S27;
the warehouse location recommendation result comprises warehouse locations of goods in and out of the warehouse and increase and decrease conditions of the goods in each warehouse location; the simulation group inventory log comprises a compliance detection result of the inventory position recommendation result and inventory data after the inventory position recommendation result is executed;
s26, the comparison group carries out warehouse entry and exit operation according to the warehouse entry and exit request to obtain a comparison group inventory log, and the step S27 is entered;
s27, submitting the stock logs of the simulation group and the comparison group, and returning to the step S23;
s28, ending the test;
and S3, calculating and storing inventory index data and total operation time cost according to the simulation group inventory log.
2. The mirror-based library site recommendation testing method of claim 1, wherein the step S1 comprises:
s11, adding a library position recommending module to be detected to a warehouse management system in a plug-in mode;
s12, synchronizing data in the warehouse with data stored in a database;
and S13, acquiring a detected configuration file, and setting detection starting time and duration.
3. The mirror-based library site recommendation testing method of claim 2, wherein the step S21 comprises:
s211, determining a database table of the mirror image;
s212, determining the table name of each created mirror image table;
s213, selecting a column of the database, selecting a filtering rule, determining the range of the selected database, and setting a database query rule;
s214, executing query operation to the database;
s215, compressing and storing the inquired data as a read-only mirror image.
4. The mirror-based library site recommendation testing method of claim 3, wherein the step S22 comprises:
and restoring the data into a table according to the stored read-only mirror image, and creating the table in a database to serve as a simulation group data source.
5. The mirror-based library bit recommendation test method of claim 4, wherein the step S25 comprises:
s251, the storage position recommending module generates a storage position recommending result according to the input warehouse entry and exit request and the analog group data source, wherein the storage position recommending result comprises the storage positions of warehouse entry and exit goods and the increase and decrease conditions of the goods in all the storage positions;
s252, judging whether the library position recommendation result meets the preset compliance requirement or not; if yes, go to step S253; if not, go to step S254;
s253, modifying the inventory data according to the inventory recommendation result to obtain a simulation group inventory log containing the inventory data and the inventory recommendation result compliance, and entering the step S27;
and S254, detecting the reason of non-compliance, reporting the result of non-compliance and the reason of non-compliance, obtaining a simulation group inventory log containing the inventory data failed to be modified and the library position recommendation result of non-compliance, and entering the step S27.
6. The mirror-based library bit recommendation testing method of claim 5, wherein the compliance requirement in step S252 comprises:
an order quantity compliance entry, a stock quantity compliance entry, an empty pallet quantity compliance entry, an attribute match compliance entry, and a production date match compliance entry.
7. The mirror-based library site recommendation testing method of claim 1, wherein the step S3 comprises:
s31, calculating inventory index data according to the simulation group inventory log, wherein the inventory index data comprises a channel arrangement order index, a dispersion index and a storage position channel utilization rate;
s32, calculating the total operation time cost of all the storage positions according to the simulation group inventory log;
and S33, storing the inventory index data and the total operation time cost.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910398626.5A CN110956301B (en) | 2019-05-14 | 2019-05-14 | Library position recommendation test method based on mirror image |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910398626.5A CN110956301B (en) | 2019-05-14 | 2019-05-14 | Library position recommendation test method based on mirror image |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110956301A CN110956301A (en) | 2020-04-03 |
| CN110956301B true CN110956301B (en) | 2023-04-07 |
Family
ID=69976176
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910398626.5A Active CN110956301B (en) | 2019-05-14 | 2019-05-14 | Library position recommendation test method based on mirror image |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110956301B (en) |
Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CA2389512A1 (en) * | 1999-11-03 | 2001-05-10 | Accenture Llp | Data warehouse computing system |
| CN103942663A (en) * | 2013-01-18 | 2014-07-23 | 纽海信息技术（上海）有限公司 | Material management method and system |
| CN105339970A (en) * | 2013-02-06 | 2016-02-17 | 电子商品交易合伙人有限公司 | Methods for recommending jewelry items |
| JP2016052938A (en) * | 2014-09-04 | 2016-04-14 | 国立大学法人秋田大学 | Warehouse work support device and warehouse work support program |
| CN105528912A (en) * | 2016-01-20 | 2016-04-27 | 中山大学 | Indoor parking stall recommendation method and system |
| CN106250427A (en) * | 2016-07-25 | 2016-12-21 | 浪潮(北京)电子信息产业有限公司 | A kind of generation method and system of container image recommendation information |
| CN107145432A (en) * | 2017-03-30 | 2017-09-08 | 华为技术有限公司 | A kind of method and client for setting up model database |
| CN107194638A (en) * | 2017-04-21 | 2017-09-22 | 仓智（上海）智能科技有限公司 | A kind of storehouse management optimization method |
| CN107562818A (en) * | 2017-08-16 | 2018-01-09 | 中国工商银行股份有限公司 | Information recommendation system and method |
| CN108341204A (en) * | 2018-01-08 | 2018-07-31 | 北京邮电大学 | A kind of intelligent robot cargo that serving storehouse management goes out to be put in storage method and system |
| CN108846600A (en) * | 2018-03-29 | 2018-11-20 | 宏图物流股份有限公司 | A kind of method and device of storehouse management |
| CN109003012A (en) * | 2017-06-06 | 2018-12-14 | 菜鸟智能物流控股有限公司 | Goods location recommendation link information acquisition method, goods location recommendation method, device and system |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9934484B2 (en) * | 2013-08-09 | 2018-04-03 | Ebay Inc. | Global back-end taxonomy for commerce environments |
| US10366174B2 (en) * | 2014-03-13 | 2019-07-30 | Ebay Inc. | Social fitting room experience utilizing interactive mirror and polling of target users experienced with garment type |
| US10314052B2 (en) * | 2017-07-12 | 2019-06-04 | Airmagnet, Inc. | System and method for recommending a channel for wireless communication |
-
2019
- 2019-05-14 CN CN201910398626.5A patent/CN110956301B/en active Active
Patent Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CA2389512A1 (en) * | 1999-11-03 | 2001-05-10 | Accenture Llp | Data warehouse computing system |
| CN103942663A (en) * | 2013-01-18 | 2014-07-23 | 纽海信息技术（上海）有限公司 | Material management method and system |
| CN105339970A (en) * | 2013-02-06 | 2016-02-17 | 电子商品交易合伙人有限公司 | Methods for recommending jewelry items |
| JP2016052938A (en) * | 2014-09-04 | 2016-04-14 | 国立大学法人秋田大学 | Warehouse work support device and warehouse work support program |
| CN105528912A (en) * | 2016-01-20 | 2016-04-27 | 中山大学 | Indoor parking stall recommendation method and system |
| CN106250427A (en) * | 2016-07-25 | 2016-12-21 | 浪潮(北京)电子信息产业有限公司 | A kind of generation method and system of container image recommendation information |
| CN107145432A (en) * | 2017-03-30 | 2017-09-08 | 华为技术有限公司 | A kind of method and client for setting up model database |
| CN107194638A (en) * | 2017-04-21 | 2017-09-22 | 仓智（上海）智能科技有限公司 | A kind of storehouse management optimization method |
| CN109003012A (en) * | 2017-06-06 | 2018-12-14 | 菜鸟智能物流控股有限公司 | Goods location recommendation link information acquisition method, goods location recommendation method, device and system |
| CN107562818A (en) * | 2017-08-16 | 2018-01-09 | 中国工商银行股份有限公司 | Information recommendation system and method |
| CN108341204A (en) * | 2018-01-08 | 2018-07-31 | 北京邮电大学 | A kind of intelligent robot cargo that serving storehouse management goes out to be put in storage method and system |
| CN108846600A (en) * | 2018-03-29 | 2018-11-20 | 宏图物流股份有限公司 | A kind of method and device of storehouse management |
Non-Patent Citations (2)
| Title |
|---|
| 曹天泽.基于代码仓库分析的代码推荐研究.湖南大学.2016,全文. * |
| 谢铭 ; 林兴志 ; 黄悦 ; 魏鹰 ; .制造企业协同物流系统本体建模与推荐.企业科技与发展.2010,(10),全文. * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110956301A (en) | 2020-04-03 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN1192321C (en) | Accessing a hierarchical data store through an SQL input | |
| CN106294772B (en) | The buffer memory management method of distributed memory columnar database | |
| US20130197975A1 (en) | Household level segmentation method and system | |
| US7558786B2 (en) | Method for storing text annotations with associated type information in a structured data store | |
| US8799293B2 (en) | System and method for efficient storage destination determination in a storage facility | |
| Bevilacqua et al. | Lean principles for organizing items in an automated storage and retrieval system: an association rule mining–based approach | |
| CN107967361B (en) | A kind of incremental processing method and system of database | |
| CN108280137B (en) | Task-based pipe network data editing method and device | |
| US7113951B2 (en) | Method and system for detecting tables to be modified | |
| CN112860769B (en) | Energy planning data management system | |
| CN109800278A (en) | Data assets map application method, device, computer equipment and storage medium | |
| CN111124917A (en) | Public test case management and control method, device, equipment and storage medium | |
| CN110442852B (en) | Target cost compiling method, storage medium and intelligent terminal thereof | |
| EP2541437A1 (en) | Data base indexing | |
| CN113343593A (en) | Home decoration wiring planning management method, system and storage medium based on neural network | |
| CN112882956B (en) | Method and device for automatically generating full-scene automatic test cases through data combination calculation, storage medium and electronic equipment | |
| CN109409780B (en) | Change processing method, device, computer equipment and storage medium | |
| CN110956301B (en) | Library position recommendation test method based on mirror image | |
| CN101013426A (en) | Information management system using connection relation | |
| CN106779245B (en) | Event-based civil aviation demand prediction method and device | |
| CN114817589B (en) | Intelligent verification method, system and device for fire-fighting building drawings and storage medium | |
| CN113127563B (en) | Intelligent retail management method and system based on block chain | |
| CN101794150A (en) | Data management method and system of fieldbus instrument management system | |
| CN114564501A (en) | Database data storage and query methods, devices, equipment and medium | |
| CN103593525A (en) | Secondary processing method and device of DFM analysis report |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |