Interactive interpreter and graphical user interface

Abstract

A text-based interactive interpreter and user interface that sequentially allows a user to modify, transform, or filter data sets from a database system. Execution of user generated instructions results in output that can be rendered as a table, map, JSON, or other view. A user can easily retrieve a data set from a resource identifier for the data set. Instructions and results are presented in a sequential manner down the user interface page. Instructions can refer to variables and output data from previous blocks in the user interface page. The interpreted user-generated textual instruction areas can retrieve a data set specified in the textual blocks, parse and execute the textual instructions to transform, filter, or manipulate the data set. The resulting data set is rendered according to the data type, default settings, or preconfigured preferences into a table, map, JSON, or other view. Each or a subset of the textual instruction blocks can be persisted, versioned, and permissioned according to access control lists. The particular session of textual instruction blocks and transformations can be published as a service, which, if called again, can dynamically perform the user generated instructions and output the result data.