Some performance results on recursive query processing in relational database systems

Jiawei Han, Hongjun Lu

Research output: Contribution to journalConference articlepeer-review

Abstract

The processing of recursive queries in relational database systems poses a great challenge in research on expert database systems. This paper uses both analytical and experimental methods to investigate the performance of several different algorithms in processing a recursive query in first-order recursive databases. The analytical method estimated the I/O and CPU cost and the storage needed in processing recursive queries. The experimental tests were performed on a synthetic relational database built on top of WISS (Wisconsin Storage System) on VAX 11/750. Both analytical and experimental results indicate that for efficient recursive database processing it is important to apply the following heuristics: Performing selection first, making use of wavefront relations, and grouping those joins which reduce the size of intermediate results. The termination conditions for recursive queries are also discussed in the paper.

Original languageEnglish (US)
Article number7266260
Pages (from-to)533-541
Number of pages9
JournalProceedings - International Conference on Data Engineering
Volume2015-January
DOIs
StatePublished - Jan 1 1986
Externally publishedYes
Event2nd IEEE International Conference on Data Engineering, COMPDEC 1986 - Los Angeles, United States
Duration: Feb 5 1986Feb 7 1986

ASJC Scopus subject areas

  • Software
  • Signal Processing
  • Information Systems

Fingerprint

Dive into the research topics of 'Some performance results on recursive query processing in relational database systems'. Together they form a unique fingerprint.

Cite this