SADL query view—a model-driven approach to speed-up read-only use cases
    1.
    发明授权
    SADL query view—a model-driven approach to speed-up read-only use cases 有权
    SADL查询视图 - 一种以加速只读用例的模型驱动方法

    公开(公告)号:US08874601B2

    公开(公告)日:2014-10-28

    申请号:US12972157

    申请日:2010-12-17

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30389 G06F17/30421

    摘要: Embodiments of the invention relate to computing, and in particular, to a systems and methods for a querying a database. Certain embodiments implement a model-driven database query (“the SADL query”) facilitating a design-time tool that allows a developer to create the query based upon existing Business Objects (BOs) and their associations. This SADL query leverages mapping between business-layer entities and database-layer entities, such mapping being derived from association metadata already extant in the business model used to create the Business Objects. In certain embodiments, query views may be based upon associations present within the business layer, rather than upon database-level entities (such as joins or restriction rules) that are typically relied upon in conventional query creation. Embodiments of the present invention may thus align query creation more closely with the structure of the business layer, and may also render query design agnostic relative to the identity of the underlying database.

    摘要翻译: 本发明的实施例涉及计算,特别是涉及用于查询数据库的系统和方法。 某些实施例实现了一种促进设计时工具的模型驱动数据库查询(“SADL查询”),该工具允许开发人员基于现有的业务对象(BO)及其关联来创建查询。 该SADL查询利用业务层实体和数据库层实体之间的映射,这种映射是从已经在用于创建业务对象的业务模型中已经存在的关联元数据导出的。 在某些实施例中,查询视图可以基于存在于业务层内的关联而不是在常规查询创建中通常依赖的数据库级实体(例如连接或限制规则)。 因此,本发明的实施例可以使查询创建与业务层的结构更紧密地对齐,并且还可以使查询设计相对于底层数据库的身份不可知。

    SADL Query View - A Model-Driven Approach to Speed-Up Read-Only Use Cases
    2.
    发明申请
    SADL Query View - A Model-Driven Approach to Speed-Up Read-Only Use Cases 有权
    SADL查询视图 - 以加速只读用例为例的模型驱动方法

    公开(公告)号:US20120158797A1

    公开(公告)日:2012-06-21

    申请号:US12972157

    申请日:2010-12-17

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30389 G06F17/30421

    摘要: Embodiments of the invention relate to computing, and in particular, to a systems and methods for a querying a database. Certain embodiments implement a model-driven database query (“the SADL query”) facilitating a design-time tool that allows a developer to create the query based upon existing Business Objects (BOs) and their associations. This SADL query leverages mapping between business-layer entities and database-layer entities, such mapping being derived from association metadata already extant in the business model used to create the Business Objects. In certain embodiments, query views may be based upon associations present within the business layer, rather than upon database-level entities (such as joins or restriction rules) that are typically relied upon in conventional query creation. Embodiments of the present invention may thus align query creation more closely with the structure of the business layer, and may also render query design agnostic relative to the identity of the underlying database.

    摘要翻译: 本发明的实施例涉及计算,特别是涉及用于查询数据库的系统和方法。 某些实施例实现了一种促进设计时工具的模型驱动数据库查询(“SADL查询”),该工具允许开发人员基于现有的业务对象(BO)及其关联来创建查询。 该SADL查询利用业务层实体和数据库层实体之间的映射,这种映射是从已经在用于创建业务对象的业务模型中已经存在的关联元数据导出的。 在某些实施例中,查询视图可以基于存在于业务层内的关联而不是在传统查询创建中通常依赖的数据库级实体(例如连接或限制规则)。 因此,本发明的实施例可以使查询创建与业务层的结构更紧密地对齐,并且还可以使查询设计相对于底层数据库的身份不可知。