File diff 000000000000 → 72890999e24d
README.rst
Show inline comments
 
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.