Execution of extended multidatabase SQL

Author

Suardi, L. ; Rusinkiewicz, M. ; Litwin, W.

Author_Institution

Dept. of Comput. Sci., Houston Univ., TX, USA

fYear

1993

fDate

19-23 Apr 1993

Firstpage

641

Lastpage

650

Abstract

The multidatabase structured query language (MSQL) is an extension of the SQL query language that provides new functions for nonprocedural manipulation of data in different and mutually non-integrated relational databases. The problems introduced by these new functions are discussed, and the semantics of multiple updates, global commitment, and rollback are analyzed. New language constructs are developed to allow declarative specification of multidatabase transactions. The design and implementation of an environment for the execution of extended MSQL queries in a heterogeneous multidatabase environment are also discussed

Keywords

SQL; distributed databases; formal specification; query languages; relational databases; transaction processing; declarative specification; extended multidatabase SQL; global commitment; heterogeneous multidatabase environment; multidatabase transactions; multiple updates; mutually non-integrated relational databases; rollback; Application software; Computer network management; Computer science; Control systems; Database languages; Database systems; Environmental management; Relational databases; Spatial databases; Transaction databases;

fLanguage

English

Publisher

ieee

Conference_Titel

Data Engineering, 1993. Proceedings. Ninth International Conference on

Conference_Location

Vienna

Print_ISBN

0-8186-3570-3

Type

conf

DOI

10.1109/ICDE.1993.344015

Filename

344015