Abstract
This abstract describes the design of a query optimiser for the object-oriented database P/FDM using Prolog. The translation of a database query into an efficient executable program in many ways resembles a specialised program transformation problem [Fr87]. From a user’s point of view, it is obviously desirable that they can write queries against a database clearly and naturally without concern for efficiency issues. However, queries written in this declarative manner are usually not efficient for execution, therefore a query optimiser becomes necessary in a database system to improve the performance.
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
References
J.C. Freytag, “A Rule-Based View of Query Optimisation”, ppl73-180, ACMSIGMOD 1987.
P.M.D Gray, “Efficient Prolog Access to Codasyl and FDM Databases”, pp 437-443, ACMSIGMOD 1985, S. Navathe (ed.).
P.M.D Gray, “Integration of Databases and Expert Systems Through Prolog”, Proc. Artificial Intelligence Conference, San Sebastian (Spain), Sept. 1987, II World Basque Congress Secretariat, Vitoria-Gasteiz.
Zhuoan Jiao and P.M.D Gray, “Optimisation Of Methods In A Navigational Query Language”, to appear in the Proc. 2nd International Conference on Deductive and Object-Oriented Database Systems, December 1991, Munich, Germany.
N.W. Paton and P.M.D. Gray, “Optimising and Executing Daplex Queries Using Prolog”, The Computer Journal, pp547–556, Vol. 33, No.6, 1990.
D. Shipman, “The Functional Data Model and the Data Language Daplex”, ACM Transactions on DB Systems, 6, 1(March 1981).
D.H. Warren, “Efficient Processing of Interactive Relational Database Queries Expressed in Logic”, Proc. 7th VLDB, 1981.
Carlo Zaniolo, “Prolog: a Database Query Language for All Seasons“, Proc. 1st International Workshop on Expert Database Systems, 1984.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1992 Springer-Verlag London
About this paper
Cite this paper
Jiao, Z., Gray, P.M.D. (1992). Query Optimisation In An Object-Oriented Database Using Prolog. In: Clement, T.P., Lau, KK. (eds) Logic Program Synthesis and Transformation. Workshops in Computing. Springer, London. https://doi.org/10.1007/978-1-4471-3494-7_24
Download citation
DOI: https://doi.org/10.1007/978-1-4471-3494-7_24
Publisher Name: Springer, London
Print ISBN: 978-3-540-19742-3
Online ISBN: 978-1-4471-3494-7
eBook Packages: Springer Book Archive