{"id":181,"date":"2013-12-31T15:06:14","date_gmt":"2013-12-31T14:06:14","guid":{"rendered":"http:\/\/wp1149244.wp072.webpack.hosteurope.de\/?page_id=181"},"modified":"2013-12-31T15:06:14","modified_gmt":"2013-12-31T14:06:14","slug":"article-the-test-data-challenge-for-database-driven-applications-testing-experience","status":"publish","type":"page","link":"https:\/\/www.klaushaller.net\/?page_id=181","title":{"rendered":"Article: The Test Data Challenge for Database-Driven Applications (testing experience)"},"content":{"rendered":"<p>Author: Klaus Haller<br \/>\nPublished in: testing experience, June 2010<\/p>\n<p>It was the summer of 2008. Testing suddenly emerged as the Topic in my professional life. I became responsible for the database back-end of a credit rating application. Banks use such applications for estimating whether companies pay back their loans. This impacts whether they get a loan and for which interest rate. So I was interested in how to test \u201cmy\u201d application. But the application was different to the ones you read about in testing literature. The application was built on a database (a database-driven application, or, short, a DBAP). The DBAP output of an action not only depends on your input, but also on the history of the DBAP\u2019s usage. The history manifests in rows and data stored in the tables. And this history influenced the present and future behavior of <em>my<\/em> application. What sounds like a philosophical question<br \/>\nis of high practical relevance. Four questions sum up what I had to answer myself: What do I need DBAP test data for? When is a DBAP <em>correct<\/em>? What is a DBAP test case? And, finally, which test data is <em>good<\/em>?<\/p>\n<p><strong>Read the full paper:<\/strong><br \/>\n<\/strong> <a title=\"The Test Data Challenge for Database-Driven Applications\" href=\"http:\/\/www.klaushaller.net\/media\/testingexperience02_10_Haller.pdf\">Klaus Haller: The Test Data Challenge for Database-Driven Applications (Testing Experience magazine)<\/a><\/p>\n<p><script>\n  (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){\n  (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),\n  m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)\n  })(window,document,'script','\/\/www.google-analytics.com\/analytics.js','ga');<\/p>\n<p>  ga('create', 'UA-35041728-1', 'klaushaller.net');\n  ga('send', 'pageview');<\/p>\n<p><\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Author: Klaus Haller Published in: testing experience, June 2010 It was the summer of 2008. Testing suddenly emerged as the Topic in my professional life. I became responsible for the database back-end of a credit rating application. Banks use such applications for estimating whether companies pay back their loans. This impacts whether they get a [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":139,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-181","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.klaushaller.net\/index.php?rest_route=\/wp\/v2\/pages\/181","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.klaushaller.net\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.klaushaller.net\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.klaushaller.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.klaushaller.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=181"}],"version-history":[{"count":1,"href":"https:\/\/www.klaushaller.net\/index.php?rest_route=\/wp\/v2\/pages\/181\/revisions"}],"predecessor-version":[{"id":182,"href":"https:\/\/www.klaushaller.net\/index.php?rest_route=\/wp\/v2\/pages\/181\/revisions\/182"}],"up":[{"embeddable":true,"href":"https:\/\/www.klaushaller.net\/index.php?rest_route=\/wp\/v2\/pages\/139"}],"wp:attachment":[{"href":"https:\/\/www.klaushaller.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=181"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}