Logical range logging

• US 20040193654A1
• Filed: 03/31/2003
• Published: 09/30/2004
• Est. Priority Date: 03/31/2003
• Status: Abandoned Application

• Current Assignee: Hewlett-Packard Development Company, L.P. (HP Inc.)
• Original Assignee: Hewlett-Packard Development Company, L.P. (HP Inc.)
• Inventors: Peleg, Nitzan, Sherman, Yuval
• Application Number:
  US10/403,499
• Publication Number:
  US 20040193654A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2393 Updating materialised views

Abstract

The disclosed embodiments may relate to a system for performing logical range logging. The system may include a refresh log that may contain entries and a database management system (“DBMS”) that may read the refresh log and employ buffers to perform a refresh operation on a table using the entries. The DBMS may determine if a last row of a previous one of the plurality of buffers is allocated and assign a status attribute for the last row of the previous buffer if the previous buffer is allocated. The DBMS may determine if a current row in a current buffer is a last row to be inserted into the table as part of the refresh operation.

Claims

1. A system for performing logical range logging, the system comprising:

a refresh log that contains a plurality of entries; and

a database management system (“

DBMS”

) to read the refresh log and employ a plurality of buffers, including a previous and a current buffer, to perform a refresh operation on a table using the plurality of entries, the DBMS being adapted to;

determine if a last row of a previous one of the plurality of buffers is allocated;

assign a status attribute for the last row of the previous buffer if the previous buffer is allocated; and

determine if a current row in a current buffer is a last row to be inserted into the table as part of the refresh operation.

2. The system set forth in claim 1, wherein the DBMS outputs the current row in the current buffer depending on the determination of whether the current row in the current buffer is the last row to be inserted.

3. The system set forth in claim 1, wherein the DBMS determines whether a non-acknowledge condition (“

NAK”

) was returned when the last row of the previous buffer was projected as output.

4. The system set forth in claim 1, wherein the DBMS determines whether the previous buffer comprised a single row.

5. The system set forth in claim 1, wherein the DBMS determines whether the last row of the previous buffer was the beginning of a logical range.

6. The system set forth in claim 1, wherein the plurality of entries each contains a row type attribute and a range size attribute.

7. A system for performing logical range logging, the system comprising:

a refresh log that contains a plurality of entries; and

a database management system (“

DBMS”

) that reads the refresh log and employ a plurality of buffers to perform a refresh operation on a table using the plurality of entries, the DBMS being adapted to;

determine if a Range Protector Key (“

RPK”

) is received in response to a row being projected as output from one of the plurality of buffers;

project a current row of a current one of the plurality of buffers as output as a single row if an RPK was not received;

save the current row of the current buffer as a last row of the current buffer and not project the current row of the current buffer as output if an RPK was received and the current row of the current buffer is the last row of the current buffer.

8. The system set forth in claim 7, wherein the RPK is generated by a B-Tree software component.

9. The system set forth in claim 7, wherein the plurality of entries each contains a row type attribute and a range size attribute.

10. A method of performing logical range logging in a computer system, the computer system comprising a refresh log that contains a plurality of entries and a database management system (“

DBMS”

) that reads the refresh log and employs a plurality of buffers to perform a refresh operation on a table using the plurality of entries, the method comprising;

determining if a last row of a previous one of the plurality of buffers is allocated;

assigning a status attribute for the last row of the previous buffer if the previous buffer is allocated;

determining if a current row in a current buffer is a last row to be inserted into the table as part of the refresh operation to create a status attribute associated with the current row of the current buffer; and

projecting the current row of the current buffer as output depending on the status attribute associated with the current row of the current buffer.

11. The method set forth in claim 10, comprising determining whether a non-acknowledge condition (“

NAK”

) was returned if the last row of the previous buffer was projected as output.

12. The method set forth in claim 10, comprising determining whether the previous buffer comprised a single row.

13. The method set forth in claim 10, comprising determining whether the last row of the previous buffer was the beginning of a logical range.

14. The method set forth in claim 10, wherein the recited acts are performed in the recited order.

15. A method of performing logical range logging in a computer system, the computer system comprising a refresh log that contains a plurality of entries and a database management system (“

DBMS”

) that is adapted to read the refresh log and employ a plurality of buffers to perform a refresh operation on a table using the plurality of entries, the method comprising;

determining whether a Range Protector Key (“

RPK”

) is received in response to a row being projected as output from one of the plurality of buffers;

outputting a current row of a current one of the plurality of buffers as a single row if an RPK was not received; and

saving the current row of the current buffer as a last row of the current buffer and not projecting the current row of the current buffer as output if an RPK was received and the current row of the current buffer is the last row of the current buffer.

16. The method set forth in claim 15, comprising employing a B-Tree software component to generate the RPK.

17. The method set forth in claim 15, wherein the recited acts are performed in the recited order.

18. A computer system, comprising:

a database;

a refresh log that contains a plurality of entries; and

a database management system (“

DBMS”

) to manage the database, to read the refresh log and to employ a plurality of buffers, including a previous and a current buffer, to perform a refresh operation on a table of the database using the plurality of entries, the DBMS being adapted to;

determine if a last row of a previous one of the plurality of buffers is allocated;

assign a status attribute for the last row of the previous buffer if the previous buffer is allocated; and

determine if a current row in a current buffer is a last row to be inserted into the table as part of the refresh operation.

19. The computer system set forth in claim 18, wherein the DBMS outputs the current row in the current buffer depending on the determination of whether the current row in the current buffer is the last row to be inserted.

20. The computer system set forth in claim 18, wherein the DBMS determines whether a non-acknowledge condition (“

NAK”

) was returned when the last row of the previous buffer was projected as output.

21. The computer system set forth in claim 18, wherein the DBMS determines whether the previous buffer comprised a single row.

22. The computer system set forth in claim 18, wherein the DBMS determines whether the last row of the previous buffer was the beginning of a logical range.

23. The computer system set forth in claim 18, wherein the plurality of entries each contains a row type attribute and a range size attribute.

24. A computer system, comprising:

a database;

a refresh log that contains a plurality of entries; and

a database management system (“

DBMS”

) to manage the database and to read the refresh log and employ a plurality of buffers to perform a refresh operation on a table using the plurality of entries, the DBMS being adapted to;

determine if a Range Protector Key (“

RPK”

) is received in response to a row being projected as output from one of the plurality of buffers;

project a current row of a current one of the plurality of buffers as output as a single row if an RPK was not received;

save the current row of the current buffer as a last row of the current buffer and not project the current row of the current buffer as output if an RPK was received and the current row of the current buffer is the last row of the current buffer.

25. The computer system set forth in claim 24, wherein the RPK is generated by a B-Tree software component.

26. The computer system set forth in claim 24, wherein the plurality of entries each contains a row type attribute and a range size attribute.