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:
Jul. 30, 2024
Filed:
Nov. 11, 2021
Oracle International Corporation, Redwood Shores, CA (US);
Sachin Vijakumar Sonawane, Foster City, CA (US);
Mahesh Baburao Girkar, Los Altos, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
Abstract
Techniques described herein allow a standby DBMS to maintain consistency of results for transactions that include redirected DML commands without requiring the standby DBMS to delay execution of queries that do not require changed objects. Specifically, a standby session records DML target object (DTO) record with information regarding DML-changed objects and transaction information from the primary DBMS. Using DTO records, the standby DBMS ensures that results of any additional queries include changes made by the redirected DML commands without delaying execution of queries that do not access changed objects. If a target object in a standby query is in a DTO record, then query execution is delayed until the standby database is updated to the timestamp indicated in the DTO record. Thus, the delayed query has access to changes made by the DML command. Otherwise, the query is immediately executed without waiting for the standby database synchronization.
Data source: USPTO (United States Patent and Trademark Office) public patent records. Weekly synchronization. How IDiyas builds this profile