On materializing views and on-line queries
We consider the problem of traversing a database multiple times treated as solving on-line transitive closure queries. In order to solve such queries more efficiently than with the most basic methods, it is necessary to compute intermediate results that can be shared between queries. However, for on-line queries we assume that the pattern or existence of future queries is unknown which makes the problem of computing the right intermediate results difficult. We show how a technique based on utilizing subtrees of results computed for other queries can be used to solve the problem efficiently.
Unable to display preview. Download preview PDF.
- Aho, A. V., Hopcroft, J. E., Ullman, J. D., The Design and Analysis of Computer Algorithms, Addison-Wesley, Reading, Mass., 1974.Google Scholar
- Bancilhon, F., “Naive evaluation of recursively defined relations,” in On Knowledge Base Management Systems, (M. L. Brodie and J. Mylopoulos, eds.), Springer-Verlag, New York, 1986.Google Scholar
- Bancilhon, F., Maier D., Sagiv, Y., Ullman, J. D., “Magic sets and other strange ways to implement logic programs,” Proc. 5th ACM Symp. on Prociples of Database Sytems, pp. 1–15, 1986.Google Scholar
- Grahne, G., Sippu, S., Soisalon-Soininen, E., “Efficient evaluation for a subset of recursive queries,” Journal of Logic Programming, 10:301–332, 1991.Google Scholar
- Imai, H., Asano, T., “Dynamic orthogonal segment intersection search,” J. Algorithms 8, pp 1–18, 1987.Google Scholar
- Jakobsson, H., “On tree-based techniques for query evaluation,” to appear in Proc. 11th ACM Symposium on Priciples of Database Systems, San Diego, California, 1992.Google Scholar
- Jiang, B., “A suitable algorithm for computing partial transitive closures in databases,” Proc. of the IEEE Intl. Conf. on Data Engineering, pp 264–271, 1990.Google Scholar
- Kemp, D. B., Ramamohanarao, K., Somogyi, Z., “Right-, left-, and multilinear rule transformations that maintain context information,” Proc. 16th Intl. Conf. on Very Large Databases, 1990.Google Scholar
- Mumick, I. S., Pirahesh, H., “Extending the right-linear transformation,” Research report RJ 7938, IBM Research Division, 1991.Google Scholar
- Mumick, I. S., Pirahesh, E., “Overbound and right-linear queries,” Proc. 10th ACM Symposium on Principles of Database Systems, pp 127–141, 1991.Google Scholar
- Naughton, J. F., Ramakrishnan, R., Sagiv, Y., Ullman, J. D., “Efficient evaluation of right-left-, and multilinear rules,” Proc. ACM SIGMOD, 1989.Google Scholar
- Purdom, P., “A transitive closure algorithm,” BIT 10 pp. 76–94, 1970.Google Scholar
- Stiefeling, H., “Evaluation Strategies for a subclass of recursive database queries,” PhD thesis, Universität Hildesheim, 1991.Google Scholar