Management of Complex and Fuzzy Queries Using a Fuzzy SOLAP-Based Framework

Sinan Keskin; Adnan Yazıcı

doi:10.1007/978-3-030-86967-0_9

Management of Complex and Fuzzy Queries Using a Fuzzy SOLAP-Based Framework

Sinan Keskin
, Adnan Yazıcı

Middle East Technical University

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution

1 Citation (Scopus)

Abstract

With the use of data warehouses, the need for faster access and analysis to historical and multidimensional data has arisen. Online analytical processing (OLAP), developed for this purpose, has provided suitable data structures that overcome some of the limitations of relational databases by providing rapid data analysis. OLAP can display and collect large amounts of data while providing searchable access to any data point and handle a wide variety of complex queries that match user interests. While OLAP enables querying and analysis of multidimensional numeric and alphanumeric data, there is still a need to support flexible queries and analyses on uncertain and fuzzy data due to the nature of the data existing the complex applications such as multimedia and spatiotemporal applications. This study presents how to handle various types of fuzzy spatiotemporal queries using our fuzzy SOLAP (spatial OLAP) based framework on meteorological databases, which inherently contain spatiotemporal data in addition to uncertainty and fuzziness. In this context, we describe the support for non-spatial and fuzzy spatial queries as well as fuzzy spatiotemporal query types. In addition, while OLAP mainly includes historical data and associated queries and analyzes, we describe how to handle predictive fuzzy spatiotemporal queries, which may require an inference mechanism. We also show that various complex queries, including predictive fuzzy spatiotemporal queries, are effectively and efficiently handled using our fuzzy SOLAP framework.

Original language	English
Title of host publication	Flexible Query Answering Systems - 14th International Conference, FQAS 2021, Proceedings
Editors	Troels Andreasen, Guy De Tré, Janusz Kacprzyk, Henrik Legind Larsen, Gloria Bordogna, Sławomir Zadrożny
Publisher	Springer Science and Business Media Deutschland GmbH
Pages	109-126
Number of pages	18
ISBN (Print)	9783030869663
DOIs	https://doi.org/10.1007/978-3-030-86967-0_9
Publication status	Published - 2021
Event	14th International Conference on Flexible Query Answering Systems, FQAS 2021 - Bratislava, Slovakia Duration: Sept 19 2021 → Sept 24 2021

Publication series

Name	Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Volume	12871 LNAI
ISSN (Print)	0302-9743
ISSN (Electronic)	1611-3349

Conference

Conference	14th International Conference on Flexible Query Answering Systems, FQAS 2021
Country/Territory	Slovakia
City	Bratislava
Period	9/19/21 → 9/24/21

Funding

Keywords: OLAP · Fuzzy spatial-temporal query · Predictive fuzzy spatial-temporal query This study is supported in part by NU Faculty Development Competitive Research Grants Program, Nazarbayev University, Republic of Kazakhstan, under Grant Number 110119FD4543.

Keywords

Fuzzy spatial-temporal query
OLAP
Predictive fuzzy spatial-temporal query

ASJC Scopus subject areas

Theoretical Computer Science
General Computer Science

Access to Document

10.1007/978-3-030-86967-0_9

Cite this

Keskin, S., & Yazıcı, A. (2021). Management of Complex and Fuzzy Queries Using a Fuzzy SOLAP-Based Framework. In T. Andreasen, G. De Tré, J. Kacprzyk, H. Legind Larsen, G. Bordogna, & S. Zadrożny (Eds.), Flexible Query Answering Systems - 14th International Conference, FQAS 2021, Proceedings (pp. 109-126). (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 12871 LNAI). Springer Science and Business Media Deutschland GmbH. https://doi.org/10.1007/978-3-030-86967-0_9

Management of Complex and Fuzzy Queries Using a Fuzzy SOLAP-Based Framework. / Keskin, Sinan; Yazıcı, Adnan.
Flexible Query Answering Systems - 14th International Conference, FQAS 2021, Proceedings. ed. / Troels Andreasen; Guy De Tré; Janusz Kacprzyk; Henrik Legind Larsen; Gloria Bordogna; Sławomir Zadrożny. Springer Science and Business Media Deutschland GmbH, 2021. p. 109-126 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 12871 LNAI).

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution

Keskin, S & Yazıcı, A 2021, Management of Complex and Fuzzy Queries Using a Fuzzy SOLAP-Based Framework. in T Andreasen, G De Tré, J Kacprzyk, H Legind Larsen, G Bordogna & S Zadrożny (eds), Flexible Query Answering Systems - 14th International Conference, FQAS 2021, Proceedings. Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), vol. 12871 LNAI, Springer Science and Business Media Deutschland GmbH, pp. 109-126, 14th International Conference on Flexible Query Answering Systems, FQAS 2021, Bratislava, Slovakia, 9/19/21. https://doi.org/10.1007/978-3-030-86967-0_9

Keskin S, Yazıcı A. Management of Complex and Fuzzy Queries Using a Fuzzy SOLAP-Based Framework. In Andreasen T, De Tré G, Kacprzyk J, Legind Larsen H, Bordogna G, Zadrożny S, editors, Flexible Query Answering Systems - 14th International Conference, FQAS 2021, Proceedings. Springer Science and Business Media Deutschland GmbH. 2021. p. 109-126. (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)). doi: 10.1007/978-3-030-86967-0_9

Keskin, Sinan ; Yazıcı, Adnan. / Management of Complex and Fuzzy Queries Using a Fuzzy SOLAP-Based Framework. Flexible Query Answering Systems - 14th International Conference, FQAS 2021, Proceedings. editor / Troels Andreasen ; Guy De Tré ; Janusz Kacprzyk ; Henrik Legind Larsen ; Gloria Bordogna ; Sławomir Zadrożny. Springer Science and Business Media Deutschland GmbH, 2021. pp. 109-126 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)).

@inproceedings{5b7e4ae3bd26430eb37eb6e529f49c8d,

title = "Management of Complex and Fuzzy Queries Using a Fuzzy SOLAP-Based Framework",

abstract = "With the use of data warehouses, the need for faster access and analysis to historical and multidimensional data has arisen. Online analytical processing (OLAP), developed for this purpose, has provided suitable data structures that overcome some of the limitations of relational databases by providing rapid data analysis. OLAP can display and collect large amounts of data while providing searchable access to any data point and handle a wide variety of complex queries that match user interests. While OLAP enables querying and analysis of multidimensional numeric and alphanumeric data, there is still a need to support flexible queries and analyses on uncertain and fuzzy data due to the nature of the data existing the complex applications such as multimedia and spatiotemporal applications. This study presents how to handle various types of fuzzy spatiotemporal queries using our fuzzy SOLAP (spatial OLAP) based framework on meteorological databases, which inherently contain spatiotemporal data in addition to uncertainty and fuzziness. In this context, we describe the support for non-spatial and fuzzy spatial queries as well as fuzzy spatiotemporal query types. In addition, while OLAP mainly includes historical data and associated queries and analyzes, we describe how to handle predictive fuzzy spatiotemporal queries, which may require an inference mechanism. We also show that various complex queries, including predictive fuzzy spatiotemporal queries, are effectively and efficiently handled using our fuzzy SOLAP framework.",

keywords = "Fuzzy spatial-temporal query, OLAP, Predictive fuzzy spatial-temporal query",

author = "Sinan Keskin and Adnan Yazıcı",

note = "Funding Information: Keywords: OLAP · Fuzzy spatial-temporal query · Predictive fuzzy spatial-temporal query This study is supported in part by NU Faculty Development Competitive Research Grants Program, Nazarbayev University, Republic of Kazakhstan, under Grant Number 110119FD4543. Publisher Copyright: {\textcopyright} 2021, Springer Nature Switzerland AG.; 14th International Conference on Flexible Query Answering Systems, FQAS 2021 ; Conference date: 19-09-2021 Through 24-09-2021",

year = "2021",

doi = "10.1007/978-3-030-86967-0\_9",

language = "English",

isbn = "9783030869663",

series = "Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)",

publisher = "Springer Science and Business Media Deutschland GmbH",

pages = "109--126",

editor = "Troels Andreasen and \{De Tr{\'e}\}, Guy and Janusz Kacprzyk and \{Legind Larsen\}, Henrik and Gloria Bordogna and S{\l}awomir Zadro{\.z}ny",

booktitle = "Flexible Query Answering Systems - 14th International Conference, FQAS 2021, Proceedings",

address = "Germany",

}

TY - GEN

T1 - Management of Complex and Fuzzy Queries Using a Fuzzy SOLAP-Based Framework

AU - Keskin, Sinan

AU - Yazıcı, Adnan

N1 - Funding Information: Keywords: OLAP · Fuzzy spatial-temporal query · Predictive fuzzy spatial-temporal query This study is supported in part by NU Faculty Development Competitive Research Grants Program, Nazarbayev University, Republic of Kazakhstan, under Grant Number 110119FD4543. Publisher Copyright: © 2021, Springer Nature Switzerland AG.

PY - 2021

Y1 - 2021

N2 - With the use of data warehouses, the need for faster access and analysis to historical and multidimensional data has arisen. Online analytical processing (OLAP), developed for this purpose, has provided suitable data structures that overcome some of the limitations of relational databases by providing rapid data analysis. OLAP can display and collect large amounts of data while providing searchable access to any data point and handle a wide variety of complex queries that match user interests. While OLAP enables querying and analysis of multidimensional numeric and alphanumeric data, there is still a need to support flexible queries and analyses on uncertain and fuzzy data due to the nature of the data existing the complex applications such as multimedia and spatiotemporal applications. This study presents how to handle various types of fuzzy spatiotemporal queries using our fuzzy SOLAP (spatial OLAP) based framework on meteorological databases, which inherently contain spatiotemporal data in addition to uncertainty and fuzziness. In this context, we describe the support for non-spatial and fuzzy spatial queries as well as fuzzy spatiotemporal query types. In addition, while OLAP mainly includes historical data and associated queries and analyzes, we describe how to handle predictive fuzzy spatiotemporal queries, which may require an inference mechanism. We also show that various complex queries, including predictive fuzzy spatiotemporal queries, are effectively and efficiently handled using our fuzzy SOLAP framework.

AB - With the use of data warehouses, the need for faster access and analysis to historical and multidimensional data has arisen. Online analytical processing (OLAP), developed for this purpose, has provided suitable data structures that overcome some of the limitations of relational databases by providing rapid data analysis. OLAP can display and collect large amounts of data while providing searchable access to any data point and handle a wide variety of complex queries that match user interests. While OLAP enables querying and analysis of multidimensional numeric and alphanumeric data, there is still a need to support flexible queries and analyses on uncertain and fuzzy data due to the nature of the data existing the complex applications such as multimedia and spatiotemporal applications. This study presents how to handle various types of fuzzy spatiotemporal queries using our fuzzy SOLAP (spatial OLAP) based framework on meteorological databases, which inherently contain spatiotemporal data in addition to uncertainty and fuzziness. In this context, we describe the support for non-spatial and fuzzy spatial queries as well as fuzzy spatiotemporal query types. In addition, while OLAP mainly includes historical data and associated queries and analyzes, we describe how to handle predictive fuzzy spatiotemporal queries, which may require an inference mechanism. We also show that various complex queries, including predictive fuzzy spatiotemporal queries, are effectively and efficiently handled using our fuzzy SOLAP framework.

KW - Fuzzy spatial-temporal query

KW - OLAP

KW - Predictive fuzzy spatial-temporal query

UR - https://www.scopus.com/pages/publications/85115855731

UR - https://www.scopus.com/pages/publications/85115855731#tab=citedBy

U2 - 10.1007/978-3-030-86967-0_9

DO - 10.1007/978-3-030-86967-0_9

M3 - Conference contribution

AN - SCOPUS:85115855731

SN - 9783030869663

T3 - Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

SP - 109

EP - 126

BT - Flexible Query Answering Systems - 14th International Conference, FQAS 2021, Proceedings

A2 - Andreasen, Troels

A2 - De Tré, Guy

A2 - Kacprzyk, Janusz

A2 - Legind Larsen, Henrik

A2 - Bordogna, Gloria

A2 - Zadrożny, Sławomir

PB - Springer Science and Business Media Deutschland GmbH

T2 - 14th International Conference on Flexible Query Answering Systems, FQAS 2021

Y2 - 19 September 2021 through 24 September 2021

ER -

Management of Complex and Fuzzy Queries Using a Fuzzy SOLAP-Based Framework

Abstract

Publication series

Conference

Funding

Keywords

ASJC Scopus subject areas

Access to Document

Other files and links

Fingerprint

Cite this