Challenges of Dimensional Modeling in Business Intelligence Systems

International Journal of Computer & Organization Trends  (IJCOT)          
© 2015 by IJCOT Journal
Volume - 5 Issue - 3
Year of Publication : 2015
AuthorsMuhammad Khalid, Zahid Javed, Tariq Shahzad, Muniza Iqbal, Rukhsana Safdar


Muhammad Khalid, Zahid Javed, Tariq Shahzad, Muniza Iqbal, Rukhsana Safdar"Challenges of Dimensional Modeling in Business Intelligence Systems", International Journal of Computer & organization Trends (IJCOT), 5(3):30-31 May - Jun 2015, ISSN:2249-2593, Published by Seventh Sense Research Group.

Abstract In today’s modern business environment, data is growing rapidly and we are drowning in huge data “big data”. Increasing in the volume of data, the ways to manage big data have been changed as compare to traditional ways. Concept of Data warehouse emerged to mange this huge data volume and absolute the tradition transaction systems (OLTP). Business adopted them as an alternative of traditional transactional systems. Dimension modeling provides number of different techniques to design these new systems (OLAP) efficiently to meet the intelligence requirements of business by providing intended support of user’s inquiries. In this paper, we analyze the challenges faced by dimension modeling for designing these systems especially for business intelligence with respect to their functionality, architecture, structure and enhance the performance and consistency of new business dimensions.


[1] Chuck Ballard, Danial M. Farrel, Amit Gupta, Carlos Mazuela, Stanislav Vohnik, Dimensional Modeling in a Business Intelligence Enviorment , IBM, Redbooks.
[2] M. Miskuf, I. Zolotova, Application of Business Intelligence Solution on Manufacturing Data, 978-1-4799-8221-9/15 (2015) IEEE
[3] Ranak Ghosh, Sujay Halder, Soumya Sen, An Integrated Approch to Deploy Data Warehouse in Bussiness Intelligence Ennvioorment, 978- 1-4799-4445-3/15$31.00 © 2015 IEEE
[4] Mary Elisabeth Jones, II-Yeol Song, Dimenional Modeling: Identifying, Classifying & Applying Patterns, ACM 2014.
[5] Deepak Asrani, Dr. Renu Jain, Review of techniques used in data warehouse implementation: An imitative towards designing a framework for effective data warehousing, August 01-02,2014, 978-1- 4799-6393-5/14 (2014) IEEE
[6] V. Jovanovice, D. Subotic, S. Mrdalj, Data Modeling Styles in Data Warehousing, MIPRO 2014, 26-30 May 2014, OPatija, Croatia.
[7] Vedika Gupta, Anjana Gosain, A Comprehensive Review of Unstructured Data Management Approaches in Data Warehouse, 2013, International Symposium on Computational and Business Intelligence, 978-0-7695-5066-4/13 (2013) IEEE
[8] Changping Yu, Architecture Research of Decision Support System for Tariff and Trade based on the Multi-dimensional Modeling Techniques, Third International Conference on Information Science and Technology, March 23-25-2013, China, 978-1-4673-2764-0/13/$31.00 © 2013 IEEE.
[9] O. Jukic, I. Hedi, The use of call detail records and data mart dimensioning for telecommunication companies, 20th Telecommunication forum TELFOR 2012, 978-1-4673-2984- 2/12$31.00 © 2012 IEEE.
[10] Joseph M. Firestone, Dimensional Modeling and ER Modeling in the Data Warehouse, White paper No. 8, June 22, 1998
[11] Suja Ramachandran, S. Rajcswari, S.A.V Satya Murty, M. Valsan, R. K, Dayal., R.V, Subba Rao, Baldev Raj, Design of a Dimensional Database for Materials Data, 978-1-4244-9008-0/10/$26.00 ©2010 IEEE.
[12] Mladen Varga, Conceptual Modeling Styles, 24th Int. Conf. Information Technology Interfaces ITI 2002, June 24-27, 2002, Cavtat, Croatia.
[13] G. Graefe, U. Fayyad, S. Chaudhuri, On the efficient gathering of sufficient statistics for classification from large SQL databases, in: Proceedings of the International Conference on Knowledge Discovery and Data Mining, New York, 1998, pp. 204–208.
[14] [10] D. Chatziantoniou, Ad hoc OLAP: expression and evaluation. in: Proceedings of the IEEE International Conference on Data Engineering, Sydney, 1999.

OLAP, Dimensional Modeling, Business Intelligence, Data Warehouse.