Skip to main content

Aggregates as Meta Functions

  • 646 Accesses

Part of the Lecture Notes in Computer Science book series (LNAI,volume 2366)

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.

Keywords

  • Data Warehousing Foundation
  • Metadata Management

This is a preview of subscription content, access via your institution.

Buying options

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

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Cabibbo, L. and Torlone, R.: A Framework for the Investigation of Aggregate Functions in Database Queries, proc. ICDT (1999),pp 383–397

    Google Scholar 

  2. S. Chaudhuri et al: An Overview of Data Warehousing and OLAP Technology. ACM SIGMOD Record, Vol. 26 No. 1 P. 65–74, March 1997

    CrossRef  MATH  Google Scholar 

  3. Fegaras, L. and Maier, D.: Towards An Effective Calculus for Object Query Languages, proc.SIGMOD (1995)

    Google Scholar 

  4. Gray, P.M.D.: LOGIC, ALGEBRA AND DATABASES, Sangyou ToSho (1989)

    Google Scholar 

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

    CrossRef  Google Scholar 

  6. Klug, A.: Equivalence of Relational Algebra and Relational Calculus Query Languages Having Aggregate Functions, J. ACM, Vol. 29,No. 3, pp. 699–717 (1982)

    CrossRef  MATH  MathSciNet  Google Scholar 

  7. Miura, T., Matsumoto, W.: Managing Meta Objects for Design of Warehouse Data, proc.DaWaK (1999), pp. 33–40

    Google Scholar 

  8. Ö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)

    CrossRef  Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints 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

Publish with us

Policies and ethics