JISE


  [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] [12] [13]


Journal of Information Science and Engineering, Vol. 38 No. 6, pp. 1213-1241


Spatiotemporal Data Warehousing for Event Tracking Applications


FRANK S. C. TSENG1,+ AND ANNIE Y. H. CHOU2
1Department of Information Management
National Kaohsiung University of Science and Technology
Kaohsiung, 824 Taiwan
E-mail: imfrank@nkust.edu.tw

2Department of Computer and Information Science
ROC Military Academy
Kaohsiung, 830 Taiwan
E-mail: imyhchou@gmail.com


In this paper, we propose a multidimensional spatiotemporal modeling framework of data warehouse creation for tracing dynamic events in contemporary applications, like crowd contact tracing for Covid-19 prevention. Such a framework offers a natural and consistent solution for slowly changing dimension management. It provides a progressive evolution from traditional static data management to modern dynamic data analysis with spatiotemporal tracking capabilities for IoT applications. Based on such a framework, entity-centered resource integration and related business intelligence applications can be rigorously developed, managed and properly tracked.


Keywords: big data, data warehouse, digital footprint, dimensional modeling, slowly changing dimension, spatiotemporal tracking, temporal database

  Retrieve PDF document (JISE_202206_07.pdf)