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 105
- Downloads 0
FPGA IMPLEMENTATION OF INTELLIGENT EMBEDDED SYSTEM FOR DISTRIBUTED ELECTRICAL APPLIANCES
Now a days, Technology is veryimportant in daily life. In the offices, theusage of electronic appliances is increasingrapidly. So the demand for power is alsoincreasing. The power demand can be metupto some extent by red...
ALLOCATION OF HETEROGENOUS CLOUDLETS ON PRIORITY BASIS IN CLOUD ENVIRONMENT
Load balancing is one of the main challenges in cloud computing which is required to distribute the dynamic workload across multiple nodes to ensure that no single node is overwhelmed. It helps in optimal utilization of...
Novel Approach for Frequent Pattern Algorithm for Maximizing Frequent Patterns in Effective Time
The essential aspect of mining association rules is to mine the frequent patterns. Due to native difficulty it is impossible to mine complete frequent patterns from a dense database. FP-growth algorithm has been implemen...
A New Approach For Load Balancing In Cloud Computing
Cloud computing is the dynamic delivery of information technology resources and capabilities as a service over the Internet. Cloud computing is a style of computing in which dynamically scalable and often virtualized res...
TheWorkQueue with Dynamic Replication-FaultTolerant Scheduler in Desktop Grid Environment
Desktop Grid is different from Grid in terms of the characteristics of resources as well as types of sharing. Particularly, resource providers in Desktop Grid are volatile, heterogeneous, faulty, and malicious. These dis...