System and method for analyzing raw data files

• US 20060271582A1
• Filed: 05/25/2005
• Published: 11/30/2006
• Est. Priority Date: 05/25/2005
• Status: Abandoned Application

• Current Assignee: Caterpillar Incorporated
• Original Assignee: Caterpillar Incorporated
• Inventors: Collins, Darryl Victor
• Application Number:
  US11/136,444
• Publication Number:
  US 20060271582A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2455 Query execution

Abstract

A method and system are disclosed for generating and displaying a custom report based on raw data files received from work machines in a construction site. The method includes receiving raw data files and queries from a user. The query may be parsed into components. A heuristic may be applied to the parsed components to generate a filter. The filter may operate on the data in the raw data files to generate the custom report and the custom report may be displayed to the user.

Claims

1. A method for generating and displaying a custom report based on raw data files, the method comprising:

receiving raw data files;

receiving a query from a user;

parsing the query into components;

applying a heuristic to the parsed components to generate a filter;

using the filter to generate the custom report based on data in the raw data files; and

displaying the custom report to the user.

2. The method of claim 1, wherein the raw data files originate from geographically dispersed sources.

3. The method of claim 1, wherein the components of the query include a verb component and an object component.

4. The method of claim 3, wherein the object component is a graphically defined polygon on a map defining a location of interest to the user.

5. The method of claim 1, wherein parsing the query into components is performed with an XML parser.

6. The method of claim 1, wherein displaying the custom report to the user includes displaying at least one of tabular views of data and chart views of data.

7. The method of claim 1, further including interpolating data in the raw data files based on external reference data, wherein the external reference data includes time-stamped data from a global location system.

8. The method of claim 1, wherein the filter includes at least one of a proximity in space filter and a proximity in time filter.

9. The method of claim 1, wherein the raw data files originate from a work machine and include measurements describing a state of the work machine.

10. A console for generating and displaying a custom report based on raw data files, the console being adapted to:

receive raw data files;

receive a query from a user;

parse the query into components;

apply a heuristic to the parsed components to generate a filter;

use the filter to generate the custom report based on data in the raw data files; and

display the custom report to the user.

11. The console of claim 10, wherein the raw data files originate from geographically dispersed sources.

12. The console of claim 10, wherein the components of the query include a verb component and an object component.

13. The console of claim 12, wherein the object component defines a location of interest to the user.

14. The console of claim 10, wherein displaying the custom report to the user includes displaying at least one of tabular views of data and chart views of data.

15. The console of claim 10, further being adapted to interpolate data in the raw data files based on time-stamped data from a global location system.

16. The console of claim 10, wherein the filter includes at least one of a proximity in space filter and a proximity in time filter.

17. The console of claim 10, wherein the raw data files originate from a work machine and include measurements describing a state of the work machine.

18. A system for generating and displaying a custom report based on raw data files, the system comprising:

at least one work machine including;

one or more sensors for gathering measurements describing a state of the at least one work machine;

a processor for compiling the measurements in a raw data file; and

a console adapted to;

receive raw data files from the at least one work machine;

receive a query from a user;

parse the query into components;

apply a heuristic to the parsed components to generate a filter;

use the filter to generate the custom report based on data in the raw data files; and

display the custom report to the user.