# US 2023/0267102 A1 · On-demand virtual storage access method analytics

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2023/0267102 A1
- Document ID: US20230267102A1
- Status: Published application
- Kind: A1
- Application number: 17/677,701
- Filed: 2022-02-22
- Published: 2023-08-24
- Earliest claimed: 2022-02-22
- Assignees: Accenture Global Solutions Limited
- Applicants: Accenture Global Solutions Limited
- Inventors: Pragya C. Sharma; Ritu Pramod Dalmia; Vikas Obaiah Pujar; Soubhagya Mishra; Pawan Kumar Mishra; Manish Bachhania; Shalini F. Gupta; Nilesh D. Gupta
- Web page: https://patentgrep.com/patent/US20230267102A1

## CPC

- G06F 16/188: Virtual file systems
- G06F 16/25: Integrating or interfacing systems involving database management systems
- G06F 16/148: {File search processing}
- G06F 16/162: {Delete operations (erasing in storage systems G06F3/0652)}
- G06F 16/258: {Data format conversion from or to a database}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Implementations are directed to receiving, by an application, query data, the query data indicating a conditional query and a selection of files on which to execute the conditional query; identifying a subset of selected files for which copies of the selected files are not stored in a file database of the application; extracting, from a file system, a copy of each file of the subset of selected files into the file database of the application; parsing the copies of the selected files from the file database into a dataframe; executing the conditional query on the selected files in the dataframe; and providing a result of the conditional query. Actions include executing, by a discovery engine, a discovery process to provide metadata comprising, for a file in the file system: a name of the file; corresponding column names and data types; and a file alias.

## Claims

### Claim 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:
receiving, by an application, query data, the query data indicating a conditional query and a selection of files on which to execute the conditional query;
identifying a subset of selected files for which copies of the selected files are not stored in a file database of the application;
extracting, from a file system, a copy of each file of the subset of selected files into the file database of the application;
parsing the copies of the selected files from the file database into a dataframe;
executing the conditional query on the selected files in the dataframe; and
providing a result of the conditional query.

### Claim 2 (depends on 1)

The method of claim 1, further comprising:
executing, by a discovery engine, a discovery process to provide metadata comprising, for a file in the file system:
a name of the file;
corresponding column names and data types; and
a file alias.

### Claim 3 (depends on 2)

The method of claim 2, further comprising:
generating, by the discovery engine and from the metadata, a metadata catalog representing files in the file system.

### Claim 4 (depends on 1)

The method of claim 1, wherein parsing the copies of the selected files from the file database into a dataframe comprises:
obtaining, from a metadata catalog representing files in the file system, schema information; and
parsing the copies of the selected files into tables using the schema information.

### Claim 5 (depends on 1)

The method of claim 1, further comprising:
storing, by the application, historical query data including query data received over time.

### Claim 6 (depends on 1)

The method of claim 1, further comprising:
based on determining that at least a threshold amount of time has passed after extracting a copy of a particular selected file into the file database, deleting, from the file database, the copy of the particular selected file.

### Claim 7 (depends on 1)

The method of claim 1, wherein executing the conditional query on the selected files in the dataframe comprises executing the conditional query on combined data from two or more of the selected files.

### Claim 8 (depends on 1)

The method of claim 1, wherein the application comprises a UNIX Systems Services (USS).

### Claim 9 (depends on 1)

The method of claim 1, wherein the file system is hosted by an operating system.

### Claim 10 (depends on 9)

The method of claim 9, wherein the operating system comprises z/OS.

### Claim 11 (depends on 9)

The method of claim 9, wherein the application and the operating system operate within the mainframe system.

### Claim 12 (depends on 1)

The method of claim 1, wherein the dataframe comprises a Python dataframe.

### Claim 13 (depends on 1)

The method of claim 1, wherein the file system comprises a Virtual Storage Access Method (VSAM) file system.

### Claim 14 (depends on 1)

The method of claim 1, wherein the files are stored on a direct access storage device (DASD).

### Claim 15

A non-transitory computer-readable storage medium coupled to one or more processors and having instructions stored thereon which, when executed by the one or more processors, cause the one or more processors to perform operations for executing queries on files stored within a mainframe system, the operations comprising:
receiving, by an application, query data, the query data indicating a conditional query and a selection of files on which to execute the conditional query;
identifying a subset of selected files for which copies of the selected files are not stored in a file database of the application;
extracting, from a file system, a copy of each file of the subset of selected files into the file database of the application;
parsing the copies of the selected files from the file database into a dataframe;
executing the conditional query on the selected files in the dataframe; and
providing a result of the conditional query.

### Claim 16 (depends on 15)

The non-transitory computer-readable storage medium of claim 15, the operations further comprising:
executing, by a discovery engine, a discovery process to provide metadata comprising, for a file in the file system:
a name of the file;
corresponding column names and data types; and
a file alias.

### Claim 17 (depends on 16)

The non-transitory computer-readable storage medium of claim 16, the operations further comprising:
generating, by the discovery engine and from the metadata, a metadata catalog representing files in the file system.

### Claim 18 (depends on 15)

The non-transitory computer-readable storage medium of claim 15, wherein parsing the copies of the selected files from the file database into a dataframe comprises:
obtaining, from a metadata catalog representing files in the file system, schema information; and
parsing the copies of the selected files into tables using the schema information.

### Claim 19 (depends on 15)

The non-transitory computer-readable storage medium of claim 15, the operations further comprising:
storing, by the application, historical query data including query data received over time.

### Claim 20

A system, comprising:
a computing device; and
a computer-readable storage device coupled to the computing device and having instructions stored thereon which, when executed by the computing device, cause the computing device to perform operations for executing queries on files stored within a mainframe system, the operations comprising:
receiving, by an application, query data, the query data indicating a conditional query and a selection of files on which to execute the conditional query;
identifying a subset of selected files for which copies of the selected files are not stored in a file database of the application;
extracting, from a file system, a copy of each file of the subset of selected files into the file database of the application;
parsing the copies of the selected files from the file database into a dataframe;
executing the conditional query on the selected files in the dataframe; and
providing a result of the conditional query.
