Changes between Version 240 and Version 241 of DatabaseBasedAnalysis/Spectrum

Timestamp:

12/09/19 18:44:21 (5 years ago)

Author:

tbretz

Comment:

--

DatabaseBasedAnalysis/Spectrum

@@ -245 +245 @@
 == Summarize Corsika Production ==
 
+{{{#!Spoiler
+{{{#!sql
+CREATE TEMPORARY TABLE SimulatedSpectrum
+(
+   `.energy` SMALLINT UNSIGNED NOT NULL COMMENT 'Bin Index [MC Energy]',
+   CountN    DOUBLE            NOT NULL,
+   CountW    DOUBLE            NOT NULL,
+   CountW2   DOUBLE            NOT NULL,
+   PRIMARY KEY (`.energy`) USING HASH
+) ENGINE=Memory
+AS
+(
+   SELECT
+      INTERVAL(LOG10(Energy), %0:energyest) AS `.energy`,
+      COUNT(*) AS CountN,
+      SUM(    (%2:spectrum)/pow(Energy, SpectralIndex)   ) AS CountW,
+      SUM(POW((%2:spectrum)/pow(Energy, SpectralIndex),2)) AS CountW2
+   FROM
+      MonteCarloFiles
+   LEFT JOIN
+      factmc.RunInfoMC USING (FileId)
+   LEFT JOIN
+      factmc.OriginalMC USING (FileId)
+   GROUP BY
+      `.energy`
+   ORDER BY
+      `.energy`
+)
+}}}
+}}}
+
+
 == Result (Spectrum) ==