Oppskrift for federerte søk i OVID - ved hjelp av “use”

Oppskrift mottatt fra Dave Kaunelis i CADTH, Canada:

You can limit a single search line within a search to a specific database or databases by using the Ovid field codes assigned to each database. Ovid database codes can be difficult to find so I have listed the codes for all databases that CADTH subscribes to (see end of this message). For other database, you may need to contact Ovid for the field code.

Removing duplicates:

First, prepare and save your individual database searches separately. Then open all the databases you have searched. This is what Ovid calls a multifile search. Run one of the searches, EMBASE 1980-present, for example.

EMBASE search
Line 1. dogs.ti
Line 2 cats.ti
Line 3. pigs.ti
Line 4. rabbits.ab
Line 5. or/1-4

Line 6. 5 use emez

Line 6 will limit the results of this part of the search to the Embase database only [emez is the 1980-present Embase field code]

Then run another of your individual database searches (Medline 1950-present, for example) with all databases still open.

MEDLINE search
Line 7. dogs.ti,ab
Line 8. cats.hw
Line 9. pigs.mp
Line 10. rabbits.ti,ab,hw
Line 11. or/7-10

Line 12. 11 use mesz

Line 12 will limit the results of this part of the search to the Medline 1950-present database.

Then run any other searches from other databases.

Then OR your results together (Line 6 or Line 12 or …)

Then remove duplicates.


You can also use this feature in other ways. See the example below for limiting specific lines within a multifile search to a specific database by using Ovid database codes.

exp tramadol/ [retrieves items from all databases open]
exp *tramadol/ use emef [retrieves items only from EMBASE]
tramadol.ti,ab,hw use prem,mesz,b10o89 [retrieves items from PreMedline, Medline, Biosis]


Ovid Database Codes
for 2010
(field codes in parentheses)

Biosis
BIOSIS Previews 1985 to 1989 (biol85)
BIOSIS Previews 1989 to present (b10o89) [note: this code changes yearly – the code for 2011 will likely be b11o89]

EBM Reviews
EBM Reviews - ACP Journal Club 1991 to September 2008 (acp)
EBM Reviews - Cochrane Central Register of Controlled Trials current update (cctr)
EBM Reviews - Cochrane Database of Systematic Reviews current update (coch)
EBM Reviews - Database of Abstracts of Reviews of Effects current update (dare)
EBM Reviews - Cochrane Methodology Register current update (clcmr)
EBM Reviews - Health Technology Assessment current update (clhta)
EBM Reviews - NHS Economic Evaluation Database current update (cleed)
The short code for ALL EBM Reviews is ebmz
The short code for EBM Reviews Full Text is ebmy

Embase
EMBASE 1996 to present (emef)
EMBASE 1988 to present (emed)
EMBASE 1980 to present (emez)
EMBASE 1988 to 1995 (emem)
EMBASE 1980 to 1987 (emeb)

ERIC
ERIC 1965 to present (eric)

Medline
Ovid MEDLINE(R) In-Process & Other Non-Indexed Citations and Ovid MEDLINE(R) 1950 to Present (prmz)
Ovid MEDLINE(R) 1950 to present (mesz)
Ovid MEDLINE(R) 1996 to present (medf)
Ovid MEDLINE(R) 1950 to 1995 (medb)
Ovid MEDLINE(R) In-Process & Other Non-Indexed Citations current (prem)
Ovid MEDLINE(R) Daily Update current (mesx)
Ovid MEDLINE(R) 2003 to present (medl)
Ovid MEDLINE(R) 1996 to 2002 (med3)
Ovid MEDLINE(R) 1980 to 1995 (med2)
Ovid MEDLINE(R) 1950 to 1979 (med1)
Ovid OLDMEDLINE(R) 1950 to 1965 (medo)

PsycINFO
PsycINFO 2000 to present (psya)
PsycINFO 1985 to present (psyf)
PsycINFO 1967 to present (psyb)
PsycINFO 1806 to present (psyh)
PsycINFO 1806 to 1966 (psy1)