IP Library › Granted Patent US 50,304
Granted Patent E1
US 50,304 · App. 18/077,584 · Granted Feb 18, 2025

Method and apparatus for implementing a data book application module

Inventor: Susan Sterling (Syosset, NY)
Assignee: JPMORGAN CHASE BANK, N.A.
G06F16/211G06F16/168G06F16/221G06F16/2282G06F16/283G06F16/955
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 50,304
App. No.
18/077,584
Granted
Feb 18, 2025
Kind
E1
Abstract

Various methods, apparatuses/systems, and media for implementing a data book application module is disclosed. The processor identifies an application that needs to be scanned through a data factory; receives inventories of all servers and databases associated with the data factory; scans the servers and databases for receiving inventories of schema, tables and columns associated with the application; and applies artificial intelligence (AI) and/or machine learning (ML) routines and matching algorithms for matching contents of columns to predefined logical terms. The processor also converts the contents of columns into taxonomies associated with the predefined logical terms; matches the taxonomies with the corresponding predefined logical terms; assigns a probability of accuracy value to the matched terms; and populates a data catalog with the matched terms when the assigned probability of accuracy value satisfies a predetermined threshold value.

Claims (75)

1. A method for implementing a data book application module by utilizing one or more processors and one or more memories, the method comprising:

providing a data factory that includes a data book application;

identifying an application that needs to be scanned through the data factory utilizing the data book application;

receiving inventories of all servers and databases associated with the data factory;

scanning the servers and databases for receiving inventories of schema associated with the application, the schema containing tables and the tables containing columns;

applying artificial intelligence and/or machine learning routines and matching algorithms for matching contents of columns to predefined logical terms;

converting the contents of columns into taxonomies associated with the predefined logical terms;

matching the taxonomies with the corresponding predefined logical terms;

assigning a probability of accuracy value to the matched terms; and

populating a data catalog with the matched terms when the assigned probability of accuracy value satisfies a predetermined threshold value.

2. The method according to claim 1 , further comprising:

receiving a user input via a first icon of a user interface, the first icon corresponding to a glossary icon that allows access to a glossary stored onto the servers and databases, wherein the glossary establishes common terminology across different applications and groups within an organization; and

executing a search to scan the servers and databases for receiving inventories of columns, tables, and schema associated with the application from the glossary.

3. The method according to claim 1 , further comprising:

receiving a user input via a second icon of a user interface, the second icon corresponding to a catalog icon that allows access to a catalog stored onto the servers and databases, the catalog containing a listing of some or all applications within an organization identifying which lines of business use or be responsible for an application; and

scanning the servers and databases for receiving inventories of columns, tables, and schema associated with the application from the catalog.

4. The method according to claim 1 , further comprising:

running the data book application at log in; and

maintaining to run the data book application in the background after log in.

5. The method according to claim 1 , further comprising:

running the data book application from any application on a Windows desktop.

6. The method according to claim 1 , further comprising:

receiving a single keystroke to provide a dialog box where a user can type and select a predefined type of search.

7. The method according to claim 1 , further comprising:

receiving a user input to select a desired web browser to view search results.

8. The method according to claim 1 , further comprising:

applying a globally unique identifier (GUID) mechanism to assign an asset identifier (ID); and

scanning the servers and databases for obtaining inventories of columns for that asset ID within the data factory.

9. The method according to claim 1 , further comprising:

receiving a user input to change search uniform resource locator (URL) to perform target searches.

10. A system for implementing a data book application module, the system comprising:

a data factory that includes a data book application; and

a processor coupled to the data factory via a communication network, wherein the processor is configured to:

identify an application that needs to be scanned through the data factory utilizing the data book application;

receive inventories of all servers and databases associated with the data factory;

scan the servers and databases for receiving inventories of schema associated with the application, the schema containing tables and the tables containing columns;

apply artificial intelligence and/or machine learning routines and matching algorithms for matching contents of columns to predefined logical terms;

convert the contents of columns into taxonomies associated with the predefined logical terms;

match the taxonomies with the corresponding predefined logical terms;

assign a probability of accuracy value to the matched terms; and

populate a data catalog with the matched terms when the assigned probability of accuracy value satisfies a predetermined threshold value.

11. The system according to claim 10 , wherein the processor is further configured to:

receive a user input via a first icon of a user interface, the first icon corresponding to a glossary icon that allows access to a glossary stored onto the servers and databases, wherein the glossary establishes common terminology across different applications and groups within an organization; and

execute a search to scan the servers and databases for receiving inventories of columns, tables, and schema associated with the application from the glossary.

12. The system according to claim 10 , wherein the processor is further configured to:

receive a user input via a second icon of a user interface, the second icon corresponding to a catalog icon that allows access to a catalog stored onto the servers and databases, the catalog containing a listing of some or all applications within an organization identifying which lines of business use or be responsible for an application; and

scan the servers and databases for receiving inventories of columns, tables, and schema associated with the application from the catalog.

13. The system according to claim 10 , wherein the processor is further configured to:

run the data book application at log in; and

maintain running of the data book application in the background after log in.

14. The system according to claim 10 , wherein the processor is further configured to:

run the data book application from any application on a Windows desktop.

15. The system according to claim 10 , wherein the processor is further configured to:

receive a single keystroke to provide a dialog box where a user can type and select a predefined type of search.

16. The system according to claim 10 , wherein the processor is further configured to:

apply a globally unique identifier (GUID) mechanism to assign an asset identifier (ID); and

scan the servers and databases for obtaining inventories of columns for that asset ID within the data factory.

17. The system according to claim 10 , wherein the processor is further configured to:

receive a user input to change search uniform resource locator (URL) to perform target searches.

18. A non-transitory computer readable medium configured to store instructions for implementing a data book application module, wherein, when executed, the instructions cause a processor to perform the following:

accessing a data factory that includes a data book application;

identifying an application that needs to be scanned through the data factory utilizing the data book application;

receiving inventories of all servers and databases associated with the data factory;

scanning the servers and databases for receiving inventories of schema associated with the application, the schema containing tables and the tables containing columns;

applying artificial intelligence and/or machine learning routines and matching algorithms for matching contents of columns to predefined logical terms;

converting the contents of columns into taxonomies associated with the predefined logical terms;

matching the taxonomies with the corresponding predefined logical terms;

assigning a probability of accuracy value to the matched terms;

populating a data catalog with the matched terms when the assigned probability of accuracy value satisfies a predetermined threshold value.

19. The non-transitory computer readable medium according to claim 18 , wherein the instructions, when executed, further cause the processor to perform the following:

receiving a user input via a first icon of a user interface, the first icon corresponding to a glossary icon that allows access to a glossary stored onto the servers and databases, wherein the glossary establishes common terminology across different applications and groups within an organization; and

executing a search to scan the servers and databases for receiving inventories of columns, tables, and schema associated with the application from the glossary.

20. The non-transitory computer readable medium according to claim 18 , wherein the instructions, when executed, further cause the processor to perform the following:

receiving a user input via a second icon of a user interface, the second icon corresponding to a catalog icon that allows access to a catalog stored onto the servers and databases, the catalog containing a listing of some or all applications within an organization identifying which lines of business use or be responsible for an application; and

scanning the servers and databases for receiving inventories of columns, tables, and schema associated with the application from the catalog.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Dec 8, 2022
From: STERLING, SUSAN
To: JPMORGAN CHASE BANK, N.A.
Reel/Frame 062028/0210 →
Continuity (1)
Reissue 16864552 · May 1, 2020
References Cited (3)
US 7822769B2 · Rohan · 2010 [cited by examiner]
US 10204380B1 · Moore · 2019 [cited by examiner]
US 20130046582A1 · Ramer · 2013 [cited by examiner]