ADAPTIVE FILTER INDEX FOR DETERMINING QUERIES AFFECTED BY A DML OPERATION
    21.
    发明申请
    ADAPTIVE FILTER INDEX FOR DETERMINING QUERIES AFFECTED BY A DML OPERATION 有权
    用于确定DML操作影响的自适应滤波器索引

    公开(公告)号:US20100036803A1

    公开(公告)日:2010-02-11

    申请号:US12326822

    申请日:2008-12-02

    IPC分类号: G06F7/06 G06F17/30

    CPC分类号: G06F17/3051

    摘要: Techniques are disclosed for creating and using a filter index in order to identify registered queries whose result sets are likely to have been changed by changes made to tables. The filter index entries are based on filter conditions. The filter conditions are created based on predicates contained in the registered queries. The filter conditions may include exclusive predicates and join predicates. Join predicates that join a table T1 with a table T2 may be instantiated by replacing references to table T2 with values extracted from table T2. Various techniques are described for recognizing situations in which a query can be included in, or excluded from, the set of likely-changed queries, without fully evaluating the filter conditions that correspond to the queries.

    摘要翻译: 公开了用于创建和使用过滤器索引的技术,以便识别其结果集可能由于对表的改变而改变的注册查询。 过滤器索引条目基于过滤器条件。 过滤条件是根据注册查询中包含的谓词创建的。 过滤条件可能包括排除谓词和连接谓词。 可以通过用从表T2提取的值替换对表T2的引用来实例化加入具有表T2的表T1的连接谓词。 描述各种技术用于识别其中可以将查询包括在可能改变的查询集合中或从可能改变的查询集合中排除的情况,而不完全评估与查询相对应的过滤条件。

    Extensible rules engine in a database management system
    22.
    发明授权
    Extensible rules engine in a database management system 有权
    数据库管理系统中的可扩展规则引擎

    公开(公告)号:US07366713B2

    公开(公告)日:2008-04-29

    申请号:US10418882

    申请日:2003-04-17

    IPC分类号: G06F17/30

    摘要: An extensible rules engine that uses database technology provides a rules evaluation service for applications external to the database server or database management system. Applications are able to utilize the rules engine to provide alternative behaviors based on information against which specified conditions are evaluated. A framework is provided for specifying data definitions that can be referenced by user-defined rules, through creation and use of an evaluation context. Application-specific data types can be defined by specifying data tables and/or variables that can be referenced by rules created for evaluation against data that is associated with the evaluation context. The data against which rules are evaluated can be provided as an in-memory object. A security model is provided in which the privilege to create rules according to a particular evaluation context is controlled by one privilege, whereas the privilege to access underlying tables or variables is controlled by another privilege.

    摘要翻译: 使用数据库技术的可扩展规则引擎为数据库服务器或数据库管理系统外部的应用程序提供规则评估服务。 应用程序能够利用规则引擎提供基于评估指定条件的信息的替代行为。 提供了一个框架,用于通过创建和使用评估上下文来指定可由用户定义的规则引用的数据定义。 应用程序特定的数据类型可以通过指定可以根据与评估上下文相关联的数据进行评估而创建的规则引用的数据表和/或变量来定义。 评估规则的数据可以作为内存中对象提供。 提供了一种安全模型,其中根据特定评估上下文创建规则的权限由一个权限控制,而访问基础表或变量的权限由另一个权限控制。

    Method and apparatus for making available data that was locked by a dead transaction before rolling back the entire dead transaction
    23.
    发明授权
    Method and apparatus for making available data that was locked by a dead transaction before rolling back the entire dead transaction 有权
    用于在回滚整个死锁事务之前使可用数据被死锁交易锁定的方法和装置

    公开(公告)号:US07237147B2

    公开(公告)日:2007-06-26

    申请号:US10650362

    申请日:2003-08-27

    IPC分类号: G06F11/00

    摘要: Described is an approach for recovering the failure of a transaction. According to the approach, a first change and a third change is made to a first resource and a second change is made to a second resource. The second change was made after the first but before the third. However, to recover the failure of the transaction, a recovery record for the third change is applied before the recovery record for the second change. Also described is an approach involving establishing links that link together a set of undo records that contain changes made to the particular resource. Also described is an approach for applying two or more undo records in parallel.

    摘要翻译: 描述了一种恢复交易失败的方法。 根据该方法,对第一资源进行第一改变和第三改变,并且对第二资源进行第二改变。 第二次改变是在第一次但是在第三次之前进行的。 但是,为了恢复事务的故障,在第二次更改的恢复记录之前应用第三次更改的恢复记录。 还描述了一种涉及建立将包含对特定资源所做的改变的一组撤销记录链接在一起的链接的方法。 还描述了并行应用两个或多个撤销记录的方法。

    File system for a plurality of storage classes
    24.
    发明授权
    File system for a plurality of storage classes 失效
    用于多个存储类的文件系统

    公开(公告)号:US5553285A

    公开(公告)日:1996-09-03

    申请号:US489267

    申请日:1995-06-09

    摘要: A file system for managing data files for access by a plurality of users of a data processing system that includes internal storage for buffering, external storage, and a file user interface by which the plurality of users request access to data files. A first level, coupled to the file user interface in the internal storage allocates the internal storage for temporary storage of data to be accessed by the plurality of users, and generates requests for transactions with external storage in support of such allocations. A second level is coupled to the first level and the external storage and responds to the request for transactions with the external storage for managing the transactions for storage of data to, and retrieval of data from, the external storage. The second level defines a plurality of physical storage classes which are characterized by pre-specified parameters that allocate data files subject of transactions to locations in external memory. In response to requests for transactions, the second level identifies one of the plurality of storage classes assigned to the data file subject of the transaction and carries out the transaction with the appropriate locations in external memory. At least one of the plurality of storage classes provides for utilization of a plurality of access paths in parallel for transactions involving data files assigned to such storage class. Further, at least one parameter pre-specified for storage classes identifies a level of reliability desired for the subject data files.

    摘要翻译: 一种用于管理数据文件的文件系统,用于由数据处理系统的多个用户访问,该数据处理系统包括用于缓冲的内部存储器,外部存储器和多个用户请求访问数据文件的文件用户界面。 耦合到内部存储器中的文件用户界面的第一级别分配内部存储器以临时存储由多个用户访问的数据,并且生成用于支持这种分配的与外部存储器的事务的请求。 第二级耦合到第一级和外部存储器,并且响应于与外部存储器的事务的请求,用于管理用于存储数据的事务和从外部存储器检索数据。 第二级定义了多个物理存储类别,其特征在于预先指定的参数,将事务对象分配给外部存储器中的位置。 响应于事务请求,第二级识别分配给事务的数据文件主体的多个存储类中的一个,并且在外部存储器中执行与适当位置的事务。 多个存储类别中的至少一个提供了并行地涉及涉及分配给这种存储类别的数据文件的事务的多个访问路径的使用。 此外,为存储类别预先规定的至少一个参数标识了对象数据文件所期望的可靠性水平。

    Two-stage valve
    25.
    发明授权
    Two-stage valve 失效
    两级阀

    公开(公告)号:US5239828A

    公开(公告)日:1993-08-31

    申请号:US951511

    申请日:1992-09-25

    申请人: Dieter Gawlick

    发明人: Dieter Gawlick

    CPC分类号: B60T11/224 B60T11/26

    摘要: A two-stage brake control valve has a larger first stage and a smaller second stage. First stage operates to fill a brake. Then, after a transition phase only the second stage is used to supply the working pressure. A check valve is between the first stage pressure chamber a sump. The check valve opens if the pressure in the first stage pressure chamber exceeds a predetermined value. To minimize the operating force of the valve and to avoid a sudden change of the valve working pressure during the changing phase, the closing force of the check valve is controlled as a function of the valve working pressure. The valve working pressure acts on a valve spool which influences the closing force of the check valve in the way that the closing force decreases with increasing working pressure.

    摘要翻译: 两级制动控制阀具有较大的第一级和较小的第二级。 第一阶段操作以填充刹车。 然后,在过渡阶段之后,仅使用第二阶段来提供工作压力。 止回阀位于第一级压力室之间的集油槽中。 如果第一级压力室中的压力超过预定值,则止回阀打开。 为了最小化阀的操作力并避免在变化阶段期间阀工作压力的突然变化,止回阀的关闭力作为阀工作压力的函数被控制。 阀工作压力作用在阀芯上,阀芯以闭合力随着工作压力的增加而减小而影响止回阀的关闭力。