Performing sequence analysis as a multipart plan storing intermediate results as a relation
View Patent ↗A usage model and the underlying technology used to provide sequence analysis as part of a relational database system. Included components include the semantic and syntactic integration of the sequence analysis with an existing query language, the storage methods for the sequence data, and the design of a multipart execution scheme that runs the sequence analysis as part of a potentially larger database query, especially using parallel execution techniques.
1. A method for sequence analysis in a relational database, comprising:
generating an optimized execution plan according to processor, memory and disk requirements;
designating an inner table to a relational join operation as at least one query sequence and an outer table to the relational join operation as at least one subject sequence if the at least one query sequence requires a smaller amount of memory than the at least one subject sequence, designating the inner table to the relational join operation as the at least one subject sequence and the outer table to the relational join operation as the at least one query sequence if the at least one subject sequence requires a smaller amount of memory than the at least one query sequence, and, if an amount of available memory is insufficient to individually store the at least one query sequence and the at least one subject sequence, designating the inner table to the relational join operation as the at least one subject sequence to be stored to a disk;
storing a control table in the relational database;
performing a first part of the execution plan as a cross-product join relational database operation to the control table of the designated inner table in the relational database; and
performing a second part of the execution plan as a join relational database operation of the results of the cross-product join relational database operation, as a resultant inner table, and the designated outer table in the relational database.
2. The method as in claim 1 further comprising performing a statistics scan of the subject sequence.
3. The method as in claim 1 further comprising:
dividing execution of the execution plan into a plurality of snippets; and
performing each snippet of the execution plan at a host or one of a plurality of Snippet Processing Units (SPUs).