A Trajectory Data Warehouse is a central repository of large amount of data focusing on moving objects, which have been collected and integrated from multiple sources with spatial and temporal dimensions as the main metrics of analysis. By adding semantic-related contextual information, it is converted to a Semantic Trajectory Data Warehouse. It transforms raw trajectories to valuable information that can be utilized for decision-making purposes in ubiquitous applications. Human recourses management is a domain that may benefit significantly from semantic trajectory data warehouses. In particular, employees working shifts can be considered as trajectories. In this work, standard data warehousing tools are used to store data about nursing personnel shifts as trajectories of moving persons. The conceptual and logical modelling of the semantic trajectory data warehouse is developed. The objective is the observation, management and scheduling of nurses' shifts data by the computation of OLAP operations over them. A prototype implementation has also been realized to illustrate the functionality of the proposed model. The produced results prove the efficiency in improving nursing productivity.
Keywords: Conceptual modelling; Data warehouse; Logical modelling; Moving object; Trajectory.
© Springer Nature Switzerland AG 2020.