Script:
Dialog at a Glance module:

Using the MAP Command

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 chemical substance. We need to begin our search in a chemical substance file to search for a chemical compound name and gather synonyms and the CAS Registry Number to build terminology. Three chemical substance databases of note are Chapman and Hall Chemical Database (File 303), The Merck Index OnlineSM (File 304) and Registry of Toxic Effects of Chemical Substances (RTECS^®) (File 336). We'll use the EXPAND command to find the appropriate chemical name and we'll create a SearchSave that includes both the synonyms and the CAS Registry Number. Then we can take the SearchSave into a file that specializes in toxicology literature.

Slide 6
The compound is dibutyl phthalate, a commonly used additive found in a variety of household items including food packaging. We'll start in Registry of Toxic Effects of Chemical Substances (RTECS^®) (File 336) and find the record for the compound. Then we'll MAP the synonyms and the CAS Registry Number. The MAP command creates a SearchSave that contains these terms and we can EXECUTE it in ToxFile (File 156).

Slide 7
So we BEGIN File 336 and EXPAND dibutyl phthalate on the Chemical Name field using NA equals. Then we'll SELECT the appropriate E reference number.

Slide 8
We 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 create a free, temporary SearchSave that will be available for seven days.

Notice that Dialog gave the temporary SearchSave a number, TD513. Dialog remembers the last SearchSave so you can simply EXECUTE it when ready. However, if you log off and come back later to execute the save, you will need to enter the SearchSave 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 chemical terms and a CAS Registry Number. We will carry this saved search statement into ToxFile, File 156.

Notice that four search sets will be created. The first three sets are chemical names, synonyms and the CAS Registry Number. Set 4 will OR the first three sets together.

Slide 9
Now we'll BEGIN ToxFile, File 156, and EXECUTE the temporary SearchSave.

Slide 10
The execute created four search sets. S4 is Sets 1, 2 and 3 ORed together.

Slide 11
We'll add in keywords to qualify the search and limit retrieval to certain publication years.

Slide 12
And now we'll TYPE out some records in free Format 8 to browse titles, publication dates and descriptors.

Slide 13
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 (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 Number field, CGPN.

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 space T, to create a temporary SearchSave to take into Derwent World Patents Index^® (File 351). After we BEGIN 351, we can EXECUTE STEPS.

On the next slide when you see the blank screen, hit the Play arrow twice on the playbar at the bottom of the screen. This will start a movie that shows Using the MAP command with citing patents.

Slide 14 — The movie

• We'll start our search by typing BEGIN 342, Patents Citation Index.
• Next we enter SELECT and the patent number of interest.
• Our search found the one record: the patent of interest. We will TYPE the record so we can see the companies and patents that cited IBM's patent.
• As you can see there are a number of patent numbers that cited this patent. Imagine if you had to type a search statement with all of those patent numbers! Dialog provides the MAP command so that Dialog will do the work for you. The field we want to MAP is Citing Patents (CG=). The MAP code for citing patents is CGPN. When we enter MAP CGPN Dialog will extract all of the patent numbers on the CG field and create a SearchSave where the field will be converted to Patent Number (PN=).
• We have created temporary SearchSave TD260. The SearchSave contains 23 patent numbers to search. Our next step is to BEGIN File 351 and execute the SearchSave and retrieve those patents.
• In File 351, we will EXECUTE the SearchSave. Since we have not logged out, Dialog remembers our most recent SearchSave. All we need to do is enter the EXECUTE STEPS command (EXS). Watch how Dialog searches for each patent number.
• We now have a set containing patents that cited IBM's patent that we displayed in File 342. At this point, we could TYPE them out or deliver them in a PRINTOFF, or we could do further analysis, for example, using the RANK command RANK PANAME to see the list of patent assignees.

Slide 15
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 16
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 17
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 18
EXECUTE the saved search and DISPLAY SETS. Our MAP command retrieved 130 corporate family members.

Slide 19
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 20
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 21
To find the fields available for MAP in a database, enter HELP MAP nnn, where nnn is a database number, or check the Bluesheet.

You can map on priority application numbers in Derwent World Patents Index^® to find patent family members. Check out the How Do I...? series, step instructions for additional MAP techniques you can use on Dialog. See How Do I Find a Complete Patent Family Using Derwent World Patents Index^®?

Use MAP in chemical substance files to create a comprehensive saved search containing a compounds synonyms and CAS Registry Numbers. See How Do I Use the MAP Command to Begin a Basic Toxicology Search?

Slide 22
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 To find the fields available for MAP in a database, enter HELP MAP nnn, where nnn is a database number, or check the Bluesheet.

You can map on priority application numbers in Derwent World Patents Index^® to find patent family members. Check out the How Do I...? series, step instructions for additional MAP techniques you can use on Dialog. See How Do I Find a Complete Patent Family Using Derwent World Patents Index^®?

Use MAP in chemical substance files to create a comprehensive saved search containing a compounds synonyms and CAS Registry Numbers. See How Do I Use the MAP Command to Begin a Basic Toxicology Search?

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 23
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.