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.
A tutorial on SQL and the Millennium database in the form of a Microsoft power-point presentation is available from
this link.
|