Intelligent compilation of scripting language for query processing systems
AssigneeInternational Business Machines Corporation
InventorsRoberta Jo Cochrane, Mir Hamid Pirahesh, Serge Philippe Rielau, Richard Sefton Sidle
Life of this patent
Estimating the term…
Abstract
A method, apparatus, and article of manufacture for an intelligent compiler. A query is executed in a computer to retrieve data from a relational database stored on a data storage device. One or more scripting language statements are compiled to generate an internal representation. Then, the execution of the scripting language statements is optimized using the generated internal representation.
Claims42
A method of executing a query in a computer to retrieve data from a relational database stored on a data storage device, comprising the steps of:
- compilation of the query, which contains one or more scripting language statements, to generate an internal representation;
- compilation of the scripting language statements to modify the generated internal representation to reflect the parsing of the scripting language statements, wherein each scripting language statement specifies syntax and semantics of a database language for declaring and maintaining persistent database language routines;
- and
- optimization of the execution of the scripting language statements using the modified internal representation.
A method of executing a query in a computer to retrieve data from a relational database stored on a data storage device, comprising the steps of:
- compilation of one or more scripting language statements to generate an internal representation, further comprising the step of compiling a return in a sequence;
- and
- optimizing the execution of the scripting language statements using the generated internal representation.
A method of executing a query in a computer to retrieve data from a relational database stored on a data storage device, comprising the steps of:
- compilation of one or more scripting language statements to generate an internal representation, further comprising the step of compiling an early exit in a sequence;
- and
- optimizing the execution of the scripting language statements using the generated internal representation.
A method of executing a query in a computer to retrieve data from a relational database stored on a data storage device, comprising the steps of:
- compilation of one or more scripting language statements to generate an internal representation, further comprising the step of compiling an iterative sequence;
- and
- optimizing the execution of the scripting language statements using the generated internal representation.
An apparatus for executing a query, comprising:
- a computer having a memory and a data storage device coupled thereto, wherein the data storage device stores a relational database;
- and
- one or more computer programs, performed by the computer, for compiling the query, which contains one or more scripting language statements, to generate an internal representation, for compiling the scripting language statements to modify the generated internal representation to reflect the parsing of the scripting language statements, wherein each scripting language statement specifies syntax and semantics of a database language for declaring and maintaining persistent database language routines, and for optimizing the execution of the scripting language statements using the modified internal representation.
An apparatus for executing a query, comprising:
- a computer having a memory and a data storage device coupled thereto, wherein the data storage device stores a relational database;
- and
- one or more computer programs, performed by the computer, for compiling one or more scripting language statements to generate an internal representation, further comprising the means for compiling a return in a sequence, and for optimizing the execution of the scripting language statements using the generated internal representation.
An apparatus for executing a query, comprising:
- a computer having a memory and a data storage device coupled thereto, wherein the data storage device stores a relational database;
- and
- one or more computer programs, performed by the computer, for compiling one or more scripting language statements to generate an internal representation, further comprising the means for compiling an early exit in a sequence, and for optimizing the execution of the scripting language statements using the generated internal representation.
An apparatus for executing a query, comprising:
- a computer having a memory and a data storage device coupled thereto, wherein the data storage device stores a relational database;
- and
- one or more computer programs, performed by the computer, for compiling one or more scripting language statements to generate an internal representation, further comprising the means for compiling an iterative sequence, and for optimizing the execution of the scripting language statements using the generated internal representation.
An article of manufacture comprising a program storage medium readable by a computer and embodying one or more instructions executable by the computer to perform method steps for executing a query to retrieve data from a relational database stored on a data storage device, the method comprising the steps of:
- compilation of the query, which contains one or more scripting language statements, to generate an internal representation;
- compilation of the scripting language statements to modify the generated internal representation to reflect the parsing of the scripting language statements, wherein each scripting language statement specifies syntax and semantics of a database language for declaring and maintaining persistent database language routines;
- and
- optimization of the execution of the scripting language statements using the modified internal representation.
An article of manufacture comprising a program storage medium readable by a computer and embodying one or more instructions executable by the computer to perform method steps for executing a query to retrieve data from a relational database stored on a data storage device, the method comprising the steps of:
- compilation of one or more scripting language statements to generate an internal representation, further comprising the step of compiling a return in a sequence;
- and
- optimizing the execution of the scripting language statements using the generated internal representation.
An article of manufacture comprising a program storage medium readable by a computer and embodying one or more instructions executable by the computer to perform method steps for executing a query to retrieve data from a relational database stored on a data storage device, the method comprising the steps of:
- compilation of one or more scripting language statements to generate an internal representation, further comprising the step of compiling an early exit in a sequence;
- and optimizing the execution of the scripting language statements using the generated internal representation.
An article of manufacture comprising a program storage medium readable by a computer and embodying one or more instructions executable by the computer to perform method steps for executing a query to retrieve data from a relational database stored on a data storage device, the method comprising the steps of:
- compilation of one or more scripting language statements to generate an internal representation, further comprising the step of compiling an iterative sequence;
- and
- optimizing the execution of the scripting language statements using the generated internal representation.
Dependencies are inferred from the claim text.