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.
TopDatabase 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