MULTI-JOIN DATABASE QUERY
    3.
    发明申请
    MULTI-JOIN DATABASE QUERY 审中-公开
    多重数据库查询

    公开(公告)号:US20130185280A1

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

    申请号:US13349366

    申请日:2012-01-12

    IPC分类号: G06F17/30

    CPC分类号: G06F16/2456

    摘要: A method includes performing a query of a database. The query includes joining a first Domain-Model-sub-class table with a Domain-Model table based on identity attributes present in both the first Domain-Model-sub-class table and Domain-Model table to produce a first joined table. The query further includes joining the first joined table with an access control list (ACL) entry table based on an ACL object identity attribute present in both the first joined table and the ACL entry table to produce a second joined table. The query also includes joining the second joined table with a second Domain-Model-sub-class table based on an ACL security identity present in both the second joined table and the second Domain-Model-sub-class table to produce a third joined table.

    摘要翻译: 方法包括执行数据库的查询。 该查询包括基于存在于第一域模型子类表和域模型表中的身份属性将第一域模型子类表与域模型表加入以产生第一连接表。 所述查询还包括基于存在于所述第一连接表和所述ACL条目表中的ACL对象标识属性,将所述第一连接表加入到访问控制列表(ACL)条目表中,以产生第二连接表。 该查询还包括基于存在于第二连接表和第二域模型子类表中的ACL安全性身份,将第二联接表加入第二域模型子类表,以产生第三连接表 。