Using average replication latency to influence routing query transactions
US-9229999-B2 · Jan 5, 2016 · US
US9418134B2 · US · B2
| Field | Value |
|---|---|
| Publication number | US-9418134-B2 |
| Application number | US-201615010713-A |
| Country | US |
| Kind code | B2 |
| Filing date | Jan 29, 2016 |
| Priority date | Mar 11, 2014 |
| Publication date | Aug 16, 2016 |
| Grant date | Aug 16, 2016 |
A practical reading order for non-experts. Skip the full description unless you need deep technical detail.
What the patent document calls the invention.
A short plain-language summary of the technical disclosure.
Who owns or filed the patent and who is credited as inventor.
Filing, priority, publication, and grant dates set the timeline.
The legal scope of protection — read this for what is actually claimed.
Technology tags used to group this patent with similar filings.
Prior art links and similar publications in this corpus.
Official abstract text for this publication.
A computer-implemented method, carried out by one or more processors, for managing replication configurations. In an embodiment, the method comprises receiving, by one or more processors, a replication configuration for replicating data, wherein the replication configuration defines at least a target table in a target database based on a source table in a source database; initializing, by one or more processors, a federated view, wherein the federated view is based on at least the source table in the source database as defined in the replication configuration; utilizing, by one or more processors, the federated view to satisfy requesting applications, where requesting applications obtain data from the federated view; responsive to determining the replication of data is in spec, utilizing, by one or more processors, the target table in the target database to satisfy requesting applications.
Opening claim text (preview).
What is claimed is: 1. A method for managing replication configurations, the method comprising: receiving, by one or more processors, a first replication configuration for replicating data, wherein the first replication configuration defines at least a target table in a target database based on a source table in a source database; determining, by one or more processors, a latency value, wherein the latency value represents a latency of replicating data from the source database to the target database; responsive to determining the latency value exceeds a threshold latency value and a portion of the target table in the target database is damaged, determining, by one or more processors, to utilize a first federated view to satisfy requesting applications; initializing, by one or more processors, the first federated view, wherein the first federated view is based on at least the source table in the source database as defined in the first replication configuration; utilizing, by one or more processors, the first federated view to satisfy requesting applications, wherein requesting applications obtain data from the first federated view; responsive to determining, by one or more processors, the source table matches the target table, utilizing, by one or more processors, the target table in the target database to satisfy requesting applications; responsive to determining the source table does not match the target table, initializing, by one or more processors, a second federated view, wherein the second federated view is based on at least the target table in the target database in the first replication configuration; utilizing, by one or more processors, the second federated view to satisfy requesting applications, where requesting applications obtain data from the second federated view; receiving, by one or more processors, a second replication configuration for replicating data, wherein the second replication configuration defines at least a new target table based on the source table; responsive to determining, by one or more processors, the target table matches the new target table, utilizing, by one or more processors, the new target table in the target database to satisfy requesting applications; responsive to determining the target table does not match the new target table, initializing, by one or more processors, a third federated view, wherein the third federated view is based on at least the new target table in the target database in the second replication configuration; and utilizing, by one or more processors, the third federated view to satisfy requesting applications, where requesting applications obtain data from the third federated view.
Tablespace storage structures; Management thereof · CPC title
Synchronous replication · CPC title
in federated or virtual databases · CPC title
Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor · CPC title
Physics · mapped topic
Related publications grouped by family.
Answers are generated from the same data shown on this page.