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.

Date of Patent:
Jun. 18, 2024

Filed:

Mar. 31, 2022
Applicant:

Bmc Software, Inc., Houston, TX (US);

Inventors:

Oscar J. Garza, Helotes, TX (US);

Kenneth J. Durfee, Round Rock, TX (US);

Mohamad A. Elhage, Austin, TX (US);

Assignee:

BMC Software, Inc., Houston, TX (US);

Attorney:
Primary Examiner:
Int. Cl.
CPC ...
G06F 16/00 (2019.01); G06F 11/14 (2006.01); G06F 11/30 (2006.01); G06F 16/22 (2019.01); G06F 16/23 (2019.01);
U.S. Cl.
CPC ...
G06F 11/1469 (2013.01); G06F 11/1435 (2013.01); G06F 11/1448 (2013.01); G06F 11/1458 (2013.01); G06F 11/1471 (2013.01); G06F 11/3075 (2013.01); G06F 11/3086 (2013.01); G06F 16/2282 (2019.01); G06F 16/2358 (2019.01);
Abstract

Described systems and techniques enable log recovery that spans inter-tablespace movement of one or more tables within a database. Log-related processing, including, e.g., system recovery, auditing, or reporting, may be maintained, even when such inter-tablespace table movements occur within a time window defined for the log-related processing. A table movement of a moved table from a source tablespace to a target tablespace within a database may be identified. Within a plurality of log records of the database, pre-move log records identifying the moved table as being included within the source tablespace may be identified, and post-move log records identifying the moved table as being included within the target tablespace may be identified. The pre-move log records may be updated to obtain updated pre-move log records identifying the moved table as being included within the target tablespace.


Find Patent Forward Citations

Loading…