Folk Index Database Information

This index was originally created and is currently updated and maintained using Alpha4, a relational databse management software. Currently the database files reside on my home PC, an IBM Thinkpad model, using the DOS v.8 version of Alpha4. The files, consist of both primary and index link files. The primary files include: These primary files, which contain a unique ID for each record, are used to create the link files as described below. Other files include instrument files, and music category. They serve mainly as lookup files or auxilliary files that are not completely linked to the primary files.

Web file Management
Transferring a relational database system to the text based environment of web browsers requires considerable adjustment. Since the web is all about transmitting files over the internet, large files present problems. The original discography created by Alpha4 was about 3.5 Meg. Breaking this up into smaller files of about 30-50K and then establishing an index to these files is relatively easy, but the issues of presentation and the idea of creating "active" cross references presented some interesting challenges in terms of both web page and data management.

Since Alpha4 has a very sophisticated report writing facility, I decided to use this facility to generate these individual files with the required HTML markup. This meant establishing an additional datafile to store information about each separate file in order to generate the correct cross reference name anchors and links. A new field containing the name of the web file it apears in was added to the primary music database. In many ways, it is convenient to think of these 400 odd files as drawers in an old fashioned library catalog, with the cross references functioning to point you to other related entries in the catalog. The HTML hypertext link now gives instant movement between these cross references.

Future enhancements that I have considered in the past are discussed below, and it is possible that I maybe able to carry out some of this in the coming months, since the changes would not affect the search facilities of the site.

A slightly more detailed description of the process involved in transforming this relational database structure into the current Web Site design is provided in a handout distributed as part of my poster session presentation at the Association for College & Research Libraries Conference in Detroit on April 9, 1999. 

Other statistics - Listed here are some statistics with respect to ranking of specific titles and performers. The rank frequency distribution for both music titles and performers follows the typical "80-20" rule, with approximately 80% of the songs and performers appearing 20% of the time, and 20% of the listings appearing 80% of the time. Thus there is a "top hits" distribution for both titles and performers.

Music titles - The list below show the top 12 entries for songs and ballads and then for dance tunes. On an absolute basis, the tunes outnumber the songs in terms of the 10 highest ranked, and this probably reflects my involvement as a stringband musician (fiddle, banjo, dulcimer, guitar, etc.) in collecting and indexing both the older recorded material and the modern "old-time stringband" revival recordings and books.

Ballads and Songs
Title Total hits Cross Refs Books Records
John Henry 293 18 84 191
Barbara Allen 220 17 125 88
Froggie Went A-Courting 156 11 88 57
Buffalo Gals 153 12 63 78
House Carpenter 140 7 91 42
Coo Coo Bird 130 14 47 89
Pretty Polly* 124 10 53 61
Golden Vanity 120 9 60 51
Lonesome Road Blues 118 14 39 65
John Hardy 126 5 50 71
Wildwood Flower 124 6 55 63
Girl I Left Behind Me 123 16 61 46
*does not include any of the Cruel Ship's Carpenter versions.

Dance music (Reels, Hornpipes, etc.) - included here pieces that are primarily used as music to be danced to. Some, such as Old Joe Clark which has many lyrics, are associated with square dances, but were also sung in a wide variety of settings, including children's games, show and display music, and many other social events.

Title Total hits Cross Refs Books Records
Old Joe Clark 253 7 94 152
Soldier's Joy 242 14 70 158
Turkey in the Straw 205 24 69 112
Sally Goodin 180 14 42 124
Cripple Creek 183 12 51 120
Arkansas Traveller* 176 3 67 106
Miss McLeod's Reel 153 14 51 88
Fisher's Hornpipe 149 7 43 99
Billy in the Lowground 144 16 42 85
Flop Eared Mule 142 20 31 91
Sally Ann 132 11 21 100
Mississippi Sawyer 127 2 29 96
* Does not include the skit versions of Arkansas Traveler


Jane Keefer, June 11, 2011      Home