{"schema_version":"1.0","canonical_url":"https://patentable.app/patents/US-11468060","patent":{"patent_number":"US-11468060","title":"Automatic query offloading to a standby database","assignee":null,"inventors":[],"filing_date":"2018-06-25T00:00:00.000Z","publication_date":"2022-10-11T00:00:00.000Z","cpc_codes":["G06F","G06F","G06F","G06F","G06F","G06F","G06F"],"num_claims":26,"abstract":"Embodiments allow a primary database system (“primary”) to automatically detect queries directed to the primary database that may be offloaded to a standby database system (“standby”), and then to automatically offload the offload-eligible queries to a standby. The primary identifies offload-eligible queries based on a record of up-to-date database objects within each standby that replicates the primary database. The record of up-to-date standby objects is updated based on heartbeat messages from each standby, and commit timestamps for transactions on the primary. Evaluation of whether a query is offload-eligible is triggered by one or more trigger conditions that include: inclusion of an offload optimizer hint in the query, an estimated run-time of the query, etc. Embodiments further allow an offloaded query over particular changed data in the primary database to access, on a standby database, uncommitted changes made to the particular data in the primary database."},"analysis":{"summary":null,"layman_explanation":null,"technical_analysis":null,"business_analysis":null,"faqs":null,"topics":[],"tech_cluster":null},"seo":{"title":"Automatic query offloading to a standby database","description":"Embodiments allow a primary database system (“primary”) to automatically detect queries directed to the primary database that may be offloaded to a standby database system (“standby”), and then to aut","keywords":[]},"attribution":{"source":"Patentable","source_url":"https://patentable.app","canonical_url":"https://patentable.app/patents/US-11468060","license":"CC-BY-4.0-like","license_terms":"AI-generated analysis on this page (summary, layman_explanation, technical_analysis, business_analysis, faqs) may be reused with attribution and a visible link back to the canonical URL above. Patent abstracts, claims, and bibliographic data are USPTO public domain.","required_link":"https://patentable.app/patents/US-11468060","citation_suggestion":"Patentable. \"Automatic query offloading to a standby database\" (US-11468060). https://patentable.app/patents/US-11468060","copyright_holder":"Nomic Interactive Technology LLC"},"links":{"html":"https://patentable.app/patents/US-11468060","json":"https://patentable.app/api/llm-context/US-11468060","site":"https://patentable.app","llms_txt":"https://patentable.app/llms.txt"},"generated_at":"2026-05-31T14:09:01.360Z"}