What are the techniques and technologies that people use to store spatial data over time that performs fast when querying?
For example, you have a map where people add data at certain locations over time. How would you implement fast querying for the data available on a certain date (that date and before) or exactly on that date?
Collecting the data I understand but I don't know how to make perform well when querying? Should the raw data be post processed based on the expected queries?