SpringerLink
Log in

A Decathlon in Multidimensional Modeling: Open Issues and Some Solutions

  • Conference paper
  • First Online:
Data Warehousing and Knowledge Discovery (DaWaK 2002)

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

Included in the following conference series:

  • 1283 Accesses

Abstract

The concept of multidimensional modeling has proven extremely successful in the area of Online Analytical Processing (OLAP) as one of many applications running on top of a data warehouse installation. Although many different modeling techniques expressed in extended multidimensional data models were proposed in the recent past, we feel that many hot issues are not properly reflected. In this paper we address ten common problems reaching from defects within dimensional structures over multidimensional structures to new analytical requirements and more.

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

Access this chapter

Log in via an institution

Subscribe and save

Springer+ Basic
EUR 32.99 /Month
  • Get 10 units per month
  • Download Article/Chapter or Ebook
  • 1 Unit = 1 Article or 1 Chapter
  • Cancel anytime
Subscribe now

Buy Now

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

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Similar content being viewed by others

References

  1. Baralis, E.; Paraboschi, S.; Teniente, E.: Materialized View Selection in a Multidimensional Database. VLDB’ 97, Athens, Greece, 1997

    Google Scholar 

  2. Brodsky, A.; Farkas, C.; Jajodia., S.: Secure databases: Constraints, inference channels, and monitoring disclosures. IEEE Trans. Knowledge and Data Engineering, 12(6):900–919, 2000.

    Article  Google Scholar 

  3. Chaudhuri, S; Das, G., Narasayya, V.: A Robust, Optimization-Based Approach for Approximate Answering of Aggregate Queries. ACM SIGMOD, Santa Barbara, USA. 2001.

    Google Scholar 

  4. Chen, P. et al: Evaluating Aggregate Operation over Imprecise Data. IEEE Trans. on Knowledge and Data Engineering, 8(2):273–284, 1996.

    Article  Google Scholar 

  5. 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

    Google Scholar 

  6. N.N.: Common Warehouse Metamodel specification. OMG (http://www.omg.org/cwm/)

  7. Date, C.J.: An Introduction to Database Systems. 7th ed. Reading, Massachusettes, 2000

    Google Scholar 

  8. Denning, D.E.: Secure statistical databases with random sample queries. ACM Trans. on Database Systems, 5(3):291–315, 1980.

    Article  MATH  Google Scholar 

  9. Dyreson, C. E.: Information Retrieval from an Incomplete Data Cube. VLDB’96, Bombay, 1996.

    Google Scholar 

  10. Gray, J.; Bosworth A.; Layman A.; Pirahesh, H.: Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Total. ICDE’96, New Orleans, 1996

    Google Scholar 

  11. Gamma, E.; Helm, R.; Johnson, R.; Vlissides, J.: Design Patterns — Elements of Reusable Object-Oriented Software. Boston et al., 1994

    Google Scholar 

  12. Gupta, A.; Mumick, I.: Maintenance of Materialized Views: Problems, Techniques, and Applications. In: IEEE Data Engineering Bulletin, Special Issue on Materialized Views & Data Warehousing 18(1995)2

    Google Scholar 

  13. Harinarayan, V.; Rajaraman, A.; Ullman, J.D.: Implementing Data Cubes Efficiently. SIGMOD’ 96, Montreal, Canada, 1996

    Google Scholar 

  14. Hurtado, C.; Mendelzon, A.: Reasoning about Summarizability in Heterogeneous Multidimensional Schemas. ICDT’01, 2001.

    Google Scholar 

  15. Hurtado, C.; Mendelzon, A.: OLAP Dimension Constraints. PODS’02, Madison, 2002.

    Google Scholar 

  16. Hurtado, C.; Mendelzon, A.; Vaisman, A.: Maintaining data cubes under dimension updates. ICDE’99

    Google Scholar 

  17. Jagadish, H. V.; Lakshmanan, L. V. S.; Srivastava, D.: What can Hierarchies do for Data Warehouses? VLDB’99, Bombay, 1999.

    Google Scholar 

  18. Joseph M. Hellerstein, Peter J. Haas, Helen Wang: Online Aggregation. SIGMOD Conference 1997

    Google Scholar 

  19. N.N.: Hyperion Essbase OLAP Server, Hyperion Software Corporation, 1999 (http://www.hyperion.com/essbaseolap.cfm)

  20. Inmon, W.H.: Building the Data Warehouse, New York, John Wiley & Sons, 1996

    Google Scholar 

  21. Kimball, R.: The Data Warehouse Toolkit, New York, John Wiley & Sons, 1996

    Google Scholar 

  22. Lehner, W., Albrecht, J., Wedekind, H.: Multidimensional Normal Forms. SSDBM’98, Capri, Italy, 1998

    Google Scholar 

  23. Lehner, W.; Ruf, T.; Teschke, M.: CROSS-DB: A Feature-extended multi-dimensional Data Model for Statistical and Scientific Databases. CIKM’96, Rockville (MD), U.S.A., 1996

    Google Scholar 

  24. Lenz, H.-J.; Shoshani, A: Summarizability in OLAP and Statistical Data Bases. SSDBM’97, Olympia

    Google Scholar 

  25. Malvestuto, F.M.; Moscarini, M.: Computational issues connected with the protection of sensitive statistics by auditing sum-queries. IEEE SSDM’98, 1998.

    Google Scholar 

  26. Mason, R.: Statistical Design and Analysis of Experiments: With Applications to Engineering and Science (Wiley Series in Probability and Mathematical Statistic), John Wiley & Sons, 1989

    Google Scholar 

  27. N.N.: OLAP Council API, MDAPI version 2.0 specification. OLAP Council (http://www.olapcouncil.org/research/apily.htm)

  28. N.N.: The Multidimensional Expressions language (MDX). Microsoft Corporation (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmad/agmdxbasics_04qg.asp)

  29. N.N.: Microstrategy 6, MicroStrategy Inc., 1999, (http://www.microstrategy.com/Products/index.asp)

  30. O'Neil, P.: INFORMIX and Indexing Support for Data Warehouses. In: Database Programming and Design, v. 10, no. 2, February, 1997

    Google Scholar 

  31. N.N.: Open Information Model, Meta Data Coalition, (http://www.mdcinfo.com/)

  32. Mirek Riedewald, Divyakant Agrawal, Amr El Abbadi: Flexible Data Cubes for Online Aggregation. ICDT’01, London, United Kingdom, 2001

    Google Scholar 

  33. Pedersen, T. B.; Jensen, C. S.; Dyreson, C. E.: Supporting Imprecision in Multidimensional Databases Using Granularities. SSDBM’99, 1999.

    Google Scholar 

  34. Pedersen, T. B.; Jensen, C. S.; Dyreson, C. E.: A foundation for capturing and querying complex multidimensional data. Information Systems, 26(5): 383–423, 2001.

    Article  MATH  Google Scholar 

  35. Praveen Seshadri, Miron Livny, Raghu Ramakrishnan: The Design and Implementation of a Sequence Database System. VLDB’96, Mumbai (Bombay), India, 1996

    Google Scholar 

  36. Shoshani, A.: OLAP and Statistical Databases: Similarities and Differences, PODS’97, Tuscon, Arizona

    Google Scholar 

  37. Smith, J.M.; Smith, D.C.P.: Database Abstractions: Aggregation and Generalization, ACM Transactions on Database Systems 2(1977)2

    Article  Google Scholar 

  38. Snodgrass, R. T. (Hrsg.): The TSQL2 Temporal Query Language. Kluwer Academic Publishing, Amsterdam, 1995

    MATH  Google Scholar 

  39. N.N.: ISO/IEC 9075: 1999, Informatik Technology — Database Languages — SQL, 1999

    Google Scholar 

  40. Song, I.; Rowan, B.; Medsker, C.; Ewen, E.: An Analysis of Many-to-Many Relationships Between Fact and Dimension Tables in Dimensional Modeling. DMDW’01, 2001.

    Google Scholar 

  41. Steger, J.; Günzel, H.; Bauer, A.: Identifying Security Holes in OLAP Applications. IFIP WG 11.3 Conference on Database Security, Schoorl, Netherlands, 2000

    Google Scholar 

  42. Tsois, A.; Karayiannidis, N.; Sellis, T.: MAC: Conceptual data modeling for OLAP. DMDW’01, 2001.

    Google Scholar 

  43. Vassiliadis, P.; Sellis, T.: A Survey of Logical Models for OLAP Databases. In: SIGMOD Record 28(1999)4

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. University of Erlangen-Nuremberg (Database Systems), Martensstr. 3, D-91058, Erlangen, Germany

    W. Hümmer, W. Lehner, A. Bauer & L. Schlesinger

Authors
  1. W. Hümmer
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. W. Lehner
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. A. Bauer
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. L. Schlesinger
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Graduate School of Informatics, Kyoto University, Yoshida-Honmachi, Sakyo-ku, 606-8501, Kyoto, Japan

    Yahiko Kambayashi

  2. Institute for Computer Science and Business Informatics, University of Vienna, Liebiggasse 4, 1010, Vienna, Austria

    Werner Winiwarter

  3. Center for Spatial Information Science (CSIS), University of Tokyo, 4-6-1, Komaba, Meguro-ku, 153-8904, Tokyo, Japan

    Masatoshi Arikawa

Rights and permissions

Reprints and permissions

Copyright information

© 2002 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Hümmer, W., Lehner, W., Bauer, A., Schlesinger, L. (2002). A Decathlon in Multidimensional Modeling: Open Issues and Some Solutions. In: Kambayashi, Y., Winiwarter, W., Arikawa, M. (eds) Data Warehousing and Knowledge Discovery. DaWaK 2002. Lecture Notes in Computer Science, vol 2454. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-46145-0_27

Download citation

  • DOI: https://doi.org/10.1007/3-540-46145-0_27

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-44123-6

  • Online ISBN: 978-3-540-46145-6

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation