Slide 1
Welcome to using the MAP command on Dialog. This short module will explain and illustrate how to use a powerful command that pulls together from a search set all of the terms on a certain field so you don’t have to spend time scanning records for keywords and typing them into a search.
This module assumes that you know basic searching on Dialog. It may also serve as a refresher on using MAP or show you additional uses for MAP. The content on Dialog is available through several interfaces. This module uses the DialogClassic Web interface to illustrate the MAP command. This is an online course, which means that you can take this course from any computer attached to the Internet. You may also stop and resume the session any time you wish.
Slide 2
By the end of this session you will understand the concept of field searching in a database and you will know that the MAP command allows you to collect the data from a particular field in retrieved records and create a new search statement. You will know how to quickly find the fields available for MAP in each database. You will gain ideas on when to use the MAP command and you will understand the steps to using MAP and executing the steps. You will learn why MAP saves you hours of research and searching time and guides you to many more terms than you might have conceived.
Slide 3
You use the MAP command after you have run an initial search and created a search set. The idea is that you want to take all of the data from, for example, the patent number field and run a search on all those patent numbers. It could be a case where you have the brand name for a drug and you need to brainstorm all of the possible synonyms or preferred drug names for that compound and search on those names.
You could have a drug name and you want to find the CAS® Registry Number and search on it. There are many applications in company-directory files where, for example, you can map the DUNS® numbers in a search set and then run a search on just those companies in ABI/INFORM or Business Dateline, databases with a DUNS number field (DN=). Another common example in the DUNS files is to MAP all of the corporate family members of a company. In the patent files, you can MAP patent assignees, or even classification codes.
When you use the MAP command you create a Dialog SearchSave, and you can choose whether to create a permanent or temporary SearchSave. Then you can EXECUTE the SearchSave in the same or in another database, as long as the second database has the same field.
Slide 4
As you develop skill in using the MAP command you let Dialog do the work. Gain exponentially by adding power and efficiency to more effective searches.
Slide 5
The first application of MAP involves a search for synonyms for a drug brand name. The brand name is Exelon, an agent to treat moderate dementia caused by Alzheimer’s disease. In order to search in the biomedical literature we need to find the preferred drug terms, because the brand name is seldom mentioned in peer-reviewed scientific articles.
Slide 6
Our command summary shows a start in CHEMSEARCH™ (File 398). We will retrieve the record with the brand name and use the MAP command. The MAP command will create a saved search containing the synonyms and the CAS® Registry Number. Now, as you will see, we can BEGIN key biomedical files and EXECUTE the search that contains the terms we need to work with to get good data.
Slide 7
First, BEGIN File 398, CHEMSEARCH.EXPAND the drug name of interest. We’re going to SELECT E3, which has the record for Exelon.
Slide 8
We’ll MAP Set 1 using SYRN to extract the synonyms and the CAS Registry Number. By adding “T” to the end of the MAP command, we are creating a free, temporary SearchSave that will be available for seven days.Notice that Dialog gave the temporary SearchSave a number, TD270. If you log off and come back later to execute the save, you will need to enter the number after the EXECUTE command.
An optional step is to RECALL the SearchSave. This shows the terms that Dialog extracted from the Synonym field and the CAS Registry Number field. The plus sign acts as OR. We picked up some generic drug names, some laboratory codes and a CAS Registry Number. We will carry this saved search statement into the biomedical files.
Slide 9
Now we’ll execute the search in MEDLINE®, EMBASE®, BIOSIS Previews® and SciSearch®: a Cited-Reference Science Database. These are the core biomedical files. EXECUTE Steps (EXS). If you have not logged off after using the MAP command, you can simply enter the EXS command. However, if you created the MAP save before lunch, logged off, and came back into the biomedical files, then you would need to add the SearchSave number, in this case, TD270.
Slide 10
Dialog creates Set 1. We will want to narrow the results down to a manageable number. You may want to AND in specific qualifiers, such as therapy, efficacy, adverse events, and so forth.
Slide 11
In our example, we will narrow the results to the most recent publication years.Since we are in more than one database, we will REMOVE DUPLICATES with the RD command.Then we can TYPE out the first few records FROM EACH database. In the example, we show the first record.
Slide 12
In our next example, we want to find all of the patent numbers that cited an IBM patent that has to do with touch-screen technology. We will use Patents Citation Index (PCI) (File 342) because one of the great features of this database is that we can find out who is citing earlier patents. This Derwent file allows us to MAP on the Citing Patents field (CG=).
Our command summary shows that we will BEGIN 342 and SELECT the patent number of interest on the PN= field. A good step is to TYPE the record out and see the lists both of earlier patents this patent cited and the patents that later cited this patent. Now, we want to pull up abstracts on the patents that are citing the IBM patent.
We can MAP just the citing patents with MAP CGPN T, to create a temporary SearchSave to take into Derwent World Patents Index® (DWPISM) (File 351). After we BEGIN 351, we can EXECUTE STEPS.
Slide 13 The movie
Slide 14
The third application shows how to convert the DUNS number (DN=) of the ultimate parent company to its corporate number (DC=), and then execute a search that retrieves all of the corporate family members. We’ll use Dun’s Market Identifiers® (File 516).
The principle behind this is the fact that the DUNS number of the ultimate parent is the same as the corporate family number. A trick to remember in some Dun & Bradstreet databases is availability of a limiter that allows you to restrict retrieval to the parent company. The qualifier suffix is /ultimate.
Once you have a search set with the ultimate parent, simply MAP DN T/DC=. In that MAP command you extract the corporate parent’s DUNS number, but the search statement will convert DN= to DC=, followed by the DUNS number. When you EXECUTE the saved search, you will pull up all of the family members, including the parent.
Slide 15
Here’s how it works: BEGIN 516. EXPAND on the company name. Always remember that sometimes you will need to EXPAND and SELECT several variations on the company name. In this case we are fairly certain the UNISYS Corporation is the name of the parent company.
Slide 16
SELECT the appropriate E reference numbers and qualify to /ultimate. We have one record. MAP the DUNS number, creating a temporary save. Immediately following the “t”, enter a slash followed immediately by the field conversion, for example, DC, followed by the equal sign. Notice in the recall save: DC equals the parent’s DUNS number.
Slide 17
EXECUTE the saved search and DISPLAY SETS.Our MAP command retrieved 130 corporate family members.
Slide 18
At this point you can do a number of things: either TYPE out records in the format of your choice, or you can take it further and SORT the family records by state.
Then, rather than TYPE out the records, you can create a REPORT with pertinent fields, in this case, the states and the company names.
You may wish to include locations. Enter HELP REPORT 516 to find the fields available for REPORT.
Notice the last company shown on the slide. We would not have found that company name if we had searched on CO=UNISYS CORPORATION. That’s where the MAP command enhances your search. We found that location by searching on the DUNS corporate number, which brought in all the locations regardless of company name.
Slide 19
In summary, the MAP command offers you many advantages. It extracts data from a field or combination of fields and creates a saved search that you can execute in the same database or another file. It saves time, especially when you are gathering up patent numbers or strings of DUNS numbers. It guides you to synonyms or keywords that may not have occurred to you.
The command is MAP field code. Append a T to the end to save a free temporary save.
To MAP one field to convert to another, enter, for example, MAP DN T/DC=
There are many applications of MAP. In this session we covered MAPping chemical and drug names, patent numbers and DUNS numbers. Additional examples include patent assignee names, authors, inventors, Derwent accession numbers and classification codes.
Slide 20
To find the fields available for MAP in a database, enter HELP MAP nnn, where nnn is a database number, or check the Bluesheet.
Check out the How Do I…? series step instructions for additional MAP techniques you can use on Dialog. The first one cited here shows how to use a specialized MAP command to find an entire patent family. The second one explains how to MAP for chemical names in CHEMSEARCH, EXECUTE in CA SEARCH, qualify to patent records, MAP patent numbers and then EXECUTE in patent files.
Slide 21
Dialog’s Knowledge Center is on hand to help you or answer questions. Call 1-800-3-Dialog within North America, or 00- 800-33-Dialog outside of North America.
Be sure to take advantage of free training offered throughout the year. Visit support.dialog.com/training for details.
Use the Essential Tools sites, such as support.dialog.com/validate, to locate the free search aids and resources that will help you make the most of Dialog’s content, files and features.
Sign up to receive news about Dialog and upcoming trainings in the Chronolog and the training e-newsletter.
Slide 22
Thank you for your interest in Dialog. We hope that you have gained new skills and understanding of a time-saving searching tool by attending this short module. Watch for additional on-demand training opportunities in the future.
