Skip to main content

Process-Oriented Requirement Analysis Supporting the Data Warehouse Design Process A Use Case Driven Approach

  • Conference paper
  • First Online:

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 1873))

Abstract

A comprehensive requirement analysis for data warehouse systems is mostly often the starting point for the implementation of an enterprise-wide decision support system. Because data warehouse systems concern many organisational 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 modelling. We illustrate how use cases enhances communication between domain experts, data warehouse specialists, data warehouse designers and other professionals with different backgrounds. They can be used on a general level, which is intuitive for the users of data warehouse system. This paper explains how use cases can be used to elicit requirements for data warehouse systems, and how to involve the organisational context in the modelling process. With an adapted object model, we demonstrate how to capture different analysis perspectives of the business process. We develop a predefined set of dimension objects that belong to every classic business process and are able to create various fact objects, representing these perspectives.

This is a preview of subscription content, log in via an institution.

Buying options

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   84.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   109.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Anahory, S. Murray, D., Data Warehousing in the real World-A practical Guide for Building Decision Support Systems, Addison-Wesley Publishing 1997.

    Google Scholar 

  2. Coad, P., Yourdon, E., Object-Oriented Analysis. Englewood Cliffs, N.J.: Prentice Hall 1991.

    Google Scholar 

  3. Davenport, Th., Process Innovation: Reengineering Work through Information Technology, Harvard Business School Press 1993.

    Google Scholar 

  4. Davis, A., Hisa, P., Status Report: Requirements Engineering, IEEE Software November 1993.

    Google Scholar 

  5. Debevoise, N. T., The Data Warehouse Method, Prentice-Hall, 1999.

    Google Scholar 

  6. Finkelstein, A., Requirements Engineering Research: Coordination and Infrastructure, Requirements Engineering 1, 1996.

    Google Scholar 

  7. Hammer, M., Champy, J., Reengineering the Corporation-A Manifesto for Business Revolution, Harper Collins Publishers 1993.

    Google Scholar 

  8. Hammer, M., Beyond Reengineering, Harper Collins Publishers 1996.

    Google Scholar 

  9. IEEE, IEEE Guide to Software Requirements Specifications, IEEE Inc., 1984

    Google Scholar 

  10. Inmon, W. H., Building the Data Warehouse, Wiley & Sons 1996.

    Google Scholar 

  11. Jacobson, I., Christerson, M., Jonsson, P., Overgaard, G., Object-Oriented-Software Engineering-A Use Case Driven Approach, Addison Wesley 1992.

    Google Scholar 

  12. Jacobson, I., Ericson, M., Jacobson, A., The Object Advantage-Business Process Reengineering with Object Technology, ACM Press, Addison-Wesley Publishing 1995.

    Google Scholar 

  13. Kimball, R., The Data Warehouse Toolkit: Practical Techniques For Building Dimensional Data Warehouse, John Wiley & Sons 1996.

    Google Scholar 

  14. Kimball, R., Reeves, L., Ross, M., Thornthwaite, W., The Data Warehouse Lifecycle Toolkit, John Wiley & Sons, 1998

    Google Scholar 

  15. Leymann, F., Roller, D., Production Workflow-Concepts and Techniques, Prentice Hall PTR, 2000.

    Google Scholar 

  16. List, B., Schiefer, J., Tjoa, A. M., Quirchmayr, G., The Process Warehouse-A Data Warehouse Approach for Business Process Management, In e-Business and Intelligent Management-Proceedings of the International Conference on Management of Information and Communication Technology (MiCT1999), Copenhagen, Denmark, 1999.

    Google Scholar 

  17. List, B., Schiefer, J., Tjoa, A. M., Quirchmayr, G., The Process Warehouse Approach for Inter-Organisational e-Business Process Improvement, To appear in Proceedings of Re-Technologies for Information Systems (ReTIS2000) integrated in Reengineering Week 2000, Zurich, Switzerland, 2000.

    Google Scholar 

  18. List, B., Schiefer, J., Tjoa, A. M., Quirchmayr, G., A Generic Data Model for the Process Warehouse-An Approach for Multidimensional Business Process Analysis, Proceedings of Business Information Systems 2000 (BIS 2000), Poznan, Poland, 2000.

    Google Scholar 

  19. Poe, V., Building a Data Warehouse for Decision Support, Prentice Hall 1995.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2000 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

List, B., Schiefer, J., Tjoa, A.M. (2000). Process-Oriented Requirement Analysis Supporting the Data Warehouse Design Process A Use Case Driven Approach. In: Ibrahim, M., Küng, J., Revell, N. (eds) Database and Expert Systems Applications. DEXA 2000. Lecture Notes in Computer Science, vol 1873. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-44469-6_55

Download citation

  • DOI: https://doi.org/10.1007/3-540-44469-6_55

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-67978-3

  • Online ISBN: 978-3-540-44469-5

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics