Fine-grained access control in a database by preventing information leakage and removing redundancy
    31.
    发明授权
    Fine-grained access control in a database by preventing information leakage and removing redundancy 失效
    通过防止信息泄漏和消除冗余,在数据库中进行细粒度的访问控制

    公开(公告)号:US07685194B2

    公开(公告)日:2010-03-23

    申请号:US11468928

    申请日:2006-08-31

    CPC classification number: G06F17/30471 G06F17/30306 G06F21/6227

    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 translation: 用于以低开销和安全计划查询数据库的细粒度访问控制。 在视图放置方法中,查询表达式的基础关系被替换为适合特定用户的视图。 可以通过生成安全计划来防止通过UDF推送,异常处理和错误消息的信息泄漏。 可以修改现有的查询优化器,以执行冗余删除和安全计划实施。 查询优化器可以利用实体​​化视图匹配中的可用度量测试。 利用授权推理来制定安全计划。

    DETECTING ESTIMATION ERRORS IN DICTINCT PAGE COUNTS
    32.
    发明申请
    DETECTING ESTIMATION ERRORS IN DICTINCT PAGE COUNTS 有权
    检测DICTINCT页数中的估计错误

    公开(公告)号:US20090254522A1

    公开(公告)日:2009-10-08

    申请号:US12098178

    申请日:2008-04-04

    CPC classification number: G06F17/30306 G06Q30/0202

    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 translation: 数据库服务器可以被配置为计算被访问的页面的不同页面计数以执行各个查询的操作数。 可以针对由该页组成的表并且具有由数据库服务器管理的索引来执行查询。 独立页面计数可以通过在执行查询期间计数访问的不同页面作为执行查询的一部分来获得。

    EXPLOITING EXECUTION FEEDBACK FOR OPTIMIZING CHOICE OF ACCESS METHODS
    33.
    发明申请
    EXPLOITING EXECUTION FEEDBACK FOR OPTIMIZING CHOICE OF ACCESS METHODS 审中-公开
    用于优化访问方法选择的执行反馈

    公开(公告)号:US20090094191A1

    公开(公告)日:2009-04-09

    申请号:US11868957

    申请日:2007-10-08

    CPC classification number: G06F16/24542

    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 translation: 一种主动监视机制,用于根据同一查询的执行反馈来校正给定查询的访问方法(可用查询计划)的选择。 该机制利用绕过数据库服务器谓词评估模块内的谓词短路来获得表达式的基数。 该机制还可以修改计划以获得表达式的基数。 这些技术由查询优化器和/或数据库管理员(DBA)明智地使用,以便执行开销在可接受的限度内。

    Techniques for estimating progress of database queries
    34.
    发明授权
    Techniques for estimating progress of database queries 有权
    估计数据库查询进度的技术

    公开(公告)号:US07454407B2

    公开(公告)日:2008-11-18

    申请号:US11149968

    申请日:2005-06-10

    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 translation: 本文描述了用于估计数据库查询的进度的技术。 在第一实现中,相应的下限参数与表示给定数据库查询的运算符树中的每个节点相关联,并且基于下限参数来估计给定点处的数据库查询的进度。 在第二个实现中,通过将相应的下限和上限参数与运算符树中的每个节点相关联来估计查询的进度。 然后,基于下限和上限参数估计给定点处的查询进度。

    INCREMENTAL REPAIR OF QUERY PLANS
    36.
    发明申请
    INCREMENTAL REPAIR OF QUERY PLANS 有权
    查询计划的增量修复

    公开(公告)号:US20080177694A1

    公开(公告)日:2008-07-24

    申请号:US11625153

    申请日:2007-01-19

    CPC classification number: G06F17/30463

    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 translation: 数据库系统使用计划缓存来避免查询重新编译的开销(如时间,金钱)。 通过对数据统计信息的更新或物理数据库设计更改,查询计划可能会失效。 一旦计划无效,可以利用所公开的一个或多个实施例来修复计划。 查询计划的增量修复包括重新使用当前计划的部分,而不是完全在无效的情况下丢弃计划。 在进行完全重新编译之前尝试修复现有的查询计划。

    Influence of engine parameters on condensation protection strategies
    37.
    发明授权
    Influence of engine parameters on condensation protection strategies 失效
    发动机参数对冷凝保护策略的影响

    公开(公告)号:US07079938B2

    公开(公告)日:2006-07-18

    申请号:US10627936

    申请日:2003-07-25

    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 translation: 一种用于内燃机的控制和方法,其包括排气再循环系统,以预测在进入废气再循环时会发生冷凝的进气歧管临界温度(露点)。 该控制通过处理变量被这些值占据的方程式来计算进气歧管临界温度(IMT_Critical)作为预定的,感测值或假定值的函数。 控制命令响应于计算,优选在实际进气歧管温度超过IMT_Critical预定时间之后调节废气再循环操作。

Patent Agency Ranking