Prototyping Data Warehouse Systems

  • Thanh N. Huynh
  • Josef Schiefer
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 2114)


The process of developing and evolving complex data warehouse systems is intrinsically exploratory in nature. Data warehouse projects are notoriously difficult to manage and many of them end in failure. One explanation for the high failure rate is the lack of understanding of the requirements and missing proof-of-concepts for a decision support for the knowledge workers of an organization. In this paper, we present a prototyping approach for data warehouse environments. We show how prototyping can support an incremental and iterative requirement development. We introduce different types of prototypes and illustrate their applicability for data warehouse systems. Finally, we show how to develop data warehouse prototypes with the BEDAWA tool, which supports a rapid development of prototypes by automatically generating the mass sample data for a data warehouse system.


Data Warehouse Fact Table Prototype Tool Evolutionary Prototype Star Schema 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [1]
    Bitton, D.; Orji, C., Program Documentation for DBGEN, a test database generator, University of Illinois at Chicago.Google Scholar
  2. [2]
    Davis, Alan M., Software Requirements: Objects, Functions, and States, PTR Prentice HallGoogle Scholar
  3. [3]
    Floyd, C.A, A Systematic Look at Prototyping. In: Bude et al. (eds) approaches to Prototyping Springer Verlag, 1984Google Scholar
  4. [4]
    Goldman, N.M.; Narayanaswamy, K., Software Evolution through Iterative Prototyping 14th Int. Conf. on SW Eng., IEEE, 1992Google Scholar
  5. [5]
    Huynh, T.; Nguyen, B.; Schiefer, J.; Tjoa, AM., BEDAWA-A Tool for Generating Sample Data for Data Warehouses. Data Warehousing and Knowledge Discovery, 2nd Int’l Conf., Dawak 2000, Greenwich, UK., Springer-Verlag.Google Scholar
  6. [6]
    Huynh, T.; Nguyen, B.; Schiefer, J.; Tjoa, AM., Representative Sample Data for Data Warehouse Environments ADVIS2000, TurkeyGoogle Scholar
  7. [8]
    Kimball, R. (1996). The Data Warehouse Toolkit, John Wiley & Sons Inc.Google Scholar
  8. [9]
    Lichter, H.; Schneider-Hufschmidt, M.; Zuellighoven, H. Prototyping in Industrial software Projects-Bridging the Gap Between Theory and Practice, IEEE Trans. on SE, Vol 20,No 11, pp 825–832, 1993CrossRefGoogle Scholar
  9. [10]
    List, B.; Schiefer, J.; Tjoa, AM., Use Case Driven Requirements Analysis for Data Warehouse Systems, Data Warehousing 2000, FriedrichshafenGoogle Scholar
  10. [11]
    Nielsen, J., Prototyping user interfaces using an object-oriented hypertext programming system, Proc. NordDATA’89 Joint Scandinavian Computer Conference Copenhagen, DenmarkGoogle Scholar
  11. [12]
    Nielsen, J., Paper versus computer implementations as mockup scenarios for heuristic evaluation, Proc. INTERACT’90 3rd IFIP Conf. Human-Computer Interaction Cambridge, UKGoogle Scholar
  12. [13]
    Rao, C.R.; Toutenburg, H., Linear Models least Squares and Alternatives, Springer-Verlag New York, Inc. 1995.zbMATHGoogle Scholar
  13. [14]
    Schach, S.R., Classical and Object-Oriented Software Engineering, 3rd, IRWIN.Google Scholar
  14. [15]
    Schiefer, J.; Tjoa, AM., Generating Sample Data for Mining and Warehousing Proc. Int. Conference on Business Information System Springer-Verlag, BIS 99, PoznanGoogle Scholar
  15. [16]
    Turbyfill, C.; Bitton, D., AS3AP-An ANSI SQL Standard Scalable and Portable Benchmark for Relational Database Systems. The Benchmark Handbook. J. Gray, Morgan Kaufmann Publishers.Google Scholar
  16. [17]
    Whiteside, J.; Bennett, J.; Holtzblatt, K., Usability Engineering: Our experience and Evolution. In: Handbook of Human-Computer Interaction Amsterdam, Elsevier, 1988Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2001

Authors and Affiliations

  • Thanh N. Huynh
    • 1
  • Josef Schiefer
    • 2
  1. 1.1Institute of Software TechnologyVienna University of TechnologyVienna
  2. 2.Watson Research Center, IBMVienna

Personalised recommendations