User Tools

Site Tools


scratchpad:db_todo

Post v1.0 PINES-specific additions

  • For indexing consideration
    • field_class: subject, name: title, format: mods
      //mods:mods/mods:subject/mods:title

      As a stop-gap measure to avoid having to reindex the entire dataset (and until Ingest gets partial indexing logic), after adding the xpath setting above:

      -- insert into metabib.subject_field_entry (field, source, value)
      SELECT
          -- (select id from config.metabib_field where field_class = 'subject' and name = 'title'),
          record,
          array_to_string( array_accum( VALUE ), ' ' )
        FROM 
          metabib.full_rec
        WHERE
          tag='630'
          AND subfield IN ('a','d','f','h','k','l','o','r')
        GROUP BY 1 --, 2
      ;

      Just uncomment the hidden bits to perform the insertion after testing.

Post v1.0 generic additions

  • New index type of "description"?? This would contain publisher info, physical description and date data, etc. IOW, non-content info.
scratchpad/db_todo.txt · Last modified: 2022/02/10 13:34 by 127.0.0.1

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki

© 2008-2022 GPLS and others. Evergreen is open source software, freely licensed under GNU GPLv2 or later.
The Evergreen Project is a U.S. 501(c)3 non-profit organization.