1 / 37

Carolina Innovative Users Group 2005 Meeting

Carolina Innovative Users Group 2005 Meeting The University of North Carolina at Charlotte Charlotte, North Carolina May 12 – 13, 2005. Global Update for Database Maintenance Dan Pfohl Associate University Librarian for Computing Services University of North Carolina Wilmington.

decima
Download Presentation

Carolina Innovative Users Group 2005 Meeting

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Carolina Innovative Users Group2005 Meeting The University of North Carolina at CharlotteCharlotte, North Carolina May 12 – 13, 2005

  2. Global Update for Database Maintenance Dan PfohlAssociate University Librarian for Computing ServicesUniversity of North Carolina Wilmington

  3. Examples of Global Update Routines • Isolate Data • Specify Changes • Execute Changes - Describe Global Update Mode - Impact on System Resources - Compare to Rapid Update

  4. Global Update Resources Millennium User Manual, p. 104002 IUG Program (2005) – Mastering Global Update by Richard Jackson IUG Listserv CIUG Listserv Innovative Help Desk

  5. What’s Global Update good for? • Global Update allows a user to quickly and easily add, delete, and change data on a database-wide scale. • Retrieve records based on record type, field group tag, MARC tag, word or string in field/subfield • Make single or multiple edits to specified records

  6. Types of changes within records: • edit multiple types of records simultaneously • find and replace tags or subfield indicators • change the value of fixed-length fields • insert new variable-length fields • find and replace data in variable-length fields/subfields • delete variable-length fields • change the value of special fields • delete duplicate fields

  7. Main Steps Select records to update Specify changes to be made Preview the changes Process the changes

  8. To Get Started . . .

  9. Specify Record Type Multiple record types can be simultaneously updated if there are fields in both records that share the same index.

  10. Specify Type of Search

  11. Specify Review File Search

  12. Specify Index Search

  13. Specify Advanced Search

  14. Advanced Limiting

  15. Toggle Field Display

  16. Manually Select Records Click – anywhere on a line to select only that line and deselect all others. Shift-click – selects a range. Control-Click – toggles a line between selected and unselected. Ctrl + a – selects entire list.

  17. Command Tab

  18. Adding data to the end of a field:

  19. Command Line Ready

  20. Preview Tab

  21. Process Button

  22. Statistics Tab Number of records updates _____ Number of records not updated _____ Number of busy records _____ Total number of changes made _____

  23. Multiple Change Commands

  24. Preview of Multiple Changes

  25. Order of Multiple Change Commands Order of commands All commands performed on individual records before system moves to next record Specific change first, general change next

  26. Multiple Change Commands (Example) (Innovative User Manual, p. 105090) Qualifying Codes f use displayed fieldw match whole fieldc match cases match whole subfield

  27. Other Global Updates Update MARC 856 links for WAM’s Rewrite Proxy Server Update MARC 245|h[computer file] => [electronic resource] Various iLumina corrections (ENC LVL, URL spaces, ampersands, scientific notation, etc.) Update Checkin records (Temp. holdings info, vendor tags) UNIV EXP DATE in Patron records

  28. Impact on System Resources Server processing resources for Create lists Server processing resources for Update processing Adds to Transaction File

  29. Rapid/Global Update Both allow multiple edits simultaneously. Global update allows more types of edits. Global Update allows change to records of different types simultaneously. Global Update has a better preview of changes.

  30. Questions

More Related