主动数据库技术医院收费系统设计和开发.docVIP

基于主动数据库技术的医院收费系统的设计与开发摘 要 基于主动数据库技术的医院收费系统，能够自动判断内部或外部的数据状态变化，当变化符合主动触发条件时，立即响应操作命令，自动保护和检测收费数据，实现数据完整性、一致性的自动维护以及满足实时信息处理的需要，这是医院收费系统的发展趋势。 本课题主要包括门诊挂号、门诊划价收费和住院收费三个部分。通过需求分析，确定整个系统的设计原则、设计思想，在此基础上结合各部分的功能特点和实际要求，详细设计了收费管理系统的开发方案，主要包括：门诊挂号收费管理子系统和住院收费管理子系统的设计方案，并对系统安全和数据库进行相应的设计，在数据管理层利用 SQL Server 2000 中的触发器来实现主动地对实时数据正确性的检验和数据分析。进行了功能测试，及时发现本系统中存在的问题并解决问题，保证软件的质量和可靠性。 在本文中主要论述了主动数据库的理论知识以及基于主动数据库技术的医院收费系统的开发过程。 关键词：主动数据库技术，医院收费系统，触发器，测试 ABSTRACT The hospital charge management system based on active database technology can inspect the change of inner or outer data,if the change matches trigger condition,it will respond the opertion command immediately,porotect and inspect charge data,realize automatic maintenance of integrality and consistency and satisfy requirement of real time information management.It’s the development direction of hospital charge management system. This system includes the outpatient registration, outpatient charge and inpatient charge. Based on the requirement analyse, the system design principle and design idea is determined. Combined functional characteristic of every part and practice requirement, the development program of hospital charge management is designed detailedly,including patient registration, patient charge and hospital charge development program, and database and system security are also designed. In the data-manage layer, the trigger of SQL Server 2000 is used to actively analyze the data and check the validity of data.In order to guarantee quality and dependability of software,fuction test is processed and problems is found and desolved in time. In this paper, active database theory and the development of the hospital charge management system based on active database technology is discussed. Keywords：Active Database Technology, Hospital Charge System, Trigger, Test 目 录 引 言 伴随着信息化时代的来临，信息管理系统在各行各业得到了越来越广泛的应用。医院信息系统(Hospital Information System，简称HIS)就是在这样一种情况下发展起来的。通过应用医院信息系统，实现医院管理的现代化，提高工作效率，更好地为病人服务。同时，结合医疗和管理过程的实际