Building Databases and the Cocitation Counts Generation System Using Microsoft Excel Program in Visual Basics

Building Databases and the Cocitation Counts Generation System Using Microsoft Excel Program in Visual Basics

Sean Eom (Southeast Missouri State University, USA)
DOI: 10.4018/978-1-59904-738-6.ch006
OnDemand PDF Download:
$37.50

Abstract

This chapter shows another alternative approach of building citation database and retrieval system using the spreadsheet program, Microsoft Excel. McIntyre built a custom database based on the Clothing and Textile Research Journal (CTRJ), covering from 1990 to 2006 as part of his master’s thesis. The database includes all the author citations, citations sorted by article, and the top cited author’s cocitation frequencies.
Chapter Preview
Top

Database Design

McIntire completed his Master’s thesis in the department of textile and apparel management. He built a custom database based on the Clothing and Textile Research Journal (CTRJ), covering from 1990 to 2006. The database includes all the author citations, citations sorted by article, and the top cited author’s cocitation frequencies. Using the chronological list of Clothing and Textile Research Journal (CTRJ), each article published between 1990-2006 was viewed as a PDF document. Each article was assigned a six digit number: the first four digits representing the publication year, the fifth and sixth digits representing the article number for that year beginning with one.

Example: the article Dickerson, K.G. & Dalecki, M. Apparel Manufacturers’ Perceptions of Supplier-Retailer Relationships would be assigned the article number 1990-10, since it was published in 1990 and is the tenth article published in CTRJ that year.

A custom database is created containing the names of all cited authors and when and where they were cited. Within an Excel spreadsheet, a column is titled with the appropriate article number. The rows are labeled alphabetically with author names. Each time an author is listed in the reference section of the article, it is counted in the article column.

Figure 1 shows how the references of article 1990-10 are entered into the excel database. The visible portion of the references lists four authors and a coeditor. The other co-editor, B.N. Feinberg, is not one of the final author sets under study.

Figure 1.

Example for article 1990-10

  • It is notable that multiple authors in one article are counted regardless their position. For example, the second article has two coauthors (Chaffin and Andersson). The database equally treats the two authors by entering the two authors individually and gives an equal number of citation count of 1.

  • Multiple citations are counted, i.e. four references of Chaffin in article 1990-11 would be entered as a 4 in Excel for the author in the appropriate article number column.

The citation counts compiled above are spot checked for accuracy. The final document appears as this:

The citation counts are divided into five year blocks: 1990-1995, 1996-2000, 2001-2006. An arbitrary number of top cited authors are selected, and a matrix is formed showing how often they are cited in the same documents.

The cocitation count is limited by the author cited the least. An author cited four times, and another cited twice, will only be counted as cocited twice. For example, consider the following citation count.

Once this is transformed into a cocitation count, the matrix would include the following pairs:

Figure 5 is an excerpt from the actual cocitation matrix.

Figure 5.

An excerpt from the actual co-citation matrix

Complete Chapter List

Search this Book:
Reset
Table of Contents
Acknowledgment
Sean B. Eom
Chapter 1
Sean Eom
Author cocitation analysis (ACA) is a branch of bibliometrics. Bibliometrics/informetrics is one of the older areas of library and information... Sample PDF
An Introduction to Bibliometrics and Informetrics
$37.50
Chapter 2
Sean Eom
This chapter introduces online citation data retrieval using the Web of Science and Dialog Classic. The Web of Science provides access to... Sample PDF
An Introduction to Online Data Retrieval and Issues
$37.50
Chapter 3
Sean Eom
Virtually all ACA studies using Thomson’s ISI citation indexes used only the first author to retrieve the cocitation counts. Therefore, this has... Sample PDF
The Impact of the ISI Convention of Relying on only the Name of the First Author on ACA Results: An Empirical Investigation
$37.50
Chapter 4
Diagonal Values in ACA  (pages 91-121)
Sean Eom
Diagonal values in the cocitation frequency counts matrix are a fundamental issue in ACA study. Diagonal values are the co-citation frequency counts... Sample PDF
Diagonal Values in ACA
$37.50
Chapter 5
The Fox-Base Approach  (pages 123-136)
Sean Eom
Chapter II introduced online cocitation counts retrieval using Dialog Classic and citation index files. Certainly Dialog Classic is an attractive... Sample PDF
The Fox-Base Approach
$37.50
Chapter 6
Sean Eom
This chapter shows another alternative approach of building citation database and retrieval system using the spreadsheet program, Microsoft Excel.... Sample PDF
Building Databases and the Cocitation Counts Generation System Using Microsoft Excel Program in Visual Basics
$37.50
Chapter 7
Sean Eom
The previous two chapters examined the two alternative approaches of retrieving cocitation counts using custom databases and cocitation frequency... Sample PDF
Overview of Author Cocitation Analysis Procedures
$37.50
Chapter 8
Sean Eom
This chapter describes the factor procedure. The first section of the chapter begins with the definition of factor analysis. This is the statistical... Sample PDF
Principal Component Analysis Using the Factor Procedure
$37.50
Chapter 9
Sean Eom
This chapter describes the distance and cluster procedure of the SAS system. SAS version 9 introduced the proc distance procedure. All previous... Sample PDF
The Distance and Cluster Procedure
$37.50
Chapter 10
Multidimensional Scaling  (pages 225-254)
Sean Eom
This chapter discusses multidimensional scaling (MDS) procedures. MDS is a class of multivariate statistical techniques/procedures to produce two or... Sample PDF
Multidimensional Scaling
$37.50
Chapter 11
Sean Eom
This chapter briefly introduces the use of SPSS version 15.0 to conduct ACA analysis. The SPSS accepts datafiles in many different formats including... Sample PDF
ACA Analysis with the 15.0.0 Verison of SPSS for Windows
$37.50
Chapter 12
Sean Eom
This is the capstone chapter that shows how the concepts, tools, and techniques discussed in each of the previous chapters can be applied in... Sample PDF
The Intellectual Structure of Decision Support Systems Research (1969-1989)
$37.50
Chapter 13
Sean Eom
This chapter extends an earlier benchmark study (Sean B. Eom, 1995) which examined the intellectual structure, major themes, and reference... Sample PDF
The Changing Structure of Decision Support Systems Research: An Empirical Investigation through Author Cocitation Mapping (1990-1999)
$37.50
About the Author