Abstract: Systems, methods and articles of manufacture for accelerating database queries containing bitmap-based conditions are described herein. An embodiment includes determining a bitmap, where the bitmap represents a set of rows that have satisfied one or more conjunctive conditions which preceded a conjunct that is a disjunction in a query expression and restricting evaluation of a disjunct within the disjunction to the set of rows represented by the bitmap. Another embodiment includes determining a satisfaction bitmap, where the bitmap represents the result of one or more preceding disjuncts in a disjunction within a query expression and restricting scope of evaluation of a disjunct to a set of rows that are not within the determined satisfaction bitmap. In this way, embodiments of the present invention enable the acceleration of queries containing disjunctions of conditions on a database table, as well as reduce the temporary resources consumed for such queries.

Abstract: A system, method, and computer program product for processing a database query are presented. Steps for identifying a table needed to resolve the query, creating an enumeration value, determining whether the enumeration value is semantically equivalent to data from a data field in the table, and using a temporary data structure to evaluate the query are disclosed.

Abstract: A device for introducing continuous fiber into a product material is provided. The continuous fiber is provided from at least one continuous fiber supply. The device comprises a housing having a first opening and a second opening. A channel is formed through the housing from the first opening to the second opening. At least one fin member extends from the housing into the channel with the at least one fin member having a conduit formed therethrough. Upon the product material travelling through the channel of the housing, the continuous fiber travels from the continuous fiber supply, through the conduit, and into the product material. The continuous fiber increases strength and stiffness of the product material while decreasing time-dependent creep deformation of the product material.

Abstract: A method, computer program product, and system are provided for accelerating a query in a database system. For example, an embodiment of the method may include generating a data structure identifying a set of rows that satisfy conditions local to a table prior to an evaluation of a query and modifying the query based on the data structure. In addition, the method may include repeating the steps with respect to generating the data structure and modifying the query, if one or more additional local conditions are inferred from modifying the query based on the data structure.

Abstract: A system, method, and computer program product are provided for sorting a set of records in a sort run. As the records are sorted, metadata regarding the sort run is gathered, and subsequently used to determine bounds of two or more disjoint subsets of the sort run. This enables the parallelization of several tasks over the sort run data using efficient, dynamic bounds determination, such as the outputting of sorted data from the disjoint subsets in parallel.

Abstract: A system, method, and computer program product for processing a database query are presented. Steps for creating a secondary enumeration when necessary and utilizing the secondary enumeration to improve query operations by processing enumeration values of the secondary enumeration instead of data represented by the enumeration values are disclosed.

Abstract: Systems, methods and articles of manufacture for accelerating database queries containing bitmap-based conditions are described herein. An embodiment includes determining a bitmap, where the bitmap represents a set of rows that have satisfied one or more conjunctive conditions which preceded a conjunct that is a disjunction in a query expression and restricting evaluation of a disjunct within the disjunction to the set of rows represented by the bitmap. Another embodiment includes determining a satisfaction bitmap, where the bitmap represents the result of one or more preceding disjuncts in a disjunction within a query expression and restricting scope of evaluation of a disjunct to a set of rows that are not within the determined satisfaction bitmap. In this way, embodiments of the present invention enable the acceleration of queries containing disjunctions of conditions on a database table, as well as reduce the temporary resources consumed for such queries.

Abstract: A system, method, and computer program product are provided for sorting a set of records in a sort run. As the records are sorted, metadata regarding the sort run is gathered, and subsequently used to determine bounds of two or more disjoint subsets of the sort run. This enables the parallelization of several tasks over the sort run data using efficient, dynamic bounds determination, such as the outputting of sorted data from the disjoint subsets in parallel.

Abstract: A system, method, and computer program product for processing a database query are presented. Steps for identifying a value expression comprising information needed in order to resolve a query, associating enumerated values with the set of distinct values for the value expression, evaluating the query utilizing the enumerated values, and deleting the association are disclosed.

Abstract: A system, method, and computer program product are provided for optimizing LIKE-condition based queries on a table in a database system.

Abstract: A method, computer program product, and system are provided for accelerating a query in a database system. For example, an embodiment of the method may include generating a data structure identifying a set of rows that satisfy conditions local to a table prior to an evaluation of a query and modifying the query based on the data structure. In addition, the method may include repeating the steps with respect to generating the data structure and modifying the query, if one or more additional local conditions are inferred from modifying the query based on the data structure. With respect to the step of modifying the query based on the data structure, in the case where no rows satisfy the local conditions in the data structure, an always false prefilter condition may be migrated as high as possible within the query. When only one row satisfies the local conditions in the data structure, a column may be replaced by a constant value from within that column in that one row.

Abstract: A system, method, and computer program product for processing a database query are presented. Steps for identifying a value expression comprising information needed in order to resolve a query, associating enumerated values with the set of distinct values for the value expression, evaluating the query utilizing the enumerated values, and deleting the association are disclosed.

Abstract: A system, method, and computer program product for processing a database query are presented. Steps for creating a secondary enumeration when necessary and utilizing the secondary enumeration to improve query operations by processing enumeration values of the secondary enumeration instead of data represented by the enumeration values are disclosed.

Abstract: A system, method, and computer program product for processing a database query are presented. Steps for identifying a table needed to resolve the query, creating an enumeration value, determining whether the enumeration value is semantically equivalent to data from a data field in the table, and using a temporary data structure to evaluate the query are disclosed.

Abstract: The present invention provides an axially-rotated valve which permits increased flow rates and lower pressure drop (characterized by a lower loss coefficient) by using an axial eccentric split venturi with two portions where at least one portion is rotatable with respect to the other portion. The axially-rotated valve typically may be designed to avoid flow separation and/or cavitation at full flow under a variety of conditions. Similarly, the valve is designed, in some embodiments, to produce streamlined flow within the valve. A typical cross section of the eccentric split venturi may be non-axisymmetric such as a semicircular cross section which may assist in both throttling capabilities and in maximum flow capacity using the design of the present invention. Such a design can include applications for freeze resistant axially-rotated valves and may be fully-opened and fully-closed in one-half of a complete rotation.

Abstract: An axially-rotated valve permitting increased flow rates and lower pressure drop is disclosed using an axial eccentric split venturi with two portions where at least one portion is rotatable with respect to the other portion. A cross section of the eccentric split venturi may be non-axisymmetric such as a semicircular cross section which may assist in both throttling capabilities and in maximum flow capacity. Applications are disclosed for freeze resistant axially-rotated valves which may be fully-opened and fully-closed in one-half of a complete rotation. An internal wide radius elbow connected to a rotatable portion of the eccentric venturi may assist in directing flow with lower friction losses. A valve actuator may actuate in an axial manner located outside of the axial flow path. A seat may be used between the two portions that may include a peripheral and diametrical seal in the same plane.

Abstract: The present invention provides an axially-rotated valve which permits increased flow rates and lower pressure drop (characterized by a lower loss coefficient) by using an axial eccentric split venturi with two portions where at least one portion is rotatable with respect to the other portion. The axially-rotated valve typically may be designed to avoid flow separation and/or cavitation at full flow under a variety of conditions. Similarly, the valve is designed, in some embodiments, to produce streamlined flow within the valve. A typical cross section of the eccentric split venturi may be non-axisymmetric such as a semicircular cross section which may assist in both throttling capabilities and in maximum flow capacity using the design of the present invention. Such a design can include applications for freeze resistant axially-rotated valves and may be fully-opened and fully-closed in one-half of a complete rotation.

Abstract: An emergency system for improving the traction of a tire with the tire having an outer circumferential tread surface and an inner circumferential edge. The emergency system has at least one tire traction device having a substantially C-shaped cross-sectional configuration with at least a portion of the tire traction device positionable about at least a portion of the tread of the tire. A tensioning strap is positioned between the tire traction devices. An adjustable connecting strap is secured to each tire traction device and the tensioning strap wherein upon a tightening adjustment of each adjustable connecting strap, each tire traction device is releasably secured about at least a portion of the tread surface of the tire.

Abstract: The present invention provides an axially-rotated valve which permits increased flow rates and lower pressure drop (characterized by a lower loss coefficient) by using an axial eccentric split venturi with two portions where at least one portion is rotatable with respect to the other portion. The axially-rotated valve typically may be designed to avoid flow separation and/or cavitation at full flow under a variety of conditions. Similarly, the valve is designed, in some embodiments, to produce streamlined flow within the valve. A typical cross section of the eccentric split venturi may be nonaxisymmetric such as a semicircular cross section which may assist in both throttling capabilities and in maximum flow capacity using the design of the present invention. Such a design can include applications for freeze resistant axially-rotated valves and may be fully-opened and fully-closed in one-half of a complete rotation.

Abstract: The present invention provides an axially-rotated valve which permits increased flow rates and lower pressure drop (characterized by a lower loss coefficient) by using an axial eccentric split venturi with two portions where at least one portion is rotatable with respect to the other portion. The axially-rotated valve typically may be designed to avoid flow separation and/or cavitation at full flow under a variety of conditions. Similarly, the valve is designed, in some embodiments, to produce streamlined flow within the valve. A typical cross section of the eccentric split venturi may be non-axisymmetric such as a semicircular cross section which may assist in both throttling capabilities and in maximum flow capacity using the design of the present invention. Such a design can include applications for freeze resistant axially-rotated valves and may be fully-opened and fully-closed in one-half of a complete rotation.