+ Resolve Article
+ Follow Us
Follow on FacebookFollow on Facebook
Follow on TwitterFollow on Twitter

+ Translate
+ Subscribe to Site Feed
GeoScience Most Shared ContentMost Shared Content

Statistics and evaluation of a graphic SQL user interface in an anesthesia information management system (AIMS)

, : Statistics and evaluation of a graphic SQL user interface in an anesthesia information management system (AIMS). Anasthesiologie, Intensivmedizin, Notfallmedizin, Schmerztherapie 34(1): 24-32

Since 1997, the Anaesthesia Information Management Systems (AIMS) in our department has produced extensive data material (DGAI core data, vital sign parameters, respiratory parameters, material consumed, etc.) which is stored in a relational data bank. The processing of this data by means of SQL queries was restricted to a few persons with special knowledge only. It was the objective of the project to create an evaluation tool which enables each member of the department to enter queries concerning topics such as efficiency records, quality management, training and research at any time. The tool was also intended to present results in an adequate form. Since 1997, the data of the performed anaesthesia procedures have been recorded using the online anaesthesia documentation software NarkoData Version 4 (ProLogic GmbH, Erkrath) within the AIMS. The recorded data sets have been imported into a relational Oracle data bank (Oracle Corporation). The commercial programme Voyant (Brossco Systems, Espoo, Finland) enables for the user to formulate SQL-requests (Structured Query Language) with the help of a graphic user interface and to present the results in a variety of graphics and tables. Repetition of the evaluation using the current data is possible at any time. During 1997 and the first quarter of 1998, the data of 26,030 anaesthesia procedures have been registered and stored in the anaesthesiological data base. 235 queries could be formulated with the SQL-capable graphic tool Voyant. They are available to each member of the department by the application of NarkoStatistik (IMS GmbH, Giessen) within the AIMS, together with the corresponding documentation (HTML pages). The query catalogue covers the main topics of efficiency, quality management, organisation, diagnoses and surgery, pre-, intra- and postoperative data and day-care unit. Even without much previous experience with the system it is possible to carry out evaluations with the current data at selected AIMS terminals. Queries concerning other subjects can be created and can be integrated into the existing query catalogue. With the described application we are able to establish an evaluation tool which fulfils our expectations regarding user friendliness and the subjects the queries can cover. Today it has a central position within the AIMS. In addition to the anaesthesia documentation software and the data bank structure, the efficiency of an AIMS is mainly influenced by the corresponding evaluation tool.


PMID: 10073252

DOI: 10.1055/s-1999-167

Other references

Sampson, A.P.; Pizzichini, E.; Bisgaard, H., 2003: Effects of cysteinyl leukotrienes and leukotriene receptor antagonists on markers of inflammation. The understanding that asthma pathophysiology includes an inflammatory component has spurred the more aggressive use of anti-inflammatory therapies and created a need for effective tools to measure inflammation. Biomarkers of airway inflammation p...

D.F.anceschi, L.; Shalev, O.; Piga, A.; Collell, M.; Olivieri, O.; Corrocher, R.; Hebbel, R.P.; Olivieri, N.; Brugnara, C., 1996: Deferiprone treatment removes erythrocyte membrane free iron and affects K-Cl cotransport activity in homozygous beta thalassemia. Blood 88(10 SUPPL 1 PART 1-2): 24B

Chu, G.; Rosenfield, A.T.; Anderson, K.; Scout, L.; Smith, R.C., 1999: Sensitivity and value of digital CT scout radiography for detecting ureteral stones in patients with ureterolithiasis diagnosed on unenhanced CT. When unenhanced CT reveals ureterolithiasis, some patients will require baseline or follow-up conventional radiography to help guide clinical management. We sought to determine the sensitivity of routinely obtained scout radiographs for revealing...

Pennington, Jean A.T., 2000: Total diet studies: Experiences in the United States. Total Diet Studies in the United States (U.S.) are conducted yearly by the U.S. Food and Drug Administration (FDA) to monitor the safety and quality of the U.S. food supply and to monitor the dietary intakes of population subgroups with respect to...

Dougherty, T.M., 1956: Epilepsy; the history of folklore in its treatment. Journal of the Kansas Medical Society 57(5): 304-318

Ryzhkov Y.F.; Belov V.V., 1973: Cement raw materials. Limestone, marlstone, dolomite, opoka, and tripoli deposits in the Urals.

Sporle, A.; Pearce, N., 1999: Impact of changes in the death registration process upon Maori mortality statistics. New Zealand Medical Journal 112(1098): 411-412

Pietrzyk, E.; Michta, K.; Gorczyca-Michta, I.; Wożakowska-Kapłon, B., 2013: Dissecting aortic aneurysm in a 23 year-old hypertensive woman. Kardiologia Polska 71(6): 663-663

Lastorino, K.M., 2007: Heed the OIG's usual suspects. Beware of joint ventures with physicians in which you offer broad management, administrative, or operations services to the venture, and the physicians assume little or no financial risk and provide little more than referrals to the venture. Bewar...

Bakos N.; Meszaros C.; Debreczeni M., 1990: Examination of chronic urticaria. 66 patients with chronic urticaria were examined using a three-stage examination protocol. Stage I. consisted of case history, general dermatological and internal physical examination and routine laboratory tests. Stage II. comprised investigation...