Logo
ScienceStack
Table of Contents
Fetching ...
Sign In

Natural Language Interfaces for Spatial and Temporal Databases: A Comprehensive Overview of Methods, Taxonomy, and Future Directions

Samya Acharja, Kanchan Chowdhury

Abstract

The task of building a natural language interface to a database, known as NLIDB, has recently gained significant attention from both the database and Natural Language Processing (NLP) communities. With the proliferation of geospatial datasets driven by the rapid emergence of location-aware sensors, geospatial databases play a vital role in supporting geospatial applications. However, querying geospatial and temporal databases differs substantially from querying traditional relational databases due to the presence of geospatial topological operators and temporal operators. To bridge the gap between geospatial query languages and non-expert users, the geospatial research community has increasingly focused on developing NLIDBs for geospatial databases. Yet, existing research remains fragmented across systems, datasets, and methodological choices, making it difficult to clearly understand the landscape of existing methods, their strengths and weaknesses, and opportunities for future research. Existing surveys on NLIDBs focus on general-purpose database systems and do not treat geospatial and temporal databases as primary focus for analysis. To address this gap, this paper presents a comprehensive survey of studies on NLIDBs for geospatial and temporal databases. Specifically, we provide a detailed overview of datasets, evaluation metrics, and the taxonomy of the methods for geospatial and temporal NLIDBs, as well as a comparative analysis of the existing methods. Our survey reveals recurring trends in existing methods, substantial variation in datasets and evaluation practices, and several open challenges that continue to hinder progress in this area. Based on these findings, we identify promising directions for future research to advance natural language interfaces to geospatial and temporal databases.

Natural Language Interfaces for Spatial and Temporal Databases: A Comprehensive Overview of Methods, Taxonomy, and Future Directions

Abstract

The task of building a natural language interface to a database, known as NLIDB, has recently gained significant attention from both the database and Natural Language Processing (NLP) communities. With the proliferation of geospatial datasets driven by the rapid emergence of location-aware sensors, geospatial databases play a vital role in supporting geospatial applications. However, querying geospatial and temporal databases differs substantially from querying traditional relational databases due to the presence of geospatial topological operators and temporal operators. To bridge the gap between geospatial query languages and non-expert users, the geospatial research community has increasingly focused on developing NLIDBs for geospatial databases. Yet, existing research remains fragmented across systems, datasets, and methodological choices, making it difficult to clearly understand the landscape of existing methods, their strengths and weaknesses, and opportunities for future research. Existing surveys on NLIDBs focus on general-purpose database systems and do not treat geospatial and temporal databases as primary focus for analysis. To address this gap, this paper presents a comprehensive survey of studies on NLIDBs for geospatial and temporal databases. Specifically, we provide a detailed overview of datasets, evaluation metrics, and the taxonomy of the methods for geospatial and temporal NLIDBs, as well as a comparative analysis of the existing methods. Our survey reveals recurring trends in existing methods, substantial variation in datasets and evaluation practices, and several open challenges that continue to hinder progress in this area. Based on these findings, we identify promising directions for future research to advance natural language interfaces to geospatial and temporal databases.
Paper Structure (38 sections, 4 equations, 6 figures, 8 tables)

This paper contains 38 sections, 4 equations, 6 figures, 8 tables.

Table of Contents

  1. Introduction
  2. Limitations of Existing Surveys
  3. Contributions
  4. Background
  5. General Purpose NLIDBs
  6. ST-NLIDBs
  7. Spatial NLIDBs
  8. Time-Series NLIDBs
  9. Spatiotemporal NLIDBs
  10. Datasets and Evaluation Metrics
  11. Datasets Analysis
  12. Evaluation Metrics
  13. Execution-Based accuracy.
  14. Interpretation / Translation Accuracy.
  15. Precision-Oriented accuracy.
  16. ...and 23 more sections

Figures (6)

  • Figure 1: A sample of the Business relation in Yelp, a sample natural language question with the ground truth SQL query, and 4 queries translated by various NL-2-SQL approaches as well as the output relations for such queries.
  • Figure 2: Unified methodological pipeline for NL interfaces to spatial, spatiotemporal, and time-series databases
  • Figure 3: General flow structure of rule-based and grammar-driven NLIDBs
  • Figure 4: Generic pipeline of neural net and semantic parsing-based hybrid NLIDBs
  • Figure 5: A general illustration of how LLM-prompting approaches generate database queries.
  • ...and 1 more figures