Assist UCB to retire resolver (nma.berkeley.edu)

[jsjiang]

Request from UCB:

Name: David Triebwasser Email: davidtriebwasser@berkeley.edu Institution: UC Berkeley Reason for contact: I have a problem or question about existing account Comment: We want to retire our resolver (nma.berkeley.edu). We would like to meet with a technical contact to discuss our options. We are interested in transition all the existing links to EZID if that's possible.

Comment from Dave: UC Berkeley has a number of prefixes including DOIs and ARKs. First step is getting more specifics on the request. Is this for all identifiers or a specific prefix (NAAN)?

[jsjiang]

Shoulders:

• ark:/28722/bk: no minter; UC Berkeley Legacy Library bk
• ark:/13030/hb: no minter; UC Berkeley Legacy Library
• ark:/13030/k6: with a minter; UC Berkeley/Digital Special Collections

Sample ARKs and location URLs: ark:/13030/hb - no minter:

• select * from ezidapp_identifier where identifier like 'ark:/13030/hb%' => returned 21031 records
• create time: most were between 2011-2016; one in 2018 and 2 in 2020
• URL patterns:

  ark:/13030/hb000000kt   http://ark.cdlib.org/ark:/13030/hb000000kt
  ark:/13030/hb000000mb   http://ark.cdlib.org/ark:/13030/hb000000mb
  ark:/13030/hb000000vz   http://merritt.cdlib.org/m/ark%3A%2F13030%2Fhb000000vz
  ark:/13030/hb000002hr   http://merritt.cdlib.org/m/ark%3A%2F13030%2Fhb000002hr

  ark:/13030/k6 - with minter:

• select from ezidapp_identifier table returned 90375 records
• create time: 2012-2021
• URL patterns:

  ark:/13030/k62n50f9 http://ezid.cdlib.org/id/ark:/13030/k62n50f9    2013-11-05 12:51:06 2016-07-13 12:53:48
  ark:/13030/k6xw4gzm http://ezid.cdlib.org/id/ark:/13030/k6xw4gzm    2013-11-05 12:51:10 2016-07-13 14:20:41
  ark:/13030/k6t43r7m http://merritt.cdlib.org/m/ark%3A%2F13030%2Fk6t43r7m    2013-11-05 12:51:42 2017-01-20 18:12:13
  ark:/13030/k6pc30jq http://ezid.cdlib.org/id/ark:/13030/k6pc30jq    2013-11-05 12:51:52 2016-07-13 13:55:07
  ark:/13030/k6jm27t0 http://ezid.cdlib.org/id/ark:/13030/k6jm27t0    2013-11-05 12:51:55 2016-07-13 13:41:54
  ark:/13030/k6dz06gj http://ezid.cdlib.org/id/ark:/13030/k6dz06gj    2013-11-05 12:51:58 2016-07-13 13:29:22
  ark:/13030/k6959frk http://merritt.cdlib.org/m/ark%3A%2F13030%2Fk6959frk    2013-11-05 12:52:00 2017-01-20 16:00:10

ark:/28722/bk - no minter

• select from the ezidapp_identifier table returned 316,580 records
• create time: 2011-2020
• URL patterns

  ark:/28722/bk0003d9r6q  http://ark.cdlib.org/ark:/28722/bk0003d9r6q 2011-09-09 14:57:40 2016-11-22 08:36:00
  ark:/28722/bk0003d908f  http://ark.cdlib.org/ark:/28722/bk0003d908f 2011-09-09 14:58:58 2016-11-22 08:35:33
  ark:/28722/bk0005z484z  http://merritt.cdlib.org/m/ark%3A%2F28722%2Fbk0005z484z 2011-09-09 20:11:47 2017-03-08 10:59:54
  ark:/28722/bk0005z543t  https://merritt.cdlib.org/d/ark:/28722/bk0005m5f6n  2011-09-09 20:11:49 2017-03-10 09:56:09
  ark:/28722/bk0005z4n56  https://merritt.cdlib.org/d/ark:/28722/bk0005m412r  2011-09-09 20:11:50 2017-03-10 09:53:07

[jsjiang]

From Dave: shoulders with record count

28722/bk = 513856 28722/h2 = 161

13030/ft = 10197 13030/k6 = 37951 13030/hb = 14866 13030/kt = 1503 13030/tf = 30757

ark_samples.xlsx

[adambuttrick]

Mapped to existing shoulder names in EZID. All shoulders appear to be known to us:

Shoulder	Shoulder Name	Count
ark:/13030/ft	Online Archive of California (OAC) Legacy ft	10197
ark:/13030/k6	UC Berkeley/Digital Special Collections	37951
ark:/13030/hb	UC Berkeley Legacy Library	14866
ark:/13030/kt	Online Archive of California (OAC)	1503
ark:/13030/tf	Online Archive of California (OAC) Legacy tf	30757
ark:/28722/bk	UC Berkeley Legacy Library bk	513856
ark:/28722/h2	UC Berkeley Library - HathiTrust/UCB	161

[adambuttrick]

Additional testing:

Shoulder	Test Result
ark:/13030/ft	Sample IDs do not resolve and do not appear to be in EZID. EZID has 416 total records under this shoulder, all of which belong to Merritt.
ark:/13030/hb	Sample IDs resolve and all belong to Merritt.
ark:/13030/k6	Sample IDs resolve and all belong to UCB library. Do not contain target/location URLs. Links provided are for the EZID records.
ark:/13030/kt	Sample IDs resolve and all belong to Merritt.
ark:/13030/tf	One ID (ark:/13030/tf00000195) known to us, resolves, and owned by Merritt. The rest do not resolve and do not appear to be in EZID.
ark:/28722/bk	Sample IDs do not resolve and do not appear to be in EZID. Search timed out, so unable to determine extent of records.
ark:/28722/h2	Sample IDs resolve and all belong to UCB library. Do not contain target/location URLs. Links provided are for the EZID records.

[jsjiang]

Shoulder and user relationships:

prefix	shoulderName	minter	username	userDisplayname
ark:/13030/ft	Online Archive of California (OAC) Legacy ft		merritt	CDL UC3 Merritt
ark:/13030/hb	UC Berkeley Legacy Library		ucb-genx	for use by GenX to mint EAD ARKs
ark:/13030/hb	UC Berkeley Legacy Library		merritt	CDL UC3 Merritt
ark:/13030/hb	UC Berkeley Legacy Library		ucrlibrary	UC Riverside Library
ark:/13030/hb	UC Berkeley Legacy Library		ucr-digi	UCR Library - Digital Initiatives
ark:/13030/hb	UC Berkeley Legacy Library		ucblibrary	UC Berkeley Library
ark:/13030/k6	UC Berkeley/Digital Special Collections	https://n2t.net/a/ezid/m/ark/13030/k6	cdldsc	CDL Digital Special Collections
ark:/13030/k6	UC Berkeley/Digital Special Collections	https://n2t.net/a/ezid/m/ark/13030/k6	ucb-genx	for use by GenX to mint EAD ARKs
ark:/13030/k6	UC Berkeley/Digital Special Collections	https://n2t.net/a/ezid/m/ark/13030/k6	merritt	CDL UC3 Merritt
ark:/13030/k6	UC Berkeley/Digital Special Collections	https://n2t.net/a/ezid/m/ark/13030/k6	ucblibrary	UC Berkeley Library
ark:/13030/kt	Online Archive of California (OAC)		merritt	CDL UC3 Merritt
ark:/13030/tf	Online Archive of California (OAC) Legacy tf		merritt	CDL UC3 Merritt
ark:/28722/bk	UC Berkeley Legacy Library bk		merritt	CDL UC3 Merritt
ark:/28722/bk	UC Berkeley Legacy Library bk		ucblibrary	UC Berkeley Library
ark:/28722/h2	UC Berkeley Library - HathiTrust/UCB	https://n2t.net/a/ezid/m/ark/28722/h2	ucb-genx	for use by GenX to mint EAD ARKs
ark:/28722/h2	UC Berkeley Library - HathiTrust/UCB	https://n2t.net/a/ezid/m/ark/28722/h2	ucblibrary	UC Berkeley Library

select s.prefix, s.name as shoulderName, s.minter,
u.username, u.displayName as userDisplayname from ezidapp_user u
join ezidapp_user_shoulders us 
on u.id = us.`user_id`
join ezidapp_shoulder s
on s.id = us.shoulder_id
where s.id in (
select id from ezidapp_shoulder where prefix in (
'ark:/28722/bk',
'ark:/28722/h2',
'ark:/13030/ft', 
'ark:/13030/k6', 
'ark:/13030/hb',
'ark:/13030/kt',
'ark:/13030/tf'
)) order by s.prefix;

[jsjiang]

Note: we need to assign an owner (user.id) to each ARK.