专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

31. 发明申请

US20150074140A1 SQL EXTENDED WITH TRANSIENT FIELDS FOR CALCULATION EXPRESSIONS IN ENHANCED DATA MODELS 有权
标题翻译：用于在增强数据模型中计算表达式的瞬态字段扩展的SQL
公开(公告)号：US20150074140A1
公开(公告)日：2015-03-12
申请号：US14020703
申请日：2013-09-06
申请人： Daniel Hutzel , Timm Falter , Stefan Baeuerle
发明人： Daniel Hutzel , Timm Falter , Stefan Baeuerle
IPC分类号： G06F17/30
CPC分类号： G06F17/30554 , G06F17/3041 , G06F17/30418 , G06F17/30501 , G06F17/30507 , G06F17/30604 , G06F17/30979
摘要： A database language (e.g. SQL) is extended to define a transient field whose value is derived from data stored in a database. The value of the transient field is calculated by the database engine for consumption as needed by the application layer, for example as part of a particular data model. The value of the transient field may not be materialized as a persistent field in the underlying database table, or may be selectively materialized based upon a heuristic or hint. Certain embodiments may implement the transient field as a basic elaboration on standard SQL utilizing an identifier. Some embodiments may implement the transient field as an entity where SQL has been extended to accommodate concepts of a higher-level Entity Relationship Model (ERM). The use of constants and/or floating values (e.g. a current time) in connection with transient fields, is also disclosed.
摘要翻译：数据库语言（例如SQL）被扩展以定义其值从存储在数据库中的数据导出的瞬态字段。瞬态字段的值由应用层需要的数据库引擎计算消耗，例如作为特定数据模型的一部分。瞬态字段的值可能不会实现为底层数据库表中的持久字段，也可能会根据启发式或提示进行选择性实现。某些实施例可以使用标识符来将瞬态字段实现为标准SQL的基本说明。一些实施例可以将瞬态字段实现为已经扩展了SQL以容纳更高级实体关系模型（ERM）的概念的实体。还公开了与瞬态场有关的常数和/或浮动值（例如当前时间）的使用。

32. 发明申请

US20150074139A1 Database Language Extended to Accommodate Entity-Relationship Models 有权
标题翻译：数据库语言扩展以容纳实体关系模型
公开(公告)号：US20150074139A1
公开(公告)日：2015-03-12
申请号：US14020509
申请日：2013-09-06
申请人： Timm Falter , Daniel Hutzel , Stefan Baeuerle , Andreas Gruenhagen
发明人： Timm Falter , Daniel Hutzel , Stefan Baeuerle , Andreas Gruenhagen
IPC分类号： G06F17/30
CPC分类号： G06F17/30424 , G06F17/30498 , G06F17/30604
摘要： Embodiments extend the relational model and language of standard SQL, to recognize features of higher level entity-relationship models (ERMs). SQL extensions implemented in the data design language (DDL) incorporate Entities (and Views) having custom-defined/semantic structure, rather than being limited to primitive types (e.g. flat tables as in standard SQL). Entities are defined similar to structured types with an underlying persistency, but with a uniquely identifying leading key. In DDL, these entities are combined with associations in the data model. The associations of the extended SQL reflect relationships between entities in the ERM. Associations are specified by adding an element to a source entity, with an association type pointing to a target entity. This may be complemented by providing optional information (e.g., cardinality, keys, filter conditions), up to a complete JOIN condition. In the query language (QL), JOINs may be replaced by the use of simple path expressions.
摘要翻译：实施例扩展了标准SQL的关系模型和语言，以识别更高级实体关系模型（ERM）的特征。以数据设计语言（DDL）实现的SQL扩展包含具有自定义/语义结构的实体（和视图），而不仅限于原始类型（例如标准SQL中的平面表）。实体被定义与具有底层持久性的结构化类型相似，但是具有唯一标识的引导键。在DDL中，这些实体与数据模型中的关联组合。扩展SQL的关联反映了企业风险管理实体之间的关系。通过向源实体添加元素来指定关联，关联类型指向目标实体。这可以通过提供高达完整的JOIN条件的可选信息（例如，基数，密钥，过滤条件）来补充。在查询语言（QL）中，可以使用简单的路径表达式替换JOIN。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式