US 12,443,593 B1
System and a method for data transformation using a spreadsheet-like user interface
Shuveb Hussain, Chennai (IN); Arun Venkataswamy, Chennai (IN); Narendran HAriparant Haman, Chennai (IN); and Rao Koteswara, Los Altos, CA (US)
Assigned to Zipstack, Los Altos, CA (US)
Filed by Shuveb Hussain, Chennai (IN); Arun Venkataswamy, Chennai (IN); Narendran HAriparant Haman, Chennai (IN); and Rao Koteswara, Los Altos, CA (US)
Filed on Apr. 15, 2024, as Appl. No. 18/635,915.
Claims priority of provisional application 63/496,193, filed on Apr. 14, 2023.
Int. Cl. G06F 16/242 (2019.01); G06F 16/25 (2019.01); G06F 40/18 (2020.01)
CPC G06F 16/2423 (2019.01) [G06F 16/258 (2019.01); G06F 40/18 (2020.01)] 14 Claims
OG exemplary drawing
 
1. A computer-implemented system for transforming data from a source format to a user-desired target format, said system comprising:
a relational database configured to store at least a first data table, said first data table comprising predetermined data arranged in a plurality of rows and a plurality of columns, said predetermined data comprising values of a plurality of attributes;
a processor communicably coupled to said relational database, said processor configured to:
process said first data table incorporating said predetermined data and programmatically extract a subset of said predetermined data;
programmatically embed into a user interface, one or more spreadsheet-specific data processing options usable for manipulating at least said subset of said predetermined data;
trigger said user interface to display said subset of predetermined data in a predetermined format and to display said one or more spreadsheet-specific data processing options for facilitating manipulation of said subset of predetermined data;
identify said one or more spreadsheet-specific data processing options selected by a user for manipulating said subset of predetermined data, and further identify one or more corresponding actions to be implemented on said subset of predetermined data;
automatically generate one or more database queries for executing said one or more actions on said subset of predetermined data, based on said one or more spreadsheet-specific data processing options selected by said user, and thereby programmatically transform said one or more spreadsheet-specific data processing options and said one or more corresponding actions into said one or more database queries;
implement said one or more database queries on said subset of predetermined data;
programmatically extrapolate said one or more database queries to said predetermined data stored on said first data table, and thereby implement said one or more spreadsheet-specific data processing options and said one or more corresponding actions on said predetermined data stored on said first data table, and wherein said one or more database queries are extrapolated to an entirety of said first data table, thereby enabling the processor to:
process the entirety of said predetermined data stored in said first data table, based on said one or more database queries that were previously applied only to said subset of predetermined data extracted from said first data table; and
implement said one or more spreadsheet-specific data processing options on the entirety of said first data table and the entirety of said predetermined data stored thereon;
programmatically update said predetermined data stored on said first data table based on implementation of said one or more database queries on said first data table, and create updated data; and
wherein said processor is further configured to generate a plurality of intermediate representations indicative of said one or more spreadsheet-specific data processing options selected by said user, said one or more corresponding actions identified by said processor, said first data table containing said predetermined data, and a second data table containing said updated data, and wherein said processor is further configured to track changes in said predetermined data from an initial state to intermediate states and a final state.