Managing the Kanchanaburi Demographic Surveillance System: Creation of a Relational Database Management System.

Autor: Rittirong, Jongjit
Předmět:
Zdroj: Asia-Pacific Population Journal; Dec2008, Vol. 23 Issue 3, p107-119, 13p
Abstrakt: The Kanchanaburi Demographic Surveillance System (KDSS) monitors population change in Thailand's Kanchanaburi Province. KDSS was established with a cross-sectional scheme for data collection and manipulation. This original database needed to be transformed into a longitudinal scheme in order to achieve productive data utilization as the original KDSS data structure was a "flat file" in SPSS format and was difficult to manage and manipulate. Three main problems with the original database were identified. First, the linkage between the various data sets required excessive human resources. Second, some data were missing as a result of individuals moving from one study area to another during consecutive years. Last, but not least, a number of data retrievals were inconsistent because the data capture was employed separately on the survey of the previous year. The new system is operated using a relational database management system, which is compatible with the spatial data. The procedures of the transformation diminish data redundancy, unreliability and inconsistency. Hence, the human resources needed for data retrieval are reduced, data quality is improved and data confidentiality is strengthened. [ABSTRACT FROM AUTHOR]
Databáze: Complementary Index