Developing Requirements for Data Warehouse Systems with Use Cases

Intelligent and comprehensive data warehouse systems are a powerful instrument for organizations to analyze their business. The implementation of such decision systems for an enterprise-wide management and decision support can be very different from traditional software implementations. Because data warehouse systems are strongly data-driven, the development process is highly dependent on its underlying data, which is generally stored in a data warehouse. Since data warehouse systems concern many organizational units, the collection of unambiguous, complete, verifiable, consistent and usable requirements can be a very difficult task. Use cases are considered as standard notation for object-oriented requirement modeling. In this paper we show how use cases can enhance communication between stakeholders, domain experts, data warehouse designers and other professionals with diverse backgrounds. We introduce and discuss three different abstraction levels (business, user and system requirements) of data warehouse requirements and show how use cases can be drivers for the requirements development.

By: Robert Bruckner (Vienna Univ. of Technology), Beate List (Vienna Univ. of Technology), Josef Schiefer

Published in: RC22042 in 2001

LIMITED DISTRIBUTION NOTICE:

This Research Report is available. This report has been submitted for publication outside of IBM and will probably be copyrighted if accepted for publication. It has been issued as a Research Report for early dissemination of its contents. In view of the transfer of copyright to the outside publisher, its distribution outside of IBM prior to publication should be limited to peer communications and specific requests. After outside publication, requests should be filled only by reprints or legally obtained copies of the article (e.g., payment of royalties). I have read and understand this notice and am a member of the scientific community outside or inside of IBM seeking a single copy only.

rc22042.pdf

Questions about this service can be mailed to reports@us.ibm.com .