Systems and methods for providing faster data access using lookup and relationship tables

A system for decreasing data access time using a lookup table and a relationship table, the system comprising:

• at least one memory storing instructions;
• and
• at least one processor executing the instructions to perform operations, the operations comprising:
• receiving a plurality of tables comprising attributes and attribute data, the attribute data comprising attribute forms and attribute related information;
• identifying attributes and corresponding attribute data from each of the plurality of tables;
• applying a categorization machine learning model to categorize each attribute data as an attribute form or an attribute related information;
• generating the lookup table based on the attributes and the corresponding attribute forms;
• generating the relationship table based on the attributes and the corresponding attribute related information;
• receiving a query for attribute data;
• and
• generating a query response based on at least one of the lookup table or the relationship table.

A non-transitory computer-readable medium storing instructions that, when executed by a processor, cause the processor to perform operations, the operations comprising:

• receiving a plurality of tables comprising attributes and attribute data, the attribute data comprising attribute forms and attribute related information;
• identifying attributes and corresponding attribute data from each of the plurality of tables;
• applying a categorization machine learning model to categorize each attribute data as an attribute form or an attribute related information;
• generating a lookup table based on the attributes and the corresponding attribute forms;
• generating a relationship table based on the attributes and the corresponding attribute related information;
• receiving a query for attribute data;
• and
• generating a query response based on at least one of the lookup table or the relationship table.