SYSTEM AND METHOD FOR MANAGING DATA ASSOCIATED WITH WORKSITE

• US 20170132299A1
• Filed: 11/10/2015
• Published: 05/11/2017
• Est. Priority Date: 11/10/2015
• Status: Abandoned Application

• Current Assignee: Caterpillar Incorporated
• Original Assignee: Caterpillar Incorporated
• Inventors: Fox, Sharon L., Bennett, Kerry N., Mountford, Gordon W.
• Application Number:
  US14/936,955
• Publication Number:
  US 20170132299A1
• Time in Patent Office: Days
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

A system for managing data associated with one or more worksites is provided. The system includes one or more source systems associated with the one or more worksites for receiving the data associated with the one or more worksites. The system further includes an information accessing system in communication with the one or more source systems. The information accessing system includes a data management system, a deployment and packaging module, and a corporate warehouse. The data management system includes a data capturing module, a data virtualization module, and a data warehouse. The data virtualization module includes a data identification module, a standardization module, a transformation module, and a data consolidation module.

Claims

1. A system for managing data associated with one or more worksites, the system comprising:

one or more source systems associated with the one or more worksites for receiving the data associated with the one or more worksites; and

an information accessing system in communication with the one or more source systems, the information accessing system comprising;

a data management system, comprising;

a data capturing module configured to extract the data from the one or more source systems;

a data virtualization module, comprising;

a data identification module for identifying a format of the extracted data based on a version of the one or more source systems, a database of the one or more source systems, and a reporting tool;

a standardization module for determining a plurality of pre-defined standards associated with the extracted data;

a transformation module for transforming the identified format of the extracted data based on the plurality of pre-defined standards; and

a data consolidation module for consolidating the data transformed by the transformation module; and

a data warehouse in communication with the data virtualization module for storing the consolidated data.

2. The system of claim 1, wherein the information accessing system comprises a deployment packaging module for deploying the data management system.

3. The system of claim 2, wherein the deployment packaging module comprises:

a source system support module for providing a plurality of pre-defined supporting instructions for deployment of the data management system;

a configuration module for configuring the data management system based on the plurality of pre-defined supporting instructions;

a scheduling module for scheduling a set of pre-defined transformation logic to be executed during configuration of the data management system; and

a schema of the data management system to be deployed.

4. The system of claim 1, wherein the information accessing system comprises a corporate warehouse, and wherein the corporate warehouse is configured to:

receive the data stored at the data warehouse located at each of multiple worksites; and

generate one or more reports based on the data received from the data warehouse located at each of multiple worksites.

5. The system of claim 4, wherein the corporate warehouse comprises:

a comparison module for generating multisite comparison reports of the one or more worksites;

a report generation module for generating a report using one or more third party reporting tools; and

a storage module for storing the multisite comparison reports and the report generated using the one or more third party reporting tools.

6. The system of claim 1, wherein the information access system comprises a reporting server, and wherein the reporting server comprises the reporting tool for generating reports of the one or more worksites from the data warehouse.

7. The system of claim 1, wherein the data warehouse comprises

a fact table generated based on the consolidated data;

and

multiple dimension table, wherein at least one of the multiple dimension tables is a time usage model used for generating time reports of the one or more worksites.

8. The system of claim 1, wherein the extracted data related to the one or more worksites comprises at least one of production information, machine information, operator information, machine time line data, production recording data, a set of pre-defined rules, a plurality of pre-defined parameters, and a combination thereof.

9. A method of managing data associated with one or more worksites, the method comprising:

receiving the data associated with the one or more worksites by one or more source systems;

accessing the data received in the one or more source systems using an information accessing system;

extracting the data from the one or more source systems; and

formatting the extracted data by a data virtualization module, wherein formatting the extracted data further comprises;

identifying a format of the extracted data based on a version of the one or more source systems, a database of the one or more source systems, and a reporting tool;

determining a plurality of pre-defined standards associated with the extracted data;

transforming the identified format of the extracted data based on the plurality of pre-defined standards; and

consolidating the data transformed by the transformation module; and

storing the consolidated data in a data warehouse.

10. The method of claim 9 further comprising:

deploying a data management system by a deployment packaging module, wherein deploying the data management system further comprises;

providing a plurality of pre-defined supporting instructions for deployment of the data management system;

configuring the data management system based on the plurality of pre-defined supporting instructions; and

scheduling a set of pre-defined transformation logic to be executed during configuration of the data management system.

11. The method of claim 9, wherein accessing the data further comprises:

generating multisite comparison reports of the one or more worksites by a corporate warehouse;

generating a report using one or more third party reporting tools; and

storing the multisite comparison reports and the report generated using the one or more third party reporting tools.

12. The method of claim 9 further comprising, generating reports from the data warehouse using the reporting tool of the reporting server.

13. The method of claim 9, wherein the data warehouse comprises:

a fact table generated based on the consolidated data; and

multiple dimension table, wherein at least one of the multiple dimension tables is a time usage model used for generating time reports of the one or more worksites.

14. The method of claim 9, wherein the extracted data related to the one or more worksites comprises at least one of production information, machine information, operator information, machine time line data, production recording data, a set of pre-defined rules, a plurality of pre-defined parameters, and a combination thereof.

15. A computer program product embodied in a computer for managing data associated with one or more worksites, the computer program product causing the computer to perform operations comprising:

receiving the data associated with the one or more worksites by one or more source systems;

accessing the data received in the one or more source systems using an information accessing system;

extracting the data from the one or more source systems; and

formatting the extracted data by a data virtualization module, wherein formatting the extracted data further comprises;

identifying a format of the extracted data based on a version of the one or more source systems, a database of the one or more source systems, and a reporting tool;

determining a plurality of pre-defined standards associated with the extracted data;

transforming the identified format of the extracted data based on the plurality of pre-defined standards; and

consolidating the data transformed by the transformation module; and

storing the consolidated data in a data warehouse.

16. The computer program product of claim 15, further comprising:

deploying a data management system by a deployment packaging module, wherein deploying the data management system further comprises;

providing a plurality of pre-defined supporting instructions for deployment of the data management system;

configuring the data management system based on the plurality of pre-defined supporting instructions; and

scheduling a set of pre-defined transformation logic to be executed during configuration of the data management system.

17. The computer program product of claim 15, wherein accessing to the data further comprises:

generating multisite comparison reports of the one or more worksites by a corporate warehouse;

generating a report using one or more third party reporting tools; and

storing the multisite comparison reports and the report generated using the one or more third party reporting tools.

18. The computer program product of claim 15, further comprising:

generating reports from the data warehouse using the reporting tool of the reporting server.

19. The computer program product of claim 18, wherein the data warehouse comprises:

a fact table, wherein the fact table is generated based on the consolidated data; and

multiple dimension table, wherein at least one of the multiple dimension tables is a time usage model for generating time reports of the one or more worksite.

20. The computer program product of claim 15, wherein the extracted data related to the one or more worksites comprises at least one of production information, machine information, operator information, machine time line data, production recording data, a set of pre-defined rules, a plurality of pre-defined parameters, and a combination thereof.