Premium
How to maintain blood supply during computer network breakdown: a manual backup system
Author(s) -
Zeiler T.,
Slonka J.,
Bürgi H. R.,
Kretschmer V.
Publication year - 2000
Publication title -
transfusion medicine
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.471
H-Index - 59
eISSN - 1365-3148
pISSN - 0958-7578
DOI - 10.1046/j.1365-3148.2000.00265.x
Subject(s) - backup , computer science , workstation , database , log shipping , database server , sql , data transformation services , sql server , operating system , relational database , stored procedure , local area network , computer network , internet authentication service , server , world wide web , search engine , query by example , web search query
. Electronic data management systems using computer network systems and client/server architecture are increasingly used in laboratories and transfusion services. Severe problems arise if there is no network access to the database server and critical functions are not available. We describe a manual backup system (MBS) developed to maintain the delivery of blood products to patients in a hospital transfusion service in case of a computer network breakdown. All data are kept on a central SQL database connected to peripheral workstations in a local area network (LAN). Request entry from wards is performed via machine‐readable request forms containing self‐adhesive specimen labels with barcodes for test tubes. Data entry occurs on‐line by bidirectional automated systems or off‐line manually. One of the workstations in the laboratory contains a second SQL database which is frequently and incrementally updated. This workstation is run as a stand‐alone, read‐only database if the central SQL database is not available. In case of a network breakdown, the time‐graded MBS is launched. Patient data, requesting ward and ordered tests/requests, are photocopied through a template from the request forms on special MBS worksheets serving as laboratory journal for manual processing and result report (a copy is left in the laboratory). As soon as the network is running again the data from the off‐line period are entered into the primary SQL server. The MBS was successfully used at several occasions. The documentation of a 90‐min breakdown period is presented in detail. Additional work resulted from the copy work and the belated manual data entry after restoration of the system. There was no delay in issue of blood products or result reporting. The backup system described has been proven to be simple, quick and safe to maintain urgent blood supply and distribution of laboratory results in case of unexpected network breakdown.