IP Library Granted Patent US 7,523,213
Granted Patent B1
US 7,523,213 · App. 12/124,108 · Granted Apr 21, 2009

Efficient approach with the toleration of stale data to dynamically transform and unify data quality in client and server with continuous transaction flows

View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 7,523,213
App. No.
12/124,108
Granted
Apr 21, 2009
Kind
B1
Abstract

Discrepancies between client replication data quality information and server replication data quality information may be addressed by recording and transmitting the transaction processing rate for the server. The transaction processing rate may be used in conjunction with the number of transactions the server is behind to determine the transaction delay. The transaction delay may also be used in conjunction with the transaction processing rate to calculate the transaction lag. Using this information, the client and server may have a similar understanding of the replication data quality. This information may be cached and used to determine what servers requests should be routed to. Each time a client makes a request, the transaction processing rate and/or the transaction lag for the given server may be inserted into the replication data stream. The values inserted into the replication data stream may invalidate and replace the cached values.

Claims (8)

1. A method for addressing discrepancies between client replication data quality information and server replication data quality information comprising the steps of:

calculating a maximum allowable transaction lag;

identifying one or more servers having a historical transaction lag less than said maximum allowable transaction lag;

sending a request to at least one of the identified one more or servers;

calculating, in at least one of the identified one more or servers, a modified maximum allowable transaction lag;

determining whether a current transaction lag is less than said modified maximum allowable transaction lag;

processing the request in the server; and

responding to the request, said response including the current transaction lag.

Assignments (3)
CHANGE OF NAME Recorded Aug 26, 2014
From: SAP AG
To: SAP SE
Reel/Frame 033625/0334 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jul 12, 2012
From: INTERNATIONAL BUSINESS MACHINES CORPORATION
To: SAP AG
Reel/Frame 028540/0522 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Sep 19, 2008
From: SHEN, JINMEI; WANG, HAO
To: INTERNATIONAL BUSINESS MACHINES CORPORATION
Reel/Frame 021560/0320 →