At present the Benchmark compares the following databases:
MongoDB CE (3.4.9)
GridDB SE (3.0.1)
AsterixDB (0.9.2)
PostgreSQL (9.6.5)
Crate DB (2.1.6)
InfluxDB (1.5.0)
SparkSQL (2.3.0)
Couchbase (5.1.0)
For each database we use different mappings to store TIPPERS data. For each such mapping we add code for schema creation, data upload and query translation.
Benchmark can be configured to compare a certain set of databases and mappings and other features such as report generation,
through a configuration file benchmark.ini situated at <$basedir/src/main/resources/
[benchmark]
scale-data = false
scale-query = false
write-query-result = true
query-timeout = 500
databases = mongodb,griddb,postgresql,cratedb,asterixdb
scripts-dir = /home/benchmark/benchmark/benchmark/scripts/
data-dir = /home/benchmark/benchmark/benchmark/data/
queries-dir = /home/benchmark/benchmark/benchmark/queries/
query-result-dir = /home/benchmark/benchmark/benchmark/results/
reports-dir = /home/benchmark/benchmark/benchmark/reports/
report-format = text
There are some third party jars that are required to be added to maven repository.
mvn install:install-file -Dfile=<$basedir/thirdparty/gridstore.jar> -DgroupId=griddb -DartifactId=org.griddb -Dversion=3.0 -Dpackaging=jar
mvn clean install
mvn exec:java
cd python
python generate.py <path to config file>
[observation]
start_timestamp = 2017-11-08 00:00:00
days = 20
step = 500
pattern = random
[sensors]
wemo = 20
wifiap = 20
temperature = 20
[others]
users = 20
data-dir = /home/benchmark/benchmark/benchmark/src/main/resources/data/
output-dir = /home/benchmark/benchmark/benchmark/data/
Benchmark also has support for the following cloud secure database systems
Jana
Pulsar
SQL Server Always Encrypted
In order to run bencmark on these systems checkout the encryption branch.
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent