High Impact Factor : 4.396 icon | Submit Manuscript Online icon |

Comparison between cube techniques

Author(s):

Mr. Nilesh Padariya , Infebeam Pvt. Ltd., Ahmadabad, Gujarat, India; Riddhi Dhandha, Gujarat Technological University, Ahmedabad, Gujarat, India

Keywords:

Data cube, Range cube, Bit cube, Comparison, conclusion

Abstract

Data Cube in the contest of data warehousing and OLAP is core operator. The data cube was proposed to pre compute the aggregation for all possible combination of dimension to answer analytical queries efficiently. It is a generalization of the group-by operator over all possible combination of dimension with various granularity aggregates. Efficient and Compressed computation of data cube are Fundamental issues. Data Warehouses tend to be order of magnitude larger than operational database in size. So by studying and comparing all these methods we can find out that which methods are applicable and suitable for which kind of Data. Here I have compared range cube with Bit cube .Each problem is of particular interest in the field of data analysis and query answering. So by comparing various methods, we can verify the trades of between time and space as per the requirements and type of problem. Different Types of measures are available for aggregating the datasets. Such as Major-Minor, Count, Sum etc. So comparative study shows that we can find which measures can be compute data cube incrementally.

Other Details

Paper ID: IJSRDV1I3004
Published in: Volume : 1, Issue : 3
Publication Date: 01/06/2013
Page(s): 418-421

Article Preview

Download Article