Welcome to the InfoSci Platform
Reference Hub1
An Application of an Intelligent Data Warehouse for Modelling Spatiotemporal Objects

An Application of an Intelligent Data Warehouse for Modelling Spatiotemporal Objects

Georgia Garani, Nunziato Cassavia, Ilias K. Savvas
Copyright: © 2020 |Volume: 1 |Issue: 1 |Pages: 22
ISSN: 2644-1675|EISSN: 2644-1683|EISBN13: 9781799809777|DOI: 10.4018/IJBDIA.2020010103
Cite Article Cite Article

MLA

Garani, Georgia, et al. "An Application of an Intelligent Data Warehouse for Modelling Spatiotemporal Objects." IJBDIA vol.1, no.1 2020: pp.36-57. http://doi.org/10.4018/IJBDIA.2020010103

APA

Garani, G., Cassavia, N., & Savvas, I. K. (2020). An Application of an Intelligent Data Warehouse for Modelling Spatiotemporal Objects. International Journal of Big Data Intelligence and Applications (IJBDIA), 1(1), 36-57. http://doi.org/10.4018/IJBDIA.2020010103

Chicago

Garani, Georgia, Nunziato Cassavia, and Ilias K. Savvas. "An Application of an Intelligent Data Warehouse for Modelling Spatiotemporal Objects," International Journal of Big Data Intelligence and Applications (IJBDIA) 1, no.1: 36-57. http://doi.org/10.4018/IJBDIA.2020010103

Export Reference

Mendeley
Favorite Full-Issue Download

Abstract

Data warehouse (DW) systems provide the best solution for intelligent data analysis and decision-making. Changes applied to data gradually in real life have to be projected to the DW. Slowly changing dimension (SCD) refers to the potential volatility of DW dimension members. The treatment of SCDs has a significant impact over the quality of data analysis. A new SCD type, Type N, is proposed in this research paper, which encapsulates volatile data into historical clusters. Type N preserves complete history of changes, additional tables, columns, and rows are not required, extra join operations are omitted, and surrogate keys are avoided. Type N is implemented and compared to other SCD types. Good candidates for practicing SCDs are spatiotemporal objects (i.e., objects whose shape or geometry evolves slowly over time). The case study used and implemented in this paper concerns shape-shifting constructions (i.e., buildings that respond to changing weather conditions or the way people use them). The results demonstrate the correctness and effectiveness of the proposed SCD Type N.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.