Abstract: Systems and methods are disclosed to implement a bounded group by query system that computes approximate time-sliced statistics for groups of records in a dataset according to a group by query. In embodiments, a single pass scan of the dataset is performed to accumulate exact results for a maximum number of groups in a result grouping structure (RGS) and approximate results for additional groups in an approximate result grouping structure (ARGS). RGSs and ARGSs are accumulated by a set of accumulator nodes and provided to an aggregator node, which combines the received structures to generate exact or approximate statistical results for at least a subset of the groups in the dataset. Advantageously, the disclosed query system is able to produce approximate results for at least some of the groups in a single pass of the dataset using size-bounded data structures, without predetermining the actual number of groups in the dataset.

Abstract: Systems and methods are disclosed to implement a distributed query execution system that performs statistical operations on specified time windows over time-based datasets. In embodiments, the query system splits a statistical function into a set of parallel accumulator tasks that correspond to different portions of the dataset and/or function time windows. The accumulator tasks are executed in parallel by individual accumulator nodes to generate individual statistical result structures. The structures are then combined by an aggregator node to produce an aggregate result structure that indicates the results of the statistical function over the time windows. In embodiments, the accumulator and aggregator tasks are implemented and executed using a programmable task execution framework that allows developers to define custom accumulator and aggregator tasks.

Abstract: Systems and methods are disclosed to implement a distributed query execution system that performs statistical operations on specified time windows over time-based datasets. In embodiments, the query system splits a statistical function into a set of parallel accumulator tasks that correspond to different portions of the dataset and/or function time windows. The accumulator tasks are executed in parallel by individual accumulator nodes to generate individual statistical result structures. The structures are then combined by an aggregator node to produce an aggregate result structure that indicates the results of the statistical function over the time windows. In embodiments, the accumulator and aggregator tasks are implemented and executed using a programmable task execution framework that allows developers to define custom accumulator and aggregator tasks.

Abstract: A device for holding endotracheal tubes includes a bite tube that defines a passage zone for at least one endotracheal tube; a front plate and an adjustable retainer joined to the bite tube, and which form means for limiting displacement of the bite tube in an axial direction towards the interior and exterior of the mouth of the patient, respectively; and means for immobilising at least one endotracheal tube with respect to the bite tube in an axial direction. The device includes a lateral opening along the entire length of the bite tube, the front plate and the adjustable retainer for lateral or transversal introduction of at least one endotracheal tube into the passage zone defined by the bite tube.

Abstract: The insert for vehicle wheels comprises an insert body (1) and fastening means that enable said insert to be fastened to a rim (4) of a wheel, wherein said fastening means comprise at least one retaining element (2) provided with a step (22); and at least one fastening element (3) covering the or each retaining element (2), the or each fastening element (3) comprising at least one tab (33) that is coupled to said step (22). The invention provides an insert for use thereof in a wheel of a vehicle that is inexpensive and can be easily mounted from the front portion thereof, but which has an anti-theft system that prevents the removal thereof from the front portion and enables most of said insert to be made of a material that does not require high thermal resistance.

Abstract: The present invention is related to an immunogenic complex comprising a polymerized antigen, mannan and a dialdehyde, the composition comprising it and the use thereof as an immune response stimulator and vaccine, useful in the treatment of infectious diseases, neoplasms and allergies. Likewise, the invention relates to the method for obtaining said immunogenic complex, based on the antigen and mannan simultaneous polymerization and conjugation by using a dialdehyde.

Abstract: A piece of furniture having a convertible work surface, comprising: a lower frame suitable for supporting a surface on which a fixed part is arranged, having the fixed part a series of concave curved faces on its periphery; and a number of mobile parts having at least one convex curved face and two straight faces on the periphery thereof, said straight faces being arranged perpendicular to one another. The mobile parts are provided with means for arranging same in relation to the lower frame, in a first operating position in which the mobile parts are arranged around the fixed part, defining, together with the fixed part, a first work surface; and a second operating position in which the mobile parts are arranged on top of the fixed part, abutting along their straight faces, said mobile parts defining a second work surface.

Abstract: The hubcap for vehicle wheels comprises a disk (1), a ring (2) to secure the hubcap to said rim of the vehicle wheel and a plurality of securing modules (3) for securing the ring (2) to said disk (1), each of said securing modules (3) comprising at least a first securing element (5) which is coupled to said ring (2); characterized in that each securing module (3) also comprises a positioner (8), such that the ring (2) is retained between the first securing element (5) and the positioner (8) in its position of use, said first securing element (5) and said positioner (8) defining a lodging for said ring (2) before placing it in its position of use. It enables simpler placement of the ring, which can be carried out by applying pressure solely in the axial direction.

Abstract: The present invention is related to an immunogenic complex comprising a polymerized antigen, mannan and a dialdehyde, the composition comprising it and the use thereof as an immune response stimulator and vaccine, useful in the treatment of infectious diseases, neoplasms and allergies. Likewise, the invention relates to the method for obtaining said immunogenic complex, based on the antigen and mannan simultaneous polymerization and conjugation by using a dialdehyde.