Astronomical Data Query Language

Astronomical Data Query Language
Stable release
2.0 / 30 October 2008; 17 years ago (2008-10-30)
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 designed 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

Sources

  • Demleitner, Markus; Heinl, Hendrik (2019). "Gaia Data Queries with ADQL" (PDF). Archived (PDF) from the original on 29 October 2019. Retrieved 12 January 2021.
  • Gaia (2021). "An Astronomy Data Query Language cookbook to accompany Gaia Data Release 1". Archived from the original on 12 January 2021. Retrieved 12 January 2021.
  • Heinl, Hendrik; Jordan, Stefen (28 February 2017) [November 2016]. 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). Archived from the original on 3 January 2022. Retrieved 24 September 2021 – via YouTube.
  • Minin, Mikhail; Rossi, Angelo Pio (2020). "4. Synergy in Astronomy 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". www.ivoa.net. Archived from the original on 27 May 2019. Retrieved 3 January 2022.
  • Pössel, Markus (January 2020). "A Beginner's Guide to Working with Astronomical Data". The Open Journal of Astrophysics. 3 (1): 2. arXiv:1905.13189v2. Bibcode:2020OJAp....3E...2P. doi:10.21105/astro.1905.13189. S2CID 170079000.


Stub icon

This computer-programming-related article is a stub. You can help Wikipedia by adding missing information.

Stub icon

This astronomy-related article is a stub. You can help Wikipedia by adding missing information.

Content Disclaimer

Informasi ini disarikan dari Wikipedia dan disajikan kembali untuk tujuan edukasi. Konten tersedia di bawah lisensi CC BY-SA 3.0. Kami tidak bertanggung jawab atas ketidakakuratan data yang bersumber dari kontribusi publik tersebut.

  1. The information displayed on this website is sourced in part or in whole from Wikipedia and has been adapted for the purpose of restating it. We strive to provide accurate and relevant information, however:
  2. There is no guarantee of absolute accuracy. Wikipedia is an open, collaborative project that can be edited by anyone, so information is subject to change.
  3. It is not intended to constitute professional advice. The content displayed is for informational and educational purposes only. For important decisions (e.g., medical, legal, or financial), please consult a professional.
  4. Content copyright. Wikipedia is licensed under the Creative Commons Attribution-ShareAlike License (CC BY-SA). This means that content may be reused with appropriate attribution and shared under a similar license.
  5. Responsible use. Any risk arising from the use of information from this website is entirely the responsibility of the user.