Abstract: A method for a multi-cluster warehouse includes allocating a plurality of compute clusters as part of a virtual warehouse. The compute clusters are used to access and perform queries against one or more databases in one or more cloud storage resources. The method includes providing queries for the virtual warehouse to each of the plurality of compute clusters. Each of the plurality of compute clusters of the virtual warehouse receives a plurality of queries so that the computing load is spread across the different clusters. The method also includes dynamically adding compute clusters to and removing compute clusters from the virtual warehouse as needed based on a workload of the plurality of compute clusters.

Abstract: A method for a multi-cluster warehouse includes allocating a plurality of compute clusters as part of a virtual warehouse. The compute clusters are used to access and perform queries against one or more databases in one or more cloud storage resources. The method includes providing queries for the virtual warehouse to each of the plurality of compute clusters. Each of the plurality of compute clusters of the virtual warehouse receives a plurality of queries so that the computing load is spread across the different clusters. The method also includes dynamically adding compute clusters to and removing compute clusters from the virtual warehouse as needed based on a workload of the plurality of compute clusters.

Abstract: The subject technology receives a query plan, the query plan comprising a set of query operations, the set of query operations including at least one aggregation and at least one join operation. The subject technology analyzes the query plan to identify an aggregation that is redundant. The subject technology removes the aggregation based at least in part on the analyzing. The subject technology determines at least one aggregation property corresponding to at least one query operation of the query plan. The subject technology inserts at least one adaptive aggregation operator in the query plan based at least in part on the at least one aggregation property. The subject technology provides a modified query plan based at least in part on the inserted at least one adaptive aggregation operator in the query plan.

Abstract: Joining data using a disjunctive operator is described. An example computer-implemented method can include receiving a query that includes a first disjunctive predicate involving a first table and a second table. The method may also include determining a first set of rows from the first table and generating a filter from the first set of rows. The method may also further include applying the filter to the second table to generate a second set of rows. Additionally, the method may also include joining the first set of rows and the second set of rows using a first disjunctive operator of the first disjunctive predicate to generate a first results set.

Abstract: Systems, methods, and devices, for managing data skew during a join operation are disclosed. A method includes computing a hash value for a join operation and detecting data skew on a probe side of the join operation at a runtime of the join operation using a lightweight sketch data structure. The method includes identifying a frequent probe-side join key on the probe side of the join operation during a probe phase of the join operation. The method includes identifying a frequent build-side row having a build-side join key corresponding with the frequent probe-side join key. The method includes asynchronously distributing the frequent build-side row to one or more remote servers.

Abstract: Systems, methods, and devices, for managing data skew during a join operation are disclosed. A method includes computing a hash value for a join operation and detecting data skew on a probe side of the join operation at a runtime of the join operation using a lightweight sketch data structure. The method includes identifying a frequent probe-side join key on the probe side of the join operation during a probe phase of the join operation. The method includes identifying a frequent build-side row having a build-side join key corresponding with the frequent probe-side join key. The method includes asynchronously distributing the frequent build-side row to one or more remote servers.

Abstract: The invention relates to a device (1) for recording and transmitting image and audio data, comprising: a head mounting (1a), wherein the head mounting (1a) comprises a forehead portion (2), a first side portion (3) and a second side portion (4), wherein the head mounting (1a) is adapted and configured to be mounted on a human head (100), so as to be stabilized on at least three points (5, 6, 7) on the human head (100), wherein a first point (5) among the at least three points (5, 6, 7) is arranged on the first side portion (3), a second point (6) among the at least three point (5, 6, 7) is arranged on the second side portion (4), and a third point (7) among the at least three points (5, 6, 7) is arranged on the forehead portion (2) of the head mounting (1a); a first camera (8) and a second camera (9) that are arranged on the forehead portion (2) of the head mounting (1a) at a predefined distance (10) along a horizontal extension direction (11) of the forehead portion (2); wherein the forehead portion (2), in

Abstract: A display device for displaying a selection of permanently specified display elements with a front panel that has a plurality of windows that form a number of permanently specified display elements, an electrophoretic electronic paper that is arranged behind the front panel so that a partial surface of the electronic paper is assigned to each of the windows, and an electronic control with which a degree of reflection of the electronic paper can be set for each of the partial surfaces.

Abstract: A method for a multi-cluster warehouse includes allocating a plurality of compute clusters as part of a virtual warehouse. The compute clusters are used to access and perform queries against one or more databases in one or more cloud storage resources. The method includes providing queries for the virtual warehouse to each of the plurality of compute clusters. Each of the plurality of compute clusters of the virtual warehouse receives a plurality of queries so that the computing load is spread across the different clusters. The method also includes dynamically adding compute clusters to and removing compute clusters from the virtual warehouse as needed based on a workload of the plurality of compute clusters.

Abstract: A process for the extrusion of a composition from an extruder, which composition is suitable for use in a food product, is disclosed. The process provides a composition which is comprised of a hydrophilicized carrier and surface-active compound which is extruded. The process describes adding the surface-active compound after the carrier is hydrophilicized.

Abstract: The invention concerns a timepiece that has a single hand, which is movable into a plurality of hand positions. The timepiece has a clockwork for mechanically moving the hand so that the hand is located in a hand position which corresponds to a current time of day and an actuating element connected to the clockwork. The clockwork is designed to change, upon actuation of the actuating element, from a first operating state into a second operating state and to move the hand so that the hand position in the first operating state displays minute information and in the second operating state displays hour information.

Abstract: A device for displaying a text message, comprising a display (10) having a plurality of characters, each of said characters being arranged at a fixed position, not overlapping with any other of said characters, and being adapted to be switched on and off, and a controller being connected to said plurality of characters and being adapted to switch on and off selected characters so that at a given time, a selected sub-group of said characters is switched on, the selected sub-group displaying a text message.

Abstract: A single hand timepiece having a single hand, which is movable into a plurality of hand positions, a clockwork for mechanically moving the hand so that the hand is located in a hand position which corresponds to a current time of day, characterized in that the single hand timepiece has an actuating element connected to the clockwork, and the clockwork is designed to change, upon actuation of the actuating element, from a first operating state into a second operating state and to move the hand so that the hand position in the first operating state displays minute information and in the second operating state displays hour information.

Abstract: A device for displaying a text message, comprising a display (10) having a plurality of characters, each of said characters being arranged at a fixed position, not overlapping with any other of said characters, and being adapted to be switched on and off, and a controller being connected to said plurality of characters and being adapted to switch on and off selected characters so that at a given time, a selected sub-group of said characters is switched on, the selected sub-group displaying a text message.