This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Next revision Both sides next revision | ||
teaching:projh402 [2020/10/03 18:14] ezimanyi [VODKA Indexes for MobilityDB] |
teaching:projh402 [2020/10/03 18:14] ezimanyi [VODKA Indexes for MobilityDB] |
||
---|---|---|---|
Line 87: | Line 87: | ||
However, the drawback of keeping a single bounding box for the whole trajectory makes that the index is not very selective as shown in the following figure (extracted from a presentation by Oleg Bartunov from ProstgresPro) | However, the drawback of keeping a single bounding box for the whole trajectory makes that the index is not very selective as shown in the following figure (extracted from a presentation by Oleg Bartunov from ProstgresPro) | ||
- | {{:teaching:gist.png?1000|}} | + | {{:teaching:gist.png?400|}} |
The goal of the project is to define [[https://www.pgcon.org/2014/schedule/events/696.en.html|VODKA indexes]] that enable us to store in the index multiple bounding boxes associated to each row in the table as shown in the following figure | The goal of the project is to define [[https://www.pgcon.org/2014/schedule/events/696.en.html|VODKA indexes]] that enable us to store in the index multiple bounding boxes associated to each row in the table as shown in the following figure | ||
- | {{:teaching:vodka.png?1000|}} | + | {{:teaching:vodka.png?400|}} |