Birth of a Database

1
Birth of a Database

• Newfoundland and Labrador Health Bibliography
• A labour of love

2
Introduction

• The Bibliography of Health Care in Newfoundland
  published 1986.
• Sabbatical leave 2004-2005
• Goal Update the Bibliography and create a
  searchable database available on the Web

3
Background

• 1991Original file was converted to the Spires
  database management system
• Did the file still exist?

4
Design the Database

• Select the software
• Reviewed the literature
• Consulted Systems at QE II

5
Design the Database

• Unicorn II Database Properties
• One Format
• HEALTHBIB
• One Template
• Lists all the fields

6
Design the Database

• Document types
• 4 document types in the original file
• Article
• Book
• Chapter
• Thesis

7
Design the Database

• Fields
• Assign fields to the 4 document types
• Flexibility
• Searching
• Display of information
• Output

8
Fields

• Original 12 Fields
• ID
• Category
• Author
• Title
• Found.In
• Volume
• Number
• Pages
• Publisher
• Address
• Subject
• Print Date

• Revised Fields
• Record No
• Document Type
• Author
• Title
• Publication Info
• Volume
• Number
• Pages
• Publisher
• Place
• Subject
• Date

9
22 New Fields

• Other Title
• Journal Abbrev
• General Note
• General Subject
• Publication Date
• Original No
• Language
• ISSN
• Unique ID
• Article ID
• Availability

• Copy Note
• Journal Title
• Edition
• Publisher
• Place
• Added Author
• Series
• ISBN
• Main Author
• Main Title
• Dissertation Note

10
Repeatable Fields

• Author
• Added Author
• Main Author
• General Note

• ISBN
• ISSN
• Series
• Subject
• Availability

11
Journal Title Field

• Add the full journal titles
• Sample from Journal Title file
• Abdom SurgAbdominal surgery
• Appl Nurs ResApplied nursing research ANR
• Can Fam PhysicianCanadian family physician
  Médecin de famille canadien Can Med Assoc
  JCanadian Medical Association journal
  CMAJCMAJ Canadian Medical Association journal
  journal de lAssociation médicale canadienne
  Nurs PapNursing papers Perspectives en
  nursing Polar Rec (G Brit) The Polar record
• Progr Med (Paris) Le Progrès médicale

12
Availability Field

• Links
• Memorial holdings
• Links to the catalogue records were added using
• ISSN
• ISBN
• Control numbers
• Full-text
• Links using DOI

13
Design the Database

• MARC tags
• MARC tag required for each field
• Not a cataloguer

14
MARC Tags

• 001 Record No
• 008 Date
• 012 Document Type
• 014 Unique ID
• 020 ISBN
• 022 ISSN
• 100 Author
• 210 Journal Abbrev
• 222 Journal Title
• 242 Other Title
• 245 Title
• 250 Edition
• 260 Publisher
• 270 Place
• 440 Series
• 500 General Note

• 502 Dissertation Note
• 512 Volume
• 517 Number
• 519 Pages
• 529 Publication Date
• 546 Language
• 650 Subject
• 695 General Subject
• 700 Added Author
• 704 Main Author
• 730 Main Title
• 773 Publication Info
• 851 Article ID
• 856 Availability
• 890 Copy Note
• 891 Original No

15
Design the Database

• Limits
• Assign limit fields
• Three fields were selected
• Year
• Document Type
• Language

16
Design the Database

• Indexes
• Create Keyword and Browse indexes
• Author
• Title
• Journal
• Subject
• Everything
• Assign fields to each index

17
Indexes

• Author Index
• Author
• Added Author
• Main Author
• Title Index
• Title
• Other Title
• Main Title
• Series

• Journal Index
• Journal Abbrev
• Journal Title
• Subject Index
• Subject
• General Subject
• Everything

18
Design the Database

• Style
• Vancouver style
• MeSH headings assigned as subjects
• General Subjects
• broad subject categories based on NLM
  classification outline, e.g.
• Pediatrics, Cardiovascular System

19
Design the Database

• Display of Records
• Four display views
• Hit list of results
• Full view (default)
• Brief
• All
• Define the displays for the 4 record types

20
Hit List
21
Brief View
22
Full View
23
Full View

• Link to Full-Text

24
Full View

• Link to PDF

25
Full View

• Link to Catalogue

26
Full View

• Link to Catalogue

27
All View
28
Build the Database

• September 2004
• Systems added a new database to the UnicornII
  system
• Problems
• Generic framework customization needed
• No records

29
Build the Database

• November 2004
• Spires records were uploaded to WF
• Numerous problems
• Obtained text file of Spires records
• December 2004
• Records had been dumped and reloaded twice in WF

30
Build the DatabaseHow to Proceed?

• Problems with the database
• Lack of WF experience
• Decision
• Work with the text file (original records)
• Upload it later to WF

31
Original Spires record

• ID 1
• CATEGORY Article
• AUTHOR P W Allderdice
• AUTHOR N Browne
• AUTHOR D P Murphy
• TITLE Chromosome 3 duplication q21 qter
  deletion p25 pter syndrome in
• children of carriers of a pericentric inversion
  inv(3)(p25q21).
• FOUND.IN Am J Hum Genet
• VOLUME 27
• NUMBER 6
• PAGES 699-718
• SUBJECT Chromosomes, Human, Pair 3
• SUBJECT Inversion (Genetics)
• SUBJECT Chromosome Aberrations
• SUBJECT Chromosome Abnormalities
• SUBJECT Genetics
• ENTERED 04/25/1991
• MODIFIED 01/26/1996

32

• Original record
• ID 1
• CATEGORY Article
• AUTHOR P W Allderdice
• AUTHOR N Browne
• AUTHOR D P Murphy
• TITLE Chromosome 3 duplication q21 qter
  deletion p25 pter syndrome in children of
  carriers of a pericentric inversion
  inv(3)(p25q21).
• FOUND.IN Am J Hum Genet
• VOLUME 27
• NUMBER 6
• PAGES 699-718
• SUBJECT Chromosomes, Human, Pair 3
• SUBJECT Inversion (Genetics)
• SUBJECT Chromosome Aberrations
• SUBJECT Chromosome Abnormalities
• SUBJECT Genetics
• ENTERED 04/25/1991
• MODIFIED 01/26/1996

• New version of record
• RECORD NO 1
• DOCUMENT TYPE Article
• AUTHOR Allderdice PW
• AUTHOR Browne N
• AUTHOR Murphy DP
• TITLE Chromosome 3 duplication q21 leads to
  qter deletion p25 leads to pter syndrome in
  children of carriers of a pericentric inversion
  inv(3)(p25q21).
• JOURNAL ABBREV Am J Hum Genet
• VOLUME 27
• NUMBER 6
• PAGES 699-718
• SUBJECT Chromosomes, Human, Pair 3
• SUBJECT Inversion (Genetics)
• SUBJECT Chromosome Aberrations
• SUBJECT Chromosome Abnormalities
• GENERAL SUBJECT Genetics
• DATE 1975
• PUBLICATION DATE 1975 Nov

33
Build the Database

• New Content
• Criteria for inclusion
• Basically unchanged
• Term health - used in the broadest sense
• Range of material
• Primarily journal articles

34
Build the Database

• Journal Articles
• Search databases
• Hand search journals
• Obtain hard copy of articles
• Determine if article is relevant
• Check bibliographies for additional material
• Create a template for adding new records

35
Template for New Articles

• RECORD NO
• DOCUMENT TYPE Article
• AUTHOR
• AUTHOR
• AUTHOR
• AUTHOR
• TITLE .
• OTHER TITLE
• JOURNAL ABBREV
• VOLUME
• NUMBER
• PAGES
• GENERAL NOTE
• SUBJECT
• SUBJECT
• SUBJECT
• SUBJECT
• GENERAL SUBJECT

36
Build the Database

• September 2005
• File was ready to be uploaded to WF
• Now 2000 records in text file
• October 2005
• Records uploaded to WorkFlows
• Journal Title file uploaded

37
Implementation

• Fall 2005
• All records were now in WF
• Created a Webpage
• Created customized Help
• Next step
• Test
• Review

38
Implementation

• WF Problems
• Records missing
• Template
• Display and format of information
• Journal Titles did not map properly
• Search and Browse problems

39
Implementation

• WorkFlows
• File reloaded a number of times
• March 2006
• Final reload of records
• Manual edits

40
Manual Cleanup

• ALL 2000 records were edited at least once!

41
Manual Cleanup Journal Titles
42
Manual Cleanup Publication Info
43
Manual Cleanup - Chapters
44
Manual Cleanup Filing Indicators
45
Manual Cleanup - Accents
46
Manual Cleanup - Links
47
Manual Cleanup - Limits
48
Implementation

• Keyword
• Title
• Journal
• Subject
• Limits
• WorkFlows
• Search

• Browse
• Author
• Title
• Journal
• Subject
• Browse

49
Implementation

• Display
• Journal Title links
• Series
• Full View
• Browse Journal
• Search screen

50
Adding New Records in WF
51
Adding New Records in WF
52
Adding New Records in WF
53
Adding New Records in WF
54
Conclusion

• Launch of the database
• Can the remaining problems be resolved?
• What are the options?
• Time is running out!

55
Outcome

• Birth or Mutation or Abortion?
• Thank You

56
Outcome

• Birth or Mutation or Abortion?
• Thank You