Abstract
Many applications in Object Databases (ODB), for example, schema management tools, CASE tools, database development tools and integration wrappers, need extensive queries over both application data as well as metadata. However queries over metadata via OQL, a de-facto standard for object query languages defined for the ODMG 2.0 Object Model, are tied to low-level implementation details of the underlying schema repository of the database system. Hence, they are neither portable nor easily usable, requiring the application developer to have detailed knowledge of the proprietary structure of the schema repository. In this paper, we propose an extension of OQL, called MetaOQL, to address this limitation. Our proposition of MetaOQL offers several benefits: (1) it is a natural extension of OQL in terms of both its syntax and semantics; (2) it removes the dependency of metadata queries on the particular schema repository, hence providing uniformity and portability of metadata queries across different ODBs; (3) it supports transparent navigation over the metadata thus offering ease of use; (4) unlike OQL, it hides metadata querying details from the users hence the queries can be simplified and more easy to read and understand. We have also investigated implementation strategies for MetaOQL. In particular, we propose a translation strategy from MetaOQL to OQL as a preferable solution compared to development of a special-purpose MetaOQL processor. The translation strategy offers the advantage that the MetaOQL queries can be retargeted to work on top of any existing ODB engine equipped with OQL with minimal effort. Furthermore, all OQL query optimization strategies can thus still be brought to bear in our extended system.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
R. G. G. Cattell and D. Barry et al. The Object Database Standard: ODMG 2.0. Morgan Kaufmann Publishers, Inc., 1997.
K. T. Claypool, J. Jin, and E. A. Rundensteiner. OQL SERF: An ODMG Implementation of the Template-Based Schema Evolution Framework. In Centre for Advanced Studies Conference, pages 108–122, November 1998.
K. T. Claypool, J. Jin, and E. A. Rundensteiner. SERF: Schema Evolution through an Extensible, Re-usable and Flexible Framework. Technical Report WPI-CS-TR-98-9, Worcester Polytechnic Institute, May 1998.
W. Chen, M. Kifer, and D.S. Warren. Hilog as a platform for database languages. In DBPL, pages 37–44, 1989.
K. T. Claypool and E. A. Rundensteiner. Flexible Database Transformations: The SERF Approach. In IEEE Data Engineering Bulletin 22(1), pages 19–24, 1999.
K. T. Claypool and E. A. Rundensteiner. SERF: An ODMG Based Extensible Schema Transformation System. Technical Report WPI-CS-TR-99-21, Worcester Polytechnic Institute, July 1999.
Itasca Systems Inc. Itasca Systems Technical Report. Technical Report TM-92-001, OODBMS Feature Checklist. Rev 1.1, Itasca Systems, Inc., December 1993.
M. Kifer, W. Kim, and Y. Sagiv. Querying object-oriented databases. SIGMOD, pages 393–402, 1992.
M. Kifer, G. Lausen, and Wu. J. Logical foundations of object-oriented and frame-based languages. In JACM, pages 741–843, 1995.
R. Krishnamurthy, W. Litwin, and W. Kent. Towards a real horn clause language. In VLDB, 1988.
R. Krishnamurthy, W. Litwin, and W. Kent. Languages features for interoperability of databases with schematic discrepancies. In Proceedings of the ACM SIGMOD International Conference on Management of Data, pages 40–49, 1991.
K. W. Liu and D. Spooner. Object-oriented database views for supporting multidisciplinary concurrent engineering. In IEEE Computer Software and Applications Conference, pages 19–25, November 1993.
L.V.S. Lakshmanan, F. Sadri, and I.N. Subramanian. On the logical foundations of schema integration and evolution in heterogeneous database system. In DOOD, pages 81–100, 1993.
L.V.S. Lakshmanan, F. Sadri, and I.N. Subramanian. SchemaSQL-A Language for Interoperability in Relational Multi-database Systems. In VLDB, pages 239–250, 1996.
L.V.S. Lakshmanan, F. Sadri, and I.N. Subramanian. On Efficiently Implementing SchemaSQL on a SQL Database System. In VLDB, pages 471–482, 1999.
P. O’Brien. Making Java Objects Persistent. Java Report, 1(1):49–60, 1997.
Object Design Inc. ObjectStore-User Guide: DML. ObjectStore Release 3.0 for UNIX Systems. Object Design Inc., 1993.
E. A. Rundensteiner, K. T. Claypool, M. Li, L. Chen, X. Zhang, C. Natarajan, J. Jin, S. De Lima, and S. Weiner. SERF: ODMG-Based Generic Restructuring Facility. In Demo Session Proceedings of SIGMOD’99, pages 568–570, 1999.
J. F. Roddick and L. Al-Jadir et al. Evolution and Change in Data Management-Issues and Directions. In SIGMOD Record, pages 21–25, March 2000.
O2 Technology. O2 Reference Manual, Version 4.5, Release November 1994. O2 Technology, Versailles, France, 1994.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2001 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Su, H., Claypool, K.T., Rundensteiner, E.A. (2001). Extending the Object Query Language for Transparent Metadata Access. In: Balsters, H., de Brock, B., Conrad, S. (eds) Database Schema Evolution and Meta-Modeling. DEMM FoMLaDO 2000 2000. Lecture Notes in Computer Science, vol 2065. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-48196-6_11
Download citation
DOI: https://doi.org/10.1007/3-540-48196-6_11
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-42272-3
Online ISBN: 978-3-540-48196-6
eBook Packages: Springer Book Archive