Abstract
The generation of representative sample data for data warehouses for henchmarking, testing and presentation purposes is a challenging complex task. Difficulties often arise in producing familiar, complete and consistent sample data of any scale. Producing sample data manually often causes problems, which can be avoided by an automatic generation tool producing consistent and statistical plausible data. The data generated by the tool is based on the linear statistical model of a hierarchical n-way classification with fixed effects. We present an approach for a flexible generation of “real world” sample data using the BEDAWA (BEnchmarks forDAta WArehouses) tool.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
R. Christenscn, Plane Answers to Complex Questions: The Theory of Linear Models, Springer-Verlag, 1987.
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.
E. Codd, S. Codd, and C. 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.
V. Harinarayan, A. Rajaraman, J. D. Ullman, Implementing Data Cubes Efficiently, SIGMOD Conf. 1996: 205–216.
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, 1998
OLAP Council, APB-1 OLAP Benchmark. Release II, 1998
J. Schiefer, A. Min Tjoa, Generating Sample Data for Mining and Warehousing, Proc. Tnt. 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, TCP-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). BEDAWA - A Tool for Generating Sample Data for Data Warehouses. In: Kambayashi, Y., Mohania, M., Tjoa, A.M. (eds) Data Warehousing and Knowledge Discovery. DaWaK 2000. Lecture Notes in Computer Science, vol 1874. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-44466-1_9
Download citation
DOI: https://doi.org/10.1007/3-540-44466-1_9
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-67980-6
Online ISBN: 978-3-540-44466-4
eBook Packages: Springer Book Archive