Automatic error detection for inventory tracking and management systems used at a shipping container yard

• US 8,630,443 B2
• Filed: 09/01/2009
• Issued: 01/14/2014
• Est. Priority Date: 09/01/2009
• Status: Active Grant

• Current Assignee: Mi-Jack Products Incorporated (Lanco International, Inc.)
• Original Assignee: Mi-Jack Products Incorporated (Lanco International, Inc.)
• Inventors: Tan, Han-Shue, Chuang, Ke-Ren, Huang, Jihua, Warf, Gregory Keith
• Primary Examiner(s): Bitar, Nancy
• Application Number:
  US12/552,109
• Publication Number:
  US 20110052001A1
• Time in Patent Office: 1,596 Days
• Field of Search: None
• US Class Current: 382/100
• CPC Class Codes: G06Q 10/08 Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
• CPC Class Codes: G06Q 50/28 Logistics, e.g. warehousing, loading, distribution or shipping

Abstract

A method automatically detects errors in a container inventory database associated with a container inventory tracking system of a container storage facility. A processor in the inventory tracking system performs a method that: obtains a first data record, identifies an event (e.g., pickup, drop-off, or movement) associated with the first record, provides a list of error types based on the identified event, and determines whether a data error has occurred through a checking process. In each of the checking steps, the processor selects an error type from the list of error types, determines a search criterion based on the selected error type and the first data record, queries the database using the search criterion, compares query results with the first data record to detect data conflicts between them, and upon the detection of the data conflicts, reports that a data error of the selected error type has been detected.

Claims

1. A method performed by at least one processor for detecting errors in a container inventory database provided in a memory device readable by the at least one processor associated with a container inventory tracking system of a container storage facility, the method comprising:

obtaining at least one first data record, wherein the first data record is provided by at least one of the following data sources comprising;

the container inventory tracking system, an inventory management system associated with the inventory tracking mechanism, an input device for accepting entries from an operator, and a computer program configured to generate the at least one data record;

identifying an event among a pre-defined set of events based on the first data record associated with the container inventory and container handling equipment in the facility;

providing a list of error types based on the identified event; and

determining whether a data error has occurred through an error checking process, wherein for a plurality of the error types in the list the error checking process comprises;

selecting an error type from the list of error types;

determining a search criterion based on the selected error type and the first data record;

querying the container inventory database using the determined search criterion and obtaining query results from the container inventory database;

comparing the first data record together with data records in the inquiry results to detect data conflicts between the first data record and the data records in the inquiry results; and

reporting that the data error of the selected error type has been detected upon the detection of the data conflicts.

2. The method in claim 1, wherein the first data record comprises at least one of the following:

a position of handling equipment, a position of a container, and a container cell location in the container storage facility.

3. The method in claim 1, wherein

the pre-defined list of events comprises:

a container pickup event, a container drop event, and a vehicle movement event.

4. The method in claim 3, wherein,

upon identification of the vehicle movement event, the list of error types comprises a movement violation error indicating movement of the container handling equipment across locations occupied with containers according to the container inventory database,

upon identification of the container pickup event, the list of error types comprises:

no container available for pickup, inaccessible pickup location, and inaccessible operating location, and

upon identification of the container drop event, the list of error types comprises;

drop location in mid-air, occupied drop location, and inaccessible operating location.

5. The method in claim 1, upon detection of the data errors, further comprising

identifying, among the query results, data records that are affected by the data conflicts as erroneous data records, and

reporting the erroneous data records to at least one of the following:

the container inventory tracking system, the inventory management system associated with the inventory tracking system, an output device for displaying the erroneous data records to an operator, and a computer program configured to receive the erroneous data records.

6. The method in claim 5, further comprising creating tables in the container inventory database, and recording the erroneous data records to the tables.

7. The method in claim 5 further comprising modifying the erroneous data records by changing values in data fields of the erroneous data records to indicate the error.

8. The method in claim 7 further comprising recording the modified erroneous data records to the container inventory database, whereby an operator can find the erroneous data records by searching for the changed values in the data fields.

9. The method in claim 8, where in the modification further comprises:

computing a probability measure for each of the erroneous data records based on the erroneous data record, the first data record, and the identified error type, and

writing the probability measure to each of the erroneous data records,

whereby the probability measure represents a confidence level for the detected data error.

10. A container inventory tracking and error detection system, comprising:

a container inventory tracking system that tracks containers in a container storage facility, provides inventory data associated with the containers and container handling equipment, and stores the inventory data in an inventory tracking database,

an error detection module provided in a processor that obtains at least one first inventory data from the container inventory tracking system, identifies an event among a predefined set of events based on the first inventory data, provides a list of error types based on the identified event, and determines whether an error of any of the error types has occurred;

wherein the error detection module is configured to determine whether an error of any of the error types has occurred by employing an error checking process, wherein for a plurality of error types in the list the process;

selects an error type from the list of error types;

determines a search criterion based on the selected error type and the first data record;

queries the inventory tracking database using the determined search criterion and obtains query results from the inventory tracking database;

compares the first data record with data records in the query results to detect data conflicts between the first data record and the data records in the query results.

11. The container inventory tracking and error detection system of claim 10, wherein the identified event comprises at least one of a container pickup event, a container drop event, and a vehicle movement event.

12. A container inventory error detection system for detecting errors in an inventory tracking database associated with a container inventory tracking system of a container storage facility, comprising:

image generating devices that provide images of the container storage facility;

an image processing module that receives images provided by the image generating devices, recognizes containers in the images, determines locations of the recognized containers in the container storage facility based on the images, and generates inventory-validation data based on the recognized containers and their locations;

a communication network that connects the image generating devices with the image processing module for transmitting images provided by the image generating devices to the image processing module; and

an error detection module that receives the inventory-validation data, queries the inventory tracking database based on the inventory-validation data, and compares the inventory-validation data with the query results to detect errors in the inventory tracking database;

wherein the error detection module is configured to determine whether an error of any of a list of error types has occurred by employing an error checking process, wherein for a plurality of error types in the list the process;

selects an error type from the list of error types;

determines a search criterion based on the selected error type and the inventory-validation data;

queries the inventory tracking database using the determined search criterion and obtains query results from the inventory tracking database;

compares the inventory-validation data with data records in the query results to detect data conflicts between the inventory-validation data and the data records in the query results.

13. The container inventory error detection system in claim 12, wherein the image generating devices comprise at least one camera and the image generating devices are installed at fixed locations in the container storage facility.

14. The container inventory error detection system in claim 12, wherein the image generating devices are installed on handling equipment that can move around in the container storage facility.

15. The container inventory error detection system in claim 12, wherein

the image processing module further identifies attributes of the recognized containers to obtain the inventory-validation data, wherein the attributes comprise at least one of the following:

sizes, colors, types, origins, manufacturers and container IDs, and

the error detection module further compares the identified container attributes with container attributes in the query results to detect the errors.

16. The container inventory error detection system in claim 12, wherein the error detection module further creates new inventory data and modifies inventory data in the query results according to the error detection, and updates the inventory tracking database with the new inventory data and the modified inventory data.