Transcript DBTextWorks Tutorial - SJSU | School of Information

CREATING A DATABASE
USING DB/TEXTWORKS
LIBR 202
Richard Jackson
DB/TextWorks

A Database Management System (DBMS) made by
Inmagic

Instructions for downloading:
http://slisweb.sjsu.edu/ecommunication/IMDown.htm
Two steps in creating a database

Database Designer
Creates the data structure

Database Maintainer (Indexer)
Populates the database with records
Designing the Database

Primary decisions
 Purpose
of the database
 Nature of its users

Set up the fields using the DBMS
 Field
name
 Type of data contained in the field
 How the field is to be indexed
 Limits on values that can be entered (“validation”)
Adding Records to the Database

For each document in the collection, the indexer
creates a record

Appropriate field values are entered according to
the rules for standards for the database

Records will be added (and sometimes updated or
deleted) through the life of the database
A collection of rocks ...
Indexing

A field must be indexed in order to be searchable

A field can be Term indexed or Word indexed
Term Indexing
Each field value is indexed as a single entry
Records
#1
Color: Dark gray
#2
Color: Black
#3
Color: Gray
#4
Color: Dark brown
#5
Color: Pink
Index for Color field
Black
#2
Dark brown
#4
Dark gray
#1
Gray
#3
Pink
#5
Word Indexing
Each word in the field value is separately indexed
Records
#1
Note: Found at Montana del
Oro; perfect skipping rock.
#2
Note: Obsidian.
#3
Note: Found in northern New
Mexico, 1967. Rose quartz
with a piece of mica
embedded in it.
Index for Note field
1967
at
del
embedded
found
it
mexico
mica
montana
new
northern
obsidian
oro
perfect
piece
quartz
rock
rose
skipping
with
#3
#1
#1
#3
#1, #3
#3
#3
#3
#1
#3
#3
#2
#1
#1
#3
#3
#1
#3
#1
#3
For more information …

Review the 202 Online Resource:
http://slisweb.sjsu.edu/courses/202/index.html

Search DB/TextWorks Help
 Click
Help > Help Topics, or press F1
 Click the Index tab to browse or search for help topics

As always, post any questions on Blackboard