SDSS Science Archive SQL

20 astronomical queries - how to do them in SQL

The Science Archive's operational database system is Objectivity/DB. However, due to the currently not satisfactory performance (especially of indices) of Objectivity, we have set up an experimental SQL interface.

We translated the Objectivity/DB schema into an SQL schema of 25 tables. They were generated from a UML schema by an automated script, and fine-tuned by hand.

Peter Z. Kunszt, Alex S. Szalay, Ani R. Thakar, Jim Gray, Don Slutz
Last Modified: February 24, 2000.