-
公开(公告)号:US20150074686A1
公开(公告)日:2015-03-12
申请号:US14020657
申请日:2013-09-06
申请人: Stefan Baeuerle , Timm Falter , Daniel Hutzel , Lior Schejter
发明人: Stefan Baeuerle , Timm Falter , Daniel Hutzel , Lior Schejter
IPC分类号: G06F9/54
CPC分类号: G06F9/542 , G06F11/30 , G06F11/36 , G06F17/30371
摘要: 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(在保存之前检查对象时触发事件)。
-
公开(公告)号:US20150074083A1
公开(公告)日:2015-03-12
申请号:US14020610
申请日:2013-09-06
申请人: Daniel Hutzel , Timm Falter , Stefan Baeuerle
发明人: Daniel Hutzel , Timm Falter , Stefan Baeuerle
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来引入路径表达式中的关联后缀的过滤器表达式,从而提高对查询语句中局部性原则的遵守。 另一种技术允许“缩小”关联路径前缀的简写,从而避免路径表达式的冗长列表,以便从单个关联后面的相同嵌套结构或相同目标实体读取几个元素。 还公开了简化数据库查询的其他技术。
-
公开(公告)号:US09354948B2
公开(公告)日:2016-05-31
申请号:US14020657
申请日:2013-09-06
申请人: Stefan Baeuerle , Timm Falter , Daniel Hutzel , Lior Schejter
发明人: Stefan Baeuerle , Timm Falter , Daniel Hutzel , Lior Schejter
CPC分类号: G06F9/542 , G06F11/30 , G06F11/36 , G06F17/30371
摘要: 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(在保存之前检查对象时触发事件)。
-
4.
公开(公告)号:US20150074069A1
公开(公告)日:2015-03-12
申请号:US14020672
申请日:2013-09-06
申请人: Stefan Baeuerle , Timm Falter , Daniel Hutzel , Lior Schejter , Daniel Zoch , Andreas Bader
发明人: Stefan Baeuerle , Timm Falter , Daniel Hutzel , Lior Schejter , Daniel Zoch , Andreas Bader
CPC分类号: G06F11/0751 , G06F8/35 , G06F8/41 , G06F17/30294 , G06F17/30371 , G06F17/30424 , G06F17/3051
摘要: A database language is extended to define constraints on a data model (e.g., entity-relationship model) rather than the concrete database. The constraints can be declarative (e.g., constraints that are defined using expressions of the database language) or programmatic (e.g., constraints that are defined as a stored procedure implemented in a domain specific language). By storing the constraints at a higher level than the database level, the constraints can be performed without changing the persistency of the database. Also disclosed are techniques for handling of constraints on partially loaded entities.
摘要翻译: 扩展数据库语言以定义数据模型的约束(例如,实体关系模型),而不是具体的数据库。 约束可以是声明性的(例如,使用数据库语言的表达式定义的约束)或程序化(例如,被定义为以域特定语言实现的存储过程的约束)。 通过将约束存储在比数据库级更高的级别,可以执行约束而不改变数据库的持久性。 还公开了用于处理部分加载的实体上的约束的技术。
-
公开(公告)号:US09639572B2
公开(公告)日:2017-05-02
申请号:US14020610
申请日:2013-09-06
申请人: Daniel Hutzel , Timm Falter , Stefan Baeuerle
发明人: Daniel Hutzel , Timm Falter , Stefan Baeuerle
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.
-
公开(公告)号:US09619552B2
公开(公告)日:2017-04-11
申请号:US14020675
申请日:2013-09-06
申请人: Timm Falter , Daniel Hutzel , Stefan Baeuerle
发明人: Timm Falter , Daniel Hutzel , Stefan Baeuerle
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.
-
7.
公开(公告)号:US09176801B2
公开(公告)日:2015-11-03
申请号:US14020672
申请日:2013-09-06
申请人: Stefan Baeuerle , Timm Falter , Daniel Hutzel , Lior Schejter , Daniel Zoch , Andreas Bader
发明人: Stefan Baeuerle , Timm Falter , Daniel Hutzel , Lior Schejter , Daniel Zoch , Andreas Bader
CPC分类号: G06F11/0751 , G06F8/35 , G06F8/41 , G06F17/30294 , G06F17/30371 , G06F17/30424 , G06F17/3051
摘要: A database language is extended to define constraints on a data model (e.g., entity-relationship model) rather than the concrete database. The constraints can be declarative (e.g., constraints that are defined using expressions of the database language) or programmatic (e.g., constraints that are defined as a stored procedure implemented in a domain specific language). By storing the constraints at a higher level than the database level, the constraints can be performed without changing the persistency of the database. Also disclosed are techniques for handling of constraints on partially loaded entities.
摘要翻译: 扩展数据库语言以定义数据模型的约束(例如,实体关系模型),而不是具体的数据库。 约束可以是声明性的(例如,使用数据库语言的表达式定义的约束)或程序化(例如,被定义为以域特定语言实现的存储过程的约束)。 通过将约束存储在比数据库级更高的级别,可以执行约束而不改变数据库的持久性。 还公开了用于处理部分加载的实体上的约束的技术。
-
公开(公告)号:US20150074685A1
公开(公告)日:2015-03-12
申请号:US14020633
申请日:2013-09-06
申请人: Stefan Baeuerle , Timm Falter , Daniel Hutzel
发明人: Stefan Baeuerle , Timm Falter , Daniel Hutzel
IPC分类号: G06F9/54
CPC分类号: G06F9/542 , G06F9/5016 , G06F11/0706 , G06F11/0778 , G06F11/0793
摘要: 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.
摘要翻译: 描述了一种用于生成包含由程序调用的程序和事件处理程序的错误的错误缓冲区的技术。 事件驱动环境中的程序触发事件。 响应触发的事件,程序调用与事件相关的事件处理程序。 执行事件处理程序,并在执行期间生成的错误消息存储在本地错误缓冲区中。 完成事件处理程序后,将本地错误缓冲区返回给程序,程序将本地错误缓冲区与程序关联的错误缓冲区合并。
-
公开(公告)号:US20150074136A1
公开(公告)日:2015-03-12
申请号:US14020675
申请日:2013-09-06
申请人: Timm Falter , Daniel Hutzel , Stefan Baeuerle
发明人: Timm Falter , Daniel Hutzel , Stefan Baeuerle
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中的平面表)。 扩展语言包括一个指示,即查询将包括活动的每个表扩展或实体扩展的所有活动元素。 扩展语言可以被链接以扩展已经被扩展的表或实体。
-
公开(公告)号:US20150074081A1
公开(公告)日:2015-03-12
申请号:US14020664
申请日:2013-09-06
申请人: Timm Falter , Daniel Hutzel , Stefan Baeuerle
发明人: Timm Falter , Daniel Hutzel , Stefan Baeuerle
IPC分类号: G06F17/30
CPC分类号: G06F17/30404 , G06F17/30424 , G06F17/30427 , G06F17/30525 , G06F17/30595 , G06F17/30604
摘要: 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中。 反射程序可以使用注释语言的元数据来反映表或实体。
-
-
-
-
-
-
-
-
-