MULTI-INPUT, MULTI-OUTPUT-PER-INPUT USER-DEFINED-FUNCTION-BASED DATABASE OPERATIONS

• US 20130031139A1
• Filed: 07/27/2011
• Published: 01/31/2013
• Est. Priority Date: 07/27/2011
• Status: Active Grant

• 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, Sin, Wu, Ran
• Granted Patent: US 8,805,870 B2
• Time in Patent Office: Days
• US Class Current: 707/802
• 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 data base management system that provides multiple-input, multiple-output-per-input user-defined-function-based operations, the database management system comprising:

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.

2. The database management system of claim 1 wherein the database-query processor receives 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 a multiple-output-per-input user-defined-function implements 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 that implements processing of a call-detail-record table identities 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 time interval.

5. The database management system of claim 4 wherein the multiple-output-per-input user-defined-function that implements processing of a call-detail-record table 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.

6. The database management system of claim 5 wherein the multiple-output-per-input user-defined-function that implements processing of a call-detail-record table outputs, in response to receiving each call-detail-record-table input by an input-transmitting call, no, one, or 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.

7. The database management system of claim 1 wherein the multiple-input, multiple-output-per-input user-defined-function stores information maintained across a first and subsequent input-transmitting calls made by the database-query processor in a first memory buffer of the three different memory buffers.

8. The database management system of claim 7 wherein the 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.

9. The database management system of claim 1 wherein the multiple-input, multiple-output-per-input user-defined-function stores information, in a second memory buffer of the three different memory buffers, that is maintained during processing of a received input-transmitting call.

10. The database management system of claim 9 wherein the 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.

11. The database management system of claim 1 wherein the multiple-input, multiple-output-per-input user-defined-function stores information, in a third memory buffer of the three different memory buffers, returned during transmission of each of no, one, or multiple outputs in response to receiving an input-transmitting call.

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

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 invocation of the multiple-input, multiple-output-per-input user-defined function by the database-query processor;

associating three memory butlers with the multiple-input, multiple-output-per-input user-defined function, the contents of which are maintained for three different time periods during operation of the multiple-input, multiple-output-per-input user-defined function; and

computing and returning to the database-query processor multiple outputs in response to at least one of the multiple inputs.

14. The method of claim 13 wherein the database-query processor receives 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 wherein the multiple-input, multiple-output-per-input user-defined-function stores information maintained across a first and subsequent input-transmitting calls made by the database-query processor in a first memory buffer of the three different memory buffers, the 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 database management system of claim 14 wherein the multiple-input, multiple-output-per-input user-defined-function stores information, in a second memory buffer of the three different memory buffers, that is maintained during processing of a received input-transmitting call, the 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 database management system of claim 14 wherein the multiple-input, multiple-output-per-input user-defined-function stores information, in a third memory buffer of the three different memory buffers, returned during transmission of each of no, one, or multiple outputs in response to receiving an input-transmitting call, the information stored in the second memory buffer includes 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, executed on a computer processor controlled by computer instructions stored in a computer-readable memory, 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 invocation of the multiple-input, multiple-output-per-input user-defined function by the database-query processor;

associating three memory buffers with the multiple-input, multiple-output-per-input user-defined function, the contents of which are maintained for three different time periods during operation of the multiple-input, multiple-output-per-input user-defined function; and

computing and returning to the database-query processor call detail records of the processed call-detail-record table.

19. The method of claim 18 wherein the multiple-output-per-input user-defined-function that processes the call-detail-record table 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 time interval.

20. The method of claim 19

wherein the multiple-output-per-input user-defined-function that processes the call-detail-record table 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 that processes the call-detail-record table outputs, in response to receiving each call-detail-record-table input by an input-transmitting call, no, one, or 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.