Abstract
The lack of sample data for data warehouse or OLAP systems usually makes it difficult for enterprises to evaluate, demonstrate or benchmark these systems. However, the generation of representative sample data for data warehouses is a challenging and complex task. Difficulties often arise in producing familiar, complete and consistent sample data on any scale. Producing sample data manually often causes problems that can be avoided by an automatic generation tool that produces consistent and statistically plausible data. In this paper, we determine requirements for sample data generation, and introduce the BEDAWA tool, a sample data generation tool, designed and implemented in a 3-tier CORBA architecture. A short discussion on the sample data generating results proves the usability of the tool.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
R. C. Barquin, H. A. Edelstein, Planning and Design the Data Warehouse, Prentice Hall PTR, 1997
R. Cattell, The Benchmark Handbook, 1993.
S. Chaudhuri, U. Dayal, An Overview of Data Warehousing and OLAP Technology, SIGMOD Record Volume 26, Number 1, September 1997.
R. Christensen, Plane Answers to Complex Questions: The Theory of Linear Models, Springer-Verlag, 1987.
E. F. Codd, S. B. Codd, and C. T. Salley, Providing OLAP (On-Line Analytical Processing) to user-analysts: An IT mandate, Technical report, 1993.
D. J. Dewitt, The Wisconsin Benchmark: Past, Present, and Future, The Benchmark handbook, chapter 4, 1993.
H. Gupta, V. Harimarayan, A. Jajaraman, Jeffrey D. Ullman, Index Selection for OLAP, ICDE 1997: 208–219.
D. Harkey, R. Orfali, Client/Server Programming with Java and CORBA, 2nd, John Wiley & Sons inc., 1998.
J. M. Hellerstein, The Case for Online Aggregation, SIGMOD 1997.
W.H. Inmon, Building the Data Warehouse, John Wiley, 1992.
R. Kimball, The Data Warehouse Toolkit, John Wiley & Sons inc., 1996.
R. Kimball, A Dimensional Modelling Manifesto, DBMS Magazine, 1997.
R. Kimball, L. Reeves, M. Ross, W. Thornthwaite, The Data Warehouse Lifecycle Toolkit, John Wiley & Sons inc., 1998
A White Paper, MicroStrategy Incorporated, The Case for Relational OLAP.
OLAP Council, APB-1 OLAP Benchmark. Release II, 1998
J. Schiefer, A. M. Tjoa, Generating Sample Data for Mining and Warehousing, Proc. Int. Conference on Business Information System, Springer-Verlag, 1999.
O. Serlin, The history of debitcredit and the TPC, The Benchmark handbook, chapter 2, 1993.
Transaction Processing Performance Council, TPC-D benchmark
C. Turbyfill, C. Orji, D. Bitton, AS3AP-An ANSI SQL Standard Scalable and Portable Benchmark for Relational Database Systems, The Benchmark handbook, chapter 5, 1993.
R. Winter, P. Kostamaa, On-the-fly on the up and up, Intelligent Enterprise Magazine, November 16th, 1999.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2000 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Huynh, T.N., Nguyen, B.T., Schiefer, J., Tjoa, A.M. (2000). Representative Sample Data for Data Warehouse Environments. In: Yakhno, T. (eds) Advances in Information Systems. ADVIS 2000. Lecture Notes in Computer Science, vol 1909. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-40888-6_5
Download citation
DOI: https://doi.org/10.1007/3-540-40888-6_5
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-41184-0
Online ISBN: 978-3-540-40888-8
eBook Packages: Springer Book Archive