What are the different types of storage modes?

53
8647

There are three standard storage modes in OLAP applications.

1) MOLAP

2) ROLAP

3) HOLAP

When ever the cube process is going on then it process leaf level data(detailed data) and creates Aggregations based on the Aggregation design defined in the cube. Now lets see about these in detail –

MOLAP – Stores Detailed data and Aggregations in the form of binary files and these are completely separate from relational database.

ROLAP – Stores Detailed data and Aggregations in the relational database.

HOLAP – Stores Detailed data in relational database and Aggregations in the form of binary files.

PFB the difference between these three –

Storage Mode Storage Location for Detail Data Storage Location for Summary/ Aggregations Storage space requirement Query Response Time Processing Time Latency
MOLAP Multidimensional Format Multidimensional Format MediumBecause detail data is stored in compressed format. Fast Fast High
HOLAP Relational Database Multidimensional Format Small Fast for aggregated data and Slow when trying to read Leaf level data. Fast Medium
ROLAP Relational Database Relational Database Large Slow Slow Low

There is one main difference between ROLAP and MOLAP i.e ROLAP supports REAL TIME Data where as MOLAP doesn’t. Real time in the sense when a record is inserted into fact table then it should be immediately available for analysis. It doesnot happen if you use MOLAP storage mode and to pull newly added record in MOLAP storage mode we need to process cube. In ROLAP as the data is storing in relational databases, when ever a record is inserted into table it will be available for analysis.

Regards,

Roopesh Babu V

53 COMMENTS

  1. You said it nicely.!
    [url=https://hireawriterforanessay.com/]do my essay for money[/url] hire an essay writer [url=https://theessayswriters.com/]write my essay paper[/url] make my essay

  2. Regards! Quite a lot of posts!
    [url=https://theessayswriters.com/]can you do my essay[/url] write my essay for me free [url=https://bestcheapessaywriters.com/]write my essay for me cheap[/url] how do i conclude my essay

  3. Incredible a lot of valuable facts!
    [url=https://helpwithdissertationwriting.com/]writing a dissertation[/url] a dissertation [url=https://dissertationwritingtops.com/]doctoral dissertation proposal[/url] professional dissertation help

  4. Beneficial info. With thanks!
    [url=https://essaytyperhelp.com/]help with an essay[/url] college admissions essay help [url=https://helptowriteanessay.com/]help with essay papers[/url] essay write help

  5. You made your point.
    [url=https://hireawriterforanessay.com/]make my essaywrite my essay[/url] can someone write my essay for cheap [url=https://theessayswriters.com/]writes essays for you[/url] do i underline the title of my essay

  6. You said it adequately.!
    [url=https://service-essay.com/]my paper writing service reviews[/url] analytical essay paper writing service [url=https://custompaperwritingservices.com/]term paper writing services reviews[/url] buy a paper for college

  7. Amazing lots of great tips.
    [url=https://writinganessaycollegeservice.com/]best essay service[/url] saga will writing service [url=https://essayservicehelp.com/]best essays writing service[/url] fake essay writing service

  8. Regards. Plenty of information.
    [url=https://payforanessaysonline.com/]pay for writing essay[/url] order an essay [url=https://buycheapessaysonline.com/]order essay[/url] buy custom essays online

  9. Kudos. I enjoy this!
    [url=https://researchproposalforphd.com/]doctorate proposal[/url] buy college term papers [url=https://writingresearchtermpaperservice.com/]the proposal online[/url] proposal helper

  10. You said it nicely.!
    [url=https://researchproposalforphd.com/]write my research paper for me[/url] proposal argument paper [url=https://writingresearchtermpaperservice.com/]reserach proposal[/url] help research paper

  11. “선입금&예약금없는 후불제
    시그니처출장마사지 시그니처출장안마 입니다.
    자택 오피스텔 모텔 호텔 등 에서 이용가능하며
    경기 인천 서울 전지역 30분 이내
    방문 가능합니다” 출장안마

  12. “이제 나가지말구 간편하게 계신곳에서 편하게 이용하세요 ~
    서울 전지역 모텔 . 호텔 . 오피스텔 . 원룸 등에서
    전화한통만 주시면 ok ~ !!
    직접 방문해서 케어 해드립니다 ” 출장안마

  13. Slot88bet juga menyediakan berbagai jenis permainan dari provider-provider terpopuler. Dengan beragamnya pilihan permainan slot88, tidak akan membuat member bosan atau jenuh dalam bermain. Kami memastikan setiap member akan mendapatkan pengalaman bermain yang seru dan menyenangkan. Karena setiap permainan di situs judi slot88 online Indonesia ini memiliki ciri khas dan keunikan masing-masing, serta jackpot slot terbesar yang menggiurkan. Namun situs SLOT88BET online juga hadir membawa pelayanan profesional yang siap memanjakan setiap member 24 jam nonstop. Bersama situs slot online terbaik, member akan selalu terlayani 24 jam setiap hari. Untuk mewujudkan hal tersebut, Kami juga sudah menyediakan layanan customer service profesional. Jadi, kapanpun member butuh bantuan, bisa langsung ditangani dengan cepat. Anda bisa akses melalui saluran live chat, sms, whatsapp, line, telepon 24 jam nonstop setiap harinya. Transaksi juga selalu terproses dengan lancar dan cepat, semua dalam hitungan menit saja. Jadi, berjudi bersama situs slot 88 dijamin mampu berikan Anda kepuasan optimal!
    http://www.xn--vk1bo0k7odj4dwpa.kr/bbs/board.php?bo_table=free&wr_id=789017
    Zynga Poker Hack Apk With our Mod you can get unlimited chips and gold. Thus open all the unlock features with this version. No need to spend your real money. Just download its mod version from here and enjoy it. Join the legendary poker community and be a poker star. And also, newbies can get benefits from the company of senior and experienced players. You can polish your skills in the free poker practice mode and prepare for a great match. Zynga Poker is a popular online poker game that offers a variety of features and game modes to its players. Here are some of the key features of the game: A: Yes, of course. The Play Store installs downloads from Google’s servers, with the exception of downloading and installing your service (page loading), and page loading from websites like Apkbeas is the same.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

9 + 1 =