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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Butler, G., Wang, G., Wang, Y., Zou, L.: A Graph Database with Visual Queries for Genomics. In: Procs. of the 3rd Asia-Pacific Bioinformatics Conf., pp. 31–40 (2005)
Consens, M.P., Eigler, F.C., Hasan, M.Z., Mendelzon, A.O., Noik, E.G., Ryman, A.G., Vista, D.: Architecture & Applications of the Hy+ Visualization System. IBM Systems Journal 33(3), 458–476 (1994)
Ramakrishnan, R., Srivastava, D., Sudarshan, S., Seshadri, P.: The CORAL Deductive System. VLDB Journal 3(2), 161–210 (1994)
Widenjus, M., Axmark, D.: MySQL Reference Manual. O’Reilly, Sebastopol (2002)
Chan, K.C., Trinder, P.W., Welland, R.: Evaluating Object-Oriented Query Languages. The Computer Journal 37(10), 858–872 (1994)
Zou, L.: GraphLog: Its Representation in XML & Translation to CORAL. Masters Thesis. Dept. of Computer Science, Concordia University (2003)
Beeri, C., Ramakrishnan, R.: On the Power of Magic. In: Procs. of the ACM Symp. on Principles of Database Systems, pp. 269–283 (1987)
Ramakrishnam, R.: Magic Templates: A Spellbinding Approach to Logic Programs. In: Procs. of the Intl. Conf. on Logic Programming, pp. 140–159 (1988)
Naughton, J.F., Seshadri, S.: Argument Reduction Through Factoring. In: Procs. of the 15th Intl. Conf. on Very Large Databases, pp. 173–182 (1989)
Ramakrishnan, R., Srivastava, D., Sudarshan, S.: Rule ordering in bottom-up fixpoint evaluation of logic programs. In: Procs of the 16th Intl. Conf. on Very Large Databases, pp. 359–371 (1990)
Wang, G.: Linking CORAL to MySQL & PostgreSQL. Master Thesis. Dept. of Computer Science, Concordia University (2004)
Bancilhon, F., Ramakrishnan, R.: An amateur’s introduction to recursive query processing strategies. In: Procs. of ACM SIGMOD, pp. 16–52 (1986)
Bancilhon, F., Ramakrishnan, R.: Performance evaluation of data intensive logic programs. In: Minker, J. (ed.) Foundations of Deductive Databases & Logic Programming, pp. 439–517. Morgan Kaufmann, San Francisco (1988)
Ceri, S., Gottlob, G., Tanca, L.: What You Always Wanted to Know About Datalog. IEEE Trans. on Knowledge & Data Eng. 1(1), 146–166 (1989)
Giugno, R., Shasha, D.: A Fast & Universal Method for Querying Graphs. In: Proc. of the Intl. Conf. in Pattern Recognition, pp. 112–115 (2002)
Cruz, I.F., Leveille, P.S.: Implementation of a Constraint-Based Visualization System. In: Procs. of IEEE Intl. Symp. on Visual Languages, pp. 13–21 (2000)
Gyssens, M., Paredaens, J., Gutch, D.V.: A graph-oriented object model for database end-user interfaces. In: Procs. of ACM SIGMOD, pp. 24–33 (1990)
Paredaens, J., Peelman, P., Tanca, L.: G-Log: A Declarative Graphical Query Language. In: Procs. of 2nd Intl. Conf. on Deductive & Object–oriented Databases, pp. 108–128 (1991)
Poulovassilis, A., Hild, S.G.: Hyperlog: a graph-based system for database browsing, querying & update. Trans. on Knowledge & Data Eng. 13(2) (2001)
Olston, C.: VIQING: Visual Interactive QueryING. In: Procs. of 4th IEEE Symp. on Visual Languages, pp. 162–169 (1998)
Erwig, M.: XING: a visual XML query language. Journal of Visual Languages & Computing 14, 5–45 (2003)
Ni, W., Ling, T.W.: GLASS: A Graphical Query Language for Semi-Structured Data. In: Procs. of 8th Intl. Conf. on Database Systems for Advanced Applications, pp. 362–369 (2003)
Vista, D., Wood, P.T.: Efficient Evaluation of Visual Queries Using Deductive Databases. In: Workshop on Programming with Logic Databases, pp. 143–161 (1993)
Seshadri, S., Naughton, J.F.: On the expected size of recursive Datalog queries. In: Procs. of ACM Symp. on Principles of Database Systems, pp. 268–279 (1991)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2006 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Butler, G., Wang, G., Wang, Y., Zou, L. (2006). Query Optimization for a Graph Database with Visual Queries. In: Li Lee, M., Tan, KL., Wuwongse, V. (eds) Database Systems for Advanced Applications. DASFAA 2006. Lecture Notes in Computer Science, vol 3882. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11733836_42
Download citation
DOI: https://doi.org/10.1007/11733836_42
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-33337-1
Online ISBN: 978-3-540-33338-8
eBook Packages: Computer ScienceComputer Science (R0)