Abstract: The disclosure generally describes computer-implemented methods, software, and systems, including a method for storing information. In a database including plural records having time-related characteristics, a time-related partition is identified for relocating records in the partition to secondary storage. For each pair in one or more pairs of different time-related characteristic values of the records in the partition, a time-related distance is determined between the different time-related characteristic values. The time-related distances are aggregated for the partition. Information is stored in an index in primary storage that identifies the aggregated time-related distances for the partition.

Abstract: The disclosure generally describes computer-implemented methods, software, and systems, including a method for storing information. In a database including plural records having time-related characteristics, a time-related partition is identified for relocating records in the partition to secondary storage. For each pair in one or more pairs of different time-related characteristic values of the records in the partition, a time-related distance is determined between the different time-related characteristic values. The time-related distances are aggregated for the partition. Information is stored in an index in primary storage that identifies the aggregated time-related distances for the partition.

Abstract: Systems and techniques for sequencing transactions and operations. In one aspect, an article includes one or more machine-readable media storing instructions operable to cause one or more machines to perform operations. The operations include identifying a delta of a first data store, and replicating the delta, including the transaction, to a second data store. The delta comprising a collection of changes to the first data store since a previous replication. The delta includes a transaction that began before the previous replication but did not commit before the previous replication replicated data from the first data store.

Abstract: The present disclosure includes systems and techniques relating to integration of a service-oriented transaction system with an information storage, access and analysis system, such as a Business Intelligence (BI) infrastructure. In general, in some implementations, a data transformation interface and a data transfer interface can be configured to effect data exchange between a computer-based information storage, access and analysis system including a second data model, and a computer-based service-oriented transactional system including a first data model. The data transformation interface and the data transfer interface can be configured to communicate through a decoupled information exchange that separates program implementation details of the data transfer interface from the data transformation interface.

Abstract: Methods and apparatus, including computer systems and program products, for normalizing computer-represented collections of objects. A first minimum value can be normalized based on a second minimum value of a universal set object that corresponds to the first set object. The second minimum value is both a minimum value supported by a data type (e.g., 1-byte integer) and a minimum value defined to be in the universal set object (e.g., 0 for a universal set of all natural numbers). Similarly, a first maximum value can be normalized based on a second maximum value of the universal set object where the second maximum value is both a maximum value supported by a data type and in the universal set object. Intervals can be normalized, which can involve replacing half-open intervals with equivalent half-closed intervals. Also, a consecutively ordered, uninterrupted, sequence of values of a set object can be normalized.

Abstract: Systems and techniques for the hybrid provision of data are described. In one aspect, a system includes a first collection of information stored in accordance with a reporting data model, a second collection of information setting forth a collection of one or more additive delta records, and an analytic engine to perform queries on the first collection of information and the second collection of information to yield an aggregated result set that is based on the contents of both the first collection of information and the second collection of information. The additive delta records each include a numeric value that characterizes the magnitude of a change to a numeric measure in the first collection and identification information that identifies the numeric measure in the first collection. The identified numeric measure is no longer current.

Abstract: Methods and apparatus, including computer systems and program products, for machine-implemented representations of collections of objects. A method includes providing data structure definitions that define a set object to represent the collection of objects; and generating, with a computer-implemented constructor using the one or more data structure definitions, a set object representing the collection of objects. The data structure definitions may define the set object to be a one-dimensional set object including a first list of knot elements, a second list representing the knot elements that the one-dimensional set includes, and a third list representing elements, other than the knot elements, that are included in the one-dimensional set. The data structure definitions may define the set object to be a multi-dimensional set object including set objects, such as one-dimensional set objects or other multi-dimensional set objects, nested within the multi-dimensional set object.

Abstract: The present disclosure includes systems and techniques relating to integration of a service-oriented transaction system with an information storage, access and analysis system, such as a Business Intelligence (BI) infrastructure. In general, in some implementations, a data transformation interface and a data transfer interface can be configured to effect data exchange between a computer-based information storage, access and analysis system including a second data model, and a computer-based service-oriented transactional system including a first data model. The data transformation interface and the data transfer interface can be configured to communicate through a decoupled information exchange that separates program implementation details of the data transfer interface from the data transformation interface.

Abstract: Systems and techniques for the hybrid provision of data are described. In one aspect, a system includes a first collection of information stored in accordance with a reporting data model, a second collection of information setting forth a collection of one or more additive delta records, and an analytic engine to perform queries on the first collection of information and the second collection of information to yield an aggregated result set that is based on the contents of both the first collection of information and the second collection of information. The additive delta records each include a numeric value that characterizes the magnitude of a change to a numeric measure in the first collection and identification information that identifies the numeric measure in the first collection. The identified numeric measure is no longer current.

Abstract: Systems and techniques for sequencing transactions and operations. In one aspect, an article includes one or more machine-readable media storing instructions operable to cause one or more machines to perform operations. The operations include identifying a delta of a first data store, and replicating the delta, including the transaction, to a second data store. The delta comprising a collection of changes to the first data store since a previous replication. The delta includes a transaction that began before the previous replication but did not commit before the previous replication replicated data from the first data store.