I'm working on a project which is dealing with a lot of date ranges. I'm starting completely from scratch; there is no existing code, infrastructure or database. Therefore, I'm searching for the best technology for each job.
I need to store a lot of date ranges in a database. Later on I would like to compare those data ranges to find overlaps.
I´ve already read about elasticsearch and influxdb.
Do you know any database system which is specialized to store and work with a great amount of date ranges?
The date ranges could be stored as single days or as range like from 01.01.2016 to 08.01.2016. I don't want to store any other data besides an identifier, to identify each date range record.