(r4) ADQLGeomOnSQLServer < IVOA

IVOA Web>TWikiUsers>DaveMorris>ADQLGeomOnSQLServer (revision 4) (raw view)~~EditAttach~~

---+ SQLServer & ADQL geometric functions

Page for discussions about supporting the ADQL geometric functions in SQLServer.

---++ Current deployments

---+++ ROE

The main science archives at ROE are hosted on a set of SQLServer 2012 databases.  They have HTM-based regional queries enabled using SQL Server's built-in geometric functions, but these are not connected to the TAP services.

Our current TAP services do not support the ADQL geometric functions.

---+++ MAST

Many MAST holdings, including the Registry and a growing set of multimission data in ObsCore, are hosted on a set of SQLServer databases.

Nearly completed TAP services are not currently published. Release is held up on a library for parsing ADQL to SQL Server-flavoured queries. It needs to handle differences in left/etc join syntax (some canned TOMCAT RegTAP queries don't work), the ivo_string_agg function (for RegTap only), and ADQL geometric functions.

Brian McLean has written a series of database procedures mapping the HTM-based regional queries used by existing MAST services to the SQL Server's built-in geometric functions. Testing suggests similar performance to the old HTM-based system.

---+++

Topic revision: r4 - 2014-10-21 - MarkHolliman

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