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

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.

Edit | Attach | Print version | History: r5 < r4 < r3 < r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions...
Topic revision: r3 - 2014-10-11 - TheresaDower
 
This site is powered by the TWiki collaboration platformCopyright © 2008-2022 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback