Skip to main content

Thoth CDN Update

1. Overview and Context

This procedure updates the Thoth_CDN table in the SQL Database.

2. Triggers

The execution of this procedure is usually triggered by

3. Steps to Be Performed

3.1 Download

The CDN operated by Thoth provides access to our PDF files (books.punctumbooks.com). The CDN also generates usage metrics. They are provided on a quarterly basis by Javi from Thoth Open Metadata until an automated system is developed.

3.2 Clean

  • delete the column event_uri
  • in work_uri, remove the DOI prefixes and .1.00 at the end such that only the PBN remains (make sure the format is set to "Text" to preserve the initial zero)
  • double check that all PBNs are correct (with initial zero)
  • delete the rows with the other publishers

3.3 Upload

  • Upload to the phpMyAdmin table "Thoth_CDN"
  • select Import tab;
select file click "Go."

4. Additional Information

5. Document Control

Document ID PRO-043
Document Owner Vincent
Version 1.0
Last Date of Change March 26, 2026
Next Review Due Date
Version & Change Tracking