UX Caucus Database Tips

Featuring guest author, information specialist, and Scopus mechanic Dr. Marc von Gernler, University of Bern. Dr. von Gernler devised a brilliant work around for when Scopus exports fewer records than are in a results set. At the end of his post are details of Elsevier HelpDesk experiences from Database Tips Blog editor Michele McGinnis related to this issue. The crux: Scopus export discrepancy between number or records retrieved and exported is an inconsistently experienced issue. If you happen to experience this issue, this workaround will identify the missing records and save your systematic review! It may have been resolved in May 2026 with Scopus export performance fixes, but it's not clear that it was. Introduction At a certain point in a systematic literature search, when all search strategies have been developed, the final search is at hand. A moment the review team is yearning for. In this final search, each database is searched and all the results are exported for the scr...

A huge thanks to John Reynolds , MLIS, from the Louis Calder Memorial Library at the University of Miami Miller School of Medicine, who wrote this post! Embase (Elsevier’s Embase.com) has recently added large numbers of clinical trials records to their database and includes them in search results by default. Starting in May 2025 they added 500,000 records from ClinicalTrials.gov and continue to add new records. See their FAQ for more information. Similarly, Cochrane CENTRAL (Wiley) has been adding clinical trials registry records from ClinicalTrials.org and the WHO ICTRP since 2023. It also contains registry records identified through its own Specialized Registers and Handsearch projects. See this FAQ on how trials records are added . While trials records can be useful for many kinds of research, many people may not want trials records in their search results, or may prefer to search trials registries directly. While both Embase and CENTRAL allow searchers to identify and limit search...

It’s alive! Or we wish it were. On June 16th, 2026, the Medical Library Association User Experience Caucus hosted the networking event, “Building a (Database) Creature with the Best Features”, at the Library Evidence Synthesis Services Symposium ( LESSS) .  During this event, more than sixty evidence synthesis librarians across disciplines assembled in an unscientific effort to cobble together their dream database platform based on the ones they search every day.

The Crux: i n Scopus, enclose acronyms in curly brackets.  In 2022, Kate posted  Tip #9 Scopus - Loose vs. Exact Phrases . Essentially, to search for an EXACT phrase in Scopus, you'll need to enclose it in {curly brackets} rather than "double quotation marks."  In Tip #67 Subject Areas in Scopus May Amplify the Noise in Your Search , I wrote about a discovery I made in Scopus when searching the acronym DBS, signifying  deep brain stimulation .  I was getting substantially more results in non-medical subject areas than medical and was curious to know what DBS meant in non-medical areas. As I scanned resulting abstracts,  I was surprised to discover that most records included db in the abstract. It appeared that Scopus was treating DBS as the plural of db, which is the abbreviation for decibel, and returning results with both db and dbs. I confirmed this by testing that the search strings ABS (DBS) and ABS (db) returned the same number of records. It's inte...

Written by Hilary Kraus and Zahra Premji  Take a walk on the wild side! Join us for a deep dive into the world of wildcards. This post provides an introduction to how wildcards work, some potential  pitfalls  of using them, and detailed information about how to use them in many popular database platforms. Wildcards 101 Complex searching often involves looking for various forms and spellings of a word. One common approach to this is the use of wildcards. There are two varieties of wildcard. A mandatory wildcard replaces one letter; an optional wildcard replaces either zero or one letter. How these wildcards function and what syntax is used to operationalize them depends on where you're searching. In this post, we look at the ways commonly used databases (or database platforms) use wildcards. Going forward, we will use root to refer to a collection of Latin alphabet letters to which a wildcard may be applied. Since wildcards are typically executed using a punctuation mar...

The crux:  In Scopus, pay attention to Subject area  on the search results page to see if your search retrieves an unexpected number of records from non-relevant areas.  This is especially important when you include acronyms in a search.  The multidisciplinary nature of Scopus presents opportunities and challenges. This post focuses on one of the challenges - records that contain your terms but are wildly irrelevant. This is referred to as noise in a search. Scopus's subject area feature can alert you to noise in your search and provide clues to which terms are causing it.  On the left side of the Scopus results page are options for refining the search. This is where you find the feature called Subject area . But it may not work how you think.   Journal titles are classified in Scopus using its ASJC (All Science Journal Classification) scheme, a list of 361 numerical classification codes that correspond to subject areas. Classification is perform...

As a librarian, a common part of my job is to generate reports for departments on their publication outputs. Namely, this consists of creating a PubMed (or sometimes Scopus) search based on a list of names provided to me by the department. After a few years of these requests, I've been able to compile some insights, and, perhaps most importantly, shortcuts to speed up the process in PubMed.  As a note, I will only be discussing generating the author names search string, and not how to structure affiliation search strings (which is a whole other can of worms!). Basic structure of a PubMed author name search Author searches in PubMed are structured as last name followed by initials (e.g., Wilson P[au] OR Wilson PJ[au] ). PubMed automatically applies truncation to the last initial in the name without the need for truncation (in fact, using truncation with an author name can cause issues with the search, as discussed in the following section). This automatic truncation feature he...