Data warehousing - What is data cube technology used for?

What is data cube technology used for?

Data cube is a multi-dimensional structure. Data cube is a data abstraction to view aggregated data from a number of perspectives. The dimensions are aggregated as the ‘measure’ attribute, as the remaining dimensions are known as the ‘feature’ attributes.

Data is viewed on a cube in a multidimensional manner. The aggregated and summarized facts of variables or attributes can be viewed. This is the requirement where OLAP plays a role.

What is data cube technology used for?

Data cubes are commonly used for easy interpretation of data. It is used to represent data along with dimensions as some measures of business needs. Each dimension of the cube represents some attribute of the database, e.g Sales per day, month or year.
What is Data Scheme? - Data warehousing
Data Scheme is a diagrammatic representation that illustrates data structures and data relationships to each other in the relational database within the data warehouse.....
What is Bit Mapped Index? - Data warehousing
Bitmap indexes make use of bit arrays (bitmaps) to answer queries by performing bitwise logical operations......
What is Bi-directional Extract? - Data warehousing
In hierarchical, networked or relational databases, the data can be extracted, cleansed and transferred in two directions. The ability of a system to do this is refered to as bidirectional extracts.....
Post your comment