湖南省区域性骨盆创伤数据库的研制

Establishement for regional pelvic trauma database in Hunan Province

目的:建立湖南省骨盆创伤数据库,开展多中心前瞻性的骨盆创伤登记工作。方法:阅读骨盆创伤相关文献,参考国内外大型综合性数据库的结构特点和研发经验,结合湖南省骨盆创伤救治实际情况,制定科学合理的数据库字段内容。以数据库管理系统Postgre SQL为平台,以高级程序设计语言Java 1.6开发数据库应用程序,建立骨盆创伤数据库。结果:将骨盆创伤救治复杂的过程进行了结构化、流程化表达,包括患者一般情况、受伤情况、院前急救、入院情况、院内救治、出院情况、诊断与分型、并发症、创伤评分及疗效评价等。本数据库以浏览器/服务器基于互联网的形式登录,具备病例管理、数据导出、历史痕迹查询、进度报告、影像管理、个人资料管理等功能。结论:首次在国内建立了包含院前急救的骨盆创伤全生命周期数据库。通过将数据录入数据库分析,证明数据库运行良好,具有内容详实科学、功能实用、界面友好、结构清晰、操作简单等特点。

Objective： To establish a database for pelvic trauma in Hunan Province, and to start the work of multicenter pelvic trauma registry. Methods： To establish the database, literatures relevant to pelvic trauma were screened, the experiences from the established trauma database in China and abroad were learned, and the actual situations for pelvic trauma rescue in Hunan Province were considered. The database for pelvic trauma was established based on the PostgreSQL and the advanced programming language Java 1.6. Results： The complex procedure for pelvic trauma rescue was described structurally.The contents for the database included general patient information, injurious condition, prehospital rescue,conditions in admission, treatment in hospital, status on discharge, diagnosis, classification, complication, trauma scoring and therapeutic effect. The database can be accessed through the internet by browser/servicer. The functions for the database include patient information management, data export, history query, progress report, video-image management and personal information management. Conclusion： The database with whole life cycle pelvic trauma is successfully established for the first time in China. It is scientific, functional, practical, and user-friendly.