Abstract: Generation of longer cDNA fragments from SAGE tags for gene identification (GLGI) is disclosed. This method converts SAGE tags, which are about 10 base pairs in length, into their corresponding 3? cDNA fragments covering hundred bases. This added information provides for more accurate genome-wide analysis and overcomes the inherent deficiencies of SAGE. The generation of longer cDNA fragments from isolated and purified protein fragments for gene identification is also disclosed. This method converts a short amino acid sequence into extended versions of the DNA sequences encoding the protein/protein fragment and additional 3? end sequences of the gene encoding the protein. This additional sequence information allows gene identification from purified protein sequences. The invention also provides a high-throughput GLGI procedure for identifying genes corresponding to a set of unidentified SAGE tags.

Abstract: A method and apparatus for parallel execution of trigger actions. One or more embodiments of the invention comprise providing a C++ class (hereinafter referred to as “dispatcher”) that can take an SQL query or trigger action and start parallel execution of the trigger action. The trigger action is optimized and parallelized. The dispatcher executes the trigger action, sets up the communication links between the various operators in the trigger action, and ensures that all the results are sent back to the trigger.

Abstract: A method, apparatus, and an article of manufacture for parallel execution of SQL operations from within user defined functions. One or more embodiments of the invention provide the user defined function (UDF) with a C++ class (hereinafter referred to as “dispatcher”) that can take an SQL query and start parallel execution of the query. The query is optimized and parallelized. The dispatcher executes the query, sets up the communication links between the various operators in the query, and ensures that all the results are sent back to the data-server that originated the query request. Further, the dispatcher merges the results of the parallel execution and produces a single stream of tuples that is fed to the calling UDF. To provide the single stream to the calling UDF, one or more embodiments of the invention utilize a class that provides the UDF with a simple and easy-to-use interface to access the results of the nested SQL execution.

Abstract: Generation of longer cDNA fragments from SAGE tags for gene identification (GLGI) is disclosed. This method converts SAGE tags, which are about 10 base pairs in length, into their corresponding 3′ cDNA fragments covering hundred bases. This added information provides for more accurate genome-wide analysis and overcomes the inherent deficiencies of SAGE. The generation of longer cDNA fragments from isolated and purified protein fragments for gene identification is also disclosed. This method converts a short amino acid sequence into extended versions of the DNA sequences encoding the protein/protein fragment and additional 3′ end sequences of the gene encoding the protein. This additional sequence information allows gene identification from purified protein sequences. The invention also provides a high-throughput GLGI procedure for identifying genes corresponding to a set of unidentified SAGE tags.

Abstract: A method, apparatus, and an article of manufacture for parallel execution of SQL operations from within user defined functions. One or more embodiments of the invention provide the user defined function (UDF) with a C++ class (hereinafter referred to as “dispatcher”) that can take an SQL query and start parallel execution of the query. The query is optimized and parallelized. The dispatcher executes the query, sets up the communication links between the various operators in the query, and ensures that all the results are sent back to the data-server that originated the query request. Further, the dispatcher merges the results of the parallel execution and produces a single stream of tuples that is fed to the calling UDF. To provide the single stream to the calling UDF, one or more embodiments of the invention utilize a class that provides the UDF with a simple and easy-to-use interface to access the results of the nested SQL execution.

Abstract: A method, apparatus, and an article of manufacture for parallel execution of SQL operations from stored procedures. One or more embodiments of the invention provide the stored procedure (stored procedure) with a C++ class (hereinafter referred to as “dispatcher”) that can take an SQL query and start parallel execution of the query. The query is optimized and parallelized. The dispatcher executes the query, sets up the communication links between the various operators in the query, and ensures that all the results are sent back to the data-server that originated the query request. Further, the dispatcher merges the results of the parallel execution and produces a single stream of tuples that is fed to the calling stored procedure. To provide the single stream to the calling stored procedure, one or more embodiments of the invention utilize a class that provides the stored procedure with a simple and easy-to-use interface to access the results of the nested SQL execution.

Abstract: A method, apparatus, and an article of manufacture for parallel execution of SQL operations from stored procedures. One or more embodiments of the invention provide the stored procedure (stored procedure) with a C++ class (hereinafter referred to as “dispatcher”) that can take an SQL query and start parallel execution of the query. The query is optimized and parallelized. The dispatcher executes the query, sets up the communication links between the various operators in the query, and ensures that all the results are sent back to the data-server that originated the query request. Further, the dispatcher merges the results of the parallel execution and produces a single stream of tuples that is fed to the calling stored procedure. To provide the single stream to the calling stored procedure, one or more embodiments of the invention utilize a class that provides the stored procedure with a simple and easy-to-use interface to access the results of the nested SQL execution.