apel/apel — pull request #24 by tofu-rocketry (2014-06-27 13:14:19+00:00)
Title: Hybrid (Normalised) Summaries

Resolves #8.

- Introduces new summary job message format (v0.3) to support normalised summaries which can be accepted at the server in parallel to old style summaries.
- Outline of flow through server database shown below (`HSS` shows link over line-wrap). All summaries go into `HybridSuperSummaries`, which includes all service level fields and all normalised fields. Views are then used to give the correct view of the data for output to portal/central server.
- Some of these views have been separated out into a `server-extra.sql` file where they are specific to the central APEL server (and are not needed by regional servers).
```
JobRecords --> [SummariseJobs] --> HSS*
Summaries --> [NormalisedSummaries] --> HSS*
NormalisedSummaries --> [CopyNormalisedSummaries] --> HSS*

*HSS --> HybridSuperSummaries -- VSuperSummaries
-- VNormalisedSummaries
-- VSumCPU
-- VUserCPU
-- VSpecIntHistory
-- VHepSpecHistory
```