Abstract: A method, medium, and system to generate cardinality estimates for at least one query execution plan for a query by representing a given set of multidimensional data including a plurality of data points having a value by a hierarchical tree data structure including nodes, each node representing a distribution of a subset of the points in the data set and being partitioned into tiles; calculating a bounding rectangle of the data points in each node; entering all non-empty tiles into a queue; processing of the queue can continue until a computational memory space limit is reached or until a desired estimation resolution is met; and encoding the resulting tree structure.

Abstract: A pump housing made of plastic sections is provided. The housing includes a first casing that has a first side facing the region in which a pumped medium will flow, and a second casing that has a second side facing the environment. The pump housing's first casing and second casing are both dimensionally stable, with a space between the first casing and the second casing. A filler material such as a self-expanding foam may be provided in the space. The pump casings may be standardized components, and multiple casings may be assembled to form pump housings to suit a particular application.

Abstract: A flow-conducting component such as a pump impeller is provided. Passages between vanes of the flow-conducting component include notches in the form of transitions between the vane and a common surface, such as a cover disk. The notches include a transition surface having a geometric configuration determined in accordance with a calculated load spectrum along at least a portion of the length of the notch and in accordance with a particular geometric pattern.

Abstract: A system for analyzing and sorting of petri dishes comprising an analysis tool, a control unit, a first elevator movable along a first elevator axis, a conveyor with a conveyor plane, and at least one carrier built to carry the petri dishes along a carrier axis. The analysis tool is built to assign information to the petri dish, and in case of a first information assigned to the petri dish the control unit is built to move the first elevator into a carrier position, wherein, as soon as the first elevator reaches the carrier position, the control unit is built to move a substantially flat first plate along the first elevator axis from a first neutral position located in the conveyor plane into a first transfer position.

Abstract: A sealing arrangement for a centrifugal pump is provided. The sealing arrangement permits a sealing gap between a rotating element such as a pump impeller and a non-rotating element such as a pump casing to be minimized, while protecting against element wear from gap reduction and element contact, particularly during transient operation such as pump start up. At least one of the rotating element and the non-rotating element is provided with a plurality of movably mounted bodies configured to rotate and maintain separate the rotating and non-rotating elements when the sealing gap is reduced. The elements and the bodies may be formed in an additive manufacturing process.

Abstract: A method may include receiving a query for data to be provided by a database server, wherein the query includes an indication of a maximum lag. The method may further include determining whether a hint is available to apply to the query, wherein the hint affects an execution of the query. When no hint is available, a baseline database server may be selected to be the database server. When the hint is available, a replication server or a cache server may be selected to be the database server based on the hint and the maximum lag. The query may be processed at the selected database server.

Abstract: A system includes generation of a query to retrieve, from a first database table, a result set conforming to query parameters for all entries of a second table stored in a volatile memory of a query client, serialization of the second table into the volatile memory, copying of the serialized second table into a second volatile memory of a data server, de-serialization of the serialized second table into the second volatile memory, determination of a plurality of entries of the first database table which are associated with the second table, and determination of the result set from the plurality of entries based on the query parameters.

Abstract: An earth-boring tool comprises a body having a face at a leading end thereof, blades extending from the body and comprising primary blades and secondary blades, and cutting elements on the blades and arranged in groups each comprising neighboring cutting elements. Some of the groups are disposed only on the primary blades in a first spiral configuration. Others of the groups disposed only on the secondary blades in a second, opposing spiral configuration. Methods of forming an earth-boring tool, and methods of forming a borehole in a subterranean formation are also described.

Abstract: A method for producing components from a duplex steel, and a component formed by the method, are provided. A powder-type duplex steel starting material including an austenitic phase and a ferritic phase is laser melted in successive layers to form a component. The melted and re-solidified component is then subjected to heat treatment to obtain solution annealing of the austenitic phase at a temperature range of between 850° C. and 1,100° C. for a predetermined dwell time, after which the component is cooled and the component has a grain size and grain size number G of at least 9 according to ASTM. The grain size and the grain size number G of the austenitic phase are influenced by the selection of the respective maximum temperature and/or the dwell time of the maximum temperature.

Abstract: A method produces a multilayer element with a substrate and at least one conductor structure connected in an areal manner to the substrate, which has first regions of electrically conductive material, which is present in accordance with a prescribed pattern, while electrically non-conductive second regions lie between the first regions.

Abstract: A system for cardinality estimation for database query planning is provided. In some implementations, the system performs operations comprising determining, based on a first bounds and a second bounds for a combination of query predicates, whether a solution for the combination of the query predicates exists which includes both the first and second bounds. When the solution is determined to exist, the operations can further comprise determining at least one selectivity estimate for the combination of the query predicates. A query plan for execution of a database query comprising the query predicates can be generated based on the at least one selectivity estimate, and the database query can be executed through execution of the query plan. Related systems, methods, and articles of manufacture are also described.

Abstract: A system for cardinality estimation for database query planning is provided. In some implementations, the system performs operations comprising selecting a subset of data from a set of data on which a database query is to be executed, the set of data including a first quantity of tuples and the subset of data including a second quantity of tuples. The operations can further comprise determining, based on evaluating one or more predicates on the subset, a third quantity of tuples in the subset which satisfy the one or more predicates. The operations can further comprise determining, based on the first quantity, the second quantity, and the third quantity, a range within the subset that comprises estimated cardinalities of the one or more predicates within a predetermined error threshold range. Related systems, methods, and articles of manufacture are also described.

Abstract: Disclosed herein are system, method, and computer program product embodiments for determining a constraint data statistics object is consistent. An embodiment operates by receiving a query for a database table. The embodiment determines a constraint data statistic object associated with a partition of the database table. The embodiment determines the constraint data statistics object is consistent with a data state of the partition of the database table based on consistency metadata of the constraint data statistics object. The embodiment processes the query for the database table based on the determining the constraint data statistics object is consistent with the data state of the partition of the database table.

Abstract: The present disclosure involves systems, software, and computer implemented methods for using declarative rules for optimized access to data. One example method includes receiving a structured query language (SQL) query, the SQL query associated with at least one database table and at least one predicate. A determination is made as to whether the SQL query is associated with at least one declarative rule based on the at least one database table and the at least one predicate. In response to determining that the SQL query is associated with at least one declarative rule, the at least one associated declarative rule is applied, during optimization of the SQL query. The at least one declarative rule defines a transformation to the SQL query to be performed during query optimization. An updated SQL query is generated based on the applied at least one associated declarative rule and the updated SQL query is provided.

Abstract: A system includes a non-volatile random access memory storing a column store main fragment of a column of a database table, and a processing unit to read the column store main fragment from the non-volatile random access memory. A volatile random access memory storing a column store delta fragment of the column of the database table may also be included, in which the processing unit is to write to the column store delta fragment. According to some systems, the stored column store main fragment is byte-addressable, and is copied from the volatile random access memory to the non-volatile random access memory without using a filesystem cache.

Abstract: Embodiments relate to view caching techniques that cache for a limited time, some of the (intermediate) results of a previous query execution, in order to avoid expensive re-computation of query results. Particular embodiments may utilize a cache manager to determine whether information relevant to a subsequent user request can be satisfied by an existing cache instance or view, or whether creation of an additional cache instance is appropriate. At design time, cache defining columns of a view are defined, with user input parameters automatically being cache defining. Cache instances are created for each tuple of literals for the cache defining columns, and for each explicit or implicit group by clause. Certain embodiments may feature enhanced reuse between cache instances, in order to limit memory footprint. Over time a cache instances may be evicted from memory based upon implementation of a policy such as a Least Recently Used (LRU) strategy.

Abstract: A flow-conducting component having at least one functional region for contact with a flowing medium and at least one functional region having supporting characteristics is provided. The two functional regions are produced from a material by successively solidifying layers using radiation in a manner that provides different material characteristics in the different functional regions.