| Revision | Commit Message | Age | Author | Refs | ||
|---|---|---|---|---|---|---|
|
|
0818c337d503 | 5 years ago | Bart Scheers | |||
|
|
72890999e24d | 5 years ago | Bart Scheers |
Running LSST baseline queries in MonetDB
See blog post LSST Queries in MonetDB for further details.
You need to have several LSST csv files (with artificial data), which can be requested from the LSST DM team.
MonetDB
Run the installation script install_monetdb.sh, start the daemon and create a database instance.
Loading
The python load script load_lsst_data.py defines the database schema with table and partition defintions and loads the csv files into the database.
Running queries
Two shell scripts run the queries in a hot and cold mode hotloop.queries.sh and coldloop.queries.sh, resp. The averages and standard deviations of ten runs are reported in the log files
Plotting results
Use the python script plot_baselines.py to plot a bar chart of the results in comparison with the S15 MySQL results.
More info
For more info send an e-mail to bscheers at cwi.nl.