Google set up the COVID-19 Research Explorer. Reading more than 50,000 papers about COVID-19, and allowing to ask natural language questions over that corpus.
Hi, thanks for the interest! Yes, we are planning to publish more details about the novel index structure, so feel free to visit https://blog.mireo.hr/ every 2 weeks.
Very soon we will also launch a live demo with 200,000 vehicles, so you'll be able to try SpaceTime capabilities on your own :)
Of course. MSQL queries can be as simple as "select * from st.trips", but can also include geospatial functions that we implemented and that are not part of standard SQL:
"select vid, sum(sphere_length(x[0], y[0], x[1], y[1])) as mileage
from st.segments
where
ST_Intersects(
ST_GeomFromText('POLYGON ((11955008 38520960,11995328 38530624,11998976 38531456,11955008 38520960))'),
ST_Line(x[0], y[0], x[1], y[1])
)
and t[0] >= 1569888000 and t[1] < 1572566400 and vid >= 3200 and vid <= 3300
group by vid"
Actually, a query very similar to the one listed above generates the report mileage-in-area mentioned in the blog.