Fahl, G. and Risch, T. (1995). Query Processing over Object Views of Relational Data. Technical Report LiTH-IDA-R-95-11, Department of Computer and Information Science, Linköping University, Sweden. (bibtex),
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 internal queries against the relational database from which the answer is formed. The object view can also store its own data and 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 subtype/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 optimize queries against the object view. The results are based on experiences from a running prototype implementation.
CS Dept TR Overview