Changes between Version 241 and Version 242 of DatabaseBasedAnalysis/Spectrum

Timestamp:

12/10/19 14:05:53 (5 years ago)

Author:

tbretz

Comment:

--

DatabaseBasedAnalysis/Spectrum

@@ -112 +112 @@
 
 == Get Data File List ==
+
+A list with file IDs containing the events to be analyed is required a.t.m. The following query retrieves such a list and fills a temporary table (!DataFiles) with the IDs.
 
 {{{#!Spoiler
@@ -134 +136 @@
 }}}
 
+```%0:where``` is a placeholder, for example for 
+
+{{{#!sql
+fZenithDistanceMean<30 AND fThresholdMinSet<350 AND 
+fSourceKEY=5 AND 
+fRunTypeKEY=1 AND 
+fNight>20161201 AND fNight<20170201 AND
+fR750Cor>0.9e0*fR750Ref
+}}}
+
 == Get Observation Time ==
+
+The following query bins the effective observation time of the runs listed above in zenith angle bins and stores the result in a temporary table (!ObservationTime). Note that the result contains only those bins which have entries.
 
 {{{#!Spoiler
@@ -161 +175 @@
 }}}
 
+%0:bins is a placeholder for the bin boundaries, e.g. ```5, 10, 15, 20, 25, 30``` (five bins between 5° and 30° plus underflow and overflow).
+
 == Get Monte Carlo File List ==
+
+The next query obtains all Monte Carlo runs which have their !ThetaMin or !ThetaMax within one of the bins obtained in the previous query (so all MC runs that correspond to bins in which data is available). Strictly speaking, this step is not necessary, but it accelerats further processing. In addition (here as an example) only runs with even FileIDs are obtained as test-runs (assuming that odd runs were used for training). The resulting FileIDs are stored in a temporary table (!MonteCarloFiles).
 
 {{{#!Spoiler