Astronomical Data Query Language Explained
Astronomical Data Query Language |
Paradigms: | --> |
Designers: | --> |
Developers: | --> |
Latest Release Version: | 2.0 |
File Formats: | --> |
Influenced By: | SQL |
Astronomical Data Query Language (ADQL) is a language for astronomical data query based on SQL 92.
Overview
ADQL is a specialized variant of the SQL query language adapted for accessing the astronomical datasets of the virtual observatory, via the Table access protocol (TAP). ADQL is designed to handle large datasets distributed over several locations, while not retrieving data that is not needed.
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. ADQL has extensions designed to improve handling of astronomical data such as spherical co-ordinates that are not handled by standard SQL.
Implementations
ADQL is implemented in packages such as TOPCAT.
Example
SELECT source_id, ra, decFROM gaiadr1.tgas_sourceWHERE phot_g_mean_flux > 13
References
Sources
- Web site: Demleitner. Markus. Heinl. Hendrik. 2019. Gaia Data Queries with ADQL . 12 January 2021. live . https://web.archive.org/web/20191029081405/http://docs.g-vo.org/adql-gaia/html/twoup.pdf. 29 October 2019.
- Web site: Gaia. 2021. An Astronomy Data Query Language cookbook to accompany Gaia Data Release 1 . 12 January 2021. live . https://web.archive.org/web/20210112063907/https://www.gaia.ac.uk/data/gaia-data-release-1/adql-cookbook. 12 January 2021.
- Heinl. Hendrik. Jordan. Stefen. 28 February 2017 . Gaia: Astronomy Data Query Language (ADQL) Introduction . November 2016 . Gaia data workshop at ESA's European Space Astronomy Centre (ESAC) . ESA's European Space Astronomy Centre (ESAC). 24 September 2021. live. YouTube . https://ghostarchive.org/varchive/jHKcGtpyeE8. 3 January 2022.
- Book: Minin. Mikhail. Rossi. Angelo Pio. 2020 . Knowledge Discovery in Big Data from Astronomy and Earth Observation . 4. Synergy in Astonomy and Geoscience . Amsterdam. Elsevier. 9780128191545. 1144737450.
- Web site: Osuna, Pedro. Ortiz, Inaki. 30 October 2008. Astronomical Data Query Language . . www.ivoa.net. 3 January 2022. live . https://web.archive.org/web/20190527014101/http://www.ivoa.net/documents/ADQL/20180112/PR-ADQL-2.1-20180112.html. 27 May 2019.
- Pössel. Markus. January 2020. A Beginner's Guide to Working with Astronomical Data. The Open Journal of Astrophysics . 3 . 1 . 2 . 10.21105/astro.1905.13189. 1905.13189v2 . 2020OJAp....3E...2P . 170079000 .