Uploaded image for project: 'UX Product'
  1. UX Product
  2. UXPROD-1818

RMB 26 release features and core module rollout (performance, array search and cross-table search)

    XMLWordPrintable

    Details

    • Template:
    • Epic Link:
    • Back End Estimate:
      XXL < 30 days
    • Development Team:
      Core: Platform
    • Calculated Total Rank:
      30
    • PO Rank:
      10
    • Rank: GBV (MVP Sum 2020):
      R1
    • Rank: Lehigh (MVP Summer 2020):
      R1
    • Rank: TAMU (MVP Jan 2021):
      R1

      Description

      RMB 25 was an internal release that included most of the refactoring and new functionality. During roll-out and integration testing a set of regressions (existing or introduced in 25) were discovered and scheduled for fixing in RMB 26. RMB 26 will the public release rolled out to the core storage modules.

      RMB 25/26 is focused on performance improvements and new search functionality:

      • removal of regular expression based searching
      • improvements wrt to ID searching
      • general refactoring and simplification of the SQL generation code (allows for more SQL optimizations)
      • new syntax for array searching and new implementation optimized for index use
      • cross-table search and join support (to address poor performing seaches like item.barcorde and holdingsRecord.location)

      This task includes rollout to all platform-core backend modules (including API migration and Unit test updates).

      https://issues.folio.org/issues/?jql=project%20%3D%20RMB%20AND%20fixVersion%20%3D%2025.0.0
      https://issues.folio.org/issues/?jql=project%20%3D%20RMB%20AND%20fixVersion%20%3D%2026.0.0

        TestRail: Results

          Attachments

            Issue Links

            blocks

            Bug - A problem which impairs or prevents the functions of the product. UIU-835 Searching by Close Parens Generates Error

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed
            is blocked by

            Task - A task that needs to be done. CIRC-380 Support "loan-storage 6.0" after RMB 26 audit table schema breaking change

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Task - A task that needs to be done. CIRCSTORE-134 Upgrade to RMB 26

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            New Feature - New feature requests CQLPG-96 remove regex-based query time tokenization

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Task - A task that needs to be done. MODINVSTOR-285 upgrade to RMB 26 and resolve related issues

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Task - A task that needs to be done. MODUSERS-126 Upgrade to RMB 25

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Task - A task that needs to be done. RMB-380 implement new approach for searching array-of-strings and array-of-objects fields

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            New Feature - New feature requests RMB-387 Implement child->parent foreign key support for CQLPGJson Parser

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Task - A task that needs to be done. RMB-395 support nested sub queries across multiple tables

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. RMB-414 audit table jsonb, rename item field to be unique

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Task - A task that needs to be done. UIU-1092 Audit table /loan-storage/loan-history breaking change

            • P2 - normal priority level, must be included in the current development cycle
            • Closed
            is cloned by

            New Feature - New feature requests UXPROD-1820 RMB 27 release features and core module rollout (performance, virtual indexes, search enhancements)

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed
            relates to

            Bug - A problem which impairs or prevents the functions of the product. CIRCSTORE-138 Filtering Requests by Request Status doesn't return any rows

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

              Activity

                People

                Assignee:
                jakub Jakub Skoczen
                Reporter:
                jakub Jakub Skoczen
                Back End Estimator:
                Jakub Skoczen Jakub Skoczen
                Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases