Step editor for data preparation

Abstract

A step editor for data preparation can instruct a user interface to present a first plurality of operations to be applied in a sequential order to one or more sets of data, receive user inputs including at least one indication to mute at least one operation of the first plurality of operations to prevent the processors from performing the at least one operation, generate a second plurality of operations, the second plurality of operations to be applied in a sequential order to the sets of data and comprising the first plurality of operations excluding the operation muted by the user inputs, obtain a cached data traversal program associated with the second plurality of operations and comprising a representation of a result of transforming the sets of data, and instruct the user interface to present output based at least in part on execution of the cached data traversal program.

What is claimed is: 
     
         1 . A system, comprising:
 one or more processors configured to:   present, in a user interface, a first plurality of sequenced data preparation operations;   receive, via the user interface, one or more user inputs with respect to the first plurality of sequenced data preparation operations presented via the user interface;   based at least in part on the one or more user inputs, determine a second plurality of sequenced data preparation operations, the second plurality of sequenced data preparation operations comprising a version of the first plurality of sequenced data preparation operations;   generate a signature based at least in part on the second plurality of sequenced data preparation operations;   in response to determining a match between the generated signature and a cached signature, obtain a cached data traversal program associated with the cached signature, the cached data traversal program comprising a representation of a result of transforming one or more sets of data; and   present, via the user interface, output based at least in part on execution of the cached data traversal program; and   a memory coupled to the one or more processors and configured to provide the one or more processors with instructions.   
     
     
         2 . The system recited in  claim 1  wherein a user input in the one or more user inputs comprises deleting, via the user interface, a data preparation step in the first plurality of sequenced data preparation operations. 
     
     
         3 . The system recited in  claim 1  wherein a user input in the one or more user inputs comprises, via the user interface, stepping backwards through the first plurality of sequenced data preparation operations. 
     
     
         4 . The system recited in  claim 1  wherein a user input in the one or more user inputs comprises, via the user interface, stepping forwards through the first plurality of sequenced data preparation operations. 
     
     
         5 . The system recited in  claim 1  wherein a user input in the one or more user inputs comprises muting, via the user interface, a data preparation operation in the first plurality of sequenced data preparation operations. 
     
     
         6 . The system recited in  claim 1 , wherein a set of rows is determined based at least in part on the execution of the cached data traversal program, and wherein the one or more processors are configured to present at least a portion of the rows via the user interface. 
     
     
         7 . The system recited in  claim 1  wherein generating the signature comprises generating a hash based at least in part on the second plurality of sequenced data preparation operations. 
     
     
         8 . The system recited in  claim 1  wherein the signature is generated based at least in part on a script that is generated in response to the one or more user inputs with respect to the first plurality of sequenced data preparation operations. 
     
     
         9 . The system recited in  claim 1  wherein the cached data traversal program indicates how to assemble one or more affected columns in the one or more sets of data to derive the result represented by the cached data traversal program. 
     
     
         10 . The system recited in  claim 1  wherein a data preparation operation comprises an operation that transforms at least a portion of a set of data. 
     
     
         11 . A method, comprising:
 presenting, in a user interface, a first plurality of sequenced data preparation operations;   receiving, via the user interface, one or more user inputs with respect to the first plurality of sequenced data preparation operations presented via the user interface;   based at least in part on the one or more user inputs, determining a second plurality of sequenced data preparation operations, the second plurality of sequenced data preparation operations comprising a version of the first plurality of sequenced data preparation operations;   generating a signature based at least in part on the second plurality of sequenced data preparation operations;   in response to determining a match between the generated signature and a cached signature, obtaining a cached data traversal program associated with the cached signature, the cached data traversal program comprising a representation of a result of transforming one or more sets of data; and   presenting, via the user interface, output based at least in part on execution of the cached data traversal program.   
     
     
         12 . The method of  claim 11  wherein a user input in the one or more user inputs comprises deleting, via the user interface, a data preparation step in the first plurality of sequenced data preparation operations. 
     
     
         13 . The method of  claim 11  wherein a user input in the one or more user inputs comprises, via the user interface, stepping backwards through the first plurality of sequenced data preparation operations. 
     
     
         14 . The method of  claim 11  wherein a user input in the one or more user inputs comprises, via the user interface, stepping forwards through the first plurality of sequenced data preparation operations. 
     
     
         15 . The method of  claim 11  wherein a user input in the one or more user inputs comprises muting, via the user interface, a data preparation operation in the first plurality of sequenced data preparation operations. 
     
     
         16 . The method of  claim 11 , wherein a set of rows is determined based at least in part on the execution of the cached data traversal program, and further comprising presenting at least a portion of the rows via the user interface. 
     
     
         17 . The method of  claim 11  wherein generating the signature comprises generating a hash based at least in part on the second plurality of sequenced data preparation operations. 
     
     
         18 . The method of  claim 11  wherein the signature is generated based at least in part on a script that is generated in response to the one or more user inputs with respect to the first plurality of sequenced data preparation operations. 
     
     
         19 . The method of  claim 11  wherein the cached data traversal program indicates how to assemble one or more affected columns in the one or more sets of data to derive the result represented by the cached data traversal program. 
     
     
         20 . The method of  claim 11  wherein a data preparation operation comprises an operation that transforms at least a portion of a set of data.