Changes between Version 26 and Version 27 of DatabaseBasedAnalysis

Timestamp:

08/04/18 20:10:37 (6 years ago)

Author:

tbretz

Comment:

--

DatabaseBasedAnalysis

@@ -473 +473 @@
 {{{
 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`
+    Counter.*,
+    `Signal` - `Background`/5      AS `Excess`,
+    LiMa(`Signal`, `Background`/5) 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
-}}}
-
+    SELECT
+        @S := COUNT(IF(Weight>0, 1, NULL)) AS `Signal`,
+        @B := COUNT(IF(Weight<0, 1, NULL)) AS `Background`
+    FROM
+    (
+
+        SELECT
+            Size,
+            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
+
+) Counter
+}}}
+
+I am sure there is also a query which in addition prints the effective on-time