Multi-input, multi-output-per-input user-defined-function-based database operations

A method carried out by a database management system that includes at least one processor and an electronic memory and a database-query processor, executed on a computer processor controlled by computer instructions stored in a computer-readable memory, to provide a multiple-input, multiple-output-per-input user-defined function by:

• initializing the multiple-input, multiple-output-per-input user-defined function following an invocation of the multiple-input, multiple-output-per-input user-defined function by the database-query processor;
• in response to the invocation of the multiple-input, multiple-output-per-input user-defined function:
• setting up a first memory buffer to maintain first input information for a lifetime of the invocation, wherein the first input information is provided to the multiple-input, multiple-output-per-input user-defined-function;
• setting up a second memory buffer to maintain second input information for a lifetime of each one of multiple calls to the multiple-input, multiple-output-per-input user-defined-function, wherein the second input information is provided to the multiple-input, multiple-output-per-input user-defined-function;
• and
• setting up a third memory buffer to maintain output information for a lifetime of generating output tuples for a particular input, wherein the output information is provided by the multiple-input, multiple-output-per-input user-defined-function.

A method, carried out by a database management system that includes at least one processor and an electronic memory and a database-query processor, to process a call-detail-record table to replace multiple call detail records corresponding to a single call within the call-detail-record table by a single call detail record, the method comprising:

• initializing a multiple-input, multiple-output-per-input user-defined function following an invocation of the multiple-input, multiple-output-per-input user-defined function by the database-query processor;
• in response to the invocation of the multiple-input, multiple-output-per-input user-defined function:
• setting up a first memory buffer to maintain first input information for a first period equal to a lifetime of the invocation, wherein the first input information is provided to the multiple-input, multiple-output-per-input user-defined-function;
• setting up a second memory buffer to maintain second input information for a second period, wherein the second input information is provided to the multiple-input, multiple-output-per-input user-defined-function;
• and
• setting up a third memory buffer to maintain output information for a third period, wherein the output information is provided by the multiple-input, multiple-output-per-input user-defined-function.