Abstract: A user interface displays: a first column comprising non-editable input strings retrieved from a data field; a second column comprising editable output strings initialized from the data field; and an expression window displaying a transformation function ƒ. The computer iteratively processes user inputs, each user input i providing a sample row transformation to edit an ith output string ti. Some user inputs i designate a contiguous substring ssi of the corresponding input string si. The contiguous substring expresses a causal basis for transforming the input string si. into the output string ti. The computer updates the transformation function ƒ according to the provided sample row transformations so that: ƒ(s1)=t1, . . . , ƒ(si)=ti; the transformation function ƒ specifies text or string position of at least one contiguous substring; and ƒ has minimal branching among possible transformation functions that satisfy the samples.

Abstract: Embodiments are directed to managing data models. A data source that includes records may be provided. Source fields may be determined based on the records and the source fields may be displayed in a source panel. A data model that includes a source data object may be displayed. Relationships between the source fields may be determined based on values in the records. In response to providing a relationship between the source fields, a data object that includes a key field and one or more data fields that correspond to the relationship may be generated. The data model may be modified to include the data object and to remove the source fields that correspond to the data fields.

Abstract: Embodiments are directed to managing data models. A data source that includes records may be provided. Source fields may be determined based on the records and the source fields may be displayed in a source panel. A data model that includes a source data object may be displayed. Relationships between the source fields may be determined based on values in the records. In response to providing a relationship between the source fields, a data object that includes a key field and one or more data fields that correspond to the relationship may be generated. The data model may be modified to include the data object and to remove the source fields that correspond to the data fields.