Data Mining of the Thermal Performance of Cool-Pipes in Massive Concrete via In Situ Monitoring

Algorithm 2

Data extraction flow (HDPE pipes as examples).

(1) Select* from TbPipeInfo where Material = “HDPE”, record them as Pipes.

(2) for each Pipe in Pipes  do:

(3)     Select* from TbSensorInfo where SlabId = Pipe.SlabId, record them as Sensors.

(4)     Select* from TbCoolRecord where Id = pipe.PipeId, record them as Rows.

(5)      for each Row in Rows  do:

(6)        for each Sensor in Sensors do:

(7)            Select Temperature from TbTemRecord

                where TemTime nearest* to Row.CoolTime

                   and SensorId = Sensor.SensorId

(8)        end loop  Sensors

(9)        𝑇_𝑐 = average(sum(Temperature))

(10)         output 𝑇_𝑐,𝑇_𝑤-in,𝑇_𝑤-out, Flow

(11)      end loop  Rows

(12) end loop  Pipes

Note *: all the temperature sensors’ reading in the slab are collected. If the nearest

time difference is larger than a threshold, the data of the time will not be used.