Engineering an SQL gateway to IMS

  • Authors:
  • G. N. Paulley

  • Affiliations:
  • IBM Canada Ltd., North York, Ontario

  • Venue:
  • CASCON '93 Proceedings of the 1993 conference of the Centre for Advanced Studies on Collaborative research: distributed computing - Volume 2
  • Year:
  • 1993

Quantified Score

Hi-index 0.00

Visualization

Abstract

Multidatabase systems enable organizations to integrate legacy database systems, and their applications, with newer database technology. One such legacy system is IBM'S Information Management System (IMs), a hierarchical database management system developed in the 1960s. Commercial IMS gateways typically suffer from poor performance and lack essential features needed to support updates. In this paper, we outline the engineering issues of constructing a multi-user IMS gateway that supports both client applications and ad-hoc requests. Our proposed architecture exploits the transaction management services of IMS/TM and the cross-memory services of MVS/ESA. Design features include run-time query optimization using an access plan cache and the use of IMS/TM message processing regions for database access. On the basis of performance and system programming considerations, we also discuss some implementation aspects of the gateway's design.