Abstract: An optimization technique involves optimizing a SQL query, in which the SQL query includes a large IN-List query to access data in a table. The technique includes determining whether an IN-List exceeds a predetermined size, and, if so, removing the IN-List query statement and inserting a new query statement including a join operation.

Abstract: A database query is optimized for a star database schema that includes at least one fact table and at least one dimension table, where the database query includes an IN-List condition. During optimization, the IN-List is transformed into a relation and the relation is joined with the dimension table to produce a join result. The join result is then joined to the fact table.

Abstract: A method, database system and computer program are disclosed for optimizing a SQL query, in which the SQL query includes an IN-List. An evaluation is performed to determine whether the IN-List query can be performed as a join operation. If so, a new access path that converting IN-List to a relation, and subsequently joined with the table to complete the IN-List query is cost and competes with other access paths.

Abstract: A method, database system and computer program are disclosed for optimizing a SQL query, in which the SQL query includes an IN-List. The method includes utilizing an array insert to insert the IN-List into a spool and piggybacking IN-List rows into a join step.

Abstract: A method for stabilizing colloidal suspensions of nanocrystals or nanoparticles in a solvent or solid matrix is provided by coating the nanocrystals with bulky organic molecules, specifically dendrons. By coating nanocrystals with a dense organic dendron coat and further cross-linking the dendron ligands, oxidation of the nanocrystals and dissociation of the ligands are avoided. This invention allows nanocrystals to undergo rigorous purification and processing. It may regularly be applied to a variety of nanocrystals.

Abstract: Dendron ligands or other branched ligands with cross-linkable groups were coordinated to colloidal inorganic nanoparticles, including nanocrystals, and substantially globally cross-linked through different strategies, such as ring-closing metathesis (RCM), dendrimer-bridging methods, and the like. This global cross-linking reaction sealed each nanocrystal within a dendron box to yield box-nanocrystals which showed dramatically enhanced stability against chemical, photochemical and thermal treatments in comparison to the non-cross-linked dendron-nanocrystals. Empty dendron boxes possessing a very narrow size distribution were formed by the dissolution of the inorganic nanocrystals contained therein upon acid or other etching treatments.

Abstract: A method for stabilizing colloidal suspensions of nanocrystals or nanoparticles in a solvent or solid matrix is provided by coating the nanocrystals with bulky organic molecules, specifically dendrons. By coating nanocrystals with a dense organic dendron coat and further cross-linking the dendron ligands, oxidation of the nanocrystals and dissociation of the ligands are avoided. This invention allows nanocrystals to undergo rigorous purification and processing. It may regularly be applied to a variety of nanocrystals.