Easy designing steps of a local data warehouse for possible analytical data processing

Y. Somananda Singh, Y. Kirani Singh, N. Subadani Devi, Y. Jayanta Singh


Data warehouse (DW) are used in local or global level as per usages. Most of the DW was designed for online purposes targeting the multinational firms. Majority of local firms directly purchase such readymade DW applications for their usages. Customization, maintenance and enhancement are very costly for them. To provide fruitful e-services, the Government departments, academic Institutes, firms, Telemedicine firms etc. need a DW of themselves. Lack of electricity and internet facilities, especially in rural areas, does not motivate citizen to use the benefits of e-services. In this digital world, every local firm is interested in having their DW that may support strategic and decision making for the business. This study highlights the basic technical designing steps of a local DW. It gives several possible solutions that may arise during the design of the process of Extraction Transformation and Loading (ETL). It gives detail steps to develop the dimension table, fact table and loading data. Data analytics normally answers business questions and suggest future solutions.

Full Text:



] TA Majchrzak, T Jansen, H Kuchen, "Efficiency evaluation of open source ETL tools." Proceedings of the 2011 ACM Symposium on Applied Computing. ACM, 2011. [2 ] R Kimball, J Caserta, The data warehouse ETL toolkit: practical techniques for extracting, cleaning, conforming, and delivering data. John Wiley & Sons, 2011. [3] TB Pedersen, CS Jensen, "Multidimensional database technology." Computer Journal, pp.40-46,2001 [4] TB Pedersen, CS Jensen, CE Dyreson, “A Foundation for capturing and Querying complex multidimensional data”; Information systems, Elsevier, July 2001, pp 383-423 [5] D Feinberg, MA Beyer, "Magic quadrant for data warehouse database management systems." Gartner Research Note, 2008.

M. Poess, R. Nambiar, ”Building Enterprise Class Real-Time Energy Efficient DSS” in Enabling Real-Time Business Intelligence, Vol 84, pp 36-5, 2011. [7] F Atigui, F Ravat, R Tournier, G Zurfluh, "A Unified Model-Driven Methodology for Data Warehouses and ETL Design." In ICEIS, pp. 247-252. 2011. [8] Q Chen, M Hsu, U Dayal, 'A data-warehouse/OLAP framework for scalable telecommunication tandem traffic analysis', Proceedings of 16th International Conference on Data Engineering (Cat. No. 00CB37073). IEEE, 2000. [9] SHA El-Sappagh, AMA Hendawi, AH Bastawissy, "A proposed model for data warehouse ETL processes." Journal of King Saud University-Computer and Information Sciences 23.2 (2011): 91-104. [10] A Nabli, S Bouaziz, R Yangui, F Gargouri" Two-ETL phases for data warehouse creation: Design and implementation." East European Conf. on Advances in Databases and Information Systems. Springer, Cham, 2015. [11] F Dehne, Q Kong, A Rau-Chaplin, H Zaboli, "Scalable real-time OLAP on cloud architectures." Journal of Parallel and Distributed Computing 79, pp.31-41, May2015 [12] H.Zaboli, “Parallel OLAP on Multi/Many Core and Cloud Platforms”, PhD thesis, March 2014. [13] J.Caskey, "Load balancing strategies for Cloud-based Real-Time OLAP", Project report, April 2013 [14] F.Dehne, H. Zaboli, ”Parallel Real-Time OLAP on Multicore Processors”, Proc. 2012th IEEE/ACM, 2012. [15] VM Ngo, NA Le-Khac, M Kechadi, "An Efficient Data Warehouse for Crop Yield Prediction", in proc.14th Int. Conf. on Precision Agriculture. June 24-27, 2018 [16] TMJ Al Taleb, S Hasan, YY Mahdi, "Data Warehouse System for Outpatient Healthcare", Journal of Fundamental and Applied Sciences 10, pp.187-192, 2018 [17] www.cdac.in, [accessed on 10 Oct2018] [18] N. Subadani, L.Prabhakar, "A Data Warehouse system for Human Resource Management in a Distributed Software Development" ADBU Journal of Engineering Technology, 5(2), 2016. [19] Susan Hillson, Lilian Hobbs, Shilpa Lawande, E-Book: Oracle 10g Data Warehousing, 2004 [20] Gavin Powell, E-Book: Oracle Data Warehouse Tuning For 10g, 2015 [21] S McClean, B Scotney, P Morrow, K Greer, McClean, "Knowledge discovery by probabilistic clustering of distributed databases." Data & Knowledge Engineering 54, no.2, pp.189-210, 2005 [22] B. S. Zaman, B. Kumar, Z. Azim, Y. J Singh, "Suggestive Local Engine for SQL Developer: SLED." ADBU Journal of Engineering Technology 4, 2016. [23] J Han, J Pei, Y Yin, "Mining frequent patterns without candidate generation." In ACM sigmod record, 29, no. 2, pp. 1-12. ACM, 2000


  • There are currently no refbacks.


The “ADBU Journal of Engineering Technology (AJET)" ISSN:2348-7305

This journal is published under the terms of the Creative Commons Attribution (CC-BY) (http://creativecommons.org/licenses/)

Number of Visitors to this Journal:web counter