Comment on page
Postgres schema diagram
This is a diagram of one possible schema for storing the OpenAlex data in a relational database. It's the one used in our examples here, but may not be the best one for the ways you'll use the dataset.
(click to embiggen)
Last modified 6mo ago