Maintaining database consistency and integrity in HIS with transactions
- Resource Type
- Conference
- Authors
- Xu, Zhong-wei
- Source
- 2009 IEEE International Symposium on IT in Medicine & Education IT in Medicine & Education, 2009. ITIME '09. IEEE International Symposium on. 1:1113-1116 Aug, 2009
- Subject
- Bioengineering
Communication, Networking and Broadcast Technologies
Computing and Processing
General Topics for Engineers
Transaction databases
Maintenance engineering
Data engineering
Hospitals
Information systems
Engines
Control systems
- Language
It is very important in HIS (Hospital Information System) to maintain the consistency and integrity of information. A transaction is a group of actions that must all be carried out successfully on one or more tables in a database before they are committed (made permanent). If any of the actions in the group fails, then all actions are rolled back (undone). In this paper, how to use transactions in Delphi in latent and apparent way is discussed in detail. Furthermore, a demonstration is given to show a method of using transactions in Delphi to guarantee the prescriptions being stored to the database or transmitted to another departments in intactness. This method could also be used to maintain database consistency and integrity when there is need for modifications to the data stored in the database.