Constructing Relational Databases to Study Life Histories on Your PC or Mac

Bibliographic Data

ID11253198
AuthorsJohann Peter Murmann (0000-0003-1631-3012, UNSW Sydney, corresponding author)
Year2010
Volume43
Issue3
Pages109-123
Publication date2010-07-29
Peer ReviewedYes
Open AccessNo
TypeARTICLE
VenueHistorical Methods A Journal of Quantitative and Interdisciplinary History (JOURNAL)
Journal identifiersISSN: 0161-5440 • E-ISSN: 1940-1906
PublisherInforma UK Limited (PUBLISHER • GB)
DOI10.1080/01615440.2010.496442
OpenAlexW3125206834
LanguageEN
Citations received3
References cited5

In this article, the author presents a strategy for designing relational databases with the program FileMaker Pro (FileMaker) to study the histories of individuals and organizations. The approach facilitates efficiency in inputting data and flexibility for constructing statistical analyses from the raw data. The key feature of the strategy is to define the basic unit of observation in the database in terms of an agent, an event, and a date. Given that programs such as FileMaker can easily sort data by agent and date, once one structures the data correctly, he or she can construct well-ordered event histories for agents, even if the researcher enters the data in an unordered fashion. By using events that happened to an agent at a particular time as the basic unit of observation, one maintains maximum flexibility to do statistical analysis that aggregates basic data in different ways. This article illustrates the power of the approach by outlining ways to analyze changes in geographic distances between two events marking the life histories of chemists

Computer security · Construct (python library · Data mining · Data science · Database · Event (particle physics · Flexibility (engineering · Key (lock · Programming language · Raw data · Relational database · sort · Complex Network Analysis Techniques · Computer Science

Tools

Open DOISci-Hub