Home   •   Support  •  STN  •  STNews  •  Articles  •  Efficient substance searching with DCR

Power Up: Efficient substance searching with Derwent Chemistry Resource

---

With enhancements to the DCR segment and improved chemical indexing,
substance searching in DWPI is now more efficient than ever. 

---

Derwent Chemistry Resource (DCR) is a structure database in the Derwent World Patents Index (DWPI^SM) suite of databases (WPIDS/WPINDEX/WPIX on STN).  It contains the chemical structures of more than 1 million substances indexed in DWPI bibliographic records.  Improved substance indexing gives you the flexibility to search in DCR by chemical structure or by using text queries.

The following features are illustrated in this article:

• Easy crossover between DCR and bibliographic segments of DWPI
• Limiting answer sets with fragmentation codes and polymer indexing
• Subset substructure searching
• Easy crossover between DWPI and the Derwent Drug File (DRUGU/DDFU)

---

Easy crossover between DCR and bibliographic segments of DWPI

DCR numbers have been added to DWPI records that contain DCN and DRN numbers (DWPI Compound and Registry Numbers), so more than 1.5 million DWPI records now include references to DCR.  This enhanced indexing facilitates crossover between the structural and bibliographic segments of DWPI. 

After searching in DCR, you can requalify the L-number result with /DCR.  This eliminates the need to transfer all three types of substance identifiers as well as the need to use SELECT or TRANSFER.  However, these "older" procedures can still be used and, in most cases, yield the same results.

Note: Some DRN entries, for example, those associated with polymers that are not well defined, may not have DCR numbers, making it necessary to continue using the DRN numbers.

Search for Pantoprazol in DCR.

Conduct a text search.
=> S PANTOPRAZOL?/CN
L3           8 PANTOPRAZOL?/CN

Requalify with DCR.
=> S L3/DCR
L4         352 L3/DCR
Display a record, including the structure.
=> D L4 34 FULL HITSTR
L4    ANSWER 34 OF 352  WPIX COPYRIGHT 2008  THE THOMSON
      CORP on STN 
AN    2006-767310 [78]   WPIX
DNC   C2006-237782 [78]
TI    Use of a proton pump inhibitor e.g. omeprazole, lanosprazole in the
      treatment of sleeping disturbance due to silent gastroesophageal reflux 
...
AB    WO 2006118534 A1   UPAB: 20061204
      NOVELTY - In the treatment of sleeping disturbance due to silent  ...
      TECH   ORGANIC CHEMISTRY - Preferred Compound: The proton pump inhibitor 
      is a substituted benzoimidazole compound of formula (Ia).
...
AN.S  DCR-111250
CN.P  PANTOPRAZOLE
CN.S  5-Difluoromethoxy-2-(3,4-dimethoxy-pyridin-2-ylmethanesulfinyl)-1H-
      benzoimidazole
SDCN  R22667

  

---

Limiting answer sets with fragmentation codes and polymer indexing

Because DCR numbers are now associated with chemical fragmentation coding and polymer indexing, you can limit a structure answer set to only those records that have a code or indexing term of interest.

Search for Tetrahydro-pyran-2-one and derivatives used as insect repellents.

=> STRU 5948 
Retrieve a structure by using its associated DCR number.

ENTER (DIS), GRA, NOD, BON OR ?:.


ENTER (DIS), GRA, NOD, BON or ?:END
L50  STRUCTURE CREATED

Conduct a full substructure search on the structure.
=> S L50 FUL

FULL SEARCH INITIATED 13:52:18 
FULL SCREEN SEARCH COMPLETED -     17133 TO ITERATE
100.0% PROCESSED    17133 ITERATIONS  (17 INCOMPLETE) 1259 ANSWERS 
SEARCH TIME: 00.00.10
L51       1259 SEA SSS FUL L50
 
Requalify the resulting answer set with /DCR, and refine it by using the fragmentation code for insect repellent (P361).
=> S L51/DCR (P) P361/M0,M1,M2,M3,M4,M6 
          2988 L51/DCR 
           184 P361/M0 
          1372 P361/M1 
          2407 P361/M2 
           475 P361/M3 
             1 P361/M4 
           691 P361/M6 
L53         16 L51/DCR (P) P361/M0,M1,M2,M3,M4,M6
Display a record from the refined answer set.
 
 
=> D 2 FULLG HIT FRAGHITSTR
L53  ANSWER 2 OF 16  WPIX COPYRIGHT 2008     THE THOMSON CORP on STN 
AN   2007-064875 [07]  WPIX  Full-text 
DNC  C2007-024438 [07] 
TI   Agent for repelling fiber insects and pests e.g. Tinea pellionella, 
     contains lactone compound as active ingredient 
... 
AB   JP 2006335724 A   UPAB: 20070129 
     NOVELTY - An insect repellent contains lactone compound (1)... 
FS   CPI 
MC   CPI: C06-A02; C14-B04B; C14-B05; D09-A; D09-B06; F03-C02B 
     M2 *01*     D013 D021 D130 J5 J521 L9 L942 M210 M211 M240 M282 M320 
     M412 M511 M520 M530 M540 M781 P341 P361 Q261 M905 M904 
			  RIN: 01384 
			  DCN: RAC4TG-K RAC4TG-U 
			  DCR: 798925-K 798925-U 
     M2 *02*     D013 D021 D130 J5 J521 L9 L942 M210 M211 M240 M282 M320 
			  M412 
			  M511 M520 M530 M540 M781 P341 P361 Q261  M905 M904 
			  RIN: 01384 
			  DCN: RAOSDT-K RAOSDT-U 
			  DCR: 1403293-K 1403293-U 
AN.S DCR-798925 
CN.P DIHYDRONEPETALACTONE 
CN.S 4,7-Dimethyl-hexahydro-cyclopenta[c]pyran-1-one 
SDCN RAC4TG

AN.S DCR-1403293 
CN.S 4,7-Dimethyl-hexahydro-cyclopenta[c]pyran-3-one 
SDCN RAOSDT

 

---

Subset substructure searching

Instead of performing a substructure search on the entire DCR database, you can conduct your search on a subset of the database comprised of an existing answer set that was created in DCR.  The answer set that is searched can be the result of either a text search or a structure search.  Conducting a subset search is considerably less costly than a full substructure search.

Note: When conducting a subset search on a text search answer set, the answer set must point to the DCR segment text data.

Conduct a subset search on an answer set created with a text search.

Recall the pyridine structure by its DCR number.
=> STRU 10

ENTER (DIS), GRA, NOD, BON OR ?:.
 
ENTER (DIS), GRA, NOD, BON OR ?:END
L1   STRUCTURE CREATED
  
Create a text search answer set in the DCR segment.
=> S ?CYCLOPROPANE?/CNS

L2        5320 ?CYCLOPROPANE?/CNS
  
Conduct the search for the pyridine structure on only those answers retrieved in the cyclopropane text search.
=> S L1 SSS FULL SUB=L2

FULL SUBSET SEARCH INITIATED 12:58:05
FULL SUBSET SCREEN SEARCH COMPLETED -  1368 TO ITERATE
100.0% PROCESSED     1368 ITERATIONS          1268 ANSWERS
SEARCH TIME: 00.00.01
L3         1268 SEA SUB=L2 SSS FUL L1
 
Display a free answer to evaluate.
 
=> D TRIAL
 
L3   ANSWER 1 OF 1268  WPIX COPYRIGHT 2007       THE THOMSON CORP on STN 
CN.S (R)-2-(3-Chloro-4-cyclopropanesulfonyl-phenyl)-N-pyridin-2-yl-3-
     (tetrahydro-pyran-4-yl)-propionamide

Conduct a subset search on an answer set created with a structure search.

Upload a structure.

Uploading D:\STNEXP\QUERIES\furan.str

L4      STRUCTURE UPLOADED

=> D

L4 HAS NO ANSWERS
L4              STR

Conduct a subset search on only those answers retrieved in the structure search from the previous example.

=> S L4 SSS FULL SUB=L3 

FULL SUBSET SEARCH INITIATED 13:00:05
FULL SUBSET SCREEN SEARCH COMPLETED -       94 TO ITERATE

100.0% PROCESSED       94 ITERATIONS            34 ANSWERS
SEARCH TIME: 00.00.01

L5           34 SEA SUB=L3 SSS FUL L4

Display a free answer to evaluate.

=> D TRIAL

L5   ANSWER 1 OF 34  WPIX COPYRIGHT 2007       THE THOMSON CORP on STN 
CN.S 1-1,3-Benzodioxol-5-yl-cyclopropanecarboxylic acid [6-(2,3-dihydro-
     benzo­furan-5-yl)-pyridin-2-yl]-amide; 1-Benzo[1,3]dioxol-5-yl-
     cyclopropanecar-boxylic acid [6-(2,3-dihydro-benzofuran-5-yl)-pyridin-2-yl]- 
     amide

---

Easy crossover between DWPI and DRUGU/DDFU

The Derwent Drug File (DRUGU/DDFU on STN) covers worldwide pharmaceutical literature from drug design to post-launch surveillance.  This information, including adverse effects, mechanism of action, pharmacology, and toxicology, may be a valuable supplement to the data available in DWPI.

The Controlled Term (CT) field combines the contents of the Controlled Term Drug Activity (CT.DA) field and the Controlled Term Mechanism of Action (CT.MA) field.  Because CT is available in both DWPI and DRUGU/DDFU, it allows for easy crossover between the databases.

Terms in the CT field associate a DCR structure with a DRUGU record.

E10    WPIX   10     ACETYL-COA-CARBOXYLASE-INHIBITORS/CT.DA

=> S E10
L2          10 ACETYL-COA-CARBOXYLASE-INHIBITORS/CT.DA
 
=> D AN.S STR CT
 
L2   ANSWER 1 OF 10  WPIX COPYRIGHT 2008       THE THOMSON CORP on STN 
AN.S DCR-785697      

CT   ACETYL-COA-CARBOXYLASE-INHIBITORS; ANTIARTERIOSCLEROTICS;
     TRIAL-PREP. ACETYL-COA-CARBOXYLASE-INHIBITOR

An excerpt from a corresponding DRUGU record:

AN    2004-10239  DRUGU   B P 
TI    Isozyme-nonselective N-substituted bipiperidylcarboxamide acetyl-CoA
      carboxylase inhibitors reduce ...
...
AB    The effects of acetyl-CoA carboxylase (ACC)1 and ACC2 inhibition by
      ... inhibition may reduce risk factors associated with metabolic
      syndrome.
CT    OBESITY *OC; BODY-WEIGHT *OC; CL-316243 *RC; RAT *FT; MOUSE *FT; 
      IN-VIVO *FT; HEP-G2-CELL *FT; LIVER *FT; HEART *FT; MUSCLE *FT;

      ADIPOSE-TISSUE *FT; IN-VITRO *FT; LIPID-METAB. *FT; 

      DRUG-COMPARISON *FT; I.P. *FT; P.O. *FT; ANTIARTERIOSCLEROTIC *FT;
      ACETYL-COA-CARBOXYLASE-INHIBITOR *FT; TRIAL-PREP. *FT;
      ACETYL-COA-CARBOXYLASE-INHIBITORS *FT; ANTIARTERIOSCLEROTICS *FT; 
      ... 

---

Summary

Multiple sources need to be consulted to find all of the information available for a given substance. Therefore, tools that make it easier to find related database records are valuable - saving time, effort, and money.

Improved chemical indexing in DWPI has made it possible to conduct both structure and text searches in the full database as well as subsets, and it has simplified the process of accessing related records in other databases. These capabilities, along with the powerful search and analysis tools available in STN, can improve both the efficiency and effectiveness of your substance searches.

---

Additional resources

For more information about recent enhancements to DWPI and DCR, see:

• User Guide for DWPI on STN
• Frequently Asked Questions about changes to DWPI
• Presentation on DWPI reload and enhancements