Database schema for efficient queries and data storage

A system comprising:

• one or more processors;
• and
• memory, containing program instructions that, upon execution by the one or more processors, cause the system to perform operations comprising:
• receiving a representation of a database schema of a database, the database schema including:
• a job families table, a role groups table, and a role levels table, wherein entries in the role levels table link to role groups from the role groups table, and wherein entries in the role groups table link to job families from the job families table;
• gathering, by way of a web crawler, job, role, and level data from one or more websites;
• providing, to a pretrained machine learning model, the job, role, and level data from the one or more websites, wherein the pretrained machine learning model has been trained to arrange data in accordance with the database schema;
• populating, in response to output of the pretrained machine learning model, a first portion of the job, role, and level data in accordance with the database schema;
• and
• iteratively receiving user feedback regarding recommended role level and role group data relating to one or more proposed job families, wherein the recommended role level and role group data is from a second portion of the job, role, and level data.

A non-transitory computer-readable medium, having stored thereon program instructions that, upon execution by a computing system, cause the computing system to perform operations comprising:

• receiving a representation of a database schema of a database, the database schema including:
• a job families table, a role groups table, and a role levels table, wherein entries in the role levels table link to role groups from the role groups table, and wherein entries in the role groups table link to job families from the job families table;
• gathering, by way of a web crawler, job, role, and level data from one or more websites;
• providing, to a pretrained machine learning model, the job, role, and level data from the one or more websites, wherein the pretrained machine learning model has been trained to arrange data in accordance with the database schema;
• populating, in response to output of the pretrained machine learning model, a first portion of the job, role, and level data in accordance with the database schema;
• and
• iteratively receiving user feedback regarding recommended role level and role group data relating to one or more proposed job families, wherein the recommended role level and role group data is from a second portion of the job, role, and level data.