US 12,111,805 B2
Automatic data store architecture detection
Guy Shaked, Be'er Sheva (IL); Vladimir Braverman, Los Angeles, CA (US); and Marina Sadetsky, Kfar Saba (IL)
Assigned to TAMIRAS PER PTE. LTD., LLC, Dover, DE (US)
Filed by TAMIRAS PER PTE. LTD., LLC, Dover, DE (US)
Filed on Jan. 27, 2023, as Appl. No. 18/160,969.
Application 18/160,969 is a continuation of application No. 16/280,507, filed on Feb. 20, 2019, granted, now 11,593,333.
Application 16/280,507 is a continuation of application No. 15/466,430, filed on Mar. 22, 2017, granted, now 10,223,390, issued on Mar. 5, 2019.
Application 15/466,430 is a continuation of application No. 13/139,718, granted, now 9,607,022, issued on Mar. 28, 2017, previously published as PCT/IL2009/001187, filed on Dec. 14, 2009.
Claims priority of application No. 195956 (IL), filed on Dec. 15, 2008.
Prior Publication US 2023/0325368 A1, Oct. 12, 2023
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/00 (2019.01); G06F 16/21 (2019.01); G06F 16/9535 (2019.01)
CPC G06F 16/217 (2019.01) [G06F 16/213 (2019.01); G06F 16/9535 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A system comprising:
a processor;
a data store communicatively coupled to the processor, the data store having a plurality of columns of data store tables; and
a non-transitory computer-readable medium coupled to the processor having instructions that, when executed by the processor, causes the system to:
determine a first approximation of a data store architecture, the first approximation including an estimate of column sizes of the plurality of columns of data store tables, the data store tables comprising rows and columns;
receive a user query;
responsive to the received user query, determine a second approximation, the second approximation including an update of the determined first approximation;
determine that the data store has changed based at least in part on detecting when data store tables are inserted, modified, or removed from the data store by automatically carrying out data store architecture analysis comprising analysis of a relationship between the columns of data store tables, and comparing successive approximations of the data store architecture comprising respective estimates of the column sizes;
determine that at least one of an insertion of data store tables, a modification of data store tables, or a removal of data store tables is detected;
in response to determining that the at least one of an insertion of data store tables, a modification of data store tables, or a removal of data store tables is detected, output a notification about the insertion, modification, or removal .