Trajectory modelling of publishing costs using Open Research Information - An open source analytics pipeline
Description
Through a project initially supported by IReL and building from previous work undertaken by the Curtin Open Knowledge Initiative and Invest in Open Infrastructure, we have built a system for examining the costs of potential future scenarios, based on cost parameters calculated from available data. In this analysis we use the example of the Council of Australasian University Librarians (CAUL, the Australia-Aotearoa New Zealand library consortium) and Bibsam (the Swedish library consortium) to demonstrate a system that implements this analysis.
Notes
Code and data availability
The main public data used as primary sources is detailed in Table 1. All code, including SQL templates, configuration files, the python visualisation library and resulting graph images and aggregate CSV files supporting them are available at https://codeberg.org/TwoBirds/dbt-cost-model
All intermediate tables generated by the code (including all record-level tables) are available in Google Big Query:
https://console.cloud.google.com/bigquery?ws=!1m4!1m3!3m2!1ssos-project-space!2sBibsam_2026 (Bibsam)
https://console.cloud.google.com/bigquery?ws=!1m4!1m3!3m2!1stwobirds-463608!2scaul_2026 (CAUL)
An interactive version of the trajectory modelling, including baseline values and preset parameters for the OA scenarios described in this paper, is available as Google Spreadsheet (for Bibsam):
https://docs.google.com/spreadsheets/d/1l3bvOr4oI_ON3kETbYSlZcuC-O1br8NApWABSX3WpyY/copy
Files
TRAJECTORY MODELLING OF PUBLISHING COSTS USING OPEN RESEARCH INFORMATION - 202607 v1.pdf
Files
(5.1 MB)
| Name | Size | Download all |
|---|---|---|
|
md5:2bafdad02ab34a8c1358be4ac3517b3c
|
5.1 MB | Preview Download |
Additional details
Software
- Repository URL
- https://codeberg.org/TwoBirds/dbt-cost-model
- Programming language
- SQL , Python