International Virtual Observatory Alliance

Difference: IvoaVOQLHistoric (108 vs. 109)

Revision 1092006-11-17 - PedroOsuna

META TOPICPARENT	name="WebHome"

IVOA Query Language

Added:

>
>

New VOQL group pages

IVOA Query Language (historic pages)

If you are interested in participating in the definition of the VO Query Language, you are invited to enroll in the Virtual Observatory Query Language Working Group (voql@ivoa.net).

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

ADQL-0.91

Based on the Pune (2004) agreement,In the Boston 2004 meeting, the working document toward a Proposed Recommendation was published. There have been a few minor changes since Pune. This version is to be discussed at Kyoto

The January demos ran on ADLQ0.7.4. But we should be moving to this new version now. dev.openskyquery.net is runnind ADQL0.9

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 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.

A pack of XSLT stylesheets for converting ADQL to SQL (provided by ESAC) can be downloaded here : ADQL2SQL-XSLTs.zip.
This pack includes stylesheets for v0.7.4 and v1.0 (+ extensions for Mysql and Sybase).
The latter version works fine for v0.8 and v0.9, just by changing the namespace declaration.

The currect translation services are for 0.7.4 and are at http://openskyquery.net/adqltranslator

A java client for the translation service has been prepared.

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.

SkyNodeInterface-0.9.pdf

Latest SkyNode WSDL from IVOA SkyNode0_9.wsdl

There are currently Java and .NET implementations of this. Nodes are registered in the Registry and may be intereacted with through the OpenSkyQuery Portal. You may get the .NET version off the help pages of openskyquery. The Basic Java version is included in the SumerSchool software from the nvo.

A More Complete Java implelemtation is underconstruction by Tom McGlynn and is in the NVO CVS under contrib/tam/skynode Other groups (JVO, ESA, IndiaVO) are also looking at the java implementation.

SkyNode Registry Schema Extention

The SkyNode also requires a registry entry you may register in the NVO registry. The schema for the SkyNode registry entry is here - OpenSkyNode-v0.1.xsd

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

VOQL Sessions in Kyoto 2005 May

Draft Agenda for May, 2005

WG Roadmap

May 16-20 2005 Interop Kyoto

-- work toward Recommendations ADQL/SkyNode 1.0

June Prepare PR documents

Jul (-- Aug ?) RFC

Aug Vote by the Exec → Rec ADQL & SkyNode

-- Below is work for future version --

Sept 2005 First WD ADQL/SkyNode 1.x
- Integration of current ADQL and DAL (with DAL)
- X-Matcher (with DM/DAL)
  Algorithms, PSF/Baem sizes, Positional errors
  X-match is a part of SkyNode spec, or is an independent application ?
- Inclusion of simulated data access ? (with Registry WG/Theory IG)
  Theory meta data, "coordinate" ?, etc.

Oct 2005 ADASS + IVOA Interop Madrid, Spain
Discussion on the draft, and revise the WD

Jan 2006 NVO demos

Spring 2006 reference implementations ?

May 2006 Interop WS

Aug 2006 IAU Prague : VO Special Session

Autumn 2006 Interop WS
To PR ????

Mailing-list

General working-group discussion archive.

References

<-- 
 
 
 Set ALLOWTOPICRENAME = TWikiAdminGroup
 
 
-->

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"
META FILEATTACHMENT	attr="" comment="v0.9 schema - same as v0,8" date="1099424426" name="ADQL-0.9.xsd" path="C:\wil\MSDEV\AstroDQL\ADQL\ADQL-0.9.xsd" size="26796" user="WilliamOMullane" version="1.1"
META FILEATTACHMENT	attr="" comment="Registry Schema Extention for OSN" date="1099424521" name="OpenSkyNode-v0.1.xsd" path="H:\docs\adql\OpenSkyNode-v0.1.xsd" size="4896" user="WilliamOMullane" version="1.1"
META FILEATTACHMENT	attr="" comment="draft Proposed Recommendation of ADQL" date="1100168725" name="WD_ADQL-0.9.pdf" path="D:\ohishi\Documents\DB推進室\IVOA\VOQL\WD_ADQL-0.9.pdf" size="638328" user="MasatoshiOhishi" version="1.1"
META FILEATTACHMENT	attr="" comment="" date="1115300289" name="ADQL-0.91.doc" path="ADQL-0.91.doc" size="582144" user="WilliamOMullane" version="1.1"
META FILEATTACHMENT	attr="" comment="" date="1115300903" name="ADQL-0.91.xsd" path="ADQL-0.91.xsd" size="25930" user="WilliamOMullane" version="1.1"
META FILEATTACHMENT	attr="" comment="" date="1115313943" name="ADQL-0.91.pdf" path="ADQL-0.91.pdf" size="90260" user="WilliamOMullane" version="1.1"
META FILEATTACHMENT	attr="" comment="SkyNode WSDL (fixed for java)" date="1115846058" name="SkyNode0_9.wsdl" path="SkyNode0_9.wsdl" size="78213" user="WilliamOMullane" version="1.1"
META FILEATTACHMENT	attr="" comment="some new metadat - bring uptodate with actaul pros" date="1115846322" name="SkyNodeInterface-0.9.pdf" path="SkyNodeInterface-0.9.pdf" size="248917" user="WilliamOMullane" version="1.1"
META FILEATTACHMENT	attr="" comment="" date="1115846372" name="SkyNodeInterface-0.9.doc" path="SkyNodeInterface-0.9.doc" size="154624" user="WilliamOMullane" version="1.1"
META FILEATTACHMENT	attr="h" comment="" date="1119478224" name="arc.GIF" path="arc.GIF" size="9790" user="WilliamOMullane" version="1.1"
META FILEATTACHMENT	attr="h" comment="" date="1119478307" name="layers.gif" path="layers.gif" size="10773" user="WilliamOMullane" version="1.1"
META FILEATTACHMENT	attr="" comment="XSLT Stylesheet to convert ADQL 1.0 to SQL" date="1124805203" name="adql2sql_v10.xsl" path="adql2sql_v10.xsl" size="11581" user="AurelienStebe" version="1.1"
META FILEATTACHMENT	attr="" comment="ADQL WD 1.05" date="1151766192" name="ADQL-20060701.doc" path="ADQL-20060701.doc" size="631296" user="YujiSHIRASAKI" version="1.1"
META FILEATTACHMENT	attr="" comment="ADQL WD 1.05" date="1151766240" name="ADQL-20060701.pdf" path="ADQL-20060701.pdf" size="210526" user="YujiSHIRASAKI" version="1.1"
META FILEATTACHMENT	attr="" comment="SkyNode WD 1.03" date="1152624259" name="SkyNodeInterface-20060711.doc" path="SkyNodeInterface-20060711.doc" size="499712" user="YujiSHIRASAKI" version="1.1"
META FILEATTACHMENT	attr="" comment="SkyNode WD 1.03" date="1152624295" name="SkyNodeInterface-20060711.pdf" path="SkyNodeInterface-20060711.pdf" size="143070" user="YujiSHIRASAKI" version="1.1"
META FILEATTACHMENT	attr="" comment="ADQL Core Schema 0.2" date="1152717803" name="ADQ-Core-v0.2.xsd" path="ADQ-Core-v0.2.xsd~" size="21817" user="YujiSHIRASAKI" version="1.1"
META FILEATTACHMENT	attr="" comment="ADQL Full Schema 1.05" date="1152717873" name="ADQL-v1.05.xsd" path="ADQL-v1.05.xsd" size="17466" user="YujiSHIRASAKI" version="1.1"
META FILEATTACHMENT	attr="" comment="ADQL WD 1.051" date="1152802514" name="ADQL-20060713.doc" path="ADQL-20060713.doc" size="707584" user="YujiSHIRASAKI" version="1.1"
META FILEATTACHMENT	attr="" comment="ADQL WD 1.051" date="1152802583" name="ADQL-20060713.pdf" path="ADQL-20060713.pdf" size="225832" user="YujiSHIRASAKI" version="1.1"
META FILEATTACHMENT	attr="" comment="XSLT Stylesheets pack to convert ADQL to SQL" date="1156851241" name="ADQL2SQL-XSLTs.zip" path="ADQL2SQL-XSLTs.zip" size="7700" user="AurelienStebe" version="1.1"

View topic | History: r112 < r111 < r110 < r109 | More topic actions...