Abstract: In some aspects, a method, computer program product, and system are provided for query optimization. In some implementations, there may be provided a method including detecting a select query as a candidate for optimization, the select query including an order by, an offset value, and a limit value; determining, in response to the detecting, a modified offset value as the difference between the offset value and a size of a smaller dataset; and performing the select query to form a result set, the select query executed based on at least the modified offset value. Related systems, methods, and articles of manufacture are also described.

Abstract: A system for query planning and execution with source and/or sink operators is provided. In some implementations, the system performs operations comprising identifying a plurality of operators for executing a query, allocating space in memory for storing data when a second operator comprises a collection operator for collecting the data, generating at least a portion of the data based on executing a first operator, and providing the data (e.g., access to the data) to another operator which occurs after the first operator. In some implementations, a query plan for execution of the query can be generated to include the first operator and exclude the collection operator. Related systems, methods, and articles of manufacture are also described.

Abstract: In some aspects, there is provided a method for database query execution planning. In some aspects, a method may include receiving, at a database execution engine, a query; generating, by the database execution engine, a query algebra for the query, the query algebra optimized by a query optimizer at the database execution engine; generating, based on the optimized query algebra, a query plan for execution, the query plan including pre-compiled code and code generated just-in-time; and executing, by the database execution engine, at least part of the query plan including pre-compiled code and code generated just-in-time. Related systems, methods, and articles of manufacture are also described.

Abstract: A system for query execution and planning with pipelining and shared states for query operators is provided. In some implementations, the system performs operations comprising identifying a plurality of operators for executing a query and generating an indication that a first operator and a second operator share information when the first operator and the second operator require the same data which is not present when the query is received. The operations can further include executing the first operator to generate at least a portion of the data, storing the data in a location based upon the indication, and providing, based upon the indication, the stored data for the second operator. Related systems, methods, and articles of manufacture are also described.

Abstract: A system for query execution and planning with pipelining and pump operators is provided. In some implementations, the system performs operations comprising identifying a plurality of operators for executing a query, the plurality of operators including a first operator and a second operator, generating a pump operator when the first operator comprises a table scan operator, and/or generating a query plan for execution of the query, the query plan comprising the pump operator and the second operator. The operations can further include executing the pump operator to at least retrieve a portion of a database table, generate a first data portion based on the portion of the database table, and provide the first data portion for the second operator. Related systems, methods, and articles of manufacture are also described.

Abstract: The present disclosure provides methods to produce ketones suitable for use as fuels and lubricants by catalytic conversion of an acetone-butanol-ethanol (ABE) fermentation product mixture that can be derived from biomass.

Abstract: The invention is directed to a process for preparing a juice product from a raw juice feed comprising microorganisms by subjecting the raw juice feed to microfiltration to obtain the juice product and a retentate juice product, wherein the microfiltration is performed as a cross-flow filtration over a sieve, which sieve has openings that are smaller than the dimensions of the microorganisms present in the raw juice feed and wherein over the sieve a high frequency back pulsing is applied.

Abstract: The present invention relates to novel strigolactam derivatives, to processes and intermediates for preparing them, to plant growth regulator compositions comprising them and to methods of using them for controlling the growth of plants and/or promoting the germination of seeds.

Abstract: Fresh food produce wrapped in a film, characterized in that the film has a moisture vapour transmission rate (MVTR according to ISO 12572:2001, condition B at 1 bar, 38° C.

Abstract: Lacrimal inserts such as punctal plugs may be utilized for delivery of medication to the eye. The plug includes a body portion sized to pass through a lacrimal punctum and be positioned within a lacrimal canaliculus of the eyelid. The plug may contain a core, or reservoir, at least partially within the body portion comprising a therapeutic agent that is configured for controlled, pulsatile release into the eye.

Abstract: A fluid handling structure for a lithographic apparatus, the fluid handling structure having, at a boundary from a space configured to contain immersion fluid to a region external to the fluid handling structure: a meniscus pinning feature to resist passage of immersion fluid in a radially outward direction from the space; a gas supply opening radially outward of the meniscus pinning feature; and a gas recovery opening radially outward of the meniscus pinning feature and at least partly surrounding the gas supply opening.

Abstract: Polymeric foam, characterized in that the polymeric foam is produced from a polymer composition comprising a polyester containing monomeric units of a dimerised fatty acid and/or a derivative thereof and further monomer units of at least one dicarboxylic acid and at least one diol, which polymer composition is uncrosslinked.

Abstract: The present invention relates to novel strigolactam derivatives, to processes and intermediates for preparing them, to plant growth regulator compositions comprising them and to methods of using them for controlling the growth of plants and/or promoting the germination of seeds.

Abstract: The present invention relates to novel strigolactam derivatives of formula (I), to processes and intermediates for preparing them, to plant growth regulator compositions comprising them and to methods of using them for controlling the growth of plants and/or promoting the germination of seeds.

Abstract: The invention is directed to a process for preparing a milk product from a raw milk feed comprising microorganisms as obtained by milking a milk delivering animal by separating the microorganism from the raw milk by means of microfiltration. A milk product poor in microorganisms and a retentate milk product enriched in microorganism relative to the raw milk is obtained. The microfiltration is performed as a cross-flow filtration over a sieve, which sieve comprises of a coated silicon cross-flow surface plate with openings that are smaller than the dimensions of the microorganisms present in the raw milk feed and wherein over the sieve a high frequency back pulsing is applied. Microfiltration is performed within 8 hours from obtaining the raw milk feed by milking.

Abstract: Film containing at least a first layer comprising a copolymer containing monomer units of a dimerised fatty acid or a derivative thereof, wherein the first layer has a thickness of at least 75 ?m and the first layer has a haze as measured by ASTM D1003-11 Procedure A of at most 30%. The film can be used for decorative packaging, deep drawn packaging or decorative films.

Abstract: Polymer composition containing a thermoplastic polyester elastomer, which contains hard segments of a polyester and soft segments, that contain monomer units of a dimerized fatty acid and/or a derivative thereof, which polymer composition contains at least 0.1 wt % of a UV-absorber.

Abstract: Cooking bag containing a copolymer containing monomer units of a dimerised fatty acid or a derivative thereof. Use the cooking bag for cooking food. A process for storing and cooking of food comprising the steps: a) filling the cooking with food, b) storing the filled cooking bag at a temperature below 0° C., c) cooking the food.

Abstract: A fluid handling structure for a lithographic apparatus, the fluid handling structure having, at a boundary from a space configured to contain immersion fluid to a region external to the fluid handling structure: a meniscus pinning feature to resist passage of immersion fluid in a radially outward direction from the space; a gas supply opening radially outward of the meniscus pinning feature; and a gas recovery opening radially outward of the meniscus pinning feature and at least partly surrounding the gas supply opening.

Abstract: The invention relates to a process for preparing PCL-comprising microparticles, to microparticles obtainable by said process, to gel hence obtained and to several uses of the gel such as for the preparation of a medicament for treating a skin abnormality or disfigurement, and/or for controlling bladder function and/or controlling gastric reflux and/or for treating erectile dysfunction and/or for treating vocal cords. The gel may also be used for cosmetic applications.