© 1999 - 2012
Max-Planck-Gesellschaft

A general temporal data model and the structured population event history register

References
View the references of this article
Services
Bookmark this page
Send this article to a friend
Download to Citation Manager
file RIS format
file BibTeX format
Citations and Similar Articles
PubMed
Articles by Samuel J. Clark
Google Scholar
Articles by Samuel J. Clark
Article and its Citations
 

Samuel J. Clark

 
VOLUME 15 - ARTICLE 7
PAGES 181 - 252
Date Received: 4 Jun 2004
Date Published: 13 Oct 2006

http://www.demographic-research.org/volumes/vol15/7/

doi:10.4054/DemRes.2006.15.7
   
PDF file Click the icon to view and/or download the PDF file.
Once you are in the PDF file, use your browser back button to return to this page.

Additional files
The following additional files belong to this article. Click the icon to view the files. To save them click the icon with the right mouse button and choose "Save target as..." or "Save link as..."
file SPEHR-Joburg-Durban-2
file SPEHR-London-NewYork-2
file SPEHR-Merged-2
file SPEHR-Repeated-Demographic-Survey-OR-Population-Register-2

Abstract

At this time there are 37 demographic surveillance system sites active in sub-Saharan Africa, Asia and Central America, and this number is growing continuously. These sites and other longitudinal population and health research projects generate large quantities of complex temporal data in order to describe, explain and investigate the event histories of individuals and the populations they constitute.
This article presents possible solutions to some of the key data management challenges associated with those data. The fundamental components of a temporal system are identified and both they and their relationships to each other are given simple, standardized definitions. Further, a metadata framework is proposed to endow this abstract generalization with specific meaning and to bind the definitions of the data to the data themselves.
The result is a temporal data model that is generalized, conceptually tractable, and inherently contains a full description of the primary data it organizes. Individual databases utilizing this temporal data model can be customized to suit the needs of their operators without modifying the underlying design of the database or sacrificing the potential to transparently share compatible subsets of their data with other similar databases. A practical working relational database design based on this general temporal data model is presented and demonstrated.
This work has arisen out of experience with demographic surveillance in the developing world, and although the challenges and their solutions are more general, the discussion is organized around applications in demographic surveillance. An appendix contains detailed examples and working prototype databases that implement the examples discussed in the text.

Author's affiliation
Samuel J. Clark
University of Washington, United States of America

Keywords
data, data model, database, DSS, event, influence, longitudinal, metadata, methods, population register, relational, SPEHR, state, surveillance, temporal

Word count (Main text)
9500

Other articles by the same author/authors (in Demographic Research)
file[25-2] More on the Cohort-Component Model of Population Projection in the Context of HIV/AIDS: A Leslie Matrix Representation and New Estimates
file[12-6] Toward a Unified Timestamp with explicit precision

Similar articles in Demographic Research
file [24-12] A summary period measure of immigrant advancement in the U.S. (methods)
file [22-29] Menīs and womenīs economic activity and first marriage: Jews in Israel, 1987-1995 (longitudinal)
file [19-43] Human Biodemography: Some challenges and possibilities (longitudinal)
file [17-13] The implications of long term community involvement for the production and circulation of population knowledge (longitudinal)
file [16-8] Evaluation of a village-informant driven demographic surveillance system in Karonga, Northern Malawi (methods)

[ Back to previous page ]