What is cube?


The cube is in the center of multidimensional Analysis.
It can be database or multidimensional database. The cube is consisted of levels, measures, dimensions and hierarchies. It is a method to store data as multidimensional type. The measures are categorized by dimensions. The cube is designed by business logics because it used in OLAP is usually used to analyze the high-level analysis by business users.




 
<http://blogs.technet.com, Insufficient data from Andrew Fryer>

   On-Line Analytical Processing (OLAP) is actually about business, it just sounds like a science project. ​- Hugh McLeod     



*Short explatation for OLAP

OLAP(Online Analytical Processing) is a strategic method to analyze big data by multidimensional analysis. There are two types pf OLAP as below.

1) MOLAP
MOLAP(multidimensional online analytical processing) indexes directly into a multidimensional database. It processes data that is already stored in a multidimensional array in which all possible combinations of data are reflected, each in a cell that can be accessed directly.

2) ROLAP
ROLAP(Relational online analytical processing) performs dynamic multidimensional analysis of data stored in a relational database rather than in a multidimensional database (which is usually considered the OLAP standard). It accesses data which is the one most commonly used in other OLAPs. It can also generate SQL queries to perform calculations when an end-user wishes to do so.

Comments

Post a Comment

Popular posts from this blog

[Introduction of BI MATRIX's Solutions] Integrated BI Solution, MATRIX Suite

Image
Integrated BI Solution, MATRIX Suite MATRIX Suite is a collection of BI MATRIX's flagship solutions. It is a BI suite that integrates various functions such as dashboard, OLAP, simulation, and self-BI into one platform. Scope of application of MATRIX Suite Integrated BI solution MATRIX Suite enables fast information flow, shortened analysis time, and wider scope of business so that users can utilize BI information for their own purpose. "Do you want to know what solutions and features are included in the MATRIX Suite? And how they are used?" ▶ Product Component MATRIX Suite integrates BI MATRIX's flagship products i-MATRIX, i-CANVAS and i-BIG in a single architecture. - i-MATRIX : User-centered BI solution optimized for creating complex structred reports - i-CANVAS : BI Solution optimized for creating beautiful EIS / Dashboard - i-STREAM : Advanced analytics (Statistics, Data min
Keep reading

BI MATRIX donated BI solutions to Kindai(近畿) University(Osaka, Japan)

Image
- Donation Ceremony - [Certificate of Appreciation from Kindai University, Japan] BI MATRIX donated i-MATRIX to Kindai ( 近 畿 ) University in Osaka, Japan on June 30 At an international academic conference, ITAM(International Conference on IT Applications and Management), organized by the Korea Data Strategy Association. i-MATRIX donated to Kindai University will be used for academic research and education for the students of Kindai University. Kindai students will practice their data analysis using i-MATRIX, which is a Web-systematized as the Excel function. [Certificate of donation by BI MATRIX, Korea] BI MATRIX donated solutions due to Various Activities including establishing a branch in Japan, acquiring patents in Japan, owning a Japanese partner, and participating in an IT exhibition in Japan and Product excellence proven in Korea as the No.1 company in BI solution business.
Keep reading

BI MATRIX, an agency contract with Hitachi High-Tech Solutions Corporation in Japan

Image
 (Left)BI MATRIX CEO -Bae Young Geun,  (right) Hitachi High-Tech Solutions General Headquarters -Takashiro Hirabayashi The BI MATRIX signed an agency contract with Hitachi High-Tech Solutions Corporation (JAPAN) at the head office in Tokyo, Japan, on September 10, 2018. Through the signing this contract, Hitachi High-Tech Solutions Corporation, is not only  selling BI MATRIX solutions in Japan, but also committed to creating a 'LONG-TERM CLOSE PARTNERSHIP' with BI MATRIX. ※ Hitachi High-Tech Solutions Corporation Hitachi High-Tech Solutions Corporation (https://www.hitachi-hightech.com/global/about/corporate/group/hsl/ ) an affiliate of Hitachi High-Tech Group in Japan, is a global company that designs/manufactures/sales of instrumentation and control devices and related software development and solution sales.
Keep reading