Repository logo

Infoscience

  • English
  • French
Log In
Logo EPFL, École polytechnique fédérale de Lausanne

Infoscience

  • English
  • French
Log In
  1. Home
  2. Academic and Research Output
  3. EPFL thesis
  4. Efficient Query Processing for Spatial and Temporal Data Exploration
 
doctoral thesis

Efficient Query Processing for Spatial and Temporal Data Exploration

Tzirita Zacharatou, Eleni  
2019

Core to many scientific and analytics applications are spatial data capturing the position or shape of objects in space, and time series recording the values of a process over time. Effective analysis of such data requires a shift from confirmatory pipelines to exploratory ones. However, there is a mismatch between the requirements of spatial and temporal data exploration and the capabilities of the data management solutions available today. First, traditional spatial query operators evaluate spatial relations with time-consuming geometric tests that oppose the interactivity expected from exploratory applications, creating an undue overhead. Second, spatial access methods are built on top of rough geometric object approximations that do not capture the complex structure and distribution of today's spatial data and are thus inefficient. Third, traditional indexes are typically built upfront before queries can be processed and over single data attributes, thus precluding interactive accesses to interesting data subsets that may be specified with constraints on multiple attributes. Finally, existing access methods scale poorly with increasingly granular spatial and temporal data originating from ever more precise data acquisition technologies and ever faster computing infrastructure.

This thesis introduces a novel family of spatial and temporal access methods and query operators that aim to bridge the gap between existing data management techniques and data exploration applications. We show that spatial query operators can be decomposed into primitive graphics operations that are efficiently executed by graphics hardware (GPU) and allow to trade accuracy for interactivity. Furthermore, we design access methods that adapt to data characteristics, data growth trends, and workload access patterns, thereby providing scalable performance for ad-hoc queries over increasing data amounts. Specifically, we introduce a spatial approximation that adapts to the structural properties and distribution of the data, and propose spatial and time series access methods that leverage similarities between data items and support filtering over multiple attributes. Finally, we present an approach that indexes data incrementally, using queries as hints for optimizing data access.

  • Files
  • Details
  • Metrics
Type
doctoral thesis
DOI
10.5075/epfl-thesis-9637
Author(s)
Tzirita Zacharatou, Eleni  
Advisors
Ailamaki, Anastasia  
Jury

Prof. Aikaterini Argyraki (présidente) ; professeure Anastasia Ailamaki (directeur de thèse) ; Prof. Karl Aberer, Prof. Juliana Freire, Prof. Yannis Ioannidis (rapporteurs)

Date Issued

2019

Publisher

EPFL

Publisher place

Lausanne

Public defense year

2019-08-09

Thesis number

9637

Total of pages

183

Subjects

data management

•

data exploration

•

visual analytics systems

•

scientific data management

•

spatial and temporal data management

•

geospatial joins

•

spatial approximation

•

incremental indexing

•

time series access methods

•

bitmap indexing

EPFL units
DIAS  
Faculty
IC  
School
IINFCOM  
Doctoral School
EDIC  
Available on Infoscience
July 29, 2019
Use this identifier to reference this record
https://infoscience.epfl.ch/handle/20.500.14299/159448
Logo EPFL, École polytechnique fédérale de Lausanne
  • Contact
  • infoscience@epfl.ch

  • Follow us on Facebook
  • Follow us on Instagram
  • Follow us on LinkedIn
  • Follow us on X
  • Follow us on Youtube
AccessibilityLegal noticePrivacy policyCookie settingsEnd User AgreementGet helpFeedback

Infoscience is a service managed and provided by the Library and IT Services of EPFL. © EPFL, tous droits réservés