Patent Application
20170075972
The present disclosure relates to a system and a method for generating report from one or more source systems associated with worksites.
Generally, various operations at a particular worksite are managed using source systems. Source systems include source table for storing Data corresponding to each of the operations. Reports are generated from the data stored at the source tables for analyzing various operations at the worksite. The source tables are not designed for relational reporting, hence, they are complex and hard to use. A reporting tool is used to generate reports from the source table. Conventional systems utilize specific reporting tools for each source systems. Hence, user may require knowledge for using each of the specific reporting tools. Also, the source tables are not specially designed for generating reports. Besides, the source tables include all the information about the worksite. These increase complexity of the report generation process. Moreover, the user may find difficulties for generating a consolidated report related to various operations of the worksite from different source systems, as format of data stored in each of the source systems are different. Multiple source systems have different formats for a business function, for example a machine. So the same methodology of reporting cannot be used across the multiple source systems, which in turn confuse the user and often requires different reporting tools.
US Patent Publication Number 2002/0107873 describes a system for providing centralized management and analysis of fleet information. The system includes a centralized fleet information management server accessible via a communications network to thin clients. The communications network may be Internet, and the thin clients are required to have only a web browser application to fully access functionality of the server. A portable computing device, such as a Windows CE or Palm compatible device is used with an installed application program to conduct on-site, off-line inspections. The portable device includes a local source table that is populated with fleet information downloaded from the fleet information management server. Upon completion of on-site inspection, data stored in the local source table is uploaded to the server. The server is used by thin clients to generate various reports based on the fleet data, including estimation of operating cost savings.
In one aspect of the present disclosure, a method of generating reports of one or more source systems associated with a worksite is provided. The method includes extracting information from the one or more source systems associated with the worksite. The method further includes processing the information extracted from the one or more source systems and defining a data warehouse based on the processed information related to the worksite. The method further includes generating reports of the one or more source systems associated with the worksite using a reporting tool.
In another aspect of the present disclosure, a system for generating reports associated with a worksite is provided. The system includes one or more source systems, a data processing module, a data warehouse and a reporting tool. The source systems include a source table. The data processing module includes a data capture module and a data transforming module. The data warehouse includes a fact table and a dimension table. The fact table and the dimension table are generated based on information related to the worksite. The reporting tool configured to generate reports from the data warehouse.
In yet another aspect of the present disclosure, a computer program product embodied in a computer for generating reports of one or more source systems associated with a worksite is provided. The computer program product causing the computer to perform operations includes extracting information from the one or more source systems associated with the worksite and processing the information extracted from the one or more source systems. The operations further includes defining a data warehouse based on the processed information related to the worksite and generating reports of the one or more source systems associated with the worksite using a reporting tool.
Other features and aspects of this disclosure will be apparent from the following description and the accompanying drawings.
Wherever possible, the same reference numbers will be used throughout the drawings to refer to the same or the like parts.
Each of the worksites 102 are communicated with one or more source systems 106, 108. For example, the first worksite 102-1 is communicated with a first source system 106-1 and a second source system 108-1. Similarly, the second worksite 102-2 is communicated with a first source system 106-2 and a second source system 108-2. The first source systems 106-1, 106-2 and the second source systems 108-1, 108-2 are hereinafter referred to as ‘the first source system 106, and ‘the second source system 108’, respectively. The first and second source systems 106, 108 may be worksite management systems. The first and second source systems 106, 108 may include source tables. The first and second source systems 106, 108 may collect data related to different machines 104, information related to the worksite on which the different machines operate, personnel information related to crew or designated work staff operating the different machines, or a combination thereof. Accordingly, source tables of the first and second source systems 106, 108 may include machine information, worksite information, personnel information, or a combination thereof.
Although, only the first and second source systems 106, 108 are described with reference to the worksites 102, the environment 100 may include any number of source systems, based on type of applications. For example, the environment 100 may include at least one of a terrain management system, a fleet management system, a machine detection system, an autonomous machine control system, a semi-autonomous machine control system, a reporting system associated with fleet management applications, an integrated machine control system, a machine health monitoring system, a command system, and so on. It may be understood that the first and second source systems 106, 108 disclosed herein in the context of the present disclosure may be distinct from each other with respect to architecture, data storage capabilities, type of data stored therein, data formats, and have distinct system implementation and functionality.
The first and second source systems 106, 108 may be communicated via a network 110. Examples of the network 110 may include, but are not limited to, a wide area network (WAN), a local area network (LAN), an ethernet, an internet, an intranet, a cellular network, a satellite network, or any other known network for transmitting and receiving data. In various embodiments, the network 110 may include a combination of two or more of the aforementioned networks and/or other types of networks known in the art. Further, the network 110 may be implemented as a wired network, a wireless network, or a combination thereof. Further, data transmission may take place over the network 110 with a network protocol such that the data transmission may be in an encrypted format or any other secure format, or in any of wide varieties of known manners.
In the present embodiment, the first source system 106 may embody a terrain management system. The first source system 106 may store and process data related to a terrain of the worksite 102 on which the machines operate. The first source system 106 may be configured to store and maintain surface data associated with the worksite 102. The term “surface data” used herein refers to terrain information and other parameters associated with the worksite 102. For example, the surface data may include, but not limited to, an elevation, object detection, radio network signal strength, and other geospatial aspects of the worksite 102.
In one embodiment, based on the surface data, a surface model of the worksite 102 may be generated and stored in the first source system 106, using any known technique in the art. Further, the source table of the first source system 106 may be configured to store an updated surface data, wherein the updated surface data includes a latest or updated version of the surface data associated with the worksite 102. Different levels of granularity or resolution of the surface data may also be maintained within the source table of first source system 106. The source table of first source system 106 may further store a digital map indicative of compaction of the worksite 102 as a function of history of travel of one or more machines across the worksite 102.
The second source system 108 may embody a fleet management system. The second source system 108 may be associated with information related to the machines 104 operating on the worksite 102, and may be used for asset management and for providing an interface for controlling or accessing information related to an operation of a fleet of the machines from a remote location. For example, the machines 104 are equipped with a number of sensors for detecting various machine parameters, positioning of the machine 104 on the worksite 102, and other characteristic data during working. The second source system 108 may involve gathering data regarding the fleet, managing and interpreting the data and machine maintenance, understanding how and when to maintain a machine, i.e., perform preventative maintenance, and coordinating all of the activity surrounding or going into the maintenance of the machine 104. The second source system 108 may be an open fleet management system and/or an underground fleet management system.
The second source system 108 may further store information regarding location and direction of movement of each machine in the fleet as well as status of predetermined events in which the machine is engaged. In one embodiment, the machines 104 are equipped with a plurality of sensors for detecting information regarding characteristics of the machine 104 itself, for example, speed, steering angle, orientation such as pitch and roll, geographical location, load weight, and load distribution. The second source system 108 may include various modules for monitoring, recording, conditioning, storing, indexing, processing, and/or communicating information received from the sensors associated with the machines 104.
The first and second source systems 106, 108 communicated with first and second worksites 102-1, 102-2 are exemplary and should not limit the scope of the present disclosure. The functionality of the first and second source systems 106, 108 described herein is also exemplary. The first and second source systems 106, 108 may additionally include other components and capabilities not described herein. The environment 100 may additionally include any number of source systems. Further, the architecture and capabilities of these systems may vary without any limitation.
Referring to
In an embodiment, the system 200 may be implemented as a web-based application. For example, the system 200 may be a cloud implemented platform hosted in one or more servers accessible to the users over a network 110, such as the internet. Further, the system 200 may be configured to generate an output, such as a user interface for display to the user.
The information in respect of the worksite 102 is collected and stored at the source tables correspond to the first and second source systems 106, 108. The data capture module 204 is configured to extract information from the source tables of the first and second source systems 106, 108. An exemplary source table 300 of the first source systems 106 is illustrated in
In one embodiment, the data capture module 204 extracts information relevant for generating reports. The extracted information includes production information, machine information, operator information, and machine time line data, production recording data, a set of pre-defined rules, a plurality of pre-defined parameters, and a combination thereof. The plurality of pre-defined parameters may include at least one of time data, location of the worksite 102, and materials used at the worksite 102. The machine time line data includes at least one of an activity event at the worksite 102, time delays at the worksite 102, and a combination thereof. The operator at the worksite 102 and/or a controller at the office can manually input the time line data where the machine activity is impaired from the machine operating time. It may be contemplated that the data capture module 204 may extract information from any other source systems based on the system requirements.
The information extracted by the data capture module 204 is transferred to the data transformation module 206. The data transformation module 206 formats the extracted information based on specifications of the data warehouse 208. The first and second source systems 106, 108 may be developed in different operating systems. Hence, the data stored in the first and second source systems 106, 108 may have different formats. The data transformation module 206, according to the present disclosure, is configured to determine the format of the extracted information from each of the first and second source systems 106, 108. Further, a common format of data is defined by the data transformation module 206. The format of the extracted information is converted into the common format by the data transformation module 206. A single definition table is generated using the formatted information. In addition, the data transformation module 206 is configured to customize the extracted information associated with the worksite 102 based on the data warehouse 208.
The data transformation module 206 is further configured to compute productivity metrics associated with the worksites 102 based on the machine time line data and the production recording data in the information extracted from the first and second source systems 106,108 associated with the worksites 102. In order to compute the productivity metrics, the data transformation module 206 receives the machine time line data from the worksite. Further, the production recording data from the worksite is retrieved from the first and second source systems 106, 108. The data transformation module 206 correlates the machine time line data and the production recording data to compute the productivity metrics.
The data warehouse 208 may store the data for reporting and analyzing purposes. The data warehouse 208 may contain specifically structured collection of data. The data stored in the data warehouse 208 may be subject-oriented, integrated, time-variant and non-volatile. In one embodiment, an outcome of the data processing module 206 such as the single definition table, the productivity metrics, the plurality of pre-defined parameters, and the set of pre-defined rules are stored in the data warehouse 208. The architecture of data warehouse 208 may include a fact table and a dimension table. The fact table and the dimension table are generated based on the single definition table, the productivity metrics, the plurality of pre-defined parameters, and the set of pre-defined rules. An exemplary fact table 500 in view of present disclosure is illustrated in
The system 200 includes the reporting tool 210. The reporting tool 210 is communicated to the data warehouse 208. The reporting tool 210 is configured to generate the reports based on the processed information stored in the data warehouse 208. The reporting tool 210 may be embodied as a query tool that allows a customer to query the data warehouse 208 and obtain required information therefrom.
The reporting tool 210 may include any report generating software module known in the art. The reporting tool 210 may facilitate interaction with the data warehouse 208 via a graphic user interface or any other interface known in the art that may be used to query the data warehouse 208 and obtain reports therefrom. These reports may be provided to a customer in any format, for example, spreadsheets, maps, charts, graphs, datasheet, statistic curves, data models, diagrams, tables, pictorial representations, or any other graphical or textual output generated by the reporting tool 210 that may be known in the art.
It may be contemplated that the data processing module 202, the data capture module 204 and the data transformation module 206 described herein are exemplary. The functionalities performed by each of the data processing module 202, the data capture module 204 and the data transformation module 206 may be performed in combination without any limitation. Further, additional functionalities may be performed by any of the data processing module 202; the data capture module 204 and the data transformation module 206.
It is to be understood that individual features shown or described for one embodiment of the present disclosure may be combined with individual features shown or described for another embodiment of the present disclosure. The above described implementation does not in any way limit the scope of the present disclosure. Therefore, it is to be understood that although some features are shown or described to illustrate the use of the present disclosure in the context of functional segments, such features may be omitted from the scope of the present disclosure without departing from the spirit of the present disclosure as defined in the appended claims.
The system 200 and a method 700 of the present disclosure enable generating reports of the worksites 102 with high integrity. The data warehouse 208 according to the present disclosure stores the information relevant for generating reports. This reduces the complexity associated with fetching information related to the specific user inputs. In addition, the data warehouse 208 of the system 200 for generating report is accessible to, but not limited to the third party reporting tools. Moreover, the information warehoused in the data warehouse 208 may be updated parallel with the frequent update of the first and second source systems 106, 108. The data processing module 202 of the system 200 according to present disclosure regulates the said update for keeping the data warehouse 208 consistent with the first and second source systems 106, 108. The system 200 may be embodied as a computer program product in a computer. The computer program product is enabled to generate reports of the one or more source systems 106, 108 associated with the worksite 102.
At step 704, the method 700 includes processing information from the one or more source systems 106, 108. The extracted information is processed by the data transformation module 206. The information extracted form the first and second source systems 106, 108 may posses different formats, as the first and second source systems 106,108 are developed based on different operating systems. Hence, the data transformation module 206 may define a common format for each of the extracted information based on the data warehouse 208 design specifications. Further, format of each of the extracted information may be converted into the defined common format to generate a single definition table for the worksite 102 by the data transformation module 206. In addition, the extracted information is customized based on the specifications of the data warehouse 208. The processing of information may also include computing productivity metrics associated with the worksites 102 based on the machine time line data and the production recording data in the extracted information. The computation of productivity metrics includes receiving the machine time line data from the worksite 102, retrieving the production recording data from the worksite 102 and correlating the machine time line data and the production recording data to compute the productivity metrics.
At step 706, the method 700 includes defining the data warehouse 208 based on the processed information. The processed information may include the single definition table, the productivity metrics, the plurality of pre-defined parameters, and the set of pre-defined rules. The step 706 of defining the data warehouse 208 includes the following process. Primarily, the processed information from the data processing module 202 is collected. Further, the fact table 500 and the dimension table 600 are generated based on the processed information collected from the data processing module 202. The fact table 500 and the dimension table 600 are generated based on at least one of the single definition table, the productivity metrics, and the set of pre-defined rules. Thereupon, the data warehouse 208 is defined based on the fact table 500 and the dimension table 600.
At step 708, the method 700 further includes generating reports of the first and second source systems 106, 108 associated with the worksites 102 using the reporting tool 210. The reporting tool 210 may be a third party reporting tool. In one embodiment of present invention, the user is enabled to provide specific credentials for generating the report. Based on the user specific credentials, the reporting tool 210 accesses the data warehouse 208. The reporting tool 210 is configured to fetch the information stored in the data warehouse 208 corresponding to the user specific credentials and generate reports using the fetched information. The information is stored on the source table. The reporting tool 210 queries the source table and holds a copy of information fetched from the source table in memory and displays it on a corresponding device.
While aspects of the present disclosure have been particularly shown and described with reference to the embodiments above, it will be understood by those skilled in the art that various additional embodiments may be contemplated by the modification of the disclosed machines, systems and methods without departing from the spirit and scope of what is disclosed. Such embodiments should be understood to fall within the scope of the present disclosure as determined based upon the claims and any equivalents thereof.
