Object-Oriented wrapper for relational databases in the data grid architecture

Authors:
Kamil Kuliberda;Jacek Wislicki;Radoslaw Adamus;Kazimierz Subieta
Affiliations:
Computer Engineering Department, Technical University of Lodz, Lodz, Poland;Computer Engineering Department, Technical University of Lodz, Lodz, Poland;Computer Engineering Department, Technical University of Lodz, Lodz, Poland;Computer Engineering Department, Technical University of Lodz, Lodz, Poland
Venue:
OTM'05 Proceedings of the 2005 OTM Confederated international conference on On the Move to Meaningful Internet Systems
Year:
2005

Citing 4
Cited 3

Object views and query modification

Databases and information systems
Integration of Heterogeneous Resources through Updatable Views

WETICE '04 Proceedings of the 13th IEEE International Workshops on Enabling Technologies: Infrastructure for Collaborative Enterprises
Metadata in a Data Grid Construction

WETICE '04 Proceedings of the 13th IEEE International Workshops on Enabling Technologies: Infrastructure for Collaborative Enterprises
Implementation of federated databases through updatable views

EGC'05 Proceedings of the 2005 European conference on Advances in Grid Computing

A generic proposal for a transparent integration of distributed data by an autonomous layer in a virtual repository

Multiagent and Grid Systems - Grid Computing, high performance and distributed applications
Procedures of integration of fragmented data in a p2p data grid virtual repository,

ICSOC'06 Proceedings of the 4th international conference on Service-Oriented Computing
Autonomous layer for data integration in a virtual repository

ODBASE'06/OTM'06 Proceedings of the 2006 Confederated international conference on On the Move to Meaningful Internet Systems: CoopIS, DOA, GADA, and ODBASE - Volume Part II

Quantified Score

Hi-index	0.00

Visualization

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.