loading...
 This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
Testing: Academic & Industrial Conference - Practice And Research Techniques (TAIC PART'06)
Testing a Datawarehouse - An Industrial Challenge
Windsor, United Kingdom
August 29-August 31
ISBN: 0-7695-2672-1
Harry M. Sneed, ANECON GmbH, Germany
This contribution is an experience report on system testing and in particular on the testing of a datawarehouse system. Datawarehouses are large databases used solely for querying and reporting purposes. The datawarehouse in question here was dedicated to fulfilling the reporting requirements of the BASEL-II agreement on the provision of auditing data by the banks, the European equivalent of the Sarbane-Oxley Act. The purpose of the testing project was to prove that the contents of the datawarehouse are correct in accordance with the rules specified to fill them. In the end, the only way to achieve this was to rewrite the rule specifications in a machine readable form and to transform them into post assertions, which could be interpreted by a data verification tool for comparison of the actual data contents with the expected data contents. The testing project was never fully completed, since not all of the rules could be properly transformed. Keywords: System Testing, Datawarehouse Testing, Data Transformation Rules, Post Conditions Assertions, Formal Verification.
Citation:
Harry M. Sneed, "Testing a Datawarehouse - An Industrial Challenge," taic-part, pp.203-210, Testing: Academic & Industrial Conference - Practice And Research Techniques (TAIC PART'06), 2006
Usage of this product signifies your acceptance of the Terms of Use.