Research Article
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 , 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. |
|