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

1. 发明授权

US07275056B2 System and method for transforming queries using window aggregation 有权
标题翻译：使用窗口聚合转换查询的系统和方法
公开(公告)号：US07275056B2
公开(公告)日：2007-09-25
申请号：US10425343
申请日：2003-04-29
申请人： Qi Cheng , Linqi Liu , Wenbin Ma , Mir Hamid Pirahesh , Calisto P. Zuzarte
发明人： Qi Cheng , Linqi Liu , Wenbin Ma , Mir Hamid Pirahesh , Calisto P. Zuzarte
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30451 , Y10S707/99934 , Y10S707/99935
摘要： A system and method transform queries with subqueries, using window aggregation. An optimizer in a relational database management system transforms queries to optimize their efficiency and speed. The method transforms queries that have a subquery, replacing the subquery with a window aggregation function. In the case of a correlated subquery, the window aggregation function is partitioned by a correlated column of a correlated table. All data in the main select clause, or outer block, of the query that was obtained through references to the correlated table is instead obtained through the new window aggregation subquery. By using window aggregation, the aggregation is performed at the same time as the selection of relevant data from the correlated table, thereby compiling all needed data in a single pass through the table or view. Reducing the number of times that tables or views are accessed reduces the computational demands of a query.
摘要翻译：系统和方法使用子查询转换查询，使用窗口聚合。关系数据库管理系统中的优化器可以转换查询以优化其效率和速度。该方法转换具有子查询的查询，使用窗口聚合函数替换子查询。在相关子查询的情况下，窗口聚合函数由相关表的相关列划分。通过引用相关表获得的查询的main select子句或外部块中的所有数据都是通过新的窗口聚合子查询得到的。通过使用窗口聚合，在从相关表中选择相关数据的同时进行聚合，从而在通过表或视图的单次传递中编译所有需要的数据。降低访问表或视图的次数减少了查询的计算需求。

2. 发明授权

US07454416B2 Method for aggregation subquery join elimination 失效
标题翻译：聚合子查询连接消除方法
公开(公告)号：US07454416B2
公开(公告)日：2008-11-18
申请号：US10428263
申请日：2003-04-30
申请人： Calisto P Zuzarte , Qi Cheng , Wenbin Ma
发明人： Calisto P Zuzarte , Qi Cheng , Wenbin Ma
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30979 , Y10S707/99933 , Y10S707/99934
摘要： A method for use with an information retrieval system, in which the method is used for transforming a database statement containing a first subquery and a second subquery joined together, the first subquery including a group by operation over a child subquery, the method comprising removing the first subquery from the database statement thereby removing the join between the first subquery and the second subquery.
摘要翻译：一种与信息检索系统一起使用的方法，其中所述方法用于变换包含连接在一起的第一子查询和第二子查询的数据库语句，所述第一子查询包括通过在子子查询上的操作的组，所述方法包括：数据库语句中的第一个子查询，从而删除第一个子查询和第二个子查询之间的连接。

3. 发明申请

US20080306906A1 SYSTEM FOR AGGREGATION SUBQUERY JOIN ELIMINATION 失效
标题翻译：集体救助系统
公开(公告)号：US20080306906A1
公开(公告)日：2008-12-11
申请号：US12193585
申请日：2008-08-18
申请人： Calisto P. Zuzarte , Qi Cheng , Wenbin Ma
发明人： Calisto P. Zuzarte , Qi Cheng , Wenbin Ma
IPC分类号： G06F7/06 , G06F17/30
CPC分类号： G06F17/30979 , Y10S707/99933 , Y10S707/99934
摘要： A system for use with an information retrieval system, in which system is used for transforming a database statement containing a first subquery and a second subquery joined together, the first subquery including a group by operation over a child subquery, the information retrieval system comprising means for removing the first subquery from the database statement thereby eliminating the join between the first subquery and the second subquery.
摘要翻译：一种与信息检索系统一起使用的系统，其中所述系统用于变换包含连接在一起的第一子查询和第二子查询的数据库语句，所述第一子查询包括通过子查询的操作的组，所述信息检索系统包括装置用于从数据库语句中删除第一个子查询，从而消除了第一个子查询和第二个子查询之间的连接。

4. 发明授权

US07966314B2 System for aggregation subquery join elimination 失效
标题翻译：用于聚合子查询的系统加入消除
公开(公告)号：US07966314B2
公开(公告)日：2011-06-21
申请号：US12193585
申请日：2008-08-18
申请人： Calisto Zuzarte , Qi Cheng , Wenbin Ma
发明人： Calisto Zuzarte , Qi Cheng , Wenbin Ma
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30979 , Y10S707/99933 , Y10S707/99934
摘要： A system for use with an information retrieval system, in which system is used for transforming a database statement containing a first subquery and a second subquery joined together, the first subquery including a group by operation over a child subquery, the information retrieval system comprising means for removing the first subquery from the database statement thereby eliminating the join between the first subquery and the second subquery.
摘要翻译：一种与信息检索系统一起使用的系统，其中所述系统用于变换包含连接在一起的第一子查询和第二子查询的数据库语句，所述第一子查询包括通过子查询的操作的组，所述信息检索系统包括装置用于从数据库语句中删除第一个子查询，从而消除了第一个子查询和第二个子查询之间的连接。

5. 发明申请

US20150283318A1 Methods to detect and treat diseases 审中-公开
标题翻译：检测和治疗疾病的方法
公开(公告)号：US20150283318A1
公开(公告)日：2015-10-08
申请号：US14246117
申请日：2014-04-06
申请人： Tianxin Wang , Wenbin Ma , Yiwang Chen , Lei Liu
发明人： Tianxin Wang , Wenbin Ma , Yiwang Chen , Lei Liu
IPC分类号： A61M1/36 , A61N5/10 , A61B18/04 , A61B18/18 , A61B18/02 , G01N33/48 , A61B18/20
CPC分类号： A61M1/3679 , A61B18/02 , A61B18/04 , A61B18/1815 , A61B18/20 , A61B2018/00577 , A61M1/3472 , A61M1/3486 , A61M1/3621 , A61M1/3681 , A61M1/3683 , A61M1/3687 , A61M2202/0415 , A61M2205/053 , A61M2205/75 , A61N5/10 , G01N33/48
摘要： The current invention discloses methods to treat disease caused by virus infection, bacterial infection, parasites infection, autoimmune disease, disease caused by production of unwanted antibodies, sepsis as well as methods to treat cancer and methods for virus infection detection using blood purification method. The current invention provides a method to treat pathogen infection by inactivating the pathogens in the blood. During the treatment, blood is withdrawn from a patient and is separated into its plasma and cellular components. The plasma portion is treated with physical means such as UV radiation to inactivate the pathogens inside and then is returned to the patient. The current invention also provide a method to treat cancer especially to prevent tumor metastasis and tumor recurrence by removing and/or inactivating (e.g. killing) the circulating tumor cells (CTC) in the blood after removing the tumor or treating the tumor with therapeutical means.
摘要翻译：本发明公开了使用血液净化方法治疗由病毒感染，细菌感染，寄生虫感染，自身免疫病，由不想要的抗体产生引起的疾病，败血症以及治疗癌症的方法等疾病的方法。本发明提供了通过灭活血液中的病原体来治疗病原体感染的方法。在治疗期间，将血液从患者中取出并分离成其血浆和细胞组分。用诸如UV辐射的物理手段处理血浆部分以使内部的病原体灭活，然后返回到患者体内。本发明还提供了一种治疗癌症的方法，特别是通过在除去肿瘤之后除去和/或灭活（例如杀死）血液中的循环肿瘤细胞（CTC）或用治疗方法治疗肿瘤来预防肿瘤转移和肿瘤复发。

6. 发明授权

US08122033B2 Database query optimization 失效
标题翻译：数据库查询优化
公开(公告)号：US08122033B2
公开(公告)日：2012-02-21
申请号：US11971525
申请日：2008-01-09
申请人： Jian Le , Wenbin Ma
发明人： Jian Le , Wenbin Ma
IPC分类号： G06F17/00
CPC分类号： G06F17/30442
摘要： A method, system, and computer program product for optimizing database queries in a data processing system. A query optimization (QO) utility maximizes the query coverage of Materialized Query Tables (MQTs) in order to efficiently process various types of incoming queries to a database engine. In particular, the QO utility enables MQT technology for nullable foreign key columns in a number of table joins involving fact tables and dimension tables, in which the fact tables and dimension tables have column data which are not null. The QO utility also enables MQT query matching for a relational database engine for non-additive measures, and improves the performance of existing query-matching capabilities for a relational database engine for additive measures. The QO utility specifies a number of functionally dependent relationships between the columns of a table in order to enhance the query matching abilities of the database engine.
摘要翻译：一种用于在数据处理系统中优化数据库查询的方法，系统和计算机程序产品。查询优化（QO）实用程序最大化物化查询表（MQT）的查询覆盖率，以便有效地处理数据库引擎的各种传入查询。特别地，QO实用程序在涉及事实表和维度表的多个表连接中启用MQT技术用于可空的外键列，其中事实表和维度表的列数据不为空。 QO实用程序还为关联数据库引擎启用MQT查询匹配以用于非加性度量，并提高了关系数据库引擎的加法度量的现有查询匹配功能的性能。 QO实用程序指定表的列之间的多个功能依赖关系，以增强数据库引擎的查询匹配能力。

7. 发明授权

US07547517B2 MAGE-C2 antigenic peptides and uses thereof 失效
标题翻译： MAGE-C2抗原肽及其用途
公开(公告)号：US07547517B2
公开(公告)日：2009-06-16
申请号：US10670472
申请日：2003-09-26
申请人： Wenbin Ma , Benoit Van Den Eynde , Thierry Boon-Falleur , Catherine Germeau , Pierre Coulie
发明人： Wenbin Ma , Benoit Van Den Eynde , Thierry Boon-Falleur , Catherine Germeau , Pierre Coulie
IPC分类号： G01N33/53 , C07K17/00
CPC分类号： C07K14/4748 , A61K38/00
摘要： This invention relates to isolated peptides derived from MAGE-C2, nucleic acid molecules that encode MAGE-C2 and the isolated peptides derived from MAGE-C2, expression vectors comprising the nucleic acid molecules, host cells transformed or transfected with the nucleic acid molecules or the expression vectors, and to tetramers comprising the peptides, HLA molecules, β2 microglobulin and a first and second binding partner. This invention also relates to methods for using the peptides, nucleic acid molecules, expression vectors, tetramers and complexes of this invention as well as to cytolytic T cells which recognize the peptides in complex with an HLA molecule.
摘要翻译：本发明涉及衍生自MAGE-C2的分离的肽，编码MAGE-C2的核酸分子和来自MAGE-C2的分离的肽，包含核酸分子的表达载体，用核酸分子转化或转染的宿主细胞表达载体和包含肽，HLA分子，β2微球蛋白和第一和第二结合配偶体的四聚体。本发明还涉及使用本发明的肽，核酸分子，表达载体，四聚体和复合物以及识别与HLA分子复合的肽的细胞溶解性T细胞的方法。

8. 发明申请

US20130131423A1 Methods to detect and treat diseases 审中-公开
公开(公告)号：US20130131423A1
公开(公告)日：2013-05-23
申请号：US13444201
申请日：2012-04-11
申请人： Tianxin Wang , Wenbin Ma , Yiwang Chen , Lei Liu
发明人： Tianxin Wang , Wenbin Ma , Yiwang Chen , Lei Liu
IPC分类号： A61N5/02 , A61M1/36 , C12N5/0781 , A61N5/06
CPC分类号： A61M1/3621 , A61M1/3472 , A61M1/3679 , A61M2202/20 , A61M2205/051 , A61M2205/36 , C12N5/0635
摘要： The current invention discloses methods to treat disease caused by virus infection, bacterial infection, parasites infection, autoimmune disease, disease caused by production of unwanted antibodies, sepsis as well as methods to treat cancer and methods for virus infection detection using blood purification method. The current invention provides a method to treat pathogen infection by inactivating the pathogens in the blood. During the treatment, blood is withdrawn from a patient and is separated into its plasma and cellular components. The plasma portion is treated with physical means such as UV radiation to inactivate the pathogens inside and then is returned to the patient. The current invention also provide a method to treat cancer especially to prevent tumor metastasis and tumor recurrence by removing and/or inactivating (e.g. killing) the circulating tumor cells (CTC) in the blood after removing the tumor or treating the tumor with therapeutical means.

9. 依法登记的发明

USH2056H1 Model for von Hippel-Lindau disease 有权
公开(公告)号：USH2056H1
公开(公告)日：2002-12-03
申请号：US09971476
申请日：2001-10-04
申请人： Laura S. Schmidt , Wenbin Ma , Lino Tessarollo , Berton Zbar
发明人： Laura S. Schmidt , Wenbin Ma , Lino Tessarollo , Berton Zbar
IPC分类号： C07H2104
摘要： Disclosed herein are nucleic acid molecules that can be used to effect a loss of function of the von Hippel-Lindau (VHL) allele in somatic and/or germ cells of a mammal and methods for using these molecules to create conditional VHL gene targeted and conditional VHL knockout animals. Disclosed herein are conditional VHL gene target vectors which, when inserted into an endogenous VHL gene, can result in deletion of an exon of a VHL gene by site-specific recombinaton when a recombinase is expressed conditionally.

10. 发明申请

US20090233315A1 MAGE-C2 antigenic peptides and uses therefor 审中-公开
标题翻译： MAGE-C2抗原肽及其用途
公开(公告)号：US20090233315A1
公开(公告)日：2009-09-17
申请号：US12387884
申请日：2009-05-08
申请人： Wenbin Ma , Benoit Van Den Eynde , Thierry Boon-Falleur , Catherine Germeau , Pierre Coulie
发明人： Wenbin Ma , Benoit Van Den Eynde , Thierry Boon-Falleur , Catherine Germeau , Pierre Coulie
IPC分类号： G01N33/567 , C07K7/06
CPC分类号： C07K14/4748 , A61K38/00
摘要： This invention relates to isolated peptides derived from MAGE-C2, nucleic acid molecules that encode MAGE-C2 and the isolated peptides derived from MAGE-C2, expression vectors comprising the nucleic acid molecules, host cells transformed or transfected with the nucleic acid molecules or the expression vectors, and to tetramers comprising the peptides, HLA molecules, ∃2 microglobulin and a first and second binding partner. This invention also relates to methods for using the peptides, nucleic acid molecules, expression vectors, tetramers and complexes of this invention as well as to cytolytic T cells which recognize the peptides in complex with an HLA molecule.
摘要翻译：本发明涉及衍生自MAGE-C2的分离的肽，编码MAGE-C2的核酸分子和来自MAGE-C2的分离的肽，包含核酸分子的表达载体，用核酸分子转化或转染的宿主细胞表达载体和包含肽，HLA分子，∃2微球蛋白和第一和第二结合配偶体的四聚体。本发明还涉及使用本发明的肽，核酸分子，表达载体，四聚体和复合物以及识别与HLA分子复合的肽的细胞溶解性T细胞的方法。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式