Info Hub

Data Dictionaries for Cleanup

Last updated:
Feb 19, 2024
Topic(s):
Database maintenance
Summary:

In order to keep local metadata consistent, Sierra Statistics can identify the system codes actually used in records which can then be cleaned up as needed then documented for future reference.

Suggestions for metadata clean up from Vanguard libraries

Last updated:
Feb 24, 2024
Topic(s):
Database maintenance, Vanguard libraries suggestions and advice
Summary:

Given their pre-migration experiences, the Vanguard libraries have suggestions for metadata clean-up projects and advice for all OhioLINK member libraries. This Info Hub article will continue to be expanded and revised as needed.

Kent State University Libraries regular updates for other libraries

Last updated:
Mar 26, 2025
Topic(s):
Database maintenance, Crowdsourced
Summary:

Find bibliographic records using various updates suggested by Kent State University based on their regular checks.

Regular Expressions and Title Field Indicators

Last updated:
Feb 12, 2024
Topic(s):
Database maintenance, Metadata cleanup using RegEx
Summary:

Find bibliographic records that have title field indicator errors using Regular Expressions (RegEx).

Regular Expressions and the Control Number Field

Last updated:
Feb 12, 2024
Topic(s):
Database maintenance, Metadata cleanup using RegEx
Summary:

Find bibliographic records that have a non-standard or missing control number in the 001 field using Regular Expressions (RegEx).

Using Global Updates

Last updated:
Apr 28, 2023
Topic(s):
Database maintenance, Global Update
Summary:

Basic Global Update commands

Saving Global Updates

Last updated:
Apr 28, 2023
Topic(s):
Database maintenance, Global Update
Summary:

Create and save Global Update commands for reuse

Converting 856 links to 956 links

Last updated:
Mar 6, 2023
Topic(s):
Database maintenance
Summary:

Convert supplemental material 856 links to 956 links in member-contributed records in the Central Catalog.

Searching for bib records without item, checkin, or order records

Last updated:
Feb 12, 2024
Topic(s):
Database maintenance
Summary:

Find non-electronic resource bibliographic records that do not have an attached item, checkin, or order record.

Searching for active item holds using a Sierra SQL query

Last updated:
Sep 15, 2022
Topic(s):
Database maintenance, Metadata cleanup using SQL
Summary:

Find items with holds still active using a Sierra SQL query.

Pages