Peacock Data explains the anatomy of a database, part 1

January 28, 2014 - According to Peacock Data, plans for two just released product upgrades were initially written up in January 2009 and development began in earnest mid-summer of that same year. The products were built during the same development cycle because both are extracted from the same master file.

One of the new products is pdNickname 2.0, an advanced name and nickname file used by businesses and organizations to merge database records. They can match the data against their lists to determine if two or more records are the same individual. It identifies first names that are the same even when they are not an exact match, but rather equivalent, such as a variation or nickname.

The other new package is pdGender 2.0, a gender coding database built on the same set of names. Users can match the data against the first names on their lists to establish male and female identification.

Both upgrades embrace a host of similar and compatible features including languages of origin and use for each name as well as fuzzy logic so information can be recognized even when lists have typographical errors or uncommon spellings.

According to the company's chief development coordinator Barbara Adair, "Creation of the master name file these new products result from is the biggest venture our company has ever undertaken. There are thousands of sources for names in scores of languages, and our task was to compare and contrast all this data and create the ultimate first name resource."

Information drawn from the sources includes variant spellings, relationships with other names, and the languages and gender associated with each name.

Barbara pointed out, "The language features have never been available before on this scale and required a sizable portion of the nearly five years of research and development."

"From the start it was essential to identify the languages associated which each name in considerable detail," she added. "This gives users previously unavailable ethnic demographics linked to the names already on their lists."

Barbara showed some of the documents used in construction of the new offerings including a manuscript from 731 AD, written by a monk named Bebe, listing the earliest English names dating from the Anglo-Saxon era of the Early Middle Ages. The still common personal name "Hilda" is an example from the manuscript.

"Because sources often give diverse information and use different spelling conventions, it was crucial not only to gather all the information possible but also to differentiate between the quality of sources," Barbra explained. "Better information became easier to identify after working with the sources over the course of the first year."

About half the database records are English and Spanish names, and international names originating and used in over 200 other languages make up the second half. This includes such languages as French, German, Chinese, Japanese, Vietnamese, Korean, Hindustani, Arabic, Persian, and Yiddish as well as Native American names and ancient Greek, Latin, and Hebrew names.

According to Barbara, "Special attention is paid to rare usages of unisex names like Kimberly, Hillary, Valentine, and even Maria. Names like these, while usually associated with one gender, are also occasionally employed by both genders. The new products identify rare usages so they can be considered separately. pdGender in particular employs this technology out-of-the-box allowing users to ignore rare unisex usages when assigning gender."

"Beyond just identifying the languages of use, we also classify name origins, such as Old English opposed to Middle English opposed to modern English," Barbara noted. "This adds value for those researching personal names or the relationships between languages, such as in the fields of anthroponymy, onomatology, ethnology, and linguistics."

According to the product documentation, both packages identify five basic first name types:

Base Names

Variations

Short Form Nicknames

Diminutives

Opposite Gender Forms

"Assigning a type identification to each name was a lengthy part of development, but it is significant because the added information permits more precise filtering and ultimately better results," Barbara said. "Base names are characteristically the oldest because they are the original names all later formations can be traced back to. A lot of time was devoted to these. It is important they are identified as accurately as possible because the remainder of the database is dependent on them."

Most of the main product development was completed by the end of 2012 and field testing of beta editions commenced in January 2013.

Stay tuned for "Peacock Data explains the anatomy of a database, part 2" coming Wednesday.

Product information

pdNickname 2.0: Name and Nickname Database More information…
pdGender 2.0: Name and Gender Coding Database More information…

About Peacock Data

Peacock Data are the makers of database products used by business, organizations, churches, schools, researchers, and government.

Their flagship offerings include: pdNickname, a highly-regarded name and nickname product recently upgraded to version 2.0; pdGender, a gender coding database also recently upgraded to version 2.0; pdGeoTIGER, a precision ZIP+4 and address range GeoCoding package; pdCensus2010, with demographic data drawn from 2010 American census tabulations; and pdACS2013, unveiled last May, another demographics offering providing American Community Survey (ACS) estimates gathered from the U.S. Census Bureau and summarized at over 100 stratification levels.

Peacock Data is a California-based company in business since 2003.

2014 Calendar

PRODUCT RELEASE SCHEDULE:

April: pdGeoTIGER 2.0, pdCensus2010 1.0.
May: pdLatino 1.0, pdACS2014 1.0.
June: pdZIP 2.0, pdZIP+4 1.0.
July: pdCensus2000 2.0.
August: pdSurname 1.0.
September: pdProperCase 1.0.
October: pdCountry 2.0.
November: pdGeoTIGER 2.1, pdCensus2010 1.1.
December: pdEconomics2015 1.0.