Test-Driven Development of Data Warehouses

Test-Driven Development of Data Warehouses

Sam Schutte (Unstoppable Software, Inc., USA), Thilini Ariyachandra (Xavier University, USA) and Mark Frolick (Xavier University, USA)
Copyright: © 2011 |Pages: 10
DOI: 10.4018/jbir.2011010105
OnDemand PDF Download:
No Current Special Offers


Test-driven development is a software development methodology that has recently gained a great deal of traction in the software development community. It focuses on creating software-based test cases that define the business requirements of an application before beginning the coding of the application itself. This paper proposes that test-driven development could be a useful methodology for data warehouse projects, in that it could help team members avoid some of the major pitfalls of data warehousing, and result in a higher-quality end product.
Article Preview

Status Of Tdd In The Bi & Data Warehousing Space

While the data warehouse and business intelligence industry has adopted a few of the methods from agile development, such as “bite size analysis” (Arnett, 2002) and improved coding practices, the methods of test-driven development are only starting to gain use. For instance, test-driven development has been proposed as a way to verify the validity of business intelligence reports such as Crystal Reports (Landes, 2005). In the specific area of data warehousing however, test-driven development does not appear to have made an impact.

If the principles of test-driven development were applied to a data warehousing project, the resulting data warehouse would likely be of high quality and its functionality would not exceed the scope of the original request. Additionally, it would be scientifically provable through the use of the software-based test cases that the data within a data warehouse was correct – even in the face of disbelieving executives who may question the accuracy of reports generated from the data warehouse.

Complete Article List

Search this Journal:
Volume 12: 2 Issues (2021)
Volume 11: 2 Issues (2020)
Volume 10: 2 Issues (2019)
Volume 9: 2 Issues (2018)
Volume 8: 2 Issues (2017)
Volume 7: 2 Issues (2016)
Volume 6: 2 Issues (2015)
Volume 5: 4 Issues (2014)
Volume 4: 4 Issues (2013)
Volume 3: 4 Issues (2012)
Volume 2: 4 Issues (2011)
Volume 1: 4 Issues (2010)
View Complete Journal Contents Listing