Systems and methods for facilitating data transformation
First Claim
Patent Images
1. A system for assisting a user in performing transform of an origin data set into a target data set, the system comprising:
- one or more processors; and
memory storing instructions that, when executed by the one or more processors, cause the system to;
obtain the origin data set, the origin data set being organized in a tabular framework defined by an origin data schema;
provide a graphical user interface displaying the origin data set;
receive through the graphical user interface, at least one designation of a data object, the at least one designation of the data object mapping at least a portion of the origin data set to the data object;
generate a data transform file based on the at least one designated data object, the data transform file generated in response to receiving the at least one designation of the data object;
transform the origin data set into the target data set based on an execution of the data transform file, the target data set having an object-oriented based framework;
compare the object-oriented based framework of the target data set to respective object-oriented based frameworks of a plurality of reference data sets;
detect, based on the comparison, similarities between the object-oriented based framework of the target data set and the respective object-oriented based frameworks of the plurality of reference data sets;
determine, based on the similarities, a respective similarity score for at least one of the plurality of reference data sets;
select a comparable reference data set based on the at least one respective similarity score;
obtain a data visualization template associated with the comparable reference data set;
apply the visualization template to the target data set; and
display, through the graphical user interface, the target data set based on the visualization template.
8 Assignments
0 Petitions
Accused Products
Abstract
Systems and methods are provided for facilitating the transformation of data from a tabular data set organized according to a data schema to an object based data set organized according to a data ontology. The provided systems and methods offer a graphical user interface for mapping the tabular based data to the object based data set according to the data ontology. The tabular based data may be transformed according to the mapping.
98 Citations
19 Claims
-
1. A system for assisting a user in performing transform of an origin data set into a target data set, the system comprising:
-
one or more processors; and memory storing instructions that, when executed by the one or more processors, cause the system to; obtain the origin data set, the origin data set being organized in a tabular framework defined by an origin data schema; provide a graphical user interface displaying the origin data set; receive through the graphical user interface, at least one designation of a data object, the at least one designation of the data object mapping at least a portion of the origin data set to the data object; generate a data transform file based on the at least one designated data object, the data transform file generated in response to receiving the at least one designation of the data object; transform the origin data set into the target data set based on an execution of the data transform file, the target data set having an object-oriented based framework; compare the object-oriented based framework of the target data set to respective object-oriented based frameworks of a plurality of reference data sets; detect, based on the comparison, similarities between the object-oriented based framework of the target data set and the respective object-oriented based frameworks of the plurality of reference data sets; determine, based on the similarities, a respective similarity score for at least one of the plurality of reference data sets; select a comparable reference data set based on the at least one respective similarity score; obtain a data visualization template associated with the comparable reference data set; apply the visualization template to the target data set; and display, through the graphical user interface, the target data set based on the visualization template. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. A computer implemented method of assisting a user in the transform of an origin data set into a target data set, the method being performed on a computer system having one or more physical processors programmed with computer program instructions that, when executed by the one or more physical processors, cause the computer system to perform the method, the method comprising:
-
obtaining, by the computer system, the origin data set, the origin data set being organized in a tabular framework defined by an origin data schema; providing, by the computer system, a graphical user interface displaying the origin data set; receiving, by the computer system, through the graphical user interface, at least one designation of a data object, the at least one designation of the data object mapping at least a portion of the origin data set to the data object; generating, by the computer system, a data transform file based on the at least one designated data object, the data transform file generated in response to receiving the at least one designation of the data object; transforming, by the computer system, the origin data set into the target data set based on an execution of the data transform file, the target data set having an object-oriented based framework; comparing, by the computer system, the object-oriented based framework of the target data set to respective object-oriented based frameworks of a plurality of reference data sets; detecting, by the computer system based on the comparison, similarities between the object-oriented based framework of the target data set and the respective object-oriented based frameworks of the plurality of reference data sets; determining, by the computer system based on the similarities, a respective similarity score for at least one of the plurality of reference data sets; selecting, by the computer system, a comparable reference data set based on the at least one respective similarity score; obtaining, by the computer system, a data visualization template associated with the comparable reference data set; applying, by the computer system, the visualization template to the target data set; and displaying, by the computer system, through the graphical user interface, the target data set based on the visualization template. - View Dependent Claims (11, 12, 13, 14, 15, 16, 17, 18)
-
-
19. A non-transitory computer readable medium comprising instructions that, when executed, cause one or more processors to perform:
-
obtaining the origin data set, the origin data set being organized in a tabular framework defined by an origin data schema; providing a graphical user interface displaying the origin data set; receiving, through the graphical user interface, at least one designation of a data object, the at least one designation of the data object mapping at least a portion of the origin data set to the data object; generating a data transform file based on the at least one designated data object, the data transform file generated in response to receiving the at least one designation of the data object; transforming the origin data set into the target data set based on an execution of the data transform file, the target data set having an object-oriented based framework; comparing the object-oriented based framework of the target data set to respective object-oriented based frameworks of a plurality of reference data sets; detecting, based on the comparison, similarities between the object-oriented based framework of the target data set and the respective object-oriented based frameworks of the plurality of reference data sets; determining, based on the similarities, a respective similarity score for at least one of the plurality of reference data sets; selecting a comparable reference data set based on the at least one respective similarity score; obtaining a data visualization template associated with the comparable reference data set; applying the visualization template to the target data set; and displaying, through the graphical user interface, the target data set based on the visualization template.
-
Specification