Manuel B. Garcia

Manuel B. Garcia serves as the Senior Director for Educational Technology and Digital Learning at FEU Institute of Technology, Manila, Philippines. Read More

Contact Info

1607, FEU Tech Building,
P. Paredes St, Sampaloc,
Manila, Philippines
mbgarcia@feutech.edu.ph

Follow Me

How Do You Translate a Search Strategy From One Database to Another?

Translating a search strategy means preserving its concepts and retrieval logic while adapting controlled vocabulary, fields, operators, and syntax for another database. It is not a copy-and-paste exercise.

59
Translating Search Strategies Between Databases Guide 59 of 247
01 · The Question

How Do You Move a Search to Another Database Without Changing What It Means?

You have built and tested a search strategy in one database. Its concepts are clear, the terminology retrieves useful literature, and the Boolean structure behaves as intended. Now you need to search another database.

Copying the entire search string seems like the obvious next step, but databases do not share one universal search language. A MeSH heading may need an Emtree equivalent. A Title/Abstract field may have a different code or include different metadata. A proximity operator may change from one platform to another. Truncation and wildcard symbols may behave differently, and automatic term processing can alter what an apparently simple keyword actually searches.

Translation therefore means preserving the intellectual structure of the search while rebuilding its technical implementation for the destination database. The challenge is to change what must change without quietly changing the research question.

02 · The Short Answer

Translate the Function of Each Search Element, Not Its Characters

In Brief

To translate a search strategy between databases, preserve the same concepts and intended retrieval logic, then adapt the controlled vocabulary, free-text fields, phrases, truncation, wildcards, proximity operators, and other syntax to the destination database.

Do not aim for an identical-looking search or an identical result count. The translated strategy should perform the same conceptual job as closely as the destination database permits, while taking advantage of its own indexing and search capabilities.

03 · What You Need to Know

What Should Stay the Same, and What Usually Needs to Change?

Separate the Search Concept From Its Database-Specific Expression

Before translating anything, identify the conceptual architecture of the original strategy.

Suppose your search contains two major concepts:

  • teacher-related terms;
  • burnout-related terms.

Within each concept, you may have subject headings and free-text alternatives connected with OR. The two concept groups may then be connected with AND.

That architecture is the part you generally want to preserve. The exact syntax used to express it is the part that may change.

Preserve The research concepts, intended relationships among them, relevant free-text terminology, and rationale for each retrieval route.
Translate Controlled-vocabulary terms, field codes, phrase syntax, truncation, wildcards, proximity operators, explosion commands, and other platform-specific instructions.

This distinction follows directly from why the same search syntax does not work in every research database. Translation is not character substitution. It is functional reconstruction.

Choose a Well-Developed Search as the Starting Strategy

For a multi-database search, it is usually more efficient to develop and test one principal strategy carefully before translating it into the remaining databases.

In health research, MEDLINE is often used as that starting point because its MeSH vocabulary and search interfaces are well documented, but there is no universal rule that the first strategy must be MEDLINE. The most appropriate starting database depends on the topic, discipline, database coverage, and available expertise.

What matters is that the source strategy is conceptually sound before translation begins. Translating an unfinished search merely reproduces its weaknesses in several dialects.

Do Not Start by Replacing Field Codes

A common translation method is to take the original string and begin replacing syntax: change one title code into another, substitute the truncation symbol, and replace the proximity operator.

That is risky because it encourages superficial equivalence.

Instead, annotate the original search by function:

Concept What idea does this line represent?
Vocabulary route Is this a controlled-vocabulary term or free-text expression?
Field Where is the free-text term intended to match?
Expansion Is truncation, a wildcard, synonym mapping, or hierarchical explosion being used?
Relationship Does phrase, proximity, Boolean grouping, or exclusion logic connect this expression to another?
Destination implementation How does the new database provide the same or closest useful retrieval function?

Once those questions are answered, the required syntax becomes much easier to identify.

Controlled Vocabulary Must Be Looked Up Again

This is one of the most important translation steps.

MEDLINE uses Medical Subject Headings (MeSH). Embase uses Emtree. CINAHL uses CINAHL Subject Headings. APA PsycInfo uses terminology from the APA Thesaurus of Psychological Index Terms.

Cochrane's current Handbook explicitly notes that controlled-vocabulary terms for MEDLINE and Embase are not identical and that their approaches to indexing differ. Search strategies therefore need to be customized for each database.

Do not simply copy a MeSH descriptor into Embase and assume that it functions as an Emtree term. Search the destination thesaurus for the concept itself.

Translate the Concept, Not Merely the Subject-Heading Label

Suppose the source strategy contains a controlled-vocabulary term. When you open the destination thesaurus, you may find:

  • an apparently direct equivalent;
  • a differently named preferred term;
  • several narrower terms instead of one equivalent heading;
  • a broader heading that requires additional free-text support;
  • no satisfactory controlled-vocabulary equivalent.

Each situation requires a different decision.

Read the scope note or definition where available. Inspect broader and narrower terms. Check entry terms or synonyms. Examine how known relevant records are indexed.

The task is the same one involved in understanding how controlled vocabularies represent concepts, but now you are comparing two indexing systems rather than working within one.

Check Whether the Subject Heading Should Be Exploded

Hierarchical vocabularies often allow a heading to retrieve narrower concepts beneath it. This is commonly called exploding the term.

Cochrane recommends identifying appropriate controlled vocabulary, including exploded terms where suitable, because failure to include relevant narrower concepts can cause studies to be missed.

However, explosion behavior and syntax differ by database and interface. A source strategy may have relied on automatic explosion, while the destination database may require an explicit command or provide a different hierarchy.

Do not translate the heading without translating its hierarchical behavior.

Free-Text Terms Often Transfer Better Than Subject Headings, but They Still Need Review

A phrase used by authors can often remain useful across databases because it comes from the literature rather than the indexing system.

For example, teacher burnout may remain a useful free-text expression whether you search MEDLINE, PsycInfo, Scopus, or another relevant resource.

But free-text terminology should not be copied uncritically. Different databases cover different disciplines, and disciplinary communities may use different natural language for the same or overlapping concepts. Cochrane's Technical Supplement specifically notes that terminology appropriate in a general healthcare database may differ from terminology needed in a specialized database.

A translated strategy can therefore need additional free-text terms, not merely converted syntax.

Inspect Relevant Records in the Destination Database

One of the best ways to identify destination-specific terminology is to find several clearly relevant records in that database.

Inspect:

  • their titles;
  • their abstracts;
  • author keywords;
  • controlled-vocabulary terms;
  • database-specific indexing fields.

You may discover terminology that was unnecessary in the source database but important in the destination database because of disciplinary coverage or indexing differences.

This is also a useful check that the translated vocabulary still represents the same concept rather than merely resembling the original words.

Translate Fields by What They Search, Not by Their Names

Suppose the source strategy searches free-text terms in Title/Abstract. The destination platform also offers something called Topic or Keyword. Which should you use?

The answer depends on the field definitions.

A field named Topic may include titles, abstracts, author keywords, and additional indexing. A Title/Abstract field may include author keywords in one database but not another. A default keyword search may search full text on one platform and only bibliographic metadata on another.

The correct translation therefore asks:

Which destination field most closely reproduces the information source I intended to search?

This is why the distinction among title, abstract, and keyword searching should be understood before translating field codes.

Do Not Assume Similar Field Codes Are Equivalent

A short code such as ti, ab, or kw can look self-explanatory. Its syntax and exact scope are still platform-specific.

Cochrane's current Handbook demonstrates this clearly by presenting different syntax for comparable search concepts across PubMed, Ovid MEDLINE, Embase.com, and Ovid Embase. PubMed may use a tag such as [tiab], Ovid uses dot-field syntax such as .ab., and Embase.com uses forms such as :ti,ab,tt.

The intention may be similar, but the technical expression is different.

Phrase Searching Needs to Be Rechecked

If the source strategy uses quotation marks, do not assume they produce an equivalent phrase search in the destination platform.

Ask:

  • Does the database require quotation marks for phrases?
  • Does it automatically search adjacent words as a phrase?
  • Does quotation alter automatic mapping or stemming?
  • Does the platform maintain a phrase index?
  • Would proximity be a better translation of the original linguistic intention?

The phrase itself may transfer. The phrase-search behavior may not.

Truncation Must Be Rebuilt Using the Destination Rules

Suppose the original strategy uses:

educat*

The intention is to capture multiple word forms beginning with a shared stem.

In the destination database, check the truncation symbol, minimum number of characters, maximum expansion, permitted positions, and interaction with phrases or proximity.

Cochrane's Technical Supplement specifically warns that wildcard and truncation symbols vary across databases and interfaces and can even have opposite meanings in some systems.

Watch Out

Never translate truncation or wildcards by visual similarity alone. Confirm what the symbol means in the destination platform and test the resulting word forms before incorporating it into the final strategy.

Wildcards May Need a Different Symbol or Explicit Terms

A source strategy may use a wildcard to capture spelling differences such as randomized and randomised. The destination platform may use another wildcard character, may automatically handle the spelling variation, or may not support an equivalent internal wildcard.

If necessary, replace one compact wildcard expression with explicit OR terms.

The goal is not to preserve the wildcard. It is to preserve coverage of the relevant spelling variation.

Translate Proximity by Relationship, Not Operator Name

Proximity is particularly easy to mistranslate.

Suppose the source strategy means:

Find these terms within approximately five words of each other, in either order.

The destination database may use NEAR/n, Nn, ADJn, another operator, or a field-specific syntax. It may also count distance differently.

Before translating, write the intended relationship in plain language:

Proximity Translation
Concept A within a defined distance of Concept B, either order
This is the retrieval function that should be preserved.
Choose the destination operator and distance that reproduce this function as closely as possible. Do not assume NEAR/5, N5, ADJ5, and other forms are equivalent merely because the same number appears.

If the destination platform cannot reproduce the relationship exactly, document the adaptation and test its consequences.

Some Search Features Have No Direct Equivalent

Translation occasionally reaches a dead end. A destination database may not support an operator used in the source strategy.

Possible responses include:

  • write several explicit phrase variants;
  • replace truncation with explicit word forms;
  • use a broader field and compensate with more specific terminology;
  • use separate search lines rather than one nested expression;
  • accept a somewhat broader or narrower implementation after testing it.

The absence of a direct equivalent is not permission to silently drop the function. Decide how best to approximate it and record what changed.

Automatic Term Processing Must Be Considered

Two identical-looking free-text searches can behave differently because the platforms automatically transform them differently.

PubMed, for example, uses Automatic Term Mapping for many untagged searches. Field tags, quotation marks, wildcards, and proximity syntax can alter that mapping.

Another platform may automatically include singular and plural forms, spelling variants, or stemming.

Translation therefore involves both what you explicitly type and what the platform silently adds.

Do Not Add Explicit Variants Until You Know What the Destination Database Already Does

Suppose your source strategy explicitly includes:

behavior OR behaviour

The destination database may automatically search both forms. Keeping both may be harmless, but it may also add unnecessary complexity. Conversely, assuming automatic equivalence where none exists can reduce retrieval.

Test representative terms and consult the official documentation. The same principle applies to plurals, possessives, hyphenation, diacritics, and other lexical variations.

Preserve Boolean Concept Structure Unless There Is a Substantive Reason to Change It

If the source strategy uses:

(A1 OR A2 OR A3) AND (B1 OR B2)

the destination strategy should ordinarily preserve the same conceptual architecture unless testing reveals a reason to revise it.

Do not accidentally transform OR alternatives into separate AND requirements while rewriting lines. Likewise, do not allow one synonym to escape its concept group because parentheses were lost.

For complex searches, rebuild concept groups independently and then combine them. This reduces the risk of subtle Boolean errors.

Translation Is Also an Opportunity to Catch Problems in the Original Search

Reconstructing a strategy forces you to examine each line closely. You may discover that a source term is ambiguous, a truncation stem is too broad, a concept is represented poorly, or a field restriction has no strong rationale.

Do not preserve an obvious error merely in the name of equivalence.

If you revise the conceptual strategy itself, however, apply that revision consistently across the databases where appropriate. Otherwise, you are no longer merely translating; you are running substantively different search strategies.

Translation change The syntax or database-specific vocabulary changes while the intended retrieval concept remains the same.
Conceptual revision The terms, concepts, or relationships change because you decided the original search strategy itself needed improvement.

Both can be legitimate. Keeping them conceptually separate makes the search process easier to document.

Do Not Expect Identical Result Counts

A translated strategy should not be judged by whether it produces the same number of records.

Different databases cover different journals, disciplines, publication types, dates, and document types. Even the same article can carry different indexing and metadata across resources.

If MEDLINE returns 2,500 records and Embase returns 4,100, that difference does not by itself indicate a translation failure.

Result counts are useful for detecting implausible behavior, not for proving equivalence.

Compare Concept Blocks Before Comparing the Final Search

When a translated strategy behaves unexpectedly, troubleshoot it concept by concept.

Suppose the final search retrieves dramatically fewer records than expected. Instead of modifying the complete query immediately, compare:

  • the first concept block;
  • the second concept block;
  • controlled-vocabulary retrieval;
  • free-text retrieval;
  • individual high-impact terms;
  • the final AND combination.

This can reveal that one subject heading was not exploded, one wildcard failed, or one field restriction is much narrower than its source equivalent.

Known Relevant Records Provide a Practical Translation Test

If you have several articles that clearly represent the research question, determine whether they are indexed in the destination database. If they are, test whether the translated strategy retrieves them.

If a known relevant article is present but missed, inspect the record. Which terminology and indexing does the destination database use? Which line of the translated search should have retrieved it? What failed?

This process can expose missing subject headings, inadequate free-text terms, or syntax that did not behave as expected.

Known-item testing cannot demonstrate complete sensitivity, but it is a valuable diagnostic tool.

Use the Destination Database's Own Documentation

Published systematic reviews and librarian guides can provide useful examples, but technical syntax changes over time.

Cochrane's Technical Supplement advises consulting the search-help documentation supplied by the relevant service provider and database because syntax, controlled vocabularies, operators, truncation, wildcards, and date fields vary across interfaces.

Use current official documentation to verify technical behavior, especially when the search contains complex operators.

Automated Translation Tools Can Help, but They Do Not Remove the Need for Review

Tools have been developed to convert database syntax automatically or semi-automatically. Cochrane's Technical Supplement discusses examples such as the Systematic Review Accelerator's Polyglot application and other conversion tools.

These can reduce repetitive syntax conversion, particularly for large search strategies.

However, Cochrane also notes an important limitation: automated syntax conversion does not resolve all differences in natural-language terminology or controlled vocabulary.

Watch Out

An automated translator can convert symbols without understanding whether the destination database uses a different preferred subject heading, whether another disciplinary term should be added, or whether the translated field is conceptually equivalent. Treat automated translation as a draft to verify, not as the completed search.

Peer Review Is Particularly Valuable for Complex Translations

Search translation involves many opportunities for small errors: a missing parenthesis, an incorrect field, an untranslated subject heading, a proximity operator with the wrong order behavior, or a truncation symbol that expands unexpectedly.

The PRESS guideline for peer review of electronic search strategies specifically includes Boolean and proximity operators, subject headings, text words, spelling and syntax among the elements that should be assessed. It also notes that proximity operators vary by search service.

For a high-stakes systematic review, involving an information specialist or obtaining peer review of the strategy can therefore be more than editorial tidiness. It is a methodological quality-control step.

Document Each Search Exactly as It Was Run

Translation produces database-specific strategies, so each final strategy should be preserved separately.

Cochrane recommends saving bibliographic database search strategies exactly as run, together with search-set numbers and retrieval totals where applicable. Its reporting guidance also calls for the database, access platform, search fields, limitations or settings, and complete line-by-line strategies to be documented in supplementary materials.

Do not reconstruct the search from memory after screening has begun. Database syntax has enough personality without asking your memory to become part of the method.

A Translation Table Can Make the Process Easier to Audit

For complex projects, create a working table that maps the main search functions across databases.

Search Element Source Database Destination Database Translation Check
Controlled vocabulary Source subject heading Destination thesaurus term Scope, hierarchy, explosion, indexing checked
Free-text field Source title/abstract field Closest destination field Field definitions compared
Truncation Source symbol and stem Destination syntax Expansion tested
Wildcard Source wildcard Destination wildcard or explicit variants Character behavior checked
Proximity Source operator and distance Destination equivalent Distance and word order checked
Phrase Source phrase syntax Destination phrase syntax Automatic processing checked
Final Boolean structure Source concept groups Translated concept groups AND/OR logic preserved

The table is a working aid rather than a mandatory reporting format. Its value is that it forces each translated feature to have an explicit rationale.

04 · A Practical Example

How Would You Translate a MEDLINE Search Into Embase?

Hypothetical Example

Moving a search for an intervention from MEDLINE to Embase

Suppose you have developed a MEDLINE search containing MeSH terms, title-and-abstract keywords, truncation, and a proximity expression. You now need an equivalent Embase strategy.

Preserve the concepts Write down the major concepts and the role of each search line before changing any syntax.
Replace MeSH conceptually Open Emtree and look up each concept rather than pasting the MeSH heading into Embase. Check the Emtree definition, hierarchy, narrower terms, and whether explosion is appropriate.
Review free-text terminology Retain useful author terminology but inspect relevant Embase records for additional terms that may reflect its broader or different disciplinary coverage.
Translate the fields Identify which Embase fields correspond functionally to the title, abstract, or other fields used in the MEDLINE strategy.
Rebuild operators Convert truncation, phrase, wildcard, and proximity expressions according to the Embase interface being used. Do not assume that Ovid Embase and Embase.com use identical syntax.
Test the translated blocks Run controlled-vocabulary and free-text portions separately, compare their contribution, and check known relevant records available in Embase.
Combine and document Reconstruct the original Boolean concept structure, run the complete strategy, and save the exact Embase version as executed.

Cochrane's current Handbook illustrates why this process is necessary by presenting substantially different syntax for randomized-trial filters in PubMed, Ovid MEDLINE, Embase.com, and Ovid Embase. The filters represent related retrieval objectives, but the indexing terms, field codes, proximity expressions, truncation, and syntax differ across interfaces.

The lesson extends well beyond health databases: preserve the retrieval objective, then let the destination system determine how that objective must be expressed.

05 · What Researchers Often Get Wrong

Common Mistakes When Translating Database Searches

Misconception

Translation Means Replacing the Field Codes and Keeping Everything Else

Field codes are only one database-specific feature. Controlled vocabulary, phrase behavior, truncation, wildcards, proximity, automatic term processing, and even useful free-text terminology may also require adaptation.

Misconception

A MeSH Term Should Have One Direct Emtree Equivalent

Sometimes a close equivalent exists, but controlled vocabularies organize knowledge differently. A concept may be broader, narrower, differently named, divided among several terms, or indexed differently in the destination system. Translate the concept by examining the thesaurus rather than performing word substitution.

Misconception

Free-Text Terms Never Need Translation

Author terminology often transfers better than subject headings, but disciplinary coverage can change which expressions matter. A specialized database may use natural-language terminology that was uncommon in the source database, so relevant destination records should be inspected for additional terms.

Misconception

The Translated Search Should Return About the Same Number of Results

No. Databases differ in coverage, indexing, metadata, and document types. Result counts can help identify suspicious translation problems, but equivalent retrieval logic does not imply equivalent totals.

Misconception

If an Automated Translator Converts the Search, the Work Is Finished

Automated tools can assist with syntax conversion, but they cannot be assumed to resolve conceptual differences in controlled vocabulary or disciplinary terminology. Review the translated strategy against the destination database and test its behavior.

Misconception

The Translated Search Should Look as Similar as Possible to the Original

Visual similarity is not the objective. A destination database may require different subject headings, several explicit terms in place of a wildcard, or another proximity construction. Functional equivalence is more important than typographical symmetry.

06 · What This Means for You

A Practical Workflow for Translating a Search Strategy

Translate systematically rather than editing the original string until the destination database stops reporting errors.

A simple translation workflow

First: identify the conceptual structure
Separate the search into concept blocks and record what each block is intended to retrieve.
Next: translate controlled vocabulary
Look up every major concept in the destination thesaurus and check scope, hierarchy, explosion, and indexing rather than substituting labels mechanically.
Then: review free-text terminology
Retain useful terms while examining destination records for terminology that may be specific to its disciplinary or indexing coverage.
Then: map the search fields
Compare field definitions and choose the closest functional destination fields.
Then: translate the operators
Rebuild phrases, truncation, wildcards, proximity, parentheses, and other syntax using current official documentation.
Finally: test and document
Run concept blocks separately, check known relevant records, inspect unexpected retrieval, then save the complete strategy exactly as executed.

If you discover during translation that the original strategy needs conceptual improvement, revise it deliberately and propagate that revision to the other databases where appropriate. Do not allow one database to drift into a substantially different question simply because its interface encouraged a convenient workaround.

For a complex systematic review, consider having the principal strategy and important translations reviewed by a librarian or information specialist. Search translation is partly clerical, but the difficult parts are decidedly conceptual.

07 · A Quick Checklist

Before You Call a Database Search Fully Translated, Check Each Layer

For every destination database, check:
Preserve the same major concepts and intended Boolean relationships unless you deliberately revise the underlying strategy.
Look up controlled-vocabulary concepts in the destination database's own thesaurus rather than copying source headings.
Check broader and narrower terms, scope notes, explosion behavior, and other indexing differences.
Inspect relevant destination records for additional free-text terminology and database-specific indexing.
Map title, abstract, keyword, and other fields by their actual definitions rather than their names alone.
Verify phrase, truncation, wildcard, proximity, Boolean, and nesting syntax in the current official platform documentation.
Check automatic term mapping, stemming, spelling variants, and other processing that may change how explicit terms behave.
Run and inspect concept blocks separately before troubleshooting the complete combined strategy.
Test known relevant records that are indexed in the destination database and investigate important misses.
Save the database name, platform, search date, exact strategy, settings or limits, and retrieval total as actually run.
08 · Frequently Asked Questions

Frequently Asked Questions About Translating Search Strategies

Can I copy a PubMed search directly into Embase?

No. Some free-text terminology and Boolean structure may remain useful, but MeSH must be reconsidered as Emtree, field syntax differs, and operators such as proximity and truncation depend on the Embase interface being used. Rebuild the strategy for Embase rather than treating it as a PubMed-compatible search box.

Should I translate the MeSH terms or keep them as keywords?

Do both where appropriate. Look up the concept in the destination controlled vocabulary so you retain subject-indexing retrieval, and keep useful natural-language expressions as free-text terms when they are genuinely used in the literature. A MeSH label used only as ordinary text is not equivalent to a destination subject heading.

Do all my free-text keywords stay the same across databases?

Many can, but review them. Different databases cover different disciplines and may contain literature using additional terminology. Inspect relevant destination records and test whether the original terms still provide adequate concept coverage.

How do I translate a proximity operator?

First describe the intended relationship in plain language: distance, word order, and fields. Then find the destination database's operator that reproduces that function as closely as possible. Do not assume that operators with the same number, such as NEAR/5 and ADJ5, have identical behavior.

Should translated database searches return similar numbers of results?

No. Database coverage and indexing differ, so result counts can vary substantially even when the conceptual translation is sound. Use counts to identify unexpected behavior, not as a target for equivalence.

Can software translate a search strategy automatically?

Tools can assist with syntax conversion and may save considerable time. They should still be checked manually because controlled vocabularies, natural-language terminology, field definitions, and some operator behaviors cannot be assumed to translate correctly through automated substitution alone.

Should I translate one giant final search or each concept separately?

Translate and test concept blocks separately where possible. This makes it easier to identify problems with subject headings, fields, truncation, or terminology before the concepts are combined into the final Boolean strategy.

What should I record for each translated search?

For a reproducible search, retain the database, access platform, search date, exact strategy as run, search fields, relevant settings or limits, and retrieval total. Formal reporting requirements depend on the review type and reporting standard being followed.

09 · The Bottom Line

A Good Translation Preserves Meaning, Not Appearance

The Bottom Line

Translate a search strategy by preserving its concepts and retrieval logic while rebuilding controlled vocabulary, fields, phrases, truncation, wildcards, proximity, and other syntax for the destination database.

Expect the translated strategies to look different and retrieve different numbers of records. What matters is whether each database has been searched using a defensible implementation of the same underlying information need, tested against its own vocabulary, indexing, coverage, and search functionality.

10 · Sources and Further Reading

Authoritative Resources on Translating Search Strategies

11 · Cite this Guide

How to Cite This Guide

This guide is intended to be read, shared, and used in research, teaching, and academic work. If you draw on its ideas, explanations, or other content, please acknowledge the source by citing the guide. Doing so gives appropriate credit and helps your readers locate the original resource.

Has the Field Guide helped your research?

If a guide helped clarify a question, inform a research decision, or move your work forward, I would love to hear about your experience. Your story may also help other researchers discover the Field Guide.

Share Your Experience
Takes only a few minutes