OLAP Query Optimizer: SELECTION Operation

Authors

  • Kothari Badal K.  Department of Computer Science and Engineering,. Mewar University, Rajasthan, India
  • Harish Nagar  Department of Computer Science and Engineering,. Mewar University, Rajasthan, India
  • Dr. Ashok R. Patel  Department of Computer Science and Engineering,. Mewar University, Rajasthan, India

Keywords:

OLAP Algebra, OLAP Query Optimizer, OLAP Query, OLAP selection Operator

Abstract

A query processor (query compilation and execution) is an essential component in any database management system (DBMS). Specifically, query compilation transforms user queries into a sequence of database operations, while query execution executes those given operations. Retrieve Information from the OLAP Storage is very important task, but because of large amount of OLAP data it’s taking tremendous time for the execution of the query. In this paper, we shall cover algorithm for the SELECTION operator (OLAP Algebraic Operator), which is used to access the data of the OLAP storage.

References

  1. Oracle essbase. http://www.oracle.com/us/solutions /ent-performancebi/business intelligence/ essbase/ index.html.
  2. T. Eavis and R. Sayeed. High performance analytics with the r3-cache. Data Warehousing and Knowledge Discovery (DaWak), 2009.
  3. D. Kossmann J.-P. Dittrich and A. Kreutz. Bridging the gap between olap and sql. In International conference on Very Large Data Bases (VLDB), pages 1031–1042, 2005.
  4. Thomas P. Nadeau and Toby J. Teorey. Olap query optimization in the presence of materialized views. HICCS, 2003.
  5. O. Romero and A. Abello. On the need of a reference algebra for olap. In International conference on Data warehousing and Knowledge Discovery (DaWak),pages 99–110, 2007.
  6. T. Sellis, N. Roussopoulos, and C. Faloutsos. The r+-tree - a dynamic index for multidimensional objects. VLDB, pages 507–518, 1987.
  7. Sas olap server. http://www.sas.com/technologies/dw/storage/mddb/index.html.
  8. Olap4j. http://www.olap4j.org
  9. Olapdml. http://oracle.com

International Journal of Scientific Research in Science, Engineering and Technology

Downloads

Published

2015-01-25

Issue

Volume 2, Issue 1, January-February-2016

Section

Research Articles

License

Copyright (c) IJSRSET

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

How to Cite

[1]
Kothari Badal K., Harish Nagar, Dr. Ashok R. Patel, " OLAP Query Optimizer: SELECTION Operation, International Journal of Scientific Research in Science, Engineering and Technology(IJSRSET), Print ISSN : 2395-1990, Online ISSN : 2394-4099, Volume 2, Issue 1, pp.134-139, January-February-2016.