Structured query language to IMS transaction mapper
First Claim
1. A process to access an IMS or other like transaction based computer system having transaction systems from a structured query language (SQL) application without revising or migrating said transaction based system, which process comprises:
- building a binary virtual table or tables mappings and describing said transaction streams as references to said virtual table or tables;
parsing an SQL statement entered by a user from said SQL application as said SQL statement is run;
extracting virtual column to transaction utilization mappings from said SQL statement;
generating a possible solution set or solution sets which may be capable of satisfying said SQL statement;
determining transaction costs for each said potential solution set; and
executing a solution set with the lowest transaction costs to satisfy said SQL statement.
6 Assignments
0 Petitions
Accused Products
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.
81 Citations
8 Claims
-
1. A process to access an IMS or other like transaction based computer system having transaction systems from a structured query language (SQL) application without revising or migrating said transaction based system, which process comprises:
-
building a binary virtual table or tables mappings and describing said transaction streams as references to said virtual table or tables; parsing an SQL statement entered by a user from said SQL application as said SQL statement is run; extracting virtual column to transaction utilization mappings from said SQL statement; generating a possible solution set or solution sets which may be capable of satisfying said SQL statement; determining transaction costs for each said potential solution set; and executing a solution set with the lowest transaction costs to satisfy said SQL statement. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. An ODBC application to IMS interface to access IMS transactions, which comprises:
-
a structured query language (SQL) ODBC application program; a mapper engine to parse an SQL statement entered by a user; a binary virtual table or tables mapping to possible IMS transaction solutions in communication with said mapper engine; means to extract virtual column to transaction utilization mappings from said SQL statement; means to determine transaction costs for each potential solution set; and means to execute a solution set with the lowest transaction cost to satisfy said SQL statement. - View Dependent Claims (8)
-
Specification