| Main Library Home | Site Map | UWI | Cave Hill Libraries |
![]() |
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 |
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 termsWhen more than one boolean operator is used in a single search string, use parentheses.
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
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 specifiedSome databases also offer the proximity operator, (W)ITHIN. WITHIN works in a similar fashion to NEAR, except that the word order is 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'
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.
| Top of Page | Site Map | Main Library Home | UWI | Cave Hill Libraries |