ADQL WD v1.05

From: Yuji SHIRASAKI <yuji.shirasaki-at-nao.ac.jp>
Date: Sun, 02 Jul 2006 00:41:30 +0900 (JST)

Hi VOQLers,

July is a due date to finalize the VOQL WDs and move to a PR process. That is promised at the victoria meeting...

So now I will ask you to review and commnet to the most recent version of ADQL WD that is upload at the VOQL twiki page:

http://www.ivoa.net/internal/IVOA/IvoaVOQL/ADQL-20060701.doc or
http://www.ivoa.net/internal/IVOA/IvoaVOQL/ADQL-20060701.pdf

The first dead line for comments is July 7 (in any time zone). I will update the draft according to the comments recieved by that date in a few days. I will distribute it again, then the second dead line for comment will be 1 week later from the second distribution (July 19 ?). Final doc will be distributed around July 24 and approved by WGs and go to the PR (I hope).

The skynode interface doc follows the same procedure but it will be one or two weeks behind the ADQL doc.

Changes from the WD presented at the Victoria meeting are:

  1. ADQL syntax explanation is moved to main body from Appendix. Now the Appendix has only the BNF definition, no explantion there.
  2. I assingned ADQL extension IDs by three characters and they are summarized in table 1.
  3. Data types are summarized in table 2, and allowed operations for data/time data types are summarized in table 3.
  4. Aggregate functions are summarized in table 4 and functions are summarized in table 5. The functions are categorized to a basic function and an advanced function. A basic function is not mandatory event in a Core spec, but they are recommended to support.
  5. Xmatch related functions are renamed to join_chi2 and join_distance.
  6. A section of metadata query is added, where some of the metadata tables are defined.
  7. unit is removed from doc as agreed in Victoria.
  8. frame name is mandatory in specifing the region as agreed in Vic.
  9. IS NULL predicate is added to Core spec.
  10. #UPLOAD is renamed to UPLOAD.
  11. Reserved keywords are defined, which are not used for column name, table name, and so on.
  12. A delimiter of a delimited identifier is changed from [] to "".
  13. Literal format for date/time data type is defined as agreed in Vic.
  14. What else ?

Your comments wellcom.

Thank you.

Yuji Shirasaki. Received on 2006-07-01Z17:42:50