Computer Science Publication Database Augmented from DBLP

Extracted from dblp (https://dblp.org), and augmented with data from openalex (https://openalex.org). Stored as an SQLITE database with the given schema: CREATE TABLE IF NOT EXISTS authors ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, orcid TEXT, dblp_id TEXT, openalex_id TEXT ); CREATE TABLE IF NOT EXISTS institutions ( id INTEGER PRIMARY KEY, openalex_id TEXT NOT NULL UNIQUE, name TEXT NOT NULL, country_code TEXT ); CREATE TABLE IF NOT EXISTS venues ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, dblp_key TEXT NOT NULL, short_name TEXT NOT NULL, venue_type TEXT NOT NULL ); CREATE TABLE IF NOT EXISTS articles ( id INTEGER PRIMARY KEY, title TEXT NOT NULL, doi TEXT, year INTEGER NOT NULL, venue_id INTEGER NOT NULL, dblp_key TEXT NOT NULL UNIQUE, FOREIGN KEY (venue_id) REFERENCES venues (id) ); CREATE TABLE IF NOT EXISTS article_authors ( article_id INTEGER NOT NULL, author_id INTEGER NOT NULL, PRIMARY KEY (article_id, author_id), FOREIGN KEY (article_id) REFERENCES articles (id), FOREIGN KEY (author_id) REFERENCES authors (id) ); CREATE TABLE IF NOT EXISTS author_institutions ( author_id INTEGER NOT NULL, institution_id INTEGER NOT NULL, PRIMARY KEY (author_id, institution_id), FOREIGN KEY (author_id) REFERENCES authors (id), FOREIGN KEY (institution_id) REFERENCES institutions (id) ); CREATE INDEX IF NOT EXISTS idx_authors_name ON authors (name); CREATE INDEX IF NOT EXISTS idx_authors_dblp_id ON authors (dblp_id); CREATE INDEX IF NOT EXISTS idx_articles_year ON articles (year); CREATE INDEX IF NOT EXISTS idx_articles_venue ON articles (venue_id); CREATE INDEX IF NOT EXISTS idx_venues_dblp_key ON venues (dblp_key);