{'fraction_non_alphanumeric': 0.012845849802371542, 'fraction_numerical': 0.0, 'mean_word_length': 5.291925465838509, 'pattern_counts': {'":': 0, '<': 0, '<?xml version=': 0, '>': 0, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
User-centric spatial data warehousing: a survey of requirements and approaches

The increased availability of spatial data in recent years has lead to new challenges in the analysis of large multidimensional datasets. One solution is to integrate GIS with OLAP and relational databases. Another strategy has been to leverage existing spatial capabilities of databases to perform spatial OLAP. In this article, we review existing modelling strategies for spatial data warehousing at all three levels: conceptual, logical and implementation. We gather the most essential requirements for handling spatial data and use insights from spatial databases and GIS systems to design a meta-framework that would enable a user-centric modelling of complex data. Our strategy is to keep the user as the focal point in the analysis process and lay the foundation for clear data abstraction at different levels using multidimensional abstract data types and operations and thus support complex spatial data in data warehouses.