IP Library › Granted Patent US 11,461,293
Granted Patent B2
US 11,461,293 · App. 16/544,701 · Granted Oct 4, 2022

Processes and systems for onboarding data for a digital duplicate

Inventors: Seshadri Guha (Peoria, IL); Vinay Sikka (Peoria, IL); Subbarao Turlapati (Peoria, IL)
Assignee: TADA Cognitive Solutions, LLC
G06F16/213G06F16/212G06F16/215G06F16/258
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 11,461,293
App. No.
16/544,701
Filed
Aug 19, 2019
Granted
Oct 4, 2022
Kind
B2
Art Unit
2162
USPC
707/803
Abstract

Disclosed herein is a process that involves retrieving a data model for a data source, establishing at least one filter operation or at least one clean operation that modifies an aspect of the retrieved data model, onboarding underlying data from the data source while applying the established at least one filter operation or at least one clean operation, defining at least one transformation operation to apply to a portion of the underlying data that has been onboarded, and applying the at least one transformation operation to the portion of the underlying data to thereby assign the data to a semantic network, the semantic network comprising conceptual data components and associative data components.

Claims (82)

1. A computing system comprising:

a network interface;

at least one processor;

a non-transitory computer-readable medium; and

program instructions stored on the non-transitory computer-readable medium that are executable by the at least one processor to cause the computing system to perform functions including:

retrieving a data model for a data source, wherein the data model is associated with at least a plurality of data tables of the data source;

causing a client station to present a graphical user interface (GUI) via which user input is received; and

for each data table of the plurality of data tables:

establishing, based at least in part on first user input received via the GUI, at least one filter operation or at least one clean operation to be applied to data of the data table;

generating, based at least in part on second user input received via the GUI, a table interface associated with the data table, the table interface being a data structure that comprises (i) information regarding where in the data source to retrieve data of the data table and (ii) the established at least one filter operation or at least one clean operation to be applied to the data of the data table;

onboarding underlying data from the data source using the generated table interface, so as to apply the established at least one filter operation or at least one clean operation;

defining at least one transformation operation to apply to a portion of the underlying data from the data source that has been onboarded using the generated table interface; and

applying the at least one transformation operation to the portion of the underlying data onboarded using the generated table interface to thereby assign the data to a semantic network, the semantic network comprising conceptual data components and associative data components.

2. The computing system of claim 1 , wherein the program instructions are further executable to cause the computing system to perform functions including:

receiving instructions that facilitate connecting to the data source;

responsive to receiving the instructions, connecting to the data source;

retrieving from the data source the data model.

3. The computing system of claim 1 , wherein the program instructions are further executable to cause the computing system to perform functions including:

retrieving a second data model for a second data source;

establishing at least one second filter operation or at least one second clean operation that modifies an aspect of the retrieved second data model;

onboarding underlying data from the second data source while applying the established at least one second filter operation or at least one second clean operation;

define at least one second transformation operation to apply to a portion of the underlying data from the second data source that has been onboarded; and

applying the at least one second transformation operation to the portion of the underlying data from the second data source to thereby assign the data to the semantic network.

4. The computing system of claim 1 , wherein defining at least one transformation operation to apply to a portion of the underlying data from the data source that has been onboarded using the generated table interface comprises defining a transformation operation that includes assigning the portion of underlying data to at least one of the conceptual data components and the associative data components of the semantic network.

5. The computing system of claim 1 , wherein the program instructions are further executable to cause the computing system to perform functions including:

establishing a schedule by which, or a trigger event responsive to which, the computing system refreshes the semantic network; and

periodically repeating in accordance with the established schedule the steps of (i) onboarding underlying data from the data source using the generated table interface, so as to apply the established at least one filter operation or at least one clean operation and (ii) applying the at least one transformation operation to the portion of the underlying data onboarded using the generated table interface to thereby assign the data to the semantic network.

6. The computing system of claim 1 ,

wherein onboarding underlying data from the data source using the generated table interface, so as to apply the established at least one filter operation or at least one clean operation comprises (i) extracting the underlying data from the data source, (ii) applying the at least one filter operation or the at least one clean operation, and (iii) storing the underlying data, having applied thereto the at least one filter operation or the at least one clean operation, in a first platform data source.

7. The computing system of claim 6 ,

wherein applying the at least one transformation operation to the portion of the underlying data onboarded using the generated table interface to thereby assign the data to a semantic network comprises (i) exporting the underlying data from the first platform data source, (ii) applying the at least one transformation operation to the exported data, and (iii) storing the underlying data, having applied thereto the at least one filter operation or the at least one clean operation and then the at least one transformation operation, in a second platform data source.

8. The computing system of claim 1 , wherein for each data table of the plurality of data tables, establishing, based at least in part on user input received via the GUI, at least one filter operation or at least one clean operation comprises:

establishing at least one filter operation or at least one clean operation for a first data table; and

establishing at least one filter operation or at least one clean operation for a second data table, wherein the least one filter operation or at least one clean operation for the second data table is established based on the at least one filter operation or at least one clean operation for the first data table.

9. A method comprising:

retrieving a data model for a data source, wherein the data model is associated with at least a plurality of data tables of the data source;

causing a client station to present a graphical user interface (GUI) via which user input is received; and

for each data table of the plurality of data tables:

establishing, based at least in part on first user input received via the GUI, at least one filter operation or at least one clean operation to be applied to data of the data table;

generating, based at least in part on second user input received via the GUI, a table interface associated with the data table, the table interface being a data structure that comprises (i) information regarding where in the data source to retrieve data of the data table and (ii) the established at least one filter operation or at least one clean operation to be applied to the data of the data table;

onboarding underlying data from the data source using the generated table interface, so as to apply the established at least one filter operation or at least one clean operation;

defining at least one transformation operation to apply to a portion of the underlying data from the data source that has been onboarded using the generated table interface; and

applying the at least one transformation operation to the portion of the underlying data onboarded using the generated table interface to thereby assign the data to a semantic network, the semantic network comprising conceptual data components and associative data components.

10. The method of claim 9 , further comprising:

receiving instructions that facilitate connecting to the data source;

responsive to receiving the instructions, connecting to the data source; and

retrieving from the data source the data model.

11. The method of claim 9 , further comprising:

retrieving a second data model for a second data source;

establishing at least one second filter operation or at least one second clean operation that modifies an aspect of the retrieved second data model;

onboarding underlying data from the second data source while applying the established at least one second filter operation or at least one second clean operation;

define at least one second transformation operation to apply to a portion of the underlying data from the second data source that has been onboarded; and

applying the at least one second transformation operation to the portion of the underlying data from the second data source to thereby assign the data to the semantic network.

12. The method of claim 9 , wherein defining at least one transformation operation to apply to a portion of the underlying data from the data source that has been onboarded using the generated table interface comprises defining a transformation operation that includes assigning the portion of underlying data to at least one of the conceptual data components and the associative data components of the semantic network.

13. The method of claim 9 , further comprising:

establishing a schedule by which, or a trigger event responsive to which, the computing system refreshes the semantic network; and

periodically repeating in accordance with the established schedule the steps of (i) onboarding underlying data from the data source using the generated table interface, so as to apply the established at least one filter operation or at least one clean operation and (ii) applying the at least one transformation operation to the portion of the underlying data onboarded using the generated table interface to thereby assign the data to the semantic network.

14. The computing system of claim 9 ,

wherein onboarding underlying data from the data source using the generated table interface, so as to apply the established at least one filter operation or at least one clean operation comprises (i) extracting the underlying data from the data source, (ii) applying the at least one filter operation or the at least one clean operation, and (iii) storing the underlying data, having applied thereto the at least one filter operation or the at least one clean operation, in a first platform data source.

15. The method of claim 14 ,

wherein applying the at least one transformation operation to the portion of the underlying data onboarded using the generated table interface to thereby assign the data to a semantic network comprises (i) exporting the underlying data from the first platform data source, (ii) applying the at least one transformation operation to the exported data, and (iii) storing the underlying data, having applied thereto the at least one filter operation or the at least one clean operation and then the at least one transformation operation, in a second platform data source.

16. A non-transitory computer-readable storage medium having program instructions stored thereon that are executable to cause a computing system to:

retrieve a data model for a data source, wherein the data model is associated with at least a plurality of data tables of the data source;

cause a client station to present a graphical user interface (GUI) via which user input is received; and

for each data table of the plurality of data tables:

establish, based at least in part on first user input received via the GUI, at least one filter operation or at least one clean operation to be applied to data of the data table;

generate, based at least in part on second user input received via the GUI, a table interface associated with the data table, the table interface being a data structure that comprises (i) information regarding where in the data source to retrieve data of the data table and (ii) the established at least one filter operation or at least one clean operation to be applied to the data of the data table;

onboard underlying data from the data source using the generated table interface, so as to apply the established at least one filter operation or at least one clean operation;

define at least one transformation operation to apply to a portion of the underlying data from the data source that has been onboarded using the generated table interface; and

apply the at least one transformation operation to the portion of the underlying data onboarded using the generated table interface to thereby assign the data to a semantic network, the semantic network comprising conceptual data components and associative data components.

17. The computer-readable storage medium of claim 16 , wherein the program instructions are further executable to cause the computing system to:

retrieve a second data model for a second data source;

establish at least one second filter operation or at least one second clean operation that modifies an aspect of the retrieved second data model;

onboard underlying data from the second data source while applying the established at least one second filter operation or at least one second clean operation;

define at least one second transformation operation to apply to a portion of the underlying data from the second data source that has been onboarded; and

apply the at least one second transformation operation to the portion of the underlying data from the second data source to thereby assign the data to the semantic network.

18. The computer-readable storage medium of claim 16 , wherein defining at least one transformation operation to apply to a portion of the underlying data from the data source that has been onboarded using the generated table interface comprises defining a transformation operation that includes assigning the portion of underlying data to at least one of the conceptual data components and the associative data components of the semantic network.

19. The computer-readable storage medium of claim 16 , wherein the program instructions are further executable to cause the computing system to:

establish a schedule by which, or a trigger event responsive to which, the computing system refreshes the semantic network; and

periodically repeat in accordance with the established schedule the steps of (i) onboarding underlying data from the data source using the generated table interface, so as to apply the established at least one filter operation or at least one clean operation and (ii) applying the at least one transformation operation to the portion of the underlying data onboarded using the generated table interface to thereby assign the data to the semantic network.

20. The computer-readable storage medium of claim 16 ,

wherein onboarding underlying data from the data source using the generated table interface, so as to apply the established at least one filter operation or at least one clean operation comprises (i) extracting the underlying data from the data source, (ii) applying the at least one filter operation or the at least one clean operation, and (iii) storing the underlying data, having applied thereto the at least one filter operation or the at least one clean operation, in a first platform data source.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Oct 29, 2019
From: GUHA, SESHADRI; SIKKA, VINAY; TURLAPATI, SUBBARAO
To: TADA COGNITIVE SOLUTIONS, LLC
Reel/Frame 050849/0871 →
Continuity (1)
Related Publication 20210056084A1 · Feb 25, 2021