Title :
Execution of extended multidatabase SQL
Author :
Suardi, L. ; Rusinkiewicz, M. ; Litwin, W.
Author_Institution :
Dept. of Comput. Sci., Houston Univ., TX, USA
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;
Conference_Titel :
Data Engineering, 1993. Proceedings. Ninth International Conference on
Conference_Location :
Vienna
Print_ISBN :
0-8186-3570-3
DOI :
10.1109/ICDE.1993.344015
