Abstract: A system includes reception of a query execution plan associated with a plurality of query execution pipelines, estimated execution costs and estimated intermediate result cardinalities, determination of one or more precedence relationships of the plurality of query execution pipelines, determination of an execution order of the plurality of query execution pipelines based on the estimated execution costs, the estimated intermediate result cardinalities, and the one or more precedence relationships, and providing of the execution order of the plurality of query execution pipelines and the query execution plan to a query execution engine.

Abstract: The present invention relates to a method for estimating a distance between nodes of an LPWA network. First and second nodes, respectively, successively transmit a narrow band signal at a plurality of carrier frequencies to each other. The second and first nodes, respectively, receive the transmitted signals and demodulate them into baseband signals. Complex values representative of a forward-backward function of the transmission channel between two nodes are obtained from the baseband demodulated signals. These complex values are then provided to a previously supervisingly trained neural network, the neural network giving an estimation of the distance separating the first node and the second node. The present invention also relates to a method for estimating the position of a node in an LPWA network using the above-noted distance estimation method.

Abstract: Inserts for the air-conditioning of a vehicle and methods for forming same are provided. In an exemplary embodiment, the insert includes a spacer material part. The spacer material part includes an open region extending from a top side to an opposite underside, the open region forming an air-guiding structure. The spacer material part is covered by at least one cover layer on at least one of the top side and the underside. The open areas of the air-guiding structure include a plurality of ducts connected to one another to form a net-like duct structure. The duct structure forms flow regions or flow zones. A cover layer has at least one perforation in the region of connection or intersection points of the ducts.

Abstract: A method for locating a connected object within an LPWA network using a plurality of base stations. The connected object transmits packets in RF frequency channels forming a virtual band being scanned once in the uplink direction and once in the downlink direction in a symmetrical manner. The base stations receiving the signal perform an RF to intermediate frequency translation and then a baseband translation in digital mode. The phase differences of arrival for each pair of base stations and the attenuation coefficients of each transmission channel between the connected object and each base station enable a composite transfer function to be constructed for each pair of base stations. The peaks of highest amplitude are detected in the corresponding impulse responses and the distance differences between the connected object and the different base stations are derived therefrom. The position of the object is then estimated by hyperbolic trilateration.

Abstract: A system includes reception of a query execution plan associated with a plurality of query execution pipelines, estimated execution costs and estimated intermediate result cardinalities, determination of one or more precedence relationships of the plurality of query execution pipelines, determination of an execution order of the plurality of query execution pipelines based on the estimated execution costs, the estimated intermediate result cardinalities, and the one or more precedence relationships, and providing of the execution order of the plurality of query execution pipelines and the query execution plan to a query execution engine.

Abstract: A method may include responding to a query to retrieve data from a database by identifying a plurality of query execution plans. An overall robustness value may be determined for each query execution plan. The overall robustness value of a query execution plan may correspond to a sum of individual robustness values for each operator included in the query execution plan. Each operator may have an individual robustness value that corresponds to a first change in a total cost of a query execution plan including the operator relative to a second change in an output cardinality of the operator. One of the plurality of query execution plans may be selected based on the overall robustness value of each of the plurality of query execution plans. The query may be executed by performing a sequence of operators included in the selected one of the plurality of query execution plan.

Abstract: A system includes determination of a plurality of queries of a workload, determination of a data source comprising a plurality of data rows, and determination of a sample data source based on a cardinality of each of the plurality of queries with respect to the data source and an estimated cardinality of each of the plurality of queries with respect to the data source, wherein the estimated cardinality of a query with respect to the data source is determined based on the sample data source.

Abstract: A system includes determination of a query on a table, the query including a first predicate and a second predicate, determination of a sample of the table, the sample comprising a plurality of tuples of the table, determination of a first conditional probability of selecting a tuple of the sample satisfying the first predicate and the second predicate, determination of a second conditional probability of selecting a tuple of the sample satisfying the first predicate and not satisfying the second predicate, adjustment of the first conditional probability based on the second conditional probability, a number of tuples of the sample satisfying the second predicate, a number of tuples of the sample not satisfying the second predicate, and a number of tuples of the sample satisfying the first predicate and not satisfying the second predicate, and determination of a selectivity of the query on the table based on the first adjusted conditional probability.

Abstract: Inserts for the air-conditioning of a vehicle and methods for forming same are provided. In an exemplary embodiment, the insert includes a spacer material part. The spacer material part includes an open region extending from a top side to an opposite underside, the open region forming an air-guiding structure. The spacer material part is covered by at least one cover layer on at least one of the top side and the underside. The open areas of the air-guiding structure include a plurality of ducts connected to one another to form a net-like duct structure. The duct structure forms flow regions or flow zones. A cover layer has at least one perforation in the region of connection or intersection points of the ducts.

Abstract: A method may include responding to a query to retrieve data from a database by identifying a plurality of query execution plans. An overall robustness value may be determined for each query execution plan. The overall robustness value of a query execution plan may correspond to a sum of individual robustness values for each operator included in the query execution plan. Each operator may have an individual robustness value that corresponds to a first change in a total cost of a query execution plan including the operator relative to a second change in an output cardinality of the operator. One of the plurality of query execution plans may be selected based on the overall robustness value of each of the plurality of query execution plans. The query may be executed by performing a sequence of operators included in the selected one of the plurality of query execution plan.

Abstract: A method may include responding to a query to retrieve data from a database by identifying a plurality of query execution plans. An overall robustness value may be determined for each query execution plan. The overall robustness value of a query execution plan may correspond to a sum of individual robustness values for each operator included in the query execution plan. Each operator may have an individual robustness value that corresponds to a first change in a total cost of a query execution plan including the operator relative to a second change in an output cardinality of the operator. One of the plurality of query execution plans may be selected based on the overall robustness value of each of the plurality of query execution plans. The query may be executed by performing a sequence of operators included in the selected one of the plurality of query execution plan.

Abstract: A method for locating a connected object within an LPWA network using a plurality of base stations. The connected object transmits packets in RF frequency channels forming a virtual band being scanned once in the uplink direction and once in the downlink direction in a symmetrical manner. The base stations receiving the signal perform an RF to intermediate frequency translation and then a baseband translation in digital mode. The phase differences of arrival for each pair of base stations and the attenuation coefficients of each transmission channel between the connected object and each base station enable a composite transfer function to be constructed for each pair of base stations. The peaks of highest amplitude are detected in the corresponding impulse responses and the distance differences between the connected object and the different base stations are derived therefrom. The position of the object is then estimated by hyperbolic trilateration.

Abstract: A system includes determination of a query on a table, the query including a first predicate and a second predicate, determination of a sample of the table, the sample comprising a plurality of tuples of the table, determination of a first conditional probability of selecting a tuple of the sample satisfying the first predicate and the second predicate, determination of a second conditional probability of selecting a tuple of the sample satisfying the first predicate and not satisfying the second predicate, adjustment of the first conditional probability based on the second conditional probability, a number of tuples of the sample satisfying the second predicate, a number of tuples of the sample not satisfying the second predicate, and a number of tuples of the sample satisfying the first predicate and not satisfying the second predicate, and determination of a selectivity of the query on the table based on the first adjusted conditional probability.

Abstract: A system includes determination of a plurality of queries of a workload, determination of a data source comprising a plurality of data rows, and determination of a sample data source based on a cardinality of each of the plurality of queries with respect to the data source and an estimated cardinality of each of the plurality of queries with respect to the data source, wherein the estimated cardinality of a query with respect to the data source is determined based on the sample data source.

Abstract: In some implementations, there is provided an apparatus having at least one data processor and at least one memory storing instructions which, when executed by the at least one data processor, cause executing at least a portion of a query execution plan; determining, at an edge including an intermediate result, a cardinality; proceeding with the execution of the query execution plan, when the determined cardinality is within an optimality range associated with the edge; and selecting an alternative query execution plan for execution, when the determined cardinality is outside the optimality range associated with the edge. Related systems and articles of manufacture are also provided.

Abstract: The present invention relates to a method for estimating a distance between nodes of an LPWA network. A first node (a second node resp.) successively transmits a narrow band signal at a plurality of carrier frequencies (421). The second (the first resp.) node receives the transmitted signals and demodulates them into baseband (422). Complex values representative of a forward-backward function of the transmission channel between two nodes are obtained (423) from the baseband demodulated signals. These complex values are then provided to a previously supervisingly trained neural network (425), the neural network giving an estimation of the distance separating the first node and the second node. The present invention also relates to a method for estimating the position of a node in an LPWA network using said distance estimation method.

Abstract: A method may include responding to a query to retrieve data from a database by identifying a plurality of query execution plans. An overall robustness value may be determined for each query execution plan. The overall robustness value of a query execution plan may correspond to a sum of individual robustness values for each operator included in the query execution plan. Each operator may have an individual robustness value that corresponds to a first change in a total cost of a query execution plan including the operator relative to a second change in an output cardinality of the operator. One of the plurality of query execution plans may be selected based on the overall robustness value of each of the plurality of query execution plans. The query may be executed by performing a sequence of operators included in the selected one of the plurality of query execution plan.

Abstract: In some implementations, there is provided an apparatus having at least one data processor and at least one memory storing instructions which, when executed by the at least one data processor, cause executing at least a portion of a query execution plan; determining, at an edge including an intermediate result, a cardinality; proceeding with the execution of the query execution plan, when the determined cardinality is within an optimality range associated with the edge; and selecting an alternative query execution plan for execution, when the determined cardinality is outside the optimality range associated with the edge. Related systems and articles of manufacture are also provided.

Abstract: The present invention relates to the use of phospho-tartaric acid and/or the salts thereof for the treatment of water in water-conducting systems.

Abstract: A loudspeaker overload protection circuit and method receives at a compressor a signal representing the estimated loudspeaker power consumption; receives at the compressor a signal representing the nominal power of the loudspeaker; receives at the compressor an input audio signal from the signal source and supplying with the compressor an output audio signal to the loudspeaker; estimates from the output audio signal, (a) signal(s) that represent(s) the voltage and/or current supplied to the loudspeaker and a parameter that represents the ohmic resistance of the loudspeaker the power consumed by the loudspeaker; supplies a signal representing the estimated loudspeaker power consumption to the compressor; and attenuates the input audio signal when the signal representing the estimated loudspeaker power consumption exceeds the signal representing the nominal power of the loudspeaker.