Data integration and arrangement in the shop floor based-on time stamp: An illustrative study of CNC machining

Abstract

According to the occurrence period of data in the shop floor, it can be classified into two types: the low-frequency data such as the measurement value and the high-frequency data such as the spindle speed. For the statistical processing or analysis required at the manufacturing site preferentially these two types of data, in which each has its own time-stamp, have to be integrated and arranged. In this paper, we introduce a simple data arrangement algorithms through the comparison of time slots between time stamped data sets that have different frequencies. In order to collect data that meets a desired cycle in the system to handle the collection and arrangement of the data at the same time it should be able to monitor the workload of the system. We show the experimental results (or workload) of proposed algorithms for the case of managing time stamped data sets on the relational database management system (RDBMS).