Datacubes — Do we mean ‘cubes’?
medium.com/@nayanika2017/datacubes-do-we-mean-cubes-b6c584fc2cb0
1 Users
0 Comments
15 Highlights
0 Notes
Top Highlights
Contrary to what the notion is, a data cube (and here we are referring to an OLAP cube) is not necessarily a strict mathematical definition of a cube as all its sides are not always equal
When the number of dimensions of the dataset are more than 3, the datacubes are also referred to as hypercubes.
The OLAP data is stored in a data warehouse having certain specific methods of design such as star schema and snowflake schema
These two designs can handle large, multidimensional data extremely efficiently which is why they are used in relational data warehouses.
The terms ‘star’ and ‘snowflake’ refer their patterns.
star schema is simpler and has a high level of data redundancy but its cube processing ability is faster
on the other hand, a snowflake schema is an extension of the star schema and is much more complex which is why its processing speed is slower, but it has a low level of data redundancy.
third type of schema which is known as the Galaxy schema or Fact Constellation schema.
plus points of a datacube are mainly “multidimensionality” and “facilitation of easy analysis”.
If compared to a normal OLTP database, it has benefits such as “speed” and “clean, well-structured views”.
drawbacks of OLAP cubes include low computational capability, lack of user-friendliness, slow reaction to analytical business demands, abstraction of the cubes, the requirement of a huge amount of pre-modeling of the analytical data.
Moreover, with the advent of IoT where a lot of real-time data goes into Data Lakes instead of Data warehouses, which is why OLAP cubes are getting replaced these days as more and more people find it easier to access data from the Data Lakes.
In spite of a lot of drawbacks, hypercubes are here to stay because the OLAP technologies are only getting morphed, not eradicated - to other forms such as Cloud Data Warehouses (Snowflake, Google BigQuery, Amazon Redshift), Data Virtualizations(Cisco Data Virtualisation, Informatica Data Virtualization, IBM Big SQL) and Serviced Cloud and Analytics(Looker and Sisense).
With the current and future requirements of the IT industry, OLAP datacubes are revolutionized to be the right technology which can meet the demands of various business houses dealing with and analyzing a magnanimous amount of multidimensional datasets.
the OLAP (Online Analytical Processing) cubes are used to define a multidimensional dataset
Ready to highlight and find good content?
Glasp is a social web highlighter that people can highlight and organize quotes and thoughts from the web, and access other like-minded people’s learning.