Menu path

Data Preparation > Database > ISI > Merge Document SourcesThis algorithm does not exist on the menu, but rather is run automatically when the ISI database is loaded into the tool.

Outputs

A database where the identified identical journals have been merged.

The merging table used to merge the identical journals . This can be used to rerun the merge manually, likely to correct for errors, with Merge Entities.

A Merge Report as a text file. It will give a simple description all the journals who were merged, identified by their value for the TWENTY_NINE_CHARACTER_SOURCE_TITLE_ABBREVIATION and FULL_TITLE columns.

...

The merging is performed as indicated in Merge Entities.This algorithm uses an the authoritative journal merging list (AJML)that can be found in the Sci2 tool's configuration folder as JournalGroups.txt. . It will first "normalize" the FULL_TITLE column from the SOURCE table. For this article, "normalize" means to convert the value of the column to lower case and remove all leading and trailing spaces. the Sources Table table. If the AJML contains this normalized value, all journals with the AJML's matching value will be merged together.If the normalized FULL_TITLE column is not found in the AJML, the TWENTY_NINE_CHARACTER_SOURCE_TITLE_ABBREVIATION column from the SOURCESources Tabletable will be "normalized"normalize. If the AJML contains this normalized value, all journals with the AJML's matching value will be merged together. If ; if it is does not found in contain the AJMLnormalized value, then the normalized value for the TWENTY_NINE_CHARACTER_SOURCE_TITLE_ABBREVIATION column will be used and all entries with the same value will be merged. In the case that an entry does not contain a value for the TWENTY_NINE_CHARACTER_SOURCE_TITLE_ABBREVIATION column, a random, unique value will be used for the merging.

Definitions

Normalize

For this article, "normalize" means to convert the value of the column to lower case and remove all leading and trailing spaces.

Authoritative Journal Merging List (AJML)

A mapping from an Authoritative Journal Name to other common names for the journal. It can be found in the Sci2 tool's configuration folder as JournalGroups.txt.