# US 11,907,179 B2 · System for intelligent database modelling > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 11,907,179 B2 - Document ID: US11907179B2 - Status: Granted - Kind: B2 - Application number: 17/482,779 - Filed: 2021-09-23 - Published: 2023-03-23 - Granted: 2024-02-20 - Earliest claimed: 2021-09-23 - Assignees: Bank of America Corporation - Applicants: Bank of America Corporation - Inventors: Raja Arumugam Maharaja; Ankit Singh Negi - Web page: https://patentgrep.com/patent/US11907179B2 ## CPC - G06F 16/21: Design, administration or maintenance of databases - G06F 16/212: {with details for data modelling support} - G06F 8/61: Installation - G06F 16/288: {Entity relationship models} - G06N 3/08: Learning methods - G06N 20/00: Machine learning - G06T 11/00: Two-dimensional [2D] image generation - G06T 11/23: using straight lines or curves - G06V 20/20: in augmented reality scenes - G06V 30/18: Extraction of features or characteristics of the image - G06V 30/414: Extracting the geometrical structure, e.g. layout tree; Block segmentation, e.g. bounding boxes for graphics or text - G06V 30/422: Technical drawings; Geographical maps - G06T 2200/24: involving graphical user interfaces [GUIs] - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) - G06N: COMPUTING ARRANGEMENTS BASED ON SPECIFIC COMPUTATIONAL MODELS - G06T: IMAGE DATA PROCESSING OR GENERATION, IN GENERAL - G06V: IMAGE OR VIDEO RECOGNITION OR UNDERSTANDING ## Abstract 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. ## Claims ### Claim 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. ### Claim 2 (depends on 1) 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. ### Claim 3 (depends on 2) 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. ### Claim 4 (depends on 1) 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. ### Claim 5 (depends on 1) 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. ### Claim 6 (depends on 5) 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. ### Claim 7 (depends on 6) 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. ### Claim 8 (depends on 7) 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. ### Claim 9 (depends on 8) 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. ### Claim 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. ### Claim 11 (depends on 10) 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. ### Claim 12 (depends on 11) 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. ### Claim 13 (depends on 10) 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. ### Claim 14 (depends on 10) 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. ### Claim 15 (depends on 14) 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. ### Claim 16 (depends on 15) 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. ### Claim 17 (depends on 16) 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. ### Claim 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.