Data Preparation > Database > ISI > Extract References By Year
Documents in ISI datasets will often specify a publication year and a set of references. Thus, it can be inferred that certain references will have been referenced x many times in certain years.
This algorithm extracts the full reference strings, primary keys from the ISI database, years they were referenced by documents included in the given dataset, and how many times they were referenced in those years out of an ISI database. The result is a table that consists of the following columns:
- Reference: The full, unaltered citation string found in the original ISI dataset.
- Reference ID: The primary key of the Citations Table record in the ISI database.
- Year: One of potentially several years this reference was cited by a document listed in the ISI dataset.
- Count: The number of times this reference was cited by documents listed in the ISI dataset for this year.
Load an ISI file into the tool, then create a database from it using the ISI database loader.
The specific query run by the tool can be found in the source code.