Browse Prior Art Database

Technique for integrating CICS/IMS transactions into object queries based on query rewriting Disclosure Number: IPCOM000014233D
Original Publication Date: 2001-Jul-18
Included in the Prior Art Database: 2003-Jun-19

Publishing Venue



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