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

• US 8,805,870 B2
• Filed: 07/27/2011
• Issued: 08/12/2014
• Est. Priority Date: 07/27/2011
• Status: Expired due to Fees

• Current Assignee: Hewlett Packard Enterprise Development LP (Hewlett-Packard Enterprise Company)
• Original Assignee: Hewlett-Packard Development Company, L.P. (HP Inc.)
• Inventors: Chen, Qiming, Hsu, Meichun, Zhang, Bin, Wu, Ren
• Primary Examiner(s): TRAN, ANHTAI V
• Application Number:
  US13/192,373
• Publication Number:
  US 20130031139A1
• Time in Patent Office: 1,112 Days
• Field of Search: None
• US Class Current: 707/769
• CPC Class Codes: G06F 16/2443 Stored procedures

Abstract

The current application discloses a database management system that provides multiple-input, multiple-output-per-input user-defined-function-based operations. The database management system comprises at least one processor and electronic memory, a database-query processor, executed on a computer processor controlled by computer instructions stored in a computer-readable memory, that makes multiple calls to a multiple-input, multiple-output-per-input user-defined-function, in each call transmitting a next input to the multiple-input, multiple-output-per-input user-defined-function, and the multiple-input, multiple-output-per-input user-defined-function, executed on a computer processor controlled by computer instructions stored in a computer-readable memory, that uses three different memory buffers, the contents of which are maintained for three different time periods, to compute and return to the database-query processor multiple outputs in response to at least one of the multiple inputs.

Claims

1. A database management system comprising:

at least one processor and electronic memory;

a database-query processor to make multiple calls to a multiple-input, multiple-output-per-input user-defined-function;

the multiple-input, multiple-output-per-input user-defined-function to, in response to an invocation;

set 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;

set 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

set 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.

2. The database management system of claim 1 wherein the database-query processor is to receive multiple outputs from the multiple-output-per-input user-defined-function in response to transmitting an input to the multiple-output-per-input user-defined-function by calling the multiple-input, multiple-output-per-input user-defined-function two or more times to receive, as a result of each call, a next output of the multiple outputs.

3. The database management system of claim 2 wherein the multiple-output-per-input user-defined-function is to implement processing of a call-detail-record table by which multiple call detail records corresponding to a single call within the call-detail-record table are replaced by a single call detail record.

4. The database management system of claim 3 wherein the multiple-output-per-input user-defined-function identifies the multiple call detail records corresponding to the single call as two or more call detail records containing equivalent information describing the single call and having time stamps with values that fall within a time window corresponding to time interval.

5. The database management system of claim 4 wherein the multiple-output-per-input user-defined-function maintains a window of call detail records extracted from the call-detail-record table, each call detail record of the window to be input to the multiple-output-per-input user-defined-function in a single input-transmitting call.

6. The database management system of claim 5 wherein the multiple-output-per-input user-defined-function outputs, in response to receiving each call-detail-record-table input by an input-transmitting call, multiple call detail records of the processed call-detail-record table, wherein the multiple call detail records are to be replaced with a single call detail record.

7. The database management system of claim 1 wherein the first input information stored in the first memory buffer includes one or more arguments passed to the multiple-input, multiple-output-per-input user-defined-function when the multiple-input, multiple-output-per-input user-defined-function is invoked.

8. The database management system of claim 1 wherein the second input information stored in the second memory buffer includes data passed to the multiple-input, multiple-output-per-input user-defined-function in a received input-transmitting call.

9. The database management system of claim 1 wherein the third memory buffer is to store output tuples generated for a particular input.

10. The database management system of claim 1, wherein the output information stored in the third memory buffer includes data returned by the multiple-input, multiple-output-per-input user-defined-function in response to receiving a input-transmitting call.

11. The database management system of claim 1, wherein the multiple-output-per-input user-defined-function is further to compute and return, to the database-query processor, multiple outputs in response to at least one of the multiple inputs.

12. The database management system of claim 1, wherein the second period is equal to a lifetime of each of the multiple calls to the multiple-input, multiple-output-per-input user-defined-function, and the third period is equal to a lifetime of generating output tuples for a particular input.

13. 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.

14. The method of claim 13 wherein the database-query processor is to receive multiple outputs from the multiple-output-per-input user-defined-function in response to transmitting an input to the multiple-output-per-input user-defined-function by subsequently calling the multiple-input, multiple-output-per-input user-defined-function two or more times to receive, as a result of each subsequent call, a next output of the multiple outputs.

15. The method of claim 14, the first input information stored in the first memory buffer including one or more arguments passed to the multiple-input, multiple-output-per-input user-defined-function when the multiple-input, multiple-output-per-input user-defined-function is invoked.

16. The method of claim 14, the second input information stored in the second memory buffer including data passed to the multiple-input, multiple-output-per-input user-defined-function in a received input-transmitting call.

17. The method of claim 14, the output information stored in the third memory buffer including data returned by the multiple-input, multiple-output-per-input user-defined-function in response to receiving a input-transmitting call.

18. 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.

19. The method of claim 18 wherein the multiple-output-per-input user-defined-function identifies multiple call detail records within the call-detail-record table corresponding to a single call as two or more call detail records containing equivalent information describing the single call and having time stamps with values that fall within a time window corresponding to a time interval.

20. The method of claim 18,

wherein the multiple-output-per-input user-defined-function maintains a window of call detail records extracted from the call-detail-record table, each call detail record input to the multiple-output-per-input user-defined-function in a single input-transmitting call;

and

wherein the multiple-output-per-input user-defined-function outputs, in response to receiving each call-detail-record-table input by an input-transmitting call, multiple call detail records of the processed call-detail-record table in which multiple call detail records identified as corresponding to a single call are replaced with a single call detail record for each call.