[tor-bugs] #13803 [Ooni]: Better and more efficient database schema

[Tor Bug Tracker & Wiki]

#13803: Better and more efficient database schema
--------------------+-------------------------
 Reporter:  otr     |          Owner:  hellais
     Type:  defect  |         Status:  new
 Priority:  normal  |      Milestone:
Component:  Ooni    |        Version:
 Keywords:          |  Actual Points:
Parent ID:          |         Points:
--------------------+-------------------------
 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.:

 1. query for all measurements that have inconsistencies
 2. 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.

--
Ticket URL: <https://trac.torproject.org/projects/tor/ticket/13803>
Tor Bug Tracker & Wiki <https://trac.torproject.org/>
The Tor Project: anonymity online