(r19) ADQL21RFC < IVOA

IVOA Web>IvoaTCG>ADQL21RFC (revision 19) (raw view)~~EditAttach~~
---++ ADQL 2.1 Proposed Recommendation: Request for Comments

<br /><span data-mce-mark="1"><span data-mce-mark="1">%TOC{depth="2"}%</span></span>

---

ADQL defines an SQL-like grammar adapted for astronomical purpose. It is especially used by the <a href="TableAccess" target="_blank">TAP</a> (Table Access Protocol) standard.

Latest version of ADQL can be found at:
   * [[https://www.ivoa.net/documents/ADQL/20230418/index.html][<span data-mce-mark="1">https://www.ivoa.net/documents/ADQL/20230418/index.html</span>]]

---+++ Reference Interoperable Implementations
   * <a href="https://soft.g-vo.org/dachs" target="_blank">DACHS</a>
   * <a href="https://github.com/gmantele/vollt/tree/adql2.1" target="_blank">VOLLT/ADQLLib (branch adql2.1)</a>

---+++ Implementations Validators

Two ADQL parsing validators available in the GitHub repository named <a href="https://github.com/ivoa/lyonetia" target="_blank">Lyonetia</a>:
   * One based on DACHS: <a href="https://github.com/ivoa/lyonetia/tree/master/src/adql/gavo" target="_blank">src/adql/gavo</a>
   * One based on VOLLT: <a href="https://github.com/ivoa/lyonetia/tree/master/src/adql-validator" target="_blank">src/adql-validator</a>
Both validators work offline and with no assumption on a specific database schema.

A GitHub CI workflow is set up in this repository. It validates all test queries available in the <a href="https://github.com/ivoa/lyonetia/tree/master/src/adql/ivoa" target="_blank">src/adql/ivoa</a> directory thanks to the ADQL validator based on VOLLT.

Two badges are visible on top of the <a href="https://github.com/ivoa/lyonetia/blob/master/README.md" target="_blank">README.md</a> document. The first one (named "Validator test") indicates whether the ADQL validator based on VOLLT compiled successfully or not. The second one (named "ADQL Validation) indicates whether all test queries passed or not. An HTML report is visible by clicking on this second badge (after clicking on the badge, click on the "Master" page to see it). It shows which test file run and which tests failed.

---
---

---++ Comments from the IVOA Community during RFC/TCG review period: %RED%25-Apr-2023 - 6-Jun-2023%ENDCOLOR%

The comments from the TCG members during the RFC/TCG review should be included in the next section.

In order to add a comment to the document, please edit this page and add your comment to the list below in the format used for the example (include your Wiki Name so that authors can contact you for further information). When the author(s) of the document have considered the comment, they will provide a response after the comment.

Additional discussion about any of the comments or responses can be conducted on the WG mailing list. However, please be sure to enter your initial comments here for full consideration in any future revisions of this document

   * Sample comment by TWiki.WikiName
      * Response (by TWiki.WikiName)

---
---

---++ Comments from TCG member during the RFC/TCG Review Period: %RED%25-Apr-2023 - 20-Jun-2023%ENDCOLOR%

WG chairs or vice chairs must read the Document, provide comments if any (including on topics not directly linked to the Group matters) or indicate that they have no comment.

IG chairs or vice chairs are also encouraged to do the same, althought their inputs are not compulsory.

---+++ TCG Chair & Vice Chair

---+++ [[IvoaApplications][Applications Working Group]]

---+++ [[IvoaDAL][Data Access Layer Working Group]]

---+++ [[IvoaDataModel][Data Model Working Group]]

---+++ [[IvoaGridAndWebServices][Grid & Web Services Working Group]]

---+++ [[IvoaResReg][Registry Working Group]]

---+++ [[IvoaSemantics][Semantics Working Group]]

---+++ [[IvoaDCP][Data Curation & Preservation Interest Group]]

Interesting new features - thank Greg and all!

It looks good, more user-friendly, even if the migration needs important work for data-center (eg: WITH, CAST, geometrical functions, units)

Details :
   * (4.2.7) "coord_value" is not defined.
   * (4.2.13) is it possible to use boolean instead of values {0,1} for CONTAINS ?
   * (4.3) can you add link to UDF functions validated by IVOA (ivo_..) ?
   * (4.6.1) remove item "the columns in the operands SHOULD have the same metadata, e.g. units, UCD, etc." - <br />Tests should be limited to datatype - "same UCD" is clearly wrong (eg.: JOIN on primary-foregin key use meta.id;id.main and meta.id) , furthermore VOTable have not always UCD.
Coord syst: Coordinate system parameter deprecation has impacts. <br />For instance, coordinate system used in VizieR tables depends of each catalogues.<br />The coord syst is important in case of crossmatch (from an other table or from an UPLOAD)

If the parameter is removed, it requires;
   * <span data-mce-mark="1" style="background-color: transparent;">TO FIND A WAY TO REPORT THE NATIVE COORDINATE SYSTEM TO USER - in TAP_SCHEMA for instance</span>
   * <span style="background-color: transparent;">to use UDF functions to make the conversion (is it possible to add with explicit example using UDF)</span>
Notre : (4.2.16) COORDSYS function looks strange if system is removed from geometrical function - it asks a background ADQL processing
---+++ [[IvoaEducation][Education Interest Group]]

---+++ [[IvoaKDD][Knowledge Discovery Interest Group]]

---+++ [[IvoaOps][Operations Interest Group]]

---+++ [[IvoaRadio][Radio Astronomy Interest Group]]

---+++ [[IvoaSS][Solar System Interest Group]]

---+++ [[IvoaTheory][Theory Interest Group]]

---+++ [[IvoaVOEvent][Time Domain Interest Group]]

---+++ [[IvoaStdsDocsProc][Standards and Processes Committee]]

---

---++ TCG Vote : %RED%6-Jun-2023 - 20-Jun-2023%ENDCOLOR%

If you have minor comments (typos) on the last version of the document please indicate it in the Comments column of the table and post them in the TCG comments section above with the date.

| Group | Yes | No | Abstain | Comments |
| TCG | | | | |
| Apps | | | | |
| DAL | | | | |
| DM | | | | |
| GWS | | | | |
| Registry | | | | |
| Semantics | | | | |
| DCP | | | | |
| Edu | | | | |
| KDIG | | | | |
| Ops | | | | |
| Radio | | | | |
| SSIG | | | | |
| Theory | | | | |
| TD | | | | |
| &lt;nop&gt;StdProc | | | | |

---

<br /> &lt;!--

Set ALLOWTOPICRENAME =&lt;span class="WYSIWYG_PROTECTED"&gt; IVOA.TWikiAdminGroup &lt;/span&gt;

--&gt;
Topic revision: r19 - 2023-04-26 - GregoryMantelet
IVOA
Log in or Register
IVOA.net
Wiki Home
WebChanges
WebTopicList
WebStatistics
Twiki Meta & Help
IVOA
Know
Main
Sandbox
TWiki
TWiki intro
TWiki tutorial
User registration
Notify me
Working Groups
Interest Groups
Time Domain
Committees
Stds&Procs
www.ivoa.net
Documents
Events
Members
XML Schema