Extending dynamic matrices for improved setup capability and runtime search performance of complex business rules
    1.
    发明授权
    Extending dynamic matrices for improved setup capability and runtime search performance of complex business rules 有权
    扩展动态矩阵,以改进复杂业务规则的设置能力和运行时搜索性能

    公开(公告)号:US09305075B2

    公开(公告)日:2016-04-05

    申请号:US12474982

    申请日:2009-05-29

    CPC classification number: G06F17/30595

    Abstract: A mechanism by which rule attributes of varying types and numbers can be stored and searched in an efficient manner is provided by storing attribute values of each rule in a child table of a parent rule table. The child table is normalized and contains a foreign key pointing back to the parent rule table and has attribute-value pairs as table columns of the child table. Each rule is then represented by one row of the parent rule table and one or more corresponding rows of the child rule details table. A variable and unlimited number of attribute dimensions is supported among the rules, and search performance is improved through the use of database indexes on the rule details table attribute columns. Metadata representing the structure of the child rule details table will identify the data attributes for each dimension.

    Abstract translation: 通过将每个规则的属性值存储在父规则表的子表中来提供可以以有效的方式存储和搜索不同类型和数字的规则属性的机制。 子表被归一化,并包含指向父规则表的外键,并将属性值对作为子表的表列。 然后,每个规则由父规则表的一行和子规则详细信息表的一个或多个相应行表示。 在规则中支持变量和无限数量的属性维度,通过在规则详细信息表属性列上使用数据库索引来提高搜索性能。 表示子规则详细信息表结构的元数据将标识每个维度的数据属性。

    Extending Dynamic Matrices for Improved Setup Capability and Runtime Search Performance of Complex Business Rules
    2.
    发明申请
    Extending Dynamic Matrices for Improved Setup Capability and Runtime Search Performance of Complex Business Rules 有权
    扩展动态矩阵,提高复杂业务规则的安装能力和运行时搜索性能

    公开(公告)号:US20100306262A1

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

    申请号:US12474982

    申请日:2009-05-29

    CPC classification number: G06F17/30595

    Abstract: A mechanism by which rule attributes of varying types and numbers can be stored and searched in an efficient manner is provided by storing attribute values of each rule in a child table of a parent rule table. The child table is normalized and contains a foreign key pointing back to the parent rule table and has attribute-value pairs as table columns of the child table. Each rule is then represented by one row of the parent rule table and one or more corresponding rows of the child rule details table. A variable and unlimited number of attribute dimensions is supported among the rules, and search performance is improved through the use of database indexes on the rule details table attribute columns. Metadata representing the structure of the child rule details table will identify the data attributes for each dimension.

    Abstract translation: 通过将每个规则的属性值存储在父规则表的子表中来提供可以以有效的方式存储和搜索不同类型和数字的规则属性的机制。 子表被归一化,并包含指向父规则表的外键,并将属性值对作为子表的表列。 然后,每个规则由父规则表的一行和子规则详细信息表的一个或多个相应行表示。 在规则中支持变量和无限数量的属性维度,通过在规则详细信息表属性列上使用数据库索引来提高搜索性能。 表示子规则详细信息表结构的元数据将标识每个维度的数据属性。

Patent Agency Ranking