Computer-based information access method and apparatus to permit

Details Computer-based information access method and apparatus to permit Computer-based information access method and apparatus to permit

1994-05-13

1998-10-20

Black, Thomas G.

395703, 395708, G06F 1730

Patent

active

058260765

ABSTRACT:
A method and apparatus that permits creation, reading and modification of 3GL application programs by SQL requests. A catalog is created by selecting source programs from 3GL application data for which file definitions are to be extracted, identifying specific files within the selected source programs to be processed, extracting appropriate schema from the selected files, and recording the appropriate schema in a catalog. Once the 3GL-specific data schema contained in the application source has been extracted and stored in the catalog, the relational database which is to be based upon the data represented by the 3GL schema is defined and stored in the system catalog so that tables in the relational database may be accessed by a runtime SQL database engine. Further, both 3GL data and relational database data may be modified and maintained with a single tool set. After the catalog is created, the invention uses the catalog to process SQL requests in order to access the relational database representation of the 3GL data by parsing the SQL query request, generating a set of possible execution plans for manipulating the relational form of the data, selecting an optimal plan based upon information provided from the system catalog, and executing the plan by servicing the SQL request for relational data from the underlying 3GL data files described in the system catalog.

REFERENCES:
patent: 4918588 (1990-04-01), Barrett et al.
patent: 4918593 (1990-04-01), Huber
patent: 4930071 (1990-05-01), Tou et al.
patent: 4931928 (1990-06-01), Greenfeld
patent: 5091852 (1992-02-01), Tsuchida et al.
patent: 5230049 (1993-07-01), Chang et al.
patent: 5295222 (1994-03-01), Wadhwa et al.
patent: 5307484 (1994-04-01), Baker et al.
patent: 5379419 (1995-01-01), Heffernan et al.
patent: 5423930 (1995-06-01), Song
patent: 5432930 (1995-07-01), Song
"DATAPLEX: An access to heterogenous distributed databases", Chin-Wan Chung, Communications of the ACM, v33, n1, p. 70(11) Jan. 1990.
International Search Report, PCT/US95/05851; Sep. 26, 1995.
International Application Published Under the Patent Cooperation Treaty, No. WO 93/07564 (Apr. 15, 1993).

Affiliated with

Also associated with

Rating

Computer-based information access method and apparatus to permit does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Computer-based information access method and apparatus to permit, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Computer-based information access method and apparatus to permit will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-257727