Changes between Version 25 and Version 26 of DatabaseBasedAnalysis

Timestamp:

08/04/18 19:47:49 (6 years ago)

Author:

tbretz

Comment:

--

DatabaseBasedAnalysis

@@ -469 +469 @@
 }}} 
 
+Combining everything into a single query is a bit tricky but works:
+
+{{{
+SELECT
+    @S    := COUNT(IF(Weight>0, 1, NULL)) AS `Signal`,
+    @B    := COUNT(IF(Weight<0, 1, NULL)) AS `Background`,
+    @E    := @S - 0.2*@B                  AS `Excess`,
+    @LiMa := LiMa(@S, @B/5, 0.2)          AS `Significance`
+FROM
+(
+
+   SELECT
+      Size,
+      Angle,
+      NumUsedPixels,
+      NumIslands,
+      Leakage1,
+      Weight,
+      PI()*Width*Length AS Area,
+      @PX      := cosa*X - sina*Y,
+      @PY      := cosa*Y + sina*X,
+      @DX      := MeanX-@PX/1.02,
+      @DY      := MeanY-@PY/1.02,
+      @Norm    := SQRT(@DX*@DX + @DY*@DY),
+      @Dist    := @Norm*0.0117193246260285378 AS Dist,
+      @LX      := TRUNCATE((CosDelta*@DY - SinDelta*@DX)/@Norm, 6),
+      @LY      := TRUNCATE((CosDelta*@DX + SinDelta*@DY)/@Norm, 6),
+      @Alpha   := ASIN(@LX) AS Alpha,
+      @Sign    := SIGN(@LY) AS Sign,
+      @M3L     := M3Long*@Sign*0.0117193246260285378,
+      @Slope   := SlopeLong*@Sign/0.0117193246260285378 AS Slope,
+      @Xi      := 1.39252 + 0.154247*@Slope + 1.67972*(1-1/(1+4.86232*Leakage1)),
+      @Sign1   := @M3L+0.07,
+      @Sign2   := (@Dist-0.5)*7.2-@Slope,
+      @Disp    := IF (SIGN(@Sign1)<0 || SIGN(@Sign2)<0, -@Xi, @Xi) * (1-Width/Length),
+      @ThetaSq := (@Disp*@Disp + @Dist*@Dist - 2*@Disp*@Dist*SQRT(1-@LX*@LX)) AS ThetaSq
+   FROM RunInfo
+   LEFT JOIN Events   USING (FileId)
+   LEFT JOIN Position USING (FileId, EvtNumber)
+   CROSS JOIN Wobble
+   WHERE
+      fSourceKey=5 
+   AND 
+      fRunTypeKey=1 
+   AND 
+      FileId BETWEEN 131101000 AND 131107000
+   AND 
+      fZenithDistanceMax<35
+   AND 
+      fR750Cor>0.9*fR750Ref
+) TableAlias
+
+WHERE
+   ThetaSq<0.156
+AND
+   Area < LOG10(Size)*898-1535
+AND
+   NumUsedPixels>5.5
+AND
+   NumIslands<3.5
+AND
+   Leakage1<0.1
+}}}
+