Abstract: In one embodiment, a complex query includes components that are arranged in a hierarchical structure including a first type of filter and a second type of filter and are connected by connectors. The method selects a first data set and selects a second data set for the components. The second data set being generated by processing data in the first data set for the second type of filter and the second data set includes entries describing a result of the processing. The first type of filter is applied to the first data set and the second type of filter to the second data set for the components where the information describing the result is used by the second type of filter to filter entries and first type of filter filters entries based on column values in the first data set. The method combines outputs of the components using the connectors.

Abstract: The disclosure generally describes methods, software, and systems, including a method for managing modifications to a document by collaborators. A digital document is identified for collaboration by a first user having ownership privileges for the document. The collaboration is associated with at least one collaborator. A duplicate version of the identified document is provided to each of the identified collaborators. The duplicate versions are monitored for modifications performed by corresponding collaborators. A list of modifications is created that identifies the modifications performed by the corresponding collaborators in the duplicate versions associated with those collaborators. A selection from the list of modifications is received from the first user of at least one modification for incorporation into the identified document. Based on the received selection, the selected at least one modification is merged into the identified document.

Abstract: In one embodiment, a complex query includes components that are arranged in a hierarchical structure including a first type of filter and a second type of filter and are connected by connectors. The method selects a first data set and selects a second data set for the components. The second data set being generated by processing data in the first data set for the second type of filter and the second data set includes entries describing a result of the processing. The first type of filter is applied to the first data set and the second type of filter to the second data set for the components where the information describing the result is used by the second type of filter to filter entries and first type of filter filters entries based on column values in the first data set. The method combines outputs of the components using the connectors.

Abstract: The disclosure generally describes methods, software, and systems, including a method for managing modifications to a document by collaborators. A digital document is identified for collaboration by a first user having ownership privileges for the document. The collaboration is associated with at least one collaborator. A duplicate version of the identified document is provided to each of the identified collaborators. The duplicate versions are monitored for modifications performed by corresponding collaborators. A list of modifications is created that identifies the modifications performed by the corresponding collaborators in the duplicate versions associated with those collaborators. A selection from the list of modifications is received from the first user of at least one modification for incorporation into the identified document. Based on the received selection, the selected at least one modification is merged into the identified document.

Abstract: The present disclosure includes techniques pertaining to computer implemented systems and methods for automatic generation of data transformations. In one embodiment, a user manipulates a spreadsheet of data in a user interface. On a backend, the user's manipulations trigger actions that cause the data to be modified. Actions may automatically cause data flow objects and data flow graphs to be produced. The transformations defined by the data flow graphs are automatically executed by a software engine and the results are displayed to the user. The user may access and manipulate data from a variety of data sources while the underlying complexities of the transformation process are performed in an automated manner.

Abstract: The present disclosure includes techniques pertaining to computer implemented systems and methods for automatic generation of data transformations. In one embodiment, a user manipulates a spreadsheet of data in a user interface. On a backend, the user's manipulations trigger actions that cause the data to be modified. Actions may automatically cause data flow objects and data flow graphs to be produced. The transformations defined by the data flow graphs are automatically executed by a software engine and the results are displayed to the user. The user may access and manipulate data from a variety of data sources while the underlying complexities of the transformation process are performed in an automated manner.

Abstract: When a set of screen elements are identified as a family a bounded extent is placed around the identified elements. Items can be automatically grouped based on their association with a set of data defined in a DBMS as a family, for example. When one of the elements within the group is moved, the extent automatically resizes to a new geometry that fits around each of the elements within the group. If an element within the group is moved against the extent and then extended beyond the boundaries of the extent, the extent automatically resizes to cover a bigger area; if an element within the group that is against the extent is moved inside the boundary of the extent, the extent automatically resizes to cover a smaller area. It is possible to nest a set of these extensible groups within a single extensible group thereby providing maximum flexibility while still maintaining optimal flexibility.

Abstract: Enables locating and merging potential data record matches. Enables locating duplicates through the definition of matching strategies. Each strategy may include transformations, matching rules and scoring thresholds to implement fuzzy matches that match closely related data records that are not exact matches. Performing a search allows for narrowing down the records to a desired set on which to apply a given matching strategy. Merging is performed on the potential duplicates thus located to consolidate data and remove duplicates. By narrowing down the records to a closely related set via a search, merging is simplified to work on a small number of closely related records, thus simplifying the process. The total matching score obtained via execution of match strategies may be utilized to determine which potential record(s) to merge for example. May utilize past user input to provide intelligent inputs for rules, tokens, weights, fields, parameters or any other past user input.

Abstract: When a set of screen elements are identified as a family a bounded extent is placed around the identified elements. Items can be automatically grouped based on their association with a set of data defined in a DBMS as a family, for example. When one of the elements within the group is moved, the extent automatically resizes to a new geometry that fits around each of the elements within the group. If an element within the group is moved against the extent and then extended beyond the boundaries of the extent, the extent automatically resizes to cover a bigger area; if an element within the group that is against the extent is moved inside the boundary of the extent, the extent automatically resizes to cover a smaller area. It is possible to nest a set of these extensible groups within a single extensible group thereby providing maximum flexibility while still maintaining optimal flexibility.

Abstract: An interface for indicating the presence of inherited values in a document. The interface enables a user to rapidly determine if an audience specific document conforms to the expectations or requirements of an intended audience. The interface distinguishes between current, primary and secondary audience layer values through the use of color or any other mechanism that allows a user to quickly identify data that is missing and needs to be populated, changed or remain unchanged if the inherited data is suitable for the given audience. Using the interface, users can determine at a glance what information is inherited and what level of inheritance that information is from. Before generating an audience specific document targeted at a particular media type, an audience hierarchy may be created and utilized for entry and edit of data for a desired audience.

Abstract: Audience specific document targeted at a particular media type are generated by accessing data from an audience hierarchy. When obtaining a data value for a particular audience, if that value does not exist for that audience then the audience hierarchy may be utilized to find the data value for an inherited audience. By adding regional, cultural or regulatory subdivisions within the audience hierarchy and inheriting large portions of existing audience specific data entries, a large number of audience specific documents may be generated with a minimal amount of data entry required. Audiences may be specified in a given order for traversal within the hierarchy and displayed in a data entry and editing application utilizing visual characteristics to inform a user if the value for a particular piece of data is inherited from another layer or utilized from the particular layer in use. Audience specific documents may be masked and accessed by payment.