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

1. 发明授权

US08918434B2 Optimizing sparse schema-less data in relational stores 有权
标题翻译：优化关系存储中的稀疏无模式数据
公开(公告)号：US08918434B2
公开(公告)日：2014-12-23
申请号：US13454559
申请日：2012-04-24
申请人： Bishwaranjan Bhattacharjee , Mihaela Ancuta Bornea , Patrick Dantressangle , Julian Dolby , Kavitha Srinivas , Octavian Udrea
发明人： Bishwaranjan Bhattacharjee , Mihaela Ancuta Bornea , Patrick Dantressangle , Julian Dolby , Kavitha Srinivas , Octavian Udrea
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F17/30292
摘要： Various embodiments of the invention relate to optimizing storage of schema-less data. A schema-less dataset including a plurality of resources is received. Each resource is associated with at least a plurality of properties. At least one set of co-occurring properties from the plurality of properties is identified. A graph including a plurality of nodes is generated. Each of the nodes represents a unique property in the set of co-occurring properties. The graph further includes an edge connecting each node representing a pair of co-occurring properties. A graph coloring operation is performed on the graph. The graph coloring operation includes assigning each of nodes to a color, where nodes connected by an edge are assigned different colors. A schema is generated that assigns a column identifier from a table to each unique property represented by one of the nodes in the graph based on the color assigned to the node.
摘要翻译：本发明的各种实施例涉及优化无模式数据的存储。接收包括多个资源的无模式数据集。每个资源与至少多个属性相关联。识别来自多个属性的至少一组共同属性。生成包括多个节点的图形。每个节点表示共同出现属性集中的唯一属性。该图还包括连接表示一对共同属性的每个节点的边缘。在图表上执行图形着色操作。图形着色操作包括将每个节点分配给颜色，其中通过边缘连接的节点被分配不同的颜色。生成一种模式，该模式根据分配给该节点的颜色，将表中的列标识符从图中的一个节点分配给每个唯一属性。

2. 发明授权

US09183260B2 Node-level sub-queries in distributed databases 有权
标题翻译：分布式数据库中的节点级子查询
公开(公告)号：US09183260B2
公开(公告)日：2015-11-10
申请号：US12248304
申请日：2008-10-09
申请人： Graham A. Bent , Patrick Dantressangle , David R. Vyvyan
发明人： Graham A. Bent , Patrick Dantressangle , David R. Vyvyan
IPC分类号： G06F17/30
CPC分类号： G06F17/30545 , G06F17/30339
摘要： A database query is received that includes a logical query indicator at a distributed database node within a distributed network of databases. The logical query indicator includes at least one physical database query and at least one database node identifier that allows at least one distributed database node to identify at least one physical database to execute the physical database query against. It is determined that the at least one database node identifier matches a local node identifier. The at least one physical database query is executed against at least one local physical database table. A local query response is formed including data retrieved from the at least one local physical database table. The database query is responded to with at least the local query response. This abstract is not to be considered limiting, since other embodiments may deviate from the features described in this abstract.
摘要翻译：在数据库的分布式网络中的分布式数据库节点处接收包括逻辑查询指示符的数据库查询。逻辑查询指示符包括至少一个物理数据库查询和至少一个数据库节点标识符，其允许至少一个分布式数据库节点识别至少一个物理数据库以执行物理数据库查询。确定至少一个数据库节点标识符与本地节点标识符匹配。对至少一个本地物理数据库表执行至少一个物理数据库查询。形成包括从至少一个本地物理数据库表检索的数据的本地查询响应。数据库查询至少响应本地查询响应。该摘要不被认为是限制性的，因为其他实施例可能偏离本摘要中描述的特征。

3. 发明申请

US20120310874A1 Determination of Rules by Providing Data Records in Columnar Data Structures 失效
标题翻译：通过在列数据结构中提供数据记录来确定规则
公开(公告)号：US20120310874A1
公开(公告)日：2012-12-06
申请号：US13465210
申请日：2012-05-07
申请人： Patrick Dantressangle , Eberhard Hechler , Martin Oberhofer , Michael Wurst
发明人： Patrick Dantressangle , Eberhard Hechler , Martin Oberhofer , Michael Wurst
IPC分类号： G06F17/30
CPC分类号： G06F17/30321 , G06F17/30315
摘要： A method includes providing a columnar database comprising a plurality of columnar data structures associated with one column attribute; providing first data records having a plurality of first attribute-value pairs comprising counting information indicative of a number of first data records having the respective first attribute-value pair; providing mask data structures comprising one or more second attribute-value pairs; selecting second data records by intersecting the columnar data structures and the mask data structures; selecting one of the column attributes and one value contained in the column data structure associated with said selected column attribute as the destination attribute-value pair; creating one second rule for each first attribute-value pair; calculating, for each second rule, a co-occurrence-count between its respective source attribute-value pair and its destination attribute-value pair; and specifically selecting one or more of said second rules as the first rules in dependence on the calculated co-occurrence-count.
摘要翻译：一种方法包括提供一个包括与一个列属性相关联的多个列数据结构的列数据库; 提供具有多个第一属性值对的第一数据记录，所述第一属性值对包括表示具有相应的第一属性值对的第一数据记录的数量的计数信息; 提供包括一个或多个第二属性值对的掩码数据结构; 通过与列数据结构和掩模数据结构相交来选择第二数据记录; 选择所述列属性之一和包含在与所述列列属性相关联的列数据结构中的一个值作为目标属性值对; 为每个第一个属性值对创建一个第二个规则; 对于每个第二规则，计算其各自的源属性值对与其目的地属性值对之间的共同计数; 并且具体地根据所计算的同现计数来选择所述第二规则中的一个或多个作为第一规则。

4. 发明授权

US08145652B2 Automated propagation of non-conflicting queries in distributed databases 失效
标题翻译：在分布式数据库中自动传播非冲突查询
公开(公告)号：US08145652B2
公开(公告)日：2012-03-27
申请号：US12248082
申请日：2008-10-09
申请人： Graham A. Bent , Patrick Dantressangle , David R. Vyvyan
发明人： Graham A. Bent , Patrick Dantressangle , David R. Vyvyan
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30545
摘要： A logical table definition is received in association with a database query within a distributed database system. A determination is made as to whether the received logical table definition matches a local logical table definition. The query is processed in response to determining that the received logical table definition matches the local logical table definition. The query is forwarded to at least one other distributed database node. This abstract is not to be considered limiting, since other embodiments may deviate from the features described in this abstract.
摘要翻译：与分布式数据库系统中的数据库查询相关联地接收逻辑表定义。确定接收到的逻辑表定义是否与本地逻辑表定义相匹配。响应于确定接收到的逻辑表定义与本地逻辑表定义相匹配来处理查询。该查询被转发到至少一个其他分布式数据库节点。该摘要不被认为是限制性的，因为其他实施例可能偏离本摘要中描述的特征。

5. 发明申请

US20100094862A1 AUTOMATED QUERY PATH REPORTING IN DISTRIBUTED DATABASES 失效
标题翻译：在分布式数据库中自动查询路径报告
公开(公告)号：US20100094862A1
公开(公告)日：2010-04-15
申请号：US12248170
申请日：2008-10-09
申请人： Graham A. Bent , Patrick Dantressangle , David R. Vyvyan
发明人： Graham A. Bent , Patrick Dantressangle , David R. Vyvyan
IPC分类号： G06F17/30
CPC分类号： G06F17/30545
摘要： A database query comprising a logical table definition and at least one route tracing indicator is forwarded to at least one distributed database node within a distributed network of databases. At least one query response is received including distributed route tracing information associated with each distributed database node that processed the database query along a path associated with the at least one query response. The received distributed route tracing information is processed to characterize query route propagation within the distributed network of databases. This abstract is not to be considered limiting, since other embodiments may deviate from the features described in this abstract.
摘要翻译：包括逻辑表定义和至少一个路由跟踪指示符的数据库查询被转发到分布式数据库网络内的至少一个分布式数据库节点。接收至少一个查询响应，包括与沿着与至少一个查询响应相关联的路径处理数据库查询的每个分布式数据库节点相关联的分布式路由跟踪信息。处理接收到的分布式路由跟踪信息，以表征分布式数据库网络内的查询路由传播。该摘要不被认为是限制性的，因为其他实施例可能偏离本摘要中描述的特征。

6. 发明授权

US08671111B2 Determination of rules by providing data records in columnar data structures 失效
标题翻译：通过在柱状数据结构中提供数据记录来确定规则
公开(公告)号：US08671111B2
公开(公告)日：2014-03-11
申请号：US13465210
申请日：2012-05-07
申请人： Patrick Dantressangle , Eberhard Hechler , Martin Oberhofer , Michael Wurst
发明人： Patrick Dantressangle , Eberhard Hechler , Martin Oberhofer , Michael Wurst
IPC分类号： G06F17/30
CPC分类号： G06F17/30321 , G06F17/30315
摘要： A method includes providing a columnar database comprising a plurality of columnar data structures associated with one column attribute; providing first data records having a plurality of first attribute-value pairs comprising counting information indicative of a number of first data records having the respective first attribute-value pair; providing mask data structures comprising one or more second attribute-value pairs; selecting second data records by intersecting the columnar data structures and the mask data structures; selecting one of the column attributes and one value contained in the column data structure associated with said selected column attribute as the destination attribute-value pair; creating one second rule for each first attribute-value pair; calculating, for each second rule, a co-occurrence-count between its respective source attribute-value pair and its destination attribute-value pair; and specifically selecting one or more of said second rules as the first rules in dependence on the calculated co-occurrence-count.
摘要翻译：一种方法包括提供一个包括与一个列属性相关联的多个列数据结构的列数据库; 提供具有多个第一属性值对的第一数据记录，所述第一属性值对包括表示具有相应的第一属性值对的第一数据记录的数量的计数信息; 提供包括一个或多个第二属性值对的掩码数据结构; 通过与列数据结构和掩模数据结构相交来选择第二数据记录; 选择所述列属性之一和包含在与所述列列属性相关联的列数据结构中的一个值作为目标属性值对; 为每个第一个属性值对创建一个第二个规则; 对于每个第二规则，计算其各自的源属性值对与其目的地属性值对之间的共同计数; 并且具体地根据所计算的同现计数来选择所述第二规则中的一个或多个作为第一规则。

7. 发明授权

US08560570B2 Automated propagation of non-conflicting queries in distributed databases 有权
标题翻译：在分布式数据库中自动传播非冲突查询
公开(公告)号：US08560570B2
公开(公告)日：2013-10-15
申请号：US13364728
申请日：2012-02-02
申请人： Graham A. Bent , Patrick Dantressangle , David R. Vyvyan
发明人： Graham A. Bent , Patrick Dantressangle , David R. Vyvyan
IPC分类号： G06F17/30
CPC分类号： G06F17/30545
摘要： A logical table definition is received as part of a database query within a distributed database system. A determination is made as to whether the received logical table definition matches a local logical table definition. The query is processed in response to determining that the received logical table definition matches the local logical table definition. The query is forwarded to at least one other distributed database node.
摘要翻译：在分布式数据库系统中作为数据库查询的一部分接收逻辑表定义。确定接收到的逻辑表定义是否与本地逻辑表定义相匹配。响应于确定接收到的逻辑表定义与本地逻辑表定义相匹配来处理查询。该查询被转发到至少一个其他分布式数据库节点。

8. 发明授权

US08458166B2 Dynamic context definitions in distributed databases 失效
标题翻译：分布式数据库中的动态上下文定义
公开(公告)号：US08458166B2
公开(公告)日：2013-06-04
申请号：US12248241
申请日：2008-10-09
申请人： Graham A. Bent , Patrick Dantressangle , David R. Vyvyan
发明人： Graham A. Bent , Patrick Dantressangle , David R. Vyvyan
IPC分类号： G06F17/30
CPC分类号： G06F17/30545
摘要： A database query is received including a logical table identifier at a distributed database node within a distributed network of databases. The logical table identifier includes a dynamically-updatable constant column identifier. Local logical table definitions are filtered based upon the logical table identifier and the dynamically-updatable constant column identifier to identify a local logical table associated with the logical table identifier and the dynamically-updatable constant column identifier. A local query response is formed including data retrieved from a local physical database table mapped by the local logical table in response to identifying the local logical table associated with the logical table identifier and the dynamically-updatable constant column identifier. The database query is responded to, in response to forming the local query response, with at least the local query response. This abstract is not to be considered limiting, since other embodiments may deviate from the features described in this abstract.
摘要翻译：在分布式数据库网络中的分布式数据库节点处接收包括逻辑表标识符的数据库查询。逻辑表标识符包括动态可更新的常数列标识符。基于逻辑表标识符和动态可更新的常数列标识符来过滤本地逻辑表定义，以标识与逻辑表标识符和可动态更新的常数列标识符相关联的本地逻辑表。响应于识别与逻辑表标识符和动态可更新的常数列标识符相关联的本地逻辑表，形成本地查询响应，包括从由本地逻辑表映射的本地物理数据库表检索的数据。响应于形成本地查询响应，响应数据库查询至少具有本地查询响应。该摘要不被认为是限制性的，因为其他实施例可能偏离本摘要中描述的特征。

9. 发明授权

US07668805B2 System and method for managing query access to information 有权
标题翻译：用于管理信息查询访问的系统和方法
公开(公告)号：US07668805B2
公开(公告)日：2010-02-23
申请号：US10931535
申请日：2004-09-01
申请人： Paul Miller Bird , Curt Lee Cotner , Patrick Dantressangle
发明人： Paul Miller Bird , Curt Lee Cotner , Patrick Dantressangle
IPC分类号： G06F17/30
CPC分类号： G06F21/6209 , G06F2221/2105 , G06F2221/2141 , Y10S707/99933
摘要： A system, computer usable medium and computer-based method for supporting named memory variables in an information retrieval system including a relational database. PUBLIC and PRIVATE named memory variables can be created, referenced, modified or deleted using SQL statements. The information retrieval system allocates a memory area as a named variable storage space for storing named memory variables. System catalogs may be used for storing information about PUBLIC, SECURE PUBLIC, PRIVATE, SECURE PRIVATE and pre-defined named memory variables. PUBLIC and PRIVATE named memory variables can be used for transferring information between SQL statements of one or more sessions or for retrieving system information from the relational database. Both PUBLIC and PRIVATE types can be defined as SECURE named memory variables requiring specific authorization privileges to read or write to the variable.
摘要翻译：一种用于在包括关系数据库的信息检索系统中支持命名存储器变量的系统，计算机可用介质和基于计算机的方法。可以使用SQL语句创建，引用，修改或删除PUBLIC和PRIVATE命名的内存变量。信息检索系统将存储区域分配为用于存储命名的存储器变量的命名变量存储空间。系统目录可用于存储有关PUBLIC，SECURE PUBLIC，PRIVATE，SECURE PRIVATE和预定义的命名内存变量的信息。 PUBLIC和PRIVATE命名的内存变量可用于在一个或多个会话的SQL语句之间传输信息，或用于从关系数据库检索系统信息。 PUBLIC和PRIVATE类型都可以定义为SECURE命名的内存变量，需要特定的授权权限来读取或写入变量。

10. 发明申请

US20090083379A1 Enabling connections for use with a network 失效
标题翻译：启用与网络一起使用的连接
公开(公告)号：US20090083379A1
公开(公告)日：2009-03-26
申请号：US12101220
申请日：2008-04-11
申请人： Graham A Bent , Flavio A Bergamaschi , Patrick Dantressangle , Christopher Gibson
发明人： Graham A Bent , Flavio A Bergamaschi , Patrick Dantressangle , Christopher Gibson
IPC分类号： G06N5/02 , G06F15/16
CPC分类号： G06N7/005
摘要： An apparatus for enabling connections for use with a network comprising at least one vertex, the apparatus comprising: a receiver, for receiving a first message associated with the first vertex, wherein the first message comprises an indication that the first vertex wishes to join the network; a generator, responsive to receipt of the first message, for generating a second message associated with the at least one vertex, wherein the second message comprising an indication that the at least one vertex is operable to connect to the first vertex; and a probabilistic component for determining a first time value associated with transmission of the second message to the first vertex in accordance with probabilistic data.
摘要翻译：一种用于使能与包括至少一个顶点的网络一起使用的装置，所述装置包括：接收器，用于接收与所述第一顶点相关联的第一消息，其中所述第一消息包括所述第一顶点希望加入所述网络的指示 ; 响应于接收到所述第一消息的发生器，用于生成与所述至少一个顶点相关联的第二消息，其中所述第二消息包括所述至少一个顶点可操作以连接到所述第一顶点的指示; 以及用于根据概率数据确定与第二消息向第一顶点的传输相关联的第一时间值的概率分量。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式