Title: Relational to object-oriented database wrapper solution in the data grid architecture with query optimisation issues

Authors: Jacek Wislicki, Kamil Kuliberda, Radoslaw Adamus, Kazimierz Subieta

Addresses: Department of Computer Engineering, Technical University of Lodz, Lodz, Poland. ' Department of Computer Engineering, Technical University of Lodz, Lodz, Poland. ' Department of Computer Engineering, Technical University of Lodz, Lodz, Poland. ' Department of Computer Engineering, Technical University of Lodz, Lodz, Poland

Abstract: This paper introduces a solution to the problem of integrating relational databases with the data grid architecture and presenting their contents as a purely object-oriented business model. It describes a dedicated wrapper constructed with the Stack-Based Approach (SBA) and updatable views concepts. The proposed architecture sustains the grid|s transparency and allows a grid user to operate in an object-oriented environment with SBQL – the stack-based query language. The strength of the described wrapper is a possibility of employment of native SQL optimisers. A query entering the front-end of the wrapper (object-oriented business model) can be rewritten according to the powerful SBQL optimisation rules (within the wrapper) and then evaluated in the relational resource environment where appropriate SQL optimisers apply. This paper contains a description of the wrapper and its place in the grid architecture with a query optimisation procedure and an example of such a process.

Keywords: data grid; wrapper; updateable views; query optimisation; object-oriented database; relational databases; object-oriented business models; business process integration; SBQL; stack-based query language; grid architecture.

DOI: 10.1504/IJBPIM.2007.014101

International Journal of Business Process Integration and Management, 2007 Vol.2 No.1, pp.17 - 25

Published online: 20 Jun 2007 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article