Running LSST baseline queries in MonetDB
========================================

See blog post 
`LSST Queries in MonetDB <https://www.monetdb.org/node/428>`_ 
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.