US 12,450,204 B2
Generating and reusing transformations for evolving schema mapping
Sharon Roth, Boston, MA (US); Ihab F. Ilyas, Waterloo (CA); Daniel Meir Bruckner, San Francisco, CA (US); and Gideon Goldin, Cambridge, MA (US)
Assigned to TAMR, INC., Cambridge, MA (US)
Filed by Tamr, Inc., Cambridge, MA (US)
Filed on May 10, 2021, as Appl. No. 17/316,161.
Application 17/316,161 is a continuation of application No. 16/038,762, filed on Jul. 18, 2018, granted, now 11,003,636.
Claims priority of provisional application 62/686,328, filed on Jun. 18, 2018.
Prior Publication US 2021/0334248 A1, Oct. 28, 2021
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/21 (2019.01); G06F 16/25 (2019.01); G06F 16/901 (2019.01); G06F 16/907 (2019.01)
CPC G06F 16/211 (2019.01) [G06F 16/252 (2019.01); G06F 16/254 (2019.01); G06F 16/9024 (2019.01); G06F 16/907 (2019.01)] 6 Claims
OG exemplary drawing
 
1. A method for creating a new target schema from an existing target schema, wherein the existing target schema is represented as a collection of nodes within an electronically represented and visually displayed initial transformation graph, the electronically represented and visually displayed initial transformation graph being an evolving graph of nodes and edges, the electronically represented and visually displayed initial transformation graph including nodes which represent unified attributes and edges which represent a flow of data via transformations between the nodes, and wherein the electronically represented and visually displayed initial transformation graph includes transformation paths which are reusable, the method comprising:
(a) adding a new node which represents a new unified attribute to the electronically represented and visually displayed initial transformation graph, thereby creating an electronically represented and visually displayed revised transformation graph, wherein the new node which represents the new unified attribute is added to the electronically represented and visually displayed initial transformation graph via user input of a transformation edge between the new node and an existing node into a first graphical user interface (GUI); and
(b) adding the new node which represents the new unified attribute to the existing target schema, thereby creating a revised target schema, the revised target schema being a new target schema created from the existing target schema that reuses the transformation paths of the electronically represented and visually displayed initial transformation graph, wherein the new node which represents the new unified attribute is selected for inclusion in the revised target schema via user input into a second GUI,
wherein the new node which represents the new unified attribute and edge are used by a central processing unit executing software code to propagate data using the electronically represented and visually displayed revised transformation graph and the revised target schema.