git
Show by ID
Running LSST baseline queries in MonetDB
Download as zip
Revision Commit Message Age Author Refs
0818c337d503 Add blog post url 1 year and 5 months ago Bart Scheers
72890999e24d Running LSST baseline queries in MonetDB 1 year and 5 months 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.