Skip to main content
Springer Nature Link
Log in

OLAP Schemata for Correct Applications

  • Conference paper
Trends in Enterprise Application Architecture (TEAA 2005)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 3888))

Abstract

OLAP applications are currently widely used in business applications. These applications are implicitly defined on top of OLTP systems. The applications make use of aggregation functions and data combinations. A number of paradoxes is observed if arbitrary aggregation functions and combinations are used. We develop a theory of aggregation functions, OLTP-OLAP transformations, and of the data cube. Based on these investigations we derive an architecture for OLTP-OLAP applications that supports sound and correct querying: OLTP-OLAP specification frames. The specification frame of OLTP-OLAP schemata specifically emphasises soundness of all operations involved by built-in guards. Or to turn it around, we make provision that an innocent user does not start non-sense operations. This specification frame is based on OLTP schemata, OLTP-OLAP transformations, and a rigid theory of OLAP schemata and functions.

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

Access this chapter

Log in via an institution

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. Buneman, P., Libkin, L., Suciu, D., Tannen, V., Wong, L.: Comprehension syntax. SIGMOD Record 23(1), 87–96 (1994)

    Article  Google Scholar 

  2. Calvo, T., Mayor, G., Mesiar, R.: Aggregation operators - New trends and applications. Physica, Heidelberg (2002)

    Book  MATH  Google Scholar 

  3. Fisher, W.D.: Optimal aggregation in multi-equation prediction models. Econometrica 30, 744–769 (1962)

    Article  MATH  Google Scholar 

  4. Gray, J., Chaudhuri, S., Bosworth, A., Layman, A., Reichart, D., Venkatrao, M.: Data cube: A relational aggregation operator generalizing group-by, cross-tab, and sub-totals. Data Mining and Knowledge Discovery 1(1), 29–53 (1997)

    Article  Google Scholar 

  5. Hand, D.J.: Deconstructing statistical questions (with discussion). Journal of the Royal Statistical Society, Series A 157, 317–356 (1994)

    Article  Google Scholar 

  6. Lehner, W., Albrecht, J., Wedekind, H.: Normal forms for multivariate databases. In: SSDBM X, Capri (1998)

    Google Scholar 

  7. Lenz, H.-J.: Contribution to the discussion on “Deconstructing statistical questions”. In: Hand, D.J. (ed.) Read before The Royal Statistical Society, London, December 15 (1993)

    Google Scholar 

  8. Lenz, H.-J., Shoshani, A.: Summarizability in OLAP and statistical databases. In: SSDBM IX 1997, Washington (1997)

    Google Scholar 

  9. Lenz, H.-J., Thalheim, B.: OLAP Databases and Aggregation Functions. In: Proc. 13th Intern. Conf. on Scientific and Statistical Database Management, George Mason University, Fairfax, Virginia, USA, July 18-20, pp. 91–100. IEEE Computer Society, Los Alamitos (2001)

    Google Scholar 

  10. Schewe, K.-D., Thalheim, B.: Fundamental concepts of object oriented databases. Acta Cybernetica 11(4), 49–81 (1993)

    MathSciNet  MATH  Google Scholar 

  11. Schneeweiß, H.: Das Aggregationsproblem. Statistische Hefte 6, 1–26 (1965)

    Article  MATH  Google Scholar 

  12. Siedersleben, J.: Moderne Softwarearchitektur. dpunkt-Verlag (2004)

    Google Scholar 

  13. Simpson, C.H.: The interpretation of interaction in contingency tables. JRSS, series B 13, 238–241 (1951)

    MathSciNet  MATH  Google Scholar 

  14. Snodgrass, R.T.: Developing time-oriented database applications in SQL. Morgan Kaufmann, San Francisco (1999)

    Google Scholar 

  15. Sondermann, D.: Optimale Aggregation von großen Gleichungssystemen. Zeitschrift für Nationalökonomie 33, 235–250 (1973)

    Article  MATH  Google Scholar 

  16. Thalheim, B.: Entity-relationship modeling – Foundations of database technology. Springer, Berlin (2000)

    Book  MATH  Google Scholar 

  17. Vassiliadis, P., Skiadopoulos, S.: Modelling and optimisation issues for multidimensional databases. In: Wangler, B., Bergman, L.D. (eds.) CAiSE 2000. LNCS, vol. 1789, pp. 482–497. Springer, Heidelberg (2000)

    Chapter  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Institute of Production, Information Systems and Operations Research, Free University Berlin, Garystr. 21, 14195, Berlin, Germany

    Hans-Joachim Lenz

  2. Department of Computer Science and Applied Mathematics, Christian Albrechts University Kiel, Olshausenstr. 40, D-24098, Kiel, Germany

    Bernhard Thalheim

Authors
  1. Hans-Joachim Lenz
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Bernhard Thalheim
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Software Competence Center Hagenberg, Austria

    Dirk Draheim

  2. Department of Physics, New Zealand

    Gerald Weber

Rights and permissions

Reprints and permissions

Copyright information

© 2006 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Lenz, HJ., Thalheim, B. (2006). OLAP Schemata for Correct Applications. In: Draheim, D., Weber, G. (eds) Trends in Enterprise Application Architecture. TEAA 2005. Lecture Notes in Computer Science, vol 3888. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11681885_9

Download citation

  • DOI: https://doi.org/10.1007/11681885_9

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-32734-9

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

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics