5  :  Demo Queries

Here we provide a large number of example SQL queries tailored to the Millennium databases. These are meant as examples for learning SQL and the database schema at the same time. The generic queries are the ones available under the demo query buttons on the main web page. As an example of what could constitute a complete SQL session we provide queries that reproduce the (content of the) figures in De Lucia & Blaizot 2006.

This area of the documentation will be under continuous construction, as we plan to add here interesting SQL solutions that allow particular questions to be answered efficiently. We invite users to submit some of these, possibly after publication of a paper.