Better and more efficient database schema
The current mongo db database schema has some problems that do not allow for efficient querying in certain cases.
Curently the main two collections in the DB are "reports" and "measurements" and each measurement references the report by id.
This makes analysis on a per country basis not so easy, e.g.:
- query for all measurements that have inconsistencies
- iterate over measurements and query report_id (and probe_cc)
This results in many unecessary queries.
Ideally we would like to have a schema that allows use to one query in order to get all measurements based on report AND measurement attributes ; the result would be just a list of measurements.
Trac:
Username: otr