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:
Jun. 06, 2023
Filed:
Nov. 18, 2021
International Business Machines Corporation, Armonk, NY (US);
Daniel Martin, Leinfelden-Echterdingen, DE;
Christian Wilhelm Paul Hoerst, Boeblingen, DE;
Jens Müller, Stuttgart, DE;
Johannes Severin Kern, Boeblingen, DE;
Kevin Pelletier, Saint-Genis Pouilly, FR;
Vassil Radkov Dimov, Stuttgart, DE;
Namik Hrle, Boeblingen, DE;
International Business Machines Corporation, Armonk, NY (US);
Abstract
Creating at a target database system, a target table and a history table each having a set of attributes of a source table in addition to at least one time attribute, wherein the time attribute of a record indicates the time when the record is valid. Receiving a request for applying a change of the source table to the target table. The request comprises a time value generated by the source database system indicating a time of the change. The change to the target table and the time value may be assigned to the time attribute of the current version and previous version of the record. The previous version of the record may be stored in the history table. The target table and the history table may be used to process a redirected query comprising a selection criterion on the time attribute.