Abstract
The paper presents a solution of the problem of wrapping relational databases to an object-oriented business model in the data grid architecture. The main problem with this kind of wrappers is how to utilize the native SQL query optimizer, which in majority of RDBMS is transparent for the users. In our solution we use the stack-based approach to query languages, its query language SBQL, updateable object-oriented virtual views and the query modification technique. The architecture rewrites the front-end OO query to a semantically equivalent back-end query addressing the M0 object model that is 1:1 compatible with the relational model. Then, in the resulting SBQL query the wrapper looks for patterns that correspond to optimizable SQL queries. Such patterns are then substituted by dynamic SQL execute immediately statements. The method is illustrated by a sufficiently sophisticated example. The method is currently being implemented within the prototype OO server ODRA devoted to Web and grid applications.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Bergamaschi, S., Garuti, A., Sartori, C., Venuta, A.: Object Wrapper: An Object-Oriented Interface for Relational Databases. In: EUROMICRO 1997, pp. 41–46 (1997)
Foster, I., Kesselman, C., Nick, J., Tuecke, S.: The Physiology of the Grid: An Open Grid Services Architecture for Distributed Systems Integration. Global Grid Forum (June 22 2002)
Kaczmarski, K., Habela, P., Subieta, K.: Metadata in a Data Grid Construction. In: Proc. of 13th IEEE International Workshops on Enabling Technologies: Infrastructures for Collaborative Enterprises (WETICE 2004), Italy (June 2004)
Kozakiewicz, H., Leszczyłowski, J., Płodzień, J., Subieta, K.: Updateable Object Views. ICS PAS Reports 950 (October 2002)
Kozankiewicz, H., Stencel, K., Subieta, K.: Implementation of Federated Databases through Updateable Views. In: Sloot, P.M.A., Hoekstra, A.G., Priol, T., Reinefeld, A., Bubak, M. (eds.) EGC 2005. LNCS, vol. 3470, pp. 610–619. Springer, Heidelberg (2005) (to appear)
Kozankiewicz, H., Stencel, K., Subieta, K.: Integration of Heterogeneous Resources through Updatable Views. Workshop on Emerging Technologies for Next generation GRID (ETNGRID-2004). In: 13th IEEE WETICE-2004, University of Modena and Reggio Emilia, Italy, June 14-16. Proceedings published by IEEE, Los Alamitos (2004)
Kozankiewicz, H., Subieta, K.: SBQL Views - Prototype of Updateable Views. In: ADBIS (Local Proceedings) (2004)
Matthes, F., Rudloff, A., Schmidt, J.W., Subieta, K.: A Gateway from DBPL to Ingres. In: Risch, T., Litwin, W. (eds.) ADB 1994. LNCS, vol. 819, pp. 365–380. Springer, Heidelberg (1994)
Moore, R., Merzky, A.: Persistent Archive Concepts. Global Grid Forum GFD-I.026 (December 2003)
Cattel, R.G.G., Barry, D.K. (eds.): Object Data Management Group: The Object Database Standard ODMG. Morgan Kaufmann, San Francisco (2000) (Release 3.0)
Plodzien, J.: Optimization Methods in Object Query Languages, PhD Thesis. IPIPAN, Warszawa (2000)
Subieta, K.: Theory and Construction of Object-Oriented Query Languages. Editors of the Polish-Japanese Institute of Information Technology, 522 (2004)
Subieta, K., Plodzien, J.: Object Views and Query Modification. In: Barzdins, J., Caplinskas, A. (eds.) Databases and Information Systems, pp. 3–14. Kluwer Academic Publishers, Dordrecht (2001)
W3C: XQuery 1.0: An XML Query Language. W3C Working Draft 12 (November 2003), http://www.w3.org/TR/xquery/
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2005 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Kuliberda, K., Wislicki, J., Adamus, R., Subieta, K. (2005). Object-Oriented Wrapper for Relational Databases in the Data Grid Architecture. In: Meersman, R., Tari, Z., Herrero, P. (eds) On the Move to Meaningful Internet Systems 2005: OTM 2005 Workshops. OTM 2005. Lecture Notes in Computer Science, vol 3762. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11575863_56
Download citation
DOI: https://doi.org/10.1007/11575863_56
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-29739-0
Online ISBN: 978-3-540-32132-3
eBook Packages: Computer ScienceComputer Science (R0)