A formal framework of aggregation for the OLAP-OLTP model

Journal of Universal Computer Science

Volumn 15, Issue 1, 2009, Pages 273-303

  Lenz, Hans J ^a   Thalheim, Bernhard ^b  

^a FREIE UNIVERSITÄT BERLIN   (Germany)

^b Department of Computer Science ^*  (Germany)

Author keywords

Aggregation functions; Cube operator; OLAP; OLTP OLAP specification frame

Indexed keywords

EID: 65349132912     PISSN: 0958695X     EISSN: 09486968     Source Type: Journal    
DOI: None     Document Type: Article

References (36)

1. Agrawal, R., Gupta, A., and Sarawagi, S. (1997). Modeling multidimensional databases. In Gray, A. and Larson, P.-Å., editors, Proc. 13th Int. Conf. on Data Engineering - ICDE'97, pages 232-243, Birmingham. IEEE Computer Society Press.
2. Buneman, P., Libkin, L., Suciu, D., Tannen, V., and Wong, L. (1994). Comprehension syntax. SIGMOD Record, 23(1):87-96.
3. Calvo, T., Mayor, G., and Mesiar, R. (2002). Aggregation operators - New trends and applications. Physica, Heidelberg.
4. Fisher, W. D. (1962). Optimal aggregation in multi-equation prediction models. Econometrica, 30:744-769.
5. Franconi, E. and Kamble, A. (2004). The gmd data model and algebra for multidimensional information. In CAiSE, volume 3084 of Lecture Notes in Computer Science, pages 446-462. Springer.
6. Gray, J., Chaudhuri, S., Bosworth, A., Layman, A., Reichart, D., and Venkatrao, M. (1997). Data cube: A relational aggregation operator generalizing group-by, cross-tab, and sub-totals. Data Mining and Knowledge Discovery, 1(1):29-53.
7. Gyssens, M. and Lakshmanan, L. V. S. (1997). A foundation for multidimensional databases. In Jarke, M., Carey, M. J., Dittrich, K. R., Lochovsky, F. H., Loucopoulos, P., and Jeusfeld, M. A., editors, Proc. 23rd Int. Conf. on Very Large Databases - VLDB'97, pages 106-115, Athens. Morgan Kaufmann, San Francisco.
8. Hand, D. J. (1994). Deconstructing statistical questions (with discussion). Journal of the Royal Statistical Society, Series A, 157:317-356.
9. Hurtado, C. and Mendelzon, A. (2002). OLAP dimension constraints. In ACM PODS, pages 169-179.
10. Lehner, W., Albrecht, J., and Wedekind, H. (1998). Normal forms for multivariate databases. In SSDBM X, Capri.
11. Lenz, H.-J. (1993). Contribution to the discussion on "Deconstructing statistical questions" by David J. Hand. Read before The Royal Statistical Society , London.
12. Lenz, H.-J. (1994). The conceptual schema and external schemata of metadatabases. In SSDBM, pages 160-165. IEEE Computer Society.
13. Lenz, H.-J. and Neiling, M. (1998). Zur Summierbarkeit von Häufigkeiten in multi-dimensionalen Tabellen. Technical Report 1998/28, Diskussionsbeiträge des Fachbereichs Wirtschaftswissenschaft der Freien Universität Berlin.
14. Lenz, H.-J. and Shoshani, A. (1997). Summarizability in OLAP and statistical databases. In SSDBM IX, 1997, Washington.
15. Lenz, H.-J. and Thalheim, B. (2001a). OLAP Databases and Aggregation Functions. In Proc. 13th Intern. Conf. on Scientific and Statistical Database Management, Jul 18-20, 2001, George Mason University, Fairfax, Virginia, USA, pages 91-100. IEEE Computer Society.
16. Lenz, H.-J. and Thalheim, B. (2001b). OLAP databases and aggregation functions. In 13th SSDBM 2001, pages 91 - 100.
17. Lenz, H.-J. and Thalheim, B. (2005). OLTP-OLAP schemes for sound applications. In TEAA 2005, volume LNCS 3888, pages 99-113, Trondheim. Springer.
18. Lenz, H.-J. and Thalheim, B. (2006). Warning - cube may mislead. In CSIT'06, volume 2, pages 7-16, Amman, Jordan.
19. Lewerenz, J., Schewe, K.-D., and Thalheim, B. (1999). Modeling data warehouses and OLAP applications by means of dialogue objects. In Proc. ER'99, LNCS 1728, pages 354-368. Springer, Berlin.
20. Malzew, A. (1965). Algorithms and recursive functions. Nauka. (in Russian).
21. Mansmann, S., Neumuth, T., and Scholl, M. (2007). Multidimensional data modeling for business process analysis. In Proc. ER'2007, LNCS, page .. Springer.
22. McCullagh, P. and Nelder, J. A. (1983). Generalized Linear Models. Chapman and Hall, London.
23. Meo-Evoli, L., Ricci, F. L., and Shoshani, A. (1992). On the semantic completeness of macro-data operators for statistical aggregations. In Hinterberger, H. and French, J. C., editors, Proc. of the 6th Int. Working Conf. on Scientific and Statistical Database Management, Monte Verita, Switzerland, 1992, pages 239-258. Institut f. Wissenschaftliches Rechnen Eidgenössische Technische Hochschule Zürich.
24. Molnar, A. (2007). A general partition data model and a contribution to the theory of functional dependencies. PhD thesis, Eötvös Loránd University, Faculty of Informatics, Budapest.
25. Molnar, A. and Thalheim, B. (2007). Conceptual development of OLAP applications. In Business Intelligence: Methods and Applications, pages 27 - 38. Klöden-Verlag.
26. Paredaens, J., Bra, P. D., Gyssens, M., and Gucht, D. V. (1989). The structure of the relational database model. Springer, Berlin.
27. Poeschel, R. and Kaluznin, L. A. (1979). Funktionen- und Relationenalgebren: Ein Kapitel der diskreten Mathematik. Birkhaeuser, Basel.
28. Rafanelli, M. (2003). Operators for multidimensional aggregate data. In Multidimensional Databases, pages 116-165.
29. Rafanelli, M. (2005). Basic notions on multidimensional aggregate data. In Khosrow-Pour, M., editor, Encyclopedia of Information Science and Technology (I), pages 211-216. Idea Group.
30. Schewe, K.-D. and Thalheim, B. (1993). Fundamental concepts of object oriented databases. Acta Cybernetica, 11(4):49-81.
31. Schneeweiß, H. (1965). Das Aggregationsproblem. Statistische Hefte, 6:1-26.
32. Simpson, C. H. (1951). The interpretation of interaction in contingency tables. JRSS, series B, 13:238-241.
33. Sondermann, D. (1973). Optimale Aggregation von großen Gleichungssystemen. Zeitschrift für Nationalökonomie, 33:235-250.
34. Thalheim, B. (1991). Dependencies in relational databases. Teubner, Leipzig.
35. Thalheim, B. (2000). Entity-relationship modeling - Foundations of database technology. Springer, Berlin.
36. Vassiladis, P. and Skiadopoulos, S. (2000). Modeling and optimization issues for multidimensional databases. In Proc. CAiSE'2000, LNCS 1789, pages 482-497. Springer, Berlin.