Baumann R P
Institut neuchâtelois d'anatomie pathologique, Neuchâtel.
Rev Med Suisse Romande. 1999 Oct;119(10):805-24.
The paper is describing the design and the performance of the computerized system, from its introduction in 1982 until the present day. The first device, using the MUMPS language on a mini-computer, followed by a VAX computer with terminals have been replaced in 1996 by an application program, using ORACLE, based on the client-server concept. The content and the particularities of the different data groups are discussed, concerning the functional components of the data bank: 'PATIENTS', 'SPECIMEN', 'SENDERS', 'REPORT' and 'DIAGNOSES'. By means of examples, we demonstrate the chronological evolution of the registration of persons, the distribution of the diagnoses according to the organ systems, the possibilities to combine various lesions and an algorithm to assure that a given lesion is registered only once per patient. In first place, the efficiency and the reliability of manual coding by a pathologist using the Systematized Nomenclature of Medicine (SNOMED; 2nd edition [1979/1982]) is discussed. The data bank currently contains 530,000 diagnoses, distributed among on SNOMED's five main modules, obtained from 1500 autopsies, 140,000 surgical and 180,000 cytological specimens. Concluding the article, an analysis is made of desirable developments in the future with the aim of a better integration of the acquired information in routine work and an enhanced use of the medical content for epidemiological research or statistical analysis.
本文描述了该计算机系统从1982年引入至今的设计与性能。最初的设备是在小型计算机上使用MUMPS语言,随后是配备终端的VAX计算机,1996年它们被基于客户端-服务器概念、使用ORACLE的应用程序所取代。文中讨论了不同数据组的内容和特点,涉及数据库的功能组件:“患者”“样本”“发送者”“报告”和“诊断”。通过实例,我们展示了人员登记的时间演变、根据器官系统进行的诊断分布、组合各种病变的可能性以及确保每个患者给定病变仅登记一次的算法。首先,讨论了病理学家使用医学系统化命名法(SNOMED;第2版[1979/1982])进行手动编码的效率和可靠性。该数据库目前包含530,000条诊断信息,分布在SNOMED的五个主要模块中,这些信息来自1500例尸检、140,000例手术和180,000例细胞学样本。文章结尾对未来理想的发展进行了分析,目的是在日常工作中更好地整合所获取的信息,并在流行病学研究或统计分析中更多地利用医学内容。