Browse Prior Art Database

Method and System for Efficiently Updating Changes from a Database to a Client

IP.com Disclosure Number: IPCOM000202325D
Publication Date: 2010-Dec-14
Document File: 2 page(s) / 60K

Publishing Venue

The IP.com Prior Art Database

Abstract

A method and system is disclosed for efficiently updating changes from a database to a client. The changes are transmitted from the database to the client through one or more data feeds in accordance with a publish-subscribe model.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 51% of the total text.

Page 01 of 2

Method and System for Efficiently Updating Changes from a Database to a Client

Disclosed is a method and system for efficiently updating changes from a database to a client. The changes are transmitted from the database to the client through one or more data feeds in accordance with a publish-subscribe model.

The figure illustrates the publish-subscribe model to facilitate feeds from the database to the client. The changes associated with the feeds may be, one or more of, but not limited to, insert, update, and delete. The publish-subscribe model includes a publisher and a subscriber. The publisher is included in one or more of the database and an Application Programming Interface (API) to access the database. The publisher is included in the API by extending implementation of a Statement Object for generating the events. Alternatively, a connection class may also be extended to include the publisher in the API.

The publisher publishes an entire schema as topics of interest. For example, the publisher publishes all the tables of the database under a topic. Additionally, a client as a subscriber sends a subscribe request to the publisher for the schema. Upon accepting the subscribe request, the client is registered with the publisher for the notifications. Thereafter, if a change is identified in the schema, the publisher as a Notification Producer (NP) notifies the subscribers by generating the events. For example, an insert event is generated upon identifying that an entry is inserted in a row of the database.

The subscriber receives the notification from the publisher as a Notification Consumer (NC). As illustrated in the figure, a synchronization/row merger module and a client act as...