Test-Driven Development of Data Warehouses

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.

Download Full-text

Test-Driven Development of Data Warehouses

International Journal of Business Intelligence Research ◽

10.4018/jbir.2011010105 ◽

2011 ◽

Vol 2 (1) ◽

pp. 64-73

Author(s):

Sam Schutte ◽

Thilini Ariyachandra ◽

Mark Frolick

Keyword(s):

Software Development ◽

Data Warehouse ◽

Data Warehousing ◽

Test Cases ◽

Data Warehouses ◽

Team Members ◽

Test Driven Development ◽

Development Methodology ◽

Software Development Methodology ◽

Business Requirements

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.

Download Full-text

A Methodology for Datawarehouse Design

Data Warehousing and Web Engineering ◽

10.4018/978-1-931777-02-5.ch009 ◽

2011 ◽

pp. 185-197

Author(s):

Jose Maria Cavero ◽

Esperanza Marcos ◽

Mario Piattini ◽

Adolfo Sanchez

Keyword(s):

Software Development ◽

Data Warehousing ◽

Conceptual Modeling ◽

Physical Design ◽

Online Analytical Processing ◽

Development Methodology ◽

Operational Systems ◽

Analytical Processing ◽

Software Development Methodology

Data warehousing and online analytical processing (OLAP) technologies have become growing interest areas in latest years. Specific issues, such as conceptual modeling, schemes translation from operational systems, physical design, etc... have been widely treated, but there is not a general accepted complete methodology for datawarehouse design. In this work, we present a multidimensional datawarehouse development methodology based on and integrated with a Public software development methodology.

Download Full-text

A Multidimensional Data Warehouse Development Methodology

Managing Data Mining Technologies in Organizations ◽

10.4018/978-1-59140-057-8.ch010 ◽

2011 ◽

pp. 188-201 ◽

Cited By ~ 1

Author(s):

Jose Maria Cavero ◽

Carmen Costilla ◽

Esperanza Marcos ◽

Mario G. Piattini ◽

Adolfo Sanchez

Keyword(s):

Software Development ◽

Data Warehouse ◽

Data Warehousing ◽

Conceptual Modeling ◽

Physical Design ◽

Multidimensional Data ◽

Development Methodology ◽

Development Cycle ◽

Operational Systems ◽

Analytical Processing

Data warehousing and online analytical processing (OLAP) technologies have become growing interest areas in recent years. Specific issues such as conceptual modeling, schemes translation from operational systems, physical design, etc. have been widely treated. A few methodologies covering the entire development cycle have also been proposed, but there is still not a general, accepted, complete methodology for data warehouse design. In this work we present a multidimensional data warehouse development methodology integrated within a traditional software development methodology.

Download Full-text