A generic database indexing framework for large-scale geographic knowledge graphs

Yuhan Sun, Mohamed Elsayed

Research output: Chapter in Book/Report/Conference proceedingConference contribution

1 Citation (Scopus)

Abstract

The paper proposes Riso-Tree, a generic indexing framework for geographic knowledge graphs. Riso-Tree enables fast execution of graph queries that involve spatial predicates (aka. GraSp). The proposed framework augments the classic R-Tree structure with pre-materialized sub-graph entries. Riso-Tree first partitions the graph into sub-graphs based on their connectivity to the spatial sub-regions. The proposed index allows for fast execution of GraSp queries by efficiently pruning the traversed vertexes/edges based upon the materialized sub-graph information. The experiments show that the proposed Riso-Tree achieves up to two orders magnitude faster execution time than its counterparts when executing GraSp queries on real knowledge graphs (e.g., WikiData).

Original languageEnglish (US)
Title of host publication26th ACM SIGSPATIAL International Conference on Advances in Geographic Information Systems, ACM SIGSPATIAL GIS 2018
EditorsLi Xiong, Roberto Tamassia, Kashani Farnoush Banaei, Ralf Hartmut Guting, Erik Hoel
PublisherAssociation for Computing Machinery
Pages289-298
Number of pages10
ISBN (Electronic)9781450358897
DOIs
StatePublished - Nov 6 2018
Event26th ACM SIGSPATIAL International Conference on Advances in Geographic Information Systems, ACM SIGSPATIAL GIS 2018 - Seattle, United States
Duration: Nov 6 2018Nov 9 2018

Other

Other26th ACM SIGSPATIAL International Conference on Advances in Geographic Information Systems, ACM SIGSPATIAL GIS 2018
CountryUnited States
CitySeattle
Period11/6/1811/9/18

Fingerprint

Indexing
Subgraph
Query
Graph in graph theory
Experiments
R-tree
pruning
Tree Structure
Pruning
Predicate
Execution Time
connectivity
Connectivity
Partition
Knowledge
Framework
Experiment
experiment

Keywords

  • GeoSpatial Knowledge Graph
  • Range query
  • Spatial index

ASJC Scopus subject areas

  • Earth-Surface Processes
  • Computer Science Applications
  • Modeling and Simulation
  • Computer Graphics and Computer-Aided Design
  • Information Systems

Cite this

Sun, Y., & Elsayed, M. (2018). A generic database indexing framework for large-scale geographic knowledge graphs. In L. Xiong, R. Tamassia, K. F. Banaei, R. H. Guting, & E. Hoel (Eds.), 26th ACM SIGSPATIAL International Conference on Advances in Geographic Information Systems, ACM SIGSPATIAL GIS 2018 (pp. 289-298). Association for Computing Machinery. https://doi.org/10.1145/3274895.3274966

A generic database indexing framework for large-scale geographic knowledge graphs. / Sun, Yuhan; Elsayed, Mohamed.

26th ACM SIGSPATIAL International Conference on Advances in Geographic Information Systems, ACM SIGSPATIAL GIS 2018. ed. / Li Xiong; Roberto Tamassia; Kashani Farnoush Banaei; Ralf Hartmut Guting; Erik Hoel. Association for Computing Machinery, 2018. p. 289-298.

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Sun, Y & Elsayed, M 2018, A generic database indexing framework for large-scale geographic knowledge graphs. in L Xiong, R Tamassia, KF Banaei, RH Guting & E Hoel (eds), 26th ACM SIGSPATIAL International Conference on Advances in Geographic Information Systems, ACM SIGSPATIAL GIS 2018. Association for Computing Machinery, pp. 289-298, 26th ACM SIGSPATIAL International Conference on Advances in Geographic Information Systems, ACM SIGSPATIAL GIS 2018, Seattle, United States, 11/6/18. https://doi.org/10.1145/3274895.3274966
Sun Y, Elsayed M. A generic database indexing framework for large-scale geographic knowledge graphs. In Xiong L, Tamassia R, Banaei KF, Guting RH, Hoel E, editors, 26th ACM SIGSPATIAL International Conference on Advances in Geographic Information Systems, ACM SIGSPATIAL GIS 2018. Association for Computing Machinery. 2018. p. 289-298 https://doi.org/10.1145/3274895.3274966
Sun, Yuhan ; Elsayed, Mohamed. / A generic database indexing framework for large-scale geographic knowledge graphs. 26th ACM SIGSPATIAL International Conference on Advances in Geographic Information Systems, ACM SIGSPATIAL GIS 2018. editor / Li Xiong ; Roberto Tamassia ; Kashani Farnoush Banaei ; Ralf Hartmut Guting ; Erik Hoel. Association for Computing Machinery, 2018. pp. 289-298
@inproceedings{5ecfec725c6942829528a7a237ec848d,
title = "A generic database indexing framework for large-scale geographic knowledge graphs",
abstract = "The paper proposes Riso-Tree, a generic indexing framework for geographic knowledge graphs. Riso-Tree enables fast execution of graph queries that involve spatial predicates (aka. GraSp). The proposed framework augments the classic R-Tree structure with pre-materialized sub-graph entries. Riso-Tree first partitions the graph into sub-graphs based on their connectivity to the spatial sub-regions. The proposed index allows for fast execution of GraSp queries by efficiently pruning the traversed vertexes/edges based upon the materialized sub-graph information. The experiments show that the proposed Riso-Tree achieves up to two orders magnitude faster execution time than its counterparts when executing GraSp queries on real knowledge graphs (e.g., WikiData).",
keywords = "GeoSpatial Knowledge Graph, Range query, Spatial index",
author = "Yuhan Sun and Mohamed Elsayed",
year = "2018",
month = "11",
day = "6",
doi = "10.1145/3274895.3274966",
language = "English (US)",
pages = "289--298",
editor = "Li Xiong and Roberto Tamassia and Banaei, {Kashani Farnoush} and Guting, {Ralf Hartmut} and Erik Hoel",
booktitle = "26th ACM SIGSPATIAL International Conference on Advances in Geographic Information Systems, ACM SIGSPATIAL GIS 2018",
publisher = "Association for Computing Machinery",

}

TY - GEN

T1 - A generic database indexing framework for large-scale geographic knowledge graphs

AU - Sun, Yuhan

AU - Elsayed, Mohamed

PY - 2018/11/6

Y1 - 2018/11/6

N2 - The paper proposes Riso-Tree, a generic indexing framework for geographic knowledge graphs. Riso-Tree enables fast execution of graph queries that involve spatial predicates (aka. GraSp). The proposed framework augments the classic R-Tree structure with pre-materialized sub-graph entries. Riso-Tree first partitions the graph into sub-graphs based on their connectivity to the spatial sub-regions. The proposed index allows for fast execution of GraSp queries by efficiently pruning the traversed vertexes/edges based upon the materialized sub-graph information. The experiments show that the proposed Riso-Tree achieves up to two orders magnitude faster execution time than its counterparts when executing GraSp queries on real knowledge graphs (e.g., WikiData).

AB - The paper proposes Riso-Tree, a generic indexing framework for geographic knowledge graphs. Riso-Tree enables fast execution of graph queries that involve spatial predicates (aka. GraSp). The proposed framework augments the classic R-Tree structure with pre-materialized sub-graph entries. Riso-Tree first partitions the graph into sub-graphs based on their connectivity to the spatial sub-regions. The proposed index allows for fast execution of GraSp queries by efficiently pruning the traversed vertexes/edges based upon the materialized sub-graph information. The experiments show that the proposed Riso-Tree achieves up to two orders magnitude faster execution time than its counterparts when executing GraSp queries on real knowledge graphs (e.g., WikiData).

KW - GeoSpatial Knowledge Graph

KW - Range query

KW - Spatial index

UR - http://www.scopus.com/inward/record.url?scp=85058644020&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=85058644020&partnerID=8YFLogxK

U2 - 10.1145/3274895.3274966

DO - 10.1145/3274895.3274966

M3 - Conference contribution

AN - SCOPUS:85058644020

SP - 289

EP - 298

BT - 26th ACM SIGSPATIAL International Conference on Advances in Geographic Information Systems, ACM SIGSPATIAL GIS 2018

A2 - Xiong, Li

A2 - Tamassia, Roberto

A2 - Banaei, Kashani Farnoush

A2 - Guting, Ralf Hartmut

A2 - Hoel, Erik

PB - Association for Computing Machinery

ER -