Patent Number: 6,253,200

Title: Structured query language to IMS transaction mapper

Abstract: A process to access an IMS transaction based computer system from a structured query language (SQL) application program without revising or migrating the transaction based system. Binary virtual table mappings are built. An SQL statement from the SQL application program is parsed. Virtual column to transaction utilization mappings are extracted from the SQL statement. A possible solution set or solution sets are generated which may be capable of satisfying the SQL statement. Thereafter, transaction costs for each potential solution set are determined. Finally, a solution set with the lowest cost to satisfy the SQL statement is executed.

Inventors: Smedley; Richard Ray (Broken Arrow, OK), Laroche; Guy Robert (Tulsa, OK), Clapper; Michael Raymond (Broken Arrow, OK)

Assignee: Sabre Inc.

International Classification: G06F 17/30 (20060101); G06F 009/00 (); G06F 017/30 ()

Expiration Date: 06/26/2018