Parameterized view definition and recursive relations

Abstract

The concept of parameterized view definition mechanism for relational database systems is presented. Primarily, it makes a single view definition serving for several different view instances according to the supplied actual parameters. Dynamic binding of parameters for the view allows the definition of recursive relations, such as transitive closure, without using extended operators or procedural constructs such as loops. In this paper, upward compatible syntax for SQL that incorporates view parameterization is proposed.