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 113
- Downloads 0
E-parliament and Democratic Representation in African States: Prospects and Challenges
A healthy and credible legislature is indispensable for representative liberal democratic governance. While representation involves informing and listening to those represented and making decisions and exercising influen...
Topology Controlled Energy Proficient Protocol for Wireless Sensor Networks
Random deployment in Wireless sensor networks lead to spatial node redundancy in close knit sensor networks. In this paper, an improved energy proficient PEGASIS based protocol (PEGASIS-TC) has been proposed. PEGASIS-TC...
An efficient Scheme to Remove Low Density Impulse Noise From A Digital Image
An improved adaptive noise reduction scheme for images that are highly corrupted by Salt-and-Pepper noise(impulse noise), is proposed in this paper which efficiently removes the salt and pepper noise while preserving the...
Comparative Study of Different Technique for Medical Image Segmentation: A Survey
Image analysis and processing can be done using image segmentation as one of the most critical aspect. Various subsequent processes of image analysis such as object representation object description ,feature measurement...
Optimized Load Balancing Strategy In Cloud Computing : A Review
Now a days every organization is migrating towards cloud computing as cloud computing is considered being more flexible and scalable as compared to other technologies. The technology simply means to provide the com...