Astronomical Data Query Language

Last updated

Astronomical Data Query Language
Stable release
2.0 / 30 October 2008;15 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]

Contents

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

SELECTsource_id,ra,decFROMgaiadr1.tgas_sourceWHEREphot_g_mean_flux>13

Related Research Articles

<i>Gaia</i> (spacecraft) European optical space observatory for astrometry

Gaia is a space observatory of the European Space Agency (ESA), launched in 2013 and expected to operate until 2025. The spacecraft is designed for astrometry: measuring the positions, distances and motions of stars with unprecedented precision, and the positions of exoplanets by measuring attributes about the stars they orbit such as their apparent magnitude and color. The mission aims to construct by far the largest and most precise 3D space catalog ever made, totalling approximately 1 billion astronomical objects, mainly stars, but also planets, comets, asteroids and quasars, among others.

SPARQL is an RDF query language—that is, a semantic query language for databases—able to retrieve and manipulate data stored in Resource Description Framework (RDF) format. It was made a standard by the RDF Data Access Working Group (DAWG) of the World Wide Web Consortium, and is recognized as one of the key technologies of the semantic web. On 15 January 2008, SPARQL 1.0 was acknowledged by W3C as an official recommendation, and SPARQL 1.1 in March, 2013.

<span class="mw-page-title-main">Max Planck Institute for Astronomy</span> Research institute of the Max Planck Society, Germany

The Max-Planck-Institut für Astronomie is a research institute of the Max Planck Society (MPG). It is located in Heidelberg, Baden-Württemberg, Germany near the top of the Königstuhl, adjacent to the historic Landessternwarte Heidelberg-Königstuhl astronomical observatory. The institute primarily conducts basic research in the natural sciences in the field of astronomy.

<span class="mw-page-title-main">21 Aquilae</span> Star in the constellation Aquila

21 Aquilae is a solitary variable star in the equatorial constellation of Aquila. It has the variable star designation V1288 Aql; 21 Aquilae is its Flamsteed designation. This object is visible to the naked eye as a dim, blue-white hued star with a baseline apparent visual magnitude of about 5.1. The star is located at a distance of around 680 light-years from Earth, give or take a 20 light-year margin of error. It is moving closer to the Earth with a heliocentric radial velocity of –5 km/s.

A spatial database is a general-purpose database that has been enhanced to include spatial data that represents objects defined in a geometric space, along with tools for querying and analyzing such data.

<span class="mw-page-title-main">4 Cassiopeiae</span> Star in the constellation Cassiopeia

4 Cassiopeiae is a red giant in the northern constellation of Cassiopeia, located approximately 790 light-years away from the Sun. It is visible to the naked eye as a faint, red-hued star with a baseline apparent visual magnitude of 4.96. At the distance of this system, its visual magnitude is diminished by an extinction of 0.56 due to interstellar dust. This system is moving closer to the Earth with a heliocentric radial velocity of −39 km/s.

Language Integrated Query is a Microsoft .NET Framework component that adds native data querying capabilities to .NET languages, originally released as a major part of .NET Framework 3.5 in 2007.

<span class="mw-page-title-main">HD 155035</span> Star in the constellation Ara

HD 155035 is the Henry Draper Catalogue designation for a star in the constellation Ara, the Altar. It is located at a distance of approximately 1,450 light-years from Earth and has an apparent visual magnitude of 5.92, making it is faintly visible to the naked eye. This is a red giant star with a stellar classification of M1.5 III. It an irregular variable that changes brightness over an amplitude range of 0.12 magnitudes.

BigQuery is Google's fully managed, serverless data warehouse that enables scalable analysis over petabytes of data. It is a Platform as a Service (PaaS) that supports querying using a dialect of SQL. It also has built-in machine learning capabilities. BigQuery was announced in May 2010 and made generally available in November 2011.

<span class="mw-page-title-main">10 Draconis</span> Star in the constellation Draco

10 Draconis is a single star in the northern circumpolar constellation of Draco. It was a latter designation of 87 Ursae Majoris, and is visible to the naked eye with an apparent visual magnitude of about 4.6. The distance to this star, as determined from its annual parallax shift of 8.2 mas, is around 400 light years. It is moving closer with a heliocentric radial velocity of −12 km/s, and is expected to come to within 84 ly in about 8.6 million years.

<span class="mw-page-title-main">TOPCAT (software)</span> Graphical viewer of tabular data mainly used in astronomical applications

TOPCAT is an interactive graphical viewer and editor for tabular data. Although a general purpose tool capable of handling large and sparse datasets with correlation functionality its specialist application area is astronomy and it was initially designed to support virtual observatories. It is able to handle several digital file formats including FITS which is in common use in astronomy. The Acronym TOPCAT derives from Tool for OPerations on Catalogues And Tables.

<span class="mw-page-title-main">KQ Puppis</span> Binary star in the constellation Puppis

KQ Puppis is a spectroscopic binary variable star in the constellation Puppis. A red supergiant star and a hot main sequence star orbit each other every 9,742 days. Its apparent magnitude varies between 4.82 and 5.17.

<span class="mw-page-title-main">83 Ursae Majoris</span> Candidate binary star system in the constellation Ursa Major

83 Ursae Majoris is a candidate binary star system in the northern circumpolar constellation of Ursa Major. It is a semiregular variable star, and it has been given the variable star designation IQ Ursae Majoris. It ranges in brightness from apparent visual magnitude 4.69 to 4.75. Percy and Au (1994) identified it as a small amplitude red variable with an irregular behavior, having a characteristic time scale of 20 days. Based upon an annual parallax shift of 6.23±0.22 mas, it is located roughly 520 light years from the Sun. The distance derived from its Gaia Early Data Release 3 parallax is 179 pc. The system is moving closer with a heliocentric radial velocity of −18.6 km/s.

<span class="mw-page-title-main">TW Pictoris</span> Star in the constellation Pictor

TW Pictoris is a 14th magnitude cataclysmic variable star system in the southern constellation of Pictor. It is located at a distance of approximately 1,430 light-years based on parallax measurements. Photometric observations in the visual band suggest a binary system with an orbital period of 6.06 hours. One of the components is an accreting white dwarf.

<span class="mw-page-title-main">S Boötis</span>

S Boötis is a Mira variable in the constellation Boötes. It ranges between magnitudes 7.8 and 13.8 over a period of approximately 270 days. It is too faint to be seen with the naked eye, however when it is near maximum brightness it can be seen with binoculars.

<span class="mw-page-title-main">BI Cygni</span> Star in the constellation Cygnus

BI Cygni(BI Cyg, IRC +40408, BD+36 4025) is a red supergiant in the constellation Cygnus. It is an irregular variable star with a maximum brightness of magnitude 8.4 and a minimum of magnitude 9.9. It is considered a member of the stellar Cygnus OB1 association, its distance is around 2,600 parsecs (8,500 ly) of the Solar System. It is less than a degree south of another variable red supergiant, BC Cygni.

<span class="mw-page-title-main">Gaia Sky</span> Open-source astronomy visualisation program

Gaia Sky is an open-source astronomy visualisation desktop and VR program with versions for Windows, Linux and macOS. It is created and developed by Toni Sagristà Sellés in the framework of ESA's Gaia mission to create a billion-star multi-dimensional map of our Milky Way Galaxy, in the Gaia group of the Astronomisches Rechen-Institut. Gaia Sky is a product of the outreach working group of the Gaia Data Processing and Analysis Consortium. The software is released under the Mozilla Public License.

<span class="mw-page-title-main">MZ Puppis</span> Red supergiant star in the constellation of Puppis

MZ Puppis is a red supergiant star in the constellation of Puppis. It has a radius of 400 R.

<span class="mw-page-title-main">Gaia catalogues</span> Catalogues consisting of data from the Gaia misson.

The Gaia catalogues are star catalogues created using the results obtained by Gaia space telescope.

<span class="mw-page-title-main">V1027 Cygni</span> Star in the constellation Cygnus

V1027 Cygni is a luminous yellow supergiant star located in the constellation of Cygnus, about 14,000 light years away. For a time, it was thought that it could be a low-mass post-AGB star, however recent parallax measurements published in Gaia DR3 have shown this to likely not be the case, and instead it is likely a massive yellow supergiant star.

References

Footnotes

Sources