2024-12-10 Better Sample Data Meeting notes

1. Letter to Risk Office at Michigan State University Libraries

2. Stanford is working on sample authority data to be ready soon for the snapshot environment.

Follow up on activities since last meeting:

3. Update on - Golden copy for Bugfest environment.

4. Update on - Work on a small data set for FOLIO Snapshot.

5. Update on POC findings - write robust data anonymization scripts

Finalized the letter for the MSU dean.

Autumn Faulkner- Update on Slack: “I have passed along the letter to our Dean who will take it to the Risk Management office. Hope to have updates for you soon but these processes generally drag on forever so we'll see.”

Questions from Shelley Doljack :

Some questions that came to mind today are:

• anonymize all data? or specific data? Shelley will start with the list coming out of the POC. The end goal would be to anonymize all data.

  • names, addresses, phone number

  • locations

• anybody have inventory data or MARC data that's not supposed to be shared? (e.g. not allowed to export to shared bibliographic utilities?) Does anonymizing matter?

  • E.g. notes, local tags, digital book plate information, donor information

  • This working group should provide the guidelines for this. Shelley asks - where the tool need to be flexible.

• donor or bookplate data in MARC tags? Or other inventory record fields?

  • yes

• any donor info at all?

• are circulation rules supposed to be anonymized? We will come back to that topic next time.

• When shuffling inventory data to preserve loan patterns, how do we ensure that open loans adhere to the circ rules for testing things like bills, notices, aging to lost, etc.?

Lee’s group will be tied up in Ramsons and Sunflower work.

Lee suggests to focus on one area; e.g. Patron and usergroups data. Can use a tool to fake data (names, phone numbers, addresses - all PII data).

Lee met with Shelley yesterday. The work is estimated to be 2 developers for 3-4 sprints + part time tester. Shelley will be able to contribute with max 10 hours a week. Shelley has worked previously in Phython. Tod mentioned that maybe Chicago could contribute with a Phyton developer too. Will come back to this in the new year. Shelley, Yogesh, Noah, and Lee will meet every Monday. Will add to this agenda a short update from these Monday-meetings.

There is several scrambling tools available.

• Tod suggests: https://pypi.org/project/Faker/

• See example from the chatt (in the comment box below)

Shelley would need to have the technical requirements written up. Will start with the document provided by Lee and his project on the POC. Contributing institutions will need to stand up a second test environment.

Tod explained that Chicago would store into a local postgreSQL data base and then run the anonymization. Can maybe use the test and migration script. This would be a conversation with the hosting provider (here Index Data). Then extract the anonymized data set.

Eventually will the tool need to run a test environment.

Shelley asked about the tenant, and the tenant IDs? Is the reference environment to be a multi tenant environment - Chicago, Stanford, MSU. The current Bugfest environment is a single tenant environment.

Tod pointed out that data from all three institutions would cause inconsistency in the use of reference data. Tod thinks specifically on locations; but also the use of item material types.

Shelley asked if multi tenant environment would mean that each institutions had their own reference data.

Will a solution be to have multiple stand alone environments (A, B, and C)? Yogesh confirmed. Merging data would be phase 2.

Yogesh has been in a call with the ARLEF group on anonymization.

a. Golden Copy / Yogesh Kumar

Golden copy has ~8-9 Million instances.

For performance testing the PTF testing they have a larger environment with 20 mio instances.

The environment was created by the Kitfox team and updated by QA. Yogesh' QA team removed a number of duplicates in the Ramsons environment.

b. Snapshot environment. Update from Charlotte Whitt: Still waiting for the environment - monthly build environment: https://folio-quesnelia.dev.folio.org/ to be built.

The Jira ticket for creating https://folio-quesnelia.dev.folio.org/ is FOLIO-4071

Any update? Yes, ticket is now In progress.

Status:

Autumn has provided sample data for music records and serials records with multiple holds and multiple items. Holdings statements to be added.

These records are loaded to this groups shared drive.

Write up Data Import Job profiles - Kristin Martin?

KEM: once reference environment is available, I will work on DI profiles.

Data Import Job Profile which can import ~ 100 bibs in MARC 21 and create instance, holdings, item (corresponding to the locations we have set up). MM-SIG eyes on the 100 bibs. That these records has the right mix of misc. types, to cover the basic; incl. bound-with.

Stanford has MFHD-formed holdings data in the current export workflow. Alissa Hafele mentioned that Stanford could probably provide these data. Maybe ~25-50 examples—In progress. Any update? Alissa: I have put data in the drive in a new folder - 30 instances with corresponding MARC Holdings records and FOLIO Holdings records (can be identified by lack of $s in 999). Records still include Stanford specific locations. Also included is a link to spreadsheet with reasons for picking the records. Just let me know if there are any questions or if we need to tweak the export format!

Then later we can move on to Order/Order lines data. We will ask the Acquisition SIG (Kristin Martin will take the lead on this), the ERM-SIG to review the entered data - waiting for initial env. and data to be added.

c. Anonymization script

• see also Shelley Doljack questions above.

Update: from Lee Braginsky

Presented this for the Community Council. This resulted in an engaged discussion. Lee have gotten positive response from a student from University of Colorado, who would be willing to work on this. The need is 2 developers from the community with Java/SQL and the knowledge of FOLIO Schematool to anonymize the data for 2 sprints. Alternative do Python.

When Stanford is ready to deliver data, Yogesh and Lee can set up a meeting. Alissa will check with her colleagues.

Lee Braginsky Can we make the anonymized POC slide deck available in the WG folders? Is the POC code in Github? Yogesh to follow up. /wiki/spaces/DQA/pages/409108481

2. Review timeline document

• Draft - timeline document -

Nothing new to report

3. Other topics

?