Abstract: A system includes reception of a first query at a first host, determination, at the first host, that the first query is associated with a first table, the first table including geographically-restricted data and a partitioning column storing identifiers of geographic restrictions, determination, at the first host and based on the partitioning column of the first table and on the first query, a first partition of the first table and a storage location of the first partition, and execution of the first query at the first host in conjunction with the storage location of the first partition.

Abstract: Persisting data in logical tiers of an in-memory database based on aging rules of the database system. The database system can be configured to age data by moving the data from a first logical tier supporting high performance data access to a second logical tier supporting lower performance data access, thereby improving the operational efficiency of the database system.

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 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 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 determination of a value identifier for each value of a first table, based on a data dictionary of a second table, generation of a hash function, the hash function mapping, for each row of the first table, one or more value identifiers of one or more columns of the row to a pointer to the row, application of the hash function to one or more value identifiers of a row of a second table, determination of whether the output of the hash function is a valid hash, and, if it is determined that the output of the hash function is a valid hash, determination that the row of the second table is associated with the first table.

Abstract: A fluid conducting system with cathodic corrosion protection is provided for at least one device that influences and/or acts upon a flow rate, such as a pump and/or valve. The device includes at least one connection device such as a device connection flange. At least one flow rate guiding device such as a pipe includes a connection means such as a pipe connection flange. The system includes annular anodes arranged between the connection devices and connection means, where anodes are electrically connected by electrical conducting lines to a monitoring device. The internal diameter of the anodes is preferably equal to the internal diameter of the flow rate guiding device and/or the inner diameter of the inlet and/or outlet of flow influencing device.

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 system includes determination of a value identifier for each value of a first table, based on a data dictionary of a second table, generation of a hash function, the hash function mapping, for each row of the first table, one or more value identifiers of one or more columns of the row to a pointer to the row, application of the hash function to one or more value identifiers of a row of a second table, determination of whether the output of the hash function is a valid hash, and, if it is determined that the output of the hash function is a valid hash, determination that the row of the second table is associated with the first table.

Abstract: A system includes determination of a value identifier for each value of a first table, based on a data dictionary of a second table, generation of a hash function, the hash function mapping, for each row of the first table, one or more value identifiers of one or more columns of the row to a pointer to the row, application of the hash function to one or more value identifiers of a row of a second table, determination of whether the output of the hash function is a valid hash, and, if it is determined that the output of the hash function is a valid hash, determination that the row of the second table is associated with the first table.

Abstract: Disclosed are an open-porous metal foam and a method for manufacturing the same. An open-porous metal foam according to an exemplary embodiment of the present invention is made of an iron-based alloy including 15 wt % or more of chrome and 5 wt % or more of aluminum. The open-porous metal foam is a semi-product that is formed of iron or the iron-based alloy that does not include chrome and aluminum or includes a smaller amount of chrome and aluminum in the powder when manufacturing, and the surface and the open pore thereof are uniformly coated with the powder of the iron-chrome-aluminum alloy and the organic binding agent. When heat treatment is performed under a reduction atmosphere, sintering is performed.

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: 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 method and system to generate cardinality estimates for at least one query execution plan for a query using a histogram, the cardinality estimation being constrained by a q-error that is a factor by which the estimate deviates, at most, from a true value of the cardinality and a threshold value which the cardinality does not exceed; use the cardinality estimation to determine an optimal query plan for executing the query; and produce an output of the optimal query plan.

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: A system includes determination of a value identifier for each value of a first table, based on a data dictionary of a second table, generation of a hash function, the hash function mapping, for each row of the first table, one or more value identifiers of one or more columns of the row to a pointer to the row, application of the hash function to one or more value identifiers of a row of a second table, determination of whether the output of the hash function is a valid hash, and, if it is determined that the output of the hash function is a valid hash, determination that the row of the second table is associated with the first table.

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 method and system to generate cardinality estimates for at least one query execution plan for a query using a histogram, the cardinality estimation being constrained by a q-error that is a factor by which the estimate deviates, at most, from a true value of the cardinality and a threshold value which the cardinality does not exceed; use the cardinality estimation to determine an optimal query plan for executing the query; and produce an output of the optimal query plan.

Abstract: A centrifugal pump including a rotor and a housing surrounding the rotor, the housing having a connection on the pressure side and another on the intake side, respectively. The housing surrounding the rotor is constructed as a composite part in which a first thin-walled layer (5) defines the inner configuration of the housing, and at least one second layer (11) provides structural stability to the housing.

Abstract: The invention relates to a method for fabricating an open-porous metal foam body with a nickel base alloy, to a metal foam body fabricated this way as well as advantageous applications for the separation of specific components and pollutants from fluid flows. On the occasion, according to the set object open-porous metal foam bodies which have improved mechanical properties, and in addition an enlarged specific surface and/or increased surface roughness are to be provided. During fabricating it is proceeded such that an open-porous base foam body made of nickel or a nickel base alloy is coated with a liquid binding agent. Subsequent to this, a mixture of a powdery nickel base alloy and an organic component the temperature of phase transformation of which is at least 30 degrees centigrade from its solid phase to the liquid phase is deposited. The temperature should then be below the respective temperature of phase transformation.