SAP SE
OPTIMIZATION OF RELOCATED QUERIES IN FEDERATED DATABASES USING CROSS DATABASE TABLE REPLICAS

Abstract:

Disclosed herein are system, method, and computer program product embodiments for appropriately routing requests for data stored in multiple storage mediums. An embodiment operates by maintaining a first and second data stored on a first storage medium in communication with a second storage medium. Thereafter, a replicate of the first data stored in the first storage medium may be created for the second storage medium to store a replica data mirroring the first data. Subsequently, a request for retrieval of the first data may be received. Afterward, a previous update time of the second storage medium in receiving the replicate of the first data stored in the first storage medium may be determined. Lastly, based on the previous update time, the request may be forwarded to the first storage medium or second storage medium.