Browse Prior Art Database

Technique for integrating CICS/IMS transactions into object queries based on query rewriting

IP.com Disclosure Number: IPCOM000014233D
Original Publication Date: 2001-Jul-18
Included in the Prior Art Database: 2003-Jun-19
Document File: 1 page(s) / 39K

Publishing Venue

IBM

Abstract

The invention enables an object query launched against a middle tier query server to be able to access CICS/IMS transactions as backend data sources, in addition to relational databases. CICS/IMS transactions are procedural in nature while object/relational queries are declarative in nature. The invention proposes a strategy to integrate them together, and allows a single object query language to be used for querying these different databases.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 100% of the total text.

Page 1 of 1

  Technique for integrating CICS/IMS transactions into object queries based on query rewriting

    The invention enables an object query launched against a middle tier query server to be able to access CICS/IMS transactions as backend data sources, in addition to relational databases. CICS/IMS transactions are procedural in nature while object/relational queries are declarative in nature. The invention proposes a strategy to integrate them together, and allows a single object query language to be used for querying these different databases.

The solution consists of the following steps:

Describe a CICS/IMS transaction using parameterized SQL view;

Analyze an object query and decompose it into the suitable parameterized SQL views. When more that one view is required to

retrieve needed data for answering the object query, the dependency among the CICS/IMS transactions is determined; and Rewrite the object query using the determined SQL views and generate an execution plan based on the rewritten object query.


1.


2.


3.

1