Database Evaluation Criteria - OpenData-tu/documentation GitHub Wiki

Authorship

Version Date Modified by Summary of changes
0.1 2017-05-25 Oliver Bruski Initial version

What are we looking for

We are looking for a reliable, scalable and fast database solution to store open data from several sources. Since we allow users to contribute their data to our platform the final load is hardly predictable. Moreover we need a database system that is able to query time series and geo data simultaneously.

Database Requirements

  1. Open source or at the very least an open license is required.
    • Active community
  2. Distributed characteristics of the system
    • Replication and redundancy
    • Good partitioning/sharding
  3. Complex queries over several sources
    • Time series queries
    • Geo queries
    • Combination of all datapoints in the database
  4. Always available
    • Fault-tolerant to machine failures
    • Replication to prevent data loss
  5. Logging, success/failure notifications