CN105426420B

CN105426420B - System for rapidly updating state of object in database

Info

Publication number: CN105426420B
Application number: CN201510736368.9A
Authority: CN
Inventors: 张文静
Original assignee: Beijing Jingdong Century Trading Co Ltd; Beijing Jingdong Shangke Information Technology Co Ltd
Current assignee: Beijing Jingdong Century Trading Co Ltd; Beijing Jingdong Shangke Information Technology Co Ltd
Priority date: 2015-11-03
Filing date: 2015-11-03
Publication date: 2020-03-31
Anticipated expiration: 2035-11-03
Also published as: CN105426420A

Abstract

The application discloses a system for rapidly updating the state of an object in a database. The system may include: receiving means for receiving a batch of objects and a corresponding list; a dispensing device for dispensing the objects from the receiving device into a plurality of containers, respectively, wherein the number of objects loaded into each container is less than the total number of objects in the batch; and the warehousing device is used for respectively registering the objects in the containers into the database, and is characterized in that when all the objects in one container in the containers are registered into the database, the warehousing device modifies the state of all the objects in the container in the database into usable state without waiting for all the objects in the list to be registered completely.

Description

System for rapidly updating state of object in database

Technical Field

The present disclosure relates generally to database operations and, more particularly, to a system capable of quickly updating the state of objects in a database.

Background

In e-commerce warehouse operations, a warehouse usually has many inspection receipts each day, and the inspection receipts have many different commodities. When the warehouse has the acceptance sheet that needs the acceptance, the warehouse operation personnel need put the commodity that the acceptance was accomplished to different containers when the acceptance, then put on shelf the completion back with the commodity in all containers, just can the return to the proscenium in the stock, then the proscenium just can sell, and it is long consuming time during this period. Warehousing is the key to efficient operation of the e-commerce warehouse. If there are more commodities in an acceptance bill, the acceptance time is longer, which results in slow turnover of commodity inventory. The goods which are checked and accepted firstly are stored in the warehouse, but not stored in the foreground, so that the goods cannot be sold and the customer experience is influenced, thereby bringing challenges to the checking and accepting of the warehouse.

The system returns the stock according to the mode of the purchase order at present, and the system must return the stock of the commodity to the front desk after all the commodities in the purchase order must be checked and accepted and all the commodities must be put on the shelf. Particularly, when the sales promotion is in a festival, the commodity sales are fast, and the condition that the front desk has no stock is often caused.

Disclosure of Invention

In view of the foregoing, the present disclosure provides a system that can quickly update the state of an object in a database.

According to an aspect of the present disclosure, there is provided a system for updating a state of an object in a database, comprising: receiving means for receiving a batch of objects and a corresponding list; a dispensing device for dispensing the objects from the receiving device into a plurality of containers, respectively, wherein the number of objects loaded into each container is less than the total number of objects in the batch; and the warehousing device is used for respectively registering the objects in the containers into the database, and is characterized in that when all the objects in one container in the containers are registered into the database, the warehousing device modifies the state of all the objects in the container in the database into usable state without waiting for all the objects in the list to be registered completely.

The system may further comprise verification means for verifying whether the destination of the received list is said system, wherein the receiving means does not send the received object to the racking device when the verification means determines that the destination of the list is not said system.

The receiving means may comprise reading means for reading a product code of the object. The receiving means may send the object whose product code has been read to the racking means and mark the corresponding object as received in the list. The system may further comprise an exception reporting means for reporting an exception to the outside of the system when the batch of objects has been processed but there are objects in the list that have not been marked as received, or when the receiving means reads an object that is not present in the list.

The racking device may rack the objects into different containers based on the attributes of the objects.

The sorting device may record the number of objects loaded into each container, and the warehousing device may determine whether to register all the objects in the corresponding container in the database based on the number of objects loaded into the container recorded by the sorting device. The system may further include abnormality reporting means for reporting an abnormality to the outside of the system when all the objects in the container are registered but the number of registered objects is not equal to the number of objects loaded in the container recorded by the warehousing means. Further, the system may further include an input device for receiving an input from a user, wherein the warehousing device may modify a status in the database of an object in the container that caused the report exception to be available when a confirmation of an authorized user is received through the input device.

The system can be applied to an e-commerce warehouse, and when the state of an object in the database is available, the object is displayed as being in stock in an e-commerce foreground.

According to the embodiment of the disclosure, after the objects in the container are registered, the state of the objects in the database can be modified to be usable without waiting for all the objects in the list to be registered. When the system is applied to an e-commerce warehouse, the inventory can be returned according to the containers, so that the turnover speed of the inventory can be effectively improved.

Drawings

The above and other objects, features and advantages of the present disclosure will become more apparent from the following description of embodiments of the present disclosure with reference to the accompanying drawings, in which:

fig. 1 is a perspective view schematically illustrating a system for updating a state of an object in a database according to an embodiment of the present disclosure.

Detailed Description

Hereinafter, embodiments of the present disclosure will be described with reference to the accompanying drawings. It should be understood that the description is illustrative only and is not intended to limit the scope of the present disclosure. Moreover, in the following description, descriptions of well-known structures and techniques are omitted so as to not unnecessarily obscure the concepts of the present disclosure.

The terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the disclosure. The words "a", "an" and "the" and the like as used herein are also intended to include the meanings of "a plurality" and "the" unless the context clearly dictates otherwise. Furthermore, the terms "comprises," "comprising," and the like, as used herein, specify the presence of stated features, steps, operations, and/or components, but do not preclude the presence or addition of one or more other features, steps, operations, or components.

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

In the following description, the technology of the present disclosure will be described taking a scenario of an e-commerce warehouse as an example. It should be noted, however, that the present disclosure is not limited to application to e-commerce warehouses, but may be applied to other scenarios, for example, where a batch of objects needs to be received and warehoused.

As shown in fig. 1, the system 100 according to this embodiment may include a receiving device 102, a racking device 104, and a warehousing device 106.

The receiving device 102 may be configured to receive a batch of objects and a corresponding manifest. In an e-commerce warehouse application, the objects 108 may include various goods for purchase. The same batch object 108 may be the same batch of purchased goods and the corresponding listing may be a purchase order for that batch. The purchase order may be a physical purchase order, for example, in the form of paper, or may be an electronic purchase order. For a physical purchase order, the receiving device 102 may obtain information (e.g., identification of the object 108, purchase amount, etc.) of the corresponding purchase order from the database by reading the order number of the purchase order. For an electronic purchase order, the receiving device 102 may directly obtain the relevant information therein.

In the example of fig. 1, the receiving device 102 is shown to comprise a conveyor device 1021 in the form of a conveyor belt and a door-like reading device 1023. When the purchased object 108 arrives, the object 108 may be unloaded (either automatically by a discharge tool or manually by a human operator) from a delivery tool (e.g., a truck) carrying the object 108 onto the conveyor 1021. The conveying means 1021 conveys the object 108 through the reading means 1023. The reading device 1023 can read information related to the object 108, such as a product code. The reading device 1023 may read information of the object 108 in various suitable ways. For example, the reading device 1023 may have an optical reading device (e.g., a camera) to read a bar code on the packaging of the object 108; alternatively, there may be an RFID reader to read an RFID tag attached to the object 108; and so on.

The reading device 1023 can also be used to read purchase orders. For example, the reading device 1023 can read the barcode on the purchase order using its optical reading device, and thus obtain the purchase order number. The receiving device 102 may also include a communication device (not shown). The communication device can be used for acquiring the relevant information of the corresponding purchase order from the purchase database based on the purchase order number. Alternatively, the receiving device 102 may directly receive the electronic purchase order input from the outside through the communication device.

When an object 108 is transmitted by the transmission device 1021 and passes through the reading device 1023, the related information (e.g., product code) is read by the reading device 1023; thereafter, the transfer of the object 108 to the racking device 104 may continue via the transfer device 1021. At this point, the receiving device 102 (or a control component thereof, which may be implemented in the receiving device 102 itself, or may be implemented as a control module or control function in a separate control device 110, which will be described further below) marks the object 108 as received in a manifest.

If a batch of objects is processed but there are still objects in the list that have not been marked as received, or when the receiving device reads an object that does not exist in the list, an exception may be reported to the outside of the system by an exception reporting device (which may be implemented by the control component described above, for example). For example, when a certain item or items in the inventory are missing, the warehouse administrator may be prompted to check to see if the purchase was successful or if the item was lost during the shipment, etc. When the batch of goods is mixed with other goods which are not recorded in the list, the warehouse manager can be reminded to check to confirm whether the goods are mixed into other purchase orders or whether dangerous goods exist. In particular, when an object not recorded in the list is read, the operation of the conveyor 1021 may be stopped to remove the object, thereby avoiding the delivery of an undesired object to the warehouse.

In addition, the system 100 may further comprise checking means (not shown) for checking whether the destination of the received list is the system. For example, after the list is read by the reading means 1023 and the list information is obtained based thereon, the verification means (which may be implemented by the control part described above, for example) may determine whether the destination of the list is the local warehouse. When it is determined that the destination of the manifest is not that of the system 100, the receiving device 102 may cease operation so that the received object is not sent to the racking device 104.

It should be noted here that although the receiving apparatus 102 is described above in the form of the transmitting apparatus 1021 and the reading apparatus 1023, the present disclosure is not limited thereto. The receiving device 102 may include various forms of devices or systems that accept objects from inventory. The receiving means 102 may even be partly implemented manually, which may be particularly advantageous in case, for example, the site is limited so that large machines cannot be installed. For example, a worker may hold a scanner, scan a product code on the object 108, and place the scanned object on a conveyor belt for delivery to the racking device 104; even further, the worker may directly place the scanned object into a container as described below. It should be pointed out here that this manual operation only partially replaces the machine operation and does not change the technical essence of the solution of the present disclosure.

The racking device 104 may be used to feed the objects 108 from the receiving device 102 into a plurality of containers, respectively. In the example of fig. 1, the racking device 104 is shown to include a turntable 1041 and a container 1043 disposed thereon. More specifically, in this example, two containers a and B are shown. The positions of the containers a and B on the carousel 1041 are set such that when one container is at the position of the receiving device 102, the other container is at the position of the warehousing device 106.

The turntable 1041 may rotate a container, such as a, to and thus under the conveyor 1021 for a period of time under the control of control components of the racking device 104 (which may be implemented in the racking device 104 itself, or in the control device 110 described below as a control module or control function). At this point, container a may receive the object 108 from the transmitting device 1021.

There are a number of ways to control the number of objects 108 loaded into container a. For example, the number of pieces of the object 108 dropped from the conveyor 1021 into the container a may be detected by a photodetector, or the like. When the number of objects in the container a reaches a certain number, the control means of the racking device 104 may notify the control means of the receiving device 102 (coordination between the control means may be accomplished, for example, by communication with each other, or may be centrally managed by the control 110 described below) to cause the receiving device 102 to suspend operation. Then, the carousel 1041 may be controlled to rotate the container a to a position where the object 108 contained therein may be unloaded to the warehousing device 106, and to rotate the container B to below the transport device 1021. At this point, the receiving device 102 may be notified to continue operation and thus dispense the object into container B. For the container B as well, the number of pieces of the object 108 loaded therein may be sensed, and when the number of pieces reaches a certain number, the exchange of the positions of the containers a and B is performed again by the rotation of the turntable 1041. The number of objects loaded in each container may be the same or different.

An openable/closable hatch may be included at the bottom of the receptacle 1043 (including at the corresponding position of the rotary table 1041). When the container 1043(a or B) is rotated over the warehousing device 106, the hatch may be opened and the objects 108 contained therein unloaded into the warehousing device 106. Thereafter, the hatch door can be closed in order to rotate again to receive the object at the receiving device 102.

According to an embodiment of the present disclosure, the number of objects loaded into the container 1043 at a time is less than the total number of objects in the batch. Therefore, a batch of objects can be divided into smaller batches, and thus warehousing and inventory updating operations can be performed for each smaller batch, so that the inventory updating speed can be improved.

Although the racking device 104 is described above in the form of a turntable 1041 and a container 1043, the present disclosure is not so limited. The racking device 104 may include various forms of devices or systems that sort or group objects. For example, a robotic arm may be used to dispense objects from the receiving device 102 into different containers. Even further, the staff member may directly place the objects from the receiving device 102 into the container, and lift the container to the warehousing device 106 and unload the objects in the container to the warehousing device 106 when the container is loaded with a certain number of objects. It should be pointed out here that this manual operation only partially replaces the machine operation and does not change the technical essence of the solution of the present disclosure.

Or, there may even be no physical container, but rather the objects are logically divided into different groups. When processing, such a logical group is treated as a "container", and the processing is performed similarly. In this case, the racking device 104 may be incorporated into the receiving device 102 or the warehousing device 106, for example, by grouping objects by its control means.

Advantageously, the racking device 104 may rack the objects into different containers based on the attributes of the objects. For example, objects of the same or similar attributes may be dispensed into the same container (e.g., toys into one container, food into one container, laundry into one container, etc.). Such object attributes may be recorded directly in the manifest or may be obtained from an item database based on the product code.

The warehousing device 106 may register the objects 108 in the container 1043 in the database. When all objects in a container (e.g., a or B) are registered in the database, the warehousing device 106 can modify the status of all objects in the container in the database to be available without waiting for all objects in the list to be registered. At this point, the e-commerce foreground may display the available objects as being in stock for sale.

In the example of fig. 1, the warehousing device 106 is shown as including a conveyor 1061 in the form of a conveyor belt and a portal-type reading device 1063. The container 1043 may unload the objects 108 onto the conveyor 1061. The transport device 1061 transports the object 108 through the reading device 1063. The reading device 1063 may read information related to the object 108, such as a product code. As described above for the reading device 1023, the reading device 1063 may be implemented in various ways. In a simple example, the reading means 1023 can be implemented as a means (e.g. a photosensor) that simply counts the objects passing through it.

According to an example, the warehousing device 106 (or a control component thereof, which may be implemented in the warehousing device 106 itself, or may be implemented as a control module or a control function in the control device 110 described below) may learn (through communication between each other) from the racking device 104 (specifically, a control component thereof) the number of objects that are commonly loaded in the containers that are currently unloading the objects (if the number of containers loaded each time is specified in the system as a fixed value, the number may be built in the control component of the racking device 106), and determines whether all the objects in the corresponding container have been registered in the database based on the number (for example, the number of objects read by the reading device 1063 is compared with the number) (when the two numbers of comparison are equal, it is determined that all the objects in the corresponding container are registered in the database). When all the objects in the container are registered, but the number of the registered objects is not equal to the number of the objects loaded in the container recorded by the warehousing device, an abnormality may be reported to the outside of the system by an abnormality reporting device (which may be implemented by the control means described above, for example).

Upon occurrence of an anomaly, an authorized user (e.g., a supervisor) may perform an audit and, upon satisfaction of the enterprise specification, may input (via an input device, such as implemented in the control device 110 described below) a confirmation to the warehousing device 106 so that the warehousing device 106 may modify the status in the database of the objects in the container that caused the reported anomaly to be available.

The registered objects 108 may be loaded into the container 1065 via the conveyor 1061 for storage in a warehouse.

Although the warehousing device 106 is described above as being in the form of the transport device 1061 and the reading device 1063, the present disclosure is not limited thereto. The warehousing device 106 may include various forms of warehousing entry devices or systems. The warehousing device 106 may even be partially implemented manually. For example, the staff member can directly count the number of objects in the container 1043, and when the number of objects matches, directly send the objects in the container 1043 to the warehouse, and notify the update of the database status. It should be pointed out here that this manual operation only partially replaces the machine operation and does not change the technical essence of the solution of the present disclosure.

As described above, the system 100 may also include a control device 110. The control device 110 may implement, in whole or in part, the control functions of the system 100, as described above. In the drawings, the connections between the control device 110 and other devices in the system 100, which may be wired and/or wireless, are not shown for clarity. The control apparatus 110 may be implemented as a server, a personal computer, a mobile device, or the like. The control device 110 may include an output device such as a display for outputting various information such as the related operating status of the system 100 and the above-mentioned abnormal information. The control device 110 may also include an input device such as a keyboard, touch screen, etc. A user may enter control commands into the system 100, make settings for the system 100, etc. through an input device.

According to an embodiment of the present disclosure, database state updates are performed on a container basis. The warehouse can quickly return the stock to the upstream only after goods in a single container are put on the shelf, so that the stock backlog and the rapidity of the warehouse are obviously improved, and the backlog of funds is greatly reduced.

The embodiments of the present disclosure have been described above. However, these examples are for illustrative purposes only and are not intended to limit the scope of the present disclosure. Although the embodiments are described separately above, this does not mean that the measures in the embodiments cannot be used in advantageous combination. The scope of the disclosure is defined by the appended claims and equivalents thereof. Various alternatives and modifications can be devised by those skilled in the art without departing from the scope of the present disclosure, and such alternatives and modifications are intended to be within the scope of the present disclosure.

Claims

1. A system for updating a state of an object in a database, comprising:

receiving means for receiving a batch of objects and a corresponding list, wherein the objects comprise purchased goods and the list comprises purchase orders for the purchased goods;

the subpackaging device is used for respectively feeding the goods from the receiving device into a plurality of containers, wherein the number of the goods loaded in each container is less than the total number of the batches of the goods; and

a warehousing device for respectively registering the goods in the plurality of containers into a database,

when all goods in a certain container in the plurality of containers are registered in the database, the warehousing device modifies the state of all goods in the container in the database to be available so as to update the stock of the goods without waiting for all goods in the purchase order to be registered.

2. The system of claim 1, further comprising:

checking means for checking whether the destination of the received list is the system,

wherein the receiving means does not send the received object to the racking means when the verifying means determines that the destination of the list is not said system.

3. The system of claim 1, wherein the receiving means comprises reading means for reading a product code of the object.

4. A system according to claim 3 wherein the receiving means sends objects for which the product code has been read to the dispensing means and marks the corresponding object as received in the list.

5. The system of claim 4, further comprising:

and the exception reporting device is used for reporting an exception to the outside of the system when the batch of objects are processed and objects which are not marked as received still exist in the list or when the receiving device reads the objects which do not exist in the list.

6. The system of claim 1, wherein the means for binning bins the objects into different containers based on the attributes of the objects.

7. The system of claim 1,

the dispensing apparatus records the number of objects loaded into each container, an

The warehousing device judges whether all the objects in the corresponding container are registered in the database based on the number of the objects in the loaded container recorded by the racking device.

8. The system of claim 7, further comprising:

and an abnormality reporting means for reporting an abnormality to the outside of the system when all the objects in the container have been registered but the number of the registered objects is not equal to the number of the objects loaded in the container recorded by the warehousing means.

9. The system of claim 8, further comprising:

an input device for receiving an input from a user,

wherein the warehousing means modifies a status in the database of the object in the container that caused the report exception to be available when a confirmation of the authorized user is received through the input means.

10. The system of claim 1, wherein the system is applied to an e-commerce repository, and when the status of an object in the database is available, the object is displayed as in stock at the e-commerce foreground.