Patent ID: 9223822
Filing Date: 2015-12-29
Classification: G06F

Abstract:
1. A method for performing indication management comprising: receiving registration criteria including information identifying a first set of one or more data elements of a first data model about which a subscriber is registered to receive notifications; performing one or more operations to a second set of one or more data elements stored in a first table of a database in accordance with a second data model, each of said one or more operations being an operation to modify one of the data elements stored in the first table, add a row to said first table or delete a row from said first table; recording in a delta table information regarding said one or more operations; executing a query that uses said delta table and said first table after being updated by said one or more operations to generate a virtual table including information regarding said one or more operations performed to said first table, wherein each row of said virtual table includes a column with an action type, said action type being one of a plurality of types including a first type indicating no change for a data element associated with said each row, wherein said query includes a first select statement that selects entries from the first table which do not exist in an inner join of the delta table and the first table and includes a row in said virtual table for each entry selected by the first select statement indicating said each entry as being said first type indicating no change and wherein said query includes a second select statement that results in one or more others of said plurality of types being included in one or more rows of the virtual table, wherein said first select statement includes a third select statement comprising an inner join clause that is executed to determine said inner join of the delta table and the first table, and wherein said second select statement includes a left join clause that is executed to determine a left join of the delta table and the first table; performing first processing to determine notifications for the subscriber regarding data elements of the first set in accordance with said registration criteria, said first processing using information including said virtual table, wherein no notification is sent to the subscriber as a result of said first processing for any row of the virtual table having an action type of the first type indicating no change; and sending a notification to the subscriber as a result of said first processing for at least one row of the virtual table having an action type other than said first type.