Abstract
OLAP operations have been widely accepted as a suitable method for decision support by data analysis. Among others, roll-up and drill-down are practically implemented by using database operations. However, we cannot define them as inverses of each other since they assume how to manage materialized views. In this work, we model these operators in the framework of meta objects, and extend relational algebra by introducing meta operators group and apply. Then we show two OLAP operations can be managed within the framework of (new) database operations.
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
Cabibbo, L. and Torlone, R.: A Framework for the Investigation of Aggregate Functions in Database Queries, proc. ICDT (1999),pp 383–397
S. Chaudhuri et al: An Overview of Data Warehousing and OLAP Technology. ACM SIGMOD Record, Vol. 26 No. 1 P. 65–74, March 1997
Fegaras, L. and Maier, D.: Towards An Effective Calculus for Object Query Languages, proc.SIGMOD (1995)
Gray, P.M.D.: LOGIC, ALGEBRA AND DATABASES, Sangyou ToSho (1989)
Jim Gray, Surajit Chaudhuri, Adam Bosworth, Andrew Layman, Don Reichart, Murali Venkatrao, Frank Pellow, Hamid Pirahesh: Data Cube: A Relational Aggregation Operator Generalizing Group-by, Cross-Tab,and Sub Totals, Data Mining and Knowledge Discovery 1(1): 29–53 (1997)
Klug, A.: Equivalence of Relational Algebra and Relational Calculus Query Languages Having Aggregate Functions, J. ACM, Vol. 29,No. 3, pp. 699–717 (1982)
Miura, T., Matsumoto, W.: Managing Meta Objects for Design of Warehouse Data, proc.DaWaK (1999), pp. 33–40
Özsoyoglu, G., Özsoyoglu, Z.M. and Matos, V.: Extending Relational Algebra and Relational Calculus with Set-Valued Attributes and Aggregate Functions, ACM TODS vol 12, No. 4, pp. 566–592 (1987)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2002 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Kashikawa, S., Ogura, S., Shioya, I., Miura, T. (2002). Aggregates as Meta Functions. In: Hacid, MS., RaÅ›, Z.W., Zighed, D.A., Kodratoff, Y. (eds) Foundations of Intelligent Systems. ISMIS 2002. Lecture Notes in Computer Science(), vol 2366. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-48050-1_24
Download citation
DOI: https://doi.org/10.1007/3-540-48050-1_24
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-43785-7
Online ISBN: 978-3-540-48050-1
eBook Packages: Springer Book Archive