Help for this page

Journal of Basic and Applied Sciences Volume 1 (2026) · Issue 1

Original Research

Edge-Cloud Integrated Data Warehousing Architecture for Efficient IoT Data Analytics

Blessing Oyovwe*, Christopher Maduabuchukwu, Jackson Akpojaro

  1. * Corresponding author

Read PDFDownload PDF (603 KB)

Abstract

The rapid proliferation of Internet of Things (IoT) deployments has generated urgent demand for data management architectures capable of reconciling the competing requirements of low-latency local processing and comprehensive cloud-scale analytics. This paper proposes the Edge-Cloud Integrated Data Warehousing Architecture (ECIDWA), a four-layer hybrid framework that employs metadata-driven query routing between distributed edge data marts and a centralised cloud data warehouse. ECIDWA directly addresses the principal limitations of both pure-cloud and pure-edge designs: the high bandwidth overhead and round-trip latency of cloud-only approaches, and the constrained computational capacity and limited analytical coverage inherent in edge-only deployments. A lightweight orchestration engine dynamically classifies incoming queries as either latency-sensitive or analytics-intensive and routes them to the appropriate execution tier. The architecture is evaluated against cloud-only and edge-only reference implementations using a controlled experimental protocol comprising 500 independent runs per architecture across seven performance dimensions. Results indicate statistically significant improvements on all metrics (one way ANOVA; all F > 1,800; all p < .001). Relative to the cloud-only baseline, ECIDWA achieves a 43.8% reduction in query latency, a 37.7% reduction in bandwidth consumption, a 28.0% improvement in throughput, and a 44.9% reduction in fault recovery time, while sustaining a query accuracy of 97.6% (SD = 0.8%). Scalability analyses confirm that these advantages are maintained under concurrent device loads of up to 10,000 nodes. Collectively, these findings position ECIDWA as a robust, production-ready framework for industrial IoT, smart city, and real-time monitoring applications.

Keywords

How to cite

Oyovwe, B., Maduabuchukwu, C., & Akpojaro, J. (2026). Edge-Cloud Integrated Data Warehousing Architecture for Efficient IoT Data Analytics. Journal of Basic and Applied Sciences, 1(1), Article JBAS-2026-0626-AC1780. https://journals.uat.edu.ng/pub/0000000029
Oyovwe, Blessing, et al. "Edge-Cloud Integrated Data Warehousing Architecture for Efficient IoT Data Analytics." Journal of Basic and Applied Sciences, vol. 1, no. 1, 2026, article JBAS-2026-0626-AC1780, https://journals.uat.edu.ng/pub/0000000029.
Oyovwe, Blessing, Christopher Maduabuchukwu, and Jackson Akpojaro. 2026. "Edge-Cloud Integrated Data Warehousing Architecture for Efficient IoT Data Analytics." Journal of Basic and Applied Sciences 1 (1): JBAS-2026-0626-AC1780. https://journals.uat.edu.ng/pub/0000000029.
Oyovwe, B., Maduabuchukwu, C. and Akpojaro, J. (2026) 'Edge-Cloud Integrated Data Warehousing Architecture for Efficient IoT Data Analytics', Journal of Basic and Applied Sciences, 1(1), Article JBAS-2026-0626-AC1780. Available at: https://journals.uat.edu.ng/pub/0000000029 (Accessed: 20 November 2026).
B. Oyovwe, C. Maduabuchukwu, and J. Akpojaro, "Edge-Cloud Integrated Data Warehousing Architecture for Efficient IoT Data Analytics," Journal of Basic and Applied Sciences, vol. 1, no. 1, Art. no. JBAS-2026-0626-AC1780, 2026. [Online]. Available: https://journals.uat.edu.ng/pub/0000000029
BibTeX and RIS

BibTeX

@article{oyovwe2026edgecloud,
  author = {Oyovwe, Blessing and Maduabuchukwu, Christopher and Akpojaro, Jackson},
  title = {{Edge-Cloud Integrated Data Warehousing Architecture for Efficient IoT Data Analytics}},
  journal = {Journal of Basic and Applied Sciences},
  year = {2026},
  volume = {1},
  number = {1},
  note = {Article JBAS-2026-0626-AC1780},
  publisher = {University of Africa, Toru-Orua},
  url = {https://journals.uat.edu.ng/pub/0000000029},
  keywords = {Edge computing, Cloud data warehousing, IoT analytics, Hybrid architecture, Query routing, Metadata orchestration.}
}

Download .bib

RIS

TY  - JOUR
AU  - Oyovwe, Blessing
AU  - Maduabuchukwu, Christopher
AU  - Akpojaro, Jackson
TI  - Edge-Cloud Integrated Data Warehousing Architecture for Efficient IoT Data Analytics
JO  - Journal of Basic and Applied Sciences
PY  - 2026
DA  - 2026/06/27
VL  - 1
IS  - 1
C7  - JBAS-2026-0626-AC1780
PB  - University of Africa, Toru-Orua
AB  - The rapid proliferation of Internet of Things (IoT) deployments has generated urgent demand for data management architectures capable of reconciling the competing requirements of low-latency local processing and comprehensive cloud-scale analytics. This paper proposes the Edge-Cloud Integrated Data Warehousing Architecture (ECIDWA), a four-layer hybrid framework that employs metadata-driven query routing between distributed edge data marts and a centralised cloud data warehouse. ECIDWA directly addresses the principal limitations of both pure-cloud and pure-edge designs: the high bandwidth overhead and round-trip latency of cloud-only approaches, and the constrained computational capacity and limited analytical coverage inherent in edge-only deployments. A lightweight orchestration engine dynamically classifies incoming queries as either latency-sensitive or analytics-intensive and routes them to the appropriate execution tier. The architecture is evaluated against cloud-only and edge-only reference implementations using a controlled experimental protocol comprising 500 independent runs per architecture across seven performance dimensions. Results indicate statistically significant improvements on all metrics (one way ANOVA; all F > 1,800; all p < .001). Relative to the cloud-only baseline, ECIDWA achieves a 43.8% reduction in query latency, a 37.7% reduction in bandwidth consumption, a 28.0% improvement in throughput, and a 44.9% reduction in fault recovery time, while sustaining a query accuracy of 97.6% (SD = 0.8%). Scalability analyses confirm that these advantages are maintained under concurrent device loads of up to 10,000 nodes. Collectively, these findings position ECIDWA as a robust, production-ready framework for industrial IoT, smart city, and real-time monitoring applications.
KW  - Edge computing
KW  - Cloud data warehousing
KW  - IoT analytics
KW  - Hybrid architecture
KW  - Query routing
KW  - Metadata orchestration.
UR  - https://journals.uat.edu.ng/pub/0000000029
ER  - 

Download .ris