A frame study for the automatic transformation of anesthesia chart into XML(Extensible Markup Language) and the architecture about general database

麻醉下生命信号信息数据库的建立，使各机构间麻醉调节的客观评价成为可能，有助于医学治疗的发展。我们制作了麻醉图表模块，将麻醉相关信息包括生命信号自动转换为XML格式。（可扩展标记语言）通过该模块，对建立通用型和XML型麻醉病历数据库进行了研究。在此基础上，建立了麻醉病历的XML模式DTD原型（schema），以便对数据库进行有效的管理。另一方面，日本麻醉学协会支持的JSA麻醉账簿系统，从2006年的一个版本开始，已经在PostgreSQL中得到了帮助。并对麻醉病例数据库进行了改进，使其工作在Web用户界面上。我们利用Microsoft Excel对SQL数据库的连接功能，制作了一个宏工作表函数，将JSA麻醉数据库的操作信息作为JSA2Excel录入Excel工作表中。实现了与JSA麻醉数据库系统的协作功能。

The database of vital signal information under anesthesia contributes to the development of medical therapy, because objective evaluation about the anesthetic regulation among the various institution is easily possible. We made the anesthesia chart module, which automatically transform the anesthesia-related information including vital signals into XML style. (Extensible Markup Language) We performed a study to build the general-purpose and XML type database for anesthesia-related record, through this module. Further, we made the prototype concerning the XML pattern DTD of anesthesia record (a schema) , in order to effectively manage the database.On the other hand, the JSA anesthesia account book system which Japanese anesthesiology society supports, has been helped in PostgreSQL, from a version in 2006. And it was improved to the anesthesia case database which work in user interface of Web.We made a macro work-sheet function to take in operation information of a JSA anesthesia database in an Excel work-sheet as JSA2Excel, by using connection function of Microsoft Excel to a SQL database. By this, we realized the cooperation function with a JSA anesthesia database system.