US 12,339,814 B2
On-demand virtual storage access method analytics
Pragya C. Sharma, Mumbai (IN); Ritu Pramod Dalmia, Mumbai (IN); Vikas Obaiah Pujar, Bangalore (IN); Soubhagya Mishra, Bhubaneswar (IN); Pawan Kumar Mishra, Bangalore (IN); Manish Bachhania, Mumbai (IN); Shalini F. Gupta, Pune (IN); and Nilesh D. Gupta, Jaipur (IN)
Assigned to Accenture Global Solutions Limited, Dublin (IE)
Filed by Accenture Global Solutions Limited, Dublin (IE)
Filed on Feb. 22, 2022, as Appl. No. 17/677,701.
Prior Publication US 2023/0267102 A1, Aug. 24, 2023
Int. Cl. G06F 16/188 (2019.01); G06F 16/14 (2019.01); G06F 16/16 (2019.01); G06F 16/25 (2019.01)
CPC G06F 16/188 (2019.01) [G06F 16/148 (2019.01); G06F 16/162 (2019.01); G06F 16/258 (2019.01)] 16 Claims
OG exemplary drawing
 
1. A computer implemented method for executing queries on files stored within a mainframe system, the method being executed by one or more processors and comprising:
extracting, by a UNIX Systems Services (USS) application operating within the mainframe system, Virtual Storage Access Method (VSAM) file names from catalog files;
identifying, by the USS application and based on the VSAM file names, associated copybooks within a z/OS operating system operating within the mainframe system;
generating, by the USS application, metadata for a plurality of VSAM files based on the associated copybooks;
generating, by the USS application, a metadata catalog based on the metadata for the plurality of VSAM files;
receiving, by the USS application operating within the mainframe system, query data based on the generated metadata catalog, the query data indicating a conditional query and a selection of a set of VSAM files of the plurality of VSAM files on which to execute the conditional query;
identifying, by the USS application, a subset of the selected set of VSAM files for which copies of the selected set of VSAM files are not stored in a file database of the USS application;
extracting, by the USS application and from a VSAM file system hosted by the z/OS operating system operating within the mainframe system, a copy of each file of the subset of the selected set of VSAM files into the file database of the USS application;
parsing, by the USS application, the copies of the selected set of VSAM files from the file database into a dataframe operating within the USS application;
executing, by the USS application, the conditional query on the parsed selected set of VSAM files in the dataframe; and
providing, by the USS application, a result of the conditional query based on the execution of the conditional query.