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(一种模式)的原型。另一方面，日本麻醉学会支持的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.