Main Library Home | Site Map | UWI | Cave Hill Libraries
Main Library, UWI(Cave Hill, 
Barbados)

Concepts In Database Searching: A Quick Guide

Search Strategy   
Boolean Searching    Keyword Search    Subject Search    Parentheses    Phrases    Proximity Searching
Relevance Ranking    Reserved Terms & Characters    Stopwords    Truncation    Wildcards

Databases, A-Z    Reference Service    Research Assistance

Search Strategy


Boolean Searching

The Boolean operators OR AND NOT (also called logical operators) are used to combine search terms.
OR will retrieve records with any of your search terms
     folklore or barbados retrieves records in which either word appears
AND will retrieve records with all of your search terms
     folklore and barbados retrieves records in which both words appear
NOT is used to exclude terms
     folklore not barbados retrieves records in which 'folklore' appears and 'barbados' does not
When more than one boolean operator is used in a single search string, use parentheses.


Keyword vs. Subject Searches

A keyword search retrieves records in which the search term appears in any field of the record. Also known as a free text search, any term may be used in a keyword search. The subject search is a narrower search. A subject search retrieves records in which the search term appears in the subject field of the record. It requires the precise subject heading or descriptor from the controlled list used by the database. You will need to browse the database index to determine the correct term.

Parentheses

When more than one boolean operator is used in a single search string, use parentheses to establish the order in which the searches are combined and executed. Searches enclosed in parentheses are executed first.
To search for either 'women' or 'gender' in 'Barbados', enter (women or gender) and barbados
Compare women or (gender and barbados)

To search for either 'women' or 'gender' in either 'Barbados' or 'Trinidad', enter
(women or gender) and (barbados or Trinidad)


Phrases

Enclose phrases in quotation marks
Depending on the database, entering academic achievement may execute:
a boolean OR (academic or achievement), or,
a boolean AND (academic and achievement)

To search for academic achievement as a phrase, enter "academic achievement"

Proximity Searching

The proximity operator, usually (N)EAR, is used to search for terms within a record that are in proximity to, or near to, each other.
tax n reform retrieves records in which the term 'tax' appears next to the term 'reform'. The word order is not specified
Databases often allow the option to specify the number of intervening words that may appear between the search terms.
tax n5 reform retrieves records in which the two terms appear within 5 words of each other, e.g., records with the phrase 'reform of income tax'
Some databases also offer the proximity operator, (W)ITHIN. WITHIN works in a similar fashion to NEAR, except that the word order is specified.
tax w5 reform will retrieve records with the phrase 'tax and the reform', but will not retrieve records with the phrase 'reform of income tax'


Stopwords / Reserved Terms & Characters

Stopwords are words that will retrieve too many hits, and are therefore not normally indexed for searching. Examples include 'their' 'for' 'of'. Reserved terms and characters are terms and characters that the database reserves for its own use, and are not normally used as search terms. Examples include 'or' and 'near' which are normally reserved for boolean and proximity searching respectively.

Databases sometimes make special provision for searching these terms. Consult the database documentation or help files.


Truncation

Use truncation to search on the stem of a word
Truncation symbols vary with databases. Check the database documentation or help files for the correct symbol. The following example uses the asterisk (*) as the truncation symbol.
alcoho* retrieves records in which the terms 'alcohol' 'alcoholic' 'alcoholics' and 'alcoholism' appear.