Query optimization for a graph database with visual queries

  • Authors:
  • Greg Butler;Guang Wang;Yue Wang;Liqian Zou

  • Affiliations:
  • Department of Computer Science and Software Engineering, Concordia University, Montréal, Québec, Canada;Department of Computer Science and Software Engineering, Concordia University, Montréal, Québec, Canada;Department of Computer Science and Software Engineering, Concordia University, Montréal, Québec, Canada;Department of Computer Science and Software Engineering, Concordia University, Montréal, Québec, Canada

  • Venue:
  • DASFAA'06 Proceedings of the 11th international conference on Database Systems for Advanced Applications
  • Year:
  • 2006

Quantified Score

Hi-index 0.00

Visualization

Abstract

We have constructed a graph database system where a query can be expressed intuitively as a diagram. The query result is also visualized as a diagram based on the intrinsic relationship among the returned data. In this database system, CORAL plays the role of a query execution engine to evaluate queries and deduce results. In order to understand the effectiveness of CORAL optimization techniques on visual query processing.We present and analyze the performance and scalability of CORAL's query rewriting strategies, which include Supplementary Magic Templates, Magic Templates, Context Factoring, Naïve Backtracking, and Without Rewriting method. Our research surprisingly shows that the Without Rewriting method takes the minimum total time to process the benchmark queries. Furthermore, CORAL's default optimization method Supplementary Magic Templates is not uniformly the best choice for every query. The “optimization” of visual queries is beneficial if one could select the right optimization approach for each query.