# US 6,732,089 B1 · SQL access to system specific data

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

- Number: US 6,732,089 B1
- Document ID: US6732089B1
- Status: Granted
- Kind: B1
- Application number: 09/567,959
- Filed: 2000-05-09
- Granted: 2004-05-04
- Earliest claimed: 2000-05-09
- Assignees: International Business Machines Corporation
- Inventors: Richard Pong Nam Sinn
- Web page: https://patentgrep.com/patent/US6732089B1

## CPC

- G06F 16/2438: {Embedded query languages}
- G06F 16/2443: {Stored procedures}
- Y10S 707/99933: Query processing, i.e. searching
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- Y10S: TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS

## Abstract

A method, apparatus and program storage device for enabling SQL statement access to remote system specific data and functions is provided. A method is developed to utilize wrapper stored procedures and the table formatted output of native commands in order to access the output via direct SQL statements. The output of native commands is generated by wrapper stored procedures and then directed to a temporary file by the method. The client may then access the contents of the file with direct SQL queries. This procedure allows the transformed access procedure to perform more efficiently than conventional procedures, while providing same results.

## Claims

### Claim 1

A method for obtaining system specific information using a query language, the method comprising:
providing a system specific procedure available to a client;
said system specific procedure executing at least one native command,
wherein the native command is passed as a parameter to the system specific procedure;
wherein the system specific procedure is a wrapper stored procedure;
said execution producing at least a result; and
inserting said execution result in a file available for the client access.

### Claim 2 (depends on 1)

The method according to claim 1, further comprising:
providing said execution result from said file to said client in response to a query.

### Claim 3 (depends on 2)

The method according to claim 2, wherein the query is an SQL query.

### Claim 4 (depends on 3)

The method according to claim 3, wherein said wrapper stored procedure is stored at a remote location relative to said client.

### Claim 5 (depends on 4)

The method according to claim 4, wherein said remote location is a database server.

### Claim 6 (depends on 1)

The method according to claim 1, wherein said file is a temporary file.

### Claim 7 (depends on 1)

The method according to claim 1, wherein said file is a remote file relative to the client location.

### Claim 8

A method for performing remote system-specific data access using a query language, the method comprising:
calling a wrapper stored procedure from a remote location, said wrapper stored procedure receiving as a parameter a native command native to an operating system platform;
passing said wrapper stored procedure to said operating system platform;
executing said wrapper stored procedure on said operating system platform; and
storing an output of said execution in a file available for client access.

### Claim 9 (depends on 8)

The method according to claim 8, further comprising:
providing the stored execution output in response to a query.

### Claim 10 (depends on 9)

The method of claim 9, wherein said query is an SQL query.

### Claim 11 (depends on 8)

The method of claim 8, wherein said operating system platform is on a system that provides wrapper stored procedures as well as SQL readable output formats for native procedures.

### Claim 12 (depends on 8)

The method of claim 8, wherein said file is a temporary file.

### Claim 13

An apparatus for optimizing remote data access, the apparatus comprising:
a computer having an electronic storage device coupled thereto for storing a database, the access being performed by the computer to retrieve data from said database; and
a method performed by the computer, said method comprising:
calling a wrapper stored procedure from said database, said wrapper stored procedure receiving as a parameter a native command native to said database operating system platform;
passing said wrapper stored procedure to said operating system platform;
executing said wrapper stored procedure on said operating system platform; and
storing an output of said execution in a file available for client access.

### Claim 14 (depends on 13)

The apparatus according to claim 13, further comprising: providing the execution output from the file in response to a query.

### Claim 15 (depends on 14)

The apparatus according to claim 14, wherein the query is an SQL query.

### Claim 16 (depends on 13)

The apparatus according to claim 13, wherein said operating system platform is on a system that provides wrapper stored procedures as well as SQL readable output formats for native procedures.

### Claim 17 (depends on 13)

The apparatus according to claim 13, wherein said file is a temporary file.

### Claim 18

A program storage device readable by a computer tangibly embodying a program of instructions executable by the computer to form a method for optimizing remote data access calls, the calls being performed by the computer to retrieve data from a database stored in an electronic storage device coupled to the computer, the method comprising:
calling a wrapper stored procedure from said database, said wrapper stored procedure receiving as a parameter a native command native to said database operating system platform;
passing said wrapper stored procedure to said operating system platform;
executing said wrapper stored procedure on said operating system platform; and
storing an output of said execution in a file available for client access.

### Claim 19 (depends on 18)

The program storage device according to claim 18, further comprising: providing the execution output from said file in response to a query.

### Claim 20 (depends on 19)

The program storage device according to claim 19, wherein the query is an SQL query.

### Claim 21 (depends on 18)

The program storage device according to claim 18, wherein said file is a temporary file.

### Claim 22 (depends on 19)

The program storage device according to claim 19, wherein said operating system platform is on a system that provides wrapper stored procedures as well as SQL readable output formats for native procedures.

### Claim 23 (depends on 18)

The program storage device according to claim 18, wherein said execution is enabled by at least one SQL command.

### Claim 24

A method for accessing system specific data, comprising:
allowing a client to call a wrapper stored procedure stored on a database server, the wrapper stored procedure having a native command passed as a parameter, the wrapper stored procedure accessible by a query language;
performing the wrapper stored procedure as a native procedure on the database server, the native procedure including at least the native command as a parameter;
outputting the results of the wrapper stored procedure in a temporary file;
formatting the temporary file so that it is readable by the query language; and
allowing the client to access the temporary file through the query language.

### Claim 25 (depends on 24)

The method of claim 24, wherein the query language is Standard Query Language.

### Claim 26 (depends on 25)

The method of claim 25, wherein the native command can be performed on a system that provides wrapper stored procedures as well as SQL readable output formats for native procedures.

### Claim 27 (depends on 24)

The method of claim 24, wherein the wrapper stored procedure is stored at a remote location relative to the client.

### Claim 28

A system specific data access device comprising:
a computer specific medium having computer readable program code means embodied therein for causing access to system specific date, the computer readable program code means in the system specific data access device comprising:
Computer readable program code means for causing a computer to allow a client to call a wrapper stored procedure stored on a database server, the wrapper stored procedure having a native command passed a parameter, the wrapper stored procedure accessible by a query language;
Computer readable program code means for causing the computer to perform the wrapper stored procedure as a native procedure on the database server, the native procedure including at least the native command as a parameter;
Computer readable program code means for causing the computer to output the results of the wrapper stored procedure in a temporary file;
Computer readable program code means for causing the computer to format the temporary file so that it is readable by the query language; and
Computer readable program code means for causing the computer to access the temporary file through the query language.

### Claim 29 (depends on 28)

The system specific data access device of claim 28, wherein the query language is Standard Query Language.

### Claim 30 (depends on 28)

The system specific data access device of claim 28, wherein the native command can be performed on a system that provides wrapper stored procedures as well as SQL readable output formats for native procedures.

### Claim 31 (depends on 28)

The system specific data access device of claim 28, wherein the wrapper stored procedure is stored at a remote location relative to the client.
