Difference: ADQLGeomOnSQLServer (4 vs. 5)

Revision 52016-01-22 - TheresaDower

 
META TOPICPARENT name="DaveMorris"

ADQL geometric functi"> SQLServer & ADQL geometric functions

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

Current deployments

ROE

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

Changed:
<
<
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.
>
>
Nearly completed TAP services are not currently published. Release of ObsTAP is held up on adding geometric functions for parsing ADQL to native SQL Server. to SQL Server-flavoured queries. For both RegTAP and ObsTAP, some canned TOPCAT queries don't work due to lack of NATURAL JOIN support in SQL Server. Services will be shipped preliminarily without that support, with the intention of adding it later.
 
Changed:
<
<
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.
>
>
Brian McLean has written a series of database procedures mapping more pgSphere-like regional queries to the SQL Server's built-in geometric functions. Testing suggests similar performance to the old HTM-based system, and will be used in the ADQL parsing.
 

 
This site is powered by the TWiki collaboration platform Powered by Perl This site is powered by the TWiki collaboration platformCopyright © 2008-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback