System and method for analyzing transportation data

• US 8,533,125 B2
• Filed: 02/28/2008
• Issued: 09/10/2013
• Est. Priority Date: 02/28/2008
• Status: Active Grant

• Current Assignee: Carrier Corporation (Carrier Global Corporation)
• Original Assignee: Carrier Corporation (Carrier Global Corporation)
• Inventors: Cherneff, Jonathan
• Primary Examiner(s): CAMPBELL, SHANNON S
• Application Number:
  US12/741,458
• Publication Number:
  US 20100223195A1
• Time in Patent Office: 2,021 Days
• Field of Search: 705/333, 705/1.1
• US Class Current: 705/333
• CPC Class Codes: G06Q 10/08 Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
• CPC Class Codes: G06Q 10/0833 Tracking
• CPC Class Codes: G06Q 10/0838 Historical data
• CPC Class Codes: G06Q 10/10 Office automation; Time management

Abstract

A system and method of analyzing transportation data includes receiving a transportation data set including transportation data corresponding to at least one item. A portion of the transportation data is converted into an event string, which includes a plurality of event symbols corresponding to a plurality of transportation events. The event string is selectively filtered according to a query to produce a filtered event string, and transportation data associated with the filtered event string may be reported.

Claims

1. A method of analyzing transportation data, comprising the steps of:

receiving, using a computer, a transportation data set including transportation data corresponding to at least one item, wherein the transportation data includes a plurality of transportation events each having a date and a time, and wherein the event symbols corresponding to each of the transportation events are placed in order of the time and the date at which each of the transportation events occurred;

converting, using the computer, a portion of the transportation data into an event string, the event string including a plurality of event symbols corresponding to a plurality of transportation events, wherein each of the plurality of event symbols corresponds to a single alphanumeric character;

selectively filtering, using the computer, the event string, according to a query, to produce a filtered event string; and

reporting the transportation data associated with the filtered event string.

2. The method of claim 1, further comprising the steps of:

obtaining environment data associated with the at least one item; and

reporting the environment data corresponding to the filtered event string of the at least one item.

3. The method of claim 1, further comprising the steps of:

assigning a location type to each of a plurality of locations present in the transportation data set; and

assigning an event symbol to at least one event at each location type,

wherein said step of assigning the event symbol includes assigning the event symbol to at least one of an arrival and a departure from the location type,

and wherein the location type includes a supplier, a distribution center, and a retail location.

5. The method of claim 1, further comprising the steps of:

adding a condition start event symbol to the event string to identify a beginning of valid data within the event string; and

adding a condition stop event symbol to the event string to identify an end of valid data within the event string.

17. The method of claim 1, wherein the filtered event string is representative of a subset of the transportation data, based on said query.

18. The method of claim 1, wherein the query is a request for a specific portion of the transportation data.

4. A method of analyzing transportation data, comprising the steps of:

receiving, using a computer, a transportation data set including transportation data corresponding to at least one item;

converting, using the computer, a portion of the transportation data into an event string, the event string including a plurality of event symbols corresponding to a plurality of transportation events, wherein each of the plurality of event symbols corresponds to a single alphanumeric character;

assigning a first default type setting to event symbols corresponding to arrivals or departures;

assigning a second type setting opposite the first type setting to event symbols corresponding to an arrival or a departure from an intermediate location within a location type;

selectively filtering, using the computer, the event string according to a query to produce a filtered event string; and

reporting the transportation data associated with the filtered event string.

6. A system for analyzing transportation data, comprising:

a transportation data set; and

a computer including a microprocessor operable to convert a portion of the transportation data set into an event string including a plurality of event symbols, to selectively filter the event string in response to a query to produce a filtered event string, and to report the transportation data corresponding to the filtered event string, wherein each of the plurality of event symbols corresponds to a single alphanumeric character, wherein the filtered event string is representative of a subset of the transportation data set, and wherein a first default type setting is assigned to event symbols corresponding to arrivals and departures, and a second type setting opposite the first type setting is assigned to event symbols corresponding to an arrival or departure from an intermediate location within a location type.

7. The system of claim 6, wherein the transportation data set corresponds to at least one transportation item, the transportation data set including transportation data.

8. The system of claim 6, wherein the transportation data set includes a date and a time for at least one of an arrival or a departure of the at least one transportation item at a plurality of locations.

9. The system of claim 7, wherein the transportation data set includes environment data, including a temperature of the at least one transportation item recorded at a predefined set of time intervals.

10. The system of claim 7, further comprising a data recordation unit associated with the at least one transportation item, wherein the data recordation unit is operable to record transportation data, wherein the data recordation unit includes a monitor operable to record environment data, and wherein the data recordation unit is attached to the at least one transportation item or its packaging.

11. The system of claim 7, wherein the at least one transportation item has an associated unique identifier corresponding to a radio frequency identification tag having a global location number.

12. The system of claim 8, wherein the microprocessor corresponds to a first microprocessor, and wherein each of the plurality of locations has a second microprocessor operable to record the arrival and the departure of the at least one transportation item to form a portion of the transportation data set.

13. The system of claim 6, wherein the query is in a regular expression language format.

14. The system of claim 6, wherein the plurality of event symbols includes a symbol for at least one of an arrival or a departure for each of a plurality of location types.

15. The system of claim 6, wherein a condition start event symbol is added to the event string to identify a beginning of valid data within the event string, and wherein a condition stop event symbol is added to the event string to identify an end of valid data within the event string.

16. The system of claim 6, wherein each event symbol in the event string is associated with an event, and wherein each event symbol is a data structure having a plurality of attributes to store transportation data.