Experience Report: Verifying Data Interaction Coverage to Improve Testing of Data-Intensive Systems: The Norwegian Customs and Excise Case Study

摘要: Testing data-intensive systems is paramount to increase our reliance on information processed in e-governance, scientific/ medical research, and social networks. A common practice the industrial testing process use test databases copied from live production streams functionality of complex database applications that manage well-formedness data its adherence business rules these systems. This often based assumption adequately covers realistic scenarios test, hopefully, all applications. There a need systematically evaluate this assumption. We present tool-supported method model verify whether actually cover them consequently facilitate adequate testing. conceptualize as interactions between fields cross-cutting schema cases classification tree model. human-in the-loop tool, DEPICT, uses input (a) interactive selection connected sub graph many possible paths tables specified (b) automatically generate SQL queries create an inner join (c) extract records visual report satisfied unsatisfied hence quantifying adequacy database. experience qualitative evaluation approach with large Norwegian Customs Excise system TVINN featuring millions records.