Abstract: Systems and methods are provided for performing a query in a distributed system. In one example, a query generation system receives an identification of data item components and associations between the data item components, wherein the data item components include a measure and a category, and wherein the identified association indicates that the measure is independent of another data item component, indicates that the measure is dependent on another data item component, or indicates that two or more data item components are correlated.

Abstract: Systems and methods are provided for performing a query in a distributed system. In one example, a query generation system receives an identification of data item components and associations between the data item components, wherein the data item components include a measure and a category, and wherein the identified association indicates that the measure is independent of another data item component, indicates that the measure is dependent on another data item component, or indicates that two or more data item components are correlated.

Abstract: Systems and methods are provided for performing a database query. After receiving an identification of data item components and associations between the data item components, wherein the data item components include a measure and a category, a query generation system creates and executes a database query that comprises one or more Uqueries, wherein each Uquery comprises a Mx segment subquery and a U0 segment subquery. The Mx segment subquery is associated with a table that contains the measure, a table that contains columns for a calculated measure, or a correlated table, and the U0 segment subquery is associated with a table that contains the category, a table that contains columns for a calculated category, a dependent measure table, or a dependent filter table. The query generation system can generate a virtual results table by aggregating Uquery results from one Uquery with Uquery results from another Uquery.

Abstract: Systems and methods are provided for performing a database query. After receiving an identification of data item components and associations between the data item components, wherein the data item components include a measure and a category, a query generation system creates and executes a database query that comprises one or more Uqueries, wherein each Uquery comprises a Mx segment subquery and a U0 segment subquery. The Mx segment subquery is associated with a table that contains the measure, a table that contains columns for a calculated measure, or a correlated table, and the U0 segment subquery is associated with a table that contains the category, a table that contains columns for a calculated category, a dependent measure table, or a dependent filter table. The query generation system can generate a virtual results table by aggregating Uquery results from one Uquery with Uquery results from another Uquery.

Abstract: The present invention is directed to the creation and delivery of foam to displace the vapor space of an enclosed structure of residual material suspended in the vapor space to the outside. The foam accumulates in the enclosed structure to urge the residual material suspended in the vapor space to exit the enclosed structure via an exhaust duct.

Abstract: A camera focus adjustment mechanism characterized by a base assembly, a clamping assembly, and a screw mechanism coupling the base assembly to the clamping assembly. The clamping assembly includes a carriage plate and a clamping plate, where the carriage plate is coupled to the screw mechanism and the clamping plate is adjustably coupled to the carriage plate. The clamping plate firmly clamps around the barrel of a camera lens assembly, and is adjustable relative to the carriage plate in a direction substantially perpendicular to the focusing axis of the camera lens assembly. The focus of the camera lens assembly is adjusted by rotating the screw mechanism to cause the clamping assembly (and therefore the barrel of the camera lens assembly) to move in a direction parallel to the focusing axis.