Search Strategies for Database Advisor
This page explains the precise technical search strategies used and fields searched for each database in Database Advisor. For help in formulating the best search strategy to meet your needs, consult the help files provided by the database you have chosen. Your own use of these databases may produce results that differ from DBA's if your search strategy differs from ours. Our goal in designing these search strategies was to try to achieve an an equivalent search of title words, abstract words, and subject terms in each database. This was not always possible, of course, because of the differences in the fields available and the way in which each database searches these fields.
To achieve uniformity across databases, DBA's search strategies are by necessity rather generic. In many cases more precise searches can be performed in each database. Database Advisor guides you in choosing a database, it does not perform the most precise search possible in each database. We recommend that you refine your search as appropriate for each database you use.
There are two types of databases that DBA searches. The search strategy for each type is discussed below, along with a list of the databases that fall in each catagory.
Z39.50 -
This is a type of database request protocol. It is specialized for retrieving data
and is also a fast interface. Most of the MELVYL® databases are hooked up to a Z39.50
interface. All databases that we access via Z39.50 are searched the same way. In the case of MELVYL databases, our search replicates a FIND KEYWORD search.
- Z39.50 Search Strategy
- FIND ANY/P:A/S:WORD_L/T:100 word1 AND ANY/P:A/S:WORD_L/T:100 word2 ...
- FIND ANY: Find using the indexing protocol ANY (subject, title, abstract)
- P = Position: A = Any place in the field (first word, second word, etc...)
- S = Structure: WORD_L = Word List
- T = Truncation: 100 = Off
- Note: This type of search is called a keyword search in MELVYL.
- Databases Searched by Z39.50
- ABI/Inform
- BIOSIS and Backfiles (BIO88)
- Current Contents
- COMP: Computer Articles
- INSPEC and Backfiles
- MAGS: Magazine & Journal Articles
- MEDLINE PLUS and Backfiles
- NEWS: Newspaper Articles
- PsycINFO
Web Search Strategies -
The MELVYL keyword search is what we considered "ideal". It searches for any of the
search terms in any of the following fields: subject, title, and abstract. Each of the
search terms must be present in at least one field, but need not be present in all fields. Because most web databases search each field separately, this is difficult to duplicate without multiple searches on the same topic. At times, we were forced to AND the search terms together and perform
a boolean OR between the search fields. This requires all the words to appear in at least one field, which is more restrictive than the MELVYL keyword search. We hope that this will yield the best results to the user. Database specific strategies are listed below.
- AGRICOLA
- In the Subject Search All years
field: word1 AND word2 ...
- ASFA (Current and Archives)
- In the Box for Experts field: de=(word1 AND word2 ...) or ab=(word1 AND word2 ...) or ti=(word1 AND word2 ...)
- Applied Science and Technology Abstracts
- (word1 AND word2 AND word3 ...) in ti,de,ab
- Note: This searches the title, descriptors, and abstract
(like a Melvyl keyword search)
- Arctic & Antarctic Regions
- In the Basic Search field: word1 AND word2 ...
- Then press Search and Display Record
- Commerce Business Daily
- subject=(word1 AND word2 AND ...) OR desc=(word1 AND word2 AND ...)
- Note: We execute the search on this database via their
power search option
- CIS
- Currently unavailiable due to renovation
- COMPENDEX and COMPENDEX Backfiles
- (word1 AND word2 AND word3 ...) in ti,su,ab
- Note: This searches the title, subject, and abstract
(like a Melvyl keyword search)
- DOE Reports
- In the Search Text field: a=word1 AND word2 AND ... OR b=word1 AND word2 AND ...
- Here, "a" is a title search, and "b" is a keywords search
- Earthquake Engineering Abstracts
- In the Title field: word1+word2+...
- In the Keywords field: word1+word2+...
- Note: We OR these fields together for our search
- Britannica Online
- In the Articles field: word1 AND word2 AND...
- ERIC
- In the Any field: word1+word2+...
- Note: AND is assumed between the terms
- Engineering Materials Abstracts (EMA)
- In the Box for Experts Field: de=(word1 AND word2 ...) or ab=(word1 AND word2 ...) or ti=(word1 AND word2 ...)
- de = descriptors: This is a list of words that serve as a subject listing
- ab = abstract
- ti = title
- GeoRef
- FIND S word1 word2 ...
- S - Titles of articles, papers; Words from abstracts; and Subject
descriptors from GeoRef thesaurus
- Note: AND is assumed between the terms
- Marine, Oceanographic & Freshwater Resources
- In the Basic Search field: word1 AND word2 ...
- Then press Search and Display Record
- MathSciNet
- In the Review Text field: word1 AND word2 AND ...
- In the Title field: word1 AND word2 AND ...
- Note: We OR these fields together for our search
- METADEX
- In the Box for Experts Field: de=(word1 AND word2 ...) or ab=(word1 AND word2 ...) or ti=(word1 AND word2 ...)
- de = descriptors: This is a list of words that serve as a subject listing
- ab = abstract
- ti = title
- MGA: Meteorological & Geoastrophysical Abstracts
- In the Basic Word index: word1 AND word2 AND ...
- NASA Reports & Aerospace Literature
- In the Title field: word1 AND word2 AND ...
- In the Abstract field: word1 AND word2 AND ...
- In the Subject field: word1 AND word2 AND ...
- Note: We OR these fields together for our search
- National Science Foundation Funded Projects
- In the Quick Search field:word1 AND word2 AND ...
- PREMEDLINE
- In the keyword index: word1 AND word2 AND ...
- Zoological Record
- Searches title, description and abstract fields
- Note: AND is assumed between the terms
Available source code