IvoaVOQLHistoric < IVOA

IVOA Web>IvoaVOQLHistoric (2007-01-19, BrunoRino) (raw view)

<H1> IVOA Query Language (historic pages) </H1>


--- [[IVOA.IvoaVOQL][New VOQL group pages ]]

---
%TOC%
---

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 <nop>VOQL as represented below.
<img width="75%" src="http://wiki.ivoa.net/internal/IVOA/IvoaVOQLHistoric/layers.gif" border="0">

---++ 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 
   * [[%ATTACHURL%/ADQL-0.91.pdf][Specification - ADQL-0.91.pdf]]
   * [[%ATTACHURL%/ADQL-0.91.xsd][Just the schema - ADQL-0.91.xsd]]

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 [[%ATTACHURL%/adql_steps.html][ADQL Schema generation steps]].

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

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

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

A [[%ATTACHURL%/Adql-Java-Web-Parser-0.7.4.zip ][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.
   * [[%ATTACHURL%/SkyNodeInterface-0.9.pdf][SkyNodeInterface-0.9.pdf]]  
Latest SkyNode WSDL from IVOA [[%ATTACHURL%/SkyNode0_9.wsdl][SkyNode0_9.wsdl]]

There are currently Java and .NET implementations of this. Nodes are registered in the [[http://nvo.stsci.edu/voregistry/][Registry]] and may be intereacted with through the [[http://www.openskyquery.net][OpenSkyQuery Portal]]. You may get the .NET version off the help pages of openskyquery. The Basic Java version is included in the [[http://chart.stsci.edu/twiki/bin/view/Main/SummerSchool][SumerSchool software]] from the nvo. 

A More Complete Java implelemtation is underconstruction by Tom <nop>McGlynn and is in the [[http://us-vo.org/software/index.cfm][NVO CVS]]   under [[http://viewcvs.cacr.caltech.edu/us-vo/viewcvs.cgi/contrib/tam/][contrib/tam/skynode]] 
Other groups (JVO, ESA, <nop>IndiaVO) are also looking at the java implementation.

---+++ SkyNode Registry Schema Extention
The SkyNode also requires a registry entry you may register in the
[[http://nvo.stsci.edu/voregistry][NVO registry]]. The schema for the
SkyNode registry entry is here - [[%ATTACHURL%/OpenSkyNode-v0.1.xsd][OpenSkyNode-v0.1.xsd]]

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


---++ <nop>VOQL Sessions in Kyoto 2005 May
   * [[IVOA.InterOpMay2005VOQL][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 &#8594; Rec ADQL & SkyNode

-- Below is work for future version --

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

   * Oct 2005    ADASS + IVOA Interop Madrid, Spain<br/>
   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 <br/>
   To PR ????

---++ Mailing-list 
   * General working-group discussion [[http://www.ivoa.net/forum/voql/][archive]].


---++ Related Links
   * [[http://www.skyquery.net][Sky Query]] - [[http://www.skyquery.net/matching.htm][About the cross match]]


---++ References
   * [[http://adass.org/adass/proceedings/adass02/O10-1/][Budavári, T., et al. 2002, ADASS XII, O10-1]]
   * [[http://arxiv.org/abs/cs.DB/0211023][Malik, T., et al. 2002, CIDR `03, p.17, "SkyQuery: A Web Service Approach to Federate Databases"]]
   * [[http://skyservice.pha.jhu.edu/develop/meetings/adass2003/P2-18.ps][Budavári, T., et al. 2003, ADASS XIII, P2-18]]

---






<br/>
<!--
      * Set ALLOWTOPICRENAME = IVOA.TWikiAdminGroup
-->

Attachments

Topic attachments
I	Attachment	History	Action	Size	Date	Who	Comment
xsd	ADQ-Core-v0.2.xsd	r1	manage	21.3 K	2006-07-12 - 15:23	YujiSHIRASAKI	ADQL Core Schema 0.2
pdf	ADQL-0.7.1.pdf	r1	manage	66.6 K	2004-01-23 - 15:22	WilliamOMullane
xsd	ADQL-0.7.3.xsd	r1	manage	22.3 K	2004-02-26 - 21:46	VivekHaridas	The proposed ADQL v0.73 schema
pdf	ADQL-0.7.4.pdf	r1	manage	463.1 K	2004-05-17 - 14:52	WilliamOMullane	new version for Boston meeting
xsd	ADQL-0.7.4.xsd	r1	manage	21.6 K	2004-03-23 - 16:56	VivekHaridas	The proposed ADQL v 0.7.4 schema
pdf	ADQL-0.8.1.pdf	r1	manage	600.3 K	2004-08-20 - 07:12	MasatoshiOhishi	A Working Document for ADQL-0.8.1
pdf	ADQL-0.8.pdf	r1	manage	599.3 K	2004-07-26 - 08:26	MasatoshiOhishi	A working draft for ADQL ver 0.8
xsd	ADQL-0.8.xsd	r1	manage	26.1 K	2004-07-23 - 18:27	VivekHaridas	The proposed ADQL v 0.8 schema
xsd	ADQL-0.9.xsd	r1	manage	26.2 K	2004-11-02 - 19:40	WilliamOMullane	v0.9 schema - same as v0,8
doc	ADQL-0.91.doc	r1	manage	568.5 K	2005-05-05 - 13:38	WilliamOMullane
pdf	ADQL-0.91.pdf	r1	manage	88.1 K	2005-05-05 - 17:25	WilliamOMullane
xsd	ADQL-0.91.xsd	r1	manage	25.3 K	2005-05-05 - 13:48	WilliamOMullane
doc	ADQL-20060701.doc	r1	manage	616.5 K	2006-07-01 - 15:03	YujiSHIRASAKI	ADQL WD 1.05
pdf	ADQL-20060701.pdf	r1	manage	205.6 K	2006-07-01 - 15:04	YujiSHIRASAKI	ADQL WD 1.05
doc	ADQL-20060713.doc	r1	manage	691.0 K	2006-07-13 - 14:55	YujiSHIRASAKI	ADQL WD 1.051
pdf	ADQL-20060713.pdf	r1	manage	220.5 K	2006-07-13 - 14:56	YujiSHIRASAKI	ADQL WD 1.051
xsd	ADQL-v1.05.xsd	r1	manage	17.1 K	2006-07-12 - 15:24	YujiSHIRASAKI	ADQL Full Schema 1.05
zip	ADQL2SQL-XSLTs.zip	r1	manage	7.5 K	2006-08-29 - 11:34	AurelienStebe	XSLT Stylesheets pack to convert ADQL to SQL
zip	Adql-Java-Web-Parser-0.7.4.zip	r2 r1	manage	306.7 K	2004-05-21 - 17:35	VivekHaridas	Java client src and build files for ADQL-0.7.4
xsd	Adql.xsd	r1	manage	22.3 K	2004-02-26 - 20:27	VivekHaridas	The proposed ADQL v0.73 schema
pdf	DraftAgenda_VOQL_May04.pdf	r2 r1	manage	11.5 K	2004-05-21 - 11:00	MasatoshiOhishi
pdf	DraftAgenda_VOQL_Oct04.pdf	r1	manage	9.9 K	2004-08-20 - 13:52	MasatoshiOhishi	Preliminary Agenda Items for the Pune meeting
ps	JVOQL.ps	r1	manage	106.5 K	2003-03-18 - 13:26	JonasHaase	JVO Query Language
xsd	OpenSkyNode-v0.1.xsd	r1	manage	4.8 K	2004-11-02 - 19:42	WilliamOMullane	Registry Schema Extention for OSN
wsdl	SkyNode0_9.wsdl	r1	manage	76.4 K	2005-05-11 - 21:14	WilliamOMullane	SkyNode WSDL (fixed for java)
pdf	SkyNodeInterface-0.7.4.pdf	r1	manage	145.3 K	2004-05-17 - 14:53	WilliamOMullane
pdf	SkyNodeInterface-0.7.pdf	r1	manage	138.6 K	2004-01-23 - 15:23	WilliamOMullane
doc	SkyNodeInterface-0.9.doc	r1	manage	151.0 K	2005-05-11 - 21:19	WilliamOMullane
pdf	SkyNodeInterface-0.9.pdf	r1	manage	243.1 K	2005-05-11 - 21:18	WilliamOMullane	some new metadat - bring uptodate with actaul pros
doc	SkyNodeInterface-20060711.doc	r1	manage	488.0 K	2006-07-11 - 13:24	YujiSHIRASAKI	SkyNode WD 1.03
pdf	SkyNodeInterface-20060711.pdf	r1	manage	139.7 K	2006-07-11 - 13:24	YujiSHIRASAKI	SkyNode WD 1.03
txt	VOQL-notes-oct16-2003.txt	r1	manage	2.0 K	2003-10-24 - 17:21	PatrickDowler	notes from VOQL WG session
pdf	VOQL_R2.pdf	r1	manage	7.9 K	2003-05-12 - 07:31	MasatoshiOhishi	Revised Prem. Agenda on May 12
pdf	WD_ADQL-0.9.pdf	r1	manage	623.4 K	2004-11-11 - 10:25	MasatoshiOhishi	draft Proposed Recommendation of ADQL
ycc	adql-0.8.ycc	r1	manage	11.6 K	2004-07-23 - 18:33	VivekHaridas	The grammar for ADQL/s ver 0.8
xsl	adql2sql-ns.xsl	r1	manage	12.4 K	2004-02-09 - 17:11	RamonWilliamson	XSL to convert JHU converter output to SQL
xsl	adql2sql.xsl	r1	manage	12.1 K	2004-02-09 - 17:08	RamonWilliamson	XSL stylesheet to convert ADQL 0.7.1 to SQL string
xsl	adql2sql_v073.xsl	r1	manage	8.9 K	2004-03-05 - 22:54	RamonWilliamson	XSLT Stylesheet to convert ADQL 0.7.3 to SQL
xsl	adql2sql_v074.xsl	r1	manage	10.9 K	2004-04-05 - 16:38	RamonWilliamson	XSLT Stylesheet to convert ADQL 0.7.4 to SQL
xsl	adql2sql_v10.xsl	r1	manage	11.3 K	2005-08-23 - 13:53	AurelienStebe	XSLT Stylesheet to convert ADQL 1.0 to SQL
html	adql_steps.html	r1	manage	3.1 K	2004-03-02 - 20:29	VivekHaridas
zip	adql_v073_examples.zip	r2 r1	manage	3.1 K	2004-02-26 - 21:49	VivekHaridas	Xml examples of the proposed ADQL v0.73 queries
pdf	chamberlin.pdf	r1	manage	472.5 K	2003-03-18 - 13:29	JonasHaase	XQuery: An XML query language