Abstract: A set of Internet Protocol (IP) addresses is received wherein each IP address is associated with a corresponding set of features. For an IP address in the set, the IP address is evaluated based at least in part on a set of inclusion criteria. For the IP address in the set, a likelihood that the IP address is residential or non-residential is generated based at least in part on the corresponding set of features and the evaluation of the IP address based at least in part on the set of inclusion criteria. For the IP address in the set, a training sample is generated that includes the IP address, at least some of the corresponding set of features, and a label. A labeled training data set is output that includes the training sample, where an IP address classifier is trained using the labeled training data set.

Abstract: A new type of table join operation, outer semi join (OSJ), is provided, which can be used by an optimizer layer and an execution layer of a database management system (DBMS). OSJ combines the semantics of both left outer-join and semi-join. The concept of an anti-join marker (AJM) is also introduced, which specifies whether a matching row was not found between joined tables for each result row in an OSJ operation. The OSJ operation supports unnesting of a class of disjunctive ANY, ALL, EXISTS, NOT EXISTS, IN, and NOT IN subqueries for execution plan optimization. The disjunction may contain filter predicates. For unnesting, OSJ avoids the need of using a distinct operator on the right table and also supports using inequality (e.g. >, >=, <, <=) in connecting or correlating conditions of subqueries, rather than being limited to equality only.

Abstract: This disclosure relates to the genetic modification of DNMT3A gene in immune cells. In certain embodiments, the modified immune cells may be used in adoptive T cells therapies to enhance immune responses against cancer or chronic infections. In certain embodiments, the disclosure relates to deleting, changing, or inserting nucleotides within the DNMT3A gene in immune cells, e.g., human CD8 T cells, such that the DNMT3A gene product does not function for methylation. In certain embodiments, modification of the DNMT3A gene provides an improvement in antigen-specific T cells functions and/or an enhancement of the longevity of the cells.

Abstract: In one technique, a definition of a materialized view is identified. Based on the definition, multiple candidate partitioning schemes are identified. A query is generated that indicates one or more of the candidate partitioning schemes. The query is then executed, where executing the query results in one or more partition counts, each corresponding to a different candidate partitioning scheme of the one or more candidate partitioning schemes. Based on the one or more partition counts, a candidate partitioning scheme is selected from among the plurality of candidate partitioning schemes. The materialized view is automatically partitioned based on the candidate partitioning scheme.

Abstract: This disclosure relates T cell receptors (TCR) having antigenic specificity for an epitopes of human papillomavirus (HPV) proteins such as E2, E5, and E6. Related poly peptides and proteins, as well as related nucleic acids, recombinant expression vectors, host cells, and populations of cells are also provided. Pharmaceutical compositions relating to the TCRs are also provided. Also disclosed are methods of detecting the presence of a condition in a mammal and methods of treating or preventing a condition in a mammal, wherein the condition is an epithelial cancer. HPV infection, or HPV-positive premalignancy.

Abstract: A mechanism is provided for performing a group-by pushdown operation or a distinct pushdown operation on a query. The query comprises an outer query block containing a view with a union-all operator, and the outer query block comprises an outer query statement referencing one or more columns of the union-all view and a group-by statement or a distinct keyword. Performing the group-by pushdown operation or the distinct pushdown operation on the query comprises modifying at least a given branch of the union-all view to include a distinct keyword in a query statement of the given branch or a group-by clause that groups results of the given branch by the one or more columns of the table of the given branch.

Abstract: This disclosure relates to CD8 positive stem-like chronic memory cells for uses in managing diseases and conditions associated with T cell exhaustion and compositions related thereto. In certain embodiments. the CD8 positive cells are PD-1 positive or PD-1 negative. CD62L positive. CD127 positive, and CD44 positive. In certain embodiments. this disclosure relates to methods of treating cancer. chronic viral infections. or chronic diseases comprising administering to a patient in need thereof an effective amount of CD8 positive stem-like chronic memory cells optionally in combination with checkpoint inhibitors. In certain embodiments. the CD8 positive stem-like chronic memory cells are derived from the patient to be treated. are optionally expanded ex vivo, and optionally express a chimeric antigen receptor.

Abstract: A new type of table join operation, outer semi join (OSJ), is provided, which can be used by an optimizer layer and an execution layer of a database management system (DBMS). OSJ combines the semantics of both left outer-join and semi-join. The concept of an anti-join marker (AJM) is also introduced, which specifies whether a matching row was not found between joined tables for each result row in an OSJ operation. The OSJ operation supports unnesting of a class of disjunctive ANY, ALL, EXISTS, NOT EXISTS, IN, and NOT IN subqueries for execution plan optimization. The disjunction may contain filter predicates. For unnesting, OSJ avoids the need of using a distinct operator on the right table and also supports using inequality (e.g. >, >=, <, <=) in connecting or correlating conditions of subqueries, rather than being limited to equality only.

Abstract: Techniques for automatically partitioning materialized views are provided. In one technique, a definition of a materialized view is identified. Based on the definition, multiple candidate partitioning schemes are identified. A query is generated that indicates one or more of the candidate partitioning schemes. The query is then executed, where executing the query results in one or more partition counts, each corresponding to a different candidate partitioning scheme of the one or more candidate partitioning schemes. Based on the one or more partition counts, a candidate partitioning scheme is selected from among the plurality of candidate partitioning schemes. The materialized view is automatically partitioned based on the candidate partitioning scheme.

Abstract: This disclosure relates to antibodies and antigen binding fragments that specifically bind Ebola virus particles. In certain embodiments, the antibodies and fragments are capable of treating or preventing an Ebola viral infection. In certain embodiments, the antibodies and antigen binding fragments are also contemplated for diagnostic methods and compositions related thereto.

Abstract: This disclosure relates to coronavirus assays, diagnostic methods, treatment methods, and compositions related thereto. In certain embodiments, this disclosure relates to ACE2 receptor binding domain peptides and uses in serological assays and vaccination methods.

Abstract: Techniques are described herein for subquery removal given two set operation-based subqueries in a query, where one subquery contains the result of the other. The described optimization technique of subquery removal is enabled by join and set operation-based containment of the set operation-based subqueries where semantic equivalence can be established for a given pair of set operation-based subqueries when some table(s)—with associated join condition(s), correlation condition(s), and/or filter predicate(s)—in one subquery are not considered. Subquery removal reduces multiple access to the same table and multiple evaluations of the same join conditions required to evaluate the query. When a subquery is removed from a disjunction, this may lead to other optimizations such as subquery unnesting, e.g., when the original query configuration would not permit query unnesting and the rewritten query (with one or more removed subqueries) permits unnesting.

Abstract: This disclosure relates to antibodies and antigen binding fragments that specifically bind Ebola virus particles. In certain embodiments, the antibodies and fragments are capable of treating or preventing an Ebola viral infection. In certain embodiments, the antibodies and antigen binding fragments are also contemplated for diagnostic methods and compositions related thereto.

Abstract: Definitions of material views are automatically generated. In general, Automated MV generation identifies a set of candidates MVs by examining a working set of query blocks. Once the candidates are formed, the candidate MVs are further evaluated to calculate a benefit to the candidate MVs. An improved approach for generating a candidate set of MVs is described herein. The improved approach is referred to as the extended covering subexpression technique (ECSE). Under ECSE, various relationships between join sets other than strict equivalence are used to generate new resultant join sets. Such relationships include subset, intersection, superset, and union, which shall be described in further detail below. In some cases, relationships among resultant join sets and initial join sets are considered to generate new resultant join sets. The final resultant join sets are then used to form a candidate set of MVs.

Abstract: Techniques for subsumption of inline views and subqueries in a query are described. An optimization technique of subsumption is enabled by inline views having identical tables and identical join conditions and having aggregation functions but no group-by clauses. When subsumption takes place, a single query block replaces the inline views (or subqueries) with a single inline view query block. Subsumption reduces multiple access to the same table and multiple evaluations of the same join conditions required to evaluate the query. The single query block includes factored out filter predicates and unified predicates that originate from the subsumed inline views (or subqueries). Based on similarities among the aggregation functions and filter predicates in the subsumed inline views, pre-computation of common aggregates may be performed in a new group-by view in the subsuming view.

Abstract: Techniques are described herein for subquery removal given two set operation-based subqueries in a query, where one subquery contains the result of the other. The described optimization technique of subquery removal is enabled by join and set operation-based containment of the set operation-based subqueries where semantic equivalence can be established for a given pair of set operation-based subqueries when some table(s)—with associated join condition(s), correlation condition(s), and/or filter predicate(s)—in one subquery are not considered. Subquery removal reduces multiple access to the same table and multiple evaluations of the same join conditions required to evaluate the query. When a subquery is removed from a disjunction, this may lead to other optimizations such as subquery unnesting, e.g., when the original query configuration would not permit query unnesting and the rewritten query (with one or more removed subqueries) permits unnesting.

Abstract: The present invention provides methods and compositions for the treatment, prevention, or reduction of persistent infections, such as chronic infections, latent infections, and slow infections and cancer. The methods and compositions of the invention are also useful for the alleviation of one or more symptoms associated with such infections and cancer.

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

Abstract: The present invention relates to methods of reducing liver PD-1-expressing CD8+ T cells using PD-1 Fc fusion proteins that bind Fc receptors, as well as diagnostic, prognostic, therapeutic methods and compositions related thereto.

Abstract: This disclosure relates to specific binding agents to varicella-zoster virus proteins or glycoproteins. In certain embodiments the specific binding agents are antibodies and binding fragments thereof disclosed herein. In certain embodiments, this disclosure relates to methods of treating or preventing a varicella-zoster infection comprising administering an effective amount of a specific binding agent disclosed herein to a subject in need thereof.