Patent · US Active

Query hints for caching and replication

US10275508B2 · kind B2 · utility

4Cited by

3References

20Claims

0Family size

Assignee

SAP SE · DE

Inventors

Christian Bensberg · Heidelberg, DE
Norman May · Karlsruhe, DE
Alexander Boehm · Sandhausen, DE
Juchang Lee · Seoul, KR
Sung Heun Wi · Opo-eup, KR
Jeong A Han · Ansan-si, KR
Ki Hong Kim · Seoul, KR
Kyu Hwan Kim · Anyang-si, KR
Chul Won Lee · Seoul, KR
Andreas Kemmler · Brackenheim, DE
Christoph Glania · Östringen, DE
Armin Risch · Union City, US
Kai Morich · Hockenheim, DE

Key dates

Filing date	Nov 19, 2015
Grant date	Apr 30, 2019
Priority date	—
Expiry date	Aug 25, 2037

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/24552
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

A method may include receiving a query for data to be provided by a database server, wherein the query includes an indication of a maximum lag. The method may further include determining whether a hint is available to apply to the query, wherein the hint affects an execution of the query. When no hint is available, a baseline database server may be selected to be the database server. When the hint is available, a replication server or a cache server may be selected to be the database server based on the hint and the maximum lag. The query may be processed at the selected database server.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.