Automatic transformation of complex tables in documents into computer understandable structured format and managing dependencies

In a computer system comprised of a memory repository in which is stored a set of tables and a processor communicatively coupled to the memory repository and thereby to the stored set of tables, a computer-implemented method for determining frequencies for updating dependency information among the stored set of tables, the method comprising:

• providing a set of flattened tables stored in a memory repository in a computer system, each flattened table in the set of flattened tables including table data and table meta-data converted from a compact table collected from a corpus of documents, the set of flattened tables organized to be searchable by schema-less queries;
• determining a plurality of dependent objects in the set of flattened tables, wherein a dependent object comprises all or part of a flattened table in the set of flattened tables, and wherein the processor maintains and updates dependency information stored in the memory repository, the stored dependency information maps dependency between dependent objects in the plurality of dependent objects, and wherein a frequency of access is stored in memory for each dependent object in the plurality of dependent objects;
• determining a frequency of access for each of the plurality of dependent objects;
• and
• based on the frequency of access for each of the plurality of dependent objects determine a frequency of updating dependency information for the respective each of the plurality of dependent objects.

A non-transitory computer readable storage medium, comprising computer instructions which, responsive to being executed by a processor in a computer system comprised of a memory repository in which is stored a set of tables and the processor being communicatively coupled to the memory repository and thereby to the set of tables, cause the processor to perform a method for maintaining dependency information among the set of tables, the method comprising:

• providing a set of flattened tables stored in a memory repository in a computer system, each flattened table in the set of flattened tables including table data and table meta-data converted from a compact table collected from a corpus of documents, the set of flattened tables organized to be searchable by schema-less queries;
• determining a plurality of dependent objects in the set of flattened tables, wherein a dependent object comprises all or part of a flattened table in the set of flattened tables, and wherein the processor maintains and updates dependency information stored in the memory repository, the stored dependency information maps dependency between dependent objects in the plurality of dependent objects in the set of flattened tables thereby organized to be searchable by schema-less queries, and wherein a frequency of access is stored in memory for each dependent object in the plurality of dependent objects;
• determining a frequency of access for each of the plurality of dependent objects;
• and
• in response to an access frequency of a dependent object exceeding a threshold, maintaining and updating dependency information corresponding to the dependent object stored in the memory repository.