Unisys Corporation

Michael F Parenteau

Gail L Behr

Craig D Hanson

Stephen C Payne

Neil A Lambert

Tadd E Vanyo

An apparatus for and method of utilizing an Internet terminal coupled to the world wide web to access a legacy data base management system having a dialog-based request format to prepare, modify, and execute stored procedures. The user request is passed to the legacy data base management system via the Internet. The command type is determined whereby list, parameter, column, and execute commands are defined. In response to the user request, the scripted procedure is accessed, prepared, modified, or executed, as appropriate. Invalid and/or undefined requests result in an error response. Valid and defined requests result in performance of the requested command and transfer of an appropriate response to the user terminal.

Stored procedure interface

A method and system for providing access to data stored in a plurality of data sets. A simulated table definition is hosted by a server and includes selected data definitions from the plurality of tables. Data extraction logic is hosted by the server and extracts data from the plurality of tables into memory of the server consistent with the simulated table definition and responsive to a request for access to the simulated table. Interface logic is also hosted by the server and is coupled to the data extraction logic. The interface logic transmits the extracted data to the requester consistent with the simulated table and returns for reuse the memory occupied by data of the simulated table after transmitting the data.

Growing community of inventors

Roseville, MN, United States of America

Michael F Parenteau