Shareware Overload/ShartewareOverload.cdr/educ/retrv_pc.zip/RETRIEVE.DOC

Text File | 1984-12-21 | 16KB | 459 lines

        RETRIEVE: A REFERENCE ARTICLE CITATION FILING AND
         RETRIEVAL SYSTEM USING THE dBASE II* RELATIONAL
                   DATABASE MANAGEMENT SYSTEM

                     - for IBM-PC DOS 2.0 -



                     David A. Lathrop, Ph.D.



              CARDIAC ELECTROPHYSIOLOGY LABORATORY
             CHILDREN'S HOSPITAL RESEARCH FOUNDATION
                     CINCINNATI, OHIO  45229
                         [phone]


I. DESCRIPTION:

     R+E+T+R+I+E+V+┼á i≤ ß collectioε oµ dBAS┼ II¬ commanΣá file≤ ì
whicΦ allo≈ creatioε oµ ß referencσ articlσ citatioε databasσ fo≥ ì
retrieva∞ b∙ aε assigneΣ referencσ number¼ author¼ title¼ source¼ ì
o≥á ke∙ word«á  T∩ usσ thσ system¼á yo⌡ mus⌠ posses≤ ß versioε oµ ì
thσá dBAS┼ II¬ assembly-languagσ relationa∞á databasσá managemen⌠ ì
system«

     Thσáá R+E+T+R+I+E+V+┼á systeφá allow≤á thσá use≥á t∩áá storσ ì
referencσ articlσ citation≤ b∙ authors¼á title¼ source¼ ke∙ word≤ ì
anΣá ß codσ t∩ bσ useΣ iε filinτ thσ origina∞ article«á  Thi≤á i≤ ì
donσá b∙á allowinτá thσ use≥ t∩ inpu⌠ record≤ int∩á ßá dBAS┼á II¬ ì
databasσ filσ nameΣ REFS.DB╞ havinτ thσ followinτ structure:


                FL─     NAM┼      TYP┼ WIDTH
                ---     ----      ---- -----
                00▒   REF:N╧       ├    005
                00▓   AUTHOR╙      ├    080
                00│   TITL┼        ├    160
                00┤   SOURC┼       ├    080
                00╡   KWORD╙       ├    080

     Thσá systeφá consist≤á oµá oµ thσ followinτá ninσá dBAS┼á I╔ ì
commanΣ files║

RETRIEVE.PRG  NEW.PRG       AUTONUMB.PRG  FIND.PRG
FASTFIND.PRG  INDEX.PRG     LABEL.PRG     EDIT.PRG

     Onl∙ onσ databasσ filσ i≤ created¼á REFS.DBF«á  Inde°á file≤ ì
arσá createΣá oεá fou≥á oµá thσá fields╗á REF#.NDX¼á AUTHORS.NDX¼ ì
SOURCE.NDX¼ anΣ KWORDS.NDX«


OPERATION:

     Oncσ yo⌡ havσ typeΣ 'DBAS┼ RETRIEVEº o≥ 'D╧ RETRIEVEºá (froφ ì
withiεá DBasσá ][)¬ thσ monito≥ screeε wil∞ blanδ anΣá ßá messagσ ì
wil∞á appea≥á askinτ you¼á thσ user¼á t∩ ente≥á thσá date«á  Thi≤ ì
versioε oµ R+E+T+R+I+E+V+┼ assumσ tha⌠ you≥ defaul⌠ drivσ i≤ useΣ ì
fo≥á datßá storage«á  Thσ maiε R+E+T+R+I+E+V+┼ prograφ men⌡á wil∞ ì
nex⌠ appear.

____________________

¬á Wσ recommenΣ tha⌠ yo⌡ renamσ DBASE.CO═ a≤ DO.CO═ fo≥á easσá oµ ì
operation in all DBase ][ programming applications.


                 ***  REPRINT FILE MENU ***

        0 - EXIT PROGRAM
        1 - ENTER NEW ARTICLES
        2 - ENTER NEW ARTICLES WITH
            (AUTOMATIC REFERENCE NUMBERING)
        3 - FIND ARTICLES
        4 - QUICKLY FIND ARTICLES
            (BY FIRST AUTHOR, FIRST KEY WORD,
            OR FIRST 20 LTRS OF SOURCE)
                5 - LOCATE ARTICLES & MAKE TEXT FILE
        6 - RE-INDEX FILES
                7 - MAKE LABELS FOR ARTICLES
        8 - EDIT DATA BASE RECORDS

ENTER DESIRED ACTION
  WAITING



OPTION 0 - EXIT

     Iµá yo⌡á no≈ typσ '0'¼á thσ prograφ wil∞ exi⌠ t∩ thσá PC-DO╙ ì
promp⌠á afte≥á firs⌠ displayinτ ß messagσ tellinτá yo⌡á ho≈á man∙ ì
record≤ arσ presentl∙ containeΣ iε thσ datß basσ (REFS.DBF).

           *** REFS.DBF CONTAINS 1043 RECORDS ***



*** END RUN     dBASE II    ***

A>

*¬ NOT┼ *¬ T∩ re-rente≥ R+E+T+R+I+E+V+┼ typσ 'D╧ RETRIEVE'.




OPTION 1 - ENTER NEW ARTICLES:

     Iµ yo⌡ haΣ entereΣ '1'¼ thσ prograφ woulΣ havσ beeε directeΣ ì
t∩á thσ commanΣ filσ NEW.PR╟ anΣ afte≥ answerinτ thσ prompt¼á '*¬ ì
WAN╘ T╧ CONTINUE┐á (Y/N⌐ **º b∙ typinτ 'Y'¼á thσ followinτá inpu⌠ ì
forφ woulΣ appea≥ oε you≥ monitor:


               REPRINT INFORMATION ENTRY FORM


 REF. NO. :     :

  AUTHORS :                                         :
          :                                         :

    TITLE :                                         :
          :                                         :
          :                                         :
          :                                         :
          :                                         :

   SOURCE :                                         :
          :                                         :

KEY WORDS :                                         :
          :                                         :


     Thi≤á inpu⌠á forma⌠á allow≤ fivσ character≤á fo≥á aεá alpha-ì
numeriπá codσ unde≥ whicΦ t∩ filσ thσ article¼á 8░ character≤á t∩ ì
ente≥á thσ author≤ name(s)¼á 16░ character≤ fo≥ thσ titlσ oµá thσ ì
article¼ 8░ character≤ fo≥ itsº source¼ anΣ 8░ character≤ fo≥ ke∙ ì
indexinτ words«

     Thσá systeφ wa≤ designeΣ s∩ tha⌠ article≤ arσ assigneΣ code≤ ì
consistinτá oµ thσ firs⌠ lette≥ oµ thσ firs⌠ author'≤á las⌠á namσ ì
followeΣ b∙ ß number«á  Thσ numbe≥ simpl∙ tell≤ iµ thσ articlσ i≤ ì
thσ 1¼á 2¼ 3¼ ...nthö articlσ witΦ firs⌠ author≤ whosσ las⌠ namesº ì
begiεá witΦá ß particula≥ lette≥ iε thσ owner'≤á referencσá file«  ì
Thi≤á numbe≥á i≤á incrementeΣá b∙ onσ eacΦ timσá thσá filσá owne≥ ì
receive≤ ß ne≈ articlσ whosσ firs⌠ author'≤ las⌠ namσ begin≤ witΦ ì
thσá samσ letter«á  Thi≤ codinτ systeφ allow≤ thσ filσá owne≥á t∩ ì
maintaiεá ßá filσá witΦ u≡ t∩ 259,97┤á seperatσá citations«á  An∙ ì
codinτ systeφ usinτ ╡ characte≥ alpha-numerics¼á however¼á ma∙ bσ ì
used«

     *¬á IMPORTAN╘á *¬  Thσ firs⌠ author'≤ namσ mustôá bσá entereΣ ì
last-name-firs⌠ iε orde≥ fo≥ optioε ┤ (QUICKL┘ FIN─ ARTICLES⌐á t∩ ì
functioε correctly«  Aε articlσ b∙ DaviΣ A« Lathro≡ anΣ Johε Doe¼ ì
therefore¼á woulΣ bσ entereΣ a≤ 'Lathrop¼á D.A.¼á Doe¼á J.'«á  Aε ì
examplσ oµ ß completeΣ inpu⌠ i≤ showε below:

è


               REPRINT INFORMATION ENTRY FORM


 REF. NO. :L0003:

  AUTHORS :Lathrop, D.A., Bailey, J.C.              :
          :                                         :

    TITLE :The high resistance junction between the :
          :canine left bundle branch and adjacent   :
          :ventricular septal muscle.               :
          :                                         :
          :                                         :

   SOURCE :Clin. Res. 23(4):472A, 1975              :
          :                                         :

KEY WORDS :electrotonus - left bundle branch        :
          :                                         :


OPTIO╬ ▓ - ENTE╥ ARTICL┼ WIT╚ AUTOMATI├ REFERENC┼ NUMBERING:

     Thi≤á optioεá i≤á simila≥á t∩á optioεá 1¼á excep⌠á tha⌠á thσ ì
R+E+T+R+I+E+V+┼á prograφ wil∞ searcΦ thσ databasσ filσ (REFS.DBF⌐ ì
fo≥á thσ las⌠ referencσ numbe≥ entereΣ fo≥ ßá particula≥á letter¼ ì
increment≤á thi≤á numbe≥ b∙ ▒ anΣ assign≤ t∩ thσ ne≈á citatioεá ß ì
codσá consistinτá oµ thσ firs⌠ lette≥ oµ thσ firs⌠ author'≤á las⌠ ì
namσ plu≤ thσ number«

     *¬á IMPORTAN╘ *¬ Usσ oµ thi≤ optioε assume≤ thσ usσá oµá thσ ì
codinτá systeφ suggesteΣ unde≥ optioε 1íá  Thσ followinτ show≤ aε ì
examplσá oµá ß completeΣ optioε ▓ inpu⌠ forφá anΣá thσá resultinτ ì
referencσ numbe≥ assigneΣ t∩ thσ articlσ b∙ thσ program:




               REPRIN╘ INFORMATIO╬ ENTR┘ FORM


  AUTHOR╙ :Lathrop¼ D.A.¼ Elharrar¼ V.¼ Foster¼ P.R.:
          :Bailey¼ J.C.¼ Zipes¼ D.P«                :

    TITLE :Suppression of barium induced automa-    :
          :ticity with manganese and verapamil.     :
          :                                         :
          :                                         :
          :                                         :

   SOURCE :Clin. Res. 23(4):472A, 1975              :
          :                                         :

KEY WORDS :barium - manganese - verapamil - calcium :
          :                                         :

 REF. NO. :L0004:


OPTION 3 - FIND ARTICLES

     Thi≤á optioεá allow≤ thσ use≥ t∩ locatσ record≤á withiεá thσ ì
datß basσ b∙ matchinτ u≡ t∩ threσ substring≤ founΣ iε u≡ t∩ threσ ì
differen⌠ recorΣ fields«  Thσ substring≤ ma∙ bσ entereΣ iε eithe≥ ì
UPPE╥ o≥ lowe≥ caseíá  Thσ outpu⌠ oµ thi≤ optioε ma∙ bσ displayeΣ ì
eithe≥ oε thσ monito≥ o≥ thσ printer«

     *¬á NOT┼á *¬á Thi≤á optioε ma∙ bσ usσ t∩á lis⌠á allôá oµá thσ ì
citation≤á containeΣ withiε thσ databasσ b∙ enterinτ '3º fo≥á thσ ì
1s⌠á FIEL─ T╧ SEARC╚ ON¼á `<SPACE>º fo≥ thσ SUBSTRIN╟ T╧á LOCATE¼ ì
anΣá defaultinτá (i.e.ô '<RETUNR>'⌐ througΦ thσá remaininτá SEARC╚ ì
INFORMATIO╬ prompts.

     Thσáá followinτá show≤á aεá examplσá oµá thσá monito≥á inpu⌠ ì
informatioε screen¼á thσ user'≤ responses¼á anΣ thσ firs⌠ printeΣ ì
resul⌠ obtaineΣ durinτ usσ oµ optioε 3:




           *** REFS.DBF CONTAINS 1043 RECORDS ***

             EACH RECORD CONSISTS OF 5 FIELDS:

                 (1) REF:NO     (4) SOURCE
                 (2) AUTHORS    (5) KWORDS
                 (3) TITLE

         _________________________________________

               ** ENTER SEARCH INFORMATION **è
1st FIELD TO SEARCH ON (1-5) :2:  SUBSTRING TO LOCATE :LATHROP       :
2nd FIELD TO SEARCH ON (1-5) :3:  SUBSTRING TO LOCATE :HUMAN         :
3rd FIELD TO SEARCH ON (1-5) :5:  SUBSTRING TO LOCATE :DILTIAZEM     :

           DO YOU WANT RESULTS PRINTED? (Y/N) :y:

--------------------

 REF. NO. : L0002
AUTHOR(S) : Lathrop, D.A., Valle, R., Gaum, W.E.
            Schwartz, A., Kaplan, S.
    TITLE : The effect of diltiazem and nisoldipine
            on spontaneously active human atrial
            tissue.
   SOURCE : J. Molec. Cell. Cardiol. 13(1):111-115,
            1981
KEY WORDS : diltiazem - nisoldipine - human atrium -
            calcium blockers


OPTION 4 - QUICKLY FIND ARTICLES

     Thi≤ optioε i≤ simila≥ t∩ optioε 3«á  It≤ majo≥ advantagσ i≤ ì
speed«á  Optioε 4¼ however¼ ha≤ somσ disadvantage≤ ove≥ optioε 3«  ì
Thesσ arσ tha⌠ optioε ┤ wil∞ onlyô finΣ article≤ wherσ thσ entereΣ ì
author'≤ name¼á ke∙ word,orô thσ firs⌠ 2░ character≤ oµ thσ sourcσ ì
arσá firstô iε thσ databasσ filσ records«á  Iµ thσ use≥á want≤á t∩ ì
looδá fo≥ article≤ wherσ ß particula≥ autho≥ i≤ thσ firs⌠á autho≥ ì
thi≤á optioε wil∞ bσ u≡ t∩ 1░ time≤ fasterô (dependinτ oε thσ sizσ ì
oµ thσ database⌐ thaε optioε threσ iε findinτ thσ citations«  Thσ ì
othe≥á disadvantagσ oµ thi≤ optioε i≤ tha⌠ i⌠ require≤á tha⌠á thσ ì
databasσ bσ indexeΣ oε authors¼á source¼ anΣ ke∙ words«  Creatioε ì
oµá thesσ inde° file≤ require≤ usσ oµ disδ storagσ spacσ whicΦ iε ì
turε wil∞ limi⌠ thσ sizσ oµ thσ databasσ tha⌠ thσ use≥ i≤ ablσ t∩ ì
create«á  A≤ aε example¼ a⌠ thσ timσ oµ thi≤ manual'≤ preparatioε ì
thσá origina∞á R+E+T+R+I+E+V+┼ databasσá containeΣá 104│á record≤ ì
whicΦá requireΣ 159╦ oµ disδ storagσ anΣ eacΦ oµ thσ inde°á file≤ ì
(AUTHORS.NDX¼á SOURCE.NDX¼ anΣ KWORDS.NDX⌐ requireΣ approximatel∙ ì
150╦á oµá disδá space«áá  Therefore¼á iµá thσá inde°á file≤á werσ ì
eliminateΣá REFS.DB╞á coulΣá bσ increaseΣ b∙á  pproximatel∙á 300░ ì
record≤á anΣá occup∙á thσ samσ amoun⌠ oµ spacσá oεá thσá origina∞ ì
R+E+T+R+I+E+V+┼á storagσá diskettσá (whicΦá wa≤á ßá double-sided¼ ì
double-densit∙áá 8-incΦá diskettσá providinτá onσá mega-bytσáá oµ ì
storage)«  Thσ followinτ show≤ aε example║

                     *** REFS.DBF CONTAINS 1043 RECORDS ***

*** WARNING: This program finds only EXACT matches to the substring entered ***
* Files are indexed by first author,  first 20 chrs of source, first key word *
* Therefore,  this program  will  only find records  where  an author  is the *
* first author, or where a key word is the first key word, etc.!!!!           *

                         POSSIBLE FIELDS TO SEARCH ON:
è                          (1) AUTHORS   (3) KEY WORDS
                          (2) SOURCE

                 _____________________________________________

                         ** ENTER SEARCH INFORMATION **

         FIELD TO SEARCH ON (1-3) :1:

         SUBSTRING TO LOCATE :Lathrop                                 :

                     DO YOU WANT RESULTS PRINTED? (Y/N) :y:

-----------------------

           REF. NO. : L0001
          AUTHOR(S) : Lathrop, D.A., Bailey, J.C.
              TITLE : Lack of electrical interaction between
                      proximal bundle branches and subjacent
                      muscle.
             SOURCE : J. Appl. Physiol. 42(2):235-239, 1977
          KEY WORDS : electrotonus - excitability - bundle of
                      His - His-Purkinje system


OPTION 5 - LOCATE ARTICLES & MAKE TEXT FILE



OPTION 6 - RE-INDEX ARTICLES

     Thi≤ optioε provide≤ aε eas∙ mean≤ t∩ re-inde° thσ datß basσ ì
oε firs⌠ author'≤ name¼ source¼ anΣ firs⌠ ke∙ word«

     *¬á NOT┼ *¬ Re-indexinτ i≤ requireΣ wheε ne≈á citation≤á arσ ì
addeΣá t∩á thσá databasσá iεá orde≥á fo≥á optioεá ┤á t∩á functioε ì
correctly«

     *¬á IMPORTAN╘ *¬ Thi≤ optioε shoulΣ onl∙ bσ useΣ iµ thσ use≥ ì
intend≤ t∩ usσ optioε ┤ (seσ explanatioε iε descriptioε oµ optioε ì
4).



OPTIO╬ 7 - MAK┼ LABEL╙ FO╥ ARTICLES

     Thi≤á optioεá provide≤á thσ use≥ witΦ label≤á whicΦá ma∙á bσ ì
affixeΣá t∩ thσ origina∞ referencσ articlσ fo≥á filinτá purposes«  ì
EacΦá labe∞ wil∞ identif∙ thσ owne≥ oµ thσ article¼á thσ assigneΣ ì
referencσ numbe≥ anΣ ke∙ word≤ unde≥ whicΦ thσ citatioε i≤á fileΣ ì
iεá thσ databasσ (REFS.DBF)«á  Belo≈ i≤ aε examplσ oµ thσá label≤ ì
produceΣ b∙ usσ oµ thi≤ option:


OPTIO╬ 8 - EDI╘ DATABAS┼ RECORDSè
     Optioεá ╖ allow≤ thσ use≥ ß convenien⌠ wa∙ t∩ edi⌠á specifiπ ì
databasσ record≤ afte≥ the∙ havσ beeε entered«  ┴ specifiπ recorΣ ì
ma∙á bσá locateΣ withiε thσ databasσ b∙ searchinτ fo≥ i⌠á b∙á it≤ ì
referencσ number¼á autho≥ string¼ titlσ string¼ o≥ sourcσ string«  ì
Usuall∙á thσ use≥ wil∞ kno≈ thσ aggigneΣ referencσ numbe≥ oµá thσ ì
databasσ recorΣ tha⌠ he/shσ desire≤ t∩ edit╗á therefore¼á thi≤ i≤ ì
thσ program'≤ defaul⌠ modσ fo≥ locatinτ records.

     *¬á NOT┼ *¬  Iµ morσ thaε onσ recorΣ ha≤ thσ samσá referencσ ì
number¼ al∞ oµ thesσ record≤ wil∞ bσ located.

     Oncσá locateΣá thσá recorΣá ma∙á bσá editeΣá o≥á markeΣá fo≥ ì
deletion«  Iµ editeΣ thσ olΣ recorΣ wil∞ bσ writteε ove≥ witΦ thσ ì
ne≈á information╗á i.e«á ß ne≈ recorΣ wil∞ no⌠ bσ appendeΣ t∩ thσ ì
file«á  Iµ thσ use≥ choose≤ t∩ marδ thσ recorΣ fo≥ deletion¼á thσ ì
recorΣá wil∞ no⌠ bσ permanentl∙ deleteΣ unti∞ thσ filσ i≤á PACKE─ ì
(seσ you≥ dBAS┼ II¬ user'≤ manual)«

     Finally¼á thσá prograφ wil∞ promp⌠ thσ use≥ witΦ ßá questioε ì
askinτá iµá he/shσ want≤ t∩ permanentl∙ removσ thσá markeΣá file≤ ì
froφá thσ datß base«á  Iµ thσ use≥ answer≤ affirmativel∙ t∩á thi≤ ì
questioεá thσ filσ wil∞ bσ PACKE─ anΣ al∞ thσ record≤ markeΣá fo≥ ì
deletioε wil∞ bσ removeΣ froφ thσ fileí

     *¬á IMPORTAN╘á *¬  Afte≥ thσ databasσ ha≤á beeεá PACKE─á thσ ì
deleteΣá record≤á ma∙ neve≥ bσ recovered-- the∙á arσá GONEíá   Bσ ì
carefu∞ wheε usinτ thi≤ option.



          ********¬ *********¬ ********¬ *********
          ********¬ *********¬ ********¬ *********

     Yo⌡á arσá no≈ read∙ t∩ experimen⌠ witΦá R+E+T+R+I+E+V+E«á  ╔ ì
hopσá tha⌠ yo⌡ wil∞ enjo∙ usinτ thσ systeφ anΣ tha⌠ i⌠ wil∞á hel≡ ì
yo⌡á t∩á maintaiεá ßá completσ filσá oµá you≥á referencσá articlσ ì
citations¼ n∩ matte≥ wha⌠ you≥ area≤ oµ interestí


--------------------
* dBASE II* was developed and is distributed by,
  Ashton-Tate, Culver City, California





             **************************************
                      ---- FINAL NOTE ----
             **************************************


     Iµá yo⌡á finΣ thi≤ se⌠ oµ program≤ useful¼á wσ asδ tha⌠á yo⌡ ì
make a contribution to:

             Children's Hospital Research Foundation
                  Division of Cardiac Research
                   Elland and Bethesda Avenues
                     Cincinnati, Ohio 45229

     B∙á makinτá ß contributioε you≥ namσ wil∞ bσ placeΣá oεá ou≥ ì
mailinτá lis⌠á whicΦá wil∞ includσ an∙á futurσá update≤á oµá thi≤ ì
program«á Iµ yo⌡ woulΣ likσ t∩ contributσ software,yo⌡ ma∙ uploaΣ ì
program≤á directl∙ t∩ thσ CHRF'≤ Divisioε oµ Cardiolog∙á Bulletiε ì
Board [[phone]].