|
new file 100644
|
|
|
Running LSST baseline queries in MonetDB
|
|
|
========================================
|
|
|
|
|
|
See blog post ... 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.
|
|
|
|