title: A substitution method to improve completeness of events documentation in anesthesia records.
abstract: AIMS are optimized to find and display data and curves about one specific intervention but is not retrospective analysis on a huge volume of interventions. Such a system present two main limitation; (1) the transactional database architecture, (2) the completeness of documentation. In order to solve the architectural problem, data warehouses were developed to propose architecture suitable for analysis. However, completeness of documentation stays unsolved. In this paper, we describe a method which allows determining of substitution rules in order to detect missing anesthesia events in an anesthesia record. Our method is based on the principle that missing event could be detected using a substitution one defined as the nearest documented event. As an example, we focused on the automatic detection of the start and the end of anesthesia procedure when these events were not documented by the clinicians. We applied our method on a set of records in order to evaluate; (1) the event detection accuracy, (2) the improvement of valid records. For the year 2010-2012, we obtained event detection with a precision of 0.00 (-2.22; 2.00) min for the start of anesthesia and 0.10 (0.00; 0.35) min for the end of anesthesia. On the other hand, we increased by 21.1% the data completeness (from 80.3 to 97.2% of the total database) for the start and the end of anesthesia events. This method seems to be efficient to replace missing "start and end of anesthesia" events. This method could also be used to replace other missing time events in this particular data warehouse as well as in other kind of data warehouses.
authors: INSERM CIC-IT, University Hospital, 59000, Lille, France. antoine.lamer@chru-lille.fr.|Pôle d'Anesthésie Réanimation, University Hospital, 59000, Lille, France. antoine.lamer@chru-lille.fr.|UDSL EA 2694, Univ Lille Nord de France, 59000, Lille, France. antoine.lamer@chru-lille.fr.
authors: Antoine
authors: A
authors: Lamer
authors: INSERM CIC-IT, University Hospital, 59000, Lille, France.
authors: Julien
authors: J
authors: De Jonckheere
authors: INSERM CIC-IT, University Hospital, 59000, Lille, France.|UDSL EA 2694, Univ Lille Nord de France, 59000, Lille, France.
authors: Romaric
authors: R
authors: Marcilly
authors: Pôle d'Anesthésie Réanimation, University Hospital, 59000, Lille, France.
authors: Benoît
authors: B
authors: Tavernier
authors: Pôle d'Anesthésie Réanimation, University Hospital, 59000, Lille, France.|UDSL EA 2694, Univ Lille Nord de France, 59000, Lille, France.
authors: Benoît
authors: B
authors: Vallet
authors: INSERM CIC-IT, University Hospital, 59000, Lille, France.|Pôle d'Anesthésie Réanimation, University Hospital, 59000, Lille, France.
authors: Mathieu
authors: M
authors: Jeanne
authors: INSERM CIC-IT, University Hospital, 59000, Lille, France.|UDSL EA 2694, Univ Lille Nord de France, 59000, Lille, France.
authors: Régis
authors: R
authors: Logier
mesh_terms: D000758:Anesthesia / Q000706:statistics & numerical data; D003628:Database Management Systems / Q000706:statistics & numerical data; D004282:Documentation / Q000379:methods* / Q000706:statistics & numerical data; D006751:Hospital Information Systems / Q000706:statistics & numerical data; D006801:Humans; D016347:Medical Records Systems, Computerized / Q000706:statistics & numerical data; D013997:Time Factors
keywords: AIMS; Data completeness; Data warehouse; Substitution rule
references: Can J Anaesth. 1999 Feb;46(2):122-8
references: 10083991
references: Acta Anaesthesiol Scand. 2009 Sep;53(8):995-1005
references: 19572938
references: J Am Med Inform Assoc. 2003 Sep-Oct;10(5):454-62
references: 12807807
references: J Clin Monit Comput. 2015 Feb;29(1):163-7
references: 24838488
references: Anesthesiology. 1996 Nov;85(5):977-87
references: 8916813
references: Int J Med Inform. 2013 Aug;82(8):702-7
references: 23731825
references: Int J Med Inform. 2006 Mar-Apr;75(3-4):268-81
references: 16169771
references: Anesthesiology. 2007 Jan;106(1):157-63
references: 17197858
references: Anesth Analg. 2008 Jan;106(1):192-201, table of contents
references: 18165578
references: Comput Methods Programs Biomed. 2012 Jan;105(1):22-30
references: 20728956
references: Anesth Analg. 2013 Dec;117(6):1329-37
references: 24257383
references: Ochsner J. 2011 Summer;11(2):102-14
references: 21734847
references: J Am Med Inform Assoc. 2013 Jan 1;20(1):144-51
references: 22733976
references: J Biomed Inform. 2013 Oct;46(5):830-6
references: 23820016
references: Anesthesiology. 2013 Sep;119(3):507-15
references: 23835589
references: IEEE Trans Inf Technol Biomed. 2011 Nov;15(6):823-30
references: 21859604
references: Stud Health Technol Inform. 2007;129(Pt 2):890-4
references: 17911844