Abstract
We require a database system that is efficient for operations on individual data objects without losing the functionality provided by a relational DBMS. Typically, our database operations cannot be expressed as a single query in SQL or another high-level relational language, and must be decomposed into many simple “object-oriented” queries. The queries are invoked by programs rather than directly by an end-user; response time must be at least an order of magnitude faster than conventional DBMSs. An SQL processor, even with parameterized compilation, is not usually optimized for fast response for such trivial queries. We might get the performance we require from an “object-oriented” database system such as Maier et al [MSOP86], but then we would lose the powerful relational facilities. Instead of using either an object-oriented language or the high-level SQL language, we chose to use an efficient object-level interface to a relational DBMS, called ERIC (Entity-Relationship Interface Convention), to give us the best characteristics of both kinds of database in one system. In this paper, we describe ERIC and its implementation, and explain how the relational and object-oriented viewpoints on databases may be combined.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Cattell, R.G.G.: “Design and Implementation of a Relationship-Entity-Datum Data Model”, Xerox PARC Technical Report CSL 83–4, May 1983.
Hagman, R., Ferrari, D.: “Performance Analysis of Several Back-End Database Architectures”, ACM TODS, Vol. 11, No. 1, pp. 126, March 1986.
Maier, D., Stein, J., Otis, A., Purdy, A.: “Development of an Object-Oriented DBMS”, Proc. Conference on Object-Oriented Programming Systems, Languages and Applications, ACM SIGPLAN Notices, Vol. 21, No. 11, pp. 472–482, Portland, OR, September 1986.
Rubenstein, W.B., Cattell, R.G.G, R.G.G.: “Benchmarks for Database Response Time”, Proc. ACM-SIGMOD, 1987
Stonebraker, M.: “Object Management in POSTGRES Using Procedures”, in this volume.
Sun Microsystems, Inc.: “SunSimplify 1.0 Manuals”, Order Number SunSimplify-09, Sun Microsystems, Mountain View, CA, 1986.
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1991 Springer-Verlag Berlin Heidelberg
About this chapter
Cite this chapter
Learmont, T., Cattell, R.G.G. (1991). An Object-Oriented Interface to a Relational Database. In: Dittrich, K.R., Dayal, U., Buchmann, A.P. (eds) On Object-Oriented Database Systems. Topics in Information Systems. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-84374-7_11
Download citation
DOI: https://doi.org/10.1007/978-3-642-84374-7_11
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-84376-1
Online ISBN: 978-3-642-84374-7
eBook Packages: Springer Book Archive