Changes between Version 108 and Version 109 of DatabaseBasedAnalysis

Timestamp:

09/02/18 14:42:52 (7 years ago)

Author:

tbretz

Comment:

--

DatabaseBasedAnalysis

@@ -261 +261 @@
 === Data retrieval ===
 
-The events themselves are stored in a table named '''Events'''. The position of the source in camera coordinates is stored in '''Position'''. To get them, you can run the following query
+The image parameters of the events themselves are stored in a table named '''Images'''. The position of the source in camera coordinates is stored in '''Position'''. To get them, you can run the following query
 
 {{{#!sql
 SELECT
-   Events.*,
+   Images.*,
    Position.X,
    Position.Y
 FROM RunInfo
-LEFT JOIN Events   USING (FileId)
+LEFT JOIN Images   USING (FileId)
 LEFT JOIN Position USING (FileId, EvtNumber)
 WHERE 
@@ -287 +287 @@
 {{{#!sql
 SELECT
-   Events.*,
+   Images.*,
    Position.X,
    Position.Y
-LEFT JOIN Events   USING (FileId)
+LEFT JOIN Images   USING (FileId)
 LEFT JOIN Position USING (FileId, EvtNumber)
 WHERE 
@@ -427 +427 @@
 {{{#!sql
 SELECT
-   Events.*,
+   Images.*,
    Angle,
    weight,
@@ -449 +449 @@
    @ThetaSq := (@Disp*@Disp + @Dist*@Dist - 2*@Disp*@Dist*SQRT(1-@LX*@LX)) AS ThetaSq
 FROM RunInfo
-LEFT JOIN Events   USING (FileId)
+LEFT JOIN Images   USING (FileId)
 LEFT JOIN Position USING (FileId, EvtNumber)
 CROSS JOIN
@@ -549 +549 @@
             @ThetaSq := (@Disp*@Disp + @Dist*@Dist - 2*@Disp*@Dist*SQRT(1-@LX*@LX)) AS ThetaSq
         FROM RunInfo
-        LEFT JOIN Events   USING (FileId)
+        LEFT JOIN Images   USING (FileId)
         LEFT JOIN Position USING (FileId, EvtNumber)
         CROSS JOIN Wobble
@@ -712 +712 @@
                                             cosa*Y + sina*X   AS PY
                                         FROM RunInfo
-                                        LEFT JOIN Events   USING (FileId)
+                                        LEFT JOIN Images   USING (FileId)
                                         LEFT JOIN Position USING (FileId, EvtNumber)
                                         CROSS JOIN Wobble
@@ -868 +868 @@
                                             cosa*Y + sina*X   AS PY
                                         FROM RunInfo
-                                        LEFT JOIN Events   USING (FileId)
+                                        LEFT JOIN Images   USING (FileId)
                                         LEFT JOIN Position USING (FileId, EvtNumber)
                                         CROSS JOIN Wobble
@@ -1026 +1026 @@
                                         cosa*Y + sina*X   AS PY
                                     FROM RunInfo
-                                    LEFT JOIN Events   USING (FileId)
+                                    LEFT JOIN Images   USING (FileId)
                                     LEFT JOIN Position USING (FileId, EvtNumber)
                                     CROSS JOIN Wobble
@@ -1146 +1146 @@
         RunInfo
     JOIN
-        Events
+        Images
     JOIN
         Position
@@ -1156 +1156 @@
         RunInfo.fSourceKEY  = 5
     AND
-        Position.EvtNumber = Events.EvtNumber
+        Position.EvtNumber = Images.EvtNumber
     AND
-        Events.FileId = RunInfo.FileId
+        Images.FileId = RunInfo.FileId
     AND
         Position.FileId=RunInfo.FileId