DIALOG Graduate Education Program

1
DIALOG Graduate Education Program
GEP
the value of information education

• Advanced Applications
• for Business on Dialog

Allison Evatt MLIS Consultant Eastern Region
2
Locating Company Information

• Basic company information
• Location
• Size
• Business description
• Sales figures
• Company management
• Corporate structure and ownership
• Financials
• Balance sheet
• Profit and loss statements
• Capitalization
• Operating ratios
• Credit worthiness
• Financial analysis

3
Choosing a Database

• Is the company public or private?
• What is (are) its location(s)?
• Is the location inside or outside the United
  States?
• What are the companys products and services?
• What is the size of the company number of
  employees, amount of sales?

4
Company Directory Databases

• DB Duns Market Identifiers (File 516)
• DB Duns Electronic Business Directory (File
  515)
• DB International Duns Market Identifiers
  (File 518)
• Other Duns Canada, European (Files 520,521)
• Standard Poors Register Corporate (File 527)
• Gale Group Company Intelligence (File 479)
• American Business Directory (File 531)
• Harris Business Profiler (File 537)
• ICC British Company Directory (File 561)
• Kompass Directories UK, Western Europe,
  Central/Eastern Europe, Asia/Pacific, USA (Files
  591,590,593,592,584)
• Teikoku Databank Japanese Companies (File 502)

5

• DIALOG(R)File 516D B - Duns Market
  Identifiers(Copr. 2002 DB). All rts.
  reserv.04522488Apple Computer Inc1 Infinite
  LoopCupertino, CA 95014-2083TELEPHONE
  408-996-1010COUNTY SANTA CLARA MSA 7400
  (San Jose, CA)REGION PacificBUSINESS Mfg
  Personal Computers and Peripheral Products
  Operating System and Application Computer
  SoftwarePRIMARY SIC 3571 Electronic
  computers, nsk 35719904 Personal computers
  (microcomputers)SECONDARY SIC(S) 3577
  Computer peripheral equipment, nec 35770102
  Printers, computer 3575 Computer
  terminals, nsk 35750100 Computer terminals,
  monitors and components 7372 Prepackaged
  software 73729905 Operating systems computer
  software 73729901 Application computer
  software

6

• LATEST YEAR ORGANIZED 1976STATE OF
  INCORPORATION CA DATE OF INCORPORATION
  01/03/1977ANNUAL SALES REVISION DATE
  01/04/2002 LATEST
  TREND BASE
  YEAR YEAR YEAR
  (2000)
  (1998)SALES 5,363,000,000
  5,363,000,000 7,983,000EMPLOYEES TOTAL
  11,473 8,568
  6,960EMPLOYEES HERE 2,000SALES
  GROWTH 2,000 NET WORTH
  3,920,000,000EMPLOYMENT GROWTH 23 SQUARE
  FOOTAGE 930,000 OwnedNUMBER OF ACCOUNTS
  NAACCOUNTING FIRM KPMG LLPBANK J P Morgan
  Chase Bank BANK DUNS 00-698-1831THIS
  IS A MANUFACTURING LOCATION A
  HEADQUARTERS LOCATION AN ULTIMATE LOCATION
  A CORPORATION A PUBLIC COMPANYDUNS
  NUMBER 06-070-4780CORPORATE FAMILY
  DUNS 06-070-4780

7

• VICE PRESIDENT Tribble,Guy /V Pres, Software
  TechnologySECRETARY Heinen,Nancy R /Sr V
  Pres-General Counsel-SecCOUNSEL Heinen,Nancy R
  /Sr V Pres-General Counsel-SecOPERATIONS Cook,
  Timothy D /Sr V Pres-Worldwide
  OperationsFINANCE Anderson, Fred D /Exec V
  Pres-CFO
• ENGINEERING Tribble, Guy /V Pres, Software
  Technology Johnson, Ronald B /Sr V Pres-New
  Business DevelopmentEXECUTIVE VICE PRESIDENT
  Anderson, Fred D /Exec V Pres-CfoSENIOR VICE
  PRESIDENT Johnson, Ronald B /Sr V Pres-New
  BusinessDevelopmentTevanian, Avadis Jr /Sr V
  Pres, Software EngineeringTamaddon, Sina /Sr V
  Pres, ApplicationsRubinstein, Jonathan /Sr V
  Pres, Hardware EngineeringCook, Timothy D /Sr V
  Pres-Worldwide OperationsHeinen, Nancy R /Sr V
  Pres-General Counsel-SecCHIEF EXECUTIVE OFFICER
  Jobs, Steven P /CEOADMINISTRATION Jobs,
  Steven P /CEO
• Heinen, Nancy R /Sr V Pres-General
  Counsel-SecCHIEF FINANCIAL OFFICER Anderson,
  Fred D /Exec V Pres-CFOENGINEERING VP Tribble,
  Guy /V Pres, Software Technology
• LATEST UPDATE TO RECORD 08/14/02

8

• Method 1 BEST
• BEGIN
• EXPAND
• SELECT
• TYPE
• B 516
• E coapple computer
• S E3E7
• S s1 and sfheadquarters
• T 2/9/1

9
EXPAND Command Tips

• Enter the appropriate prefix for the index you
  are searching, CO for company name, AU for
  author name, etc.
• Enter only the first part of the name or search
  term, just enough to go to the right section of
  the index. (E COFord Motor)
• Examine the list of E numbers carefully you may
  not be in the right section of the index if you
  entered the prefix incorrectly or used incorrect
  formatting of the name.
• Never enter any truncation or proximity operators
  in an EXPAND command EXPAND is completely
  literal, character by character.
• SELECT E (or R) numbers using the OR operator or
  the colon () range operator.
• SELECT all relevant E (or R) numbers before
  entering another EXPAND command. Each new EXPAND
  command erases the previous command.

10

• Method 2 Proximity Connectors (W) or (N)
• S W()R()Grace/CO
• S Anheuser()Busch/CO

11
Financial Information Databases

• Disclosure Database (File 101)
• Market Guide Company Financials (File 100)
• Extel International Financial Cards (File 500)
• DB Duns Financial Records Plus ( File 519)
• EdgarPlus (Files 534,773-780)
• MG Financial/Stock Statistics (File 546)
• Mergent Company Profiles (File 555)
• Ownership
• Directory of Corporate Affiliations (File 513)
• DB Who Owns Whom (File 522)

12
Company News Sources

• TYPES OF SOURCES
• Newspapers
• Newsletters
• Newswires
• Trade journals
• Broadcast transcripts
• DIALOG CHOICES
• DIALINDEX (File 411) Use co or /co
• OneSearch categories NEWSCO, INTLNEWS, PAPERSMJ
• Individual databases
• Business Industry, PROMT, ABI/INFORM, Trade
  Industry
• Newspapers, newsletters, newswires. Dialog Global
  Reporter.

13
Biographical Information Databases

• Marquis Whos Who (File 234)
• Use /NM or NM to search individual names
• Multiple indexes available, including occupation
  name, company, political/religious affiliation,
  professional memberships
• Standard Poors Register (File 526)
• Biographical information for 70,000 key
  executives (sales 1m)
• Use /NM or NM to search executive names
• Use CO to find name of executives primary
  company affiliation
• Use UC or GC to find name of executives
  college or university
• Biography Master Index (File 287)
• Key to information on 4,000,000 noteworthy
  persons from the beginning of recorded history to
  the present day
• Indexes 1500 biographical directories and
  dictionaries
• Use /NM or NM to search individual names

14
Using Controlled Vocabulary

• Descriptors Subject-related terms taken from a
  thesaurus or
• controlled vocabulary list and assigned to
  records by
• professional indexers.
• Multiple-word descriptors are called bound
  descriptors or descriptor phrases.
• Descriptor phrases are entered into the Basic
  Index in two ways
• Each individual word
• The phrase as a whole
• Identifiers Terms assigned to a record by an
  indexer, but generally not from a controlled
  vocabulary. Identifiers are typically proper
  names, geographic locations, or new words that
  are not yet in the thesaurus.

15
SELECTing Descriptor Terms

• If you SELECT a multiple-word phrase, including
  spaces and punctuation, Dialog retrieves the
  phrase only if it is an exact descriptor or
  identifier
• ? ?s teaching skills
• S1 3599 TEACHING SKILLS
• ?s teaching(w)skills
• 176850 TEACHING
• 126341 SKILLS (COMPLEX MENTAL AND/OR
  PHYSICAL BEHAVIORS THA...)
• S2 4435 TEACHING(W)SKILLS
• If you SELECT a single word and restrict with the
  suffix /DE, Dialog retrieves the word if it
  appears anywhere in a descriptor term
• ?s teaching/de
• S3 108277 TEACHING/DE
• retrieves records with descriptors such as
  Teaching Skills, Student Teaching, Science
  Teaching Centers, etc.
• To retrieve a single-word descriptor (such as
  Teaching), but not descriptor phrases that
  contain the word, use the suffix /DF
• ?s teaching/df
• S4 1031 TEACHING/DF

16
Searching the Additional Indexes

• Additional Index fields are also called prefixed
  fields.
• Typical Additional Index fields include
• Prefix Field Name Prefix Field Name
• AU Author Name LA Language
• PC Product Code or Standard PD Publication
  Date
• Industrial Classification (SIC) Code
• CO Company Namealso searchable PY
  Publication Year
• in the Basic Index using the /CO suffix
• CS Corporate Source DT Document Type
• TS Ticker Symbol JN Journal Name
• Using a prefix is required when searching the
  Additional Indexes.
• ?s teaching skills and dtconference?
• 3599 TEACHING SKILLS
• 93174 DTCONFERENCE?
• S3 530 TEACHING SKILLS AND
  DTCONFERENCE?
• To SELECT a group of entries from the same
  prefixed field, use
• parentheses

?s teaching skills and dt(conference paper or
journal article) 3599 TEACHING
SKILLS 85163 DTCONFERENCE PAPER
329895 DTJOURNAL ARTICLE
S2 1385 TEACHING SKILLS AND DT(CONFERENCE
PAPER OR JOURNAL ARTICLE)
17
Using Dialog OneSearch

• Enter BEGIN followed by any combination of file
  numbers and DIALINDEX categories, up to 60 files.
• ? b9,16 SYSTEMOS - DIALOG OneSearch
  File 9Business Industry(R)
  Jul/1994-2002/Oct 28 (c) 2002 Resp. DB
  Svcs. File 16Gale Group PROMT(R)
  1990-2002/Oct 28 (c) 2002 The Gale Group
• SELECT search terms as usual.
• Set Items Description --- -----
  -----------? s beer S1 17450 BEER

18
OneSearch Tips

• Codes, limits, prefixes, or suffixes that work
  in one file may not work in another file because
  the data elements or their equivalents are not
  present or differ. Be prepared for such
  differences by reviewing the Bluesheets and
  including alternative codes or forms of entry.
• Use proximity operators, particularly with
  descriptors, and consider qualifying to
  descriptor (/DE) and title (/TI). Bound
  descriptors are not likely to be the same across
  databases.
•  Use limit suffixes to modify the search after
  it is run on the basic concepts.
•  If you SELECT from an EXPAND display while
  constructing your strategy, be sure to use the OR
  and range (colon) operators so that the E numbers
  are saved as actual search terms.

19
Using SET DETAIL ON

• Enter SET DETAIL ON to see the number of records
  from each database, in addition to the total
  results.
• When SET DETAIL is ON, detailed record counts
  display for SELECT, EXPAND, and DISPLAY SETS
  commands.

20
Displaying Records in OneSearch

• Records display in this order
• All records from the first file in the BEGIN
  command display in reverse accession number
  order,
• Then all records from the second file display in
  reverse accession number order, etc.
• If you want to order the records so that records
  from all files are sorted together, you can do
  so. However, you can sort only on PD or PY when
  using OneSearch.

21
Using the FROM Option in OneSearch

• Command Example
• DISPLAY SETS Display sets from 16
• DS from each
• DISPLAY SETS Display sets s2 from 16
• EXPAND Expand JNfortune from 7
• SELECT Select gifted(w)child?/TI from 7
• TYPE Type s4/6/1-3 from each
• T s4/6/1-10 from 56
• FROM is required in some commands and must use a
  single file number.
• ORDER Order S1/3 SRC1 from 7
• SAVE ALERT Save alert from 7
• SORT on fields
• other than PY or PD Sort s1/all/au from 675

22
ADD and REPEAT

• Use ADD to include additional files in the
  OneSearch file group.
• Then enter REPEAT to create new sets that include
  results from the added files.

23
Detecting Duplicate Records

• A special set of commands lets you identify
  and/or remove duplicate records in bibliographic
  and full-text file searches.
• Each command creates a new set.
• Command and
• Abbreviation Example Function
• IDENTIFY DUPLICATES ID S5 Groups duplicate
  records ID together, retaining all
  records.
• REMOVE DUPLICATES RD S3 Removes duplicate
• RD records.
• IDENTIFY DUPLICATES ONLY Groups duplicate
  records IDO together, retaining only the
  IDO S4 duplicate records.

24
SORTing Records

• SORT command format
• ?sort s3/all/au,ti
• SORT creates a new set of the same records,
  rearranged according to the SORT parameters
• ?sort s3/all/au,ti
• S4 103 Sort S3/ALL//AU,TI
• SORT assumes the order to be ascending (A to Z,
  and lowest to highest numbers). To specify
  descending order, add the letter D after the
  field
• ?sort s7/all/em,d
• S8 103 Sort S7/ALL/EM,D

25
Creating Customized TablesREPORT Command

• Special feature available in many directory
  databases
• Create customized tables from the records you
  retrieve.
• To create a REPORT table, follow these five
  steps
•  1. Consult the Bluesheet to determine the fields
  you can use in the table and the number of
  characters needed for the full display.
• 2. Conduct your search to retrieve the set of
  records you want.
• 3. Enter a SET SCREEN command if needed to
  accommodate the size of REPORT table.
  (For instructions on the SET SCREEN command, see
  Successful Searching on Dialog.)
• 4. Sort the set by the field codes you want.
• 5. Enter the REPORT command, followed by sorted
  set number, field
• codes for table, and ranges of
  records. Use the command format
•   ?report s4/co,cy,st,sa/1-25

26
Sample REPORT

• File 516D B - Duns Market Identifiers
  2001/Oct
• (Copr. 2001 DB)
•   Set Items Description
• --- ----- -----------
• ?s sc2082 and stca
• 1141 SC2082 (MALT BEVERAGES)
• 1457269 STCA
• S1 186 SC2082 AND STCA
• ?sort s1/all/sa,d
•  
• S2 186 Sort S1/ALL/SA,D
• ?report s2/co,cy,sa/1-10
• Align paper press ENTER
• ?
•   DIALOG(R)File 516D B - Duns Market
  Identifiers
• (Copr. 2001 DB) All rts.
  reserv.
•  
• Company
  Sales
• Name City
  Dollars

27
Using the RANK Command

• Use RANK command to statistically analyze your
  search results for frequency of terms
• Helps evaluate search results and modify strategy
• RANK is available in phrase-indexed fields only
• Simple application of RANK
• Extracts terms from specified field in set of
  records and displays terms in ranked order.
• Syntax for RANK is
• RANK
  
•  Example
• Find the most prolific authors in the area of
  fractal research over the past two years.
• Search for articles about fractals
• Rank of authors to see which author ranks highest
  with the most articles on fractals in this
  database, then the next-most prolific author, and
  so on.
• Display a record to see the most prolific
  authors address.

28

• ?b 34 current
•  File 34SciSearch(R) Cited Ref Sci
  1990-2001/Sep W3
• (c) 2001 Inst for Sci Info
• CURRENT started
• Set Items Description
• --- ----- -----------
• ?s fractals/de
•   S1 139 FRACTALS/DE
• ?rank au
•  
• Started processing RANK
• ...Ranking 100 of 139 records
• Completed Ranking 139 records
• DIALOG RANK Results
• --------------------
• RANK S1/1-139 Field AU File(s) 34
• (Rank fields found in 139 records -- 336 unique
  terms) Page 1 of 42
• RANK No. Items Term

29

• Enter desired option(s) or enter RANK number(s)
  to save terms.
• ?2-6
•  
• RANK numbers saved 2-6
• DIALOG RANK Results
• --------------------
• RANK S1/1-139 Field AU File(s) 34
• (Rank fields found in 139 records -- 336 unique
  terms) Page 1 of 42
•  
• RANK No. Items Term
• -------- ----- ----
• 1 134 REPRINT)
• 2 5 RAMAKRISHNAN A
• 3 5 SADANA A
• 4 3 QUEIROSCONDE D
• 5 3 ROMEU J
• 6 2 BALIARDA CP
• 7 2 COURTIAL J
• 8 2 FALOUTSOS C

30

• P next page Pn Jump to page n
• P- previous page M More Options Exit
  Leave RANK
• To view records from RANK, enter VIEW followed by
  RANK number,
• format, and item(s) to display, e.g., VIEW
  2/9/ALL.
• Enter desired option(s) or enter RANK number(s)
  to save terms.
• ?EXIT
•  
• RANK results will be erased have you saved all
  the terms of interest?
• (YES/NO)
• ?y
•  
• Creating temporary SearchSave ... TD330
• Enter EXS to execute the SearchSave
• ?exs
•  
• Executing TD330

31

• ?t 8/3/1
•   8/3/1
• DIALOG(R)File 34SciSearch(R) Cited Ref Sci
• (c) 2001 Inst for Sci Info. All rts. reserv.
• 09924146 Genuine Article 466NH No.
  References 6
• Title Generalized Sierpinski fractal multiband
  antenna
• Author(s) Romeu J (REPRINT) Soler J
• Corporate Source Univ Politecn Catalunya, Dept
  Signal Theory Commun, Telecommun Engn
• Sch,E-08028 Barcelona//Spain/ (REPRINT) Univ
• Politecn Catalunya,Dept Signal Theory
  Commun, Telecommun Engn Sch,E-08028
  Barcelona//Spain/
• Journal IEEE TRANSACTIONS ON ANTENNAS AND
  PROPAGATION, 2001, V49, N8 (AUG), P1237-1239
• ISSN 0018-926X Publication date 20010800
• Publisher IEEE-INST ELECTRICAL ELECTRONICS
  ENGINEERS INC, 345 E 47TH ST, NEW YORK, NY
• 10017-2394 USA
• Language English Document Type LETTER
  (ABSTRACT AVAILABLE)

32
MAP Command

• Extract search terms from a specified field in a
  record or group of records
• Create a SearchSave of those terms
• Execute SearchSave in the same file or in a new
  file
• Eliminates the need to scan records for terms of
  interest and then re-key them into your search
  strategy
• Commonly mapped fields
• CAS Registry Numbers
• Patent Numbers
• DUNs Numbers

33

• B 516
• S sfminority owned and sa100m
• SORT s1/all/sa,d
• Set v 0
• REPORT s2/co,st/1-50
• MAP dn t
• B635
• Exs
•  Exs