Route Characterization By MySQL

Cross Correlation of Data with different KP position or Beneath Depth Position

Sometimes could happen that along a route one has to correlate for example two different parameter defined at different location/depth.

Considering the characteristic

X

at loacation

L_j

at the depth location

Z_i

while the characteristic

Y

at the same location of L_j but at different depths

Z_k

The procedure that can be used is

1.

a JOIN producing a set of

i \times k

records with the added field storing correlation (for example each others relative depths distance)

2.

create the temporary table containing the minimum of the correlated values

3.

JOIN of the table at point 1. and 2. to extract the record with the minimum correlation values

Slope Characterization

For example using the following SQL command to classify each position it is very easly:

UPDATE DBase1 AS L1
      SET L1.`InclSet`=INTERVAL(L1.`Alpha (rad)`,-7,-2,2,7);

Frequent cross boundary condiiton (e.i. values below and above -7) could results in stretch of zero length. That could, not necessarly true, make though of high values of curvature.

-- RobertoBernetti - 09 Mar 2011