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

Samuel J. Clark

doi:10.4054/DemRes.2006.15.7

Volume 15 - Article 7 | Pages 181–252

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

By Samuel J. Clark

Date received:

4 Jun 2004

Date published:

13 Oct 2006

Word count:

9500

Keywords:

data model, database, DSS, longitudinal analysis, metadata, methods, population register, SPEHR, surveillance

DOI:

10.4054/DemRes.2006.15.7

Supplementary Material:

SPEHR-Joburg-Durban-2.0 (mdb file, 1 MB)
SPEHR-London-NewYork-2.0 (mdb file, 1 MB)
SPEHR-Merged-2.0 (mdb file, 1 MB)
SPEHR-Repeated-Demographic-Survey-OR-Population-Register-2.0 (mdb file, 1 MB)

Download PDF
Submit a Response Letter

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.