Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: draw.io diagram "Spitfire-CallNumber-Refactoring-browse.drawio" edited

...

  • Configurability - The solution should allow disabling/enabling indexing by a feature flag.

  • Maintainability - The solution should allow changes for different callnumber call number types, searching for prefixes/suffixes, etc.

  • Performance - The solution should not impact reindexing time significantly.

...

  • In mod-search PostgreSQL DB

    • create tables for call numbers

      • The following fields should be present in the table callnumber table:

        • callnumber_id

        • effective_callnumber_components - set of components for a callnumbercall number

          • callnumber

          • prefix

          • suffix

          • callnumber_type_id

        • volume

        • enumeration

        • chronology

        • copynumber

      • The following fields should be present in the table callnumber_instances table:

        • callnumber_id

        • item_id

        • instance_id

        • shared

        • tenant_id

        • location_id

    • on create/update/delete events for items create a new procedure that would extract call numbers from items

  • Adjust the Reindexing procedure and Ongoing domain events consuming for items

  • Create a separate index for call numbers

  • Refactor browse queries to use search_after search_before queries

  • The titles for the browse option can be queried on the fly either from the instances table or the instances search index

...

Drawio
mVer2
zoom1
simple0
inComment0
custContentId367951901
pageId367919119
lbox1
diagramDisplayNameSpitfire-CallNumber-Refactoring-browse.drawio
contentVer12
revision12
baseUrlhttps://folio-org.atlassian.net/wiki
diagramNameSpitfire-CallNumber-Refactoring-browse.drawio
pCenter0
width750751
links
tbstyle
height494550

Holding-level Call Numbers

...