System for intelligent database modelling
Systems, computer program products, and methods are described herein for intelligent database modelling. The present invention is configured to capture, using the augmented reality application, a drawing made by the user on a medium; initiate a first machine learning model on the drawing; determine that the user is attempting to design a database model; extract at least a first entity from the drawing; determine, using the first machine learning model, one or more attributes for the first entity; initiate, via the augmented reality application, a first push notification for display on the computing device of the user; electronically receive, via the augmented reality application, a user selection of a subset of attributes from the one or more attributes; generate, using the augmented reality application, a conceptual database model based on at least the first entity and the subset of attributes.
1 . A system for intelligent database modelling, the system comprising:
at least one non-transitory storage device; and
at least one processing device coupled to the at least one non-transitory storage device, wherein the at least one processing device is configured to:
provide an augmented reality application for installation on a computing device of a user;
capture, using the augmented reality application, a drawing made by the user on a medium;
periodically initiate a first machine learning model on the drawing until the first machine learning model determines that the user is beginning to design a database model;
determine, using the first machine learning model, that the user is beginning to design the database model;
enhance, using the augmented reality the drawing using computer-generated perceptual information;
extract at least a first entity from the enhanced drawing based on at least determining that the user is beginning to the design the database model, wherein the first entity comprises an employee;
determine, using the first machine learning model, one or more attributes for the first entity, wherein each attribute is associated with a name and a data source for a value associated therewith, wherein, in an instance in which the first entity is an employee, the one or more attributes comprises at least employee information;
initiate, via the augmented reality application, a first push notification for display on the computing device of the user, wherein the first push notification comprises at least the one or more attributes;
electronically receive, via the augmented reality application, a user selection of a subset of attributes from the one or more attributes;
generate, using the augmented reality application, a conceptual database model based on at least the first entity and the subset of attributes;
automatically generate, using the first machine learning model, a relationship between the first entity and the subset of attributes;
record the relationship in the conceptual database model;
determine, using the first machine learning model, one or more database schema based on at least the conceptual database model;
initiate, via the augmented reality application, a second push notification for display on the computing device of the user, wherein the second push notification comprises at least the one or more database schema;
electronically receive, via the augmented reality application, a user selection of a database schema from the one or more database schema;
in response, generate a physical database model using the database schema, wherein generating further comprises converting each entity into corresponding tables, each relationship into corresponding foreign keys, and the subset of attributes into corresponding columns based on physical constraints and requirements of the database schema selected by the user; and
automatically generate an entity relationship diagram (ERD) based on the physical database model illustrating a logical structure of the database model.
2 . The system of claim 1 , wherein the at least one processing device is further configured to:
retrieve one or more database models from a data repository;
extract one or more entities and one or more attributes from the one or more database models;
initiate a machine learning algorithm on one or more database models, and the one or more entities and the one or more attributes; and
train, using the machine learning algorithm, the first machine learning model, wherein training further comprises determining one or more classification parameters for the first machine learning model.
3 . The system of claim 2 , wherein the at least one processing device is further configured to:
determine, using the classification parameters, the one or more attributes for the first entity.
4 . The system of claim 1 , wherein the at least one processing device is further configured to:
automatically generate, using the first machine learning model, a relationship between the first entity and the subset of attributes; and
record the relationship in the conceptual database model.
5 . The system of claim 4 , wherein the at least one processing device is further configured to:
transmit control signals configured to cause the computing device of the user to display the conceptual database model for user approval; and
electronically receive, via the computing device of the user, the user approval for the conceptual database model.
6 . The system of claim 1 , wherein the at least one processing device is further configured to:
initiate a second machine learning model on one or more data sources and the physical database model; and
determine, using the second machine learning model, at least one data source that is likely to be triggered when populating a database created using the physical database model.
7 . The system of claim 1 , wherein broadcasting the new transaction object further comprises:
receive, from a computing device associated with the at least one data source, an indication validating the physical database model; and
authorize a generation of a database using the physical database model based on at least receiving the validation.
8 . A computer program product for intelligent database modelling, the computer program product comprising a non-transitory computer-readable medium comprising code causing a first apparatus to:
provide an augmented reality application for installation on a computing device of a user;
capture, using the augmented reality application, a drawing made by the user on a medium;
periodically initiate a first machine learning model on the drawing until the first machine learning model determines that the user is beginning to design a database model;
determine, using the first machine learning model, that the user is beginning to design the database model;
enhance, using the augmented reality the drawing using computer-generated perceptual information;
extract at least a first entity from the enhanced drawing based on at least determining that the user is beginning to the design the database model, wherein the first entity comprises an employee;
determine, using the first machine learning model, one or more attributes for the first entity, wherein each attribute is associated with a name and a data source for a value associated therewith, wherein, in an instance in which the first entity is an employee, the one or more attributes comprises at least employee information;
initiate, via the augmented reality application, a first push notification for display on the computing device of the user, wherein the first push notification comprises at least the one or more attributes;
electronically receive, via the augmented reality application, a user selection of a subset of attributes from the one or more attributes;
generate, using the augmented reality application, a conceptual database model based on at least the first entity and the subset of attributes;
automatically generate, using the first machine learning model, a relationship between the first entity and the subset of attributes;
record the relationship in the conceptual database model;
determine, using the first machine learning model, one or more database schema based on at least the conceptual database model;
initiate, via the augmented reality application, a second push notification for display on the computing device of the user, wherein the second push notification comprises at least the one or more database schema;
electronically receive, via the augmented reality application, a user selection of a database schema from the one or more database schema;
in response, generate a physical database model using the database schema, wherein generating further comprises converting each entity into corresponding tables, each relationship into corresponding foreign keys, and the subset of attributes into corresponding columns based on physical constraints and requirements of the database schema selected by the user; and
automatically generate an entity relationship diagram (ERD) based on the physical database model illustrating a logical structure of the database model.
9 . The computer program product of claim 8 , wherein the first apparatus is further configured to:
retrieve one or more database models from a data repository;
extract one or more entities and one or more attributes from the one or more database models;
initiate a machine learning algorithm on one or more database models, and the one or more entities and the one or more attributes; and
train, using the machine learning algorithm, the first machine learning model, wherein training further comprises determining one or more classification parameters for the first machine learning model.
10 . The computer program product of claim 9 , wherein the first apparatus is further configured to:
determine, using the classification parameters, the one or more attributes for the first entity.
11 . The computer program product of claim 8 , wherein the first apparatus is further configured to:
automatically generate, using the first machine learning model, a relationship between the first entity and the subset of attributes; and
record the relationship in the conceptual database model.
12 . The computer program product of claim 11 , wherein the first apparatus is further configured to:
transmit control signals configured to cause the computing device of the user to display the conceptual database model for user approval; and
electronically receive, via the computing device of the user, the user approval for the conceptual database model.
13 . The computer program product of claim 8 , wherein the first apparatus is further configured to:
initiate a second machine learning model on the one or more data sources and the physical database model; and
determine, using the second machine learning model, at least one data source that is likely to be triggered when populating a database created using the physical database model.
14 . A method for intelligent database modelling, the method comprising:
providing an augmented reality application for installation on a computing device of a user;
capturing, using the augmented reality application, a drawing made by the user on a medium;
periodically initiating a first machine learning model on the drawing until the first machine learning model determines that the user is beginning to design a database model;
determining, using the first machine learning model, that the user is beginning to design the database model;
enhancing, using the augmented reality the drawing using computer-generated perceptual information;
extracting at least a first entity from the enhanced drawing based on at least determining that the user is beginning to the design the database model, wherein the first entity comprises an employee;
determining, using the first machine learning model, one or more attributes for the first entity, wherein each attribute is associated with a name and a data source for a value associated therewith, wherein, in an instance in which the first entity is an employee, the one or more attributes comprises at least employee information;
initiating, via the augmented reality application, a first push notification for display on the computing device of the user, wherein the first push notification comprises at least the one or more attributes;
electronically receiving, via the augmented reality application, a user selection of a subset of attributes from the one or more attributes;
generating, using the augmented reality application, a conceptual database model based on at least the first entity and the subset of attributes;
automatically generating, using the first machine learning model, a relationship between the first entity and the subset of attributes;
recording the relationship in the conceptual database model;
determining, using the first machine learning model, one or more database schema based on at least the conceptual database model;
initiating, via the augmented reality application, a second push notification for display on the computing device of the user, wherein the second push notification comprises at least the one or more database schema;
electronically receiving, via the augmented reality application, a user selection of a database schema from the one or more database schema;
in response, generating a physical database model using the database schema, wherein generating further comprises converting each entity into corresponding tables, each relationship into corresponding foreign keys, and the subset of attributes into corresponding columns based on physical constraints and requirements of the database schema selected by the user; and
automatically generating an entity relationship diagram (ERD) based on the physical database model illustrating a logical structure of the database model.