Granted Patent B2

US 7,421,427 · App. 10/150,089 · Granted Sep 2, 2008

Abstract

Claims (24)

1. A method of providing access to a screen-based host application presenting a screen-based user interface, by a SQL application that is otherwise non-interoperable with said screen-based host application, said method comprising:

(a) encapsulating structure of the screen-based host application into a model to allow data to be changed or retrieved using the screen-based host application screen-based interface, said model insulating said SQL application from needing to interact directly with the screen-based host application;

(b) parsing a query request for structured data from the SQL application;

(c) using said model to resolve at least some aspects of said parsed request into at least one procedure to thereby map said parsed request into one or more requests to access screens of said screen-based host application;

(d) performing said procedure to thereby generate at least one screen-based access request to said screen-based host application including placing data from SQL statements into predetermined fields of a host screen;

(e) applying said at least one request to said screen-based host application and scraping data from predetermined fields within at least one host screen to thereby extract data therefrom and generate a response; and

(f) delivering at least a portion of said generated response as structured data to said SQL application in response to said query request.

2. A method as in claim 1 wherein said SQL application provides a request in Standard Query Language, and said parsing step comprises parsing said request into a parse tree.

3. The method as in claim 1 wherein said screen-based host application runs on a host computer.

4. The method as in claim 3 wherein said host computer is a minicomputer or a mainframe.

5. The method as in claim 3 wherein said host computer comprises a IBM mainframe, VAX, UNIX or AS/400 computer.

6. The method as in claim 1 wherein said steps (a)-(f) are accomplished in a single network roundtrip involving the SQL application.

7. The method as in claim 1 wherein said resolving step comprises resolving said request into predefined procedures that perform predefined tasks.

8. The method as in claim 1 wherein said providing step includes filtering and/or sorting screen-scraping results from said screen-based host application.

9. The method as in claim 1 wherein said SQL application is a client-server application.

10. A method of providing efficient access to a screen-based host application from a requesting SQL application that is substantially non-interoperative with said screen-based host application while insulating said requesting SQL application from details of screen-based host application access, said method comprising:

establishing a model of said screen-based host application;

resolving query requests from said requesting SQL application into at least one procedure to thereby translate said parsed request into one or more requests to said screen-based host application;

executing said at least one procedure in conjunction with said model in response to a request from said requesting SQL application to generate at least one host request and to request at least one host response, said executing step including at least one of:

providing at least one input parameter obtained from said request to said screen-based host application,

thereby extracting data from at least one substantially unstructured host screen, and

providing at least one data item elicited from said screen-based host application as structured data to said requesting SQL application,

wherein said executing comprises scraping at least one screen of said screen-based host application by extracting data from predetermined fields within said at least one screen.

11. The method as in claim 10 wherein said screen-based host application is incompatible with SQL and said requestor communicates at least in part using SQL.

Assignments (24)