Structured query language to IMS transaction mapper
US6253200A · kind A · utility
Assignee
Inventors
Key dates
| Filing date | Dec 2, 1997 |
| Grant date | Jun 26, 2001 |
| Priority date | — |
| Expiry date | Dec 2, 2017 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99934
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.