Chapter 17. The RefDB database design

Table of Contents

The table t_journal_words
The table CITSTYLE
The table REFSTYLE
The table POSITION

The RefDB database is a helper database for the RefDB reference databases. It holds data for the recognition of unabbreviated words in journal names as well as the bibliography style information.

The table t_journal_words

This table holds a list with unabbreviated journal words. These are words in the names of journals which are not an abbreviation of something else. Many online sources of bibliographic information provide the journal information without periods so it is not clear whether a word in a journal name is complete by itself or whether it is an abbreviation. Some bibliographic formats ask for periods after abbreviated words, so we have to get these periods from somewhere. RefDB adds the periods if necessary when a reference is added to the database. This way you have the additional information that the periods provide always at your hands. If you don't need it, it is trivial to strip the periods away.


An alphanumeric field (maximum length 255 characters) that holds a word in uppercase which is an unabbreviated word in a journal name.