ADQL geometric functi"> SQLServer & ADQL geometric functionsPage for discussions about supporting the ADQL geometric functions in SQLServer.Current deploymentsROE | ||||||||
Changed: | ||||||||
< < | The main science archives at ROE are hosted on a set of SQLServer databases. | |||||||
> > | 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.
MASTMany 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. |