{"id":236,"date":"2015-12-08T09:43:34","date_gmt":"2015-12-08T07:43:34","guid":{"rendered":"http:\/\/whiteducksoftware.com\/?p=236"},"modified":"2021-10-01T09:12:31","modified_gmt":"2021-10-01T07:12:31","slug":"on-the-past-present-and-future-of-olap","status":"publish","type":"post","link":"https:\/\/whiteduck.de\/en\/on-the-past-present-and-future-of-olap\/","title":{"rendered":"On the Past, Present and Future of OLAP"},"content":{"rendered":"<h2>On the Past, Present and Future of OLAP<\/h2>\n<p style=\"text-align: justify;\">Recent advances in column oriented databases and the proliferation of self-service BI makes a lot of us wonder: is OLAP\/Cube technology still relevant? While the obvious answer is definitely yes, it is helpful to know the origins and evolution of these technologies, in order to predict their future.<\/p>\n<p style=\"text-align: justify;\">These technologies were invented during the 1990&#8217;s due to mainly two reasons:<\/p>\n<ul style=\"text-align: justify;\">\n<li>It was (and still is) painfully complex to write SQL queries involving multiple dimensions\/hierarchies, using aggregation functions at different granularities. Pivoting or dicing requires a not so intuitive rewriting of such queries<\/li>\n<li>Such queries were very slow, since traditional relational databases were at that point designed and optimized for transactions, not for analysis<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Cube technology has successfully coped with these issues. It has provided a centralized dimensional model with hierarchies and measures, which both business and technical users can understand. Query languages like MDX are founded on a dimensional model. Performance was tackled by means of intelligent pre-aggregation: proprietary structures in MOLAP, caching ROLAP. What Cube technologies also incurred though, was the creation of a parallel universe, with redundancy and ETL process between them.<\/p>\n<p style=\"text-align: justify;\">So almost after 20 years, what has changed and what not?<\/p>\n<p style=\"text-align: justify;\">Database systems have become so fast that the performance argument may not be that relevant anymore\u2026 In an ideal world, there would be no need to store data twice, once for transactional and once for analytical purposes.\u00a0 Nevertheless, this is still rather a vision than a\u00a0reality. We are going to get there but not anytime soon.<\/p>\n<p style=\"text-align: justify;\"><span class=\"TextRun SCX265857451\" xml:lang=\"EN-US\"><span class=\"NormalTextRun SCX265857451\">On the other hand, the need for a dimensional model is still there, cause this has been a very successful logical model. The world of analysis remains dimensional, regardless of the technical innovations.<\/span><\/span> So no matter how we call it, the world of analysis remains dimensional.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>On the Past, Present and Future of OLAP Recent advances in column oriented databases and the proliferation of self-service BI makes a lot of us wonder: is OLAP\/Cube technology still relevant? While the obvious answer is definitely yes, it is helpful to know the origins and evolution of these technologies, in order to predict their <a href=\"https:\/\/whiteduck.de\/en\/on-the-past-present-and-future-of-olap\/\"> <\/p>\n<div style=\"color:#ff9900\">[&#8230;]<\/div>\n<p><\/a><\/p>\n","protected":false},"author":4,"featured_media":2824,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_tribe_events_control_status":"","_tribe_events_control_status_canceled_reason":"","_tribe_events_control_status_postponed_reason":"","_tribe_events_control_online":"","_tribe_events_control_online_url":"","footnotes":""},"categories":[439],"tags":[72,73,74,75,76,77,78,79],"class_list":["post-236","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-analytics-2","tag-cube","tag-etl","tag-mdx","tag-molap","tag-olap","tag-roalp","tag-self-service-bi","tag-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>On the Past, Present and Future of OLAP - white duck<\/title>\n<meta name=\"description\" content=\"Find out if the OLAP\/Cube technology is still relevant and why it is helpful to know the origins and evolution of these technologies too.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/whiteduck.de\/en\/on-the-past-present-and-future-of-olap\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"On the Past, Present and Future of OLAP - white duck\" \/>\n<meta property=\"og:description\" content=\"Find out if the OLAP\/Cube technology is still relevant and why it is helpful to know the origins and evolution of these technologies too.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/whiteduck.de\/en\/on-the-past-present-and-future-of-olap\/\" \/>\n<meta property=\"og:site_name\" content=\"white duck\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/whiteduckgmbh\" \/>\n<meta property=\"article:published_time\" content=\"2015-12-08T07:43:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-01T07:12:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/whiteduck.de\/wp-content\/uploads\/magic-cube-378543_1920.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1462\" \/>\n\t<meta property=\"og:image:height\" content=\"975\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Dr. Ilias Michalarias\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@whiteduck_gmbh\" \/>\n<meta name=\"twitter:site\" content=\"@whiteduck_gmbh\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr. Ilias Michalarias\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/on-the-past-present-and-future-of-olap\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/on-the-past-present-and-future-of-olap\\\/\"},\"author\":{\"name\":\"Dr. Ilias Michalarias\",\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/#\\\/schema\\\/person\\\/8ab1d892787c0fa9732dc581e679963a\"},\"headline\":\"On the Past, Present and Future of OLAP\",\"datePublished\":\"2015-12-08T07:43:34+00:00\",\"dateModified\":\"2021-10-01T07:12:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/on-the-past-present-and-future-of-olap\\\/\"},\"wordCount\":315,\"commentCount\":93,\"image\":{\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/on-the-past-present-and-future-of-olap\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/whiteduck.de\\\/wp-content\\\/uploads\\\/magic-cube-378543_1920.jpg\",\"keywords\":[\"Cube\",\"ETL\",\"MDX\",\"MOLAP\",\"OLAP\",\"ROALP\",\"Self Service BI\",\"SQL\"],\"articleSection\":[\"Data Analytics\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/whiteduck.de\\\/en\\\/on-the-past-present-and-future-of-olap\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/on-the-past-present-and-future-of-olap\\\/\",\"url\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/on-the-past-present-and-future-of-olap\\\/\",\"name\":\"On the Past, Present and Future of OLAP - white duck\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/on-the-past-present-and-future-of-olap\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/on-the-past-present-and-future-of-olap\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/whiteduck.de\\\/wp-content\\\/uploads\\\/magic-cube-378543_1920.jpg\",\"datePublished\":\"2015-12-08T07:43:34+00:00\",\"dateModified\":\"2021-10-01T07:12:31+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/#\\\/schema\\\/person\\\/8ab1d892787c0fa9732dc581e679963a\"},\"description\":\"Find out if the OLAP\\\/Cube technology is still relevant and why it is helpful to know the origins and evolution of these technologies too.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/on-the-past-present-and-future-of-olap\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/whiteduck.de\\\/en\\\/on-the-past-present-and-future-of-olap\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/on-the-past-present-and-future-of-olap\\\/#primaryimage\",\"url\":\"https:\\\/\\\/whiteduck.de\\\/wp-content\\\/uploads\\\/magic-cube-378543_1920.jpg\",\"contentUrl\":\"https:\\\/\\\/whiteduck.de\\\/wp-content\\\/uploads\\\/magic-cube-378543_1920.jpg\",\"width\":1462,\"height\":975},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/on-the-past-present-and-future-of-olap\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"On the Past, Present and Future of OLAP\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/\",\"name\":\"white duck\",\"description\":\"Your Partner for Microsoft Azure &amp; AI\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/#\\\/schema\\\/person\\\/8ab1d892787c0fa9732dc581e679963a\",\"name\":\"Dr. Ilias Michalarias\",\"url\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/author\\\/dr-ilias-michalarias\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"On the Past, Present and Future of OLAP - white duck","description":"Find out if the OLAP\/Cube technology is still relevant and why it is helpful to know the origins and evolution of these technologies too.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/whiteduck.de\/en\/on-the-past-present-and-future-of-olap\/","og_locale":"en_US","og_type":"article","og_title":"On the Past, Present and Future of OLAP - white duck","og_description":"Find out if the OLAP\/Cube technology is still relevant and why it is helpful to know the origins and evolution of these technologies too.","og_url":"https:\/\/whiteduck.de\/en\/on-the-past-present-and-future-of-olap\/","og_site_name":"white duck","article_publisher":"https:\/\/www.facebook.com\/whiteduckgmbh","article_published_time":"2015-12-08T07:43:34+00:00","article_modified_time":"2021-10-01T07:12:31+00:00","og_image":[{"width":1462,"height":975,"url":"https:\/\/whiteduck.de\/wp-content\/uploads\/magic-cube-378543_1920.jpg","type":"image\/jpeg"}],"author":"Dr. Ilias Michalarias","twitter_card":"summary_large_image","twitter_creator":"@whiteduck_gmbh","twitter_site":"@whiteduck_gmbh","twitter_misc":{"Written by":"Dr. Ilias Michalarias","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/whiteduck.de\/en\/on-the-past-present-and-future-of-olap\/#article","isPartOf":{"@id":"https:\/\/whiteduck.de\/en\/on-the-past-present-and-future-of-olap\/"},"author":{"name":"Dr. Ilias Michalarias","@id":"https:\/\/whiteduck.de\/en\/#\/schema\/person\/8ab1d892787c0fa9732dc581e679963a"},"headline":"On the Past, Present and Future of OLAP","datePublished":"2015-12-08T07:43:34+00:00","dateModified":"2021-10-01T07:12:31+00:00","mainEntityOfPage":{"@id":"https:\/\/whiteduck.de\/en\/on-the-past-present-and-future-of-olap\/"},"wordCount":315,"commentCount":93,"image":{"@id":"https:\/\/whiteduck.de\/en\/on-the-past-present-and-future-of-olap\/#primaryimage"},"thumbnailUrl":"https:\/\/whiteduck.de\/wp-content\/uploads\/magic-cube-378543_1920.jpg","keywords":["Cube","ETL","MDX","MOLAP","OLAP","ROALP","Self Service BI","SQL"],"articleSection":["Data Analytics"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/whiteduck.de\/en\/on-the-past-present-and-future-of-olap\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/whiteduck.de\/en\/on-the-past-present-and-future-of-olap\/","url":"https:\/\/whiteduck.de\/en\/on-the-past-present-and-future-of-olap\/","name":"On the Past, Present and Future of OLAP - white duck","isPartOf":{"@id":"https:\/\/whiteduck.de\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/whiteduck.de\/en\/on-the-past-present-and-future-of-olap\/#primaryimage"},"image":{"@id":"https:\/\/whiteduck.de\/en\/on-the-past-present-and-future-of-olap\/#primaryimage"},"thumbnailUrl":"https:\/\/whiteduck.de\/wp-content\/uploads\/magic-cube-378543_1920.jpg","datePublished":"2015-12-08T07:43:34+00:00","dateModified":"2021-10-01T07:12:31+00:00","author":{"@id":"https:\/\/whiteduck.de\/en\/#\/schema\/person\/8ab1d892787c0fa9732dc581e679963a"},"description":"Find out if the OLAP\/Cube technology is still relevant and why it is helpful to know the origins and evolution of these technologies too.","breadcrumb":{"@id":"https:\/\/whiteduck.de\/en\/on-the-past-present-and-future-of-olap\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/whiteduck.de\/en\/on-the-past-present-and-future-of-olap\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/whiteduck.de\/en\/on-the-past-present-and-future-of-olap\/#primaryimage","url":"https:\/\/whiteduck.de\/wp-content\/uploads\/magic-cube-378543_1920.jpg","contentUrl":"https:\/\/whiteduck.de\/wp-content\/uploads\/magic-cube-378543_1920.jpg","width":1462,"height":975},{"@type":"BreadcrumbList","@id":"https:\/\/whiteduck.de\/en\/on-the-past-present-and-future-of-olap\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/whiteduck.de\/en\/"},{"@type":"ListItem","position":2,"name":"On the Past, Present and Future of OLAP"}]},{"@type":"WebSite","@id":"https:\/\/whiteduck.de\/en\/#website","url":"https:\/\/whiteduck.de\/en\/","name":"white duck","description":"Your Partner for Microsoft Azure &amp; AI","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/whiteduck.de\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/whiteduck.de\/en\/#\/schema\/person\/8ab1d892787c0fa9732dc581e679963a","name":"Dr. Ilias Michalarias","url":"https:\/\/whiteduck.de\/en\/author\/dr-ilias-michalarias\/"}]}},"_links":{"self":[{"href":"https:\/\/whiteduck.de\/en\/wp-json\/wp\/v2\/posts\/236","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/whiteduck.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/whiteduck.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/whiteduck.de\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/whiteduck.de\/en\/wp-json\/wp\/v2\/comments?post=236"}],"version-history":[{"count":0,"href":"https:\/\/whiteduck.de\/en\/wp-json\/wp\/v2\/posts\/236\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/whiteduck.de\/en\/wp-json\/wp\/v2\/media\/2824"}],"wp:attachment":[{"href":"https:\/\/whiteduck.de\/en\/wp-json\/wp\/v2\/media?parent=236"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/whiteduck.de\/en\/wp-json\/wp\/v2\/categories?post=236"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/whiteduck.de\/en\/wp-json\/wp\/v2\/tags?post=236"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}