ANALYTICAL PROCESSING IN DATA WAREHOUSE:A REVIEW

Article Sidebar

PDF
Published: Jul 16, 2018
DOI: https://doi.org/10.26483/ijarcs.v9i0.6136
Keywords:
OLAP model, ROLAP, MOLAP, HOLAP.

Main Article Content

Swarnima Bhatnagar
Prachi Singh
Saurabh Yadav
Roshan Jahan

Abstract

Analytical processing is the core of data warehouse. It is very helpful to analyse and predict results. There are various tools available for analytical processing. OLAP is one of the most powerful tools for analytics. It allows users to analyze database information from multiple database systems at one time. OLAP stores data in multidimensional database. This paper focused on operations of OLAP and its models.

 

 

Downloads

Download data is not yet available.

Article Details

Issue
2018: Volume 9 Special Issue No. 2, April 2018
Section
Articles

COPYRIGHT

Submission of a manuscript implies: that the work described has not been published before, that it is not under consideration for publication elsewhere; that if and when the manuscript is accepted for publication, the authors agree to automatic transfer of the copyright to the publisher.

Authors who publish with this journal agree to the following terms:

  • Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
  • Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
  • Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work
  • The journal allows the author(s) to retain publishing rights without restrictions.
  • The journal allows the author(s) to hold the copyright without restrictions.

References

W. H. Inmon “Building the Data Warehouse†Wiley, 2005.

Ralph Kimball, Margy Ross “The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling" Wiley, 2002.

William H. Inmon, Richard D. Hackathorn "Using the data warehouse" Publisher Wiley, 1994.

Paulraj Ponniah "Data Warehousing Fundamentals: A Comprehensive Guide for IT Professionals" Wiley, 2004.

Paulraj Ponniah "Data Warehousing Fundamentals" John Wiley & Sons,2006.

Amitesh K. Sinha "Data Warehousing Connectivity†Prompt Publications, 2001

Boon Keong “Design and implementation of data warehouse with data model using survey-based services data†Innovative Computing Technology (INTECH), Fourth International Conference on 13-15 Aug. 2014.

Nawfal El Moukhi, Morocco Ikram El Azami, Kenitra, Morocco Aziz Mouloudi “Data warehouse state of the art and future challenges†Cloud Technologies and Applications (CloudTech), International Conference on 2-4 June 2015.