This is a course on the Virtual Observatory's main query language
ADQL (short for Astronomical Data Query Language), which is a SQL
dialect standardised so users do not have to learn new languages each
time they want to use a new resource. We also introduce the basic
aspects of the Table Access Protocol TAP, which transports ADQL
queries, their results as well as the metadata necessary to write
meaningful queries.
The course comes with many exercises, most of which also have
solutions. We hope it is suitable for both self-study and as lecture
notes in teacher-led situations.
The global TAP schema collects information on
tables and columns from known TAP servers. This facilitates locating
queriable data by physics (via UCD) or keywords (via description).
Note that this shouldn't really be necessary as all information
present here should be exposed through Registry records. However,
in reality data providers currently are much more liable to give
column metadata in their tap_schema than in their Registry records.
Hence, for the time being, we maintain this service by harvesting
tap_schemas about monthly.
The global TAP schema collects information on
tables and columns from known TAP servers. This facilitates locating
queriable data by physics (via UCD) or keywords (via description).
Note that this shouldn't really be necessary as all information
present here should be exposed through Registry records. However,
in reality data providers currently are much more liable to give
column metadata in their tap_schema than in their Registry records.
Hence, for the time being, we maintain this service by harvesting
tap_schemas about monthly.