Changeset - 0818c337d503
[Not reviewed]
master
0 1 0
Bart Scheers - 7 years ago 2017-07-04 22:33:46
bscheers@cwi.nl
Add blog post url
1 file changed with 3 insertions and 1 deletions:
0 comments (0 inline, 0 general)
README.rst
Show inline comments
 
Running LSST baseline queries in MonetDB
 
========================================
 

	
 
See blog post ... for further details.
 
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.
 

	
0 comments (0 inline, 0 general)