Astronomical Data Query Language

{{Infobox programming language

| name = Astronomical Data Query Language

| logo =

| logo caption =

| screenshot =

| screenshot caption =

| paradigm =

| family =

| designer =

| developer =

| released =

| latest release version = 2.0

| latest release date = {{Start date and age|2008|10|30|df=yes/no}}

| latest preview version =

| latest preview date =

| typing =

| scope =

| programming language =

| discontinued =

| platform =

| operating system =

| license =

| file ext =

| file format =

| website =

| implementations =

| dialects =

| influenced by = SQL

| influenced =

}}

Astronomical Data Query Language (ADQL) is a language for astronomical data query based on SQL 92.{{Sfn|Osuna|Ortiz|2008|loc=Abstract}}

Overview

ADQL is a specialized variant of the SQL query language adapted for accessing the astronomical datasets of the virtual observatory,{{Sfn|Gaia|2021}} via the Table access protocol (TAP).{{sfn|Minin|Rossi|2020|p=39}} ADQL is designed to handle large datasets distributed over several locations,{{sfn|Demleitner|Heinl|2019|p=1}} while not retrieving data that is not needed.{{sfn|Heinl|Jordan|2017|loc=2m}}

Language

ADQL is a query language that allows data to be retrieved via a single command, the select statement, which is designed to perform as the select statement in the SQL language.{{Sfn|Gaia|2021}} ADQL has extensions designed to improve handling of astronomical data such as spherical co-ordinates that are not handled by standard SQL.{{Sfn|Gaia|2021}}

Implementations

ADQL is implemented in packages such as TOPCAT.{{sfn|Pössel|2020|p=28}}

Example

SELECT source_id, ra, dec

FROM gaiadr1.tgas_source

WHERE phot_g_mean_flux > 13

References

=Footnotes=

=Sources=

{{cite web|last1=Demleitner|first1=Markus|last2=Heinl|first2=Hendrik|date=2019|title=Gaia Data Queries with ADQL

|url=http://docs.g-vo.org/adql-gaia/html/twoup.pdf|access-date=12 January 2021|url-status=live

|archive-url=https://web.archive.org/web/20191029081405/http://docs.g-vo.org/adql-gaia/html/twoup.pdf|archive-date=29 October 2019}}

{{cite web|author=Gaia|date=2021|title=An Astronomy Data Query Language cookbook to accompany Gaia Data Release 1

|url=https://www.gaia.ac.uk/data/gaia-data-release-1/adql-cookbook|access-date=12 January 2021|url-status=live

|archive-url=https://web.archive.org/web/20210112063907/https://www.gaia.ac.uk/data/gaia-data-release-1/adql-cookbook|archive-date=12 January 2021}}

{{cite conference|last1=Heinl|first1=Hendrik|last2=Jordan|first2=Stefen|date=28 February 2017

|title=Gaia: Astronomy Data Query Language (ADQL) Introduction

|orig-date=November 2016

|conference=Gaia data workshop at ESA's European Space Astronomy Centre (ESAC)

|location=ESA's European Space Astronomy Centre (ESAC)|url=https://www.youtube.com/watch?v=jHKcGtpyeE8

|access-date=24 September 2021|url-status=live|via=YouTube

|archive-url=https://ghostarchive.org/varchive/jHKcGtpyeE8|archive-date=3 January 2022}}

{{Cite book|last1=Minin|first1=Mikhail|last2=Rossi|first2=Angelo Pio|date=2020

|title=Knowledge Discovery in Big Data from Astronomy and Earth Observation

|chapter=4. Synergy in Astronomy and Geoscience

|location=Amsterdam|publisher=Elsevier|isbn=9780128191545|oclc=1144737450}}

{{Cite web|editor1=Osuna, Pedro|editor2=Ortiz, Inaki|date=30 October 2008|title=Astronomical Data Query Language

|ref={{harvid|Osuna|Ortiz|2008}}

|url=http://www.ivoa.net/documents/ADQL/20180112/PR-ADQL-2.1-20180112.html|website=www.ivoa.net|access-date=3 January 2022|url-status=live

|archive-url=https://web.archive.org/web/20190527014101/http://www.ivoa.net/documents/ADQL/20180112/PR-ADQL-2.1-20180112.html|archive-date=27 May 2019}}

{{cite journal|last1=Pössel|first1=Markus|date=January 2020|title=A Beginner's Guide to Working with Astronomical Data|journal=The Open Journal of Astrophysics |volume=3 |issue=1 |page=2 |doi=10.21105/astro.1905.13189|arxiv=1905.13189v2 |bibcode=2020OJAp....3E...2P |s2cid=170079000 }}

Category:Query languages