专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明申请

US20090070315A1 TABLE ELIMINATION OPTIMIZATIONS 有权
标题翻译：表消除优化
公开(公告)号：US20090070315A1
公开(公告)日：2009-03-12
申请号：US11854526
申请日：2007-09-12
申请人： Rafi Ahmed , Thierry Cruanes , Sridhar Sarnobat
发明人： Rafi Ahmed , Thierry Cruanes , Sridhar Sarnobat
IPC分类号： G06F17/30
CPC分类号： G06F17/30492
摘要： Methods for transforming a query to remove redundant tables and eliminate superfluous join operations is provided. The methods provided transform queries to remove redundant tables and anti-joins, semi-joins, and outer-joins. Whether a table is redundant is determined based on a set of criteria which, if fulfilled, indicates that the removal of the table and the anti-join, semi-join, or outer-join operation does not impact query results. The removal of a redundant table from a query also results in the elimination of the anti-join, semi-join, or outer-join operation that references the removed table.
摘要翻译：提供了用于转换查询以去除冗余表并消除多余连接操作的方法。所提供的方法转换查询以删除冗余表和反连接，半连接和外连接。基于一组条件确定表是否冗余是否确定，如果满足，则表示删除表和反连接，半连接或外连接操作不会影响查询结果。从查询中删除冗余表还会导致消除引用已删除表的反连接，半连接或外部连接操作。

2. 发明授权

US08352461B2 Table elimination optimizations 有权
标题翻译：表消除优化
公开(公告)号：US08352461B2
公开(公告)日：2013-01-08
申请号：US11854526
申请日：2007-09-12
申请人： Rafi Ahmed , Thierry Cruanes , Sridhar Sarnobat
发明人： Rafi Ahmed , Thierry Cruanes , Sridhar Sarnobat
IPC分类号： G06F7/00
CPC分类号： G06F17/30492
摘要： Methods for transforming a query to remove redundant tables and eliminate superfluous join operations is provided. The methods provided transform queries to remove redundant tables and anti-joins, semi-joins, and outer-joins. Whether a table is redundant is determined based on a set of criteria which, if fulfilled, indicates that the removal of the table and the anti-join, semi-join, or outer-join operation does not impact query results. The removal of a redundant table from a query also results in the elimination of the anti-join, semi-join, or outer-join operation that references the removed table.
摘要翻译：提供了用于转换查询以去除冗余表并消除多余连接操作的方法。所提供的方法转换查询以删除冗余表和反连接，半连接和外连接。基于一组条件确定表是否冗余是否确定，如果满足，则表示删除表和反连接，半连接或外连接操作不会影响查询结果。从查询中删除冗余表还会导致消除引用已删除表的反连接，半连接或外部连接操作。

3. 发明申请

US20070219969A1 Join factorization of union/union all queries 有权
标题翻译：加入联盟/联盟所有查询的因式分解
公开(公告)号：US20070219969A1
公开(公告)日：2007-09-20
申请号：US11716010
申请日：2007-03-08
申请人： Hong Su , Rafi Ahmed , Allison Lee , Mohamed Zait , Thierry Cruanes
发明人： Hong Su , Rafi Ahmed , Allison Lee , Mohamed Zait , Thierry Cruanes
IPC分类号： G06F17/30
CPC分类号： G06F17/30466 , Y10S707/99932
摘要： Under a type of query transformation referred to herein as join factorization, the branches of an UNION/UNION ALL query that join a common table are combined to reduce accesses to the common table. The transformation can be expressed as (T1 join T2) union all (T1 join T3)=T1 join (T2 union all T3), where T1, T2 and T3 are three tables. A given query may be rewritten in many alternate ways using join factorization. Evaluating each alternative can be expensive. Therefore, the alternatives are generated and evaluated in a way that minimizes the cost of evaluating the alternatives.
摘要翻译：在这里称为连接因式分解的一种类型的查询变换中，加入公共表的UNION / UNION ALL查询的分支被组合以减少对公共表的访问。转换可以表示为（T1连接T2）联合全部（T1连接T3）= T1连接（T2联合全T3），其中T1，T2和T3是三个表。给定的查询可以使用连接因式分解以许多替代方式重写。评估每个替代品可能是昂贵的。因此，以最小化评估替代品的成本的方式生成和评估替代方案。

4. 发明授权

US07644062B2 Join factorization of union/union all queries 有权
标题翻译：加入联盟/联盟所有查询的因式分解
公开(公告)号：US07644062B2
公开(公告)日：2010-01-05
申请号：US11716010
申请日：2007-03-08
申请人： Hong Su , Rafi Ahmed , Allison Lee , Mohamed Zait , Thierry Cruanes
发明人： Hong Su , Rafi Ahmed , Allison Lee , Mohamed Zait , Thierry Cruanes
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30466 , Y10S707/99932
摘要： Under a type of query transformation referred to herein as join factorization, the branches of an UNION/UNION ALL query that join a common table are combined to reduce accesses to the common table. The transformation can be expressed as (T1 join T2) union all (T1 join T3)=T1 join (T2 union all T3), where T1, T2 and T3 are three tables. A given query may be rewritten in many alternate ways using join factorization. Evaluating each alternative can be expensive. Therefore, the alternatives are generated and evaluated in a way that minimizes the cost of evaluating the alternatives.
摘要翻译：在这里称为连接因式分解的一种类型的查询变换中，加入公共表的UNION / UNION ALL查询的分支被组合以减少对公共表的访问。转换可以表示为（T1连接T2）联合全部（T1连接T3）= T1连接（T2联合全T3），其中T1，T2和T3是三个表。给定的查询可以使用连接因式分解以许多替代方式重写。评估每个替代品可能是昂贵的。因此，以最小化评估替代品的成本的方式生成和评估替代方案。

5. 发明申请

US20140046039A1 ANTIBODIES DIRECTED AGAINST INFLUENZA 有权
标题翻译：针对流感病毒的抗体
公开(公告)号：US20140046039A1
公开(公告)日：2014-02-13
申请号：US13978607
申请日：2012-01-10
申请人： Rafi Ahmed , Jens Wrammert , Patrick C. Wilson
发明人： Rafi Ahmed , Jens Wrammert , Patrick C. Wilson
IPC分类号： C07K16/10
CPC分类号： C07K16/1018 , A61K2039/505 , C07K2317/21 , C07K2317/33 , C07K2317/76 , C07K2317/92
摘要： Antibodies or antibody fragments, wherein the antibody or the fragment binds HA domain of influenza virus (e.g. H1N1, H5N1, or both). Also described are cloned human antibodies that bind influenza
摘要翻译：抗体或抗体片段，其中抗体或片段结合流感病毒（例如H1N1，H5N1或两者）的HA结构域。还描述了结合流感的克隆人抗体

6. 发明授权

US08548983B1 Technique of decorrelation of lateral views 有权
标题翻译：侧视图的去相关技术
公开(公告)号：US08548983B1
公开(公告)日：2013-10-01
申请号：US13491391
申请日：2012-06-07
申请人： Rafi Ahmed
发明人： Rafi Ahmed
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F17/30466
摘要： Methods, computer-readable media, and machines are provided for transforming a query by removing a correlated predicate from a lateral view in an initial query. A query processor may transform the lateral view into a regular view such that a transformed query with the regular view is semantically equivalent to the initial query. The transformed query may support a larger set of access paths, join methods, and join permutations, may qualify for other transformations or optimizations, or may otherwise be executed or optimized differently from the initial query. The lateral view may reference an aggregation function, and the query processor may add a GROUP BY operator to the transformed query to preserve, after the correlated predicate has been pulled out of the lateral view, an interaction that was present between the aggregation function and the correlated predicate when the correlated predicate was in the lateral view.
摘要翻译：提供方法，计算机可读介质和机器用于通过从初始查询中的横向视图中移除相关谓词来转换查询。查询处理器可以将横向视图变换为常规视图，使得具有常规视图的变换查询在语义上等同于初始查询。变换后的查询可能支持较大的一组访问路径，连接方法和连接排列，可能有资格进行其他转换或优化，否则可能会与初始查询不同的方式执行或优化。横向视图可以引用聚合函数，并且查询处理器可以向转换后的查询添加GROUP BY运算符，以便在将相关谓词从侧视图中拉出之后保留在聚合函数和相关谓词当相关谓词处于侧视图时。

7. 发明申请

US20110271358A1 HUMAN ANTI-PD-1, PD-L1, AND PD-L2 ANTIBODIES AND USES THEREFOR 有权
标题翻译：人抗PD-1，PD-L1和PD-L2抗体及其用途
公开(公告)号：US20110271358A1
公开(公告)日：2011-11-03
申请号：US13120406
申请日：2009-09-25
申请人： Gordon J. Freeman , Rafi Ahmed , Timothy D. Jones , Francis J. Carr , James P. Gregson
发明人： Gordon J. Freeman , Rafi Ahmed , Timothy D. Jones , Francis J. Carr , James P. Gregson
IPC分类号： A61K39/395 , C07H21/00 , C12N15/63 , C12N5/10 , C12N1/00 , A01K67/027 , C12N5/0783 , C12P21/02 , A61P31/12 , A61P31/04 , A61P31/22 , A61P31/14 , A61P31/20 , A61P31/00 , A61P33/10 , A61P33/02 , A61P35/00 , A61P35/02 , A61P11/06 , A61P29/00 , A61P19/02 , A61P3/10 , A61P25/00 , C07K16/28
CPC分类号： C07K16/2803 , A61K2039/505 , C07K16/2818 , C07K16/2827 , C07K2317/21 , C07K2317/24 , C07K2317/34 , C07K2317/74 , C07K2317/76 , C07K2317/92 , Y02A50/41 , Y02A50/412
摘要： The present invention is based, in part, on the identification of novel human anti-PD-1, PD-L1, and PD-L2 antibodies. Accordingly, the invention relates to compositions and methods for diagnosing, prognosing, and treating conditions that would benefit from modulating PD-1, PD-L1, and/or PD-L2 activity (e.g., persistent infectious diseases, autoimmune diseases, asthma, transplant rejection, inflammatory disorders and tumors) using the novel human anti-PD-1, PD-L1, and PD-L2 antibodies described herein.
摘要翻译：本发明部分基于新型人抗PD-1，PD-L1和PD-L2抗体的鉴定。因此，本发明涉及用于诊断，预后和治疗将受益于调节PD-1，PD-L1和/或PD-L2活性（例如持续传染性疾病，自身免疫性疾病，哮喘，移植物）的病症的组合物和方法排斥，炎性疾病和肿瘤），使用本文所述的新的人抗PD-1，PD-L1和PD-L2抗体。

8. 发明申请

US20100279352A1 Rapid Generation of Antibodies 有权
标题翻译：快速产生抗体
公开(公告)号：US20100279352A1
公开(公告)日：2010-11-04
申请号：US12433832
申请日：2009-04-30
申请人： Rafi Ahmed , Joseph Miller , Patrick Wilson , Jens Wrammert
发明人： Rafi Ahmed , Joseph Miller , Patrick Wilson , Jens Wrammert
IPC分类号： C12P21/00
CPC分类号： C07K16/1018 , C07K16/00
摘要： High efficient methods for producing an antibody molecule that binds an antigen are described. The methods include obtaining a population of PBMC enriched for CD19highCD3negCD20low to negCD38highCD27high cells from a mammal exposed to an antigen from sample of cells enriched for PBMC. The cells are isolated from a sample obtained at a time that the fraction of PBMC expressing antibody reactive to the antigen is at a high level. Sequences encoding heavy and light chain variable domains are prepared in a manner that allow production of molecules with natural heavy and light chain pairing.
摘要翻译：描述了用于产生结合抗原的抗体分子的高效方法。所述方法包括从富集PBMC的细胞样品中获得富含CD19highCD3negCD20的PBMC群体，从暴露于抗原的哺乳动物中将CD38highCD27高细胞从抗原中除去。从在与抗原反应的表达抗体的PBMC的分数处于高水平的时刻获得的样品中分离细胞。编码重链和轻链可变结构域的序列以允许生成具有天然重链和轻链配对的分子的方式制备。

9. 发明申请

US20100030756A1 TECHNIQUES FOR COALESCING SUBQUERIES 有权
标题翻译：煤炭加工技术
公开(公告)号：US20100030756A1
公开(公告)日：2010-02-04
申请号：US12182002
申请日：2008-07-29
申请人： Rafi Ahmed , Srikanth Bellamkonda
发明人： Rafi Ahmed , Srikanth Bellamkonda
IPC分类号： G06F17/30
CPC分类号： G06F17/30448
摘要： Methods for transforming queries that contain EXISTS and NOT EXISTS subqueries are provided. The methods provided transform original queries that contain EXISTS and/or NOT EXISTS subqueries in conjunctive or disjunctive combinations into transformed queries that coalesce the original EXISTS and/or NOT EXISTS subqueries into a reduced number of EXISTS and/or NOT EXISTS subqueries, thereby eliminating duplicative table accesses and join operations.
摘要翻译：提供了用于转换包含EXISTS和NOT EXISTS子查询的查询的方法。所提供的方法将包含EXISTS和/或NOT EXISTS子查询的原始查询以联合或分离的组合转换为将原始EXISTS和/或NOT EXISTS子查询合并到减少数量的EXISTS和/或NOT EXISTS子查询中的转换查询，从而消除重复表访问和连接操作。

10. 发明申请

US20090292669A1 TECHNIQUE FOR REMOVING SUBQUERY USING WINDOW FUNCTIONS 有权
标题翻译：使用WINDOW功能删除子机的技术
公开(公告)号：US20090292669A1
公开(公告)日：2009-11-26
申请号：US12125783
申请日：2008-05-22
申请人： Rafi Ahmed , Srikanth Bellamkonda
发明人： Rafi Ahmed , Srikanth Bellamkonda
IPC分类号： G06F17/30
CPC分类号： G06F17/30466
摘要： Methods for transforming a query to remove redundant subqueries in HAVING clauses are provided. The methods provided transform queries that contain subqueries in HAVING clauses with tables and join conditions and filter conditions equal to tables, join conditions and filter conditions in outer query to queries that eliminate the original subquery and retain the original outer query with a single inline view using window functions. Whether this transformation can be performed depends on which tables and join and filter conditions are in the outer query and the subquery. The transformation eliminates duplicative table accesses and join operations from queries.
摘要翻译：提供了在HAVING子句中转换查询以删除冗余子查询的方法。所提供的方法将包含HAVING子句中的子查询的查询转换为表和连接条件以及等于外部查询中的表，连接条件和过滤条件的过滤条件，以消除原始子查询并使用单个内联视图保留原始外部查询窗口功能。是否可以执行此转换取决于外部查询和子查询中的哪些表和连接和过滤条件。该转换消除了查询中的重复表访问和连接操作。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式