Ferrante A M, Rosman D L, Knuiman M W
Department of Public Health, University of Western Australia, Nedlands, Perth.
Accid Anal Prev. 1993 Dec;25(6):659-65. doi: 10.1016/0001-4575(93)90031-q.
In order to effectively examine possible causes and determinants of road trauma, reliable information on the participants, circumstances, and resultant injuries and deaths must be available. Characteristics of participants (persons and vehicles) and the circumstances of road accidents are routinely collected by police and road authorities, whereas details of the injuries and medical care provided to casualties are collected by hospital and ambulance services. A road injury database, linking data collected by the Health, Police, and Main Roads Departments of the Government of Western Australia with records of the St. John Ambulance Association and the Death Register, has been established. This paper describes the procedures used to link the various sources of data and discusses the design, construction, and quality of the resultant relational database.
为了有效调查道路创伤的可能原因和决定因素,必须掌握有关参与者、事故情形以及由此导致的伤亡情况的可靠信息。警方和道路管理部门通常会收集参与者(人员和车辆)的特征以及道路事故的情形,而医院和救护车服务部门则会收集伤亡人员的受伤详情和所接受的医疗护理信息。西澳大利亚州政府的卫生、警察和主要道路部门所收集的数据,已与圣约翰救护车协会的记录及死亡登记册进行了关联,由此建立了一个道路伤害数据库。本文描述了将各种数据来源进行关联所采用的程序,并讨论了由此产生的关系型数据库的设计、构建和质量。