Data Filtering Utilizing Constructed Graph Structure

A non-transitory computer readable storage medium embodying a computer program for performing a method, said method comprising:

• receiving from a first analysis tool, filter criteria including an attribute of a data corpus stored in a database according to a schema;
• receiving from the database, semantic information describing a hierarchy of the schema organized according to an attribute level and a parameter level, the semantic information comprising Primary Key and Foreign Keys of tables of the schema;
• processing the filter criteria and the semantic information to construct a bootstrapped graph structure comprising entities and relationships;
• receiving from a second analysis tool, an input comprising a payload including a parameter;
• referencing the bootstrapped graph structure and the input to calculate paths between entities and relationships and generate a SQL query including the parameter;
• resolving the SQL query against the database;
• receiving from the database, a corresponding query result including the parameter;
• and
• displaying the corresponding query result to a screen of an interface.

A computer system comprising:

• one or more processors;
• a software program, executable on said computer system, the software program configured to cause an in-memory database engine of an in-memory database to:
• receive from a first analysis tool, filter criteria including an attribute of a data corpus stored in the in-memory database according to a schema;
• receive from the in-memory database, semantic information describing a hierarchy of the schema organized according to an attribute level and a parameter level;
• process the filter criteria and the semantic information to construct a bootstrapped graph structure comprising entities and relationships;
• receive from a second analysis tool, an input comprising a payload including a parameter;
• reference the bootstrapped graph structure and the input to calculate paths between entities and relationships and generate a SQL query including the parameter;
• resolve the SQL query against the in-memory database;
• receive from the in-memory database, a corresponding query result including the parameter;
• and
• display the corresponding query result to a screen of an interface.