Difference: IvoaVOQLHistoric (85 vs. 86)

Revision 862004-08-20 - MasatoshiOhishi

 
META TOPICPARENT name="IvoaInteroperability"

IVOA Query Language

If you are interested in participating in the definition of a VO Query Language please contact Prof. Masatoshi Ohishi masatoshi.ohishi@nao.ac.jp.

We have a 3 layer model for VOQL as represented below.

ADQL-0.8.1

In the Boston 2005 meeting, the VOQL group agreed on the outline toward ADQL-0.8.1 (see below), and the working document was published.

It should be noted that it is a working document toward an IVOA standard VOQL specification version 1. The content of the document will be used for the January 2005 demos.

Changed:
<
<		The document was created based on the Boston 2005 agreement, however, several new features, such as CREATE,INSERT,UPDATE,DELETE, have not yet been included because these will actually create a huge increase in the size of the grammar. The ad hoc group is working in the backyard to include these features, and an improved working document, ADQL-0.8.2, is expected to appear very soon. SkyNodeInterface specification will also be modified accordingly.
>
>		The document was created based on the Boston 2004 agreement, however, several new features, such as CREATE,INSERT,UPDATE,DELETE, have not yet been included because these will actually create a huge increase in the size of the grammar. The ad hoc group is working in the backyard to include these features, and an improved working document, ADQL-0.8.2, is expected to appear very soon. SkyNodeInterface specification will also be modified accordingly.
  The process of generating the ADQL schema are described in ADQL Schema generation steps.

An example XSL style sheet for converting ADQL/x to ADQL/s (strings) has been provided by NCSA adql2sql-ns.xsl.

Further information and some tools may be found at http://skydev.pha.jhu.edu/develop/vo/adql/

A java client for the translation service has been prepared.

Enhancements due for ADQL0.8.1

  • Functions : Built-in funtion support in ADQL
  • DML : Insert, Delete, Update (Create, Drop ?)
  • Comments : SQL style comments should be in ADQL
  • Sub Queries: Currently this is not suported
  • INTO : MyDb, MySpace for both select and insert
  • Top : tie down semantics
  • GCDIST : This is just another function .
  • XMATCH : Move sigma inside the bracket (or drop it ?) Add + for outer join and ? for uncovered areas
  • JOIN : Use Explicit JOIN syntax
  • UNITS : Add to ADQL/s, ADQL/x (need more metadata on table in SkyNode)
  • XPATH : Allow XPath like column names

SkyNode

SkyNodes and the SkyNode portal would form layer 2 and 1 of this system. At the Strasbourg meeting the skynode spec was split in two. Since release of the Standard Interfaces this has also been reomved from skynode. Finally the portal section has also been reomved leaving a leaner Skynode document.

Latest SkyNode WSDL from http://openskyquery.net/nodes/sdss/nodeb.asmx?wsdl

Ther eare currently Java and .NET implementations of this. Nodes are registered in the Registry and may be intereacted with through the OpenSkyQuery Portal

Comments should be posted on the VOQL mailing list as specified below.

VOQL Sessions in Pune 2004 October

WG Roadmap

  • May 2004 version 0.7.4
  • May 24-28, 2004 Interop meeting
  • Work to include Units, XMATCH – Ad Hoc Group (Wil O'Mullane, Clive Page, Martin Hill, Yuji Shirasaki, Sébastien Derrière and the chair). See the details above. Need to describe semantics of ADQL more clearly
  • Submit ADQL-0.8 in July
  • Sep 2004 Interop meeting Agreement --> ADQL 0.9 & interaction between us and Registry/DAL/DM groups. After interaction with Registry/DAL/DM groups and discussion within our group, we prepare a draft for ADQL 1.0. When it has been approved by the IVOA executive committee, it will become ADQL 1.0.
  • Sep/Oct (?) 2004 GGF12 @ Brussels : to report activities of the VO community
  • Work toward January Demos
  • Jan 2005 Demos by ADQL-1.0 & SkyNode-1.0
  • Improvements including New data types proposed by Yuji SHirasaki
  • May 2005 Interop meeting / GGF joint WS in Japan
Discussion on ADQL-1.x, SkyNode-1.x ?

Mailing-list

  • General working-group discussion archive.

Related Links

References 


<--  
-->

META FILEATTACHMENT attr="" comment="JVO Query Language" date="1047993967" name="JVOQL.ps" path="JVOQL.ps" size="109032" user="JonasHaase" version="1.1"
META FILEATTACHMENT attr="" comment="XQuery: An XML query language" date="1047994168" name="chamberlin.pdf" path="chamberlin.pdf" size="483890" user="JonasHaase" version="1.1"
META FILEATTACHMENT attr="h" comment="Revised Preliminary Agenda for the VOQL meeting" date="1052123756" name="VOQL_R1.pdf" path="VOQL_R1.pdf" size="5254" user="MasatoshiOhishi" version="1.1"
META FILEATTACHMENT attr="" comment="Revised Prem. Agenda on May 12" date="1052724700" name="VOQL_R2.pdf" path="VOQL_R2.pdf" size="8119" user="MasatoshiOhishi" version="1.1"
META FILEATTACHMENT attr="h" comment="3 Layer Diag for VOQL" date="1064264069" name="voqllayers.JPG" path="H:\docs\adql\voqllayers.JPG" size="101851" user="WilliamOMullane" version="1.1"
META FILEATTACHMENT attr="h" comment="" date="1064264536" name="SkyNodeInterface-0.5.doc" path="H:\docs\adql\SkyNodeInterface-0.5.doc" size="226816" user="WilliamOMullane" version="1.1"
META FILEATTACHMENT attr="h" comment="Pdf of SkyNode spec 0,5" date="1064264916" name="SkyNodeInterface-0.5.pdf" path="H:\docs\adql\SkyNodeInterface-0.5.pdf" size="255004" user="WilliamOMullane" version="1.1"
META FILEATTACHMENT attr="" comment="notes from VOQL WG session" date="1067016082" name="VOQL-notes-oct16-2003.txt" path="VOQL-notes-oct16-2003.txt" size="2037" user="PatrickDowler" version="1.1"
META FILEATTACHMENT attr="h" comment="3 layers of VOQL new version" date="1067244535" name="layers.GIF" path="C:\wil\docs\adql\layers.GIF" size="119861" user="WilliamOMullane" version="1.1"
META FILEATTACHMENT attr="h" comment="" date="1067244569" name="SkyNodeInterface-0.6.pdf" path="C:\wil\docs\adql\SkyNodeInterface-0.6.pdf" size="285016" user="WilliamOMullane" version="1.1"
META FILEATTACHMENT attr="h" comment="" date="1067244766" name="ADQL-0.6.pdf" path="C:\wil\docs\adql\ADQL-0.6.pdf" size="267245" user="WilliamOMullane" version="1.1"
META FILEATTACHMENT attr="h" comment="Minor revisions were added to ADQL-0.6" date="1073652934" name="ADQL-0.7.pdf" path="ADQL-0.7.pdf" size="151892" user="MarkusDolensky" version="1.1"
META FILEATTACHMENT attr="" comment="" date="1074871379" name="ADQL-0.7.1.pdf" path="H:\docs\adql\ADQL-0.7.1.pdf" size="68225" user="WilliamOMullane" version="1.1"
META FILEATTACHMENT attr="" comment="" date="1074871417" name="SkyNodeInterface-0.7.pdf" path="H:\docs\adql\SkyNodeInterface-0.7.pdf" size="141920" user="WilliamOMullane" version="1.1"
META FILEATTACHMENT attr="" comment="XSL stylesheet to convert ADQL 0.7.1 to SQL string" date="1076346500" name="adql2sql.xsl" path="adql2sql.xsl" size="12352" user="RamonWilliamson" version="1.1"
META FILEATTACHMENT attr="" comment="XSL to convert JHU converter output to SQL " date="1076346673" name="adql2sql-ns.xsl" path="adql2sql-ns.xsl" size="12740" user="RamonWilliamson" version="1.1"
META FILEATTACHMENT attr="" comment="The proposed ADQL v0.73 schema" date="1077827251" name="Adql.xsd" path="C:\Documents and Settings\haridas\Desktop\Adql.xsd" size="22860" user="VivekHaridas" version="1.1"
META FILEATTACHMENT attr="" comment="Xml examples of the proposed ADQL v0.73 queries" date="1077832199" name="adql_v073_examples.zip" path="C:\Documents and Settings\haridas\Desktop\adql_v073_examples.zip" size="3204" user="VivekHaridas" version="1.2"
META FILEATTACHMENT attr="" comment="The proposed ADQL v0.73 schema" date="1077832017" name="ADQL-0.7.3.xsd" path="C:\Documents and Settings\haridas\Desktop\ADQL-0.7.3.xsd" size="22860" user="VivekHaridas" version="1.1"
META FILEATTACHMENT attr="" comment="" date="1078259388" name="adql_steps.html" path="C:\Documents and Settings\haridas\My Documents\My Webs\adql_steps.html" size="3154" user="VivekHaridas" version="1.1"
META FILEATTACHMENT attr="" comment="XSLT Stylesheet to convert ADQL 0.7.3 to SQL" date="1078527297" name="adql2sql_v073.xsl" path="adql2sql_v073.xsl" size="9134" user="RamonWilliamson" version="1.1"
META FILEATTACHMENT attr="" comment="The proposed ADQL v 0.7.4 schema" date="1080061008" name="ADQL-0.7.4.xsd" path="C:\Documents and Settings\haridas\My Documents\Work\AstroDql\ADQL\ADQL-0.7.4.xsd" size="22161" user="VivekHaridas" version="1.1"
META FILEATTACHMENT attr="" comment="Java client src and build files for ADQL-0.7.4" date="1085160902" name="Adql-Java-Web-Parser-0.7.4.zip" path="C:\vivek\WSDL-Tests\Adql-Java-Web-Parser-0.7.4.zip" size="314068" user="VivekHaridas" version="1.2"
META FILEATTACHMENT attr="" comment="XSLT Stylesheet to convert ADQL 0.7.4 to SQL" date="1081183131" name="adql2sql_v074.xsl" path="adql2sql_v074.xsl" size="11205" user="RamonWilliamson" version="1.1"
META FILEATTACHMENT attr="" comment="" date="1085137205" name="DraftAgenda_VOQL_May04.pdf" path="D:\ohishi\My Documents\Documents\DB推進室\IVOA\VOQL\DraftAgenda_VOQL_May04.pdf" size="11769" user="MasatoshiOhishi" version="1.2"
META FILEATTACHMENT attr="" comment="new version for Boston meeting" date="1084805564" name="ADQL-0.7.4.pdf" path="H:\docs\adql\ADQL-0.7.4.pdf" size="474254" user="WilliamOMullane" version="1.1"
META FILEATTACHMENT attr="" comment="" date="1084805631" name="SkyNodeInterface-0.7.4.pdf" path="H:\docs\adql\SkyNodeInterface-0.7.4.pdf" size="148739" user="WilliamOMullane" version="1.1"
META FILEATTACHMENT attr="" comment="The proposed ADQL v 0.8 schema" date="1090607224" name="ADQL-0.8.xsd" path="C:\Documents and Settings\haridas\My Documents\Work\ADQL-0.8.xsd" size="26709" user="VivekHaridas" version="1.1"
META FILEATTACHMENT attr="" comment="The grammar for ADQL/s ver 0.8" date="1090607582" name="adql-0.8.ycc" path="C:\Documents and Settings\haridas\My Documents\Work\adql-0.8.ycc" size="11852" user="VivekHaridas" version="1.1"
META FILEATTACHMENT attr="" comment="A working draft for ADQL ver 0.8" date="1090830396" name="ADQL-0.8.pdf" path="D:\ohishi\My Documents\Documents\DB推進室\IVOA\VOQL\ADQL-0.8.pdf" size="613666" user="MasatoshiOhishi" version="1.1"
META FILEATTACHMENT attr="" comment="A Working Document for ADQL-0.8.1" date="1092985956" name="ADQL-0.8.1.pdf" path="D:\ohishi\Documents\DB推進室\IVOA\VOQL\ADQL-0.8.1.pdf" size="614668" user="MasatoshiOhishi" version="1.1"
META FILEATTACHMENT attr="" comment="Preliminary Agenda Items for the Pune meeting" date="1093009951" name="DraftAgenda_VOQL_Oct04.pdf" path="D:\ohishi\Documents\DB推進室\IVOA\VOQL\DraftAgenda_VOQL_Oct04.pdf" size="10099" user="MasatoshiOhishi" version="1.1"
View topic | History: r112 < r111 < r110 < r109 | More topic actions...
 
This site is powered by the TWiki collaboration platform Powered by Perl This site is powered by the TWiki collaboration platformCopyright © 2008-2025 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback