Object-Oriented Wrapper for Relational Databases in the Data Grid Architecture [chapter]

Kamil Kuliberda, Jacek Wislicki, Radoslaw Adamus, Kazimierz Subieta
2005 Lecture Notes in Computer Science  
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
more » ... ront-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.
doi:10.1007/11575863_56 fatcat:dg3b3e6zinc4rgt2jcncvovqjy