1 / 33

DIALOG Graduate Education Program

This article explores the importance of Information Education in Graduate Programs and how it can enhance advanced applications for business. It discusses the value of obtaining company information such as basic details, financials, and corporate structure. It also provides a range of relevant databases available for conducting research and analysis.

dung
Download Presentation

DIALOG Graduate Education Program

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. GEP: the value of information education DIALOG Graduate Education Program 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 company’s products and services? • What is the size of the company – number of employees, amount of sales?

  4. Company Directory Databases • D&B – Dun’s Market Identifiers (File 516) • D&B – Dun’s Electronic Business Directory (File 515) • D&B – International Dun’s Market Identifiers (File 518) • Other Dun’s – Canada, European (Files 520,521) • Standard & Poor’s 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 516:D & B - Duns Market Identifiers(Copr. 2002 D&B). 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 co=apple computer S E3:E7 S s1 and sf=headquarters 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 CO=Ford 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) • D&B Dun’s 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) • D&B – 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 Who’s Who (File 234) • Use /NM or NM= to search individual names • Multiple indexes available, including occupation name, company, political/religious affiliation, professional memberships • Standard & Poor’s 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 executive’s primary company affiliation • Use UC= or GC= to find name of executive’s 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 Name—also 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 dt=conference? 3599 TEACHING SKILLS 93174 DT=CONFERENCE? S3 530 TEACHING SKILLS AND DT=CONFERENCE? • 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 DT=CONFERENCE PAPER • 329895 DT=JOURNAL 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,16SYSTEM:OS - DIALOG OneSearch File 9:Business & Industry(R) Jul/1994-2002/Oct 28 (c) 2002 Resp. DB Svcs. File 16:Gale 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 <set number> Display sets s2 from 16 EXPAND Expand JN=fortune 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 Tables—REPORT 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 516:D & B - Duns Market Identifiers 2001/Oct (Copr. 2001 D&B) Set Items Description --- ----- ----------- ?s sc=2082 and st=ca 1141 SC=2082 (MALT BEVERAGES) 1457269 ST=CA S1 186 SC=2082 AND ST=CA ?sort s1/all/sa,d S2 186 Sort S1/ALL/SA,D ?report s2/co,cy,sa/1-10 Align paper; press ENTER ?<enter>   DIALOG(R)File 516:D & B - Duns Market Identifiers (Copr. 2001 D&B) All rts. reserv. Company Sales Name City Dollars ------------------------------ ------------- ----------- S & P Company Inc Mill Valley 900,000,000 Anheuser-Busch Incorporated Van Nuys 108,400,000 Miller Brewing Company Inc Irwindale 93,700,000 Anheuser-Busch Incorporated Suisun City 54,500,000 Associated Microbreweries, Inc San Diego 34,000,000 McKenzie River Partners San Francisco 16,900,000 Pyramid Breweries Inc Berkeley 12,500,000 Faultline Brewing Co, Inc Sunnyvale 11,100,000 Thirsty Bear Brewing Co San Francisco 9,800,000 Mendocino Brewing Company, Inc Ukiah 9,255,900

  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 <field> <set number> <range>  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 author’s address.

  28. ?b 34 current  File 34:SciSearch(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 -------- ----- ---- 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 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.

  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 P = next page Pn = Jump to page n P- = previous page M = More Options Exit = Leave RANK

  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 S2 14 AU="RAMAKRISHNAN A" S3 12 AU="SADANA A" S4 3 AU="QUEIROSCONDE D" S5 18 AU="ROMEU J" S6 2 AU="BALIARDA CP" S7 41 S2:S6 ?c 1 and 7 139 1 41 7 S8 12 1 AND 7

  31. ?t 8/3/1   8/3/1 DIALOG(R)File 34:SciSearch(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 sf=minority owned and sa>100m SORT s1/all/sa,d Set v 0 REPORT s2/co,st/1-50 MAP dn t B635 Exs  Exs

More Related