Set-level database access for performing row-sequential operations
AssigneeTeradata US, Inc.
InventorGeorge J. Coleman
Life of this patent
Estimating the term…
Abstract
A method and computer program are disclosed for increasing the efficiency of a row sequential database operation by transforming procedural logic, which applies serially to one row at a time, into set logic, which applies in parallel to many rows or all rows at once. The method includes dividing the row sequential operation into a plurality of portions. A hierarchy is determined for the portions. A set level operation is generated in accordance with the portion hierarchy.
Claims28
A computer-implemented method for increasing the efficiency of a database operation, the method including:
- receiving a row sequential operation that includes procedural logic which applies serially to one row at a time;
- dividing the row sequential operation into a plurality of portions;
- determining a hierarchy for the portions;
- and
- generating a set level operation comprising set level logic which applies in parallel to many rows at once in accordance with the portion hierarchy.
A computer program, stored on a tangible storage medium, for use in increasing the efficiency of a database operation, the program including executable instructions that cause a computer to:
- receive a row sequential operation that includes procedural logic which applies serially to one row at a time;
- divide the row sequential operation into a plurality of portions;
- determine a hierarchy for the portions;
- and
- generate a set level operation comprising set level logic which applies in parallel to many rows at once in accordance with the portion hierarchy.
A computer-implemented method for increasing the efficiency of a database operation, the method including:
- receiving a row sequential database operation that includes procedural logic which applies serially to one row at a time;
- analyzing the row sequential database operation;
- translating the analyzed row sequential database operation;
- and
- optimizing the translated and analyzed row sequential database operation to produce a set level operation comprising set level logic which applies in parallel to many rows at once.
Dependencies are inferred from the claim text.