Abstract
In literature on query optimization the normal form for relational algebra expressions consisting of Projection, Selection and Join, is well known. In this paper we extend this normal form with Calculation and Union and define a corresponding language UPCSJL. In addition we show how the normal form can be used for query optimization.
Preview
Unable to display preview. Download preview PDF.
References
van Denneheuvel, S., Kwast K. & Renardel de Lavalette G. R., A normal form for PCSJ expressions, Computing Science in the Netherlands, Nov 1990, 109–120, (1990).
Larson, P.A., Yang, H.Z., Computing Queries from Derived Relations, Proc. of the 11th Intl. Conf. on VLDB, 259–269, (1985).
Ullman, J.D., Principles of Data and Knowledge — Base Systems, Volume II: The New Technologies, Computer Science Press, (1989).
van Emde Boas, P., RL, a Language for Enhanced Rule Bases Database Processing, Working Document, Rep IBM Research, RJ 4869 (51299), (1986).
van Emde Boas, P., A semantical model for the integration and modularization of rules, Proceedings MFCS 12, Bratislava, LNCS 233, 78–92, (1986).
van Emde Boas, H. & van Emde Boas, P., Storing and Evaluating Horn-Clause Rules in a Relational Database, IBM J. Res. Develop. 30 (1), 80–92, (1986).
Yang, H. Z., Larson, P. A., Query Transformations for PSJ-queries, Proc. of the 13th Int. Conf. on VLDB, Brighton, 245–254, (1987).
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1991 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
van Denneheuvel, S., Kwast, K., Renardel de Lavalette, G.R., Spaan, E. (1991). Query optimization using rewrite rules. In: Book, R.V. (eds) Rewriting Techniques and Applications. RTA 1991. Lecture Notes in Computer Science, vol 488. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-53904-2_101
Download citation
DOI: https://doi.org/10.1007/3-540-53904-2_101
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-53904-9
Online ISBN: 978-3-540-46383-2
eBook Packages: Springer Book Archive