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 |
|
|
|
|
