Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-12719

Define and implement TAP/ADQL queries before Victoria meeting

    XMLWordPrintable

    Details

    • Epic Name:
      S18 Arch IVOA Interface
    • Story Points:
      20
    • WBS:
      02C.02.02.01
    • Team:
      Architecture
    • Cycle:
      Spring 2018

      Description

      Define and document the subset of ADQL to be supported by DAX dbserv. Implement that subset.

        Attachments

        Stories in Epic (Custom Issue Matrix)

          Activity

          Hide
          gpdf Gregory Dubois-Felsmann added a comment -

          I think Brian did partially implement ADQL in albuquery before we abandoned that line of work. I imagine we can tell from the history when this was done, if that's what necessary to resolve this epic.

          Show
          gpdf Gregory Dubois-Felsmann added a comment - I think Brian did partially implement ADQL in albuquery before we abandoned that line of work. I imagine we can tell from the history when this was done, if that's what necessary to resolve this epic.
          Hide
          gpdf Gregory Dubois-Felsmann added a comment -

          Added Fritz Mueller as a watcher to help us sort this out.

          Show
          gpdf Gregory Dubois-Felsmann added a comment - Added Fritz Mueller as a watcher to help us sort this out.
          Hide
          fritzm Fritz Mueller added a comment - - edited

          Albuquery/dbserv are no more, per Gregory's comment.  Qserv meanwhile has been extended to deduce basic geometric extensions from usage of scisql UDFs for the most common point-in-circle and point-in-polygon cases, and Rubin's TAP service implementation currently generates queries of this type when backed by Qserv.

          I would recommend that we close "research" ticket DM-14535 as done, given that Brian did do some research (documented on ticket), and then we close this epic.

          If support for additional types of ADQL queries is desired, we can open new tickets containing actual specifics ( ! ) and example queries, then divide necessary work between the teams currently responsible for the TAP service and Qserv parts.

          Show
          fritzm Fritz Mueller added a comment - - edited Albuquery/dbserv are no more, per Gregory's comment.  Qserv meanwhile has been extended to deduce basic geometric extensions from usage of scisql UDFs for the most common point-in-circle and point-in-polygon cases, and Rubin's TAP service implementation currently generates queries of this type when backed by Qserv. I would recommend that we close "research" ticket DM-14535 as done, given that Brian did do some research (documented on ticket), and then we close this epic. If support for additional types of ADQL queries is desired, we can open new tickets containing actual specifics ( ! ) and example queries, then divide necessary work between the teams currently responsible for the TAP service and Qserv parts.
          Hide
          fritzm Fritz Mueller added a comment -

          I see the description of the epic is "define and document...", however.  There is a Qserv documentation sprint currently underway, and this will include definition of geometric queries supported by Qserv.  I am not sure where/how the upstream ADQL support boundaries are delineated in documentation, though?

          Show
          fritzm Fritz Mueller added a comment - I see the description of the epic is "define and document...", however.  There is a Qserv documentation sprint currently underway, and this will include definition of geometric queries supported by Qserv.  I am not sure where/how the upstream ADQL support boundaries are delineated in documentation, though?
          Hide
          womullan Wil O'Mullane added a comment -

          We do have some ADQL but not complete. I think this can close based on the age and content. Fritz has work on the back end of it.

          Show
          womullan Wil O'Mullane added a comment - We do have some ADQL but not complete. I think this can close based on the age and content. Fritz has work on the back end of it.

            People

            Assignee:
            bvan Brian Van Klaveren
            Reporter:
            ktl Kian-Tat Lim
            Watchers:
            Fritz Mueller, Gregory Dubois-Felsmann, Kian-Tat Lim, Tim Jenness, Wil O'Mullane
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Jenkins

                No builds found.