US 12,282,496 B2
Access to data of a data analysis system by external database systems
Jens Müller, Stuttgart (DE); Felix Beier, Haigerloch (DE); Vassil Radkov Dimov, Stuttgart (DE); Eirini Kalogeiton, Stuttgart (DE); and Johannes Severin Kern, Boeblingen (DE)
Assigned to International Business Machines Corporation, Armonk, NY (US)
Filed by International Business Machines Corporation, Armonk, NY (US)
Filed on Jun. 20, 2023, as Appl. No. 18/337,684.
Claims priority of application No. 20230100070 (GR), filed on Jan. 30, 2023.
Prior Publication US 2024/0256569 A1, Aug. 1, 2024
Int. Cl. G06F 16/27 (2019.01); G06F 16/23 (2019.01)
CPC G06F 16/273 (2019.01) [G06F 16/2379 (2019.01); G06F 16/278 (2019.01)] 13 Claims
OG exemplary drawing
 
1. A computer-implemented method comprising:
providing, by one or more processors, a data analysis system comprising a source database system and a target database system, the data analysis system operable to synchronize data in the source database system with the target database system using a primary source transaction log in the source database system and a primary target transaction log in the target database system;
creating, by one or more processors, a secondary transaction log;
storing, by one or more processors, the secondary transaction log in a physical log buffer;
receiving, by one or more processors, from the target database system, data changes applied at the target database system;
creating, by one or more processors, in the secondary transaction log, for each received data change, at least one log entry that represents the respective received data change;
associating, by one or more processors, with each external database system of a set of external database systems, a logical log buffer tracking a subscription progress of the respective external database system;
determining, by one or more processors, that an entry has been used by the external database system by using subscription information of a first external database system of the set of external database systems, the subscription information comprising information on applying changes at the first external database system;
providing, by one or more processors, the secondary transaction log to the set of external database systems, for causing the data changes to be applied according to the secondary transaction log, thereby causing the data to be stored in the set of external database systems; and
responsive to determining that changes associated with removed entries have been applied by the set of external database systems, removing, by one or more processors, log entries of the secondary transaction log, where removing the log entries is performed using the physical log buffer and the logical log buffers.