{"id":71,"date":"2016-10-03T06:39:00","date_gmt":"2016-10-03T06:39:00","guid":{"rendered":"https:\/\/blogs.scu.edu\/erpsystems\/?p=71"},"modified":"2016-10-03T06:50:11","modified_gmt":"2016-10-03T06:50:11","slug":"oltp-olap-a-small-clarification","status":"publish","type":"post","link":"https:\/\/blogs.scu.edu\/erpsystems\/2016\/10\/03\/oltp-olap-a-small-clarification\/","title":{"rendered":"OLTP &amp; OLAP: A small clarification"},"content":{"rendered":"<p>This post is about curious thoughts that I had during one of my internship when I had to implement an Oracle\u2019s Hyperion Reporting software. I understood by that time that I was using an OLAP environment.<\/p>\n<p>Wait, what is OLAP again? The concept surfaced \u00a0again\u00a0the last week.\u00a0During the previous sessions, we explored the accounting transaction concept within an ERP system. We highlighted the 3 different types of data:<\/p>\n<p>1. Master data<br \/>\n2. Organizational data<br \/>\n3. Transaction data<\/p>\n<p>The ERP generates a huge volume of these data sets that need to be stored in two different ways, depending on the freshness: \u201cTransaction\u201d data for the current processes and \u201chistorical\u201d data for past processes.<\/p>\n<ul>\n<li>OnLine Transactional Processing (OLTP) to process the current data needed to fulfill a current business process.<\/li>\n<li>OnLine Analytic Processing environment (OLAP) to analyze a huge amount of historical transactions.<\/li>\n<\/ul>\n<p>OLAP environments needs a lot of processing power to aggregate all the historical data in order to provide the analysts with different \u201cViews\u201d of the overall data. Data are arranged by dimensions and can be modeled by a \u201cCube\u201d.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-113 aligncenter\" src=\"https:\/\/blogs.scu.edu\/erpsystems\/files\/2016\/10\/What-is-a-Cube-1-300x226.png\" alt=\"what-is-a-cube\" width=\"489\" height=\"369\" \/><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This post is about curious thoughts that I had during one of my internship when I had to implement an Oracle\u2019s Hyperion Reporting software. I understood by that time that I was using an OLAP environment. Wait, what is OLAP again? The concept surfaced \u00a0again\u00a0the last week.\u00a0During the previous sessions, we explored the accounting transaction &hellip; <a href=\"https:\/\/blogs.scu.edu\/erpsystems\/2016\/10\/03\/oltp-olap-a-small-clarification\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">OLTP &amp; OLAP: A small clarification<\/span><\/a><\/p>\n","protected":false},"author":1712,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"image","meta":{"qubely_global_settings":"","qubely_interactions":"","kk_blocks_editor_width":"","_kiokenblocks_attr":"","_kiokenblocks_dimensions":"","footnotes":""},"categories":[1],"tags":[9,3,11,10],"class_list":["post-71","post","type-post","status-publish","format-image","hentry","category-uncategorized","tag-data","tag-erp","tag-olap","tag-oltp","post_format-post-format-image"],"gutentor_comment":2,"qubely_featured_image_url":null,"qubely_author":{"display_name":"chedly","author_link":"https:\/\/blogs.scu.edu\/erpsystems\/author\/chedly\/"},"qubely_comment":2,"qubely_category":"<a href=\"https:\/\/blogs.scu.edu\/erpsystems\/category\/uncategorized\/\" rel=\"category tag\">Uncategorized<\/a>","qubely_excerpt":"This post is about curious thoughts that I had during one of my internship when I had to implement an Oracle\u2019s Hyperion Reporting software. I understood by that time that I was using an OLAP environment. Wait, what is OLAP again? The concept surfaced \u00a0again\u00a0the last week.\u00a0During the previous sessions, we explored the accounting transaction&hellip;","post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/blogs.scu.edu\/erpsystems\/wp-json\/wp\/v2\/posts\/71","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.scu.edu\/erpsystems\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.scu.edu\/erpsystems\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.scu.edu\/erpsystems\/wp-json\/wp\/v2\/users\/1712"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.scu.edu\/erpsystems\/wp-json\/wp\/v2\/comments?post=71"}],"version-history":[{"count":8,"href":"https:\/\/blogs.scu.edu\/erpsystems\/wp-json\/wp\/v2\/posts\/71\/revisions"}],"predecessor-version":[{"id":118,"href":"https:\/\/blogs.scu.edu\/erpsystems\/wp-json\/wp\/v2\/posts\/71\/revisions\/118"}],"wp:attachment":[{"href":"https:\/\/blogs.scu.edu\/erpsystems\/wp-json\/wp\/v2\/media?parent=71"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.scu.edu\/erpsystems\/wp-json\/wp\/v2\/categories?post=71"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.scu.edu\/erpsystems\/wp-json\/wp\/v2\/tags?post=71"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}