Overview of OLAP cubes, importance, build Considerations and querying with MDX.
Journal Title: INTERNATIONAL JOURNAL OF COMPUTERS & TECHNOLOGY - Year 2013, Vol 9, Issue 1
Abstract
An OLAP cube is a method of storing data in a multidimensional form, generally for reporting purposes. The purpose of an OLAP cube is to store data in such a way that an end user can slice and dice through the data and the storage structure itself (multidimensional) while allowing for very fast access to the data. Cubes are characterized by dimensions and measures. Dimensions refer to how the data is organized and are usually made up of character fields which tell us about the data. Measures, on the other hand, are those elements in the data which quantify something (a number) and can usually be additive . The business intelligence industry uses the word "cube" because it best describes the resulting data. The query language used to interact and perform tasks with OLAP cubes is multidimensional expressions (MDX).In this paper an attempt is made to give the overview, importance and build considerations of Olap cubes. Also querying of OLAP cube with MDX is discussed.
Authors and Affiliations
Anil Dundappa Devangavi, Dr Puneet Aggarwal
Keywords
Related Articles
- EP ID EP650146
- DOI 10.24297/ijct.v9i1.4163
- Views 112
- Downloads 0
Coloured Image Segmentation Using K-Means Algorithm
Very large collections of images are growing ever more common. From stock photo collections to proprietary databases to the Web, these collections are diverse and often poorly indexed; unfortunately, image retrieval syst...
Mobile Health Monitoring System using Fuzzy Logic
This paper was tested on a set of data in order to prove its effectiveness. Simulation gives promising results in detecting the activity of the person. This is efficient system for health monitoring as compare with conve...
GRASPING SPATIAL SOLUTIONS IN DISTRIBUTED DYNAMIC WORLDS
A high-level ideology and technology will be revealed that can effectively convert any distributed system (manned, unmanned or mixed) into a globally programmable spatial machine capable of operating without central reso...
HMotion: An Algorithm for Human Motion Detection
Computer memory is expensive and the recording of data captured by a webcam needs memory. In order to minimize the memory usage in recording data from human motion as recorded from the webcam, this algorithm will use mot...
Enhanced Adaptive Mechanisms to Improve QOS in Distributed Multimedia Applications
Recent advances in computer communications, especially highly interactivedistributed applications and those relying on the transfer of multimedia information and in particular, continuous media flows. It is essential tha...