The IRMA Community
Newsletters
Research IRM
Click a keyword to search titles using our InfoSci-OnDemand powered search:
|
Improving Expressive Power in Modeling Data Warehouse and OLAP Applications
Abstract
Data warehouse and OLAP systems are widely required during the decision-support process, since they provide integrated data in a form that facilitates the expression of complex queries. In order to exploit both systems to their full capabilities, dimensions with hierarchies must be clearly defined. Dimensions can be of different types and they allow users to see quantified data from different perspectives. Hierarchies are important in analytical applications, since they give users the possibility of representing data at different abstraction levels. However, even though there are different kinds of hierarchies in real-world applications and some of them are already implemented in commercial tools, there is still a lack of a well-accepted conceptual model that allows decision-making users to express their analysis needs. In this chapter, we show how the conceptual multidimensional model can be used to facilitate the representation of complex hierarchies and different kinds of dimensions in comparison to their representation in the relational model and commercial OLAP tools, using as an example Microsoft Analysis Services.
Related Content
Md Sakir Ahmed, Abhijit Bora.
© 2024.
15 pages.
|
Lakshmi Haritha Medida, Kumar.
© 2024.
18 pages.
|
Gypsy Nandi, Yadika Prasad.
© 2024.
16 pages.
|
Saurav Bhattacharjee, Sabiha Raiyesha.
© 2024.
14 pages.
|
Naren Kathirvel, Kathirvel Ayyaswamy, B. Santhoshi.
© 2024.
26 pages.
|
K. Sudha, C. Balakrishnan, T. P. Anish, T. Nithya, B. Yamini, R. Siva Subramanian, M. Nalini.
© 2024.
25 pages.
|
Sabiha Raiyesha, Papul Changmai.
© 2024.
28 pages.
|
|
|