Files
@ 0818c337d503
Branch filter:
Location: DA/lsst_blog/README.rst - annotation
0818c337d503
1.0 KiB
text/prs.fallenstein.rst
Add blog post url
72890999e24d 72890999e24d 72890999e24d 0818c337d503 0818c337d503 0818c337d503 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d 72890999e24d | 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.
|