System for accessing cobol data files by generating a dictionary

Details System for accessing cobol data files by generating a dictionary System for accessing cobol data files by generating a dictionary

1993-09-30

1995-07-11

Black, Thomas G.

Boots, shoes, and leggings

364DIG1, 3642823, 3642821, 3642834, G06F 1730

Patent

active

054329302

ABSTRACT:
A system and method enabling use of a COBOL compatible structured query language (CCSQL) to manipulate data stored in a COBOL data file, which is in a nonfirst normal, hierarchical format. Initially, a dictionary generator subsystem creates a corresponding dictionary for each COBOL data file. In the dictionary, the NF.sup.2 hierarchical logical relationship between the items and attributes (hierarchical nature) of each item of a COBOL data file are defined. Thereafter, whenever a new COBOL data file is produced, a corresponding dictionary is generated. When a user enters a request in the CCSQL format to query a COBOL data file, the request is parsed. The definitions in the dictionary are used by the CCSQL kernel to manipulate the data in response to the user's query. A command interpreter processes the request to determine the appropriate data manipulation to apply and initiates a CCSQL kernel request that carries out the intended action, with reference to the corresponding dictionary. For example, the request may require that certain items from a COBOL data file be extracted to produce a report. Because the hierarchical logical relationships between the items in the COBOL data are defined in the corresponding dictionary, a CCSQL report generator subsystem can produce the report using data extracted from the COBOL data file in accordance with criteria provided by the user, but without converting the data in the COBOL data files to a 1NF. COBOL programs with embedded CCSQL commands are preprocessed to convert the CCSQL commands to a COBOL compatible structured language that uses the dictionaries to access data referenced in the COBOL data files.

REFERENCES:
patent: 4931928 (1990-06-01), Greenfeld
patent: 5230049 (1993-07-01), Chang et al.
patent: 5257366 (1993-10-01), Adair et al.
patent: 5339424 (1994-08-01), Fushimi

Affiliated with

Also associated with

Rating

System for accessing cobol data files by generating a dictionary does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with System for accessing cobol data files by generating a dictionary, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System for accessing cobol data files by generating a dictionary will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-510784