Translation and Compatibility of SQL and QUEL Queries

概要

論文の詳細を見る
This paper discusses the problem of translating SQL language constructs into QUEL constructs. The main objective of the paper is twofold: 1)to study the semantics and establish the equivalency of basic constructions of SQL and QLEL; and 2)based on the results of 1), develop algorithms to translate SQL queries into equivalent QUEL queries which give the same results as the original ones. SQL queries are classified into two types: nonnested and nested queries. We present two main algorithms to handle the translation for these two types of queries. Given an arbitrary SQL query as an input, the translation algorithms produce a single equivalent QUEL query. The translation algorithms are optimized in distributed or back-end database environments since those algorithms always generate a single target query. Compatibility of the two languages is also discussed. This paper suggests some extension to allow more compatibility for the two languages.
一般社団法人情報処理学会の論文
1985-03-31