Abstract: An aggregation engine for a data warehouse which provides an indexing technique which allows the measures in a fact table data entry to be added to the appropriate aggregate bucket by mapping the each of the dimension keys to an aggregate index within a level in that dimension and then calculating an overall index using the aggregate index from each dimension which is then mapped onto the aggregate bucket in question. A rolling cache is also provided allowing frequently or recently used aggregate buckets to be represented in memory rather than in a file, and merged with the equivalent bucket in an aggregate file when necessary, so that the slower access to the address file and the aggregate files can be avoided.

Abstract: A method of populating multiple data marts in a single operation from a set of transactional data held in a database in a single aggregation process, in which aggregate values are calculated only once, a determination is made as to which output data marts required the aggregate value, and the aggregate values are output to the appropriate data marts. Dimension data associated with the output aggregate records is also output to the appropriate data marts.

Abstract: A method of populating multiple data marts in a single operation from a set of transactional data held in a database in a single aggregation process, in which aggregate values are calculated only once, a determination is made as to which output data marts required the aggregate value, and the aggregate values are output to the appropriate data marts. Dimension data associated with the output aggregate records is also output to the appropriate data marts.

Abstract: A method of defining aggregate levels to be used in aggregation in a data store having one or more dimensions. Levels are defined corresponding to attributes in the dimension, so that data can be aggregated into aggregates corresponding to values of those attributes. The invention provides for the definition of sub-levels which act as levels but define which detail entries in the associated dimension will contribute to the sub-level. The invention also provides for the definition of level groups. A level group can replace a level in a level cross-product and such a cross product is then expanded before aggregation into a set of cross products, each containing one of the level group entries.

Abstract: An electrical switch network having a substantially reduced effective ON-resistance is provided. The electrical switch network includes an input amplifier receiving the input signal at one input, and a first switch having a first terminal connected to the output of the input amplifier and a second terminal connected to a device, such as an integrator circuit, which is to receive the amplified input signal. Two additional switches are connected between a respective terminal of the first switch and a second input of the input amplifier. A pulse signal generator controls the conductive state of the switches such that the first and third switches are in a complementary conductive state with respect to the second switch. The conductive resistance of the second switch is preferably chosen to be equal to or greater than the combined conductive resistance of the first and third switches.

Abstract: An ESD protection circuit, suitable for use as part of an integrated circuit, limits the voltage potential at the contacts of the integrated circuit to a voltage potential difference range relative to, though extending beyond the voltage source potentials of the circuit protected. The ESD protection is effective regardless of whether the integrated circuit is powered. The ESD protection circuit includes a clamp subcircuit for limiting the voltage potential at a clamp point to a first voltage range approximately defined by the voltage source potentials and a voltage offset subcircuit, coupled between the clamp point and an integrated circuit contact, to establish a second voltage range encompassing the first voltage range. The voltage offset subcircuit conducts current between the clamp point and the contact to limit the voltage potential at the contact to the second voltage range.