Skip to main content
SpringerLink
Log in

Comprehensive Survey of OLAP Models

  • Conference paper
  • First Online:
Harmony Search and Nature Inspired Optimization Algorithms

Part of the book series: Advances in Intelligent Systems and Computing ((AISC,volume 741))

  • 1765 Accesses

Abstract

On-Line Analytical Processing (OLAP) is an expertise that offers data discovery, including capabilities of complex analytical calculations, infinite report viewing and predictive “what if” scenario (forecast) planning. OLAP finds its applications in various Business Intelligence (BI) applications. OLAP’s life blood is multidimensional data. OLAP differs from traditional databases in a way data is stored and conceptualized. As OLAP tools are intended to perform enquiry, these systems deliver fast answers for queries that aggregate large amount of detail data to find general trends in Data Warehouse (DW). A number of OLAP models are available, that show various contradictory trends in Data Warehouse. This paper summarizes the existing OLAP models utilized for extensive list of applications and further compares these models based on different parameters.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 169.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 219.99
Price excludes VAT (USA)
  • 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

Institutional subscriptions

References

  1. Acharya, S., Prasad, R.N.: Fundamentals of Business Analytics (2016)

    Google Scholar 

  2. Dhanasree, K., Shobabindu, C.: A survey on OLAP (2017)

    Google Scholar 

  3. Razat, M.S., Nayak, A.K.: A study on designing a Layered STAR Schema for data mining optimization (2015)

    Google Scholar 

  4. Levene, M., Loizou, G.: Why is the snowflake schema a good Data Warehouse design? (2003)

    Google Scholar 

  5. Lee, H., Park, S., Yoo, J.-H.: A data cube model for surveillance video indexing and retrieval (2013)

    Google Scholar 

  6. Boutkhoum, O., Hanine, M., Tikniouine, A., Agouti, T.: Integration approach of multicriteria scrutiny to OLAP systems: multidimensional model (2013)

    Google Scholar 

  7. Han, M., Ju, C.: Research and application on OLAP-based farm products examination model (2008)

    Google Scholar 

  8. Korobko, A., Nozhenkova, L.: Ordered multidimensional model construction of relational source for integral OLAP-modeling (2016)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Computer Science and Engineering, Thapar Institute of Engineering and Technology (Deemed to be University), Patiala, India

    Harkiran Kaur & Gursimran Kaur

Authors
  1. Harkiran Kaur
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Gursimran Kaur
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Harkiran Kaur .

Editor information

Editors and Affiliations

  1. School of Engineering and Technology, BML Munjal University, Gurgaon, Haryana, India

    Neha Yadav

  2. Department of Sciences and Humanities, National Institute of Technology, Srinagar, Uttarakhand, India

    Anupam Yadav

  3. Department of Mathematics, South Asian University, New Delhi, India

    Jagdish Chand Bansal

  4. Department of Mathematics, Indian Institute of Technology Roorkee, Roorkee, Uttarakhand, India

    Kusum Deep

  5. School of Civil, Environmental and Architectural Engineering, Korea University, Seoul, Korea (Republic of)

    Joong Hoon Kim

Rights and permissions

Reprints and permissions

Copyright information

© 2019 Springer Nature Singapore Pte Ltd.

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Kaur, H., Kaur, G. (2019). Comprehensive Survey of OLAP Models. In: Yadav, N., Yadav, A., Bansal, J., Deep, K., Kim, J. (eds) Harmony Search and Nature Inspired Optimization Algorithms. Advances in Intelligent Systems and Computing, vol 741. Springer, Singapore. https://doi.org/10.1007/978-981-13-0761-4_40

Download citation

Publish with us

Policies and ethics

Search

Navigation