检索系统基础训练研讨会课件

STN檢索系統基礎訓練研討會日期：2000年8月15日主辦單位：工研院化工所主講人：吳清源永光化學智權中心12/5/20231講題大綱-下午STNCommands(下午13:30-16:30)多種資料庫檢索(Multi-fileSearchStrategies)實機線上練習(SkillPractices)STN進階檢索指令(STNCommandsReviews)實機線上練習(SkillPractices)L-Numbers使用技巧介紹(WorkingWithL-Numbers)實機線上練習(SkillPractices)12/5/20232Multi-fileSearchStrategies如果要一次檢索多個資料庫，有以下方法：簡單的使用FILEfilename1

filename2

filename3…SETMSTEPSON直接使用系統預設群組(clusters)修改系統預設群組以適合您的需求自己將想要的資料庫設定為群組12/5/20233=>FILELCALMEDLINELDRUG=>ECYTOTECE11CYTOTACTIN/BIE21CYTOTAXONOMY/BIE31-->CYTOTEC/BIE41CYTOTEC*RC/BI。E12394CYTOTOXICITY/BI=>SE3L21CYTOTEC/BI=>SETMSTEPSONSETCOMMANDCOMPLETED=>SCYTOTECL30FILELCAL40FILELMEDLINEL51FILELDRUGTOTALFORALLFILESL61CYTOTECSETMSTEPSON後會顯示每一個資料庫所找到的資料數目簡單的使用FILE12/5/20234使用系統預設的群組(clusters)STN系統預設51個群組(參閱CASCatalog)(Agriculture,Bioscience,Business…Toxicology)=>Dclusterbioscience=>DISPLAYCLUSTERBIOSCIENCECLUSTERNAMECLUSTERDEFINITION----------------------------------------------------------------------BIOSCIENCEADISALERTSADISINSIGHTAGRICOLAAIDSLINEANABSTRAQUASCIBIOBUSINESSBIOCOMMERCEBIOSISBIOTECHABSBIOTECHDSBIOTECHNOCABACANCERLITCAPLUSCEABACENCINCONFSCICROPBCROPUDDFBDDFUDGENEDRUGBDRUGLAUNCHDRUGMONOGDRUGMONOG2DRUGNLDRUGUEMBALEMBASEESBIOBASEFOMADFOREGEFROSTIFSTAGENBANKHEALSAFEIFIPATJICST-EPLUSKOSMETLIFESCIMEDICONFMEDLINENIOSHTICNTISOCEANPHARPHICPHINPROMTSCISEARCHTOXLINETOXLITUSPATFULLWPIDSWPINDEXBioscienceLiteratureCluster12/5/20235=>FILEBIOSCIENCE=>SETMSTEPSONSETCOMMANDCOMPLETED=>SZOMIGL155FILEADISALERTSL21FILEADISINSIGHTL30FILEAGRICOLAL40FILEAIDSLINEL50FILEANABSTRL60FILEAQUASCIL718FILEBIOBUSINESSL81FILEBIOCOMMERCEL941FILEBIOSISL100FILEBIOTECHABSL118FILEBIOTECHNOL120FILECABAL131FILECANCERLITL1411FILECAPLUSL150FILECEABAL160FILECENL1728FILECINL186FILECONFSCI。L2995FILEEMBASEL3012FILEESBIOBASEL310FILEFOMADL320FILEFOREGEL5034FILETOXLINEL5111FILETOXLITL520FILEUSPATFULLL530FILEWPINDEXTOTALFORALLFILESL54786ZOMIG12/5/20236修改系統預設群組=>SETCLUSTER.clustername使用(.)以區隔預設群組-clustername使用(-)減去不要的資料庫輸入filename將需要的資料庫加到.cluster12/5/20237=>SETCLUSTERENTERCLUSTERNAMEOR(?):BIOSCIENCE'BIOSCIENCE'ISNOTAVALIDCLUSTERNAMEAvalidclustermust:1.Beginwithaperiod,2.Have2-16characters,3.Containonlyletters(A-Z)andnumbers(0-9)ENTERCLUSTERNAMEOR(?):.BIOSCIENCEENTERLISTOFFILENAMESOR(?):BIOSCIENCE–AQUASCI,-BIOBUSINESS,-BIOCOMMERCE,-BIOSIS,-BIOTECHABSMOREFILES,(NONE)OR?:HCAPLUSMOREFILES,(NONE)OR?:NONECLUSTER'.BIOSCIENCE'DEFINEDAS'BIOSCIENCE,-AQUASCI,-BIOBUSINESS,-BIOCOMMERCE,-BIOSIS,-BIOTECHABS,HCAPLUS,SETCOMMANDCOMPLETED12/5/20238將想要的資料庫設定為群組=>SETCLUSTER.clustername(selfdefine)以區隔預設群組輸入filename將需要的資料庫加到.cluster12/5/20239=>SETCLUSTERENTERCLUSTERNAMEOR(?):.DRUGENTERLISTOFFILENAMESOR(?):DRUGLAUNCH,DRUGMONOG2,DRUGNL,DRUGUMOREFILES,(NONE)OR?:NONECLUSTER'.DRUG'DEFINEDAS'DRUGLAUNCH,DRUGMONOG2,DRUGNL,DRUGU'SETCOMMANDCOMPLETED=>SETMSTEPSONSETCOMMANDCOMPLETED=>FILE.DRUGSCOSTINU.S.DOLLARSSINCEFILETOTALENTRYSESSIONFULLESTIMATEDCOST0.210.21FILE'DRUGLAUNCH'ENTEREDAT23:13:13ON13AUG2000COPYRIGHT(C)2000IMSWORLDPublicationsLtdFILE'DRUGMONOG2'ENTEREDAT23:13:13ON13AUG2000COPYRIGHT(C)2000IMSWORLDPublicationsLtdFILE'DRUGNL'ENTEREDAT23:13:13ON13AUG2000COPYRIGHT(C)2000IMSWORLDPublicationsLtdFILE'DRUGU'ACCESSNOTAUTHORIZED=>SZOMIGL139FILEDRUGLAUNCHL235FILEDRUGMONOG2L322FILEDRUGNLTOTALFORALLFILESL496ZOMIG12/5/202310UsingDUPLICATEcommandDUPLICATE指令的作用a)將群組中重複的資料剔除=>DUPLICATERemoveb)只顯示重複的資料=>DUPLICATEOnly12/5/202311=>FILECAPLUSMEDLINECOSTINU.S.DOLLARSSINCEFILETOTALENTRYSESSIONFULLESTIMATEDCOST0.211.47FILE'MEDLINE'ENTEREDAT23:20:49ON13AUG2000=>SETMSTEPSONSETCOMMANDCOMPLETED=>SZOMIGL111FILECAPLUSL225FILEMEDLINETOTALFORALLFILESL336ZOMIG=>DUPLICATEREMOVEENTERL#LISTOR(END):L3DUPLICATEPREFERENCEIS'CAPLUS,MEDLINE'KEEPDUPLICATESFROMMORETHANONEFILE?Y/(N):NPROCESSINGCOMPLETEDFORL3L427DUPLICATEREMOVEL3(9DUPLICATESREMOVED)12/5/202312=>DUPLICATEONLYL3PROCESSINGCOMPLETEDFORL3L518DUPLICATEONLYL3=>DBIB1-5L5

L5ANSWER1OF18MEDLINEDUPLICATE1AN2000104504MEDLINEDN20104504TIAlong-termstudytomaximisemigrainereliefwithzolmitriptan.AUTepperSJ;DonnanGA;DowsonAJ;BomhofMA;ElkindA;MelocheJ;FletcherPE;MillsonDSCSThePolyclinic,Seattle,USA.SOCURRENTMEDICALRESEARCHANDOPINION,(1999)15(4)254-71.Journalcode:DUX.ISSN:0300-7995.CYENGLAND:UnitedKingdomDT(CLINICALTRIAL)Journal;Article;(JOURNALARTICLE)(MULTICENTERSTUDY)(RANDOMIZEDCONTROLLEDTRIAL)LAEnglishFSPriorityJournalsEM200004EW20000403L5ANSWER2OF18CAPLUSCOPYRIGHT2000ACSDUPLICATE1AN2000:92708CAPLUSDN132:117473TIAlong-termstudytomaximizemigrainereliefwithzolmitriptanAUTepper,StewartJ.;Donnan,GeoffreyA.;Dowson,AndrewJ.;Bomhof,MartinA.M.;Elkind,Arthur;Meloche,Jacques;Fletcher,PamelaE.;Millson,DavidS.CSThePolyclinic,Seattle,USASOCurr.Med.Res.Opin.(1999),15(4),254-271CODEN:CMROCX;ISSN:0300-7995PBLibraPharmLtd.DTJournalLAEnglish12/5/202313UsingINDEXcommandINDEX指令的作用STNINDEX是一個使用多重資料庫檢索時，用來預視檢索策略所得的答案總數。INDEX的所花費用會比使用多重資料庫搜尋便宜，只要花連線費用US$45/HR。配合=>DRANK可依資料數量排名顯示。12/5/202314=>INDEXBIOSCIENCEFILE'DRUGMONOG'ACCESSNOTAUTHORIZEDCOSTINU.S.DOLLARSSINCEFILETOTALENTRYSESSIONFULLESTIMATEDCOST0.630.63INDEX'ADISALERTS,ADISINSIGHT,AGRICOLA,AIDSLINE,ANABSTR,AQUASCI,BIOBUSINESS,BIOCOMMERCE,BIOSIS,BIOTECHABS,BIOTECHDS,BIOTECHNO,CABA,CANCERLIT,CAPLUS,CEABA,CEN,CIN,CONFSCI,CROPB,CROPU,DDFB,DDFU,DGENE,DRUGB,DRUGLAUNCH,DRUGMONOG2,...'ENTEREDAT23:27:09ON13AUG200057FILESINTHEFILELISTINSTNINDEXEnterSETDETAILONtoseesearchtermpostingsortoviewsearcherrormessagesthatdisplayas0*withSETDETAILOFF.=>SZOMIG55FILEADISALERTS1FILEADISINSIGHT18FILEBIOBUSINESS1FILEBIOCOMMERCE41FILEBIOSIS8FILEBIOTECHNO11FILECAPLUS。22FILEDRUGNL11FILEDRUGU1FILELIFESCI42FILESSEARCHED...25FILEMEDLINE1FILEPHAR。192FILEPROMT45FILESCISEARCH34FILETOXLINE11FILETOXLIT26FILESHAVEONEORMOREANSWERS,57FILESSEARCHEDINSTNINDEXL1QUEZOMIG12/5/202315=>DRANKF1192PROMTF295EMBASEF391PHINF455ADISALERTSF545SCISEARCHF641BIOSISF739DRUGLAUNCHF835DRUGMONOG2F934TOXLINEF1028CINF1125MEDLINEF1222DRUGNLF1318BIOBUSINESSF1412ESBIOBASEF1511CAPLUSF1611DDFUF1711DRUGUF1811TOXLITF198BIOTECHNOF206CONFSCIF212PHICF221ADISINSIGHTF231BIOCOMMERCEF241CANCERLITF251LIFESCIF261PHAR=>FILECAPLUSMEDLINECOSTINU.S.DOLLARSSINCEFILETOTALENTRYSESSION=>SL1L236L112/5/202316實機線上練習(SkillPractices)Question1:請同時在LCA、LMEDLINE及LDRUG資料庫中，檢索出有關於控制糖尿病併發症的相關研究(controlofdiabeticcomplications)剔除其中重複的資料，再顯示其重複的資料。12/5/202317實機線上練習(SkillPractices)Question2:請在Chemistrycluster中，使用INDEX檢索出關於(orangejuiceAND((removeANDbitter)OR(debitter))，並顯示其資料數量對資料庫的排序(RANK)，再剔除其中重複的資料，並以ALL格式顯示前兩筆專利資料。12/5/202318STN進階檢索指令儲存答案集儲存SAVE、顯示DSAVED、取出ACTIVATE(ACT)、刪除DELETE(DEL)排列檢索答案SORT,ANALYZING將答案中欄位縮寫以全名顯示DISPLAYL#IBIB(IALL)顯示查詢過的答案集DISPLAYHISTORY(DHIS),DELETEHISTORY(DELHIS)12/5/202319儲存答案集-SAVE儲存SAVESAVE/A(Answer),SAVE/L(L#)SAVETEMP(免費但只是暫時性的儲存，保留7天後系統自動刪除)顯示DSAVED取出ACTIVATE(ACT)刪除DELETE(DEL)12/5/202320=>SULCER#ANDDRUG#54ULCER#1334DRUG#L18ULCER#ANDDRUG#=>SAVETEMPL1ULCER/AANSWERSETL1HASBEENSAVEDAS'ULCER/A'=>DSAVEDNAMECREATEDNOTES/TITLE-------------------------------------------------------------GELNUMBER/LTEMP2L-NUMBERSULCER/ATEMP8ANSWERSINFILELCA

=>SHYPERTENSION?L2141HYPERTENSION?=>SAVETEMPL2HYPER/LL#LISTL2HASBEENSAVEDAS'HYPER/L'=>DSAVEDNAMECREATEDNOTES/TITLE-------------------------------------------------------------GELNUMBER/LTEMP2L-NUMBERSHYPER/LTEMP1L-NUMBER

ULCER/ATEMP8ANSWERSINFILELCA=>LOGOFF12/5/202321=>FILELCA=>DSAVEDNAMECREATEDNOTES/TITLE-------------------------------------------------------------GELNUMBER/LTEMP2L-NUMBERSHYPER/LTEMP1L-NUMBERULCER/ATEMP8ANSWERSINFILELCA=>ACTIVATEULCER/AL18SEAFILE=LCAULCER#ANDDRUG#=>DL11BIB

L1ANSWER1OF8LCACOPYRIGHT2000ACSAN101:83907LCATIGeneralpharmacologicalstudiesonarotinolol(S-596),a.beta.-adrenoceptorblockingdrugAUHara,Youichi;Miyagishi,Akira;Koga,Yoshihiko;Hirose,Akira;Tanaka,YukikoCSTakarazukaRes.Cent.,SumitomoChem.Co.Ltd.,Takarazuka,665,JapanSOOyoYakuri(1984),27(6),1037-57CODEN:OYYAA2;ISSN:0369-8033DTJournalLAJapanese12/5/202322=>DSAVEDNAMECREATEDNOTES/TITLE-------------------------------------------------------------GELNUMBER/LTEMP2L-NUMBERSHYPER/LTEMP1L-NUMBERULCER/ATEMP9ANSWERSINFILELCA

=>DELHYPER/LDELETEHYPER/L?(Y)/N:Y=>DELULCER/ADELETEULCER/A?(Y)/N:Y=>DSAVEDNAMECREATEDNOTES/TITLE-------------------------------------------------------------GELNUMBER/LTEMP2L-NUMBERS12/5/202323排列檢索答案SORT格式=>SORTL#extractionfield

answerortermnumbers例子=>SORTL1

AU1-

extractionfield:AU(author)TI(Title)JT(JournalTitle)CS(CorporateSource)PA(PatentAssignee)12/5/202324=>FILELCA=>SHYPERTENSION?L1141HYPERTENSION?=>SORTL1CS1-PROCESSINGCOMPLETEDFORL1L2141SORTL11-CS=>DL2CS1-5

L2ANSWER1OF141LCACOPYRIGHT2000ACSCS2ndDep.Intern.Med.,KanazawaUniv.,Kanazawa,Japan

L2ANSWER2OF141LCACOPYRIGHT2000ACSCSAustinHosp.,Univ.Melbourne,Heidelberg,3084,Australia

L2ANSWER3OF141LCACOPYRIGHT2000ACSCSAustralas.DrugInf.Serv.,Auckland,N.Z.

L2ANSWER4OF141LCACOPYRIGHT2000ACSCSAzerb.Med.Inst.,Baku,USSR

L2ANSWER5OF141LCACOPYRIGHT2000ACSCSBakerMed.Res.Inst.,MonashUniv.,Melbourne,Australia

12/5/202325ANALYZING格式=>ANALYZEL#extractionfield

answerortermnumbers例子=>ANALYZEL1

AU1-

extractionfield*:AU(author)TI(Title)JT(JournalTitle)CS(CorporateSource)PA(PatentAssignee)*Databasedependable12/5/202326=>ANALYZEL1AU1-L2ANALYZEL11-AU:445TERMS=>DL21-15L2ANALYZEL11-AU:445TERMSTERM##OCC#DOC%DOCAU----------------------------------------1442.84SCHMITT,HENRI2332.13LAUBIE,MICHEL3221.42DOYLE,A.E.4221.42HUTCHINSON,J.S.5221.42MENDELSOHN,F.A.O.6221.42PACE-ASCIAK,C.R.7221.42SEIDEL,C.L.8221.42TARAZI,ROBERTC.9110.71ABASKULIEVA,L.I.10110.71ABE,KEISHI11110.71ABESADZE,I.G.12110.71AKHVLEDIANI,R.N.13110.71ALLAIS,ANDRE14110.71ALLEN,J.C.15110.71ANDERSON,STEVENC.12/5/202327STN進階檢索指令將答案中欄位縮寫以全名顯示DISPLAYL#IBIB(IALL)顯示查詢過的答案集DISPLAYHISTORY(DHIS),DELETEHISTORY(DELHIS)12/5/202328=>DL1IBIB1

L1ANSWER1OF141LCACOPYRIGHT2000ACSACCESSIONNUMBER:101:96930LCATITLE:HypertensionamongworkersinaplantfortheprimaryproductionofzincAUTHOR(S):Boscolo,P.;Bergamaschi,A.;Carelli,G.;Sperduto,B.;Finelli,V.N.CORPORATESOURCE:Inst.Occup.Med.,Cathol.Univ.Rome,Rome,ItalySOURCE:HeavyMet.Environ.,Int.Conf.,4th(1983),Volume1,513-16.CEPConsult.:Edinburgh,UK.CODEN:51UDABDOCUMENTTYPE:ConferenceLANGUAGE:English=>DISPLAYHISTORYENTER(BRIEF)ORFULL:FULLENTER(L1-),L#,OR?:L1-(FILE'HOME'ENTEREDAT23:55:08ON13AUG2000)FILE'LCA'ENTEREDAT23:55:20ON13AUG2000L1141SEAHYPERTENSION?L2141SORTL11-CSL3141SEAL2L4ANALYZEL11-AU:445TERMSDL1IBIB1DL1IALL212/5/202329實機線上練習(SkillPractices)Question3:請同時在LCA、LMEDLINE及LDRUG資料庫中，檢索出關於抑制偏頭痛(Antimigraine)的藥物，並以SAVETEMP儲存查詢答案，LOGOFF後再LOGIN，顯示儲存的資料並將其ACTIVATE，並顯示其資料數量對資料庫的排序，再剔除其中重複的資料，再以作者名稱SORT答案，以IBIB顯示前5筆資料，再以ANALYZE找出公司排名，顯示公司排名，刪除儲存的答案，確認無儲存的資料後，顯示查詢過的答案集，LOGOFFHOLD。12/5/202330L-Numbers使用技巧介紹WorkingWithL-NumbersRe-usingintheSameDatabaseRe-usingintheDifferentDatabaseREGISTRYL-NumberedAnswerSets12/5/202331Re-usingintheSameDatabaseRe-usingintheSameDatabaseCombiningtheL#withothersearchterms=>S

L1

AND

TERMACombiningtheL#withotherL#=>S

L1

AND

L2Re-searchinganL#12/5/202332=>FILELCA=>SHYPERTENSION?L1141HYPERTENSION?=>SL1ANDDRUG#1334DRUG#L216L1ANDDRUG#=>EMERCK/CSE11MERCH/CSE21MERCHANTS/CSE369-->MERCK/CSE412MERCKANDCOINC/CSE55MERCKANDCOINCUSA/CSE62MERCKEAG/CSE72MERCKINSTTHERRESMERCKSHARPANDDOHMERESLABWESTPOINTPA19486USA/CSE82MERCKINSTTHERRESRAHWAYNJ07065USA/CSE92MERCKINSTTHERRESWESTPOINTPAUSA/CSE103MERCKPATENTGMBH/CSE112MERCKPATENTGMBHFEDREPGER/CSE121MERCKSHARPANDDOHMERESLABDIVMERCKANDCOINCRAHWAYNJUSA/CS=>SE3-E669MERCK/CS12"MERCKANDCOINC"/CS5"MERCKANDCOINCUSA"/CS2"MERCKEAG"/CSL369(MERCK/CSOR"MERCKANDCOINC"/CSOR"MERCKANDCOINCUSA"/CSOR"MERCKEAG"/CS)=>SL1ANDL3L41L1ANDL312/5/202333Re-usingintheDifferentDatabaseRe-usingintheDifferentDatabaseCombiningtheL#withothersearchterms=>S

L2

AND

TERMACombiningtheL#withL#generatedinthecurrentdatabase=>S

L1

OR

L612/5/202334=>FILELCA=>SULCER#ANDDRUG#54ULCER#1334DRUG#L18ULCER#ANDDRUG#=>FILELMEDLINE=>SL1125ULCER#3941DRUG#L240ULCER#ANDDRUG#=>SMISOPROSTOLL33MISOPROSTOL=>SL3ANDL1125ULCER#3941DRUG#L41L3ANDL112/5/202335REGISTRYL-NumberedAnswerSetsREGISTRYL-NumberedAnswerSetsDatabasewithSearchableCASRNs=>FILEREGISTRY=>SChemicalName/CNL1n“ChemicalName/CN”=>FILEDatabase1(CASRNsSearchable)=>SL1DatabaseNotContainingSearchableCASRNs=>FILEREGISTRY=>SChemicalName/CNL1n“ChemicalName/CN”SELECTName=>FILEDatabase2(CASRNsnon-Searchable)=>SE#12/5/202336=>FILELREGISTRY=>SEnalaprilacid3ENALAPRIL31528ACIDL11ENALAPRILACID(ENALAPRIL(W)ACID)=>DL1L1ANSWER1OF1COPYRIGHT2000ACSRN76420-72-9LREGISTRYCNL-Proline,N-[(1S)-1-carboxy-3-phenylpropyl]-L-alanyl-(9CI)(CAINDEXNAME)OTHERCAINDEXNAMES:CNL-Proline,1-[N-(1-carboxy-3-phenylpropyl)-L-alanyl]-,(S)-OTHERNAMES:CNEnalaprilacidCNEnalaprildiacidCNEnalaprilatCNMK422CNN-[1(S)-Carboxy-3-phenylpropyl]-L-alanyl-L-prolineFSSTEREOSEARCHMFC18H24N2O5CICOMLCSTNFiles:AGRICOLA,ANABSTR,BEILSTEIN*,BIOBUSINESS,BIOSIS,(