Abstract: Some embodiments provide techniques of enforcing valid data assignments in a data processing system in which data can be dynamically updated by user devices and/or computerized processes. The techniques identify, using a validation rule associated with a data entity, one or more valid values for assignment to an attribute of an instance of the data entity. The techniques identify the valid value(s) by generating a query for the one or more valid values using one or more condition(s) on the attribute in the validation rule, and executing the generated query to obtain the one or more valid values for the first attribute. The attribute may then be assigned one or more of the identified valid value(s).

Abstract: Methods, systems, and apparatus, including computer programs encoded on computer storage media, for specifying logical rules, one of the methods includes defining a logical rule, the logical rule applying operations based on a term. The method includes defining a mapping between fields and terms, the mapping including a mapping between a field and the term. The method includes storing the logical rule in association with the term. The method also includes applying the logical rule to data identified by the first field where respective fields are assigned to respective terms.

Abstract: Among other things, we describe a technique for storing data of a data cube in one or more flat files. We also describe a technique for processing a query to access data of a data cube. These techniques can be implemented in a number of ways, including as a method, system, and/or computer program product stored on a computer readable storage device. One of the techniques includes receiving a set of data records having at least two dimensions, generating a set of grouped data records ordered by cardinality, and generating and storing at least one flat file containing the set of grouped data records, wherein a particular data record of the grouped data records includes a primary key that can be used to identify data of the particular data record in response to a request.

Abstract: Among other things, we describe a technique for storing data of a data cube in one or more flat files. We also describe a technique for processing a query to access data of a data cube. These techniques can be implemented in a number of ways, including as a method, system, and/or computer program product stored on a computer readable storage device. One of the techniques includes receiving a set of data records having at least two dimensions, generating a set of grouped data records ordered by cardinality, and generating and storing at least one flat file containing the set of grouped data records, wherein a particular data record of the grouped data records includes a primary key that can be used to identify data of the particular data record in response to a request.

Abstract: Methods, systems, and apparatus, including computer programs encoded on computer storage media, for generating conditional validation rules. One of the methods includes rendering a plurality of cells arranged in a two-dimensional grid having a first axis and a second axis, the two-dimensional grid including one or more subsets of the cells, each subset associated with a respective field of an element of the dataset, and multiple subsets of the cells extending in a direction along the second axis of the two-dimensional grid, one or more of the multiple subsets associated with a respective validation rule. The method includes applying one or more validation rules to an element of the dataset based on user input received from at least some of the cells. A condition cell associated with a field includes an input element for receiving input.

Abstract: Methods, systems, and apparatus, including computer programs encoded on computer storage media, for generating conditional validation rules. One of the methods includes rendering a plurality of cells arranged in a two-dimensional grid having a first axis and a second axis, the two-dimensional grid including one or more subsets of the cells, each subset associated with a respective field of an element of the dataset, and multiple subsets of the cells extending in a direction along the second axis of the two-dimensional grid, one or more of the multiple subsets associated with a respective validation rule. The method includes applying one or more validation rules to an element of the dataset based on user input received from at least some of the cells. A condition cell associated with a field includes an input element for receiving input.

Abstract: Methods, systems, and apparatus, including computer programs encoded on computer storage media, for specifying logical rules, one of the methods includes defining a logical rule, the logical rule applying operations based on a term. The method includes defining a mapping between fields and terms, the mapping including a mapping between a field and the term. The method includes storing the logical rule in association with the term. The method also includes applying the logical rule to data identified by the first field where respective fields are assigned to respective terms.

Abstract: To address needs of journalists and other editors, an audiovisual editing system associates segments of audiovisual materials with segments of related text. The editing system permits an editor to edit both the audiovisual materials of the segments and to edit the related text. The data structure representing the story includes a list of media segments and a list a text segments and a correspondence among the segments. Each media segment has a type, such as script, SOT and voice, and includes a list of video clips. These data structures enable the editing system to provide a simple and intuitive interface for editing a story, and can be transformed in a straightforward manner into a conventional, multitrack sequence used to represent an audiovisual composition. The editing system automatically defines parameters, such as designating the correct audio tracks, which minimize the chance for errors and speeds the workflow. Automatic ducking of these tracks also can be provided.

Abstract: An audiovisual editing system associates segments of audiovisual materials with related text. The editing system permits an editor to edit the references to the audiovisual materials of a segment and to edit the related text. An estimated time for reading the related text aloud by the newscaster is determined. This estimated time for reading the related text of the segment may be compared to the actual duration of the audiovisual material of the segment. The difference in the duration of the audiovisual material and the duration of the related text may be displayed to the editor. Also, any position in the text for a segment may be mapped to a corresponding position in time in the audiovisual material for the segment, and this position may be indicated to the editor. Additionally, in response to edits of the related text of a segment, a corresponding editing operation can be automatically performed on the reference to the audiovisual information of the segment.