One-to-many data conversions by extending relational algebra

This paper expresses one-to-many transformations by extending relational algebra to resolve the problem that relational expressions are difficult to execute one-to-many data transformations, the recursive query and the table function should be employed to realize unbounded one-to-many transformations for producing one or several output tuples over every input tuples. Recursive queries create original results to obtain result sets by recursion and return final result sets. Table functions declare variable sets and employ a procedure body and cursor to access tables, iterative output tuples. Experimental analysis different bounded and unbounded data transformations under different reference influencing factor, results show that the extension method improves performance observably.