Volume 15 - Article 7 | Pages 181–252
A general temporal data model and the structured population event history register
|Date received:||04 Jun 2004|
|Date published:||13 Oct 2006|
|Keywords:||data model, database, DSS, longitudinal analysis, metadata, methods, population register, SPEHR, surveillance|
|Additional files:||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)|
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.
Samuel J. Clark - Ohio State University, United States of America
Other articles by the same author/authors in Demographic Research
Most recent similar articles in Demographic Research