Astronomical Data Query Language
| Stable release | 2.0
/ 30 October 2008 |
|---|---|
| Influenced by | |
| SQL | |
Astronomical Data Query Language (ADQL) is a language for astronomical data query based on SQL 92.[1]
Overview
ADQL is a specialized variant of the SQL query language adapted for accessing the astronomical datasets of the virtual observatory,[2] via the Table access protocol (TAP).[3] ADQL is dedigned to handle large datasets distributed over several locations,[4] while not retrieving data that is not needed.[5]
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.[2] ADQL has extensions designed to improve handling of astronomical data such as spherical co-ordinates that are not handled by standard SQL.[2]
Implementations
ADQL is implemented in packages such as TOPCAT.[6]
Example
SELECT source_id, ra, dec FROM gaiadr1.tgas_source WHERE phot_g_mean_flux > 13
References
Footnotes
- ↑ Osuna & Ortiz 2008, Abstract.
- ↑ 2.0 2.1 2.2 Gaia 2021.
- ↑ Minin & Rossi 2020, p. 39.
- ↑ Demleitner & Heinl 2019, p. 1.
- ↑ Heinl & Jordan 2017, 2m.
- ↑ Pössel 2020, p. 28.
Sources
- Demleitner, Markus; Heinl, Hendrik (2019). "Gaia Data Queries with ADQL". http://docs.g-vo.org/adql-gaia/html/twoup.pdf.
- Gaia (2021). "An Astronomy Data Query Language cookbook to accompany Gaia Data Release 1". https://www.gaia.ac.uk/data/gaia-data-release-1/adql-cookbook.
- Heinl, Hendrik; Jordan, Stefen (28 February 2017). "Gaia: Astronomy Data Query Language (ADQL) Introduction". Gaia data workshop at ESA's European Space Astronomy Centre (ESAC). ESA's European Space Astronomy Centre (ESAC). https://www.youtube.com/watch?v=jHKcGtpyeE8. Retrieved 24 September 2021.
- Minin, Mikhail; Rossi, Angelo Pio (2020). "4. Synergy in Astonomy and Geoscience". Knowledge Discovery in Big Data from Astronomy and Earth Observation. Amsterdam: Elsevier. ISBN 9780128191545. OCLC 1144737450.
- Osuna, Pedro; Ortiz, Inaki, eds (30 October 2008). "Astronomical Data Query Language". http://www.ivoa.net/documents/ADQL/20180112/PR-ADQL-2.1-20180112.html.
- Pössel, Markus (January 2020). "A Beginner's Guide to Working with Astronomical Data". The Open Journal of Astrophysics 3 (1): 2. doi:10.21105/astro.1905.13189. Bibcode: 2020OJAp....3E...2P.
 |  |
