An Embedded Database Application for the Aggregation of Farming Device Data

In order to store massive amounts of data produced by the farming devices and to keep data that spans long intervals of time for analysis, reporting and maintenance purposes; it is desirable to reduce the size of the data by maintaining the data at different aggregate levels. The older data can be made coarse-grained while keeping the newest data fine-grained. Considering the availability of a limited amount of storage capacity on the farm machinery, an application written in C was developed to collect the data from a CAN-BUS, store it into the embedded database efficiently and perform gradual data aggregation effectively. Furthermore, the aggregation is achieved by using either two ratio-based aggregation
methods or a time-granularity based aggregation method. A detailed description of the embedded database technology on a tractor computer is also presented in this paper.