System for intelligent database modelling

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;

initiate a first machine learning model on the drawing;

determine, using the first machine learning model, that the user is attempting to design a database model;

extract at least a first entity from the drawing based on at least determining that the user is attempting the design the database model;

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, 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; and

record the relationship in the conceptual 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:

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.

5. The system of claim 1 , wherein the at least one processing device is further configured to:

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; and

in response, generate a physical database model using the database schema.

6. The system of claim 5 , wherein the at least one processing device is further configured to:

automatically generate an entity relationship diagram (ERD) based on the physical database model illustrating a logical structure of the database model.

7. The system of claim 6 , 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.

8. The system of claim 7 , wherein the at least one processing device is further configured to:

generate a new transaction object for the physical database model; and

broadcast the new transaction object for the physical database model to the at least one data source in a distributed ledger for validation.

9. The system of claim 8 , 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.

10. 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;

initiate a first machine learning model on the drawing;

determine, using the first machine learning model, that the user is attempting to design a database model;

extract at least a first entity from the drawing based on at least determining that the user is attempting the design the database model;

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, 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; and

record the relationship in the conceptual database model.

11. The computer program product of claim 10 , 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.

12. The computer program product of claim 11 , wherein the first apparatus is further configured to:

determine, using the classification parameters, the one or more attributes for the first entity.

13. The computer program product of claim 10 , 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.

14. The computer program product of claim 10 , wherein the first apparatus is further configured to:

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; and

in response, generate a physical database model using the database schema.

15. The computer program product of claim 14 , wherein the first apparatus is further configured to:

automatically generate an entity relationship diagram (ERD) based on the physical database model illustrating a logical structure of the database model.

16. The computer program product of claim 15 , 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.

17. The computer program product of claim 16 , wherein the first apparatus is further configured to:

generate a new transaction object for the physical database model; and

broadcast the new transaction object for the physical database model to the at least one data source in a distributed ledger for validation.

18. 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;

initiating a first machine learning model on the drawing;

determining, using the first machine learning model, that the user is attempting to design a database model;

extracting at least a first entity from the drawing based on at least determining that the user is attempting the design the database model;

determining, using the first machine learning model, one or more attributes for the first entity;

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; and

recording the relationship in the conceptual database model.