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

1. 发明申请

US20100017429A1 METHOD AND APPARATUS OF DISTRIBUTING DATA IN PARTIONED DATABASES OPERATING ON A SHARED-NOTHING ARCHITECTURE 有权
标题翻译：在无共享架构上运行的分区数据库中分配数据的方法和装置
公开(公告)号：US20100017429A1
公开(公告)日：2010-01-21
申请号：US12175373
申请日：2008-07-17
申请人： Philip S. Cox , Leo Lau , Adil M. Sardar , David Tremaine
发明人： Philip S. Cox , Leo Lau , Adil M. Sardar , David Tremaine
IPC分类号： G06F7/00
CPC分类号： G06F17/30607 , G06F17/30318 , G06F17/30321 , G06F17/30584
摘要： The invention relates to a method and apparatus of distributing data in portioned databases operating on a shared-nothing architecture. The invention provides two independent streams of data, where a first stream sends table data, and the second stream sends LOB data, to a receiving partition. The receiving partition re-couples the LOB data with the table data. Using two independent streams to distribute LOB data can increase data redistribution since large amounts of input/output is not performed to handle the sending of LOB data in a coupled fashion.
摘要翻译：本发明涉及一种在无共享架构上运行的部分数据库中分发数据的方法和装置。本发明提供了两个独立的数据流，其中第一个流发送表数据，第二个流将LOB数据发送到接收分区。接收分区将LOB数据与表数据重新耦合。使用两个独立流来分发LOB数据可以增加数据再分配，因为不执行大量的输入/输出来以耦合的方式处理LOB数据的发送。

2. 发明授权

US07774311B2 Method and apparatus of distributing data in partioned databases operating on a shared-nothing architecture 有权
标题翻译：在无共享架构上运行的分区数据库中分发数据的方法和装置
公开(公告)号：US07774311B2
公开(公告)日：2010-08-10
申请号：US12175373
申请日：2008-07-17
申请人： Philip S. Cox , Leo Lau , Adil M. Sardar , David Tremaine
发明人： Philip S. Cox , Leo Lau , Adil M. Sardar , David Tremaine
IPC分类号： G06F7/00
CPC分类号： G06F17/30607 , G06F17/30318 , G06F17/30321 , G06F17/30584
摘要： The invention relates to a method and apparatus of distributing data in portioned databases operating on a shared-nothing architecture. The invention provides two independent streams of data, where a first stream sends table data, and the second stream sends LOB data, to a receiving partition. The receiving partition re-couples the LOB data with the table data. Using two independent streams to distribute LOB data can increase data redistribution since large amounts of input/output is not performed to handle the sending of LOB data in a coupled fashion.
摘要翻译：本发明涉及一种在无共享架构上运行的部分数据库中分发数据的方法和装置。本发明提供了两个独立的数据流，其中第一个流发送表数据，第二个流将LOB数据发送到接收分区。接收分区将LOB数据与表数据重新耦合。使用两个独立流来分发LOB数据可以增加数据再分配，因为不执行大量的输入/输出来以耦合的方式处理LOB数据的发送。

3. 发明授权

US07769732B2 Apparatus and method for streamlining index updates in a shared-nothing architecture 有权
标题翻译：在无共享架构中简化索引更新的装置和方法
公开(公告)号：US07769732B2
公开(公告)日：2010-08-03
申请号：US11845608
申请日：2007-08-27
申请人： Philip S. Cox , Leo T. M. Lau , Adil M. Sardar , David Tremaine
发明人： Philip S. Cox , Leo T. M. Lau , Adil M. Sardar , David Tremaine
IPC分类号： G06F17/30
CPC分类号： G06F17/30336
摘要： An apparatus and method to streamline updates to an index in a shared-nothing architecture. The apparatus may include an association module, a consolidation module, and a processing module. The association module may associate index update requests with an index. The index update requests may be configured to update the index in response to a redistribution of data in a data table. The consolidation module may compile the index update requests prior to processing and consolidate the index update requests into a smaller number of simplified index update requests to achieve substantially the same result. The processing module may then independently process the simplified index update requests and update the index accordingly.
摘要翻译：一种在无共享架构中简化索引更新的设备和方法。该装置可以包括关联模块，整合模块和处理模块。关联模块可以将索引更新请求与索引相关联。索引更新请求可以被配置为响应于数据表中的数据的再分配来更新索引。合并模块可以在处理之前编译索引更新请求，并将索引更新请求合并到更少数量的简化索引更新请求中以实现基本上相同的结果。然后，处理模块可以独立地处理简化的索引更新请求并相应地更新索引。

4. 发明申请

US20090063589A1 APPARATUS AND METHOD TO DECOUPLE LARGE OBJECT DATA PROCESSING FROM MAIN-LINE DATA PROCESSING IN A SHARED-NOTHING ARCHITECTURE 审中-公开
标题翻译：用于在无共享架构中从主线数据处理中退出大量对象数据处理的装置和方法
公开(公告)号：US20090063589A1
公开(公告)日：2009-03-05
申请号：US11847306
申请日：2007-08-29
申请人： Philip S. Cox , Leo T. M. Lau , Adil M. Sardar , David Tremaine
发明人： Philip S. Cox , Leo T. M. Lau , Adil M. Sardar , David Tremaine
IPC分类号： G06F17/30
CPC分类号： G06F16/24557 , G06F16/24547
摘要： An apparatus and method to to decouple large object (“LOB”) data processing from main-line data processing in a shared-nothing architecture. The method may include relocating rows in a database table from a source partition to a target partition, where each row stores a source descriptor identifying a LOB associated with the row. The source descriptors may be read, and space sufficient to store each LOB in a target repository may be allocated accordingly. Source descriptors may be extracted from the rows, and sorted according to the location of the LOBs in the source repository to provide an ordered retrieval sequence. Each LOB may be retrieved from the source repository according to the retrieval sequence, and stored in its allocated space. The source descriptor stored in each row in the target partition may then be replaced with a target descriptor to identify the location of the respective LOB in the target repository.
摘要翻译：一种用于在无共享架构中将大对象（“LOB”）数据处理与主线数据处理分离的装置和方法。该方法可以包括将数据库表中的行从源分区重新定位到目标分区，其中每行存储标识与该行相关联的LOB的源描述符。可以读取源描述符，并且可以相应地分配足以存储目标存储库中的每个LOB的空间。可以从行中提取源描述符，并根据源存储库中的LOB的位置进行排序以提供有序检索序列。可以根据检索顺序从源存储库检索每个LOB，并存储在其分配的空间中。存储在目标分区中的每行中的源描述符然后可以用目标描述符来替换，以标识目标存储库中相应LOB的位置。

5. 发明申请

US20090063394A1 APPARATUS AND METHOD FOR STREAMLINING INDEX UPDATES IN A SHARED-NOTHING ARCHITECTURE 有权
标题翻译：用于在无共享架构中排列索引更新的装置和方法
公开(公告)号：US20090063394A1
公开(公告)日：2009-03-05
申请号：US11845608
申请日：2007-08-27
申请人： Philip S. Cox , Leo T. M. Lau , Adil M. Sardar , David Tremaine
发明人： Philip S. Cox , Leo T. M. Lau , Adil M. Sardar , David Tremaine
IPC分类号： G06F17/30
CPC分类号： G06F17/30336
摘要： An apparatus and method to streamline updates to an index in a shared-nothing architecture. The apparatus may include an association module, a consolidation module, and a processing module. The association module may associate index update requests with an index. The index update requests may be configured to update the index in response to a redistribution of data in a data table. The consolidation module may compile the index update requests prior to processing and consolidate the index update requests into a smaller number of simplified index update requests to achieve substantially the same result. The processing module may then independently process the simplified index update requests and update the index accordingly.
摘要翻译：一种在无共享架构中简化索引更新的设备和方法。该装置可以包括关联模块，整合模块和处理模块。关联模块可以将索引更新请求与索引相关联。索引更新请求可以被配置为响应于数据表中的数据的再分配来更新索引。合并模块可以在处理之前编译索引更新请求，并将索引更新请求合并到更少数量的简化索引更新请求中以实现基本上相同的结果。然后，处理模块可以独立地处理简化的索引更新请求并相应地更新索引。

6. 发明申请

US20110289061A1 REDISTRIBUTE NATIVE XML INDEX KEY SHIPPING 失效
标题翻译： REDISTRIBUTE原始XML索引关键运输
公开(公告)号：US20110289061A1
公开(公告)日：2011-11-24
申请号：US13074747
申请日：2011-03-29
申请人： Ivan Lew , Aleksandrs Santars , Adil M. Sardar , David Tremaine
发明人： Ivan Lew , Aleksandrs Santars , Adil M. Sardar , David Tremaine
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F17/30336
摘要： Techniques are described for data redistribution in a database system. Embodiments store a first set of receiver location identifiers mapped to a document identifier, the first set of receiver location identifiers assigned to a first set of receiver locations storing relational data referencing the document identifier. Embodiments further store a second set of receiver location identifiers mapped to the document identifier, the second set of receiver location identifiers assigned to a second set of receiver locations storing document data corresponding to the document identifier referenced by the relational data. Sender index keys are received separately from the relational data and the document data, the sender index keys referencing the document identifier and containing sender location identifiers. Embodiments determine, from the first set of receiver location identifiers and the second set of receiver location identifiers, which receiver location identifiers are mapped to the document identifier referenced by the sender index keys. The sender location identifiers are then replaced with the determined receiver location identifiers.
摘要翻译：描述了数据库系统中数据重新分配的技术。实施例存储映射到文档标识符的第一组接收器位置标识符，第一组接收器位置标识符被分配给存储参考文档标识符的关系数据的第一组接收器位置。实施例还存储映射到文档标识符的第二组接收器位置标识符，第二组接收器位置标识符分配给存储与关系数据引用的文档标识符相对应的文档数据的第二组接收器位置。发送方索引关键字与关系数据和文档数据分开接收，发送方索引键引用文档标识符并包含发件人位置标识符。实施例从第一组接收器位置标识符和第二组接收器位置标识符确定哪些接收器位置标识符被映射到由发送器索引键引用的文档标识符。发送方位置标识符随后被确定的接收方位置标识符替换。

7. 发明授权

US08543600B2 Redistribute native XML index key shipping 失效
标题翻译：重新分发本地XML索引键发货
公开(公告)号：US08543600B2
公开(公告)日：2013-09-24
申请号：US13074747
申请日：2011-03-29
申请人： Ivan Lew , Aleksandrs Santars , Adil M. Sardar , David Tremaine
发明人： Ivan Lew , Aleksandrs Santars , Adil M. Sardar , David Tremaine
IPC分类号： G06F17/00
CPC分类号： G06F17/30336
摘要： Techniques are described for data redistribution in a database system. Embodiments store a first set of receiver location identifiers mapped to a document identifier, the first set of receiver location identifiers assigned to a first set of receiver locations storing relational data referencing the document identifier. Embodiments further store a second set of receiver location identifiers mapped to the document identifier, the second set of receiver location identifiers assigned to a second set of receiver locations storing document data corresponding to the document identifier referenced by the relational data. Sender index keys are received separately from the relational data and the document data, the sender index keys referencing the document identifier and containing sender location identifiers. Embodiments determine, from the first set of receiver location identifiers and the second set of receiver location identifiers, which receiver location identifiers are mapped to the document identifier referenced by the sender index keys. The sender location identifiers are then replaced with the determined receiver location identifiers.
摘要翻译：描述了数据库系统中数据重新分配的技术。实施例存储映射到文档标识符的第一组接收器位置标识符，第一组接收器位置标识符被分配给存储参考文档标识符的关系数据的第一组接收器位置。实施例还存储映射到文档标识符的第二组接收器位置标识符，第二组接收器位置标识符被分配给存储与关系数据引用的文档标识符相对应的文档数据的第二组接收器位置。发送方索引关键字与关系数据和文档数据分开接收，发送方索引键引用文档标识符并包含发件人位置标识符。实施例从第一组接收器位置标识符和第二组接收器位置标识符确定哪些接收器位置标识符被映射到由发送器索引键引用的文档标识符。发送方位置标识符随后被确定的接收方位置标识符替换。

8. 发明授权

US07523088B2 Method for increasing system resource availability in database management systems 有权
标题翻译：在数据库管理系统中增加系统资源可用性的方法
公开(公告)号：US07523088B2
公开(公告)日：2009-04-21
申请号：US10816540
申请日：2004-03-31
申请人： Leo Tat Man Lau , Marko Milek , Adil M. Sardar
发明人： Leo Tat Man Lau , Marko Milek , Adil M. Sardar
IPC分类号： G06F7/00
CPC分类号： G06F17/30362 , G06F17/30371 , Y10S707/99931 , Y10S707/99938
摘要： A transactional database server is accessible by applications. Applications indicate whether access is made using an online protocol. Where the database server determines that a request received from an application is made using the online protocol, the server will return one of a set of defined error codes upon identified system resources being determined to be scarce. Applications monitor responses from the database server for the defined error codes. On receipt of one of the defined error codes an application will issue a commit to the database server to attempt to release system resources for use by applications.
摘要翻译：应用程序可访问事务数据库服务器。应用程序指示是否使用在线协议进行访问。在数据库服务器确定使用在线协议进行从应用程序接收到的请求的情况下，服务器将在所确定的系统资源被确定为稀缺时返回一组定义的错误代码中的一个。应用程序监视数据库服务器对定义的错误代码的响应。在收到定义的错误代码之一后，应用程序将向数据库服务器发出提交，以尝试释放系统资源供应用程序使用。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式