A cloud-based spatiotemporal data warehouse approach

The arrival of the big data era introduces new necessities for accommodating data access and analysis by organisations. The evolution of data is three-fold, increase in volume, variety, and complexity. The majority of data nowadays is generated in the cloud. Cloud data warehouses profit from the benefits of the cloud by facilitating the integration of data in the cloud. A data warehouse is developed in this paper, which supports both spatial and temporal dimensions. The research focuses on proposing a general design for spatiobitemporal objects implemented by nested dimension tables using the starnest schema approach. Experimental results reflect that the parallel processing of such data on the cloud can process OLAP queries efficiently. Furthermore, by increasing the number of computational nodes results in a significant reduction of queries' time execution. The feasibility, scalability, and utility of the proposed technique for querying spatiotemporal data are demonstrated.