Abstract: Techniques are provided for determining query cost for a query that include an outer query and at least a first subquery. The techniques include determining a filtering factor for the first subquery based on a first cardinality and a second cardinality. The first cardinality is determined based on a first set of query blocks in the query. The second cardinality is determined based on a second set of query blocks. The first set of query blocks includes the outer query and zero or more subqueries from the query and does not include the first subquery. The second set of query blocks includes all the query blocks in the first set of query blocks and, in addition, the first subquery. The techniques also include determining a cost for the query based, at least, on the filtering factor for the first subquery.

Abstract: Techniques for reusing optimized query blocks in query processing are provided. The techniques include checking a data structure to determine whether a previously-generated query block information record corresponding to an already-processed first inner query block exists in the data structure, where the already-processed first inner query block corresponds to the first inner query block in a first state in an already-processed form. If the previously-generated query block information record exists in the data structure, then query block information is established for the first inner query block in the first state based on the previously-generated query block information record. Then a cost is determined for a semantically equivalent query that includes the first inner query block in the first state based on the query block information for the first inner query block in the first state.

Abstract: Techniques are provided for processing a query including determining a first cost based on the original query; if the query has a subquery, generating a second query with the subquery unnested; determining a second cost based on the second query; determining whether the second query includes a mergeable view; and if the second query includes a mergeable view, then generating a third query with the view merged; determining a third cost based on the third query; and choosing an output query from among the set of semantically equivalent queries based on costs associated with the semantically equivalent queries, where the set of semantically equivalent queries includes two or more of the original query, the second query, and the third query.

Abstract: This invention provides methods of inducing an antiviral response in an individual comprising administering to the individual an effective amount of a LT-B blocking agent and a pharmaceutically acceptable carrier. In particular this invention provides methods for treating viral-induced systemic shock and respiratory distress.

Abstract: This invention provides methods of inducing an antiviral response in an individual comprising administering to the individual an effective amount of a LT-B blocking agent and a pharmaceutically acceptable carrier. In particular this invention provides methods for treating viral-induced systemic shock and respiratory distress.

Abstract: An information management system for managing the concurrent performance of multiple works-in-progress while providing atomicity, consistency, isolation, and durability among transactions involved in the works-in-progress. The information management system includes a database for persistently storing a set of data objects and a set of data changes targeted for the data objects. The information management system includes a library that provides a set of methods that enable an activity to persistently store the data changes in the database while maintaining a work-in-progress such that the data changes are concealed from a global view of the database until the work-in-progress is complete.