TDM Bibliographic References 5.4
From ICISWiki
9 BIBLIOGRAPHIC REFERENCES
J.G.F.Lieshout and J.W. White
9.1 INTRODUCTION
ICIS is not intended to be a reference management system or to provide a complete crop research bibliography. However, whenever possible, users are encouraged to link data to publications. This is particularly important for full documentation of methods, such as in the GMS or in defining traits in the DMS. The variables are defined to facilitate import or export of documents using AGRIS (Marinelli, 1997) or RIS formats (Research Information Systems, 1994). Tables where references may be recorded are listed in Table 9.1.1
Table 9.1.1. Tables of ICIS where bibliographic references may be provided.
Table Type of reference GMS_METHODS Reference for crossing, mutation or transformation method DMS_METHODS Reference for measuring (equipment) method CONVERSIONS Reference for conversions between scales LOCATION_DESCRIPTORS Defines a descriptor for characterising locations STUDIES Reference(s) for a study
References are stored in the table BIBLIOGRAPHIC_REFS and are linked to other tables through the BIBLIOGRAFIC_REF_ID and the REFERENCE_LINK table. The field REFERENCE_ TYPE is linked to the UDFLDS table.
9.2 DATA STRUCTURE OF THE BIBLIOGRAPHIC_REFERENCES TABLE
Description of the BIBLIOGRAPHIC_REFERENCES Table (BIBREFS).
Field name Description Type Length
REFID BIBLIOGRAPHIC_REF_ID Unique identifier for each reference. Integer 4
PUBTYPE PUBLICATION_TYPE. Type of publication: book, book chapter, journal article etc.
The chosen type determines the field-description in your data input-screen.
Link to the UDFLDS table. Integer 2
PUBDATE PUBLICATION_DATE Date of publication. Only year in most cases YYYMMDD. Integer 4
AUTHORS AUTHORS Authors as they appears on the document, separated by a “;” Char 100
EDITORS EDITORS Names of the editors. Formatted as for AUTHORS. Char 100
ANALYT ANALYTIC_TITLE Title of the article /chapter / paper / file. Char 255
MONOGR MONOGRAPHIC_TITLE Title of the journal / book / proceeding / photo. Char 255
SERIES SERIES_TITLE Title of the real series. Char 255
VOLUME VOLUME_NUMBER Volume number. Char 10
ISSUE ISSUE_NUMBER Issue number. Char 10
PAGECOL PAGE_COLLATION Pages in the format 2-5 or 31-35,37. Char 25
PUBLISH PUBLISHER Name of the publisher. Char 50
PUCITY PUBLISHER_CITY City of publication. Used for books, proceedings, experiment
station reports, but not for journals. Char 30
PUCNTRY PUBLISHER_COUNTRY Country of publication. Char 50
To ensure that the many “one to many” bibliographic references relationships can be handled adequately, the REFERENCE_LINK table will be used.
Description of the REFERENCE_LINK table (REFLINKS).
Field name Description Type Length BREFID Link to REFID in the BIBREFS table. Integer 4 BTABLE TABLE. The table the reference is pointing to. Link to the UDFLDS table. Integer 2 BRECORD IN_TABLE_RECORD. Link to the key field in the referenced table. Integer 4
In case you want to link a bibliographic reference to a table which does not contain a key field, e.g., the NAMES table in GMS, that table should contain an attribute field, containing the BIBREFID for a direct link to the BIBLIOGRAPHIC_REFS table.
Full listing of the PUBLICATION_TYPES in the BIBLIOGRAPHIC_REFS table, as defined in the USER DEFINED_FIELDS table.
REFERENCE_TYPE REF_TYPE_DESCRIPTION ABST Abstract ADVS Audiovisual material ART Art work BILL Bill/Resolution BOOK Whole book CASE Case (e.g. legal) CDROM CD-ROM (compact disk) CHAP Book chapter COMP Computer program CONF Conference proceeding CTLG Catalog DATA Data file FTP FTP site GEN Generic HEAR Hearing INPR In press JFULL Journal (full) JOUR Journal MAP Map MGZN Magazine article MPCT Motion picture MUSIC Music score NEWS Newspaper PAMP Pamphlet PAT Patent PCOMM Personal communication PHOTO Photograph RPRT Report SER Serial (Book, Monograph) SLIDE Slide (transparency) SOUND Sound recording STAT Statute THES Thesis/Dissertation UNBILL Unenacted bill/resolution UNPB Unpublished work VIDEO Video recording WWWPG Page of the World Wide Web
