Lecture Notes in Computer Science, 1998, Volume 1475/1998, 328-338, DOI: 10.1007/BFb0057744

Translating relational queries to object-oriented queries according to ODMG-93

Ahmed Mostefaoui and Jacques Kouloumdjian

View Related Documents

Abstract

With the advent of object-oriented database systems there is a need to migrate/integrate old systems, mainly relational ones, to/into object-oriented systems. In this paper we propose a method to automatically translate SQL queries to OQL ones. The method is based on a graph representation of SQL queries. This graph is enriched and transformed in a series of stages which take into account the caracteristics of the object schema with respect to the relational one (new entity type, ISA relationship, class hierarchy, etc.). This semantic enrichment allows an optimized translation of the SQL queries compared with a purely syntaxic translation.

Fulltext Preview

Image of the first page of the fulltext document