Abstract: A system, method, and non-transitory computer readable medium are disclosed herein to optimize nested queries. At least one field is associated with each row of data evaluated by at least one nested query. A value is assigned to the at least one field so as to indicate whether each row of data satisfies the at least one nested query. The at least one field associated with each row of data is evaluated to determine satisfaction of the at least one nested query.

Abstract: A record-pattern expression of a record pattern of data records is translated to a character-pattern expression of a character pattern. A data-record series of data records is converted to a character string in which each character in the character string corresponds to a respective data record in the data-record series. Pattern instances of the character pattern in the character string are searched to identify ordinal character positions in the character string of characters in the character pattern instances. Data records at ordinal record positions in the record series of data records corresponding to the ordinal character positions are reported.

Abstract: A system is described herein comprising a diverter valve operable to divert at least a portion of water flowing through a first water line to a first volume; a first float valve controlling water flow from a second water line to a second volume; and a second float valve controlling water flow from the first volume to the second volume.

Abstract: A query that is submitted to a database is analyzed so as to determine a join order restriction. The join order restriction is associated with a join between two tables of a plurality of tables of the database that participate in the query. The join order restriction constrains its associated join to be executed prior to another join of the query. At least one join plan is generated, the join plan being constrained by the join order restriction. Different join plans include different join orders. A join plan is selected from among the join plans for execution of the query.

Abstract: A method of analyzing an expression to infer output data properties, comprises storing, in a storage device, a root node “e” in R, in which “e” is an expression and R is a root node of an abstract syntax tree (AST) of the expression “e”, storing a number of child nodes of R into C1, . . . Cn, with a processor coupled to the storage device, calling analyze(Ci), storing output properties of expression C into Pi I, and determining if any of the child nodes Ci in {C1 . . . Cn} has not been analyzed, in which if the last child node has been analyzed, with the processor, calling compute-output-properties(R, P1, . . . Pn), storing, in the storage device, the result in Poutput, and returning Poutput as the output properties of the expression “e.

Abstract: A truck has an occupant compartment (24), an engine compartment (20) forward of the occupant compartment, and a wiring harness (34) extending through a dash panel (26) separating the two compartments from each other. A grommet (46) is secured at a fixed location on a wire bundle (42) that passes through the grommet. The dash has a through-opening in which the grommet seats, and the engine compartment side of the grommet comprises a bend (48) that curves generally downward and away from the dash to direct the bundle generally downward on the engine compartment side.

Abstract: A wiring harness grommet (46) composed of first and second grommet halves (54, 56) cooperatively forming a walled through-passage (48) for a wire bundle of a wiring harness. Respective walled cavity halves (58, 60) are telescopically fit together for capturing the wire bundle between respective mutually confronting throats in the cavity halves. An annular void circumferentially surrounds the bundle and is filled with a filler (S) after the two halves have been fit together onto the bundle.

Abstract: A truck has an occupant compartment (24), an engine compartment (20) forward of the occupant compartment, and a wiring harness (34) extending through a dash panel (26) separating the two compartments from each other. A grommet (46) is secured at a fixed location on a wire bundle (42) that passes through the grommet. The dash has a through-opening in which the grommet seats, and the engine compartment side of the grommet comprises a bend (48) that curves generally downward and away from the dash to direct the bundle generally downward on the engine compartment side.

Abstract: Timber harvesting apparatus and methods for use in swampland utilizing an amphibious feller-buncher, an amphibious de-limber, an amphibious log carrier, and an amphibious service vehicle.

Abstract: This invention relates to a vaccine for canine heartworm. The invention further relates to a diagnostic test capable of discerning the presence of the canine heartworm parasite even in occult infections. The invention discloses kits and test strips suitable for diagnosing canine heartworm infections.