公开(公告)号：US09342555B2

公开(公告)日：2016-05-17

申请号：US14015105

申请日：2013-08-30

申请人： International Business Machines Corporation

发明人： Cassio S. Dos Santos ,  Kunjavihari M. Kashalikar ,  Jean-Claude Mamou ,  Kishore Patel ,  Rong Qu ,  Hong X. Zhang

IPC分类号： G06F17/30

CPC分类号： G06F17/30424 ,  G06F17/30294 ,  G06F17/30418

摘要： A view schema is generated from a view definition, wherein the view schema includes one or more relational views that are created by translating one or more object queries in the view definition into one or more relational queries. A report design schema is generated from the view definition by: creating one or more report tables that correspond to the one or more relational views of the view schema and extending the one or more report tables with one or more primary key constraints and one or more foreign key constraints. A reporting model is generated by reverse engineering the report design schema, wherein the reporting model includes the one or more primary key constraints and the one or more foreign key constraints. A report is generated using the reporting model, wherein the report includes the one or more primary key constraints and the one or more foreign key constraints.

摘要翻译： 从视图定义生成视图模式，其中视图模式包括通过将视图定义中的一个或多个对象查询转换成一个或多个关系查询而创建的一个或多个关系视图。 通过以下方式从视图定义生成报告设计模式：创建一个或多个与视图模式的一个或多个关系视图对应的报表，并扩展一个或多个主键约束和一个或多个主键约束的报表 外键限制。 通过对报告设计模式进行逆向工程来生成报告模型，其中报告模型包括一个或多个主键约束和一个或多个外键约束。 使用报告模型生成报告，其中报告包括一个或多个主键约束和一个或多个外键约束。

公开(公告)号：US20160057147A1

公开(公告)日：2016-02-25

申请号：US14930056

申请日：2015-11-02

申请人： Red Hat Israel, Ltd.

发明人： Allon Mureinik

IPC分类号： H04L29/06 ,  G06F17/30 ,  G06F9/455 ,  G06F21/60 ,  G06F21/62

CPC分类号： H04L63/10 ,  G06F9/45558 ,  G06F17/30327 ,  G06F17/30418 ,  G06F17/30424 ,  G06F17/30457 ,  G06F21/00 ,  G06F21/121 ,  G06F21/31 ,  G06F21/53 ,  G06F21/604 ,  G06F21/6218 ,  G06F21/6227 ,  G06F21/629 ,  G06F2009/45587 ,  G06F2221/2141 ,  G06F2221/2145 ,  H04L63/101 ,  H04L63/102 ,  H04L63/104 ,  H04L63/105 ,  H04W12/08

摘要： A processing device receives a permission request indicating a user and an entity. The processing device modifies a permissions database to generate a modified database view. Using the modified database view, the processing device determines whether the user has permission to access the entity and returns an indication of whether the user has permission to access the entity.

摘要翻译： 处理装置接收指示用户和实体的许可请求。 处理设备修改权限数据库以生成修改的数据库视图。 使用修改的数据库视图，处理设备确定用户是否具有访问实体的权限，并返回用户是否具有访问实体的权限的指示。

公开(公告)号：US09081819B2

公开(公告)日：2015-07-14

申请号：US13671523

申请日：2012-11-07

申请人： Oracle International Corporation

发明人： Terry M. Olkin ,  Alok Srivastava

IPC分类号： G06F7/00 ,  G06F17/30 ,  G06Q10/10

CPC分类号： G06F17/30513 ,  G06F17/30418 ,  G06Q10/10

摘要： Techniques are provided for using bonds, which reflect relationships between items, to facilitate searches against the items. The degree of separation between any two given searchable items is based on the minimum number of bonds that have to be traversed to arrive at one of the two searchable items when starting at the other of the two searchable items. The bonds are used to respond to a search request, performing a search relative to a particular searchable item. For example, the search may involve only those searchable items that are within a particular degree of separation of the particular searchable item. As another example, the search may involve determining the order in which searchable items are compared against search criteria of the search request based on the degree of separation of the searchable items from the particular searchable item.

摘要翻译： 提供了使用债券的技术，其反映了项目之间的关系，以便于搜索项目。 任何两个给定的可搜索项目之间的分离程度是基于当在两个可搜索项目中的另一个开始时必须遍历的最小的绑定数量到达两个可搜索项目之一。 这些债券用于响应搜索请求，执行相对于特定可搜索项目的搜索。 例如，搜索可以仅涉及在特定搜索项目的特定分离度范围内的那些可搜索项目。 作为另一示例，搜索可以涉及基于可搜索项目与特定可搜索项目的分离程度来确定可搜索项目与搜索请求的搜索条件进行比较的顺序。

公开(公告)号：US20150193479A1

公开(公告)日：2015-07-09

申请号：US14533019

申请日：2014-11-04

申请人： International Business Machines Corporation

发明人： Jeffrey M. Fischer ,  John C. Holmes ,  Jeff J. Li ,  Yong Li

IPC分类号： G06F17/30

CPC分类号： G06F17/30292 ,  G06F17/30418

摘要： Provided are a computer program product, system, and method for limiting the rendering of instances of recursive elements in view output. A schema provides a definition of elements, wherein at least one of the elements comprises a recursive element of a recursive data type, wherein the recursive data type allows for instances of the recursive element to include instances of that same recursive data type at different levels in a hierarchy. A condition is received for terminating recursion for the recursive element. A view is generated for the schema including information on the condition for terminating the recursion, wherein the processing of the view causes a parser to chunk instances of the recursive element in schema data in response to the condition indicating to terminate recursion at the level of the instance of the recursive element being processed.

公开(公告)号：US09053151B2

公开(公告)日：2015-06-09

申请号：US12847295

申请日：2010-07-30

申请人： Oliver Vossen ,  Martin Müller ,  Maic Wintel

发明人： Oliver Vossen ,  Martin Müller ,  Maic Wintel

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F17/30498 ,  G06F17/30418 ,  G06F17/30501

摘要： According to some embodiments, an anchor transactional view may be defined for at least one business object data structure. The anchor transactional may have a plurality of anchor fields, each anchor field representing a data source and being associated with a field of an anchor search view. An indication of at least one extension field to the anchor search view may be received. The anchor search view and at least one extension field may represent, for example, a virtual fast search infrastructure view. Responsive to the received indication of the at least one extension field, an additional view may be dynamically joined at runtime to the anchor transactional view. The additional view may have at least one additional field, and each additional field may be associated with one of the extension fields.

摘要翻译： 根据一些实施例，可以为至少一个业务对象数据结构定义锚定事务视图。 锚定事务可以具有多个锚定字段，每个锚定字段表示数据源并与锚搜索视图的字段相关联。 可以接收到锚搜索视图的至少一个扩展字段的指示。 锚搜索视图和至少一个扩展字段可以表示例如虚拟快速搜索基础设施视图。 响应于接收到的至少一个扩展字段的指示，附加视图可以在运行时被动态地连接到锚事务视图。 附加视图可以具有至少一个附加字段，并且每个附加字段可以与扩展字段之一相关联。

公开(公告)号：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）的概念的实体。 还公开了与瞬态场有关的常数和/或浮动值（例如当前时间）的使用。

公开(公告)号：US20150066975A1

公开(公告)日：2015-03-05

申请号：US14015105

申请日：2013-08-30

申请人： International Business Machines Corporation

发明人： Cassio S. DOS SANTOS ,  Kunjavihari M. KASHALIKAR ,  Jean-Claude Mamou ,  Kishore Patel ,  Rong Qu ,  Hong X. Zhang

IPC分类号： G06F17/30

CPC分类号： G06F17/30424 ,  G06F17/30294 ,  G06F17/30418

摘要： A view schema is generated from a view definition, wherein the view schema includes one or more relational views that are created by translating one or more object queries in the view definition into one or more relational queries. A report design schema is generated from the view definition by: creating one or more report tables that correspond to the one or more relational views of the view schema and extending the one or more report tables with one or more primary key constraints and one or more foreign key constraints. A reporting model is generated by reverse engineering the report design schema, wherein the reporting model includes the one or more primary key constraints and the one or more foreign key constraints. A report is generated using the reporting model, wherein the report includes the one or more primary key constraints and the one or more foreign key constraints.

摘要翻译： 从视图定义生成视图模式，其中视图模式包括通过将视图定义中的一个或多个对象查询转换成一个或多个关系查询而创建的一个或多个关系视图。 通过以下方式从视图定义生成报告设计模式：创建一个或多个与视图模式的一个或多个关系视图对应的报表，并扩展一个或多个主键约束和一个或多个主键约束的报表 外键限制。 通过对报告设计模式进行逆向工程来生成报告模型，其中报告模型包括一个或多个主键约束和一个或多个外键约束。 使用报告模型生成报告，其中报告包括一个或多个主键约束和一个或多个外键约束。

公开(公告)号：US20140280308A1

公开(公告)日：2014-09-18

申请号：US13843220

申请日：2013-03-15

申请人： INTERNATIONAL BUSINESS MACHINES CORPORATION

发明人： Allan T. Chandler

IPC分类号： G06F17/30

CPC分类号： G06F17/30595 ,  G06F17/30418

摘要： An approach is provided to expand attributes included in an SQL expansion clause into a number of selection statements. In the approach, an expansion clause is identified in within a Structured Query Language (SQL) statement with the SQL statement identifying a relational database table. Column attributes associated with the identified relational database table are compared to attributes included in the identified expansion clause. Columns included in the relational database table are then selected based on the comparison. SQL column selection statements are then generated with each of the generated SQL column selection statements corresponding to one of the selected columns. The generated SQL column selection statements are then included in the SQL statement.

摘要翻译： 提供了一种方法来将包含在SQL扩展子句中的属性扩展为多个选择语句。 在该方法中，在结构化查询语言（SQL）语句中标识扩展子句，SQL语句标识关系数据库表。 与所标识的关系数据库表相关联的列属性与包含在标识的扩展子句中的属性进行比较。 然后根据比较选择关系数据库表中包含的列。 然后生成SQL列选择语句，其中每个生成的SQL列选择语句对应于所选列之一。 然后，生成的SQL列选择语句将包含在SQL语句中。

公开(公告)号：US20140280029A1

公开(公告)日：2014-09-18

申请号：US13826726

申请日：2013-03-14

申请人： ORACLE INTERNATIONAL CORPORATION

发明人： Luping Ding ,  Tsae-Feng Yu ,  Andrew Witkowski

IPC分类号： G06F17/30

CPC分类号： G06F17/30457 ,  G06F17/30383 ,  G06F17/30418

摘要： Techniques are provided for performing a refresh or update of a materialized view without modifying the materialized view. Such a refresh is referred to as an out-of-place materialized view refresh. An out-of-place materialized view refresh involves creating one or more outside tables into which data will be inserted. During the refresh, the materialized view may be accessible for query processing, even though the materialized view contains “stale” data. After the insertion, the one or more outside tables are made accessible for query processing and future queries will target the one or more outside tables instead of the materialized view.

摘要翻译： 提供了用于执行物化视图的刷新或更新而不修改实例化视图的技术。 这种刷新被称为不合适的物化视图刷新。 不合适的物化视图刷新涉及创建一个或多个外部表，数据将被插入到其中。 在刷新期间，即使物化视图包含“过时”数据，物化视图也可以访问查询处理。 插入后，一个或多个外部表格可访问以进行查询处理，并且将来的查询将针对一个或多个外部表格而不是物化视图。

公开(公告)号：US20140143267A1

公开(公告)日：2014-05-22

申请号：US14166437

申请日：2014-01-28

申请人： Microsoft Corporation

发明人： Anthony Nino Bice ,  David Robinson ,  Harihan Sivaramakrishnan

IPC分类号： G06F17/30

CPC分类号： G06F17/30528 ,  G06F17/30395 ,  G06F17/30418 ,  G06F17/3043 ,  G06F17/30867

摘要： The subject disclosure is directed towards enriching database query responses using data from external data sources. When processing a database query seeking enriched data from an external data source, a request is communicated to the external data source based on the database query. An enriched database query response is generated based on data provided by the external data source. The enriched database query response may be combined with data returned via an internal database query operation, and/or inserted into a local database table.

摘要翻译： 主题公开旨在使用来自外部数据源的数据丰富数据库查询响应。 当处理从外部数据源寻求富集数据的数据库查询时，基于数据库查询将请求传送到外部数据源。 基于由外部数据源提供的数据生成丰富的数据库查询响应。 丰富的数据库查询响应可以与通过内部数据库查询操作返回的数据组合，和/或插入到本地数据库表中。