Data validation of logistics management information system air force with shadow database

Abstract

This research aimed to study data monitoring with shadow database, before input to Logistics Management Information System database (LMIS) of the Royal Thai Air Force.  The data for this monitoring obtained from the Operations Section, the Factory Division, the Civil Engineering Department of the Royal Thai Air Force which were the numeric and texts. These data had errors such as missing, district, duplicated etc. Researcher found that these errors owing to the end user key the data with the program which was not process to check the input data. Because the Operations Section, the Factory Division and the Civil Engineering Department were only the end users, so they could not edit the application or created the tool to verify database directly. Thus, researchers developed the new user interface to verify the input data or data validation with the Shadow Database. This user interface would solve these error problems by automatic filling the missed data and create the checklist to protect the end user key in data incorrectly. By testing it, the data amount of 21,117 records were keyed in with the Shadow database, after that researchers would take the new data to compare with the original data. The result of testing showed that the new data key in with the Shadow database were more correct than the original in good level. The null value of Brand, Voltage and User could solve 100 percent but the Voltage has more null value, because the data were moved to the correct field. The null value of Category and Status could solve 99.88 and 99.92 percent, respectively. For the case of the data miss match could solve 100 percent. The provision of quality information was performed before using in the next step.