Each database used should have the following information recorded:
See the section of this guide on 'Writing the review' for more detail reporting the details of your searches according to PRISMA.
It can also be useful to save your search strategies in the databases you use.
Systematic searching will require the collection of whole sets of results from databases to be reviewed. This part of the process needs to be planned as much as any of the other steps because the results will go through a number of screening stages to remove irrelevant and duplicate results. Using reference management software such as Endnote can help with organising and maintaining the search results. If using EndNote, the results for your systematic review project are best kept separate from your regular Endnote library. Set up a separate systematic review Endnote library. The Final steps section of this guide also contains some information on using EndNote for this process.
For information on accessing Endnote see our guide to EndNote referencing software.
| Database name and Platform | Process to export | Maximum number of results at a time |
|---|---|---|
| PubMed | * From the results screen select Send to Citation Manager * In Selection choose All results on this page * Select Create File * This will create a RIS file that will be sent to your EndNote Library |
10,000 |
| MEDLINE (Ovid) | * At the beginning of the search results select the All box and the choose export option * In the Export Citation(s) choose the RIS Format * For Fields, select Citation, Abstract then select Export * The results will then be sent to EndNote as an RIS file * For over 3000 results rather than using the All box use the range box to select and export batches of 3000 results at a time, For example the first export would be 1-3000, the second export would be 3001-6000 etc. |
3000 |
| Embase.com (Elsevier) | * From the Results section select the Select number of items drop down that matches your search result number * Then select Export, choose the RIS format, and select Export * The next screen is a download screen. Choose Download. * The results will be sent to EndNote |
10,000 (500 without creating a personal account) |
| Cochrane Library (Wiley) | * In the results sections click Select all & the Export selected citation(s) * Then select RIS(EndNote) & check the include abstract box * Click Download. * Records Will be sent to EndNote as a RIS file |
Unlimited |
| CINAHL (EBSCOhost) MEDLINE (EBSCOhost) PsycInfo (EBSCOhost) |
* From the results screen select the downward pointing triangle ▼, near the number of search results |
25,000 |
| Web of Science (Clarivate) | * From the Search results select Export and choose EndNote desktop from the drop-down list * Select the records range. If your results are greater than 1000 you will need to export in batches of 1000. For example the first export would be 1-1000, the second export would be 1001-2000 etc. *Change record content to Full Record *Choose export *The results will be sent to your EndNote library as a RIS file |
1000 |
| Scopus (Elsevier) |
* From the results screen choose Select All |
20,000 |
| Informit databases | * Cannot export set of records in Informit. Only one record at a time. * Open the record by selecting it via the Title * Select the Export Citations option * This will default to a citation window with the APA format. Change this via the drop down to EndNote * Use the download arrow below to export the file to EndNote |
1 |
Once all results have been retrieved via all of the database searches there will be a number of duplicate records which will need to removed. Some of the available deduplication tools require more manual intervention from the user, and some are more automatic. The various tools have been evaluated, and the more automatic tools such as Covidence are very good at not removing papers incorrectly. Whichever tool you use, any checking of the identified duplicates should be done very carefully to avoid removing potentially useful studies.
| Tool | How to deduplicate | Notes |
|---|---|---|
| Covidence | Covidence information on importing references | Covidence deduplicates automatically when you import references. You can then easily go on to screening within Covidence |
| TERA Deduplicator | Click the ? in the top right for help using the TERA Deduplicator | The Evidence Review Accelerator (TERA) is a suite of tools which can be used individually or in combination with each other. After using the Deduplicator you could then go on to use the TERA's Screenatron tool, or you could import your references into another tool for screening |
| Rayyan | Rayyan information on detecting duplicates | Note that on the free Rayyan plan, deduplication is a more manual process (you need to go through each duplicate, one by one). The auto resolver for duplicates is available only to subscribers |
| EndNote |
EndNote information on removing duplicates |
When deduplicating with EndNote, many librarians will use a multi-pass approach. This video (YouTube, 6m 59s) is a great overview of that process |
Systematic review searches may need to be re-run before the finalisation of the review. The Cochrane handbook recommends searches for all the relevant databases should be re-run prior to publication, if the initial search date is more than 12 months (preferably six months) from the intended publication date.