The invention relates to the technical field of
data processing, in particular to a cloud-based
sluice monitoring and control system, which comprises a
water level state sensing module, an index structure self-adaptive module, a
node splitting threshold coefficient, a
node splitting threshold coefficient calculation module, a
node splitting threshold coefficient calculation module, a node splitting threshold coefficient calculation module and a node splitting threshold coefficient calculation module, the causal
lag calculation module generates a
water flow propagation
lag time amount by using an upstream
discharge amount and a Manning formula, and the spatial-temporal index construction module generates a logic index time key, sets a B +
tree node capacity upper limit according to a splitting coefficient, and writes data into an index structure. According to the method, fluctuation characteristics are quantized, index splitting coefficients are dynamically matched according to variances, the stability of a high-
frequency data writing structure is optimized, and a logic index time key is generated in combination with the inversion flow velocity of the upstream
discharge amount so as to correct physical
acquisition time; and the index construction efficiency and the query response speed of the
database during high
concurrency are improved on the basis of ensuring the causal alignment of the
time series data.