Design and Implementation of Data Warehousing for Small and Medium Sized Enterprises (SMEs): A Cost-Effective Approach in Online Stores
DOI:
https://doi.org/10.70112/ajcst-2025.14.1.4325Keywords:
Data Warehousing, Small and Medium-Sized Enterprises (SMEs), Data Analytics, Star Schema, Open-Source ToolsAbstract
The storage of historical data for reference purposes has been a fundamental practice since the advent of relational databases. Despite their importance, small and medium-sized enterprises (SMEs), particularly online merchants, often rely on rudimentary methods for data storage and retrieval, thereby limiting their ability to utilize data analytics for informed decision-making. This study aims to establish a cost-effective and low-complexity data analytics infrastructure for SMEs to facilitate their transition into data-driven organizations. It examines the effective use of data warehouses (DWs) through office automation tools and open-source software solutions. A comparative analysis of data warehouse schemas-specifically the Star Schema and Snowflake Schema-was conducted to evaluate their effectiveness in preserving data integrity and supporting analytics. A practical implementation using freeware and office automation tools was executed to validate the proposed methodology. The findings indicate that the Star Schema is more suitable for dynamic data environments requiring frequent updates, whereas the Snowflake Schema is optimal for static data contexts. The proposed infrastructure effectively supports decision-making processes, particularly for online enterprises, by maintaining data integrity and streamlining analytics. This study provides SMEs with a pragmatic and economic framework for implementing data warehousing and analytics technologies. Adoption of the proposed infrastructure enables online enterprises to enhance decision-making and transition towards a data-driven strategy, thereby sustaining competitiveness in the digital marketplace.
References
[1] M. D. AL-Shboul, “Towards better understanding of determinants logistical factors in SMEs for cloud ERP adoption in developing economies,” Business Process Management Journal, vol. 25, no. 5, pp. 887-907, Aug. 2019.
[2] M. Saratchandra and A. Shrestha, “The role of cloud computing in knowledge management for small and medium enterprises: a systematic literature review,” Journal of Knowledge Management, vol. 26, no. 10, pp. 2668-2698, Nov. 2022.
[3] S. M. Hånell, E. Rovira Nordman, D. Tolstoy, and N. Özbek, “It’s a new game out there: e-commerce in internationalising retail SMEs,” International Marketing Review, vol. 37, no. 3, pp. 515-531, Jul. 2020.
[4] T. Kelepouris, K. Pramatari, and G. Doukidis, “RFID-enabled traceability in the food supply chain,” Industrial Management & Data Systems, vol. 107, no. 2, pp. 183-200, Mar. 2007.
[5] K. Ngcobo, S. Bhengu, A. Mudau, B. Thango, and M. Lerato, “Enterprise data management: Types, sources, and real-time applications to enhance business performance-a systematic review,” Systematic Review, vol. 26, Sep. 2024.
[6] S. Shargunam and G. Rajakumar, “Predictive analysis on sensor data using distributed machine learning,” Asian Journal of Computer Science and Technology (AJCST), vol. 11, no. 1, pp. 1-4, Jan. 2022.
[7] A. Martins, P. Martins, F. Caldeira, and F. Sá, “An evaluation of how big-data and data warehouses improve business intelligence decision making,” in Proc. World Conf. Inf. Syst. Technol., Springer, Cham, pp. 609-619, Apr. 2020.
[8] R. K. Singh, S. Luthra, S. K. Mangla, and S. Uniyal, “Applications of information and communication technology for sustainable growth of SMEs in India food industry,” Resources, Conservation and Recycling, vol. 147, no. 1, pp. 10-18, Aug. 2019.
[9] R. Vasumathi and S. Murugan, “Mining of high average-utility pattern using multiple minimum thresholds in big data,” Asian Journal of Computer Science and Technology (AJCST), vol. 8, no. S2, pp. 57-60, Mar. 2019.
[10] E. Ayoubi and S. Aljawarneh, “Challenges and opportunities of adopting business intelligence in SMEs: collaborative model,” in Proc. 1st Int. Conf. Data Sci., E-Learning Inf. Syst., pp. 1–5, Oct. 2018.
[11] N. AlQershi, S. S. Mokhtar, and Z. Abas, “The influence of structural capital on the relationship between CRM implementation and the performance of manufacturing SMEs,” Int. J. Syst. Assur. Eng. Manag., vol. 13, no. 3, pp. 1205-1218, Jun. 2022.
[12] O. I. Tawfik, O. Durrah, K. Hussainey, and H. E. Elmaasrawy, “Factors influencing the implementation of cloud accounting: evidence from small and medium enterprises in Oman,” J. Sci. Technol. Policy Manag., Jul. 2022.
[13] C. M. Olszak and E. Ziemb, “Critical success factors for implementing business intelligence systems in small and medium enterprises on the example of upper Silesia, Poland,” Interdisciplinary Journal of Information, Knowledge, and Management, vol. 129, no. 7, 2012.
[14] W. Noonpakdee, A. Phothichai, and T. Khunkornsiri, “Big data implementation for small and medium enterprises,” in Proc. 2018 Wireless Opt. Commun. Conf. (WOCC), IEEE, pp. 1-5, Apr. 2018.
[15] V. Cherapanukorn, G. Suriyamanee, and S. Wanchaem, “Enterprise resources planning framework for Thai agriculture SMEs,” in Proc. 2022 Joint Int. Conf. Digital Arts, Media Technol. with ECTI Northern Sect. Conf. Electr., Electron., Comput. Telecommun. Eng. (ECTI DAMT & NCON), IEEE, pp. 41-45, Jan. 2022.
[16] R. Kimball and M. Ross, The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, John Wiley & Sons, 2011.
[17] Kaggle, “Kaggle,” [Online]. Available: https://www.kaggle.com/da tasets.
[18] SQL Server, “microsoft.com,” [Online]. Available: https://www.mic rosoft.com/en-us/sql-server/sql-server-downloads.
[19] PowerBI, “powerbi.microsoft.com,” [Online]. Available: https://powerbi.microsoft.com/en-au/.
[20] M. Patel and D. B. Patel, “Data warehouse modernization using document-oriented ETL framework for real-time analytics,” in Rising Threats in Expert Applications and Solutions 2022, Springer, Singapore, pp. 33-41, 2022.
[21] G. Thangarasu, P. Dominic, M. C. Johnwiselin, and S. P. Pradeep Kumar, “Fashions in data mining and hidden knowledge innovation from clinical database,” Asian Journal of Computer Science and Technology (AJCST), vol. 1, no. 2, pp. 36-39, Nov. 2012.
[22] V. Saraswathi Bai, “Data mining methods for communication technology,” Asian Journal of Computer Science and Technology (AJCST), vol. 8, no. S3, pp. 30-34, Apr. 2019.
[23] S. Balamurugan and A. B. Arockia Christopher, “Data pre-processing for classification and clustering,” Asian Journal of Computer Science and Technology (AJCST), vol. 1, no. 1, pp. 1-5, May 2012.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2025 Centre for Research and Innovation
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
