Abstract

Nowadays, with the rise of sensor technology, the amount of spatial and temporal data is increasing day by day. Modeling data in a structured way and performing effective and efficient complex queries has become more essential than ever. Online analytical processing (OLAP), developed for this purpose, provides appropriate data structures and supports querying multidimensional numeric and alphanumeric data. However, uncertainty and fuzziness are inherent in the data in many complex database applications, especially in spatiotemporal database applications. Therefore, there is always a need to support flexible queries and analyses on uncertain and fuzzy data, due to the nature of the data in these complex spatiotemporal applications. FSOLAP is a new framework based on fuzzy logic technologies and spatial online analytical processing (SOLAP). In this study, we use crisp measures as input for this framework, apply fuzzy operations to obtain the membership functions and fuzzy classes, and then generate fuzzy association rules. Therefore, FSOLAP does not need to use predefined sets of fuzzy inputs. This paper presents the method used to model the FSOLAP and manage various types of complex and fuzzy spatiotemporal queries using the FSOLAP framework. In this context, we describe how to handle non-spatial and fuzzy spatial queries, as well as spatiotemporal fuzzy query types. Additionally, while FSOLAP primarily includes historical data and associated queries and analyses, we also describe how to handle predictive fuzzy spatiotemporal queries, which typically require an inference mechanism.

Highlights

  • While traditional databases are concerned with the retention of data and the efficient management of online transactions, online analytical processing (OLAP) is concerned with the efficient analytics of online data

  • We show that various complex queries, including predictive fuzzy spatiotemporal queries, are effectively and efficiently handled using our fuzzy spatial OLAP framework

  • Application development environment: Eclipse IDE 2021-03; System: Windows 10 x64, Intel i5-7200U CPU, 16 GB RAM; Java: 1.8.0-281, Java HotSpot Client 64-bit Server VM 25.281-b09; spatial online analytical processing (SOLAP): GeoMondrian 1.0 Server; DBMS: PostgreSQL 13.3 64-bit; fuzzy inference system (FIS): jFuzzyLogic.jar; Data Size: approximately 10 GB data consisting of 1161 stations and 15 M records for each measurements (15 M × 10 measurement types)

Read more

Summary

Introduction

The amount and variety of data used for analytical purposes have greatly increased. Han constructed GeoMiner [4], a spatial OLAP and data mining system prototype Another proposed study [26] considers a framework for mining association rules from data cubes according to a sum-based aggregate measure, which is more general than frequencies provided by the count measure. The mining process is guided by a meta-rule, is contextdriven by analysis objectives, and exploits aggregate measures to revisit the definitions of support and confidence. These studies profit from the hierarchical aspect of cube dimensions to mine association rules at different levels of granularity, such as spatial and temporal hierarchies

Objectives
Results
Discussion
Conclusion
Full Text
Published version (Free)

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call