User Tools

Site Tools


concepts:cube

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
concepts:cube [2014/10/19 13:38]
127.0.0.1 external edit
concepts:cube [2020/08/20 13:27] (current)
Line 32: Line 32:
 Which shops increased its sales within the past 3 years? Which shops increased its sales within the past 3 years?
  
-===== Technical Implementation =====+=== Technical Implementation ===
    
 The data will be saved in a multi-dimensional way (MOLAP), a relational approach (ROLAP) or in hybrid-configuration (HOLAP)((see “MOLAP, ROLAP, And HOLAP” 1keydata.com. Web. 28 Dec. 2010 http://www.1keydata.com/datawarehousing/molap-rolap.html)). Traditional OLAP products are also called "multidimensional OLAP" (MOLAP) because they summarize transactions into multidimensional views ahead of time. ((see “OLAP - Computer Dictionary Definition” Computer Language Company Inc. Web. 28 Dec. 2010 http://computer.yourdictionary.com/olap)) The data is organized into a cube structure. The cube can be rotated by the user, which is of help for example for financial summaries. Relational OLAP tools extract data from  [[glossary:r:relational database|relational databases]].((see “OLAP” PCmag.com. Web. 29 Dec. 2010 http://www.pcmag.com/encyclopedia_term/0,2542,t=OLAP&i=48341,00.asp)) ROLAPs are usually using data that has a large number of attributes, which is the reason why the data cannot be easily placed into a cube structure. For example, customer data with numerous descriptive fields are typically ROLAP candidates, rather than financial data. HOLAP (Hybrid Online Analytical Processing) is a combination of ROLAP and MOLAP. HOLAPs store one part of the data in a MOLAP and another part in a ROLAP system. This allows a tradeoff of the advantages of each. The data will be saved in a multi-dimensional way (MOLAP), a relational approach (ROLAP) or in hybrid-configuration (HOLAP)((see “MOLAP, ROLAP, And HOLAP” 1keydata.com. Web. 28 Dec. 2010 http://www.1keydata.com/datawarehousing/molap-rolap.html)). Traditional OLAP products are also called "multidimensional OLAP" (MOLAP) because they summarize transactions into multidimensional views ahead of time. ((see “OLAP - Computer Dictionary Definition” Computer Language Company Inc. Web. 28 Dec. 2010 http://computer.yourdictionary.com/olap)) The data is organized into a cube structure. The cube can be rotated by the user, which is of help for example for financial summaries. Relational OLAP tools extract data from  [[glossary:r:relational database|relational databases]].((see “OLAP” PCmag.com. Web. 29 Dec. 2010 http://www.pcmag.com/encyclopedia_term/0,2542,t=OLAP&i=48341,00.asp)) ROLAPs are usually using data that has a large number of attributes, which is the reason why the data cannot be easily placed into a cube structure. For example, customer data with numerous descriptive fields are typically ROLAP candidates, rather than financial data. HOLAP (Hybrid Online Analytical Processing) is a combination of ROLAP and MOLAP. HOLAPs store one part of the data in a MOLAP and another part in a ROLAP system. This allows a tradeoff of the advantages of each.
  
  
concepts/cube.txt · Last modified: 2020/08/20 13:27 (external edit)