Abstract: Systems and methods for publishing information to a plurality of software applications are provided. The methods may comprise identifying a plurality of records based on a last sequential identification code in a high watermark table of a persistent store. The plurality of records may be generated subsequent to a previous record corresponding to the last sequential identification code. A plurality of corresponding messages each corresponding to a record of the plurality of records may be prepared. Each of those messages may then be transmit to at least one software application and may include a most recent message corresponding to a most recent record. In the high water mark table of the persistent store, an updated last sequential identification code may be stored as a pointer for subsequent reference. The updated last sequential identification code may correspond to the most recent message transmitted in the plurality of corresponding messages.

Abstract: Systems and methods for publishing information to a plurality of software applications are provided. The methods may comprise identifying a plurality of records to transmit to the software applications based on a last sequential identification code in a high watermark table of a persistent store. The plurality of records may be generated subsequent to a previous record corresponding to the last sequential identification code. A plurality of corresponding messages each corresponding to a record of the plurality of records may be prepared. Each of those messages may then be transmit to at least one software application and may include a most recent message corresponding to a most recent record. In the high water mark table of the persistent store, an updated last sequential identification code may be stored as a pointer for subsequent reference. The updated last sequential identification code may correspond to the most recent message transmitted in the plurality of corresponding messages.

Abstract: A “push” based publication model in which messages are sent automatically to communicate event related data to other system applications when an event occurs that causes a change to a persistent data store. A shadow table stores records relating to information stored in the main table. Each record is assigned a sequentially ordered identification code. A high water mark table stores the identification number of the last message published for a group of messages, and thus points to where publication last stopped. By using sequentially ordered codes, it is readily apparent from a gap in the sequence codes whether a record/message is missing. The shadow table may be configured as an Index Ordered Table to eliminate a query “hop” from the index table to the shadow table. The persistent store is queried to identify changes in persistent store structure, and the message structure is modified automatically to reflect any changes.