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

Use embedded DB in table data support

    XMLWordPrintable

    Details

    • Type: Story
    • Status: Done
    • Resolution: Done
    • Fix Version/s: None
    • Component/s: Firefly
    • Labels:
    • Story Points:
      26
    • Sprint:
      SUIT Sprint 2017-9, SUIT Sprint 2017-10
    • Team:
      Science User Interface

      Description

      We have done the preliminary research in ticket DM-9888 on the options for embedded database in Firefly table data support. This ticket is to implement the functions to replace the home-grown capabilities in table data operations. This will enable new functions:

      • add calculated columns to the table
      • allow more complicated filter on the table
      • use the DB functions for sorting, filtering ...

      Summary:

      • HyperSQL was selected for its performance, built-in functions, and ease of use.
      • Caching is changed to last only the during of a session.
      • Some SearchProcessors were converted to the new interface while the rest were adapted via a common wrapper.

        Attachments

          Issue Links

            Activity

            There are no comments yet on this issue.

              People

              Assignee:
              loi Loi Ly
              Reporter:
              xiuqin Xiuqin Wu [X] (Inactive)
              Watchers:
              Emmanuel Joliet, Gregory Dubois-Felsmann, Steve Groom [X] (Inactive), Xiuqin Wu [X] (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: