Synthesis of stable colloidal nanocrystals using organic dendrons
    3.
    发明授权
    Synthesis of stable colloidal nanocrystals using organic dendrons 有权
    使用有机树突的合成稳定的胶体纳米晶体

    公开(公告)号:US07153703B2

    公开(公告)日:2006-12-26

    申请号:US10146420

    申请日:2002-05-13

    IPC分类号: G01N33/551

    摘要: 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.

    摘要翻译: 通过用庞大的有机分子(特别是树突)涂覆纳米晶体,提供了稳定溶剂或固体基质中纳米晶体或纳米颗粒的胶体悬浮液的方法。 通过用致密的有机树突涂层涂覆纳米晶体并进一步交联树枝状配体,避免了纳米晶体的氧化和配体的解离。 本发明允许纳米晶体经过严格的纯化和处理。 它可以经常应用于各种纳米晶体。

    Multistage electromagnetic purification method for molten metal
    5.
    发明授权
    Multistage electromagnetic purification method for molten metal 有权
    熔融金属多级电磁净化方法

    公开(公告)号:US07927398B2

    公开(公告)日:2011-04-19

    申请号:US11996831

    申请日:2005-09-29

    IPC分类号: C22B9/22 C22B9/02

    摘要: A multistage electromagnetic purification method of molten metal, which employs a multistage separator composed of two or more multichannel straight-pass separators bonded together with inorganic high-temperature adhesive. Each stage of the separators is set up in such a manner that the region of centerline of each channel in the former separators is occupied by the sidewall of the next separators at the corresponding position therein; while simultaneously the position in the next separators becomes a region close to sidewall. The multistage separator eliminates the “dead zone” of electromagnetic separation, realizes the transformation from “weak zone” to “strong zone” of electromagnetic separation, and significantly increases removal efficiency of inclusions in the melt with great volume under the effect of induced magnetic field.

    摘要翻译: 一种熔融金属的多级电磁净化方法,其采用由两个或多个多通道直通分离器组成的多级分离器,其与无机高温粘合剂结合在一起。 分离器的每个阶段被设置成使得前隔板中的每个通道的中心线的区域被其中相应位置处的下一个隔板的侧壁占据; 同时在下一个隔板中的位置变成靠近侧壁的区域。 多级分离器消除了电磁分离的“死区”,实现了电磁分离的“弱区”到“强区”的转变,大大提高了熔体内夹杂物在感应磁场作用下的去除效率 。

    Cardinality and selectivity estimation using a single table join index
    6.
    发明授权
    Cardinality and selectivity estimation using a single table join index 有权
    使用单表连接索引的基数和选择性估计

    公开(公告)号:US08914354B2

    公开(公告)日:2014-12-16

    申请号:US12510292

    申请日:2009-07-28

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30498 G06F17/30489

    摘要: A method for estimating the selectivity of a database base table predicate, the cardinality of a join, and the cardinality of an aggregation. The method includes receiving a database query, the query comprising one or more query predicates and referencing one or more database tables. One or more join indexes are identified, the join index(es) defined on respective database tables referenced by the database query. The join index(es) comprises one or more join index predicates, and includes one or more join columns in its select list. The row count selected by the query predicates is calculated at least partly using the row count or statistics of the one or more join indexes. The selectivity of the base table predicate is calculated at least partly from the calculated row count. The cardinality of the join is estimated at least partly from the row count and statistics of the identified join index(es).

    摘要翻译: 用于估计数据库基表谓词的选择性的方法,连接的基数以及聚合的基数。 该方法包括接收数据库查询,该查询包括一个或多个查询谓词并引用一个或多个数据库表。 标识一个或多个连接索引,由数据库查询引用的各个数据库表上定义的连接索引。 连接索引(es)包括一个或多个连接索引谓词,并且在其选择列表中包括一个或多个连接列。 由查询谓词选择的行计数至少部分地使用一个或多个连接索引的行计数或统计信息进行计算。 至少部分地根据计算的行计数计算基表谓词的选择性。 连接的基数估计至少部分来自所识别的连接索引的行数和统计信息。

    TECHNIQUES FOR QUERY STATISTICS INHERITANCE
    7.
    发明申请
    TECHNIQUES FOR QUERY STATISTICS INHERITANCE 有权
    查询统计资料的技术

    公开(公告)号:US20140181075A1

    公开(公告)日:2014-06-26

    申请号:US13722735

    申请日:2012-12-20

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30469

    摘要: Techniques for query statistics inheritance are provided. Statistics for a database are used to determine selectivity estimates for sparse joins and tables being joined together within a given query. These statistics are inherited up to the given query along with the selectivity estimates and provided to a database optimizer to use when developing query plans and selecting an optimal query plan for the given query.

    摘要翻译: 提供查询统计继承技术。 数据库的统计信息用于确定给定查询中连接在一起的稀疏连接和表的选择性估计。 这些统计信息继承到给定的查询以及选择性估计,并提供给数据库优化器,以便在开发查询计划并为给定查询选择最佳查询计划时使用。

    CARDINALITY AND SELECTIVITY ESTIMATION USING A SINGLE TABLE JOIN INDEX
    8.
    发明申请
    CARDINALITY AND SELECTIVITY ESTIMATION USING A SINGLE TABLE JOIN INDEX 有权
    使用单表加入索引的亲和度和选择性估计

    公开(公告)号:US20110029507A1

    公开(公告)日:2011-02-03

    申请号:US12510292

    申请日:2009-07-28

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30498 G06F17/30489

    摘要: A method for estimating the selectivity of a database base table predicate, the cardinality of a join, and the cardinality of an aggregation. The method includes receiving a database query, the query comprising one or more query predicates and referencing one or more database tables. One or more join indexes are identified, the join index(es) defined on respective database tables referenced by the database query. The join index(es) comprises one or more join index predicates, and includes one or more join columns in its select list. The row count selected by the query predicates is calculated at least partly using the row count or statistics of the one or more join indexes. The selectivity of the base table predicate is calculated at least partly from the calculated row count. The cardinality of the join is estimated at least partly from the row count and statistics of the identified join index(es).

    摘要翻译: 用于估计数据库基表谓词的选择性的方法,连接的基数以及聚合的基数。 该方法包括接收数据库查询,该查询包括一个或多个查询谓词并引用一个或多个数据库表。 标识一个或多个连接索引,由数据库查询引用的各个数据库表上定义的连接索引。 连接索引(es)包括一个或多个连接索引谓词,并且在其选择列表中包括一个或多个连接列。 由查询谓词选择的行计数至少部分地使用一个或多个连接索引的行计数或统计信息进行计算。 至少部分地根据计算的行计数计算基表谓词的选择性。 连接的基数估计至少部分来自所识别的连接索引的行数和统计信息。

    OPTIMIZING ACCESS TO A DATABASE
    9.
    发明申请
    OPTIMIZING ACCESS TO A DATABASE 有权
    优化访问数据库

    公开(公告)号:US20070073647A1

    公开(公告)日:2007-03-29

    申请号:US11535632

    申请日:2006-09-27

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30442

    摘要: 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.

    摘要翻译: 公开了一种用于优化SQL查询的方法,数据库系统和计算机程序,其中SQL查询包括IN列表。 执行评估以确定IN-List查询是否可以作为连接操作执行。 如果是这样,将IN-List转换为关系并随后与表结合以完成IN-List查询的新的访问路径是成本并与其他访问路径竞争。