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 event information. A plurality of events associated with entities may be provided. A plurality of state types may be determined based on the plurality of events such that each state type is associated with a state. State keys associated with each entity may be determined based on events associated with each entity and the state types. A state stream for each entity may be provided based on their state keys such that each state stream may be an ordered sequence of the keys associated with each entity. In response to a query that includes a pattern filter, the pattern filter may be employed to determine a portion of the entities based on the state stream for each entity such that the pattern filter matches the state stream for each of the portion of the entities.

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.

Abstract: Embodiments are directed to managing event information. A plurality of events associated with entities may be provided. A plurality of state types may be determined based on the plurality of events such that each state type is associated with a state. State keys associated with each entity may be determined based on events associated with each entity and the state types. A state stream for each entity may be provided based on their state keys such that each state stream may be an ordered sequence of the keys associated with each entity. In response to a query that includes a pattern filter, the pattern filter may be employed to determine a portion of the entities based on the state stream for each entity such that the pattern filter matches the state stream for each of the portion of the entities.

Abstract: Selecting and formatting warped text is disclosed. Text effects such as an underline effect and/or a strikethrough effect may be transformed along with rectangular text to form a warped text element. In such a situation, the text effects are warped with the characters of the text. Also, warped text may be accurately selected or “hit.” The coordinates of a selection of warped text are inversely transformed to map the selection to the rectangular text. The inverse transform provides an accurate manner to determine the scope and location of the selection. When the scope and location are determined, the graphical representation of the selection may be transformed to provide a user with an accurate representation of a warped selection.