Automatic data store architecture detection

A computerized method comprising:

• determining a first approximation of a data store architecture of data store tables, the data store including objects, the first approximation including an estimate of attributes of the objects, the attributes including relationships between the objects;
• receiving a user query;
• responsive to the received user query, determining a second approximation, the second approximation including an update of the determined first approximation;
• determining that the data store has changed;
• determining a data store table insertion, a data store table modification, or a data store table removal detected;
• and
• output a notification of the data store insertion, the data store modification, or the data store removal.

An apparatus comprising:

• a processor;
• a data store communicatively coupled to the processor, the data store having at least one data store table;
• and
• a memory coupled to the processor and storing instructions that, when executed by the processor, causes the apparatus to perform operations including:
• determine a first approximation of a data store architecture of the at least one data store table, the first approximation including an estimate of attributes of objects of the at least one data store, the attributes including relationships between the objects;
• responsive to a 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;
• and
• in response to determining a data store table insertion, a data store table modification, or a data store table removal is detected, output a notification about the data store table insertion, data store table modification, or data store table removal.

A system comprising:

• a processor;
• a data store communicatively coupled to the processor, the data store having at least one data store table;
• and
• a memory coupled to the processor and storing instructions that, when executed by the processor, causes the system to perform operations including:
• determine a first approximation of a data store architecture, the first approximation including attributes of objects of the at least one data store, the attributes including relationships between the objects;
• determine if one or more user queries are available;
• execute a syntactic analysis of available user queries;
• use the syntactic analysis of user queries to generate statistics related to query content;
• use the statistics related to query content to determine a second approximation of the data store, the second approximation of the data store including an update of the determined first approximation;
• determine that the data store has changed based at least in part on detecting a data store table insertion, a data store table modification, or a data store table removable by automatically carrying out data store architecture analysis comprising comparing successive approximations of the architecture of the data store;
• wherein the successive approximations include the first and second approximations;
• and
• output a notification about the data store changes.