- Databasing of all the events at the telescope -----------------------
At the moment, our event registry (internally known as "the talker"), that stores all the information produced by the observing system, is based on old-style, centralized Unix syslog. This is inconvenient because those logs are stored on a "nightly" basis, which makes it difficult to correlate events across many days, etc.
For the past few years we've duplicated this data into a SQL database, but the design for this is too straightforward, based on a direct mapping of the Unix syslog, not properly indexed, etc., which makes it slow to perform any query, due to the sheer of stored information, and difficult to look up any non-numerical information.
As a solution, a new SQL schema and driver, tailored to NOT needs, are being developed. They will be integrated with the newer centralized monitoring system as much as possible.