Abstract
Conventional Data Base Management Systems (DBMSs) are not generally effective for applications such as geographic data processing where data have spatial characteristics and queries involve on spatial relationships. These DBMSs can however be extended by supplementing them with special processing subsystems and new indexing structures and by augmenting the query interface language. DBMSs supporting an SQL interface are now widely used. The GEOgraphic Query Language (GEOQL) [18] is an extension of SQL proposed for geographic applications and supports both spatial and aspatial operations. In this paper, we propose a global optimization strategy for the hybrid queries so that a general query involving both spatial and aspatial selection can be executed efficiently. We show that the method is feasible.
Preview
Unable to display preview. Download preview PDF.
References
D. J. Abel and J. L. Smith, “A Kernell-Shell Approach to an Extended Relational Spatial Database Management System”, Unpublished paper, CSIRO Canberra, 1987.
D. S. Batory and M. Mannino, “Panel on Extensible Database Systems”, Proc. ACM SIGMOD Int. Conf. on Management of Data, Washington D.C., May 1986, 187–190.
F. W. Burton, V. J. Kollias and J. G. Kollias, “Permutation Backtracking in Lexicographic Order”, The Computer Journal 27, 4 (1984), 373–376.
S. Christodoulakis, “Implications of certain assumptions in database performance evaluation”, ACM Transactions on Database Systems 9, 2 (June 1984), 163–186.
M. C. Er, “An efficient implementation of permutation backtracking in lexicographic order”, The Computer Journal 30, 3 (1987).
J. C. Freytag, “A rule-based view of query optimization”, Proceedings of SIGMOD '87, San Francisco, California, May 1987, 173–180.
R. A. Ganski and H. K. T. Wong, “Optimization of nested SQL queries revisited”, Proceedings of SIGMOD '87, San Francisco, California, May 1987, 23–33.
G. Graefe and D. J. DeWitt, “The EXODUS optimizer generator”, Proceedings of SIGMOD '87, San Francisco, California, May 1987, 160–172.
P. A. V. Hall, “Optimization of single expressions in a relational data base system”, IBM Journal of Research and Development 20, 3 (May 1976), 244–257.
M. Jarke and J. Koch, “Query optimization in database systems”, ACM Computing Surveys 16, 2 (June 1984), 111–152.
W. Kim, “On optimizing an SQL-like nested query”, ACM Transactions on Database Systems 7, 3 (September 1982), 443–469.
K. J. McDonell, “An overview of the relational test bed (RTB)”, Technical Report 81, Dept. Comp. Sci., Monash University, Vic., Australia, 1986.
B. C. Ooi, K. J. McDonell and R. Sacks-Davis, “Spatial kd-tree: an indexing mechanism for spatial database”, Proceedings of the Eleventh IEEE Computer Software and Applications Conference, Tokyo, Japan, October 1987, 433–438.
B. C. Ooi, “Efficient Query Processing for Geographic Information Systems”, PhD Thesis, Monash University, 1988.
J. A. Orenstein and F. A. Manola, “PROBE spatial data modelling and query processing in an image database application”, IEEE Trans. on Softw. Eng. 14, 5 (1988), 611–629.
P. Richard, “Evaluation of the size of a query expressed in relational algebra”, Proc. ACM SIGMOD Int. Conf. on Management of Data, New York, April 1981, 155–163.
N. Roussopoulos, C. Faloutsos and T. K. Sellis, “An efficient pictorial database system for PSQL”, IEEE Trans. on Softw. Eng. 14, 5 (1988), 639–650.
R. Sacks-Davis, K. J. McDonell and B. C. Ooi, GEOQL — a query language for geographic information systems, Royal Melbourne Institute of Technology, Melbourne, Australia, July 1987.
R. Sedgewick, “Permutation generation methods”, ACM Computing Surveys 9, 2 (June 1977), 137–164.
E. Wong and K. Youssefi, “Decomposition — a strategy for query processing”, ACM Transactions on Database Systems 1 (1976), 223–241.
S. B. Yao, “Optimization of query evaluation algorithms”, ACM Transactions on Database Systems 4, 2 (June 1979), 133–155.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1989 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Ooi, B.C., Sacks-Davis, R. (1989). Query optimization in an extended DBMS. In: Litwin, W., Schek, HJ. (eds) Foundations of Data Organization and Algorithms. FODO 1989. Lecture Notes in Computer Science, vol 367. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-51295-0_118
Download citation
DOI: https://doi.org/10.1007/3-540-51295-0_118
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-51295-0
Online ISBN: 978-3-540-46186-9
eBook Packages: Springer Book Archive