The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Feb. 27, 2024
Filed:
Oct. 31, 2018
Amazon Technologies, Inc., Seattle, WA (US);
Jamie Plenderleith, Dublin, IE;
Amazon Technologies, Inc., Seattle, WA (US);
Abstract
Systems and methods are provided to implement a database request router that routes queries to database servers storing database replicas. In embodiments, the request router maintains caching state metadata that indicates respective caching states of the database servers. For an incoming query, the request router selects a database server to receive the query based on the caching states of the database servers to improve cache utilization. In embodiments, the caching state metadata indicates whether different database objects used by observed queries are cached at individual servers. The database objects used may be determined from execution plans for the queries, obtained from the database servers. In embodiments, the request router may determine a querying pattern of the database and use it to predict an expected time for certain queries. The request router may generate a priming query ahead of the expected time to prepare database server cache for the expected queries.