Insights into Designing and Building a Historical Population Database
Volume: XII Issue: 2, Pages: 77-98
Babeş-Bolyai University, Centre for Population Studies
Doctoral School Population Studies and History of Minorities
Avram Iancu st, 68, 400083, Cluj-Napoca, Romania
The study presents some of the issues involved in designing and building a historical database, namely the Historical Population Database of Transylvania (HPDT). Devising the architecture of a source-oriented database is always a challenging task. Working with historical, complex sources with heterogeneous information, written in different languages, meant a continuous adaptation of the database that had several development versions, being presently at the starting point of its fourth version. HPDT was developed to have a research component with multiple databases (a source database, a standard one, and a linked table of individuals), as well as a public component.
Keywords: Transylvania, historical population database, HPDT, standardization, Record Linkage
Crăciun, B., Holom E.C., and Popovici V. (2015). “Historical Population Database of Transylvania: Methodology Employed in the Selection of Settlements and Micro Zones of Interest”. Romanian Journal of Population Studies 9(2): 17-29.
Goeken, R., Huynh, L., Lynch, T.A., and Wick, R. (2011) “New Methods of Census Record Linking“. Historical Methods. A Journal of Quantitative and Interdisciplinary History 44 (1): 7-14.
Harrington, J.L. (2009). Relational Database Design and Implementation: clearly explained. 3rd Ed.. Burlington, MA: Morgan Kaufmann Publishers-Elsevier.
Hin, S., Conde, D.A. and Lenart, A. (2016). “New Light on the Roman Census Papyri through Semi-Automated Record Linkage”. Historical Methods. A Journal of Quantitative and Interdisciplinary History 49(1): 50-65.
Historical Sample of the Netherlands (HSN). (2015). Annual Report. Amsterdam: International Institute for Social History.
Holom, E.C., Sorescu-Iudean, O., and Hărăguş, M. (2018). “Beyond the Visible Pattern: Historical Particularities, Development, and Age at First Marriage in Transylvania, 1850-1914”. The History of the Family. An International Quarterly 23(2): 329-358.
Mandemakers, K., and Dillon, L. (2004). “Best practices with large databases on historical populations”. Historical Methods. A Journal of Quantitative and Interdisciplinary History 37(1): 34-38.
Murmann, J.P. (2010). “Constructing Relational Databases to Study Life Histories on Your PC or Mac”. Historical Methods. A Journal of Quantitative and Interdisciplinary History 43(3): 109-23.
Thorvaldsen, G., Andersen, T., and Sommerseth, H.L. (2015). “Record Linkage in the Historical Population Register for Norway”. In G. Bloothooft, P. Christen, K. Mandemakers and M. Schraagen (Eds.), Population reconstruction. Switzerland: Springer, pp. 155-171.
Vick, R. and Huynh, L. (2011). “The Effects of Standardizing Names for Record Linkage: Evidence from the United States and Norway”. Historical Methods. A Journal of Quantitative and Interdisciplinary History 44(1): 15-24.
Winchester, I. (1992). “What Every Historian Needs to Know about Record Linkage for the Microcomputer Era”. Historical Methods. A Journal of Quantitative and Interdisciplinary History 25(4): 149-165.
Wisselgren, M., Edvinsson, S., Berggren, M., and Larsson, M. (2014). “Testing Methods of Record Linkage on Swedish Censuses”. Historical Methods. A Journal of Quantitative and Interdisciplinary History 47(3): 138-151.