Abstract: A method, apparatus, and article of manufacture for improving the performance of evaluating predicates with non-matching operands by aggressively casting the input value to the data type of the target column before the data of the target column is accessed.

Abstract: A method, apparatus, and article of manufacture for improving the performance of evaluating predicates with non-matching operands by aggressively casting the input value to the data type of the target column before the data of the target column is accessed.

Abstract: This invention provides an integrated compiler for compiling SQL3 control statements having procedural, i.e., control, information packaged together with query, i.e., non-procedural, statements. A query extractor contained within the parser extracts the query statement from the control statement leaving a control skeleton. The query statement is processed as usual through a query compiler for generating executable plans with the exception that the name resolution function for resolving variables is modified for looking up local variables. This modification takes into account the mapping of local and host variables to create a unification of local and host variables. The control skeleton is processed through a control analyzer which generates a representation of the control flow and a scope and symbol table. The control analyzer also unifies the local and host variables.

Abstract: A versioned-data management system is provided with a method for detecting independent changes to a part when an attempt is made to promote a variant of the part. For each variant of a part, there is maintained two identifiers and a flag. The first identifier is the identifier of the last change to that variant. The second identifier is the last-change identifier of the variant which was the source of the drawdown. When the variant is successfully promoted, and there was not previously a variant at the level to which it is promoted, its drawdown-from identifier value is not changed. When the variant is successfully promoted, and there was previously a variant at the level to which it is promoted, the drawdown-from identifier is set to the drawdown-from identifier value of the variant which was previously at the level to which the promote is made.