Parameterized view definition and recursive relations

Motomichi Toyama

doi:10.1109/ICDE.1986.7266282

Parameterized view definition and recursive relations

Motomichi Toyama

Department of Information and Computer Science

Research output: Contribution to journal › Conference article › peer-review

6 Citations (Scopus)

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.

Original language	English
Article number	7266282
Pages (from-to)	707-712
Number of pages	6
Journal	Proceedings - International Conference on Data Engineering
Volume	2015-January
DOIs	https://doi.org/10.1109/ICDE.1986.7266282
Publication status	Published - 1986 Jan 1
Event	2nd IEEE International Conference on Data Engineering, COMPDEC 1986 - Los Angeles, United States Duration: 1986 Feb 5 → 1986 Feb 7

ASJC Scopus subject areas

Software
Signal Processing
Information Systems

Access to Document

10.1109/ICDE.1986.7266282

Cite this

@article{b0e6df39dbc64f43aa883a66c1f79ccb,

title = "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.",

author = "Motomichi Toyama",

year = "1986",

month = jan,

day = "1",

doi = "10.1109/ICDE.1986.7266282",

language = "English",

volume = "2015-January",

pages = "707--712",

journal = "Proceedings - International Conference on Data Engineering",

issn = "1084-4627",

publisher = "Institute of Electrical and Electronics Engineers Inc.",

note = "2nd IEEE International Conference on Data Engineering, COMPDEC 1986 ; Conference date: 05-02-1986 Through 07-02-1986",

}

TY - JOUR

T1 - Parameterized view definition and recursive relations

AU - Toyama, Motomichi

PY - 1986/1/1

Y1 - 1986/1/1

N2 - 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.

AB - 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.

UR - http://www.scopus.com/inward/record.url?scp=0022582342&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=0022582342&partnerID=8YFLogxK

U2 - 10.1109/ICDE.1986.7266282

DO - 10.1109/ICDE.1986.7266282

M3 - Conference article

AN - SCOPUS:0022582342

SN - 1084-4627

VL - 2015-January

SP - 707

EP - 712

JO - Proceedings - International Conference on Data Engineering

JF - Proceedings - International Conference on Data Engineering

M1 - 7266282

T2 - 2nd IEEE International Conference on Data Engineering, COMPDEC 1986

Y2 - 5 February 1986 through 7 February 1986

ER -

Parameterized view definition and recursive relations

Abstract

ASJC Scopus subject areas

Access to Document

Other files and links

Fingerprint

Cite this