SQL access to system specific data
AssigneeInternational Business Machines Corporation
InventorRichard Pong Nam Sinn
Life of this patent
Estimating the term…
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.
Claims31
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.
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.
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.
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.
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.
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.
Dependencies are inferred from the claim text.