Abstract.
This paper presents an approach to object view management for relational databases. Such a view mechanism makes it possible for users to transparently work with data in a relational database as if it was stored in an object-oriented (OO) database. A query against the object view is translated to one or several queries against the relational database. The results of these queries are then processed to form an answer to the initial query. The approach is not restricted to a ‘pure’ object view mechanism for the relational data, since the object view can also store its own data and methods. Therefore it must be possible to process queries that combine local data residing in the object view with data retrieved from the relational database. We discuss the key issues when object views of relational databases are developed, namely: how to map relational structures to sub-type/supertype hierarchies in the view, how to represent relational database access in OO query plans, how to provide the concept of object identity in the view, how to handle the fact that the extension of types in the view depends on the state of the relational database, and how to process and optimize queries against the object view. The results are based on experiences from a running prototype implementation.
Similar content being viewed by others
Author information
Authors and Affiliations
Additional information
Edited by: M.T. Özsu. Received April 12, 1995 / Accepted April 22, 1996
Rights and permissions
About this article
Cite this article
Fahl, G., Risch, T. Query processing over object views of relational data. The VLDB Journal 6, 261–281 (1997). https://doi.org/10.1007/s007780050045
Issue Date:
DOI: https://doi.org/10.1007/s007780050045