摘要
随着HIS的长期运行 ,数据库中存储的数据增多。同时 ,统计、分析需求增加 ,导致数据库的吞吐量降低。本文提出建立在用数据库和历史数据库的方法 ,该方法将联机事务处理在用的数据存储在在用数据中 ,联机事务处理不再用的数据存储在历史数据库中。文章对在用数据库中历史数据的标识、删除 ,在用数据库和历史数据库之间的数据归档和回迁等进行了论述。
With the long run of HIS,many data stored in the database and many statistic analysis requirements are in-creased.So the database throughput is reduced.In this paper,a method to establish using database and history database is presented.By using this method,the data with on-line transactions is stored in using database and the data without on-line transactions is stored in hostory database.Then this paper states how mark history data,how delete history data,how archives and remove the history data between using database and history database.
出处
《医疗设备信息》
2004年第7期13-15,共3页
Information of Medical Equipment
关键词
数据库
归档
回迁
历史数据
database
archive
remove
history data
