›› 2012, Vol. 32 ›› Issue (12): 1558-.doi: 10.3969/j.issn.1674-8115.2012.12.008

• 专题报道(骨关节疾病) • 上一篇    下一篇

骨盆创伤全流程专业数据库的初步构建

王 谦1, 汪 方1 ,胡小锋2, 黄建华1, 曹 云1, 王秋根1   

  1. 1.上海交通大学附属第一人民医院骨科, 上海 200080; 2.上海交通大学机械与动力工程学院, 上海 200240
  • 出版日期:2012-12-28 发布日期:2012-12-31
  • 通讯作者: 王秋根, 电子信箱: wangqiugen@126.com。
  • 作者简介:王 谦(1979—), 男, 主治医师, 博士;电子信箱: drwangqian23@163.com。
  • 基金资助:

    上海市科委基金(11JC1410400);上海交通大学医工(理)交叉基金(YG2010MS10)

Preliminary construction of pelvic trauma professional whole flow database

WANG Qian1, WANG Fang1, HU Xiao-feng2, HUANG Jian-hua1, CAO Yun1, WANG Qiu-gen1   

  1. 1.Department of Orthopaedics, the First People's Hospital, Shanghai Jiaotong University, Shanghai 200080, China; 2.School of Mechanical Engineering, Shanghai Jiaotong University, Shanghai 200240, China
  • Online:2012-12-28 Published:2012-12-31
  • Supported by:

    Shanghai Science and Technology Committee Foundation, 11JC1410400;Shanghai Jiaotong University Foundation, YG2010MS10

摘要:

目的 构建骨盆创伤诊治的全流程专业数据库。方法 基于既往大量骨盆创伤数据,研究骨盆创伤救治流程及临床信息组成,分析辅助检查、诊疗环节元数据。以SQL server 2005 数据库为基础,现有医院信息系统(HIS)、检验信息管理系统(LIS)和影像归档和信息系统(PACS)等信息系统为依托,整理骨盆创伤全流程信息,开发骨盆创伤数据库。结果 将复杂的骨盆创伤救治流程进行结构化、流程化表达,整合大量历史数据,成功构建骨盆创伤专业数据库。检验结果、指标参数实现可视化表达,临床参数实现结构化分类管理。数据库将骨盆创伤患者就诊全流程分为基本信息、早期诊治及围手术期诊治、手术治疗、预后随访4个部分。结论 该骨盆创伤数据库的初步开发及应用有助于改善数据管理,便于数据挖掘,优化了临床诊治流程。

关键词: 骨盆创伤, 数据库, 医院信息系统

Abstract:

Objective To construct a professional whole flow database on diagnosis and treatment of pelvic trauma. Methods Based on pelvic trauma data, with investigation of treatment process and clinical information composition and analysis of data of accessory examinations and metadata of diagnosis and treatment, the pelvic trauma whole flow information was gathered. SQL server 2005 database, hospital information system (HIS), laboratory information system (LIS) and picture archiving and communication system (PACS) were utilized to establish the pelvic trauma professional whole flow database. Results The complex procedure of emergency rescue in pelvic trauma was described structurally. Massive amount of historical data were integrated, and professional pelvic trauma database was successfully established. The results of laboratory examinations and parameters achieved visual representation, and the clinical parameters achieved structured classification management. The data management module was composed of four parts: basic information, early treatment and perioperative management, surgical treatment, and prognosis and follow-up. Conclusion The preliminary development and application of pelvic trauma database may be helpful in data management, data mining, and optimization of clinical diagnosis and treatment.

Key words: pelvic trauma, database, hospital information system