Abstract:
Fine-grained access control for querying a database with low overhead and safety plans. In a view placement approach, base relations of the query expression are replaced by views that are appropriate for the particular user. Information leakage via UDF pushing, exception processing, and error messages can be prevented by generating safe plans. An existing query optimizer can be modified to perform redundancy removal and safe plan implementation. Subsumption testing available in materialized view matching can be exploited by the query optimizer. Authorization inference is exploited to generate safe plans.
Abstract:
A database server may be configured to compute distinct page counts of pages accessed to execute operands of respective queries. The queries may be executed against a table comprised of the pages and having an index managed by the database server. The distinct page counts may be obtained by counting, as a part of the executing of the queries, distinct pages accessed during the execution of the queries.
Abstract:
A proactive monitoring mechanism for correcting the choice of access methods (available query plans) for a given query, based on execution feedback from the same query. The mechanism exploits bypassing predicate short-circuiting inside the database server's predicate evaluation module to obtain expression cardinalities. The mechanism can also modify a plan to obtain expression cardinalities. These techniques are used judiciously by the query optimizer and/or a database administrator (DBA) so that the execution overheads are within acceptable limits.
Abstract:
Techniques for estimating the progress of database queries are described herein. In a first implementation, a respective lower-bound parameter is associated with each node in an operator tree that representing a given database query, and the progress of the database query at a given point is estimated based upon the lower-bound parameters. In a second implementation, the progress of the query is estimated by associating respective lower-bound and upper-bound parameters with each node in the operator tree. The progress of the query at the given point is then estimated based on the lower-bound and upper-bound parameters.
Abstract:
A method for controlling exhaust gas particulate emissions from a compression ignition internal combustion engine having a variable geometry turbocharger (VGT) includes the steps of determining backpressure across the engine and air mass flow into the engine, closing vanes of the VGT to provide air mass flow increase when backpressure is increasing, and stopping the step of closing the vanes of the VGT when a decrease in rate of change of air mass flow is determined.
Abstract:
Database systems use a plan cache to avoid the overheads (e.g., time, money) of query recompilation. Query plans can become invalidated by updates to the statistics on data or changes to the physical database design. Once a plan is invalidated, it can be repaired utilizing one or more of the disclosed embodiments. Incremental repair of query plans includes reusing parts of the current plan rather than discarding the plan entirely when it is invalidated. Repair to an existing query plan is attempted before resorting to full recompilation.
Abstract:
A control and method for an internal combustion engine that includes an exhaust gas recirculation system to predict an intake manifold critical temperature (dew point) at which condensation would occur upon entry into exhaust gas recirculation. The control calculates the intake manifold critical temperature (IMT_Critical) as a function of predetermined, sensed or assumed values by processing an equation whose variables are occupied by the values. The control commands adjustments of exhaust gas recirculation operation in response to the calculation, preferably after the actual intake manifold temperature exceeds the IMT_Critical for a predetermined time.
Abstract:
A control and method for an internal combustion engine that includes an exhaust gas recirculation system to predict an intake manifold critical temperature (dew point) at which condensation would occur upon entry into exhaust gas recirculation. The control calculates the intake manifold critical temperature (IMT_Critical) as a function of predetermined, sensed or assumed values by processing an equation whose variables are occupied by the values. The control commands adjustments of exhaust gas recirculation operation in response to the calculation, preferably after the actual intake manifold temperature exceeds the IMT_Critical for a predetermined time.
Abstract:
A control for an internal combustion engine that includes an exhaust gas recirculation system predicts at least one of the intake manifold temperature in EGR mode or an intake manifold pressure in EGR mode, but preferably both, during Boost mode operation. The predictions are relied upon to calculate an intake manifold critical temperate in EGR, at which condensation would occur. The control then compares the predicted temperate value with the calculated intake manifold critical temperature, and if the predicted value exceeds the calculated temperature, the control commands re-entry into exhaust gas recirculation mode.