DATA MODELS CONTAINING HOST LANGUAGE EMBEDDED CONSTRAINTS
    1.
    发明申请
    DATA MODELS CONTAINING HOST LANGUAGE EMBEDDED CONSTRAINTS 有权
    包含主机语言嵌入式约束的数据模型

    公开(公告)号:US20150074686A1

    公开(公告)日:2015-03-12

    申请号:US14020657

    申请日:2013-09-06

    IPC分类号: G06F9/54

    摘要: Techniques are described for expressing a constraint in a host language. A constraint can be defined in the host language as an event handler. The event handler can be registered to a built-in event associated with an object of the database that the constraint is intended to validate. When the object triggers the built-in event, the event handler is called to execute the constraint. Exemplary built-in events include onSave (trigger the event when the object is saved), onValidate (trigger the event when an explicit call to validate the object is detected), onInsert (trigger the event when the object is inserted), onUpdate (trigger the event when the object is updated), and onCheckBeforeSave (trigger the event when the object is checked prior to saving).

    摘要翻译: 描述用于在主机语言中表达约束的技术。 约束可以在主机语言中定义为事件处理程序。 可以将事件处理程序注册到与数据库的对象相关联的内置事件,该约束将用于验证。 当对象触发内置事件时,将调用事件处理程序来执行约束。 示例性的内置事件包括onSave(当保存对象时触发事件),onValidate(触发事件,当检测到验证对象的显式调用)时,onInsert(触发插入对象时的事件),onUpdate(trigger 当对象被更新时的事件)和onCheckBeforeSave(在保存之前检查对象时触发事件)。

    SQL ENHANCEMENTS SIMPLIFYING DATABASE QUERYING
    2.
    发明申请
    SQL ENHANCEMENTS SIMPLIFYING DATABASE QUERYING 有权
    SQL增强简化数据库查询

    公开(公告)号:US20150074083A1

    公开(公告)日:2015-03-12

    申请号:US14020610

    申请日:2013-09-06

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30418 G06F17/30604

    摘要: Disclosed are techniques employed alone or in combination, to further enhance a database language and improve conciseness and comprehensiveness of query statements in application code. Embodiments may build upon an initial extension of database language to accommodate concepts of entity-relationship models (ERMs). That initial extension may include entities with structured types, and named associations. One technique modifies SQL to allow the SELECT command to specify element path expressions based upon a relationship (e.g. named associations between ERM elements). Another technique modifies SQL to introduce filter expressions suffixed to associations within path expressions, thus improving adherence to the principle of locality within query statements. Yet another technique allows a shorthand to “factor out” association path prefixes, thereby avoiding lengthy lists of path expressions in order to read several elements from the same nested structure or a same target entity behind a single association. Other techniques simplifying database querying are also disclosed.

    摘要翻译: 公开的是单独使用或组合使用的技术,以进一步增强数据库语言,并提高应用程序代码中查询语句的简洁性和全面性。 实施例可以基于数据库语言的初始扩展来构建,以适应实体关系模型(ERM)的概念。 该初始扩展可能包括具有结构化类型的实体和命名关联。 一种技术修改SQL,以允许SELECT命令基于关系(例如,ERM元素之间的命名关联)来指定元素路径表达式。 另一种技术修改SQL来引入路径表达式中的关联后缀的过滤器表达式,从而提高对查询语句中局部性原则的遵守。 另一种技术允许“缩小”关联路径前缀的简写,从而避免路径表达式的冗长列表,以便从单个关联后面的相同嵌套结构或相同目标实体读取几个元素。 还公开了简化数据库查询的其他技术。

    Data models containing host language embedded constraints
    3.
    发明授权
    Data models containing host language embedded constraints 有权
    包含主机语言嵌入约束的数据模型

    公开(公告)号:US09354948B2

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

    申请号:US14020657

    申请日:2013-09-06

    摘要: Techniques are described for expressing a constraint in a host language. A constraint can be defined in the host language as an event handler. The event handler can be registered to a built-in event associated with an object of the database that the constraint is intended to validate. When the object triggers the built-in event, the event handler is called to execute the constraint. Exemplary built-in events include onSave (trigger the event when the object is saved), onValidate (trigger the event when an explicit call to validate the object is detected), onInsert (trigger the event when the object is inserted), onUpdate (trigger the event when the object is updated), and onCheckBeforeSave (trigger the event when the object is checked prior to saving).

    摘要翻译: 描述用于在主机语言中表达约束的技术。 约束可以在主机语言中定义为事件处理程序。 可以将事件处理程序注册到与数据库的对象相关联的内置事件,该约束将用于验证。 当对象触发内置事件时,将调用事件处理程序来执行约束。 示例性的内置事件包括onSave(当保存对象时触发事件),onValidate(触发事件,当检测到验证对象的显式调用)时,onInsert(触发插入对象时的事件),onUpdate(trigger 当对象被更新时的事件)和onCheckBeforeSave(在保存之前检查对象时触发事件)。

    SQL enhancements simplifying database querying

    公开(公告)号:US09639572B2

    公开(公告)日:2017-05-02

    申请号:US14020610

    申请日:2013-09-06

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30418 G06F17/30604

    摘要: Disclosed are techniques employed alone or in combination, to further enhance a database language and improve conciseness and comprehensiveness of query statements in application code. Embodiments may build upon an initial extension of database language to accommodate concepts of entity-relationship models (ERMs). That initial extension may include entities with structured types, and named associations. One technique modifies SQL to allow the SELECT command to specify element path expressions based upon a relationship (e.g. named associations between ERM elements). Another technique modifies SQL to introduce filter expressions suffixed to associations within path expressions, thus improving adherence to the principle of locality within query statements. Yet another technique allows a shorthand to “factor out” association path prefixes, thereby avoiding lengthy lists of path expressions in order to read several elements from the same nested structure or a same target entity behind a single association. Other techniques simplifying database querying are also disclosed.

    Core data services extensibility for entity-relationship models

    公开(公告)号:US09619552B2

    公开(公告)日:2017-04-11

    申请号:US14020675

    申请日:2013-09-06

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30604

    摘要: Embodiments extend the relational model and query language to recognize features of tables and higher level entity-relationship models (ERMs). Extension language is implemented in the data design language (DDL) to incorporate tables, entities (and views) having custom-defined/semantic structure, rather than being limited to primitive types (e.g. flat tables as in standard SQL). The extension language includes an indication that a query is to include all active elements for each table extension or entity extension that is active. The extension language can be chained to extend a table or entity that has been extended.

    LOCAL BUFFERS FOR EVENT HANDLERS
    8.
    发明申请
    LOCAL BUFFERS FOR EVENT HANDLERS 有权
    局部缓冲区为事件处理

    公开(公告)号:US20150074685A1

    公开(公告)日:2015-03-12

    申请号:US14020633

    申请日:2013-09-06

    IPC分类号: G06F9/54

    摘要: A technique is described for generating error buffer that includes errors from both a program and event handlers called by the program. A program in an event-driven environment triggers an event. In response to the triggered event, the program calls event handlers related to the event. The event handlers are executed and error messages generated during the execution are stored in a local error buffer. Upon completion of the event handlers, the local error buffers are returned to the program and the program merges the local error buffers with an error buffer associated with the program.

    摘要翻译: 描述了一种用于生成包含由程序调用的程序和事件处理程序的错误的错误缓冲区的技术。 事件驱动环境中的程序触发事件。 响应触发的事件,程序调用与事件相关的事件处理程序。 执行事件处理程序,并在执行期间生成的错误消息存储在本地错误缓冲区中。 完成事件处理程序后,将本地错误缓冲区返回给程序,程序将本地错误缓冲区与程序关联的错误缓冲区合并。

    CORE DATA SERVICES EXTENSIBILITY FOR ENTITY-RELATIONSHIP MODELS
    9.
    发明申请
    CORE DATA SERVICES EXTENSIBILITY FOR ENTITY-RELATIONSHIP MODELS 有权
    核心数据服务实体关系模型的可扩展性

    公开(公告)号:US20150074136A1

    公开(公告)日:2015-03-12

    申请号:US14020675

    申请日:2013-09-06

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30604

    摘要: Embodiments extend the relational model and query language to recognize features of tables and higher level entity-relationship models (ERMs). Extension language is implemented in the data design language (DDL) to incorporate tables, entities (and views) having custom-defined/semantic structure, rather than being limited to primitive types (e.g. flat tables as in standard SQL). The extension language includes an indication that a query is to include all active elements for each table extension or entity extension that is active. The extension language can be chained to extend a table or entity that has been extended.

    摘要翻译: 实施例扩展了关系模型和查询语言,以识别表格和更高级实体关系模型(ERM)的特征。 扩展语言在数据设计语言(DDL)中实现,以包含具有自定义/语义结构的表,实体(和视图),而不是限于原始类型(例如标准SQL中的平面表)。 扩展语言包括一个指示,即查询将包括活动的每个表扩展或实体扩展的所有活动元素。 扩展语言可以被链接以扩展已经被扩展的表或实体。

    ENTITY-RELATIONSHIP MODEL EXTENSIONS USING ANNOTATIONS
    10.
    发明申请
    ENTITY-RELATIONSHIP MODEL EXTENSIONS USING ANNOTATIONS 有权
    使用注释的实体关系模型扩展

    公开(公告)号:US20150074081A1

    公开(公告)日:2015-03-12

    申请号:US14020664

    申请日:2013-09-06

    IPC分类号: G06F17/30

    摘要: Embodiments extend the relational model and language of standard SQL, to recognize features of higher level entity-relationship models (ERMs). Annotation language is implemented in the data design language (DDL) to incorporate tables and entities Using DDL, annotations are typed structures of metadata. Annotations may be used for types, entities and elements. In the query language (QL), annotations may be added to the standard QL. A reflection program may use the metadata of the annotation language for reflection on the tables or entities.

    摘要翻译: 实施例扩展了标准SQL的关系模型和语言,以识别更高级实体关系模型(ERM)的特征。 注释语言在数据设计语言(DDL)中实现,以集成表和实体使用DDL,注释是元数据的类型化结构。 注释可用于类型,实体和元素。 在查询语言(QL)中,可以将标注添加到标准QL中。 反射程序可以使用注释语言的元数据来反映表或实体。