Maintenance of a Pre-Computed Result Set

• US 20150112922A1
• Filed: 10/17/2013
• Published: 04/23/2015
• Est. Priority Date: 10/17/2013
• Status: Active Grant

• Current Assignee: Sybase Incorporated (SAP SE)
• Original Assignee: Sybase Incorporated (SAP SE)
• Inventors: Cheng, Xun, Zhou, Xiao Ming, Du, Haiyan, Maheshwari, Nitesh, Samanta, Prabhas Kumar
• Granted Patent: US 9,703,825 B2
• Time in Patent Office: Days
• US Class Current: 707/609
• CPC Class Codes: G06F 16/2393 Updating materialised views

Abstract

A method, a system and a computer program product for maintaining a pre-computed result set are disclosed. A server coupled to a data source determines whether an object stored in the data source received an update. The server identifies at least one identifier associated with a pre-computed result set based on that determination. The pre-computed result set is computed based on the object. The server computes an updated pre-computed result set using the identifier by applying the received update to the pre-computed result set.

Claims

1. A computer implemented method comprising:

determining, using a server coupled to a data source, whether an object stored in the data source received an update;

identifying, using the server, based on the determining, at least one identifier associated with a pre-computed result set, the pre-computed result set being computed based on the object; and

computing, using the server, an updated pre-computed result set using the identifier by applying the received update to the pre-computed result set;

wherein the at least one of the determining, the identifying, and the computing is performed by at least one processor of at least one computing system.

2. The method according to claim 1, further comprising

updating, after receiving the update to a base table, the object by merging it with at least one difference between the object and the received update.

3. The method according to claim 1, wherein the updated pre-computed result set is merged with at least one difference between the object and the received update associated with the base table.

4. The method according to claim 1, wherein the object is a table containing a plurality of rows, wherein the identifier is associated with at least one row in the table.

5. The method according to claim 1, wherein the received update includes at least one of the following:

a data insert operation, a data deletion operation, and a data update operation.

6. The method according to claim 1, wherein the pre-computed result set is computed based on a plurality of objects stored in at least one data source.

7. A computer program product comprising a machine-readable medium storing instructions that, when executed by at least one programmable processor, cause the at least one programmable processor to perform operations comprising:

determining, using a server coupled to a data source, whether an object stored in the data source received an update;

identifying, using the server, based on the determining, at least one identifier associated with a pre-computed result set, the pre-computed result set being computed based on the object; and

computing, using the server, an updated pre-computed result set using the identifier by applying the received update to the pre-computed result set.

8. The computer program product according to claim 7, wherein the operations further comprise

updating, after receiving the update to a base table, the object by merging it with at least one difference between the object and the received update.

9. The computer program product according to claim 7, wherein the updated pre-computed result set is merged with at least one difference between the object and the received update associated with the base table.

10. The computer program product according to claim 7, wherein the object is a table containing a plurality of rows, wherein the identifier is associated with at least one row in the table.

11. The computer program product according to claim 7, wherein the received update includes at least one of the following:

a data insert operation, a data deletion operation, and a data update operation.

12. The computer program product according to claim 7, wherein the pre-computed result set is computed based on a plurality of objects stored in at least one data source.

13. A system comprising:

at least one programmable processor; and

a machine-readable medium storing instructions that, when executed by the at least one programmable processor, cause the at least one programmable processor to perform operations comprising;

determining, using a server coupled to a data source, whether an object stored in the data source received an update;

identifying, using the server, based on the determining, at least one identifier associated with a pre-computed result set, the pre-computed result set being computed based on the object; and

computing, using the server, an updated pre-computed result set using the identifier by applying the received update to the pre-computed result set.

14. The system according to claim 13, wherein the operations further comprise

updating, after receiving the update to a base table, the object by merging it with at least one difference between the object and the received update.

15. The system according to claim 13, wherein the updated pre-computed result set is merged with at least one difference between the object and the received update associated with the base table.

16. The system according to claim 13, wherein the object is a table containing a plurality of rows, wherein the identifier is associated with at least one row in the table.

17. The system according to claim 13, wherein the received update includes at least one of the following:

a data insert operation, a data deletion operation, and a data update operation.

18. The system according to claim 13, wherein the pre-computed result set is computed based on a plurality of objects stored in at least one data source.