Abstract
Slice&dice and drilling operations are key concepts for ad-hoc data analysis in state-of- the-art data warehouse and OLAP (On-Line Analytical Processing) systems. While most data analysis operations can be executed on that basis from a functional point of view, the representation requirements of applications in the SSDB (Scientific&Statistical DataBase) area by far exceed the means typically provided by OLAP systems. In the first part of the paper, we contrast the data analysis and representation approaches in the OLAP and SSDB field and develop a generalized model for the representation of complex reports in data warehouse environments. The second part of the paper describes the implementation of this model from a report definition, management and execution perspective. The research and implementation work was executed in the data warehouse project at GfK Marketing Services, a topranked international market research company. Various examples from the market research application domain will demonstrate the benefits of the work over other approaches in the data warehouse and OLAP domain.
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
Ackoff, R. L.: Management Misinformation Systems, in: Management Science (1967) 4, pp. 147–156
Booch, G.; Rumbaugh, J.; Jacobson, I.,: Unified Modeling Language User Guide, Reading, Massachusetts, 1997
Chaudhuri, S.; Dayal, U.: An Overview of Data Warehousing and OLAP Technology, SIGMOD Record 26 (1997) 1, pp. 65–74
Codd, E.F.; Codd, S.B.; Salley, C.T.: Providing OLAP (On-line Analytical Processing) to User Analysts: An IT Mandate, White Paper, Arbor Software Corporation, 1993
Gorry, G. A.; Scott Morton, M. S.: A Framework for Management Information Systems, in: Sloan Management Review 13 (1971) 1, pp. 55–70
Inmon, W. H.: Building the Data Warehouse, Second Edition, New York e.a.: John Wiley&Sons, Inc., 1996
Keen, P. G. W.; Scott Morton, M. S.: Decision Support Systems: An Organizational Perspective, Reading, Massachusetts, 1978
Lehner, W.; Ruf, T.; Teschke, M.: CROSS-DB: A Feature-Extended Multidimensional Data Model for Statistical and Scientific Databases, in: Proceedings of the 5 th International Conference on Information and Knowledge Management (CIKM’ 96), Rockville, MD, Nov. 12-16), 1996, pp. 253–260
Lehner, W.; Ruf, T.; Teschke, M.: Improving Query Response Time in Scientific Databases using Data Aggregation-A Case Study, in: Proceedings of the 5 th International Workshop on Database and Expert Systems Applications (DEXA’ 96, Zurich, Switzerland, Sept. 9-13), 1996, S. 201–206
Mertens, P.; Griese, J.: Integrierte Informationsverarbeitung 2-Planungs-und Kontrollsysteme in der Industrie, 7th Edition, Wiesbaden: Gabler, 1993
MicroStrategy, Inc.: http://www.microstrategy.com/products/index.htm
Ruf, T.; Baumann, G.; Albrecht, J.; Lehner, W.: Revealing Real Problems in Real Data Warehouse Applications, submitted for publication
Rumbaugh, J., Jacobson, I., Booch, G.: Unified Modeling Language Reference Manual, Reading, Massachusetts 1997
Shoshani, A.: OLAP and Statistical Databases: Similarities and Differences, in: Proceedings of the 16 th ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems (PODS’ 97, Tucson, AZ), 1997, pp. 185–196
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1999 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Ruf, T., Goerlich, J., Reinfels, I. (1999). Dealing with Complex Reports in OLAP Applications. In: Mohania, M., Tjoa, A.M. (eds) DataWarehousing and Knowledge Discovery. DaWaK 1999. Lecture Notes in Computer Science, vol 1676. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-48298-9_5
Download citation
DOI: https://doi.org/10.1007/3-540-48298-9_5
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-66458-1
Online ISBN: 978-3-540-48298-7
eBook Packages: Springer Book Archive