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 86
- Downloads 0
Performance Analysis of Biscuit Manufacturing Plant in Steady State Using Fuzzy Availability
This paper deals with the performance analysis of biscuit manufacturing plant consisting of six sub-systems using fuzzy availability in the steady state. These six sub-systems are arranged in series and parallel configur...
Low Cost VoIP Architecture Using Open Source Software Component in Tertiary Institutions
Governments and their agencies are often challenged by high cost and flexible telephonic, Web based data services. Emerging technologies, such as those of Voice over Internet Protocol (VoIP) that allow convergent system...
RE-MAC: A Reliable Energy Efficient MAC Protocol For Wireless Sensor Networks
Wireless sensor networks are considered to be a promising area to equip scientists with the capability of developing real-time monitoring systems. This paper discusses the design and development of a wireless sensor netw...
A Study on Surface Roughness and Cutting Width for Circular Contour Machining of Stir Cast AA6063/SiC Composites in WEDM
Wire electrical discharge machining is used in machining electric conductive materials with intricate shapes and profiles. This paper presents an experimental investigation on the influence of cutting conditions of WEDM...
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...