Abstract: Various approaches for accelerating data access to a computer memory and predicate evaluation includes storing, in the computer memory, (i) base data as multiple base columns, (ii) multiple sketched columns each corresponding to a base column in the base data and having smaller code values compared thereto, and (iii) a compression map for mapping one or more base columns to the corresponding sketched column; applying the compression map to a query having a predicate; determining data on the sketched column that satisfies the predicate; and evaluating the predicate based at least in part on the determined data on the sketched column without accessing the base column in the base data.

Abstract: Various approaches for accelerating data access to a computer memory and predicate evaluation includes storing, in the computer memory, (i) base data as multiple base columns, (ii) multiple sketched columns each corresponding to a base column in the base data and having smaller code values compared thereto, and (iii) a compression map for mapping one or more base columns to the corresponding sketched column; applying the compression map to a query having a predicate; determining data on the sketched column that satisfies the predicate; and evaluating the predicate based at least in part on the determined data on the sketched column without accessing the base column in the base data.

Abstract: Various approaches for determining the operation cost of a computational workload that is executed on a computational apparatus and accesses data stored in a data structure include decomposing the data structure into multiple data layout primitives, each data layout primitive corresponding to a smallest, fundamental layout aspect of the data structure; decomposing the computational workload into multiple data access primitives, each data access primitive corresponding to a computational mechanism for accessing the data stored in the data structure; determining a hardware profile associated with the apparatus; and computing the operation cost of the computational workload on the apparatus based at least in part on the data layout primitives, the data access primitives, and the hardware profile.

Abstract: A display and storage case is disclosed. The display and storage case can include a structure having a front, back, top, bottom, left and right sides. Formed into a front side of the structure are a number of cavities of varying size and shape. The display and storage case may be used to store or display bottles or other products in a horizontal or vertical manner.

Abstract: A method for determining the concentration of hydrogen ion, organic anionic species and anionic species selected from the group consisting of OH−, CO3═, HS−, ClO3−, SO4═, S2O3═, polysulfide and peroxide in an aqueous sample solution, said method comprising subjecting said solution to near infrared radiation at a wavelength region of wave numbers selected from about 7,000 to 14,000 cm−1 through a solution path length of at least 3 mm to obtain spectral data for said solution; obtaining comparative spectral data for said anionic species at known concentrations in aqueous solutions; and correlating by multivariate calibration the relationships between said spectral data of said sample solution and said comparative spectral data to determine said concentration of said anionic species in said sample solution.

Abstract: A method for determining the concentration of hydrogen ion, organic anionic species and anionic species selected from the group consisting of OH−, CO3═, HS−, ClO3−, SO4═, S2O3═, polysulphide and peroxide in an aqueous sample solution, said method comprising subjecting said solution to near infrared radiation at a wavelength region of wave numbers selected from about 7,000 to 14,000 cm−1 through a solution path length of at least 3 mm to obtain spectral data for said solution; obtaining comparative spectral data for said anionic species at known concentrations in aqueous solutions; and correlating by multivariate calibration the relationships between said spectral data of said sample solution and said comparative spectral data to determine said concentration of said anionic species in said sample solution.