Benchmarking Time Series Database Management Systems -- 2
Budget: €30 – €250 EUR
TSDBMSes: InfluxDB, Prometheus, OpenTSDB, TimescaleDB, Kdb+, FaunaDB.
Implementation Language: Native DB Query Language.
1. Choose a data set that has a large number of records (in the hundreds of thousands / millions)
2. Propose a logical scheme for data storage (Relationship entity diagram)
3. Create the physical schema for 6 management systems that reflect the logical schema.
4. Propose a set of queries / operations (from simple to complex) formally presented (usually in relational algebra): generally INSERT, SELECT, UPDATE, DELETE operations.
5. Define the scaling factor (ie the large data set is divided into subsets, usually one-eighth, one-quarter, one-half and the whole data set is used for testing)
6. Write queries in the native language of each database management system to avoid latency
7, Calculate the selectivity and complexity of SELECT requests
8. Execute each request on each subset of the dataset 10 times and keep the execution time
9. Compare the mean time and standard deviation between systems.
Implementation Language: Native DB Query Language.
1. Choose a data set that has a large number of records (in the hundreds of thousands / millions)
2. Propose a logical scheme for data storage (Relationship entity diagram)
3. Create the physical schema for 6 management systems that reflect the logical schema.
4. Propose a set of queries / operations (from simple to complex) formally presented (usually in relational algebra): generally INSERT, SELECT, UPDATE, DELETE operations.
5. Define the scaling factor (ie the large data set is divided into subsets, usually one-eighth, one-quarter, one-half and the whole data set is used for testing)
6. Write queries in the native language of each database management system to avoid latency
7, Calculate the selectivity and complexity of SELECT requests
8. Execute each request on each subset of the dataset 10 times and keep the execution time
9. Compare the mean time and standard deviation between systems.