Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: A method for determining telomerase activity using primer extension followed with real time PCR quantification is disclosed. The method of the present invention provides a rapid, sensitive and accurate measurement for telomerase activity in a biological sample. In one embodiment, the method includes the steps of: adding the biological sample to a reaction tube containing a first reaction mixture having a first primer and nucleoside triphosphates, a second reaction mixture having a second primer and a DNA polymerase, and a wax layer that separates the first reaction mixture from the second reaction mixture; incubating the biological sample with the first reaction mixture; admixing the extension product with the second reaction mixture; amplifying and quantifying the extension product using real-time PCR and a control template. In another embodiment, the detection method includes an in situ primer extension step that allows the production of the extension product within an intact cell.

Abstract: 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.

Abstract: 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.

Abstract: 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, &bgr;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.

Abstract: 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.

Abstract: 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.